See DBIx::DBSchema::DBD, "Driver Writer's Guide and Base Class". Assistance adding support for other databases is welcomed. DBIx::DBSchema will attempt to use generic SQL syntax for other databases. Sybase and Oracle drivers are partially implemented. You can transform one schema to another, adding any necessary new columns, tables, indices and foreign keys.Ĭurrently supported databases are MySQL, PostgreSQL and SQLite. You can write SQL CREATE statements statements for different databases from a single source. You can save the schema to disk and restore it in a different process. You can read the schema from an existing database. Using this module, you can create a database schema with an OO Perl interface. This module implements an OO-interface to database schemas. Use DBI qw(:sql_types) $schema = pretty_read DBIx::DBSchema \%hash DESCRIPTIONĭBIx::DBSchema objects are collections of DBIx::DBSchema::Table objects and represent a database schema. $DBIx_DBSchema_table_object = $schema->sql($dsn, $username, = $schema->sql($dsn) #doesn't connect to database - less reliable $schema = load DBIx::DBSchema "filename" or die = $schema->tables $schema = new_native DBIx::DBSchema $dsn, $user, $pass $schema = new_native DBIx::DBSchema $dbh $schema = new_odbc DBIx::DBSchema $dsn, $user, $pass $schema = new DBIx::DBSchema = new_odbc DBIx::DBSchema $dbh DBIx::DBSchema - Database-independent schema objects SYNOPSIS use DBIx::DBSchema
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |