v5:axmls:axmls_index
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
v5:axmls:axmls_index [2016/01/13 16:11] – mnewnham | v5:axmls:axmls_index [2020/01/13 15:51] – Remove NOTOC dregad | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | <WRPA right box> | + | <WRAP right box> |
[[v5: | [[v5: | ||
</ | </ | ||
======= ADOdb-xmlschema ====== | ======= ADOdb-xmlschema ====== | ||
- | ~~NOTOC~~ | + | ----------------------------------- |
<WRAP right box round 300px> | <WRAP right box round 300px> | ||
==See also== | ==See also== | ||
Line 29: | Line 29: | ||
</ | </ | ||
===== Installation ===== | ===== Installation ===== | ||
- | This feature is included in the standard release | + | This feature is included in the standard release. |
===== Using AXMLS in Your Application ===== | ===== Using AXMLS in Your Application ===== | ||
There are two steps involved in using AXMLS in your application: | There are two steps involved in using AXMLS in your application: | ||
Line 39: | Line 39: | ||
<?xml version=" | <?xml version=" | ||
<schema version=" | <schema version=" | ||
- | |||
<table name=" | <table name=" | ||
- | <desc>A typical users table for our application.</ | + | <descr>A typical users table for our application.</ |
<field name=" | <field name=" | ||
< | < | ||
< | < | ||
< | < | ||
- | </ | + | </ |
- | | + | |
<field name=" | <field name=" | ||
- | | ||
<index name=" | <index name=" | ||
< | < | ||
Line 56: | Line 53: | ||
</ | </ | ||
</ | </ | ||
- | | ||
<sql> | <sql> | ||
< | < | ||
Line 65: | Line 61: | ||
</ | </ | ||
- | Let's take a detailed look at this schema. The opening ''<? | + | Let's take a detailed look at this schema. The opening ''<? |
<code xml> | <code xml> | ||
Line 78: | Line 74: | ||
<code xml> | <code xml> | ||
<table name=" | <table name=" | ||
- | + | | |
- | | + | |
<field name=" | <field name=" | ||
< | < | ||
Line 85: | Line 80: | ||
< | < | ||
</ | </ | ||
- | | ||
<field name=" | <field name=" | ||
- | | ||
</ | </ | ||
</ | </ | ||
Line 93: | Line 86: | ||
This table is called " | This table is called " | ||
- | * The description is optional, and is currently | + | * The description is optional, and is currently only for your own information; |
* The first < | * The first < | ||
* The second < | * The second < | ||
Line 104: | Line 97: | ||
<table name=" | <table name=" | ||
... | ... | ||
- | | ||
<index name=" | <index name=" | ||
< | < | ||
< | < | ||
< | < | ||
- | </ | + | </ |
- | | + | |
</ | </ | ||
</ | </ | ||
Line 122: | Line 113: | ||
<sql> | <sql> | ||
< | < | ||
- | < | + | < |
- | < | + | < |
</ | </ | ||
</ | </ | ||
Line 153: | Line 144: | ||
/* Start by creating a normal ADODB connection. | /* Start by creating a normal ADODB connection. | ||
*/ | */ | ||
- | $db = ADONewConnection( $platform ); | + | $db = ADONewConnection($platform); |
- | $db->Connect( $dbHost, $dbUser, $dbPassword, | + | $db->connect($dbHost, $dbUser, $dbPassword, |
/* Use the database connection to create a new adoSchema object. | /* Use the database connection to create a new adoSchema object. | ||
*/ | */ | ||
- | $schema = new adoSchema( $db ); | + | $schema = new adoSchema($db); |
- | /* Call ParseSchema() to build SQL from the XML schema file. | + | /* Call parseSchema() to build SQL from the XML schema file. |
- | * Then call ExecuteSchema() to apply the resulting SQL to | + | * Then call executeSchema() to apply the resulting SQL to |
* the database. | * the database. | ||
*/ | */ | ||
- | $sql = $schema-> | + | $sql = $schema-> |
- | $result = $schema-> | + | $result = $schema-> |
</ | </ | ||
Line 171: | Line 162: | ||
<code php> | <code php> | ||
- | $db = ADONewConnection( | + | $db = ADONewConnection($platform); |
- | $db->Connect( ' | + | $db->connect($dbHost, $dbUser, $dbPassword, $dbName); |
</ | </ | ||
Line 178: | Line 169: | ||
<code php> | <code php> | ||
- | $schema = new adoSchema( $db ); | + | $schema = new adoSchema($db); |
</ | </ | ||
- | Third, call ParseSchema() to parse the schema and then '' | + | Third, call parseSchema() to parse the schema and then '' |
<code php> | <code php> | ||
- | $schema-> | + | $schema-> |
- | $schema-> | + | $schema-> |
</ | </ | ||
Line 195: | Line 186: | ||
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 [[v5: | + | 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: |
**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. | ||
<code php> | <code php> | ||
- | $schema = new adoSchema( $this-> | + | $schema = new adoSchema($this-> |
// Inline Execution | // Inline Execution | ||
- | $schema-> | + | $schema-> |
- | $schema-> | + | $schema-> |
- | $schema-> | + | $schema-> |
</ | </ | ||
Line 211: | Line 202: | ||
<code php> | <code php> | ||
- | $schema = new adoSchema( $this-> | + | $schema = new adoSchema($this-> |
// Post Execution (default) | // Post Execution (default) | ||
- | $schema-> | + | $schema-> |
- | $schema-> | + | $schema-> |
- | $schema-> | + | $schema-> |
</ | </ | ||
Line 226: | Line 217: | ||
<code php> | <code php> | ||
- | $schema = new adoSchema( $this-> | + | $schema = new adoSchema($this-> |
// Set the prefix for database objects (before parsing) | // Set the prefix for database objects (before parsing) | ||
- | $schema-> | + | $schema-> |
</ | </ | ||
==== Getting at the SQL ==== | ==== Getting at the SQL ==== | ||
Line 236: | Line 227: | ||
<code php> | <code php> | ||
- | $schema-> | + | $schema-> |
$schema-> | $schema-> | ||
- | print( $schema-> | + | print $schema-> |
- | print( $schema-> | + | print $schema-> |
$sql = $schema-> | $sql = $schema-> | ||
// Save SQL to file | // Save SQL to file | ||
- | $schema-> | + | $schema-> |
</ | </ | ||
As always, see the Class Documentation for detailed information about the methods. | As always, see the Class Documentation for detailed information about the methods. |
v5/axmls/axmls_index.txt · Last modified: 2020/01/13 15:52 by dregad