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

META: DB layer 2.0

    XMLWordPrintable

Details

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

    Description

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

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-17491 Implement native Oracle DML driver

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. MDL-24192 Finish implementation of sqlsrv/mssql drivers

          • Minor - Minor loss of function where workaround is possible
          • Closed
          has been marked as being related by

          Sub-task - Issues are sometimes broken into multiple sub-tasks. MDL-29515 remove deprecated DDL+DML methods and functions

          • Minor - Minor loss of function where workaround is possible
          • Closed

          Improvement - An enhancement to an existing Moodle feature. MDL-6605 switch datalib functions (wherever they are now) to use placeholders

          • Minor - Minor loss of function where workaround is possible
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-15094 M2-M3-M4 Upgrade all code using DML

          • Blocker - Blocks development and/or testing, prevents Moodle from running (applicable to bugs only)
          • Closed
          will be (partly) resolved by

          Task - A task that needs to be completed. Tasks usually refer to work that must be done outside the product. CONTRIB-3451 replace missing field non-standard workarounds in hotpot_restore_record() with new $DB->get_columns()

          • Minor - Minor loss of function where workaround is possible
          • Closed
          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

          Activity

            People

              stronk7 Eloy Lafuente (stronk7)
              skodak Petr Skoda
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                24/Nov/10