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.
        adodb does not support blob and clob updates with bound parameters Sub-task Closed Petr Skoda (Inactive)
        2.
        pgsql does not support bound parameters in comments Sub-task Closed Petr Skoda (Inactive)
        3.
        pgsql does not support bound queries in field default values Sub-task Closed Petr Skoda (Inactive)
        4.
        some unknown problem in big query (1.5MB) test Sub-task Closed Petr Skoda (Inactive)
        5.
        Use proper placeholders for IN senteces Sub-task Closed Petr Skoda (Inactive)
        6.
        rename xmldb stuff to follow lowercase guidelines Sub-task Closed Eloy Lafuente (stronk7)
        7.
        Installer script is broken Sub-task Closed Petr Skoda (Inactive)
        8.
        prefix check shouldn't be perfomed by moodle_database classes Sub-task Closed Petr Skoda (Inactive)
        9.
        preconfigure_dbconnection() stuff must be implemented in some way Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        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 (Inactive)
        21.
        M2: Normalize results returned from get_tables() get_indexes() and get_columns() Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        24.
        M2-M3-M4 Upgrade all code using DML Sub-task Closed Petr Skoda (Inactive)
        25.
        reset_columns() implementation... Sub-task Closed Petr Skoda (Inactive)
        26.
        Cleanup up deprecated functions so that we do not need to convert them Sub-task Closed Petr Skoda (Inactive)
        27.
        add optional dmllib regex search support Sub-task Closed Petr Skoda (Inactive)
        28.
        add magic quotes stripping option into data_submitted() Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        32.
        M2: adodb sessions switched to moodle sessions Sub-task Closed Petr Skoda (Inactive)
        33.
        M2: implement some workaround for Oracle recordset rewind Sub-task Closed Petr Skoda (Inactive)
        34.
        M2: delete_records should truncate table of delete of all records requested Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        37.
        M4: remove all dependencies on adodb code (except dml itself) Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        41.
        pdo patches from Andrei Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        44.
        M5: Test all sql_xxx() helper functions Sub-task Closed Petr Skoda (Inactive)
        45.
        Named parameters must accept repetitions Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        48.
        Make sql_substr() to accept parameters instead of simply returning function name Sub-task Closed Petr Skoda (Inactive)
        49.
        add new native mysqli dml driver Sub-task Closed Petr Skoda (Inactive)
        50.
        implement exceptions instead of error() and print_error() in ddl, dml and dtl Sub-task Closed Petr Skoda (Inactive)
        51.
        add new native pgsql dml driver Sub-task Closed Petr Skoda (Inactive)
        52.
        move dbpersist option into dboptions Sub-task Closed Petr Skoda (Inactive)
        53.
        implement dml_exceptions in drivers Sub-task Closed Petr Skoda (Inactive)
        54.
        obsolete $CFG->dbfamily Sub-task Closed Petr Skoda (Inactive)
        55.
        implement exceptions in all DML drivers Sub-task Closed Petr Skoda (Inactive)
        56.
        make native drivers default if library not specified in config.php Sub-task Closed Petr Skoda (Inactive)
        57.
        move reset_sequence into dbmanager Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        59.
        postgres native driver, socket connection not working for me Sub-task Closed Petr Skoda (Inactive)
        60.
        implement sql_modulo() method Sub-task Closed Petr Skoda (Inactive)
        61.
        improve dml and ddl unit tests Sub-task Closed Petr Skoda (Inactive)
        62.
        implement caching in get_tables() Sub-task Closed Petr Skoda (Inactive)
        63.
        leading zores are chopped off from strings Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        68.
        M2: logging Sub-task Closed Petr Skoda (Inactive)
        69.
        M2: profiling Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        72.
        Drop enums support Sub-task Closed Eloy Lafuente (stronk7)
        73.
        improve db transactions Sub-task Closed Petr Skoda (Inactive)
        74.
        remove obsoleted adodb database drivers before 2.0 branching Sub-task Closed Petr Skoda (Inactive)
        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 (Inactive)
        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 (Inactive)
        85.
        new sql_like() should accept parameters and treat case/accent sensitiveness properly Sub-task Closed Petr Skoda (Inactive)
        86.
        deprecate $DB->sql_ilike() Sub-task Closed Petr Skoda (Inactive)
        87.
        add $DB->sql_not_like() or add parameter to the sql_like() Sub-task Closed Petr Skoda (Inactive)

            stronk7 Eloy Lafuente (stronk7)
            skodak Petr Skoda (Inactive)
            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.