aura / sqlschema
Provides facilities to read table names and table columns from a database using PDO.
Installs: 206 393
Dependents: 8
Suggesters: 0
Security: 0
Stars: 41
Watchers: 14
Forks: 14
Open Issues: 5
Requires
- php: >=5.3.0
This package is auto-updated.
Last update: 2024-11-11 04:06:43 UTC
README
Provides facilities to read table names and table columns from a database using a PDO connection.
Foreword
Installation
This library requires PHP 5.3 or later; we recommend using the latest available version of PHP as a matter of principle. It has no userland dependencies.
It is installable and autoloadable via Composer as aura/sqlschema.
Alternatively, download a release or clone this repository, then require or include its autoload.php file.
Quality
To run the unit tests at the command line, issue phpunit
at the package root. (This requires PHPUnit to be available as phpunit
.)
This library attempts to comply with PSR-1, PSR-2, and PSR-4. If you notice compliance oversights, please send a patch via pull request.
Community
To ask questions, provide feedback, or otherwise communicate with the Aura community, please join our Google Group, follow @auraphp on Twitter, or chat with us on #auraphp on Freenode.
Getting Started
Instantiation
Instantiate a driver-specific schema object with a matching PDO instance:
<?php use Aura\SqlSchema\ColumnFactory; use Aura\SqlSchema\MysqlSchema; // for MySQL use Aura\SqlSchema\PgsqlSchema; // for PostgreSQL use Aura\SqlSchema\SqliteSchema; // for Sqlite use Aura\SqlSchema\SqlsrvSchema; // for Microsoft SQL Server use PDO; // a PDO connection $pdo = new PDO(...); // a column definition factory $column_factory = new ColumnFactory(); // the schema discovery object $schema = new MysqlSchema($pdo, $column_factory); ?>
Fetching Table Lists
To get a list of tables in the database, issue fetchTableList()
:
<?php $tables = $schema->fetchTableList(); foreach ($tables as $table) { echo $table . PHP_EOL; } ?>
Fetching Column Information
To get information about the columns in a table, issue fetchTableCols()
:
<?php $cols = $schema->fetchTableCols('table_name'); foreach ($cols as $name => $col) { echo "Column $name is of type " . $col->type . " with a size of " . $col->size . PHP_EOL; } ?>
Each column description is a Column
object with the following properties:
-
name
: (string) The column name -
type
: (string) The column data type. Data types are as reported by the database. -
size
: (int) The column size. -
scale
: (int) The number of decimal places for the column, if any. -
notnull
: (bool) Is the column marked asNOT NULL
? -
default
: (mixed) The default value for the column. Note that sometimes this will benull
if the underlying database is going to set a timestamp automatically. -
autoinc
: (bool) Is the column auto-incremented? -
primary
: (bool) Is the column part of the primary key?