Package | Description |
---|---|
org.nuxeo.ecm.core.storage.sql.jdbc | |
org.nuxeo.ecm.core.storage.sql.jdbc.db |
Internal API to deal with the database by generating SQL statements.
|
org.nuxeo.ecm.core.storage.sql.jdbc.dialect |
Database
Dialect s implementations;
a Dialect encapsulates knowledge about database-specific behavior. |
org.nuxeo.ecm.directory.sql |
Modifier and Type | Method and Description |
---|---|
static SQLInfo.SQLInfoSelect |
SQLInfo.makeSelect(Table table,
String[] orderBys,
String... freeColumns)
Basic SELECT x, y, z FROM table WHERE a = ? AND b = ?
|
Modifier and Type | Class and Description |
---|---|
class |
TableAlias
An alias for an existing table.
|
class |
TableImpl
The basic implementation of a SQL table.
|
Modifier and Type | Method and Description |
---|---|
Table |
Database.addTable(String name) |
Table |
Column.getForeignTable() |
Table |
TableImpl.getRealTable() |
Table |
TableAlias.getRealTable() |
Table |
Table.getRealTable() |
Table |
Update.getTable() |
Table |
Column.getTable() |
Table |
Database.getTable(String name) |
Modifier and Type | Method and Description |
---|---|
Collection<Table> |
Database.getTables() |
Modifier and Type | Method and Description |
---|---|
void |
Column.setReferences(Table foreignTable,
String foreignKey) |
Constructor and Description |
---|
Column(Column column,
Table table)
Creates a column from an existing column and an aliased table.
|
Column(Table table,
String physicalName,
ColumnType type,
String key)
Creates a new column with the given name and type.
|
Delete(Table table) |
Insert(Table table) |
Select(Table table) |
TableAlias(Table table,
String alias)
Creates a table as an alias for another one.
|
Update(Table table) |
Modifier and Type | Method and Description |
---|---|
void |
DialectPostgreSQL.existingTableDetected(Connection connection,
Table table,
Model model,
Database database) |
void |
Dialect.existingTableDetected(Connection connection,
Table table,
Model model,
Database database)
Called after an existing table has been detected in the database.
|
String |
DialectSQLServer.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectPostgreSQL.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectOracle.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectMySQL.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectHSQLDB.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectH2.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
String |
DialectDerby.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model) |
abstract String |
Dialect.getCreateFulltextIndexSql(String indexName,
String quotedIndexName,
Table table,
List<Column> columns,
Model model)
Gets a CREATE INDEX statement for a fulltext index.
|
List<String> |
DialectPostgreSQL.getPostCreateTableSqls(Table table,
Model model,
Database database) |
List<String> |
Dialect.getPostCreateTableSqls(Table table,
Model model,
Database database)
Gets the sql statements to call after a table has been created.
|
String |
DialectMySQL.getTableTypeString(Table table) |
String |
Dialect.getTableTypeString(Table table) |
boolean |
DialectPostgreSQL.preCreateTable(Connection connection,
Table table,
Model model,
Database database) |
boolean |
Dialect.preCreateTable(Connection connection,
Table table,
Model model,
Database database)
Called before a table is created, when it's been determined that it
doesn't exist yet.
|
Modifier and Type | Method and Description |
---|---|
static Table |
SQLHelper.addTable(String name,
Dialect dialect,
boolean nativeCase) |
Table |
TableReference.getTable() |
Table |
SQLDirectory.getTable() |
Modifier and Type | Method and Description |
---|---|
static Column |
SQLHelper.addColumn(Table table,
String fieldName,
ColumnType type,
boolean nativeCase) |
Column |
SQLStaticFilter.getDirectoryColumn(Table table,
boolean nativeCase) |
Constructor and Description |
---|
SQLHelper(Connection connection,
Table table,
String dataFileName,
char characterSeparator,
String policy) |
SQLHelper(Connection connection,
Table table,
String dataFileName,
String policy) |
Copyright © 2012 Nuxeo SA. All Rights Reserved.