com.irisel.oms.sql

Class CreateTableQuery

java.lang.Object

com.irisel.util.BaseBean

com.irisel.oms.olapi.beans.XMLBean

com.irisel.oms.sql.Query

com.irisel.oms.sql.CreateTableQuery

All Implemented Interfaces:

XMLBean, java.io.Serializable

public class CreateTableQuery
extends Query

This class is used to generate, store and analyze Create-Table SQL statements. Creation date: (21/10/02 21:17:23)

See Also:

Serialized Form

Field Summary

Fields inherited from class com.irisel.oms.sql.Query

PARAM_PLACEHOLDER

Fields inherited from class com.irisel.oms.olapi.beans.XMLBean

CLASSNAME, CLASSTYPE, DEFAULT_VISIBILITY, NOT_VISIBLE, VISIBLE

Fields inherited from interface com.irisel.util.XMLBean

CSV

Constructor Summary

Constructors

Constructor and Description
CreateTableQuery() Constructor Dummy constructor
CreateTableQuery(Field[] target) Constructor Creation date: (21/10/02 21:54:21)
CreateTableQuery(Field[] target, Filter[][] filters) Constructor Creation date: (21/10/02 21:54:21)
CreateTableQuery(Field[] target, Filter[][][] filters)
CreateTableQuery(Field[] target, Filter[][][] filters, Option[] options)
CreateTableQuery(Field[] target, Filter[][] filters, Option[] options) Constructor Creation date: (21/10/02 21:54:21)
CreateTableQuery(java.lang.String table_name, java.lang.String[] column_names, int[] column_type, int[] column_size, int[] primary_key) Constructor Specific constructor, for this kind of Query-object

Method Summary

Modifier and Type	Method and Description
java.lang.String	toString(boolean parametrized) Returns the query in SQL language

Methods inherited from class com.irisel.oms.sql.Query

addFilter, addFilter, chkDeps, getChilds, getChildsDeep, getDbType, getFilters, getKeyword, getOptions, getTarget, getTargetTables, getTargetTablesText, getTime, getTimestamp, getTimeStr, propagateDbType, setDbType, setException, setFilter, setFilter, setFilters, setFilters, setFilters, setKeyword, setOptions, setTarget, setTarget, toString, whereToString

Methods inherited from class com.irisel.oms.olapi.beans.XMLBean

copyToInstance, export2csv, getComments, getDescId, getGeneratedAt, getGenericAttr, getIcon, getIconName, getId, getLabel, getName, getO, getOrd, getVisibility, isDirty, isEnabled, isErased, isMandatory, isReadOnly, readFromFile, readFromStream, refreshMyLabel, refreshMyLabel, setComments, setDescId, setDirty, setEnabled, setErased, setGeneratedAt, setGenericAttr, setIcon, setIconName, setId, setLabel, setName, setO, setOrd, setVisibility, updateFromInstance, writeToFile, writeToStream, xmlSerialize

Methods inherited from class com.irisel.util.BaseBean

decode64, decode64bin, encode64, encode64bin, readObject, readObject64, toBean, toByteArray, toJSON, toJSONObject, toXML

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CreateTableQuery

public CreateTableQuery(java.lang.String table_name,
                        java.lang.String[] column_names,
                        int[] column_type,
                        int[] column_size,
                        int[] primary_key)

Constructor Specific constructor, for this kind of Query-object

Parameters:

table_name - String

column_names - String[]

column_type - int[]

column_size - int[]

primary_key - int[]

CreateTableQuery

public CreateTableQuery()

Constructor Dummy constructor

CreateTableQuery

public CreateTableQuery(Field[] target)

Constructor Creation date: (21/10/02 21:54:21)

Parameters:

target - com.irisel.oms.sql.Field[]

CreateTableQuery

public CreateTableQuery(Field[] target,
                        Filter[][] filters)

Constructor Creation date: (21/10/02 21:54:21)

Parameters:

target - com.irisel.oms.sql.Field[]

filters - com.irisel.oms.sql.Filter[]

CreateTableQuery

public CreateTableQuery(Field[] target,
                        Filter[][][] filters)

CreateTableQuery

public CreateTableQuery(Field[] target,
                        Filter[][] filters,
                        Option[] options)

Constructor Creation date: (21/10/02 21:54:21)

Parameters:

target - com.irisel.oms.sql.Field[]

filters - com.irisel.oms.sql.Filter[]

options - com.irisel.oms.sql.Option[]

CreateTableQuery

public CreateTableQuery(Field[] target,
                        Filter[][][] filters,
                        Option[] options)

Method Detail

toString

public java.lang.String toString(boolean parametrized)

Description copied from class: Query

Returns the query in SQL language

Specified by:

toString in class Query

Parameters:

parametrized - is ignored

Returns: