public class MySQLStatements extends SQLStatements
SQLStatements.SID
Modifier and Type | Field and Description |
---|---|
protected static String[] |
ALL_TABLES |
protected static String |
TBL_ASSOCIATIONS |
protected static String |
TBL_DICTIONARY |
protected static String |
TBL_NODE_NAMES |
protected static String |
TBL_NODES |
protected static String |
TBL_ONTOLOGIES |
protected static String |
TBL_PREFIX |
Constructor and Description |
---|
MySQLStatements(Connection connection) |
Modifier and Type | Method and Description |
---|---|
String[] |
getSchemaSQLForTable(String table)
Returns a number of SQL statments that create the schema for the given
table.
|
String |
getSQLDropTableIfExists(String table)
Returns the an SQL string that can be used to drop a table with the given
name.
|
String |
getStatementSQL(SQLStatements.SID statementID)
Returns the SQL for the corresponding statement id.
|
String[] |
getTables()
Returns an array containg the names of each table entry.
|
finalizeStatements, getStatement, getStatementDeleteAssociation, getStatementDeleteAssociationsForOntology, getStatementDeleteDictionaryEntriesForOntology, getStatementDeleteDictionaryEntry, getStatementDeleteNodeAssociations, getStatementDeleteNodeID, getStatementDeleteNodeNames, getStatementDeleteNodeNamesForOntology, getStatementDeleteNodesForOntology, getStatementDeleteOntology, getStatementDeleteTableIfExists, getStatementGetInboundAssociations, getStatementGetIsRootNode, getStatementGetNodeExists, getStatementGetNodeNames, getStatementGetOntologies, getStatementGetOntologyByID, getStatementGetOntologyByName, getStatementGetOntologyDate, getStatementGetOutboundAssociations, getStatementGetRootNodes, getStatementGetUndirectedAssociations, getStatementInsertAssociation, getStatementInsertDictionaryEntry, getStatementInsertNodeID, getStatementInsertNodeName, getStatementInsertOntology, getStatementQueryDictionary, getStatementSetOntologyDate
protected static final String TBL_PREFIX
protected static final String TBL_ONTOLOGIES
protected static final String TBL_NODES
protected static final String TBL_NODE_NAMES
protected static final String TBL_ASSOCIATIONS
protected static final String TBL_DICTIONARY
protected static final String[] ALL_TABLES
public MySQLStatements(Connection connection)
public String[] getSchemaSQLForTable(String table)
SQLStatements
getSchemaSQLForTable
in class SQLStatements
table
- is the name of the table for which the schema SQL should be
returned.public String[] getTables()
SQLStatements
getTables
in class SQLStatements
public String getSQLDropTableIfExists(String table)
SQLStatements
getSQLDropTableIfExists
in class SQLStatements
table
- is the table that should be droped.public String getStatementSQL(SQLStatements.SID statementID)
SQLStatements
getStatementSQL
in class SQLStatements
statementID
- is the statement identifier.Copyright (C) 2013, 2014 Raphael Dickfelder, Jan Göpfert, Benjamin Paassen, Andreas Stöckel, licensed under the AGPL v. 3: http://openresearch.cit-ec.de/projects/scie