Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-14679

META: DB layer 2.0

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major Major
    • 2.0
    • 2.0
    • Database SQL/XMLDB
    • None

      General collection of tasks and bugs related to datalib rewrite for Moodle 2.0

        1. new_dmllib_47.patch
          1.28 MB
        1.
        		 adodb does not support blob and clob updates with bound parameters Sub-task Closed Petr Skoda
        2.
        		 pgsql does not support bound parameters in comments Sub-task Closed Petr Skoda
        3.
        		 pgsql does not support bound queries in field default values Sub-task Closed Petr Skoda
        4.
        		 some unknown problem in big query (1.5MB) test Sub-task Closed Petr Skoda
        5.
        		 Use proper placeholders for IN senteces Sub-task Closed Petr Skoda
        6.
        		 rename xmldb stuff to follow lowercase guidelines Sub-task Closed Eloy Lafuente (stronk7)
        7.
        		 Installer script is broken Sub-task Closed Petr Skoda
        8.
        		 prefix check shouldn't be perfomed by moodle_database classes Sub-task Closed Petr Skoda
        9.
        		 preconfigure_dbconnection() stuff must be implemented in some way Sub-task Closed Petr Skoda
        10.
        		 Fix one error in SetFetchMode() + minor clean Sub-task Closed Eloy Lafuente (stronk7)
        11.
        		 ADOdb Insert_ID() function under MSSQL, using placeholders doesn't work Sub-task Closed Eloy Lafuente (stronk7)
        12.
        		 M2: Implement mssql_adodb driver Sub-task Closed Eloy Lafuente (stronk7)
        13.
        		 M2: Implement oci8po_adodb driver Sub-task Closed Eloy Lafuente (stronk7)
        14.
        		 Move function emulate_bound_params() to adodb_moodle_database Sub-task Closed Eloy Lafuente (stronk7)
        15.
        		 Make generators stuff reentrant Sub-task Closed Eloy Lafuente (stronk7)
        16.
        		 M2: DDL and DML functional tests Sub-task Closed Nicolas Connault
        17.
        		 moodle_database should have one disconnect method Sub-task Closed Petr Skoda
        18.
        		 M2: Modify XMLDB Editor to suggest PHP code using the manager Sub-task Closed Eloy Lafuente (stronk7)
        19.
        		 M2: Modify XMLDB Editor to suggest creation conditional code Sub-task Closed Eloy Lafuente (stronk7)
        20.
        		 M2: Exception handling in DDL stuff Sub-task Closed Petr Skoda
        21.
        		 M2: Normalize results returned from get_tables() get_indexes() and get_columns() Sub-task Closed Petr Skoda
        22.
        		 M2: Tests get_tables() get_indexes() get_columns() Sub-task Closed Nicolas Connault
        23.
        		 M2: Move moodle_recordset to separate class into lib/dml Sub-task Closed Petr Skoda
        24.
        		 M2-M3-M4 Upgrade all code using DML Sub-task Closed Petr Skoda
        25.
        		 reset_columns() implementation... Sub-task Closed Petr Skoda
        26.
        		 Cleanup up deprecated functions so that we do not need to convert them Sub-task Closed Petr Skoda
        27.
        		 add optional dmllib regex search support Sub-task Closed Petr Skoda
        28.
        		 add magic quotes stripping option into data_submitted() Sub-task Closed Petr Skoda
        29.
        		 M2: Move emulate_bound_params() from adodb drivers to adodb_moodle_database Sub-task Closed Eloy Lafuente (stronk7)
        30.
        		 undefined variable in oci raw insert $primarykey Sub-task Closed Eloy Lafuente (stronk7)
        31.
        		 M2: Enable dml/ddl functional tests for MSSQL and Oracle Sub-task Closed Petr Skoda
        32.
        		 M2: adodb sessions switched to moodle sessions Sub-task Closed Petr Skoda
        33.
        		 M2: implement some workaround for Oracle recordset rewind Sub-task Closed Petr Skoda
        34.
        		 M2: delete_records should truncate table of delete of all records requested Sub-task Closed Petr Skoda
        35.
        		 M2: implement full temp table support in ddl Sub-task Closed Eloy Lafuente (stronk7)
        36.
        		 M4: stop using magic quotes Sub-task Closed Petr Skoda
        37.
        		 M4: remove all dependencies on adodb code (except dml itself) Sub-task Closed Petr Skoda
        38.
        		 M2: review missing $this-> inside dml/ddl code Sub-task Closed Eloy Lafuente (stronk7)
        39.
        		 Create one script to detect old uses of dml/ddl stuff Sub-task Closed Eloy Lafuente (stronk7)
        40.
        		 M2: basic read/write perf counter in moodle_database Sub-task Closed Petr Skoda
        41.
        		 pdo patches from Andrei Sub-task Closed Petr Skoda
        42.
        		 implement upgrade savepoints for mods and plugins Sub-task Closed Eloy Lafuente (stronk7)
        43.
        		 Some oddities in admin/report/courseoverview Sub-task Closed Petr Skoda
        44.
        		 M5: Test all sql_xxx() helper functions Sub-task Closed Petr Skoda
        45.
        		 Named parameters must accept repetitions Sub-task Closed Petr Skoda
        46.
        		 M5: Add some more tests about CLOBs and BLOBs Sub-task Closed Nicolas Connault
        47.
        		 cleanup the last stripslashes and friends Sub-task Closed Petr Skoda
        48.
        		 Make sql_substr() to accept parameters instead of simply returning function name Sub-task Closed Petr Skoda
        49.
        		 add new native mysqli dml driver Sub-task Closed Petr Skoda
        50.
        		 implement exceptions instead of error() and print_error() in ddl, dml and dtl Sub-task Closed Petr Skoda
        51.
        		 add new native pgsql dml driver Sub-task Closed Petr Skoda
        52.
        		 move dbpersist option into dboptions Sub-task Closed Petr Skoda
        53.
        		 implement dml_exceptions in drivers Sub-task Closed Petr Skoda
        54.
        		 obsolete $CFG->dbfamily Sub-task Closed Petr Skoda
        55.
        		 implement exceptions in all DML drivers Sub-task Closed Petr Skoda
        56.
        		 make native drivers default if library not specified in config.php Sub-task Closed Petr Skoda
        57.
        		 move reset_sequence into dbmanager Sub-task Closed Petr Skoda
        58.
        		 Need to put back the debug code that tells you if your first column is not unique in get_records_sql Sub-task Closed Petr Skoda
        59.
        		 postgres native driver, socket connection not working for me Sub-task Closed Petr Skoda
        60.
        		 implement sql_modulo() method Sub-task Closed Petr Skoda
        61.
        		 improve dml and ddl unit tests Sub-task Closed Petr Skoda
        62.
        		 implement caching in get_tables() Sub-task Closed Petr Skoda
        63.
        		 leading zores are chopped off from strings Sub-task Closed Petr Skoda
        64.
        		 ADOdb ODBC Insert_ID() function under MSSQL doesn't work Sub-task Closed Eloy Lafuente (stronk7)
        65.
        		 M2: Document xmldb/database/manager APIs Sub-task Closed Eloy Lafuente (stronk7)
        66.
        		 M2-M3-M4: Document all changes to perform in code to use new XMLDD/DDL/DML libs properly Sub-task Closed Eloy Lafuente (stronk7)
        67.
        		 M5: Finish the Tests page in Docs Sub-task Closed Petr Skoda
        68.
        		 M2: logging Sub-task Closed Petr Skoda
        69.
        		 M2: profiling Sub-task Closed Petr Skoda
        70.
        		 Implement native MS sql server drivers (freetds and sqlsrv) Sub-task Closed Eloy Lafuente (stronk7)
        71.
        		 do not check return value from isert_record and update_record and cleanup unused error messages replaced by new DML exceptions Sub-task Closed Petr Skoda
        72.
        		 Drop enums support Sub-task Closed Eloy Lafuente (stronk7)
        73.
        		 improve db transactions Sub-task Closed Petr Skoda
        74.
        		 remove obsoleted adodb database drivers before 2.0 branching Sub-task Closed Petr Skoda
        75.
        		 Any field operation (drop, rename, change_xxx) must look for field dependencies (indexes, keys...) Sub-task Closed Eloy Lafuente (stronk7)
        76.
        		 Improve PostgreSQL generator code Sub-task Closed Eloy Lafuente (stronk7)
        77.
        		 OCI breaks badly with statement_cache enabled under certain situations Sub-task Closed Eloy Lafuente (stronk7)
        78.
        		 Drop find_sequence_name() function Sub-task Closed Eloy Lafuente (stronk7)
        79.
        		 sql_ilike() refactoring Sub-task Closed Petr Skoda
        80.
        		 raise min Oracle reqs to 10R2 (10.2) Sub-task Closed Eloy Lafuente (stronk7)
        81.
        		 Nested DB transactions Sub-task Closed Eloy Lafuente (stronk7)
        82.
        		 insert/update/set_field expected behaviour is to cast empty string to 0 for numeric columns Sub-task Closed Eloy Lafuente (stronk7)
        83.
        		 On database dispose() check/warn/drop any remaining temp tables... Sub-task Closed Eloy Lafuente (stronk7)
        84.
        		 Control (count) opened recordsets Sub-task Closed Petr Skoda
        85.
        		 new sql_like() should accept parameters and treat case/accent sensitiveness properly Sub-task Closed Petr Skoda
        86.
        		 deprecate $DB->sql_ilike() Sub-task Closed Petr Skoda
        87.
        		 add $DB->sql_not_like() or add parameter to the sql_like() Sub-task Closed Petr Skoda

            stronk7 Eloy Lafuente (stronk7)
            skodak Petr Skoda
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.