Log of /moodle/lib/dml/moodle_database.php

MDL-20625 coding help - better detection of missing commit or rollback

MDL-20625 new delegated transaction support in DML

MDL-20734 normalise_value() - moving from private to protected everywhere and abstracting

MDL-14679 tidy phpdocs for sql_substr() a bit

MDL-19474 One year and a half ago we started designing and implementing our new databse abstraction layer which included brand new moodle native drivers. Today we are finally removing old legacy drivers that were still using adodb internally. From now on the adodb will be used only in some authentication and enrolment plugins, we are probably going to drop adodb there too later in 2.x. Thanks everybody who helped test and improve our new drivers, even bigger thanks to all the great developers who created ADOdb!

MDL-20334 re-fix - small performance improvement

As Petr suggested, is_array() is faster than empty() so it makes sense
to check it first.

MDL-20334 get_in_or_equal() does not accept empty array

Delegate prefix subtitution to each db driver to enforce calls to fix_sql_params() everywhere

MDL-19689 fixed strictness constants, thanks Tim

MDL-19689 fixed strictness constants, thanks Tim

MDL-19689 new $strictness parameter in $DB->get_record() and $DB->get_field() family of DML methods

themes: MDL-19077 new $OUTPUT->header/footer to replace print_header/footer.
Also, part of the change from weblib.php functions to $OUTPUT-> methods.

This is part of http://docs.moodle.org/en/Development:Theme_engines_for_Moodle%3F

This is a big change, and the result is not perfect yet. Expect some debugging output
on some pages.

The main part of these changes are that $OUTPUT->header now looks for a file
in the theme called layout.php, rather than header.html and footer.html. Also
you can have special templates for certain pages like layout-home.php. There is
fallback code for Moodle 1.9 themes, so they still work.

A few of the old arguments to print_header are no longer supported. (You get an
exception if you try to use them.) Sam H will be cleaning those up.

All the weblib functions that have been replaced with $OUTPUT-> have version in
deprecatedlib, so existing code will go on working for the foreseeable future.

MDL-14990 implemented query loggin in new native DML drivers

MDL-19470, MDL-14990 fixed db transactio nregression + towards query logging support

MDL-14679 fixing old TODOs and adding more CLI support

MDL-19470 detection of unfinished transactions and transactions interrupted by exceptions

MDL-19470 adding missing inline docs

MDL-19470 fixing DML license headers

MDL-19470 detection of nested transactions, only one level allowed

MDL-14992 sessions - proper destructor method and fixed dispose() behaviour.

lib/dml: new compatibility method sql_cast_2signed for when MySQL thinks that 1 * -1 = 18446744073709551615

MDL-18244 sql_length() - new cross-db function to calculate the length in chars of any expression ; from 19_STABLE

MDL-17458 rewritten installer

MDL-14992 refactored use of session_write_close()

MDL-14992 pg session locking (8.2 and later only), refactoring and db session not default yet in new installs

MDL-14992 pg sessions advisory locks accept only integers :-( trying to find a workaround

MDL-14992 towards better db sessions - session locking for mysql

MDL-14992 towards better db sessions

MDL-17859 implemented caching in get_tables()

MDL-17806 fixed sql_bit_and use which returns number and that is why it is not suitable for SQL conditions; thanks penny!
Fixed DML docs too.

MDL-17645 delete_records_list - Tidied a bit return values. Fix behaviour when no values are passed + new dml tests for all *_list() functions.

dml: MDL-17645 New database method delete_records_list.

MDL-17491 experimental native oracle driver - still bugy and incomplete, this will require more core changes, grrrrrr

MDL-17522 improved dml tests, fixed sql LIMIT support in native drivers

MDL-17408 DML: new sql_modulo() method + test

MDL-15837 more dml unit tests

MDL-17317 DML: more exceptions - now in connect too

MDL-17354 moved reset_sequence into dbmanager

MDL-17317 DML: Exceptions used by all drivers now :-) expect some more commits/cleanup soon

MDL-17317 lets make Netbeans happy, it is not clever enough to detect undefined vars properly ;-)

Improve error message.

MDL-17130 dml: removed lambda-style functions - they might be a major scalability problem in future

MDL-17129 dml/ddl: improved ddl exceptions when changing db structure

MDL-17129 dml: implemented exceptions in new drivers, yay!

MDL-17129 basic dml exceptions

MDL-14990 dml: towards proper logging/perf infrastructure

Fix and improve error message.

MDL-14990 dml: towards proper logging/perf infrastructure

Missing parenthesis in sql_substr(). MDL-16669

MDL-16669 dml: improved sql_substring(), added unit tests

MDL-14990 dml: added __destruct method, will be needed for logging

MDL-17036 dml:  dbpersist moved into dboptions

MDL-17020 dml: native pgsql driver - implementation and unittests of transactions

MDL-17020 dml: native pgsql driver - improved get_record and get_field - this should be faster

MDL-17020 dml: native pgsql driver - $ bound syntax fully implemented, we do not need string for exception anymore

MDL-17020 dml: dollar bound query syntax support

MDL-16930 dml: converting print_error to exceptions

MDL-14679 dml/native_mysqli improvements

MDL-16483 Reverting as Petr ordered... I mean, suggested.

MDL-16483 Refactored install/upgrade code into lib/adminlib. Created an intermediate MoodleUnitTestCase class that overrides simpletest's constructor, destructor and setup/teardown methods. All moodle unit tests must extend this class.

MDL-14589 minor database driver loading refactoring

MDL-15635 dml library inclusion refactoring

MDL-15671, MDL-15717 DB->import_record() support - code based on patch by Andrei Bautu; added new param to raw insert; unit tests included

MDL-15671 support for table sequence resetting - code by Andrei Bautu (with minor modifications)

MDL-16141 Need an sql_position method to do POSITION(needle IN haystack) on crappy databases; and
MDL-16140 Table "testtable" already exists messages when re-running dml unit tests after a crash - make it self-healing.

Final modifications to PHP docs while documenting DML function in Docs.

Some more PHP Docs minor changes.

Polishing a bit PHP docs

MDL-15808 Applying Andrei's patch

MDL-14129, remove error() call

Make a comment a bit clearer.

Added sql_ceil() helper method. MDL-15336

Adding new sql_null_from_clause() helper function from 19_STABLE. MDL-13861

MDL-14679 var_export now used instead of addsingleslashes in installer; refactored the database setting initialisation

MDL-14905 Finished all basic tests. It should now be easy to extend these tests with more boundary conditions

MDL-14905 Added more unit tests, plus stubs for all methods to be tested. Also fixed a bug in moodle_database:get_recordset_list(), which was using " AND " between values instead of " OR "

MDL-15273 basic read/write perf counter in moodle_database

MDL-15273 basic read/write perf counter in moodle_database

MDL-15273 basic read/write perf counter in moodle_database

MDL-15094 removed remaining references to $db

MDL-15247 lib/dmllib.php is now obsolete

MDL-15246 moving all remaining ddl function to adminlib, keeping old lib/ddllib.php only for BC withexisting code; fixed inline docs related to ddl

Fix some missing $this-> in ddl/dml stuff. MDL-15236

MDL-14905 towards functional DB tests

MDL-15194 adodb separation, dml database creation support

MDL-14679 towards adodb separation

MDL-15181 temp table support in ddl/dml

MDL-14679 fixed incorrect fields param

MDL-15132 fixed broken sql menu functions - thanks Howard

MDL-15140 get_records_list() doesn't work as in 1.9 - thanks Jerome

MDL-14967 DB upgrades. Not finished yet.

MDL-14679 remoed all instances of get_records_list()

MDL-14679 fixed count_records() API

MDL-15073 delete_records now truncates table if deleting all records, fixed some regressions

MDL-14679 towards reports and stats conversion

MDL-14679 detect incorrect key=>value pairs in $conditions - in case somebody forgets "=>" and uses "," instead

MDL-14957 fixed get_indexes() comments

MDL-14957 fixed get_tables() comments

MDL-14957 get_columns() improvements - mostly docs; definition moved to new file

MDL-14981 regex search support in datalib, fixed course search

MDL-14910 added option to dispose existing database instance (closes connection and releases all resources)

MDL-14974 improved columns caching implementation

MDL-14679 improved get_in_or_equal() method

MDL-14679 fixed get_in_or_equal() method

MDL-14905 Started on the DDL functional tests. Added an ugly but temporary hack into error() and print_error(), so that they throw an exception instead of dying when UNITTEST is defined.

Installer fixed, prefixes improved, moved conn settings to connect() and some more improvements. MDL-14864

MDL-14679 ok, here is the big patch with new dmllib and ddlib API, some code is already converted, XML db editor works; see tracker for details of regressions and TODOs