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

          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
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                24/Nov/10