Note: You are currently viewing documentation for Moodle 3.3. Up-to-date documentation for the latest stable version of Moodle is probably available here: DML functions.

Development:DML functions: Difference between revisions

From MoodleDocs
mNo edit summary
 
mNo edit summary
Line 1: Line 1:
Starting with Moodle 1.7, an important change has been done to practically all the DB abstraction layer in order to improve the number of RDBMS supported by Moodle.
In this page you'll access to the available functions under Moodle to be able to access to DB data. You should use '''exclusively''' this functions in order to retrieve or modify DB contents because this functions provide an high level of abstraction and guarantee that your DB manipulation will work against different RDBMS.


One of the basic points to achieve this improvement is to have a well-defined group of functions able to handle all the DB structure (DDL statements) using one neutral description, being able to execute the correct SQL statements required by each RDBMS. All these functions are used '''exclusively by the installation and upgrade processes'''.
Where possible, tricks and examples will be documented here in order to make developers's life a bit easier. Of course, feel free to clarify, complete and add more info to all this documentation. It will be welcome, absolutely!
 
In this page you'll see a complete list of such functions, with some explanations, tricks and examples of their use. If you are interested, it's also highly recommendable to take a look to the [[DML functions|DML functions page]] where everything about how to handle DB data (select, insert, update, delete i.e. DML statements) is defined.
 
Of course, feel free to clarify, complete and add more info to all this documentation. It will be welcome, absolutely!


== Main info ==
== Main info ==

Revision as of 16:53, 13 August 2006

In this page you'll access to the available functions under Moodle to be able to access to DB data. You should use exclusively this functions in order to retrieve or modify DB contents because this functions provide an high level of abstraction and guarantee that your DB manipulation will work against different RDBMS.

Where possible, tricks and examples will be documented here in order to make developers's life a bit easier. Of course, feel free to clarify, complete and add more info to all this documentation. It will be welcome, absolutely!

Main info

The functions

See also

  • DDL functions: Where all the functions used to handle DB objects (DDL) are defined.
Retrieved from "https://docs.moodle.org/33/en/index.php?title=Development:DML_functions&oldid=14346"
Powered by MediaWiki