|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.lapetus_ltd._2009.xml.types.XLptsDBCreateTableConstraintType
com.lapetus_ltd.api.db.xml.types.TLptsDBCreateTableConstraintType
public class TLptsDBCreateTableConstraintType
Class Description : This initiates the constraint type for tables of a CREATE statement.
CREATE TABLE `myTable` ( `myTableId` INT, `myName` VARCHAR(50), `mySalary` DECIMAL(10,2), `myInsuranceId` VARCHAR(50), CONSTRAINT id_pk PRIMARY KEY (`myTableId`), CONSTRAINT insuranceId UNIQUE (`myInsuranceId`), CONSTRAINT salary_chk CHECK (`myInsuranceId` > 0.00), CONSTRAINT name_fk FOREIGN KEY (`myName`) REFERENCES `clients` (`FirstName`) )
TLptsStatement createStatement = new TLptsStatement(connection,XLptsDBTypeOfStatementType.CREATE); TLptsDBCreateStatementRootType rootType = new TLptsDBCreateStatementRootType(); rootType.setTitle("root"); TLptsDBCreateStatementTableType table = new TLptsDBCreateStatementTableType(); table.setTable("myTable"); rootType.setTable(table); TLptsDBCreateStatementColumnType myTableID = new TLptsDBCreateStatementColumnType(); myTableID.setColumn("myTableId"); TLptsDBCreateStatementColumnSqlType myTableIdSqlType = new TLptsDBCreateStatementColumnSqlType(myTableID); myTableIdSqlType.setSqlType(java.sql.Types.INTEGER); myTableID.setSqlType(myTableIdSqlType); table.addColumn(myTableID); TLptsDBCreateStatementColumnType myName = new TLptsDBCreateStatementColumnType(); myName.setColumn("myName"); TLptsDBCreateStatementColumnSqlType myNameSqlType = new TLptsDBCreateStatementColumnSqlType(myName); myNameSqlType.setSqlType(java.sql.Types.VARCHAR); myName.setSqlType(myNameSqlType); TLptsDBCreateStatementColumnSizeType myNameSize = new TLptsDBCreateStatementColumnSizeType(myName); myNameSize.setSize1("50"); myName.setSizes(myNameSize); table.addColumn(myName); TLptsDBCreateStatementColumnType mySalary = new TLptsDBCreateStatementColumnType(); mySalary.setColumn("mySalary"); TLptsDBCreateStatementColumnSqlType mySalarySqlType = new TLptsDBCreateStatementColumnSqlType(mySalary); mySalarySqlType.setSqlType(java.sql.Types.DECIMAL); mySalary.setSqlType(mySalarySqlType); TLptsDBCreateStatementColumnSizeType mySalarySize = new TLptsDBCreateStatementColumnSizeType(mySalary); mySalarySize.setSize1("10"); mySalarySize.setSize2("2"); mySalary.setSizes(mySalarySize); table.addColumn(mySalary); TLptsDBCreateStatementColumnType myInsuranceId = new TLptsDBCreateStatementColumnType(); myInsuranceId.setColumn("myInsuranceId"); TLptsDBCreateStatementColumnSqlType myInsuranceIdSqlType = new TLptsDBCreateStatementColumnSqlType(myInsuranceId); myInsuranceIdSqlType.setSqlType(java.sql.Types.VARCHAR); myInsuranceId.setSqlType(myInsuranceIdSqlType); TLptsDBCreateStatementColumnSizeType myInsuranceIdSize = new TLptsDBCreateStatementColumnSizeType(myInsuranceId); myInsuranceIdSize.setSize1("50"); myInsuranceId.setSizes(myInsuranceIdSize); table.addColumn(myInsuranceId); //Table Constraints TLptsDBCreateTableConstraintType primaryCon = new TLptsDBCreateTableConstraintType(); primaryCon.setName("id_pk"); primaryCon.setConstraintType(XLptsDBCreateTableConstraintParameterType.PRIMARY_KEY); primaryCon.setConstraint("(`myTableId`)"); table.addConstraint(primaryCon); TLptsDBCreateTableConstraintType insuranceCon = new TLptsDBCreateTableConstraintType(); insuranceCon.setName("insuranceId"); insuranceCon.setConstraintType(XLptsDBCreateTableConstraintParameterType.UNIQUE); insuranceCon.setConstraint("(`myInsuranceId`)"); table.addConstraint(insuranceCon); TLptsDBCreateTableConstraintType salaryCon = new TLptsDBCreateTableConstraintType(); salaryCon.setName("salary_chk"); salaryCon.setConstraintType(XLptsDBCreateTableConstraintParameterType.CHECK); salaryCon.setConstraint("(`myInsuranceId` > 0.00)"); table.addConstraint(salaryCon); TLptsDBCreateTableConstraintType nameCon = new TLptsDBCreateTableConstraintType(); nameCon.setName("name_fk"); nameCon.setConstraintType(XLptsDBCreateTableConstraintParameterType.FOREIGN_KEY); nameCon.setConstraint("(`myName`)"); nameCon.setReferences("`clients` (`FirstName`)"); table.addConstraint(nameCon); createStatement.setCreateRootItem(rootType);
TLptsStatement.setSqlStatementUser(java.lang.String)
XLptsDBStatementType.setSqlStatementModified(boolean)
to true.
Field Summary |
---|
Fields inherited from class com.lapetus_ltd._2009.xml.types.XLptsDBCreateTableConstraintType |
---|
constraint, constraintType, id, name, references |
Constructor Summary | |
---|---|
TLptsDBCreateTableConstraintType()
This constructor initiates the TableConstraint. |
|
TLptsDBCreateTableConstraintType(XLptsDBCreateTableConstraintType ct)
This constructor copies the tableConstraints information from an XLptsDBCreateTableConstraintType. |
Method Summary | |
---|---|
boolean |
equals(java.lang.Object obj)
Check for equal TLptsDBCreateTableConstraintType objects. |
Methods inherited from class com.lapetus_ltd._2009.xml.types.XLptsDBCreateTableConstraintType |
---|
getConstraint, getConstraintType, getId, getName, getReferences, setConstraint, setConstraintType, setId, setName, setReferences |
Methods inherited from class java.lang.Object |
---|
clone, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public TLptsDBCreateTableConstraintType()
This constructor initiates the TableConstraint.
Thread Safe : Yes
Spawns its own Thread : No
May Return NULL : Never.
Notes : Default Constructor set id, constraintType as PRIMARY_KEY and other variables as empty string.
Example :
TLptsStatement createStatement = new TLptsStatement(connection,XLptsDBTypeOfStatementType.CREATE); TLptsDBCreateStatementRootType rootType = new TLptsDBCreateStatementRootType(); rootType.setTitle("root"); TLptsDBCreateStatementTableType table = new TLptsDBCreateStatementTableType(); table.setTable("newTable"); rootType.setTable(table); TLptsDBCreateStatementTableTemporaryType temporary = new TLptsDBCreateStatementTableTemporaryType(); temporary.setTemporary(true); TLptsDBCreateStatementTableGlobalLocal globalLocal = new TLptsDBCreateStatementTableGlobalLocal(); globalLocal.setGlobalLocal(XLptsDBCreateStatementTableGlobalLocalType.GLOBAL); temporary.setGlobalLocal(globalLocal); table.setTemporary(temporary); ... tableConstraint.setName("foreign_key"); tableConstraint.setConstraintType(XLptsDBCreateTableConstraintParameterType.FOREIGN_KEY); tableConstraint.setConstraint("newTable.newColumn"); tableConstraint.setReferences("foreignTable.column"); table.addConstraint(tableConstraint); TLptsDBCreateStatementTableCommitType commit = new TLptsDBCreateStatementTableCommitType(table); commit.setCommitType(XLptsDBCreateTableCommitType.DELETE); table.setCommitType(commit); ... }
public TLptsDBCreateTableConstraintType(XLptsDBCreateTableConstraintType ct)
This constructor copies the tableConstraints information from an XLptsDBCreateTableConstraintType.
Thread Safe : Yes
Spawns its own Thread : No
May Return NULL : Never.
Notes : Use this function every time you need to copy or instantiate a type XLptsDBCreateTableConstraintType class.
Example :
public void example(XLptsDBCreateTableConstraintType ct) { TLptsDBCreateTableConstraintType tableConstraint = new XLptsDBCreateTableConstraintType(ct); }
ct
- the class object to copy.Method Detail |
---|
public boolean equals(java.lang.Object obj)
Check for equal TLptsDBCreateTableConstraintType objects.
Thread Safe : Yes
Spawns its own Thread : No
May Return NULL : n/a
Notes : Use this to compare two TLptsDBCreateTableConstraintType objects by there id's.
Example :
equals
in class java.lang.Object
obj
- the Table Constraint Type
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |