summaryrefslogtreecommitdiff
path: root/odb/relational/oracle/schema.cxx
AgeCommit message (Collapse)AuthorFilesLines
2012-01-26Implement support for database schemaBoris Kolpackov1-9/+11
New pragma qualifier: namespace. New pragma specifier: schema. The table specifier was extended to accept a schema prefix. New option: --default- schema. The common/schema test was extended to cover the new functionality.
2011-11-18Add newlines to the multi-line embedded schema creation statementsBoris Kolpackov1-1/+1
2011-11-17Correct Oracle PL/SQL script generation typoConstantin Michael1-1/+1
2011-10-24Generate database schema from database model instead of C++ modelBoris Kolpackov1-185/+121
We now first create the so-called database model from C++ model and then use that to generate the database schema. The new approach also adds more general support for primary/foreign keys, including multi- column keys. Finally, for MySQL we now generate out-of-line foreign key definitions. Because MySQL does not support deferred constraints checking, deferred foreign keys are written commented out, for documentation.
2011-10-21Add support for const data membersBoris Kolpackov1-1/+2
Const data members are automatically treated as readonly. New test: const-member.
2011-10-21Add schema_file implementation to support schema file header and footer hooksConstantin Michael1-0/+25
2011-10-21Correct generation of Oracle sequences and triggers for auto increment columnsConstantin Michael1-4/+12
2011-10-21Disable generation of inline foreign key constraintsConstantin Michael1-0/+5
2011-10-21Specify all VARCHAR2 and NVARCHAR2 columns as nullableConstantin Michael1-0/+13
Oracle interprets empty VARCHAR2 and NVARCHAR2 strings as NULL. As an empty string is always valid within the C++ context, VARCHAR2 and NVARCHAR2 columns are always specified as nullable.
2011-10-21Cascade constraints when dropping Oracle tablesConstantin Michael1-1/+1
2011-10-21Minimize Oracle schema_emitter implementationConstantin Michael1-14/+4
2011-10-21Specialize schema_emitter for OracleConstantin Michael1-0/+47
SQLPlus scripts are required to indicate PL/SQL block terminations with a trail '/'.
2011-10-21Use the quoted column name of the id member in the auto id trigger bodyConstantin Michael1-1/+1
2011-10-21Use GNU GPL v3 license for ODB compiler filesConstantin Michael1-1/+1
2011-10-21Correct Oracle auto ID trigger implementationConstantin Michael1-4/+6
2011-10-21Compact Oracle drop_table PL/SQL codeConstantin Michael1-10/+4
2011-10-21Add Oracle schema implementationConstantin Michael1-0/+279