ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:dictionary:structure:introduction

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:dictionary:structure:introduction [2016/04/09 21:30] – mnewnhamv5:dictionary:structure:introduction [2021/08/26 10:11] (current) – typos peterdd
Line 4: Line 4:
 **From Version 5.21.0-beta-2** **From Version 5.21.0-beta-2**
 == Reference == == Reference ==
-[[v5:dictionary:structure:addattrbute|addAttribute()]]\\+[[v5:dictionary:structure:addattribute|addAttribute()]]\\
 [[v5:dictionary:structure:addcolumnobject|addColumnObject()]]\\ [[v5:dictionary:structure:addcolumnobject|addColumnObject()]]\\
 [[v5:dictionary:structure:addindexobject|addIndexObject()]]\\ [[v5:dictionary:structure:addindexobject|addIndexObject()]]\\
 [[v5:dictionary:structure:addindexitemobject|addIndexItemObject()]]\\ [[v5:dictionary:structure:addindexitemobject|addIndexItemObject()]]\\
 [[v5:dictionary:structure:setnewname|setNewName()]]\\ [[v5:dictionary:structure:setnewname|setNewName()]]\\
 +[[v5:dictionary:structure:platform|The Platform Keyword]]\\
 +[[v5:dictionary:structure:sample_usage|Sample Usage]]\\
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
 From ADOdb Version 5.21, A new method of managing changes to the schema has been added. This method is called //**Structured**// schema management to signify the more formal method of managing elements. The original method, referred to as //**Simple**//, remains unchanged. From ADOdb Version 5.21, A new method of managing changes to the schema has been added. This method is called //**Structured**// schema management to signify the more formal method of managing elements. The original method, referred to as //**Simple**//, remains unchanged.
  
-In Structured schema management, the elements that can be modified through the dictionary management routines such as [[v5:dictionary:createindexsql|createIndexSql()]],[[v5:dictionary:dropcolumnsql|dropSql()]] and [[v5:dictionary:createtablesql|createtableSql()]] can be created and represented as objects prior to them being passed to the methods that create the SQL necessary to create them in the database. The concept is built on [[v5:axmls:axmls_index|AXMLS]] and contains some feature overlap.+In Structured schema management, the elements that can be modified through the dictionary management routines such as [[v5:dictionary:createindexsql|createIndexSql()]], [[v5:dictionary:dropcolumnsql|dropColumnSql()]] and [[v5:dictionary:createtablesql|createTableSql()]] can be created and represented as objects prior to them being passed to the methods that create the SQL necessary to create them in the database. The concept is built on [[v5:axmls:axmls_index|AXMLS]] and contains some feature overlap.
  
 These objects can then be easily stored through the use of technologies such as JSON, which can easily be manipulated through 3rd party tools and reprocessed.  These objects can then be easily stored through the use of technologies such as JSON, which can easily be manipulated through 3rd party tools and reprocessed. 
  
-Each table, and element of a table (such as a column or index) is represented by a PHP object called a //**metaObjectStructure**//. Each of these objects can store an unlimited number of additional attributes that represent configuration items for the element. The attributes themselves can be defined as platform-specific.+Each table and element of a table (such as a column or index) is represented by a PHP object called a //**metaObjectStructure**//. Each of these objects can store an unlimited number of additional attributes that represent configuration items for the element. The attributes themselves can be defined as platform-specific.
  
 ===== Construction Of The Structure ===== ===== Construction Of The Structure =====
Line 37: Line 39:
  
 The **//platform//** option is available to all level of object definitions, and filters the definition based on the database's data provider. For example, if a table definition were given a platform **mysql**, it would simply be ignored if applied to a PostgreSQL database. The **//platform//** option is available to all level of object definitions, and filters the definition based on the database's data provider. For example, if a table definition were given a platform **mysql**, it would simply be ignored if applied to a PostgreSQL database.
 +
 +===== Processing The MetaObjectStructure =====
 +
 +The structure is not automatically sent to createTableSql, it must be deliberately passed on. This is important because it allows the returned object be to re-used or stored, for example by serializing or JSON-encoding it. Conceivably, a JSON-encoded object could be passed in by a 3rd party application and used.
 +
 +In this example, we create a table 'test' with a single column 'COL1', and extract the structure
 +
 +<code php>
 +$dict = newDataDictionary($db);
 +$t = new metaObjectStructure($dict, 'test');
 +/*
 +* Make sure the table is transactional in MySQL
 +*/
 +$t->addAttribute('ENGINE INNODB', 'mysql');
 +
 +/*
 +* Add the column
 +*/
 +$t->addColumnObject('COL1', 'I');
 +
 +/*
 +* Now get the structure
 +*/
 +print_r($t);
 +</code>
 +
 +The following object is returned:
 +
 +<code>
 +metaObjectStructure Object
 +(
 +    [type] => table
 +    [value] => 
 +    [platform] => 
 +    [options] => Array
 +        (
 +        )
 +    [attributes] => Array
 +        (
 +            [0] => metaElementStructure Object
 +                (
 +                    [type] => table
 +                    [name] => test
 +                    [value] => ENGINE INNODB
 +                    [platform] => mysql
 +                    [action] => 0
 +                    [attributes] => Array
 +                        (
 +                        )
 +                )
 +        )
 +    [name] => test
 +    [action] => 0
 +    [columns] => Array
 +        (
 +            [COL1] => metaObjectStructure Object
 +                (
 +                    [type] => column
 +                    [value] => I
 +                    [platform] => 
 +                    [options] => Array
 +                        (
 +                        )
 +                    [attributes] => Array
 +                        (
 +                        )
 +                    [name] => COL1
 +                    [action] => 0
 +                )
 +        )
 +)
 +</code>
 +
 +We could JSON-encode it here and store it
 +
 +<code php>
 +$j = json_encode($def)
 +/*
 +{"type":"table",
 + "value":"",
 + "platform":"",
 + "options":[],
 + "attributes":[{
 +    "type":"table",
 +    "name":"test",
 +    "value":"ENGINE INNODB",
 +    "platform":"mysql",
 +    "action":0,
 +    "attributes":[]
 +    }],
 +    "name":"test",
 +    "action":0,
 +    "columns":{"COL1":{"type":"column",
 +                       "value":"I",
 +                       "platform":"",
 +                       "options":[],
 +                       "attributes":[],
 +                       "name":"COL1",
 +                       "action":0
 +                       }
 +              }
 +}
 +*/
 +</code>
 +===== Processing The Structure =====
 +A change to ''createTableSql()'' that allows the object to be passed as the first argument is all that is necessary to process the result
 +
 +<code php>
 +
 +$sql = $dict->createTableSql($tabledef);
 +
 +print_r($sql);
 +/*
 +* Returns:
 +Array
 +(
 +    [0] => CREATE TABLE test (
 +           COL1 I
 +          )ENGINE INNODB
 +)
 +*/
 +</code>
 +
v5/dictionary/structure/introduction.1460230235.txt.gz · Last modified: (external edit)