comparison test/test_anydbm.py @ 6814:3f60a71b0812

Summary: Support selecion session/otk data store. Add redis as data store. Allow admin to select the backend data store. Compatibility matrix: main\/ session>| anydbm | sqlite | redis | mysql | postgresql | anydbm | D | | X | | | sqlite | X | D | X | | | mysql | | | | D | | postgresql | | | | | D | --------------------------------------------------------------+ D - default if unconfigured, X - compatible choice DETAILS roundup/configuration.py: add config.ini section sessiondb with settings: backend and redis_url. CHANGES.txt, doc/admin_guide.txt, doc/installation.txt, doc/upgrading.txt: doc on config of session db and redis. Plus some other fixes: admin - clarified why we do not drop __words and __testids table in native-fts conversion. TYpo fix. upgrading - doc how you can keep using anydbm for session data with sqlite. Fix dupe sentence in an upgrading config.ini section. roundup/backends/back_anydbm.py, roundup/backends/back_sqlite.py: code to support redis, redis/anydbm backends respectively. roundup/backends/sessions_redis.py new storage backend for redis. roundup/rest.py, roundup/cgi/actions.py, roundup/cgi/templating.py redis uses a different way of calculating lifetime/timestamp. Since expiration of an item occurred if its timestamp was more than 1 week old, code would calculate: now - 1 week + lifetime. But this results in faster expiration in redis if used for lifetime/timestamp. Convert code to use the lifetime() method in BasicDatabase that generates the right timestamp for each backend. test/session_common.py: added tests for more cases, get without default, getall non-existing key etc. timestamp test changed to use new self.get_ts which is overridden in other tests. Test that datatypes survive storage. test/test_redis_session.py: test redis session store with sqlite and anydbm primary databases test/test_anydbm.py, test/test_sqlite.py add test to make sure the databases are properly set up sqlite - add test cases where anydbm is used as datastore anydbm - remove updateTimestamp override add get_ts(). test/test_config.py tests on redis_url and compatibility on choice of sessiondb backend .travis.yml: add redis db and redis-py
author John Rouillard <rouilj@ieee.org>
date Thu, 04 Aug 2022 14:41:58 -0400
parents bdd28b244839
children
comparison
equal deleted inserted replaced
6813:6b636fb29740 6814:3f60a71b0812
53 53
54 from .session_common import SessionTest 54 from .session_common import SessionTest
55 class anydbmSessionTest(anydbmOpener, SessionTest, unittest.TestCase): 55 class anydbmSessionTest(anydbmOpener, SessionTest, unittest.TestCase):
56 s2b = lambda x,y: strings.s2b(y) 56 s2b = lambda x,y: strings.s2b(y)
57 57
58 # this only works for dbm. other backends don't change the __timestamp 58 def get_ts(self):
59 # value, they have a separate column for the timestamp so they can 59 return (self.sessions.get('random_session', '__timestamp'),)
60 # update it with SQL.
61 def testUpdateTimestamp(self):
62 # make sure timestamp is older than one minute so update will work
63 timestamp = time.time() - 62
64 self.sessions.set('random_session', text='hello, world!',
65 __timestamp=timestamp)
66 self.sessions.updateTimestamp('random_session')
67 self.assertNotEqual (self.sessions.get('random_session',
68 '__timestamp'),
69 timestamp)
70 60
61 def testDbType(self):
62 self.assertIn("back_anydbm", repr(self.db))
63 self.assertIn("roundup.backends.sessions_dbm.Sessions", repr(self.db.Session))
64
71 class anydbmSpecialActionTestCase(anydbmOpener, SpecialActionTest, 65 class anydbmSpecialActionTestCase(anydbmOpener, SpecialActionTest,
72 unittest.TestCase): 66 unittest.TestCase):
73 backend = 'anydbm' 67 backend = 'anydbm'
74 68
75 class anydbmRestTest (RestTestCase, unittest.TestCase): 69 class anydbmRestTest (RestTestCase, unittest.TestCase):

Roundup Issue Tracker: http://roundup-tracker.org/