Mercurial Repository: p/roundup/code: test/db_test

comparison test/db_test_base.py @ 3826:bf2e9535da00

Journal and database testing. - Add to Import/Export test to also test that journals are correctly retrieved - Fix a bug in anydbm backend that didn't export journal 'set' actions where the previous value was None -- all other backends export them correctly so I consider this a bug of anydbm - Fix journal import/export of Date and Interval for metakit - Fix journal import of Password for metakit - Fix setting of Password oldvalue for metakit -- this would be written as the string "None" instead of the value None. Note that existing databases *will* have wrong log-entries. Since this is only for passwords -- and old passwords aren't of much importance -- I consider this fix to be enough... This fix makes the Journal import/export test run for metakit.

author	Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
date	Wed, 14 Mar 2007 15:23:11 +0000
parents	2a60b68985db
children	cf8b716d9ac2

comparison

equal deleted inserted replaced

-:f5bb1ad47268
+:bf2e9535da00
 # BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
 # FOR A PARTICULAR PURPOSE.  THE CODE PROVIDED HEREUNDER IS ON AN "AS IS"
 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE,
 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 #
-# $Id: db_test_base.py,v 1.83 2007-03-09 10:25:10 schlatterbeck Exp $
+# $Id: db_test_base.py,v 1.84 2007-03-14 15:23:11 schlatterbeck Exp $
 import unittest, os, shutil, errno, imp, sys, time, pprint, sets
 from roundup.hyperdb import String, Password, Link, Multilink, Date, \
 Interval, DatabaseError, Boolean, Number, Node
 # XXX add sorting tests for other types
 def testImportExport(self):
 # use the filtering setup to create a bunch of items
 ae, filt = self.filteringSetup()
+# Get some stuff into the journal for testing import/export of
+# journal data:
+self.db.user.set('4', password = password.Password('xyzzy'))
+self.db.user.set('4', age = 3)
+self.db.user.set('4', assignable = True)
+self.db.issue.set('1', title = 'i1', status = '3')
+self.db.issue.set('1', deadline = date.Date('2007'))
+self.db.issue.set('1', foo = date.Interval('1:20'))
+p = self.db.priority.create(name = 'some_prio_without_order')
+self.db.commit()
+self.db.user.set('4', password = password.Password('123xyzzy'))
+self.db.user.set('4', assignable = False)
+self.db.priority.set(p, order = '4711')
+self.db.commit()
 self.db.user.retire('3')
 self.db.issue.retire('2')
 # grab snapshot of the current database
 orig = {}
+origj = {}
 for cn,klass in self.db.classes.items():
 cl = orig[cn] = {}
+jn = origj[cn] = {}
 for id in klass.list():
 it = cl[id] = {}
+jn[id] = self.db.getjournal(cn, id)
 for name in klass.getprops().keys():
 it[name] = klass.get(id, name)
 os.mkdir('_test_export')
 try:
 if hasattr(klass, 'import_files'):
 klass.import_files('_test_export', str(id))
 maxid = max(maxid, id)
 self.db.setid(cn, str(maxid+1))
 klass.import_journals(journals[cn])
+# This is needed, otherwise journals won't be there for anydbm
+self.db.commit()
 finally:
 shutil.rmtree('_test_export')
 # compare with snapshot of the database
-for cn, items in orig.items():
+for cn, items in orig.iteritems():
 klass = self.db.classes[cn]
 propdefs = klass.getprops(1)
 # ensure retired items are retired :)
 l = items.keys(); l.sort()
 m = klass.list(); m.sort()
 except AssertionError:
 if not isinstance(propdefs[name], Date):
 raise
 # don't get hung up on rounding errors
 assert not l.__cmp__(value, int_seconds=1)
+for jc, items in origj.iteritems():
+for id, oj in items.iteritems():
+rj = self.db.getjournal(jc, id)
+# Both mysql and postgresql have some minor issues with
+# rounded seconds on export/import, so we compare only
+# the integer part.
+for j in oj:
+j[1].second = float(int(j[1].second))
+for j in rj:
+j[1].second = float(int(j[1].second))
+oj.sort()
+rj.sort()
+ae(oj, rj)
 # make sure the retired items are actually imported
 ae(self.db.user.get('4', 'username'), 'blop')
 ae(self.db.issue.get('2', 'title'), 'issue two')

Mercurial > p > roundup > code

comparison test/db_test_base.py @ 3826:bf2e9535da00