Package x.data.bigquery

Class SkyDataBQSupport

java.lang.Object

x.data.bigquery.SkyDataBQSupport

All Implemented Interfaces:

Serializable, SkyDataEntity

public class SkyDataBQSupport
extends Object
implements Serializable, SkyDataEntity

See Also:

• Serialized Form

Constructor Summary

Constructors

Constructor	Description
SkyDataBQSupport()

Method Summary

Modifier and Type	Method	Description
void	addIndex(String columnName)
SkyDataEntity	and(String entityName, Object entityValue)	Setup with condition for AND.
SkyDataEntity	and(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withOR LIKE flag.
SkyDataEntity	and(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)	Setup and condition IN with 4 parameters.
SkyDataEntity	and(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)	Setup and condition IN with 8 parameters.
SkyDataEntity	and(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup and condition and 2 operations.
SkyDataEntity	and(String entityName, Object entityValue, String operation)	Setup with condition and operation.
SkyDataEntity	asc()	ASC order sort.
void	checkObject()	Check Condition object.
void	clearValue()	Clear value before new call.
static void	connect(String schemaName)	Open SQL SkyDatabase connection.
static void	connect(String schemaName, String entityName)	Open SQL SkyDatabase connection.
void	createIndex()
void	createIndex(String columnName)	Create index by default Model.
void	createTable()	Create table by default Model.
void	delete(XData obj)	Delete default model class data from database.
SkyDataEntity	desc()	ASC order sort.
void	dropTable()	Drop table by default Model.
Collection<XData>	execute()	Return query result relate with setup parameter.
XData	execute1()	Return query result just only one record (first object record).
Collection<XData>	find(String hql)	Find set of default model class data from database by CQL.
Collection<XData>	find(String hql, Object[] args)	Find set of default model class data from database by CQL.
XDataModel	getDataModel()	Check Condition object.
XDataModel	getDataModel(String dataModel)	Check Condition object.
XDataModel	getModel()
String	getName()	Get object name.
boolean	haveDeleteRight()	xxx
boolean	haveReadRight()	xxx
boolean	haveUpdateRight()	xxx
SkyDataEntity	id(Long id)	Set id to SkyDataEntity for load function.
SkyDataEntity	id(String id)	Set id to SkyDataEntity for load function.
SkyDataEntity	in()
SkyDataEntity	in(String dataModelName)	xxx
SkyDataEntity	in(SCIn in)	xxx
SkyDataEntity	index(String indexName)	Setup Index object.
Iterable<String>	listTables()
XData	load()	Load default model class data from database relate with setup id.
XData	load(Long id)	Load any model class data from database.
XData	load(String id)	Load any model class data from database.
SkyDataEntity	loadAll()	loadAll.
SkyDataEntity	max(int i)	Set max result.
SkyDataEntity	model(String dataModelName)	Get Data Model
SkyDataEntity	modelx(String dataModelName)	Get System Data Model
SkyDataEntity	or(String entityName, Object entityValue)	Setup with condition for OR.
SkyDataEntity	or(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withOR LIKE flag.
SkyDataEntity	or(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)	Setup or condition IN with 4 parameters.
SkyDataEntity	or(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)	Setup with condition IN with 8 parameters.
SkyDataEntity	or(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup or condition and 2 operations.
SkyDataEntity	or(String entityName, Object entityValue, String operation)	Setup with condition and operation OR.
SkyDataEntity	order(String entityName)	Setup order condition.
SkyDataEntity	q(String likeCondition)	Query Like Condition.
SkyDataEntity	qlike(String likeCondition)	Query Like Condition.
String	queryString()	Return query string.
void	reset()	Clear value before new call.
void	save(XData obj)	Save default model class data to database.
SkyDataEntity	select(String selectObject)	Setup select object. !!!!!!!!!!
SkyDataEntity	sort(String sortType)	Setup sort type.
SkyDataEntity	sys()	xxx
SkyDataEntity	with(String entityName, Object entityValue)	Setup with 2 condition.
SkyDataEntity	with(String entityName, Object entityValue, Boolean likeFlag)	Setup with 3 condition with LIKE flag.
SkyDataEntity	with(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)	Setup with condition IN with 4 parameters.
SkyDataEntity	with(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)	Setup with condition IN with 8 parameters.
SkyDataEntity	with(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup with 4 condition and 2 operations.
SkyDataEntity	with(String entityName, Object entityValue, String operation)	Setup with 3 condition and operation.
SkyDataEntity	withAND(String entityName, Object entityValue)	Setup with condition for AND.
SkyDataEntity	withAND(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withOR LIKE flag.
SkyDataEntity	withAND(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)	Setup withAND condition IN with 4 parameters.
SkyDataEntity	withAND(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)	Setup withAND condition IN with 8 parameters.
SkyDataEntity	withAND(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup withAND condition and 2 operations.
SkyDataEntity	withAND(String entityName, Object entityValue, String operation)	Setup with condition and operation withAND.
SkyDataEntity	withOR(String entityName, Object entityValue)	Setup with condition for OR.
SkyDataEntity	withOR(String entityName, Object entityValue, Boolean likeFlag)	Setup with condition withOR LIKE flag.
SkyDataEntity	withOR(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4)	Setup withOR condition IN with 4 parameters.
SkyDataEntity	withOR(String entityName, Object entityValue1, Object entityValue2, Object entityValue3, Object entityValue4, Object entityValue5, Object entityValue6, Object entityValue7, Object entityValue8)	Setup withOR condition IN with 8 parameters.
SkyDataEntity	withOR(String entityName, Object entityValue1, Object entityValue2, String operation)	Setup withOR condition and 2 operations.
SkyDataEntity	withOR(String entityName, Object entityValue, String operation)	Setup with condition and operation withOR.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SkyDataBQSupport

public SkyDataBQSupport()

Method Details

save

public void save(XData obj)
          throws Exception

Save default model class data to database.

Specified by:

save in interface SkyDataEntity

Throws:

Exception

delete

public void delete(XData obj)
            throws Exception

Delete default model class data from database.

Specified by:

delete in interface SkyDataEntity

Throws:

Exception

load

public XData load(Long id)
           throws Exception

Load any model class data from database.

Specified by:

load in interface SkyDataEntity

Throws:

Exception

load

public XData load(String id)
           throws Exception

Load any model class data from database.

Specified by:

load in interface SkyDataEntity

Throws:

Exception

find

public Collection<XData> find(String hql)
                       throws Exception

Find set of default model class data from database by CQL.

Specified by:

find in interface SkyDataEntity

Throws:

Exception

find

public Collection<XData> find(String hql,
 Object[] args)
                       throws Exception

Find set of default model class data from database by CQL.

Specified by:

find in interface SkyDataEntity

Throws:

Exception

max

public SkyDataEntity max(int i)
                  throws Exception

Set max result.

Specified by:

max in interface SkyDataEntity

Throws:

Exception

checkObject

public void checkObject()
                 throws Exception

Check Condition object.

Throws:

Exception

getDataModel

public XDataModel getDataModel()
                        throws Exception

Check Condition object.

Throws:

Exception

getDataModel

public XDataModel getDataModel(String dataModel)
                        throws Exception

Check Condition object.

Throws:

Exception

select

public SkyDataEntity select(String selectObject)
                     throws Exception

Setup select object. !!!!!!!!!! In QueryRequest CAN'T USE select method

Specified by:

select in interface SkyDataEntity

Throws:

Exception

index

public SkyDataEntity index(String indexName)
                    throws Exception

Setup Index object.

Specified by:

index in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue)
                   throws Exception

Setup with 2 condition. Create DynamoDB Query Form Equal Compare AttributesNames = #entityName,entityName AttributeValues = :entityName,entityValue Expression = #entityName=:entityName (and #entityName=:entityName)

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue,
 Boolean likeFlag)
                   throws Exception

Setup with 3 condition with LIKE flag. Create DynamoDB Query Form Like Compare AttributesNames = #entityName,entityName AttributeValues = :entityName,entityValue Expression Not Like = #entityNam=:entityNam (and #entityName=:entityNam) Begin Like = begins_with(#entityNam, :entityNam) (and begins_with(#entityNam, :entityNam)) Contain Like = contains(#entityNam, :entityNam) (and contains(#entityNam, :entityNam))

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue,
 String operation)
                   throws Exception

Setup with 3 condition and operation. Create DynamoDB Query Form Operation Compare

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                   throws Exception

Setup with 4 condition and 2 operations. Create DynamoDB Query Form 2 Entity Compare (Between) AttributesNames = #entityName,entityName AttributeValues = :entityName1=entityValue1, :entityName2=entityValue2 Expression = #entityName between :entityName1 and :entityName2 (and #entityName between :entityName1 and :entityName2)

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                   throws Exception

Setup with condition IN with 4 parameters. Create DynamoDB Query Form 4 Value exist (In) AttributesNames = #entityName,entityName AttributeValues = :entityName1=entityValue1, :entityName2=entityValue2, :entityName3=entityValue3, :entityName4=entityValue4 Expression = #entityName in(:entityName1, :entityName2, :entityName3, :entityName4) (and in(:entityName1, :entityName2, :entityName3, :entityName4))

Specified by:

with in interface SkyDataEntity

Throws:

Exception

with

public SkyDataEntity with(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                   throws Exception

Setup with condition IN with 8 parameters. Create DynamoDB Query Form 8 Value exist (In) AttributesNames = #entityName,entityName AttributeValues = :entityName1=entityValue1, :entityName2=entityValue2, :entityName3=entityValue3, :entityName4=entityValue4 Expression = #entityName in(:entityName1, :entityName2, :entityName3, :entityName4) (and in(:entityName1, :entityName2, :entityName3, :entityName4))

Specified by:

with in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue)
                     throws Exception

Setup with condition for OR.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue)
                 throws Exception

Setup with condition for OR.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue,
 Boolean likeFlag)
                     throws Exception

Setup with condition withOR LIKE flag.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue,
 Boolean likeFlag)
                 throws Exception

Setup with condition withOR LIKE flag.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue,
 String operation)
                     throws Exception

Setup with condition and operation withOR.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue,
 String operation)
                 throws Exception

Setup with condition and operation OR.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                     throws Exception

Setup withOR condition and 2 operations.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                 throws Exception

Setup or condition and 2 operations.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                     throws Exception

Setup withOR condition IN with 4 parameters.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                 throws Exception

Setup or condition IN with 4 parameters.

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withOR

public SkyDataEntity withOR(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                     throws Exception

Setup withOR condition IN with 8 parameters.

Specified by:

withOR in interface SkyDataEntity

Throws:

Exception

or

public SkyDataEntity or(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                 throws Exception

Setup with condition IN with 8 parameters. Create DynamoDB Query Form 8 Value exist (In) AttributesNames = #entityName,entityName AttributeValues = :entityName1=entityValue1, :entityName2=entityValue2, :entityName3=entityValue3, :entityName4=entityValue4 Expression = #entityName in(:entityName1, :entityName2, :entityName3, :entityName4) (and in(:entityName1, :entityName2, :entityName3, :entityName4))

Specified by:

or in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue)
                      throws Exception

Setup with condition for AND.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue)
                  throws Exception

Setup with condition for AND.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue,
 Boolean likeFlag)
                      throws Exception

Setup with condition withOR LIKE flag.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue,
 Boolean likeFlag)
                  throws Exception

Setup with condition withOR LIKE flag.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue,
 String operation)
                      throws Exception

Setup with condition and operation withAND.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue,
 String operation)
                  throws Exception

Setup with condition and operation.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                      throws Exception

Setup withAND condition and 2 operations.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue1,
 Object entityValue2,
 String operation)
                  throws Exception

Setup and condition and 2 operations.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                      throws Exception

Setup withAND condition IN with 4 parameters.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4)
                  throws Exception

Setup and condition IN with 4 parameters.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

withAND

public SkyDataEntity withAND(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                      throws Exception

Setup withAND condition IN with 8 parameters.

Specified by:

withAND in interface SkyDataEntity

Throws:

Exception

and

public SkyDataEntity and(String entityName,
 Object entityValue1,
 Object entityValue2,
 Object entityValue3,
 Object entityValue4,
 Object entityValue5,
 Object entityValue6,
 Object entityValue7,
 Object entityValue8)
                  throws Exception

Setup and condition IN with 8 parameters.

Specified by:

and in interface SkyDataEntity

Throws:

Exception

order

public SkyDataEntity order(String entityName)
                    throws Exception

Setup order condition.

Specified by:

order in interface SkyDataEntity

Throws:

Exception

q

public SkyDataEntity q(String likeCondition)
                throws Exception

Query Like Condition.

Specified by:

q in interface SkyDataEntity

Throws:

Exception

qlike

public SkyDataEntity qlike(String likeCondition)
                    throws Exception

Query Like Condition.

Specified by:

qlike in interface SkyDataEntity

Throws:

Exception

sort

public SkyDataEntity sort(String sortType)
                   throws Exception

Setup sort type.

Specified by:

sort in interface SkyDataEntity

Throws:

Exception

asc

public SkyDataEntity asc()
                  throws Exception

ASC order sort.

Specified by:

asc in interface SkyDataEntity

Throws:

Exception

desc

public SkyDataEntity desc()
                   throws Exception

ASC order sort.

Specified by:

desc in interface SkyDataEntity

Throws:

Exception

loadAll

public SkyDataEntity loadAll()
                      throws Exception

loadAll.

Specified by:

loadAll in interface SkyDataEntity

Throws:

Exception

execute

public Collection<XData> execute()
                          throws Exception

Return query result relate with setup parameter.

Specified by:

execute in interface SkyDataEntity

Throws:

Exception

execute1

public XData execute1()
               throws Exception

Return query result just only one record (first object record).

Specified by:

execute1 in interface SkyDataEntity

Throws:

Exception

queryString

public String queryString()
                   throws Exception

Return query string.

Specified by:

queryString in interface SkyDataEntity

Throws:

Exception

clearValue

public void clearValue()

Clear value before new call.

reset

public void reset()

Clear value before new call.

Specified by:

reset in interface SkyDataEntity

createTable

public void createTable()
                 throws Exception

Create table by default Model.

Specified by:

createTable in interface SkyDataEntity

Throws:

Exception

createIndex

public void createIndex(String columnName)
                 throws Exception

Create index by default Model.

Throws:

Exception

dropTable

public void dropTable()
               throws Exception

Drop table by default Model.

Specified by:

dropTable in interface SkyDataEntity

Throws:

Exception

in

public SkyDataEntity in()

Specified by:

in in interface SkyDataEntity

in

public SkyDataEntity in(String dataModelName)

xxx

modelx

public SkyDataEntity modelx(String dataModelName)

Get System Data Model

Specified by:

modelx in interface SkyDataEntity

model

public SkyDataEntity model(String dataModelName)

Get Data Model

Specified by:

model in interface SkyDataEntity

getModel

public XDataModel getModel()
                    throws Exception

Specified by:

getModel in interface SkyDataEntity

Throws:

Exception

in

public SkyDataEntity in(SCIn in)

xxx

Specified by:

in in interface SkyDataEntity

sys

public SkyDataEntity sys()

xxx

Specified by:

sys in interface SkyDataEntity

id

public SkyDataEntity id(Long id)
                 throws Exception

Set id to SkyDataEntity for load function.

Specified by:

id in interface SkyDataEntity

Throws:

Exception

id

public SkyDataEntity id(String id)
                 throws Exception

Set id to SkyDataEntity for load function.

Specified by:

id in interface SkyDataEntity

Throws:

Exception

load

public XData load()
           throws Exception

Load default model class data from database relate with setup id.

Specified by:

load in interface SkyDataEntity

Throws:

Exception

getName

public String getName()
               throws Exception

Get object name.

Throws:

Exception

haveReadRight

public boolean haveReadRight()

xxx

haveUpdateRight

public boolean haveUpdateRight()

xxx

haveDeleteRight

public boolean haveDeleteRight()

xxx

createIndex

public void createIndex()
                 throws Exception

Specified by:

createIndex in interface SkyDataEntity

Throws:

Exception

addIndex

public void addIndex(String columnName)
              throws Exception

Specified by:

addIndex in interface SkyDataEntity

Throws:

Exception

connect

public static void connect(String schemaName)

Open SQL SkyDatabase connection.

connect

public static void connect(String schemaName,
 String entityName)

Open SQL SkyDatabase connection.

listTables

public Iterable<String> listTables()
                            throws Exception

Specified by:

listTables in interface SkyDataEntity

Throws:

Exception