|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.eclipse.datatools.connectivity.sqm.core.rte.fe.GenericDdlBuilder
org.eclipse.datatools.enablement.sybase.ddl.SybaseDdlBuilder
public abstract class SybaseDdlBuilder
Field Summary |
---|
Fields inherited from interface org.eclipse.datatools.enablement.sybase.ddl.ISybaseDdlConstants |
---|
ALTER_PRIVILEGE, ASC, AT, BEGIN, CAST, CHECKOPTION, CLUSTERED, COLUMN, COMMENT, COMMIT, DATABASE, DELETE_PRIVILEGE, DESC, END, END_IF, EQUAL, EVENT, EXEC_PRIVILEGE, EXISTS, EXTERNAL, EXTERNAL_NAME, FILE, FROM, GO, GO_FOR, GRANT, IF, IN, INOUT, INSERT_PRIVILEGE, IS, JAVA, LOCATOR, LOG, MESSAGE, NONCLUSTERED, OUT, OUTPUT, REFERENCE_PRIVILEGE, REFERENCES_PRIVILEGE, REMOVE, RENAME, REVOKE, SELECT_PRIVILEGE, SEMICOLUMN, SP_RENAME, THEN, TO, UPDATE_PRIVILEGE, WITH_GRANT_OPTION, WITH_RECOMPILE |
Constructor Summary | |
---|---|
SybaseDdlBuilder()
|
Method Summary | |
---|---|
java.lang.String[] |
addCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding check constraint clause. |
abstract java.lang.String[] |
addForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
addUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createCatalogs(Catalog catalog,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createDatabase(Database database,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createEvent(Event event,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createTable(BaseTable table,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String |
createTSQLTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames)
|
abstract java.lang.String[] |
createUserDefinedFunction(UserDefinedFunction function,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String[] |
createView(ViewTable table,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
abstract java.lang.String |
dropAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropCatalog(Catalog db,
boolean quoteIdentifiers,
boolean qualifyNames)
|
abstract java.lang.String |
dropCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropDatabase(Database db,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropEvent(Event event,
boolean quoteIdentifiers,
boolean qualifyNames)
|
abstract java.lang.String |
dropForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropFunction(UserDefinedFunction function,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames)
|
abstract java.lang.String |
dropUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
|
abstract java.lang.String |
dropUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames)
DROP VIEW [ owner.]view-name |
org.eclipse.datatools.sqltools.core.DatabaseIdentifier |
getDatabaseIdentifier(org.eclipse.emf.ecore.EObject ojb)
|
java.lang.String |
getIndexKeyColumns(Index index,
boolean quoteIdentifiers)
|
java.lang.String |
getName(org.eclipse.emf.ecore.ENamedElement element,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
getTriggerBody(Trigger trigger)
|
java.lang.String |
getTriggerEvents(Trigger trigger)
|
java.lang.String |
getTSQLParameter(Routine routine,
Parameter p)
Returns the TSQL parameter declaration. |
java.lang.String |
getTSQLParameter(java.lang.String name,
java.lang.String type,
java.lang.String defValue,
java.lang.String mode)
|
java.lang.String[] |
grantPrivilege(Privilege privilege,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Assemble SQL statement to grant privilege. One thing needs to be pointed out is, a privilege instance can be referenced by an instance of AuthorizationIdentifier (The grantor), it can also be contained by an instance of
AuthorizationIdentifier (The grantee). |
java.lang.String |
revokePrivilege(Privilege privilege,
boolean quoteIdentifiers,
boolean qualifyNames)
Assemble SQL statement to revoke privilege. |
Methods inherited from class org.eclipse.datatools.connectivity.sqm.core.rte.fe.GenericDdlBuilder |
---|
addCheckConstraint, addForeignKey, addUniqueConstraint, alterTableAddColumn, createAssertion, createIndex, createProcedure, createSchema, createTable, createTrigger, createUserDefinedFunction, createUserDefinedType, createView, dropAssertion, dropIndex, dropSchema, dropTable, dropTableConstraint, dropTrigger, getEngineeringCallBack, isImplicitConstraint, setEngineeringCallBack |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SybaseDdlBuilder()
Method Detail |
---|
public java.lang.String[] createTable(BaseTable table, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createView(ViewTable table, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createEvent(Event event, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createProcedure(Procedure procedure, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createUserDefinedFunction(UserDefinedFunction function, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createTrigger(Trigger trigger, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createDatabase(Database database, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createCatalogs(Catalog catalog, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createUserDefinedType(UserDefinedType udt, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createAuthorizationId(AuthorizationIdentifier authId, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] createColumn(Column col, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] addUniqueConstraint(UniqueConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String[] addForeignKey(ForeignKey foreignKey, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public abstract java.lang.String dropForeignKey(ForeignKey foreignKey, boolean quoteIdentifiers, boolean qualifyNames)
public abstract java.lang.String dropCheckConstraint(CheckConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames)
public abstract java.lang.String dropUniqueConstraint(UniqueConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames)
public abstract java.lang.String dropUserDefinedType(UserDefinedType udt, boolean quoteIdentifiers, boolean qualifyNames)
dropUserDefinedType
in class GenericDdlBuilder
public abstract java.lang.String dropAuthorizationId(AuthorizationIdentifier authId, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String dropView(ViewTable view, boolean quoteIdentifiers, boolean qualifyNames)
DROP VIEW [ owner.]view-name
dropView
in class GenericDdlBuilder
public java.lang.String dropEvent(Event event, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String dropProcedure(Procedure procedure, boolean quoteIdentifiers, boolean qualifyNames)
dropProcedure
in class GenericDdlBuilder
public java.lang.String dropFunction(UserDefinedFunction function, boolean quoteIdentifiers, boolean qualifyNames)
dropFunction
in class GenericDdlBuilder
public java.lang.String dropColumn(Column col, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String dropCatalog(Catalog db, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String dropDatabase(Database db, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String getName(org.eclipse.emf.ecore.ENamedElement element, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String[] addCheckConstraint(CheckConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
See following SQL Syntax:
alter table [[database.][owner].table_name add {[constraint constraint_name] check (search_condition)}
constraint
- quoteIdentifiers
- qualifyNames
- fullSyntax
-
public java.lang.String[] grantPrivilege(Privilege privilege, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
AuthorizationIdentifier
(The grantor), it can also be contained by an instance of
AuthorizationIdentifier
(The grantee).
In this case, to avoid generating a same grant statement two times, we only generate the statement for a contained privilege.
Syntax:
Adaptive Server Anywhere 9.x
GRANT { ALL [ PRIVILEGES ], ALTER, DELETE, INSERT, REFERENCES [ ( column-name, ... ) ], SELECT [ ( column-name, ... ) ], UPDATE [ ( column-name, ... ) ], } ON [ owner.]table-name TO userid, ... [ WITH GRANT OPTION ] [ FROM userid ]
GRANT EXECUTE ON [ owner.]procedure-name TO userid, ...
Adaptive Server Enterprise 12.5.x & 15.x
grant {all [privileges]| permission_list} on { table_name [(column_list)] | view_name[(column_list)] | stored_procedure_name} to {public | name_list | role_name} [with grant option]
Object permission_list ------------------------------------------------------ Table select, insert, delete, update, references View select, insert, delete, update Column select, update, references Stored procedure executeTODO: For ASE15, there're new types of permissions, I'll do research to find out if we should support them. The "[FROM userid]" sub clause won't be used here.
privilege
- the privilege instancequoteIdentifiers
- the status of "quoted_identifier"qualifyNames
- if qulified name should be usedpublic java.lang.String revokePrivilege(Privilege privilege, boolean quoteIdentifiers, boolean qualifyNames)
REVOKE table-priv, ... ON [ owner.]table-name FROM userid, ... table-priv : ALL [PRIVILEGES] | ALTER | DELETE | INSERT | REFERENCES [ ( column-name, ...) ] | SELECT [ ( column-name, ...) ] | UPDATE [ ( column-name, ...) ]
REVOKE EXECUTE ON [ owner.]procedure-name FROM userid, ...Adaptive Server Enterprise 12.5.x & 15.x
revoke [grant option for] {all [privileges] | permission_list} on { table_name [(column_list)] | view_name [(column_list)] | stored_procedure_name} from {public | name_list | role_name} [cascade]Generally speaking, the "[ALL PRIVILEGES]" won't appear since in system table there is no "[ALL PRIVILEGES]" type.
privilege
- the privilege instancequoteIdentifiers
- the status of "quoted_identifier"qualifyNames
- if qulified name should be usedpublic java.lang.String getTSQLParameter(Routine routine, Parameter p)
routine
- the container of the parameter. Must have containing schema and database.p
-
public java.lang.String getTSQLParameter(java.lang.String name, java.lang.String type, java.lang.String defValue, java.lang.String mode)
public java.lang.String[] createIndex(Index index, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
public java.lang.String getTriggerEvents(Trigger trigger)
public java.lang.String getTriggerBody(Trigger trigger)
public java.lang.String createTSQLTrigger(Trigger trigger, boolean quoteIdentifiers, boolean qualifyNames)
public java.lang.String getIndexKeyColumns(Index index, boolean quoteIdentifiers)
public org.eclipse.datatools.sqltools.core.DatabaseIdentifier getDatabaseIdentifier(org.eclipse.emf.ecore.EObject ojb)
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |