v5:axmls:axmls_index
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
v5:axmls:axmls_index [2016/01/13 03:47] – created mnewnham | v5:axmls:axmls_index [2016/01/13 16:11] – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <WRPA right box> | ||
+ | [[v5: | ||
+ | </ | ||
======= ADOdb-xmlschema ====== | ======= ADOdb-xmlschema ====== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
==See also== | ==See also== | ||
- | [[axmls: | + | [[v5:axmls: |
- | [[dictionary: | + | [[v5:dictionary:dictionary_index|The Meta Functions]]\\ |
</ | </ | ||
===== Introduction ===== | ===== Introduction ===== | ||
- | Adodb-xmlschema, | + | Adodb-xmlschema, |
* An XML file contains all of the definitions required to create a table, the associated columns, indexes and constraints. | * An XML file contains all of the definitions required to create a table, the associated columns, indexes and constraints. | ||
- | * The table can be created by processing the XML file with the [[axmls: | + | * The table can be created by processing the XML file with the [[v5:axmls: |
* That XML file can be used **unmodified** against any database supported by ADOdb. | * That XML file can be used **unmodified** against any database supported by ADOdb. | ||
* Any modifications to the table can be enabled by simply modifying the XML file, and re-executing the XML load command. The ADOdb Meta Functions take care of any processing required to apply those changes to the table. | * Any modifications to the table can be enabled by simply modifying the XML file, and re-executing the XML load command. The ADOdb Meta Functions take care of any processing required to apply those changes to the table. | ||
Line 192: | Line 195: | ||
AXMLS consists of two parts: the **schema description**, | AXMLS consists of two parts: the **schema description**, | ||
==== Executing the Schema ==== | ==== Executing the Schema ==== | ||
- | AXMLS provides two different methods for applying the SQL resulting from a parsed schema to the database: **inline execution** and **post execution**. Use the [[axmls: | + | AXMLS provides two different methods for applying the SQL resulting from a parsed schema to the database: **inline execution** and **post execution**. Use the [[v5:axmls: |
**Inline Execution** applies each schema entity to the database immediately after that entity is parsed. I.e., the first table is read from the schema and applied to the database, then the second table, etc. | **Inline Execution** applies each schema entity to the database immediately after that entity is parsed. I.e., the first table is read from the schema and applied to the database, then the second table, etc. | ||
Line 220: | Line 223: | ||
Upgrading a database is as simple as creating one. To upgrade an existing database to a new version of a schema, simply parse and execute the schema as above. AXMLS will automatically upgrade all tables and indices to match those provided in the schema. | Upgrading a database is as simple as creating one. To upgrade an existing database to a new version of a schema, simply parse and execute the schema as above. AXMLS will automatically upgrade all tables and indices to match those provided in the schema. | ||
==== Object Prefixing==== | ==== Object Prefixing==== | ||
- | In a world of pluggable and reusable code, multiple applications often coexist in a single database. Object prefixes allow you to create a namespace for your application. For example, an application called Tackle might want to prefix all its tables and objects with **tackle_** so they' | + | In a world of pluggable and reusable code, multiple applications often coexist in a single database. Object prefixes allow you to create a namespace for your application. For example, an application called Tackle might want to prefix all its tables and objects with **tackle_** so they' |
<code php> | <code php> | ||
Line 230: | Line 233: | ||
==== Getting at the SQL ==== | ==== Getting at the SQL ==== | ||
- | AXMLS provides several tools for accessing the SQL created by the schema parser. Calling [[axmls: | + | AXMLS provides several tools for accessing the SQL created by the schema parser. Calling [[v5:axmls: |
<code php> | <code php> |
v5/axmls/axmls_index.txt · Last modified: 2020/01/13 15:52 by dregad