Note:

If you want to create a new page for developers, you should create it on the Moodle Developer Resource site.

DB layer 2.0: Difference between revisions

From MoodleDocs
DB layer 2.0
mNo edit summary
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Work in progress}}
{{Template:Development:dmllib 2.0}}{{Moodle_2.0}}__NOTOC__
{{Template:Development:dmllib 2.0}}
__NOTOC__
== Objectives ==
== Objectives ==


Line 23: Line 21:
* Well documented (PHPDocs + use examples)
* Well documented (PHPDocs + use examples)
* Tasks, bugs and progress tracked in MDL-14679
* Tasks, bugs and progress tracked in MDL-14679
* Due date: June 24th
* Due date: June 24th 2008


== See also ==


 
* [[XMLDB Documentation|XMLDB Documentation]]: where both xmldb and ddl stuff is explained.
== Meetings ==
* [[DDL functions|DDL functions]] - Documentation for all the Data Definition Language (DDL) functions available inside Moodle.
 
* [[DML functions|DML functions]] - Documentation for all the Data Manipulation Language (DML) functions available inside Moodle.
* [http://docs.google.com/Doc?id=dgzf39jp_1gkks3pd3 MDM-20080501 Dmllib 2.0] - Penny, Petr and Eloy.
* [http://docs.google.com/Doc?id=dgzf39jp_5fv3j3jd7 MDM-20080508 Dmllib 2.0] - Penny, Petr, Nicolas and Eloy.
* [http://docs.google.com/Doc?id=dgzf39jp_7tmcr5jc5 MDM-20080513 Dmllib 2.0] - Penny, Petr, Nicolas and Eloy.
* [http://docs.google.com/Doc?id=dgzf39jp_11fdj3jhg8 MDM-20080515 Dmllib 2.0] - Penny, Petr, Nicolas, Martin and Eloy.
* [http://docs.google.com/Doc?id=dgzf39jp_12hmwjmzfq MDM-20080522 Dmllib 2.0] - Penny, Petr, Nicolas, Martin and Eloy.
* MDM-20080526 Dmllib 2.0 - Penny, Petr, Nicolas, Martin and Eloy.
 
== Ideas ==
 
* [http://en.wikipedia.org/wiki/Object-relational_mapping Object Relational Mapping style]
* There are already some PHP ORM tools:
** [http://www.phpdoctrine.org/ Doctrine]
** [http://www.phpobjectgenerator.com/ PHP Object Generator]
** [http://propel.phpdb.org/trac/ Propel]

Latest revision as of 23:32, 25 July 2008

Moodle 2.0


Objectives

  • Switch to prepared statements - using placeholders and preparing statements protects against sql injection
  • Remove the need for data to be add/strip slashed all over the place in the code.
  • Enable easier and productive unit tests.

Requirements

  • 100% cross-db
  • OOP implementation:
    • Full abstraction: Hide underlying libraries (adodb, pdo...) and drivers to Moodle developers completely.
    • Make it so that the database object can be subclassed - this means for unit tests that want to test database access, the test framework can override necessary methods
    • support ? and :param parameter types (independently of the param types supported by each driver).
    • global $DB
    • profiling, logging and exceptions
  • Easy to use (consistent and similar to current dmllib 1.0)
  • Easy to migrate (provide documentation and utilities to help on that)
  • Complete unit testing (self)
  • Easy unit testing (moodle - real and mockup)
  • Well documented (PHPDocs + use examples)
  • Tasks, bugs and progress tracked in MDL-14679
  • Due date: June 24th 2008

See also

  • XMLDB Documentation: where both xmldb and ddl stuff is explained.
  • DDL functions - Documentation for all the Data Definition Language (DDL) functions available inside Moodle.
  • DML functions - Documentation for all the Data Manipulation Language (DML) functions available inside Moodle.
Retrieved from "https://docs.moodle.org/dev/index.php?title=DB_layer_2.0&oldid=8468"
Powered by MediaWiki