http://hg.code.sf.net:8000/p/roundup/code/atom-log/tip/roundup/backends/back_sqlite.py Mercurial Repository: p/roundup/code: roundup/backends/back_sqlite.py history 2024-07-13T18:52:55-04:00 issue2551343 - Remove support for PySQLite and sqlite v2. http://hg.code.sf.net:8000/p/roundup/code/#changeset-95f91b6f0386817e952300dafa4ed65418ffce7b John Rouillard rouilj@ieee.org 2024-07-13T18:52:55-04:00 2024-07-13T18:52:55-04:00
changeset 95f91b6f0386
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2551343 - Remove support for PySQLite and sqlite v2.

It is unmaintained and sqlite3 is used which is the default for a
Python distribution.
files
issue2551302 - Remove support for sqlite version 1 from back_sqlite.py http://hg.code.sf.net:8000/p/roundup/code/#changeset-e3975f679bf17e1fdcf5df649bd0358494eaab2d John Rouillard rouilj@ieee.org 2024-04-30T22:16:22-04:00 2024-04-30T22:16:22-04:00
changeset e3975f679bf1
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2551302 - Remove support for sqlite version 1 from back_sqlite.py

Remove sqlite v1 support and document.
files
fix: diagnose/report use of SQLite without FTS5 support http://hg.code.sf.net:8000/p/roundup/code/#changeset-e10d0b262abd048ff49b54194732f2978f6a8821 John Rouillard rouilj@ieee.org 2023-11-12T19:35:07-05:00 2023-11-12T19:35:07-05:00
changeset e10d0b262abd
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description fix: diagnose/report use of SQLite without FTS5 support

As of 2.2.0 Roundup requires FTS5 support in SQLite. FTS5 has been part
of the main SQLite distribution since October 2015.

Tonu Mikk found this when trying to run 2.3.0 under RedHat 7.
He got a traceback when trying to spin up 2.3.0. It took us a bit to
figure out that FTS5 was missing from the SQLite library used by
Python3. See: https://sourceforge.net/p/roundup/mailman/message/51783129/

This change catches the sql error and checks to see if the ENABLE_FTS5
compile option is defined. If not it raises NotImplementedError with a
more useful error message and reports the version of SQLite in use.

This will at least ease diagnosis.

Trying to support SQLite without FTS5 support raises a number of
issues including tracking the internal schema used by Roundup.
So not going to attempt that.

Details: https://sourceforge.net/p/roundup/mailman/message/51783321/
files
fix comment on use of sqlite for session db's. http://hg.code.sf.net:8000/p/roundup/code/#changeset-e138f5cf432a6f5558b6be6446e7d7d96238cd46 John Rouillard rouilj@ieee.org 2022-09-08T02:14:11-04:00 2022-09-08T02:14:11-04:00
changeset e138f5cf432a
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description fix comment on use of sqlite for session db's.
files
flake8 fixes. http://hg.code.sf.net:8000/p/roundup/code/#changeset-ff7f6c0bbdae7da2db92cbc482dd04647f0e1661 John Rouillard rouilj@ieee.org 2022-09-08T01:23:27-04:00 2022-09-08T01:23:27-04:00
changeset ff7f6c0bbdae
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description flake8 fixes.
files
Set all sqlite db's to WAL mode on creation http://hg.code.sf.net:8000/p/roundup/code/#changeset-a96a239db0d9cfc7b55e4eccd13ef30a720417d9 John Rouillard rouilj@ieee.org 2022-09-08T01:12:12-04:00 2022-09-08T01:12:12-04:00
changeset a96a239db0d9
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Set all sqlite db's to WAL mode on creation

Complete work done on 6917:fba76e0bba98.

WAL journaling mode now enabled on primary db as well as session db's
when using sqlite for session databases.

Made change to WAL mode more robust for testing by bracketing
`pragma journal_mode=wal` with commit() calls. Normally the conversion
would occur when a new session was opened, but this commits the changes
explicitly to make all the tests stable.

Also added doc on this.
files
set journal mode to wal when creating db. http://hg.code.sf.net:8000/p/roundup/code/#changeset-fba76e0bba98db96b1ffec3b9341fd6fbcb953df John Rouillard rouilj@ieee.org 2022-09-06T11:32:13-04:00 2022-09-06T11:32:13-04:00
changeset fba76e0bba98
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description set journal mode to wal when creating db.

Trying to work around sqlite3.OperationalError: disk I/O error
errors in CI that I can't reproduce locally.

Also this allows reads to happen while writes are occurring.
This should permit using the web interface for browsing while
a large write load (e.g. bulk data loading from another tracker)
is happening. Right now autogenerating issues locks up the tracker
for reading with an error that the database is locked.
files
Add instrumentation to debug I/O error in CI that I don't get locally http://hg.code.sf.net:8000/p/roundup/code/#changeset-fad6b3a272cd16ec3079c8f13f76a312080e16ae John Rouillard rouilj@ieee.org 2022-09-05T23:47:23-04:00 2022-09-05T23:47:23-04:00
changeset fad6b3a272cd
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Add instrumentation to debug I/O error in CI that I don't get locally

try to debug 'sqlite3.OperationalError: disk I/O error' failures:

https://github.com/roundup-tracker/roundup/actions/runs/2995869962

https://app.travis-ci.com/github/roundup-tracker/roundup/jobs/581894108

during commit().

Get info on mode, uid, gid etc. for db directory and files in it.

I can provoke the failure by stopping before a self.conn.commit(),
chmod 555 the directory holding the db then continue. But even running
a full test suite I never see this error. It only occurs for some
tests and not others and doesn't seem to be consistent.

One other possible workaround is setting it to WAL mode rather than
journal mode when opening it.
files
redis import failure on python2 causes crash http://hg.code.sf.net:8000/p/roundup/code/#changeset-feb175271f3e239ef162f02af8984de88a404443 John Rouillard rouilj@ieee.org 2022-08-07T00:43:31-04:00 2022-08-07T00:43:31-04:00
changeset feb175271f3e
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description redis import failure on python2 causes crash

Don't use ModuleNotFoundError, it's python 3.6+. Use plain ImportError
instead.
files
Summary: Support selecion session/otk data store. Add redis as data store. http://hg.code.sf.net:8000/p/roundup/code/#changeset-3f60a71b081240cebcb1c0e96d760e7a9c790612 John Rouillard rouilj@ieee.org 2022-08-04T14:41:58-04:00 2022-08-04T14:41:58-04:00
changeset 3f60a71b0812
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description 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
files
issue2551224 - Replace dbm db for sessions/otks when using sqlite http://hg.code.sf.net:8000/p/roundup/code/#changeset-25d08e15e3b4ea98a13540cf2388e33a9b227105 John Rouillard rouilj@ieee.org 2022-07-25T15:30:36-04:00 2022-07-25T15:30:36-04:00
changeset 25d08e15e3b4
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2551224 - Replace dbm db for sessions/otks when using sqlite

Generate new sqlite db's for storing one time keys and session and
other ephemeral data.
files
issue2551189 - increase size of words in full text index. 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
Summary: Add test cases for sqlite fts http://hg.code.sf.net:8000/p/roundup/code/#changeset-91ab3e0ffcd0d5550274ffda207241843ee6a545 John Rouillard rouilj@ieee.org 2022-01-23T18:57:45-05:00 2022-01-23T18:57:45-05:00
changeset 91ab3e0ffcd0
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Summary: Add test cases for sqlite fts

Add support for using the FTS5 full text query engine for sqlite.

Also stubbed out some sections for adding postgresql FTS support as
well.

Added nee indexer type native-fts. It is not selected by default. The
indexer=native is used if no indexer is set. This prevents an upgrade
from seeming to wipe out the native index if upgraded and
indexer=native is not explicitly set.

Docs updated. Also changed section headers to sentence case for the
current release notes.

Indexing backend can control if the full text search phrase is broken
into a list of words or passed intact. For backends with query
languages (sqlite and can be enabled for whoosh and xapian) we do not
want the phrase "tokenized" on whitespace.

This also updates the rdbms database version to version 7 to add FTS
table. I will be using the same version when I add postgresql. If
somebody runs this version on postgresql, they will have to manually
add the fts tables for postgresql if they want to use it.

Added a new renderError method to client. This allows errors to be
reported still using page.html rather than raw html. It also supports
templates for any error code. If no template for the error code
(e.g. 400) is found, the error in raw html with no page frame is
shown.

New IndexerQueryError exception to pass back message about query syntax
errors.
files
Flake8: whitepace; don't import base64; unused loop var gets leading _ http://hg.code.sf.net:8000/p/roundup/code/#changeset-19a58adf5d1fd74b286c71cbcd2a12111bd962c5 John Rouillard rouilj@ieee.org 2020-01-11T16:50:44-05:00 2020-01-11T16:50:44-05:00
changeset 19a58adf5d1f
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Flake8: whitepace; don't import base64; unused loop var gets leading _
files
Implement limit and offset for filter http://hg.code.sf.net:8000/p/roundup/code/#changeset-16e1255b16cf3400f54de9a6048809c1b413e239 Ralf Schlatterbeck rsc@runtux.com 2019-08-26T20:23:53+02:00 2019-08-26T20:23:53+02:00
changeset 16e1255b16cf
branch
bookmark
tag
user Ralf Schlatterbeck <rsc@runtux.com>
description Implement limit and offset for filter

These map to the corresponding SQL parameters for the SQL backends.
files
Implement exact string search http://hg.code.sf.net:8000/p/roundup/code/#changeset-ee2e8f8d66482ffeb6b2133fce281d069c421bd5 Ralf Schlatterbeck rsc@runtux.com 2019-08-26T18:18:02+02:00 2019-08-26T18:18:02+02:00
changeset ee2e8f8d6648
branch
bookmark
tag
user Ralf Schlatterbeck <rsc@runtux.com>
description Implement exact string search

.. in the 'filter' method of hyperdb.Class (and the corresponding
backend implementations).
files
Python 3 preparation: unicode. http://hg.code.sf.net:8000/p/roundup/code/#changeset-56c9bcdea47f22412e4f0768775d1abea52d19c2 Joseph Myers jsm@polyomino.org.uk 2018-07-25T09:05:58+00:00 2018-07-25T09:05:58+00:00
changeset 56c9bcdea47f
branch
bookmark
tag
user Joseph Myers <jsm@polyomino.org.uk>
description Python 3 preparation: unicode.

This patch introduces roundup/anypy/strings.py, which has a comment
explaining the string representations generally used and common
functions to handle the required conversions. Places in the code that
explicitly reference the "unicode" type / built-in function are
generally changed to use the new functions (or, in a few places where
those new functions don't seem to fit well, other approaches such as
references to type(u'') or use of the codecs module). This patch does
not generally attempt to address text conversions in any places not
currently referencing the "unicode" type (although
scripts/import_sf.py is made to use binary I/O in places as fixing the
"unicode" reference didn't seem coherent otherwise).
files
Fix commits although a Reject exception is raised 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
Add a 'retired' parameter to Class.filter http://hg.code.sf.net:8000/p/roundup/code/#changeset-506c7ee9a3854cac2ad3615d489ec131dd448e33 Ralf Schlatterbeck rsc@runtux.com 2018-04-19T20:01:43+02:00 2018-04-19T20:01:43+02:00
changeset 506c7ee9a385
branch
bookmark
tag
user Ralf Schlatterbeck <rsc@runtux.com>
description Add a 'retired' parameter to Class.filter

.. to allow searching for retired, non-retired or all (retired and
non-retired) items similar to the argument of the same name to
Class.getnodeids. This is 'False' by default (finding only non-retired
items for backwards compatibility) and can be set to None (for finding
retired and non-retired items) or True (for finding only retired items).
files
Use Python-3-compatible 'as' syntax for except statements http://hg.code.sf.net:8000/p/roundup/code/#changeset-198b6e810c67c4e7e38f1aa41edbc864783fe6e6 Eric S. Raymond esr@thyrsus.com 2017-08-24T22:21:37-04:00 2017-08-24T22:21:37-04:00
changeset 198b6e810c67
branch
bookmark
tag
user Eric S. Raymond <esr@thyrsus.com>
description Use Python-3-compatible 'as' syntax for except statements

Many raise statements near these are also fixed.
So are two ivorrect file encoding marks ('utf8'->'utf-8').
files
Implement double-precision Number http://hg.code.sf.net:8000/p/roundup/code/#changeset-e1e40674a0bcbb8e2a03166dc2c44bd685b2932e Ralf Schlatterbeck rsc@runtux.com 2016-12-12T13:53:47+01:00 2016-12-12T13:53:47+01:00
changeset e1e40674a0bc
branch
bookmark
tag
user Ralf Schlatterbeck <rsc@runtux.com>
description Implement double-precision Number

.. as an option to the 'Number' property.
files
issue2550727: db.newid is broken with sqlite. http://hg.code.sf.net:8000/p/roundup/code/#changeset-9cebf686c552d58df5290b6152e17b05dfb81009 John Rouillard rouilj@ieee.org 2016-07-13T22:30:07-04:00 2016-07-13T22:30:07-04:00
changeset 9cebf686c552
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description issue2550727: db.newid is broken with sqlite.

Added proper transaction lock around the sql code to get a new id. The
the locking that pysqlite attempts had to be defeated because it is
broken. Had to explicitly manage transactions with BEGIN IMMEDIATE
and call sql_commit.

Note that this reduces performance by 30% in return for accuracy.

Also use update call set newid=newid+1 rather than incrementing in
python.
files
- issue2550636, issue2550909: Added support for Whoosh indexer. http://hg.code.sf.net:8000/p/roundup/code/#changeset-e74c3611b1387156cc22a7e18d0d5048b6961f8a John Rouillard rouilj@ieee.org 2016-06-25T20:10:03-04:00 2016-06-25T20:10:03-04:00
changeset e74c3611b138
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description - issue2550636, issue2550909: Added support for Whoosh indexer.
Also adds new config.ini setting called indexer to select
indexer. See ``doc/upgrading.txt`` for details. Initial patch
done by David Wolever. Patch modified (see ticket or below for
changes), docs updated and committed.

I have an outstanding issue with test/test_indexer.py. I have to
comment out all imports and tests for indexers I don't have (i.e.
mysql, postgres) otherwise no tests run.

With that change made, dbm, sqlite (rdbms), xapian and whoosh indexes
are all passing the indexer tests.

Changes summary:
1) support native back ends dbm and rdbms. (original patch only fell
through to dbm)
2) Developed whoosh stopfilter to not index stopwords or words outside
the the maxlength and minlength limits defined in index_common.py.
Required to pass the extremewords test_indexer test. Also I
removed a call to .lower on the input text as the tokenizer I chose
automatically does the lowercase.
3) Added support for max/min length to find. This was needed to pass
extremewords test.
4) Added back a call to save_index in add_text. This allowed all but
two tests to pass.
5) Fixed a call to:
results = searcher.search(query.Term("identifier", identifier))
which had an extra parameter that is an error under current whoosh.
6) Set limit=None in search call for find() otherwise it only return
10 items. This allowed it to pass manyresults test

Also due to changes in the roundup code removed the call in
indexer_whoosh to

from roundup.anypy.sets_ import set

since we use the python builtin set.
files
Add support for an integer type to join the existing number type. http://hg.code.sf.net:8000/p/roundup/code/#changeset-e424987d294ab827d33f4e5253522b2e86563162 John Rouillard rouilj@ieee.org 2016-06-05T00:17:26-04:00 2016-06-05T00:17:26-04:00
changeset e424987d294a
branch
bookmark
tag
user John Rouillard <rouilj@ieee.org>
description Add support for an integer type to join the existing number type.

Commit patch supplied for issue2550886. This can be used for
properties used for ordering, counts etc. where a decimal point
isn't needed. Developed by Anthony (antmail). Doc updates written by
John Rouillard.
files
Fixed issue2550595: Allow migrating from roundup 0.x to 1.4 http://hg.code.sf.net:8000/p/roundup/code/#changeset-3adff0fb0207059bfb1cdd8c2e2d441ba21cc176 Thomas Arendsen Hein thomas@intevation.de 2013-03-22T15:53:27+01:00 2013-03-22T15:53:27+01:00
changeset 3adff0fb0207
branch
bookmark
tag
user Thomas Arendsen Hein <thomas@intevation.de>
description Fixed issue2550595: Allow migrating from roundup 0.x to 1.4

All changes were required to make an upgrade from 0.6 to 1.4,
The changes affecting "retired" were required for an upgrade from 0.8 to 1.4.
files
- more logger fixes, sorry for the noise. http://hg.code.sf.net:8000/p/roundup/code/#changeset-67bef70ab9b956f0af82e6eff9a743fd5d84187c Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2010-09-17T06:47:58+00:00 2010-09-17T06:47:58+00:00
changeset 67bef70ab9b9
branch
bookmark
tag
user Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description - more logger fixes, sorry for the noise.
files
- more logger fixes -- use correct hierarchical logger names... http://hg.code.sf.net:8000/p/roundup/code/#changeset-9655a1b65974dfe2d1e2270fa419a067829ef72a Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2010-09-16T07:44:50+00:00 2010-09-16T07:44:50+00:00
changeset 9655a1b65974
branch
bookmark
tag
user Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description - more logger fixes -- use correct hierarchical logger names...

...always starting with "roundup." -- otherwise logger configuration
changed in changeset
2010-08-09T03:36:06Z!schlatterbeck@users.sourceforge.net will not work
(e.g. turning debugging on)
files
new rdbms config item sqlite_timeout... http://hg.code.sf.net:8000/p/roundup/code/#changeset-3e35233ea93c276a531980e3663ada9f63f97533 Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2010-09-07T15:42:04+00:00 2010-09-07T15:42:04+00:00
changeset 3e35233ea93c
branch
bookmark
tag
user Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description new rdbms config item sqlite_timeout...

...makes the previously hard-coded timeout of 30 seconds
configurable. This is the time a client waits for the locked database
to become free before giving up. Used only for SQLite backend.
files
Beginnings of a big code cleanup / modernisation to make 2to3 happy http://hg.code.sf.net:8000/p/roundup/code/#changeset-13b3155869e050964ca244b2fc0e586e7918a3f3 Richard Jones richard@users.sourceforge.net 2010-02-22T05:26:57+00:00 2010-02-22T05:26:57+00:00
changeset 13b3155869e0
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description Beginnings of a big code cleanup / modernisation to make 2to3 happy
files
compatibilty fix for pysqlite2 / unicode http://hg.code.sf.net:8000/p/roundup/code/#changeset-289f249ba192759e88a64f2ccc9b9b24605a0645 Richard Jones richard@users.sourceforge.net 2009-08-10T04:25:15+00:00 2009-08-10T04:25:15+00:00
changeset 289f249ba192
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description compatibilty fix for pysqlite2 / unicode
files
re-order sqlite imports to handle multiple installed versions (issue 2550570) http://hg.code.sf.net:8000/p/roundup/code/#changeset-23ba17d01a24adb2652ca740eabbb1f537b0b99c Richard Jones richard@users.sourceforge.net 2009-07-27T23:57:23+00:00 2009-07-27T23:57:23+00:00
changeset 23ba17d01a24
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description re-order sqlite imports to handle multiple installed versions (issue 2550570)
files
force sqlite3 in py2.6+ to treat our stored text as UTF-8 http://hg.code.sf.net:8000/p/roundup/code/#changeset-09e79cbeb8279fb095ba07183aff34f7acb9d4d6 Richard Jones richard@users.sourceforge.net 2009-03-12T04:29:16+00:00 2009-03-12T04:29:16+00:00
changeset 09e79cbeb827
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description force sqlite3 in py2.6+ to treat our stored text as UTF-8
files
Uniformly use """...""" instead of '''...''' for comments. http://hg.code.sf.net:8000/p/roundup/code/#changeset-59d02edfaa9c1128bcd29cf480701dd3e12365a9 Stefan Seefeld stefan@seefeld.name 2009-02-24T03:15:57+00:00 2009-02-24T03:15:57+00:00
changeset 59d02edfaa9c
branch
bookmark
tag
user Stefan Seefeld <stefan@seefeld.name>
description Uniformly use """...""" instead of '''...''' for comments.
files
Indexing fixes. http://hg.code.sf.net:8000/p/roundup/code/#changeset-bb30bbfc7cdda4caa7010d3056b88b020786aaef Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2007-06-21T07:35:51+00:00 2007-06-21T07:35:51+00:00
changeset bb30bbfc7cdd
branch
bookmark
tag
user Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description Indexing fixes.

- Add new rdbms-indexes to the tables for the full-text index. These
speed up adding new entries and finding old ones to remove.
- Remove getprops method from FileClass in backends/rdbms_common: This
forced indexing for the content property even if the user decided to
turn it off for a FileClass instance.
files
*** empty log message *** http://hg.code.sf.net:8000/p/roundup/code/#changeset-f5ddd1639a150eb1d9212bee662f4c17ae3b53a7 Richard Jones richard@users.sourceforge.net 2006-12-19T03:01:37+00:00 2006-12-19T03:01:37+00:00
changeset f5ddd1639a15
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description *** empty log message ***
files
unicode / sqlite 3 problem [SF#1589292] http://hg.code.sf.net:8000/p/roundup/code/#changeset-c92687dce13515d3c2c3d31ee1bcc94048170f6e Richard Jones richard@users.sourceforge.net 2006-11-11T03:21:12+00:00 2006-11-11T03:21:12+00:00
changeset c92687dce135
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description unicode / sqlite 3 problem [SF#1589292]
files
fixed support for pysqlite2 (version 2.1.0 is the minimum version supported) http://hg.code.sf.net:8000/p/roundup/code/#changeset-b476fef16ccc1690d29862f35d8c527665c15fd7 Richard Jones richard@users.sourceforge.net 2006-10-10T03:55:31+00:00 2006-10-10T03:55:31+00:00
changeset b476fef16ccc
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description fixed support for pysqlite2 (version 2.1.0 is the minimum version supported)
files
support sqlite3 http://hg.code.sf.net:8000/p/roundup/code/#changeset-0d561b24ceff7c80dc8b38ddff86c5831d39a4df Richard Jones richard@users.sourceforge.net 2006-10-04T01:12:00+00:00 2006-10-04T01:12:00+00:00
changeset 0d561b24ceff
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description support sqlite3
files
Database interface fixes. http://hg.code.sf.net:8000/p/roundup/code/#changeset-a775afeeee8b6bcd65b7f96e3701196dc5da31e9 Ralf Schlatterbeck schlatterbeck@users.sourceforge.net 2006-08-30T09:05:30+00:00 2006-08-30T09:05:30+00:00
changeset a775afeeee8b
branch
bookmark
tag
user Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net>
description Database interface fixes.

- Fix a problem with wrong sort-order in RDBMS backend when a
sort-attribute is also searched for. We need to preserve correct sort
attribute order in that case. A test for this was added earlier.
- Added forgotten fail_ok parameter to sql_commit method in sqlite
backend to make tests work again.
- Note that this version still fails a test for the postgresql backend.
files
update for latest version of pysqlite ([SF#1487098]; patch 1534227) http://hg.code.sf.net:8000/p/roundup/code/#changeset-f5201bbbc50523e4906fd25807d05740975334b9 Richard Jones richard@users.sourceforge.net 2006-08-11T00:02:12+00:00 2006-08-11T00:02:12+00:00
changeset f5201bbbc505
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description update for latest version of pysqlite ([SF#1487098]; patch 1534227)
files
umask is now configurable (with the same 0002 default) http://hg.code.sf.net:8000/p/roundup/code/#changeset-f2fda3e6fc8b1e5780dfc671c3ff0ddd7094d70c Richard Jones richard@users.sourceforge.net 2006-04-27T04:59:37+00:00 2006-04-27T04:59:37+00:00
changeset f2fda3e6fc8b
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description umask is now configurable (with the same 0002 default)
files
more errors. backport candidate http://hg.code.sf.net:8000/p/roundup/code/#changeset-9020fe58c51c3777bf0263dd6e895ae4eb0187e7 Anthony Baxter anthonybaxter@users.sourceforge.net 2005-06-08T03:41:21+00:00 2005-06-08T03:41:21+00:00
changeset 9020fe58c51c
branch
bookmark
tag
user Anthony Baxter <anthonybaxter@users.sourceforge.net>
description more errors. backport candidate
files
merge from maint-0-7 http://hg.code.sf.net:8000/p/roundup/code/#changeset-3518d1ffd9409ece98c0d5fae5b489c0b920729a Richard Jones richard@users.sourceforge.net 2005-05-02T05:48:59+00:00 2005-05-02T05:48:59+00:00
changeset 3518d1ffd940
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from maint-0-7
files
[maint-0.8] merge from maint-0-7 http://hg.code.sf.net:8000/p/roundup/code/#changeset-088c1792b7f62be0ef56fa33794e58bd9b7cfdd3 Richard Jones richard@users.sourceforge.net 2005-05-02T05:48:59+00:00 2005-05-02T05:48:59+00:00
changeset 088c1792b7f6
branch maint-0.8
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from maint-0-7
files
[maint-0.7] fix RDBMS clear() so it resets all class itemid counters http://hg.code.sf.net:8000/p/roundup/code/#changeset-c7c25f2103b23f0c8aa9b12411ce288ebd42f5cb Richard Jones richard@users.sourceforge.net 2005-05-02T05:44:56+00:00 2005-05-02T05:44:56+00:00
changeset c7c25f2103b2
branch maint-0.7
bookmark
tag 0.7.12
user Richard Jones <richard@users.sourceforge.net>
description fix RDBMS clear() so it resets all class itemid counters
files
merge from maint-0-7 http://hg.code.sf.net:8000/p/roundup/code/#changeset-ae1093684ef5e9170689a6bba5fafdf247327abf Richard Jones richard@users.sourceforge.net 2005-05-02T01:05:15+00:00 2005-05-02T01:05:15+00:00
changeset ae1093684ef5
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from maint-0-7
files
[maint-0.7] fix RDBMS clear() so it resets all class itemid counters http://hg.code.sf.net:8000/p/roundup/code/#changeset-e074c641cb5eadb6fb224d609c280c108339d713 Richard Jones richard@users.sourceforge.net 2005-05-02T01:03:41+00:00 2005-05-02T01:03:41+00:00
changeset e074c641cb5e
branch maint-0.7
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description fix RDBMS clear() so it resets all class itemid counters
files
remove unnecessary import http://hg.code.sf.net:8000/p/roundup/code/#changeset-a9b0fe809d16fb1d874a631c24d184148ec4a23f Richard Jones richard@users.sourceforge.net 2005-02-14T04:37:37+00:00 2005-02-14T04:37:37+00:00
changeset a9b0fe809d16
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description remove unnecessary import
files
[maint-0.8] remove unnecessary import http://hg.code.sf.net:8000/p/roundup/code/#changeset-43675a5232b15fea6a298ef73a7fb66d027efe51 Richard Jones richard@users.sourceforge.net 2005-02-14T04:37:37+00:00 2005-02-14T04:37:37+00:00
changeset 43675a5232b1
branch maint-0.8
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description remove unnecessary import
files
[maint-0.8] merge from HEAD http://hg.code.sf.net:8000/p/roundup/code/#changeset-e1da7b5b04abf9880c0cb834dc868ffd59c556d1 Richard Jones richard@users.sourceforge.net 2005-02-14T02:55:31+00:00 2005-02-14T02:55:31+00:00
changeset e1da7b5b04ab
branch maint-0.8
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from HEAD
files
Python 2.3 minimum version - bye bye roundup.rlog, you had a short life. http://hg.code.sf.net:8000/p/roundup/code/#changeset-57b60bda9473826c2c97b92f46f8f4b18ccd8900 Richard Jones richard@users.sourceforge.net 2005-02-14T02:48:12+00:00 2005-02-14T02:48:12+00:00
changeset 57b60bda9473
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description Python 2.3 minimum version - bye bye roundup.rlog, you had a short life.
files
merge from maint-0-8 http://hg.code.sf.net:8000/p/roundup/code/#changeset-d9b4224f955c4d1c406f37c4f2b366fca589a761 Richard Jones richard@users.sourceforge.net 2005-01-04T01:38:12+00:00 2005-01-04T01:38:12+00:00
changeset d9b4224f955c
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from maint-0-8
files
[maint-0.7] merge from maint-0-8 http://hg.code.sf.net:8000/p/roundup/code/#changeset-d3a5e382d44a36cfc46025fb71cad4f611521883 Richard Jones richard@users.sourceforge.net 2005-01-04T01:38:12+00:00 2005-01-04T01:38:12+00:00
changeset d3a5e382d44a
branch maint-0.7
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from maint-0-8
files
[maint-0.8] have RDBMS full-text indexer do AND searching [SF#1055435] http://hg.code.sf.net:8000/p/roundup/code/#changeset-a7045bad20def82339aae3d3ffb7cdd2a9a82063 Richard Jones richard@users.sourceforge.net 2005-01-04T01:33:04+00:00 2005-01-04T01:33:04+00:00
changeset a7045bad20de
branch maint-0.8
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description have RDBMS full-text indexer do AND searching [SF#1055435]
files
[maint-0.8] merge from HEAD http://hg.code.sf.net:8000/p/roundup/code/#changeset-240a24f1e69ffc9d39da90ee7db41f56f1196172 Richard Jones richard@users.sourceforge.net 2004-12-14T23:23:35+00:00 2004-12-14T23:23:35+00:00
changeset 240a24f1e69f
branch maint-0.8
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from HEAD
files
back_sqlite.py is missing "import time" [SF#1081959] http://hg.code.sf.net:8000/p/roundup/code/#changeset-c5530df3aaa67aa9ea8472119b3dd7f09459ed63 Richard Jones richard@users.sourceforge.net 2004-12-14T23:16:45+00:00 2004-12-14T23:16:45+00:00
changeset c5530df3aaa6
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description back_sqlite.py is missing "import time" [SF#1081959]
files
sqlite_busy_timeout is not supported in pysqlite 1.1 (SQLite 3.x). http://hg.code.sf.net:8000/p/roundup/code/#changeset-fddbbeb581bc670dc6be71ec58877ca5c5d8e334 Alexander Smishlajev a1s@users.sourceforge.net 2004-10-31T09:57:10+00:00 2004-10-31T09:57:10+00:00
changeset fddbbeb581bc
branch
bookmark
tag
user Alexander Smishlajev <a1s@users.sourceforge.net>
description sqlite_busy_timeout is not supported in pysqlite 1.1 (SQLite 3.x).
have to install sqlite_busy_handler instead.
files
sqlite database creation requires existing directory. http://hg.code.sf.net:8000/p/roundup/code/#changeset-d3b3f1b3d59ea78fb724ca589ff34caee27ee3ba Alexander Smishlajev a1s@users.sourceforge.net 2004-10-16T12:52:53+00:00 2004-10-16T12:52:53+00:00
changeset d3b3f1b3d59e
branch
bookmark
tag
user Alexander Smishlajev <a1s@users.sourceforge.net>
description sqlite database creation requires existing directory.

create the database directory in sql_open_connection()
if the directory does not exist.
files
postgres backend open doesn't hide corruption in schema [SF#956375] http://hg.code.sf.net:8000/p/roundup/code/#changeset-402d6d5565586fdb56b0c6acea9b88eecd1c3577 Richard Jones richard@users.sourceforge.net 2004-10-08T05:37:44+00:00 2004-10-08T05:37:44+00:00
changeset 402d6d556558
branch
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description postgres backend open doesn't hide corruption in schema [SF#956375]

*dbm-style backends nuke() method now clear id counters
files
[maint-0.7] merge from HEAD http://hg.code.sf.net:8000/p/roundup/code/#changeset-8140fb12808886bbc488816f0ff8b60bc829a832 Richard Jones richard@users.sourceforge.net 2004-10-07T06:33:57+00:00 2004-10-07T06:33:57+00:00
changeset 8140fb128088
branch maint-0.7
bookmark
tag
user Richard Jones <richard@users.sourceforge.net>
description merge from HEAD
files