|
||||||||||
| 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
org.eclipse.datatools.enablement.ase.ddl.SybaseASEDdlBuilder
public class SybaseASEDdlBuilder
| Field Summary | |
|---|---|
static java.lang.String |
ASE_PROCEDURE_WITH_TEMP_TABLE_ANNOTATION
|
static java.lang.String |
ASE_PROCEDURE_WITH_TEMP_TABLE_NAME
|
static java.lang.String |
PATTERN
|
| 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, THEN, TO, UPDATE_PRIVILEGE, WITH_GRANT_OPTION, WITH_RECOMPILE |
| Method Summary | |
|---|---|
java.lang.String[] |
addCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding check constraint clause. |
java.lang.String[] |
addForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding foreign key clause. |
java.lang.String[] |
addUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding unique constraint/primary key clause. |
java.lang.String[] |
createAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
sp_adduser loginame [, name_in_db [, grpname]] sp_addgroup grpname sp_changegroup grpname, username |
java.lang.String |
createBoundDefault(Column col,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createCatalogs(Catalog catalog,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String |
createColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String[] |
createColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
alter table [[database.][owner].table_name add column_name datatype [default {constant_expression | user | null}] {identity | null | not null} [off row | in row] |
java.lang.String[] |
createDatabase(Database database,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createDefault(SybaseASEDefault aseDefault,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for creating default. |
java.lang.String[] |
createEvent(Event event,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createProcedureBody(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
TSQL procedure: |
java.lang.String[] |
createProcedureObject(java.lang.String body,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
add temp table creation support for stored procedure and trigger |
java.lang.String[] |
createRule(SybaseASERule aseRule,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for creating rule. |
java.lang.String[] |
createSegment(SybaseASESegment segment,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
sp_addsegment segname, dbname, devname sp_extendsegment segname, dbname, devname |
java.lang.String[] |
createTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
create trigger [owner .]trigger_name on [owner .]table_name for {insert , update , delete} as SQL_statements |
java.lang.String[] |
createUserDefinedFunction(UserDefinedFunction function,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
create function [owner.]sql_function_name ( [ sql_parameter_name sql_datatype [( length)| (precision[, scale ]) ] [ [, sql_parameter_name sql_datatype [( length )| ( precision[, scale ]) ]] ... |
java.lang.String[] |
createUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for creating user defined type. |
java.lang.String[] |
createView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE VIEW [ owner.]view-name [ ( column-name, . |
java.lang.String[] |
createWebServiceTable(SybaseASEWebServiceTable ws,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for creating a webservice table. |
java.lang.String |
dropAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames)
sp_dropuser name_in_db sp_dropgroup grpname |
java.lang.String |
dropCatalog(Catalog db,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropDefault(SybaseASEDefault aseDefault,
boolean quoteIdentifiers,
boolean qualifyNames)
Returns the SQL Statement for droping default. |
java.lang.String |
dropForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropRule(SybaseASERule aseRule,
boolean quoteIdentifiers,
boolean qualifyNames)
Returns the SQL Statement for droping rule. |
java.lang.String |
dropSegment(SybaseASESegment segment,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropTable(BaseTable table,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames)
Returns the SQL Statement for droping user defined type. |
java.lang.String |
dropView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames)
DROP VIEW [ owner.]view-name |
java.lang.String |
dropWebServiceTable(SybaseASEWebServiceTable ws,
boolean quoteIdentifiers,
boolean qualifyNames)
Returns the SQL Statement for droping a webservice table. |
java.lang.String |
getIndexKeyColumns(Index index,
boolean quoteIdentifiers)
|
static SybaseDdlBuilder |
getInstance()
|
java.lang.String |
getName(org.eclipse.emf.ecore.ENamedElement element,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
getName(Table table,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.util.List |
getRuleBindingStmt(BaseTable table,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
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.enablement.sybase.ddl.SybaseDdlBuilder |
|---|
createTable, createTSQLTrigger, dropColumn, dropDatabase, dropEvent, dropFunction, getDatabaseIdentifier, getTriggerBody, getTriggerEvents, getTSQLParameter, getTSQLParameter |
| 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, dropSchema, dropTableConstraint, getEngineeringCallBack, isImplicitConstraint, setEngineeringCallBack |
| Methods inherited from class java.lang.Object |
|---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Field Detail |
|---|
public static final java.lang.String ASE_PROCEDURE_WITH_TEMP_TABLE_ANNOTATION
public static final java.lang.String ASE_PROCEDURE_WITH_TEMP_TABLE_NAME
public static final java.lang.String PATTERN
| Method Detail |
|---|
public java.lang.String dropIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames)
dropIndex in class GenericDdlBuilderpublic static SybaseDdlBuilder getInstance()
public java.lang.String[] createCatalogs(Catalog catalog,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
createCatalogs in class SybaseDdlBuilder
public java.lang.String[] createDatabase(Database database,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
createDatabase in class SybaseDdlBuilder
public java.lang.String[] createUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
See following SQL Syntax:
sp_addtype typename,
phystype [(length) | (precision [, scale])]
[, "identity" | nulltype]
sp_bindefault defname, objname [, futureonly]
sp_bindrule rulename, objname [, futureonly]
createUserDefinedType in class SybaseDdlBuilderaseUDT - quoteIdentifiers - qualifyNames - fullSyntax -
public java.lang.String[] createDefault(SybaseASEDefault aseDefault,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
See following SQL Syntax:
create default [owner.]default_name
as constant_expression
aseDefault - quoteIdentifiers - qualifyNames - fullSyntax -
public java.lang.String[] createRule(SybaseASERule aseRule,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
See following SQL Syntax:
create [ [ and | or ] access]] rule
[owner.]rule_name
as condition_expression
aseRule - quoteIdentifiers - qualifyNames - fullSyntax -
public java.lang.String[] createProcedureBody(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
create procedure [owner.]procedure_name[;number]
[[(]@parameter_name
datatype [(length ) | (precision [, scale ])]
[= default][output]
[, @parameter_name
datatype [(length ) | (precision [, scale ])]
[= default][output]]...[)]]
[with recompile]
as {SQL_statements | external name dll_name}
SQLJ
[modifies sql data ]
[dynamic result sets integer]
[deterministic | not deterministic]
language java
parameter style java
external name 'java_method_name
[ ( [java_datatype[, java_datatype
...]] ) ]'
public java.lang.String[] createProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
createProcedure in class SybaseDdlBuilder
public java.lang.String[] createProcedureObject(java.lang.String body,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
public java.lang.String[] createUserDefinedFunction(UserDefinedFunction function,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
create function [owner.]sql_function_name
( [ sql_parameter_name sql_datatype
[( length)| (precision[, scale ]) ]
[ [, sql_parameter_name sql_datatype
[( length )| ( precision[, scale ]) ]]
... ] ] )
returns sql_datatype
[ ( length)| (precision[, scale ]) ]
[modifies sql data]
[returns null on null input |
called on null input]
[deterministic | not deterministic]
[exportable]
language java
parameter style java
external name 'java_method_name
[ ( [java_datatype[, java_datatype
...] ] ) ] '
createUserDefinedFunction in class SybaseDdlBuilder
public java.lang.String[] createTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
create trigger [owner .]trigger_name
on [owner .]table_name
for {insert , update , delete}
as SQL_statements
createTrigger in class SybaseDdlBuilder
public java.lang.String[] createEvent(Event event,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
createEvent in class SybaseDdlBuilder
public java.util.List getRuleBindingStmt(BaseTable table,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
public java.lang.String[] grantPrivilege(Privilege privilege,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
SybaseDdlBuilderAuthorizationIdentifier (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 execute
TODO: 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.
grantPrivilege in class SybaseDdlBuilderprivilege - the privilege instancequoteIdentifiers - the status of "quoted_identifier"qualifyNames - if qulified name should be used
public java.lang.String revokePrivilege(Privilege privilege,
boolean quoteIdentifiers,
boolean qualifyNames)
SybaseDdlBuilder
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.
revokePrivilege in class SybaseDdlBuilderprivilege - the privilege instancequoteIdentifiers - the status of "quoted_identifier"qualifyNames - if qulified name should be used
public java.lang.String[] addUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
See following SQL Syntax:
alter table [[database.][owner].table_name
add {[constraint constraint_name]
{ unique | primary key}
[clustered | nonclustered]
(column_name [asc | desc]
[, column_name [asc | desc]...])
[with { fillfactor = pct,
max_rows_per_page = num_rows,
reservepagegap = num_pages}]
[on segment_name]
addUniqueConstraint in class SybaseDdlBuilderconstraint - quoteIdentifiers - qualifyNames - fullSyntax -
public java.lang.String[] addForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
See following SQL Syntax:
alter table [[database.][owner].table_name
add {[constraint constraint_name]
foreign key (column_name [{, column_name}...])
references [[database.]owner.]ref_table
[(ref_column [{, ref_column}...])]
[match full]
addForeignKey in class SybaseDdlBuilderconstraint - quoteIdentifiers - qualifyNames - fullSyntax -
public java.lang.String[] createIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
createIndex in class SybaseDdlBuilder
public java.lang.String[] createView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE VIEW
[ owner.]view-name [ ( column-name, . . . ) ]
AS select [distinct]select-statement
[ WITH CHECK OPTION ]
createView in class SybaseDdlBuilder
public java.lang.String[] createWebServiceTable(SybaseASEWebServiceTable ws,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
See following SQL Syntax:
sp_webservices 'add','wsdl_uri'[,sds_name] [,'method_name=proxy_table' [,method_name=proxy_table]*']
ws - quoteIdentifiers - qualifyNames -
public java.lang.String dropWebServiceTable(SybaseASEWebServiceTable ws,
boolean quoteIdentifiers,
boolean qualifyNames)
See following SQL Syntax:
sp_webservices 'remove','wsdl_uri'[,sds_name]
ws - quoteIdentifiers - qualifyNames -
public java.lang.String dropCatalog(Catalog db,
boolean quoteIdentifiers,
boolean qualifyNames)
dropCatalog in class SybaseDdlBuilder
public java.lang.String dropProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames)
dropProcedure in class SybaseDdlBuilder
public java.lang.String dropUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames)
See following SQL Syntax:
sp_droptype typename
dropUserDefinedType in class SybaseDdlBuilderaseUDT - quoteIdentifiers - qualifyNames -
public java.lang.String dropDefault(SybaseASEDefault aseDefault,
boolean quoteIdentifiers,
boolean qualifyNames)
See following SQL Syntax:
drop default [owner.]default_name
[, [owner.]default_name] ...
aseDefault - quoteIdentifiers - qualifyNames -
public java.lang.String dropRule(SybaseASERule aseRule,
boolean quoteIdentifiers,
boolean qualifyNames)
See following SQL Syntax:
drop rule [owner.]rule_name [, [owner.]rule_name] ...
aseRule - quoteIdentifiers - qualifyNames -
public java.lang.String dropTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames)
dropTrigger in class GenericDdlBuilder
public java.lang.String dropTable(BaseTable table,
boolean quoteIdentifiers,
boolean qualifyNames)
dropTable in class GenericDdlBuilder
public java.lang.String dropView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames)
SybaseDdlBuilder
DROP VIEW
[ owner.]view-name
dropView in class SybaseDdlBuilder
public java.lang.String createColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames)
public java.lang.String dropForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames)
dropForeignKey in class SybaseDdlBuilder
public java.lang.String dropCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
dropCheckConstraint in class SybaseDdlBuilder
public java.lang.String dropUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
dropUniqueConstraint in class SybaseDdlBuilder
public java.lang.String getName(org.eclipse.emf.ecore.ENamedElement element,
boolean quoteIdentifiers,
boolean qualifyNames)
getName in class SybaseDdlBuilder
public java.lang.String getName(Table table,
boolean quoteIdentifiers,
boolean qualifyNames)
public java.lang.String[] createAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
sp_adduser loginame [, name_in_db [, grpname]] sp_addgroup grpname sp_changegroup grpname, username
createAuthorizationId in class SybaseDdlBuilder
public java.lang.String[] createColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
alter table [[database.][owner].table_name
add column_name
datatype
[default {constant_expression | user | null}]
{identity | null | not null}
[off row | in row]
createColumn in class SybaseDdlBuilder
public java.lang.String createBoundDefault(Column col,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
public java.lang.String dropAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames)
sp_dropuser name_in_db sp_dropgroup grpname
dropAuthorizationId in class SybaseDdlBuilder
public java.lang.String[] createSegment(SybaseASESegment segment,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
sp_addsegment segname, dbname, devname sp_extendsegment segname, dbname, devname
public java.lang.String dropSegment(SybaseASESegment segment,
boolean quoteIdentifiers,
boolean qualifyNames)
public java.lang.String getIndexKeyColumns(Index index,
boolean quoteIdentifiers)
getIndexKeyColumns in class SybaseDdlBuilder
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)}
addCheckConstraint in class SybaseDdlBuilderconstraint - quoteIdentifiers - qualifyNames - fullSyntax -
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||