Update of /cvsroot/babeldoc/babeldoc/modules/sql/build/sql/sql
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv12751/modules/sql/build/sql/sql
Added Files:
config.properties query.properties
Log Message:
Minor update
--- NEW FILE: query.properties ---
tableKeyGet=select key_val from table_key where key_table_name = ?
tableKeyUpdate=update table_key set key_val = ? where key_table_name = ?
tableKeyCreate=insert into table_key values( ? ,0)
logKeyGet-postgresql=select nextval('log_seq')
journalLogInsert=insert into log (log_id, log_step, log_datetime, log_operation, log_other_data, log_pipeline, log_additional) values ( ? , ? , ? , ? , ? , ? , ? )
journalLogMaxStep=select max(log_step) from log where log_id=?
journalAddBlankDataRow-oracle=insert into JOURNAL values ( ? , ? , empty_blob() )
journalAddBlankDataRow-mysql=insert into journal values ( ? , ? , ? )
journalAddBlankDataRow-sqlserver=insert into journal values ( ? , ? , ? )
journalSelectBlob=select jrn_data from journal where jrn_log_id=? and jrn_log_step=?
journalSelectBlobForUpdate-oracle=select jrn_data from journal where jrn_log_id=? and jrn_log_step=? for update
journalUpdateDeltaData=insert into journal_data values ( ? , ? , ? , ? )
queryOtherTicketValues=select distinct log_id from log where log_other_data=? and log_operation=?
queryAllTicketSteps=select distinct log_id, log_datetime, log_pipeline, log_operation, log_other_data, log_step, log_additional from log where log_id=?
queryTickets=select distinct log_id, log_datetime, log_pipeline, log_operation, log_other_data, log_step, log_additional from log
queryTicketsOperation=log_operation
queryTicketsPipeline=log_pipeline
queryTicketsDatetime=log_datetime
userGetByName=select user_id, user_name, user_passwd,user_org_id, user_type from user where user_name=?
userGetById=select user_id, user_name, user_passwd, user_org_id, user_type from user where user_id=?
userAdd=insert into user (user_id, user_name, user_passwd, user_org_id, user_type) values (?,?,?,?,?)
userDelete=delete from user where user_name=?
userGetByOrgId=select user_id, user_name, user_passwd, user_org_id, user_type from user where user_org_id=?
orgGetByName=select org_id, org_name, org_parent_id from organization where org_name=?
orgGetById=select org_id, org_name, org_parent_id from organization where org_id=?
orgAdd=insert into organization (org_id, org_name, org_parent_id) values (?, ?, ?)
orgDelete=delete from organization where org_name=?
resGetById=select res_id, res_name, res_parent_id, res_auth_needed from resource where res_id=?
resGetByNameParent=select res_id, res_name, res_parent_id, res_auth_needed from resource where res_name=? and res_parent_id=?
resGetByParent=select res_id, res_name, res_parent_id, res_auth_needed from resource where res_parent_id=?
resGetByNameId=select res_id, res_name, res_parent_id, res_auth_needed from resource where res_name=? and res_id=?
resGetUserForRes=select acc_res_id, acc_usr_id from usr_res_access where acc_res_id=? and acc_usr_id=?
resGetOrgForRes=select acc_res_id, acc_org_id from org_res_access where acc_res_id=? and acc_org_id=?
resDelete=delete from resource where res_id=?
resInsert=insert into resource ( res_id, res_name, res_parent_id, res_auth_needed ) values (?, ?, ?, ?)
accUserResInsert=insert into usr_res_access (acc_res_id, acc_usr_id) values (?, ?)
accOrgResInsert=insert into org_res_access (acc_res_id, acc_org_id) values (?, ?)
accUserResDelete=delete from usr_res_access where acc_res_id=? and acc_usr_id=?
accOrgResDelete=delete from org_res_access where acc_res_id=? and acc_org_id=?
prefGlobalSelect=select pref_value from preference where pref_name=?
prefUserSelect=select upref_value from user_preference where upref_name=? and upref_user_id=?
prefOrgSelect=select opref_value from org_preference where opref_name=? and opref_org_id=?
prefGlobalInsert=insert into preference (pref_name, pref_value) values(?,?)
prefUserInsert=insert into user_preference (upref_user_id, upref_name, upref_value) values(?,?,?)
prefOrgInsert=insert into org_preference (opref_org_id, opref_name, opref_value) values(?,?,?)
prefGlobalDelete=delete from preference where pref_name=?
prefUserDelete=delete from user_preference where upref_name=? and upref_user_id=?
prefOrgDelete=delete from org_preference where opref_name=? and opref_org_id=?
--- NEW FILE: config.properties ---
connectionManagerClassName=com.babeldoc.sql.SimpleSqlConnectionManager
|
