Diffusion invenio-infoscience f777c4c9b99f

legacy: fix sql compatibility with PostgreSQL
f777c4c9b99f
Actions

Authored by Leonardo Rossi <leonardo.r@cern.ch> on Jun 26 2015, 11:05.

Description

legacy: fix sql compatibility with PostgreSQL

Adds double quotes for tables and column, and single quotes for values. (closes #3212)

Fixes MySQL specific queries: "SHOW TABLES", "DATE_FORMAT", "PRIORITY", "RLIKE", "REGEXP", cascading on truncate tables. (addresses #3214)

Fixes call of get_user_preferences on system_email module.

Fixes blob column transforming string in bytearray.

Signed-off-by: Leonardo Rossi <leonardo.r@cern.ch>

Details

Committed

Leonardo Rossi <leonardo.r@cern.ch>

Jun 26 2015, 14:09

Parents

R3600:87f083c0b782: legacy: BibCirculation removal

Branches

Unknown

Tags

Unknown

Event Timeline

Leonardo Rossi <leonardo.r@cern.ch> committed R3600:f777c4c9b99f: legacy: fix sql compatibility with PostgreSQL (authored by Leonardo Rossi <leonardo.r@cern.ch>).Jun 26 2015, 14:09

Changes (46)

				Path
	M			invenio/legacy/bibcatalog/dblayer.py
	M			invenio/legacy/bibcatalog/system_email.py
	M			invenio/legacy/bibcatalog/system_rt.py
	M			invenio/legacy/bibclassify/daemon.py
	M			invenio/legacy/bibclassify/ontology_reader.py
	M			invenio/legacy/bibclassify/webinterface.py
	M			invenio/legacy/bibdocfile/managedocfiles.py
	M			invenio/legacy/bibedit/cli.py
	M			invenio/legacy/bibedit/db_layer.py
	M			invenio/legacy/bibedit/utils.py
	M			invenio/legacy/bibexport/daemon.py
	M			invenio/legacy/bibexport/fieldexporter_dblayer.py
	M			invenio/legacy/bibindex/engine.py
	M			invenio/legacy/bibrank/adminlib.py
	M			invenio/legacy/bibrank/citation_indexer.py
	M			invenio/legacy/bibrank/citation_searcher.py
	M			invenio/legacy/bibrank/citerank_indexer.py
	M			invenio/legacy/bibrank/cli.py
	M			invenio/legacy/bibrank/downloads_grapher.py
	M			invenio/legacy/bibrank/downloads_indexer.py
	M			invenio/legacy/bibrank/record_sorter.py
	M			invenio/legacy/bibrank/selfcites_indexer.py
	M			invenio/legacy/bibrank/selfcites_task.py
	M			invenio/legacy/bibrank/tag_based_indexer.py
	M			invenio/legacy/bibrank/word_indexer.py
	M			invenio/legacy/bibrank/word_searcher.py
	M			invenio/legacy/bibsched/bibtask.py
	M			invenio/legacy/bibsched/cli.py
	M			invenio/legacy/bibsched/monitor.py
	M			invenio/legacy/bibsched/webapi.py
	M			invenio/legacy/bibsort/adminlib.py
	M			invenio/legacy/bibsort/daemon.py
	M			invenio/legacy/bibsort/engine.py
	M			invenio/legacy/bibupload/engine.py
	M			invenio/legacy/miscutil/dbdump.py
	M			invenio/legacy/oaiharvest/dblayer.py
	M			invenio/legacy/oairepository/admin.py
	M			invenio/legacy/oairepository/server.py
	M			invenio/legacy/oairepository/updater.py
	M			invenio/legacy/webbasket/db_layer.py
	M			invenio/legacy/websearch/adminlib.py
	M			invenio/legacy/websession/dblayer.py
	M			invenio/legacy/websession/inveniogc.py
	M			invenio/legacy/websession/session.py
	M			invenio/legacy/websession/webaccount.py
	M			invenio/legacy/webuser.py