http://hg.code.sf.net:8000/p/roundup/code/atom-log/tip/test/test_mysql.py 2023-03-02T17:01:39-05:00 http://hg.code.sf.net:8000/p/roundup/code/#changeset-521d98231e5c07f2e465f8da998d489aa655a37c John Rouillard rouilj@ieee.org 2023-03-02T17:01:39-05:00 2023-03-02T17:01:39-05:00

changeset	521d98231e5c
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Test self.db.db_version_updated in schema upgrade paths A user on the roundup-users mailing list reported that a 'roundup-admin migrate' reported that changes were needed. But it should have done the migration. roundup-admin uses the property db.db_version_updated to tell if there was a migration. Testing never looked at that property. Add a test for that property in all migration updates. AFAICT the test is always successful. So no bug uncovered by these tests.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-bdd28b244839c257336c4eefc7ba45593437d1d3 John Rouillard rouilj@ieee.org 2022-07-25T17:20:20-04:00 2022-07-25T17:20:20-04:00

changeset	bdd28b244839
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	- issue2551223 - fix timestamp truncation in mysql and postgresql The data types used to represent timestamps in pg and mysql for ephemeral tables: sessions and otks don't have enough signifcant digits to work. As a result the timestamps are rounduped (up/down) rsuling in the stored timestamp being 2 minutes (pg) or 2-3 hours(mysql) off from what it should be. Modify db schema to use a numeric type that preserves more significant figures. Implement schema upgrade. Document need for upgrade in upgrading.txt. Write tests for schema upgrade. Implement test for updateTimestamp method on BasicDatabase that showed this issue in the first place. Write overrides for test for anydbm/memorydb which store timestamp properly or not at all.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-09d9c646ca891c4f2454c76e7460445edc43e05e John Rouillard rouilj@ieee.org 2022-07-25T16:39:31-04:00 2022-07-25T16:39:31-04:00

changeset	09d9c646ca89
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Put in missing s2b needed for session list test.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-0d99ae7c8de62fdc4561e7f0a8a6b38da86e34cd John Rouillard rouilj@ieee.org 2022-01-27T19:48:48-05:00 2022-01-27T19:48:48-05:00

changeset	0d99ae7c8de6
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Allow Roundup to use PostgreSQL database native full text search back_postgreql.py - schema version changes for schema version 7. configuration.py - added indexer_language checks for postgresql. Hardcoded list for now. Docs admin_guide and upgrading Tests. This also restructures the version upgrade tests for the rdbms backends. They can run all of them now as the proper cascade is developed to roll back changes to version 6.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-39189dd94f2cc9d0b460685b20b3fc077d59f7ec John Rouillard rouilj@ieee.org 2022-01-26T15:04:09-05:00 2022-01-26T15:04:09-05:00

changeset	39189dd94f2c
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	issue2551189 - increase size of words in full text index. Increased indexed word maxlength to 50 DB migration code is written and tests work. Restructured some tests to allow for code reuse. Docs. If this passes CI without errors 2551189 should be done. However, testing on my system generates errors. Encoding (indexer unicode russian unicode string invalid) and collation errors (utf8_bin not valid) when running under python2. No issues with python3 and I haven't changed code that should cause these since the last successful build in CI. So if this fails in CI we will have more checkins.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-778a9f45506769b8bf5cad1322c3fc3500a4c1d8 John Rouillard rouilj@ieee.org 2020-12-20T15:43:07-05:00 2020-12-20T15:43:07-05:00

changeset	778a9f455067
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	Remove old code import imp, old style trackers db/backend_name Module imp is depricated. Removing that means rewriting old style trackers that used imp to load schema and config files. So removed code supporting old style trackers that have been depricated since 2008. Added test to verify that existence of dbinit.py triggers alert that tracker is old style and not supported. Also remove support for depricated db/backend_name file for specifying backend. It is now specified in config.ini's [rdbms] backend. It looks like not specifying an [rdbms] backend key in config.ini throws a config error. However I left in a check and throw an exception with details if there is an empty backend value. But I don't think it will ever be triggered. Removed unused import of imp in a number of test files.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-6b4857686365255a0014f931ea48d9ae22e13a3b John Rouillard rouilj@ieee.org 2019-10-12T21:40:18-04:00 2019-10-12T21:40:18-04:00

changeset	6b4857686365
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	revert code to try to debug issue2551025
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-8814d1d5cb4ee2b5869f92b254403ac29e3b705c John Rouillard rouilj@ieee.org 2019-10-12T21:17:38-04:00 2019-10-12T21:17:38-04:00

changeset	8814d1d5cb4e
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	issue2551025- mysql failure with 1.3.14 mysqlclient. fix mixed tab/space
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-c840e8a571d3add3c935319ec972f00cf4da6903 John Rouillard rouilj@ieee.org 2019-10-12T21:05:50-04:00 2019-10-12T21:05:50-04:00

changeset	c840e8a571d3
branch
bookmark
tag
user	John Rouillard <rouilj@ieee.org>
description	issue2551025- mysql failure with 1.3.14 mysqlclient. Do we have a double close error here?
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-fcbeff272828220b7566ee26a15ba1e5acd77121 Ralf Schlatterbeck rsc@runtux.com 2019-01-30T13:58:14+01:00 2019-01-30T13:58:14+01:00

changeset	fcbeff272828
branch	REST-rebased
bookmark
tag
user	Ralf Schlatterbeck <rsc@runtux.com>
description	Integrate REST tests into db framework
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-d26921b851c328681aa6638475ce2cdae29963b4 Joseph Myers jsm@polyomino.org.uk 2018-07-24T22:22:08+00:00 2018-07-24T22:22:08+00:00

changeset	d26921b851c3
branch
bookmark
tag
user	Joseph Myers <jsm@polyomino.org.uk>
description	Python 3 preparation: make relative imports explicit. Tool-generated patch.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-62de601bdf6fd224fead26c33b585af5a05e7d80 Ralf Schlatterbeck rsc@runtux.com 2018-04-20T18:46:28+02:00 2018-04-20T18:46:28+02:00

changeset	62de601bdf6f
branch
bookmark
tag
user	Ralf Schlatterbeck <rsc@runtux.com>
description	Fix commits although a Reject exception is raised Fix the problem that changes are committed to the database (due to commits to otk handling) even when a Reject exception occurs. The fix implements separate database connections for otk/session handling and normal database operation.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-efb34cbdba7c2610de41c0e4241f6a388ebb3329 Ralf Schlatterbeck rsc@runtux.com 2017-11-06T09:26:59+01:00 2017-11-06T09:26:59+01:00

changeset	efb34cbdba7c
branch
bookmark
tag
user	Ralf Schlatterbeck <rsc@runtux.com>
description	Add (currently failing) test for atomic actions Actions via the web-interface can have several database-modifying instructions. These should be atomic, i.e., either all should go in or none. This is currently not the case due to commit calls from OTK handling (CSRF-protection).
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-43a1f7fe39f502d3dc1ba5c560a81a629c924619 John Kristensen john@jerrykan.com 2016-06-28T15:39:38+10:00 2016-06-28T15:39:38+10:00

changeset	43a1f7fe39f5
branch
bookmark
tag
user	John Kristensen <john@jerrykan.com>
description	Improved work-around for pytest markers bug The previous fix was only a partial solution. Any test class sharing a parent with, and appearing after, a skipped test class was being skipped (not just other test classes using the skip/skipif marker). Now only tests that should be skipped will be skipped, the rest should run as normal.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-37d1e24fb941044d39cfdd59449155eeee154b65 John Kristensen john@jerrykan.com 2016-06-27T14:03:32+10:00 2016-06-27T14:03:32+10:00

changeset	37d1e24fb941
branch
bookmark
tag
user	John Kristensen <john@jerrykan.com>
description	Fix work-around for pytest markers bug The initial work-around implemented was totally botched using 'pytest.skip' instead of 'pytest.mark.skip' which resulted in all tests in a file being completely ignored if any skip conditions that evaluated to true were declared or imported in the file. This work-around will not correctly display why all the tests have been skipped when using the '-rs' parameter. Only the first skip marker to taint a parent test class will be displayed (ie. if both xapian and mysql tests are being skipped, pytest will only output that tests are being skipped because xapian is not installed even though the mysql tests are also being skipped because mysql backend is not available). There also seems to be a bug in the current version of pytest being used in 'run_tests.py' (v2.8.4) that results in the skip not actually working when using 'pytest.mark.skip'. This does work correctly with the most recent release (v2.9.2), so the 'run_tests.py' script will need to be updated.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-c977f3530944c9adf85594092b8caff9c13889fd John Kristensen john@jerrykan.com 2015-09-07T23:24:33+10:00 2015-09-07T23:24:33+10:00

changeset	c977f3530944
branch
bookmark
tag
user	John Kristensen <john@jerrykan.com>
description	Work-around for pytest.mark.skipif() bug There is a pytest bug that can cause all test classes marked with the skipif() decorator that inherit a common class to be skipped if one of the skipif() conditions is True. See: https://github.com/pytest-dev/pytest/issues/568
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-364c549918613cff81c3ebe07aee4025e0ef3fcc John Kristensen john@jerrykan.com 2015-08-21T13:08:02+10:00 2015-08-21T13:08:02+10:00

changeset	364c54991861
branch
bookmark
tag
user	John Kristensen <john@jerrykan.com>
description	Remove unneeded TestSuite code from tests The TestSuite code is no longer needed now that we are using py.test which can automatically discover tests
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-380d8d8b30a3b0dca517fb242809703963a00588 John Kristensen john@jerrykan.com 2015-08-20T18:15:23+10:00 2015-08-20T18:15:23+10:00

changeset	380d8d8b30a3
branch
bookmark
tag
user	John Kristensen <john@jerrykan.com>
description	Replace existing run_tests.py script with a pytest script The existing run_test.py script is quite old, a bit restrictive, and doesn't always behave as documented. The pytest testing tool is mature, well documented, and maintained. The run_tests.py script is generating by installing py.test and running: py.tests --genscript=run_tests.py Note: to generate a script that is compatible with python2.6 the command needs to be run using python2.6
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-63c79c0992aeb805fbed74a82881d2eb32bbb70d John Kristensen john@jerrykan.com 2015-08-20T14:44:49+10:00 2015-08-20T14:44:49+10:00

changeset	63c79c0992ae
branch
bookmark
tag
user	John Kristensen <john@jerrykan.com>
description	Update tests to work with py.test py.test searches for any class that looks like a TestCase in the test directory and tries to run them as tests. Some of the classes that inherit TestCase are not meant to be run and are only intended to be "helper classes". Only the tests of the classes that inherit the "helper classes" should be run. If we convert these "helper classes" to be "mixins" py.test should not pick them up.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f6e76a03b502d3e331cc7d888fbc70c3afea18b8 Ralf Schlatterbeck rsc@runtux.com 2014-03-29T10:52:20+01:00 2014-03-29T10:52:20+01:00

changeset	f6e76a03b502
branch
bookmark
tag
user	Ralf Schlatterbeck <rsc@runtux.com>
description	HTML* classes for cgi are now all new-style Add regression test for old behaviour: Lookup of a value of a HTMLProperty was possibly via getitem -- for old-style classes this worked because __getattr__ returned the __getitem__ of a newly created HTMLItem object, this does no longer work for new-style classes as these look up special method only on the class not the instance.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-6e3e4f24c75376f61ae0bf0e9ee334567585c38e Eric S. Raymond esr@thyrsus.com 2011-11-16T09:51:38-05:00 2011-11-16T09:51:38-05:00

changeset	6e3e4f24c753
branch
bookmark
tag
user	Eric S. Raymond <esr@thyrsus.com>
description	Remove keyword expansions from CVS. All regression tests passed afterwards.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-34dce76bb202fab5fbf9685444ad856ee04b6178 Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2011-03-21T20:44:39+00:00 2011-03-21T20:44:39+00:00

changeset	34dce76bb202
branch
bookmark
tag
user	Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description	Multilink fixes and optimizations: - Optimisation: Late evaluation of Multilinks (only in rdbms backends): previously we materialized each multilink in a Node -- this creates an SQL query for each multilink (e.g. 'files' and 'messages' for each line in the issue index display) -- even if the multilinks aren't displayed. Now we compute multilinks only if they're accessed (and keep them cached). - Add a filter_iter similar to the existing filter call. This feature is considered experimental. This is currently not used in the web-interface but passes all tests for the filter call except sorting by Multilinks (which isn't supported by SQL and isn't a sane concept anyway). When using filter_iter instead of filter this saves a *lot* of SQL queries: Filter returns only the IDs of Nodes in the database, the additional content of a Node has to be fetched in a separate SQL call. The new filter_iter also returns the IDs of Nodes (one by one, it's an iterator) but pre-seeds the cache with the content of the Node. The information needed for seeding the cache is retrieved in the same SQL query as the ids.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-2784c239e6c81a46684e200e95181d67243ba1b8 Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2010-10-22T14:14:26+00:00 2010-10-22T14:14:26+00:00

changeset	2784c239e6c8
branch
bookmark
tag
user	Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description	clear the cache on commit for rdbms backends: Don't carry over cached values from one transaction to the next (there may be other changes from other transactions) see new ConcurrentDBTest for a read-modify-update cycle that fails with the old caching behavior.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-2eae5848912d633161017e4fd8c4b1170193181a Richard Jones richard@users.sourceforge.net 2004-11-10T22:22:59+00:00 2004-11-10T22:22:59+00:00

changeset	2eae5848912d
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	always honor indexme property on Strings (patch [SF#063711])
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-adec352e2ce05c53bc62d77df81b56e4fa61a63c Richard Jones richard@users.sourceforge.net 2004-11-03T01:34:21+00:00 2004-11-03T01:34:21+00:00

changeset	adec352e2ce0
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	don't try to import all backends in backends.__init__ unless we *want* to
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-6ca9017b6f07b10daba0c9ed9505121b75d9f24f Alexander Smishlajev a1s@users.sourceforge.net 2004-10-01T09:04:13+00:00 2004-10-01T09:04:13+00:00

changeset	6ca9017b6f07
branch	maint-0.7
bookmark
tag
user	Alexander Smishlajev <a1s@users.sourceforge.net>
description	connection availability check merged from HEAD
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-91fdaaf8d929ddee1bf3b480d4c0f58b3de25dcc Alexander Smishlajev a1s@users.sourceforge.net 2004-09-26T15:18:28+00:00 2004-09-26T15:18:28+00:00

changeset	91fdaaf8d929
branch
bookmark
tag
user	Alexander Smishlajev <a1s@users.sourceforge.net>
description	use mysql.db_exists() instead of mysql.Database to test connection availability: mysql.Database requires existing roundup database to connect.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-09651970063b808ec2f0e7a9ca162ba24c3477f1 Alexander Smishlajev a1s@users.sourceforge.net 2004-09-26T11:30:56+00:00 2004-09-26T11:30:56+00:00

changeset	09651970063b
branch
bookmark
tag
user	Alexander Smishlajev <a1s@users.sourceforge.net>
description	skip mysql backend tests on any MySQL error... ...raised from Database instantiation. (if the server is not available, MySQLdb raises OperationalError, not ProgrammingError.)
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-1a335e3c958968a7b238da25379cc541c74d66cc Alexander Smishlajev a1s@users.sourceforge.net 2004-09-25T15:49:31+00:00 2004-09-25T15:49:31+00:00

changeset	1a335e3c9589
branch
bookmark
tag
user	Alexander Smishlajev <a1s@users.sourceforge.net>
description	rdbms settings are now common for all backends. remove old MySQL-specific settings (not allowed by new config). add vim modeline.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-351304739aae3a103d0945ce0e303c0822580f18 Richard Jones richard@users.sourceforge.net 2004-05-23T09:44:47+00:00 2004-05-23T09:44:47+00:00

changeset	351304739aae
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	simpler RDBMS unit test config
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-b7404a96b58ac74bad85c1c1940f5e4a46b2e8ef Richard Jones richard@users.sourceforge.net 2004-03-24T06:18:59+00:00 2004-03-24T06:18:59+00:00

changeset	b7404a96b58a
branch
bookmark
tag	0.7.0b1
user	Richard Jones <richard@users.sourceforge.net>
description	minor pre-release / test fixes
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-c091cacdc505c94fed0c4fddba142d9646f96214 Richard Jones richard@users.sourceforge.net 2004-03-18T01:58:46+00:00 2004-03-18T01:58:46+00:00

changeset	c091cacdc505
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	Finished implementation of session and one-time-key stores for RDBMS backends. Refactored the API of sessions and their interaction with the backend database a fair bit too. Added some session tests. Nothing testing ageing yet, 'cos that's a pain inna ass to test :) Note: metakit backend still uses the *dbm implementation. It might want to implement its own session store some day, as it'll be faster than the *dbm one.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-b1704ba7be41e73ebbe4b8baea54709997e3a2dc Richard Jones richard@users.sourceforge.net 2004-03-12T04:09:00+00:00 2004-03-12T04:09:00+00:00

changeset	b1704ba7be41
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	make mysql / postgresql work again. beginnings of otk/session store in rdbmses
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f9316d2cd5ba6dab9a51ea45ff3e6b55f3faba0c Richard Jones richard@users.sourceforge.net 2003-11-14T00:11:19+00:00 2003-11-14T00:11:19+00:00

changeset	f9316d2cd5ba
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	Fixed retirement of items in rdbms imports [SF#841355] Fixed bug in looking up journal of newly-created items in *dbm backends
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f255363e6d976d4a92190c19619fc47188c9d2f3 Richard Jones richard@users.sourceforge.net 2003-11-11T11:19:18+00:00 2003-11-11T11:19:18+00:00

changeset	f255363e6d97
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	PostgreSQL backend lands. - that's the postgresql backend in (cleaned up doc, unit testing harness and the backend module itself) - also cleaned up the index maintenance code (actual checks for existence rather than bare-except failure mode)
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f3d25c5129315f16a96f0444a323041a09be540f Johannes Gijsbers jlgijsbers@users.sourceforge.net 2003-11-05T21:54:57+00:00 2003-11-05T21:54:57+00:00

changeset	f3d25c512931
branch
bookmark
tag
user	Johannes Gijsbers <jlgijsbers@users.sourceforge.net>
description	Remove duplication: use a 'extra_config' attribute which is appended to the config file for testCreation.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-043e1b699047ebfeaa15fd781886334dbbeec3f1 Richard Jones richard@users.sourceforge.net 2003-11-02T08:44:17+00:00 2003-11-02T08:44:17+00:00

changeset	043e1b699047
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	more unit test work
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-be9b87ad711b1c2cd61f88de453432f7dc7bc62e Johannes Gijsbers jlgijsbers@users.sourceforge.net 2003-10-26T14:13:04+00:00 2003-10-26T14:13:04+00:00

changeset	be9b87ad711b
branch
bookmark
tag
user	Johannes Gijsbers <jlgijsbers@users.sourceforge.net>
description	Add hasattr() check for backend in mysqlOpener.
files

http://hg.code.sf.net:8000/p/roundup/code/#changeset-f63aa57386b0b2c50eb311d6b407a12e9b5e45db Richard Jones richard@users.sourceforge.net 2003-10-25T22:53:26+00:00 2003-10-25T22:53:26+00:00

changeset	f63aa57386b0
branch
bookmark
tag
user	Richard Jones <richard@users.sourceforge.net>
description	Backend improvements. - using Zope3's test runner now, allowing GC checks, nicer controls and coverage analysis - all RDMBS backends now have indexes on several columns - added testing of schema mutation, fixed rdbms backends handling of a couple of cases - !BETA! added postgresql backend, needs work !BETA!
files