http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6851|0 |1 is obsolete| | --- Comment #5 from [email protected] --- Created attachment 8428 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8428&action=edit Add DBQ, a small module to generate DB specific SQL code To eliminate database specific SQL idoms (aka MySQLisms) it is necessary to either use a standard SQL form like 'CAST(now() as date)' instead of the non-standard MySQLism 'CURDATE()', or to generate a database specific idiom where no such standard form exists (e.g. to get the list of column names from a table). The new DBQ module is a generator for DB specific SQL idioms and comes with an implementatio for both MySQL and PostgreSQL. Generating the SQL idioms this way is the least invasive form of getting DB independence, as no large changes to the database layer are required. Please note that DBQ->dbq returns a singleton. DBQ stands for Database Query. Name, usage patterns, and implementation discussed and agreed upon with many during the Marseille Hackfest 2012. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
