svn commit: r451332 - in /incubator/lokahi/lokahi/branches/mysql/conf: db.properties lokahi.properties

[to...@apache.org]

Author: toback
Date: Fri Sep 29 09:04:36 2006
New Revision: 451332

URL: http://svn.apache.org/viewvc?view=rev&rev=451332
Log:
Re:

http://mail-archives.apache.org/mod_mbox/incubator-lokahi-dev/200609.mbox/%3c451ADBE9.9090605@free.fr%3e

Modified:
    incubator/lokahi/lokahi/branches/mysql/conf/db.properties
    incubator/lokahi/lokahi/branches/mysql/conf/lokahi.properties

Modified: incubator/lokahi/lokahi/branches/mysql/conf/db.properties
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/branches/mysql/conf/db.properties?view=diff&rev=451332&r1=451331&r2=451332
==============================================================================
--- incubator/lokahi/lokahi/branches/mysql/conf/db.properties (original)
+++ incubator/lokahi/lokahi/branches/mysql/conf/db.properties Fri Sep 29 09:04:36 2006
@@ -222,4 +222,221 @@
 oracle.apache.server.by.name=F_AM_GET_APACHE_BY_name
 oracle.tomcat.worker.by.server=F_TM_GET_TW_BY_TM
 oracle.apache.worker.by.server=F_AM_GET_AW_BY_AID
-oracle.core.pool.by.tomcatpool=F_TM_GET_HPOOLS_BY_TPID
\ No newline at end of file
+oracle.core.pool.by.tomcatpool=F_TM_GET_HPOOLS_BY_TPID
+
+#
+# MySQL - Standard
+#
+
+mysql.apache.server.by.id=SELECT ap.CONTAINER_ID, ap.CONTAINER_NAME, ap.LOG_LOCATION, ap.ENV_VARIBLES, ap.FORK_WAIT, ap.PIDFILE_LOCATION, ap.RESTART_COMMAND, ap.START_COMMAND, ap.STOP_COMMAND, ap.SYS_GROUP, ap.SYS_USER, ap.SERVER_ROOT, ap.MAIN_ID FROM AM_CONTAINER ap WHERE ap.CONTAINER_ID = ?
+mysql.apache.server.all=SELECT ap.CONTAINER_ID, ap.CONTAINER_NAME, ap.LOG_LOCATION, ap.ENV_VARIBLES, ap.FORK_WAIT, ap.PIDFILE_LOCATION, ap.RESTART_COMMAND, ap.START_COMMAND, ap.STOP_COMMAND, ap.SYS_GROUP, ap.SYS_USER, ap.SERVER_ROOT, ap.main_ID FROM AM_CONTAINER ap
+mysql.apache.server.store=sp_am_store_apache
+mysql.apache.server.update=sp_am_update_apache
+mysql.apache.server.delete=sp_am_drop_apache
+mysql.apache.pool.store=sp_am_store_pool
+mysql.apache.pool.update=sp_am_update_pool
+mysql.apache.pool.delete=sp_am_drop_pool
+mysql.apache.pool.by.id=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM AM_POOL p WHERE p.POOL_ID=?
+mysql.apache.pool.by.name=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM AM_POOL p WHERE lower(p.POOL_name) like lower(?)
+mysql.apache.pool.by.vhost=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM AM_POOL p, TMC_REL_HOSTING_MODULES rhp, AM_VHOST vh WHERE p.POOL_ID=rhp.AM_POOL_ID AND rhp.HOSTING_POOL_ID=vh.HOSTING_POOL_ID AND vh.VHOST_ID=?
+mysql.apache.pool.all=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM AM_POOL p
+mysql.apache.pool.by.worker=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM AM_POOL p, AM_REL_POOL_WORKER rel WHERE p.POOL_ID=rel.POOL_ID and rel.WORKER_ID=?
+mysql.apache.pool.rel.worker.add=sp_am_store_worker_pool
+mysql.apache.pool.rel.worker.delete=sp_am_delete_worker_pool
+mysql.apache.worker.by.id=SELECT * FROM AM_WORKER_VIEW aw where aw.WORKER_ID=?
+mysql.apache.worker.by.server.hardware=SELECT * FROM AM_WORKER_VIEW aw where aw.CONTAINER_ID=? AND aw.HARDWARE_ID=?
+mysql.apache.worker.all=SELECT * FROM AM_WORKER_VIEW
+mysql.apache.worker.by.pool=SELECT worker_id, aw.container_id, aw.state_id, aw.hardware_id, aw.container_name, aw.server_root, aw.log_location, aw.sys_user, aw.sys_group, aw.start_command, aw.stop_command, aw.restart_command, aw.fork_wait, aw.pidfile_location, aw.env_varibles, aw.main_id, aw.hardware_name, aw.physical_location, aw.comments, aw.instance_id, aw.env_id, aw.hardware_state_id, aw.default_ip_id FROM (AM_WORKER_VIEW aw JOIN AM_REL_POOL_WORKER using (WORKER_ID)) where pool_id=?
+mysql.apache.worker.by.name=SELECT * FROM AM_WORKER_VIEW aw where lower(hardware_name) like lower(?)
+mysql.apache.worker.by.name.instance=SELECT * FROM AM_WORKER_VIEW aw where hardware_name like "?" AND instance_id = ?
+mysql.apache.worker.by.hardware=SELECT * FROM AM_WORKER_VIEW aw where aw.HARDWARE_ID=?
+mysql.apache.worker.store=sp_am_store_worker
+mysql.apache.worker.update=sp_am_update_worker
+mysql.apache.worker.delete=sp_am_drop_worker
+mysql.core.environment.by.id=SELECT e.ENV_ID, e.ENV_NAME, e.COMMENTS FROM TMC_ENV e WHERE e.ENV_ID = ?
+mysql.core.environment.by.project=SELECT unique e.env_id, e.env_name, e.comments FROM TMC_ENV e, AM_REL_ENTITY_Project ag, AM_VHOST v where ag.vhost_id = v.vhost_id and v.env_id = e.env_id and ag.project_id = ?
+mysql.core.environment.all=SELECT e.ENV_ID, e.ENV_NAME, e.COMMENTS FROM TMC_ENV e
+mysql.core.environment.store=sp_tmc_store_enviroment
+mysql.core.environment.update=sp_tmc_update_enviroment
+mysql.core.environment.delete=sp_tmc_drop_environment
+mysql.core.file.by.id=SELECT f.FILE_ID, f.FILE_NAME, f.FILE_DESCRIPTOR, f.FILE_PATH, f.file_content FROM TMC_FILES f WHERE f.FILE_ID=?
+mysql.core.file.delete=sp_tmc_drop_file
+mysql.core.file.all=SELECT f.FILE_ID, f.FILE_NAME, f.FILE_DESCRIPTOR, f.FILE_PATH, f.file_content FROM TMC_FILES f
+mysql.core.function.by.id=SELECT f.FUNCTION_ID, f.FUNCTION_COMMAND, f.FUNCTION_NAME FROM TMC_FUNCTION f WHERE f.FUNCTION_ID = ?
+mysql.core.function.by.command=SELECT f.FUNCTION_COMMAND, f.FUNCTION_ID, f.FUNCTION_NAME FROM TMC_FUNCTION f WHERE f.FUNCTION_COMMAND = v_command
+mysql.core.function.all=SELECT f.FUNCTION_ID, f.FUNCTION_COMMAND, f.FUNCTION_NAME FROM TMC_FUNCTION f
+mysql.core.function.store=sp_tmc_store_function
+mysql.core.function.update=sp_tmc_update_function
+mysql.core.function.delete=sp_tmc_drop_function
+mysql.core.server.rel.ip.add=sp_tmc_add_hardware_ip
+mysql.core.server.rel.ip.delete=sp_tmc_delete_hardware_ip
+mysql.core.server.by.id=SELECT h.HARDWARE_ID, h.INSTANCE_ID, h.ENV_ID, h.PHYSICAL_LOCATION, h.HARDWARE_NAME, h.STATUS_ID, h.COMMENTS, h.DEFAULT_IP_ID FROM TMC_HARDWARE h WHERE h.HARDWARE_ID = ?
+mysql.core.server.by.name.instance=SELECT h.HARDWARE_ID, h.INSTANCE_ID, h.ENV_ID, h.PHYSICAL_LOCATION, h.HARDWARE_NAME, h.STATUS_ID, h.COMMENTS, h.DEFAULT_IP_ID FROM TMC_HARDWARE h WHERE h.HARDWARE_NAME = "?" AND h.INSTANCE_ID=?
+# TODO: Steve T. should check if this is adequate
+mysql.core.server.by.environment=SELECT h.HARDWARE_ID, h.INSTANCE_ID, h.ENV_ID, h.PHYSICAL_LOCATION, h.HARDWARE_NAME, h.STATUS_ID, h.COMMENTS, h.DEFAULT_IP_ID FROM TMC_HARDWARE h WHERE h.ENV_ID = ?
+mysql.core.server.all=SELECT h.HARDWARE_ID, h.INSTANCE_ID, h.ENV_ID, h.PHYSICAL_LOCATION, h.HARDWARE_NAME, h.STATUS_ID, h.COMMENTS, h.DEFAULT_IP_ID FROM TMC_HARDWARE h
+mysql.core.server.store=sp_tmc_store_hardware
+mysql.core.server.update=sp_tmc_update_hardware
+mysql.core.server.delete=sp_tmc_drop_server
+mysql.core.state.store=sp_tmc_store_state
+mysql.core.state.update=sp_tmc_update_state
+mysql.core.state.all=SELECT s.STATE_NAME, s.STATE_ID, s.STATE_COLOR FROM TMC_STATE s
+mysql.core.state.delete=sp_tmc_drop_state
+mysql.core.state.by.id=SELECT s.STATE_NAME, s.STATE_ID, s.STATE_COLOR FROM TMC_STATE s WHERE s.STATE_ID = ?
+mysql.core.pool.update=sp_tmc_update_hostingpool
+mysql.core.pool.store=sp_tmc_store_hostingpool
+mysql.core.pool.delete=sp_tmc_drop_hostingpool
+mysql.core.pool.by.id=SELECT hp.HOSTING_POOL_ID, hp.HOSTING_POOL_NAME, hp.ENV_ID, rel.AM_POOL_ID, rel.TM_POOL_ID FROM TMC_Hosting_Pool hp, TMC_REL_HOSTING_MODULES rel Where rel.HOSTING_POOL_ID = hp.HOSTING_POOL_ID AND hp.HOSTING_POOL_ID=?
+mysql.core.pool.all=SELECT hp.HOSTING_POOL_ID, hp.HOSTING_POOL_NAME, hp.ENV_ID, rel.AM_POOL_ID, rel.TM_POOL_ID FROM TMC_Hosting_Pool hp, TMC_REL_HOSTING_MODULES rel Where rel.HOSTING_POOL_ID = hp.HOSTING_POOL_ID
+mysql.core.pool.by.apacheworker=SELECT hp.HOSTING_POOL_ID, hp.HOSTING_POOL_NAME, hp.ENV_ID, rel.AM_POOL_ID, rel.TM_POOL_ID FROM TMC_Hosting_Pool hp, TMC_REL_HOSTING_MODULES rel, AM_REL_POOL_WORKER rpw Where rel.HOSTING_POOL_ID = hp.HOSTING_POOL_ID AND rel.AM_POOL_ID=rpw.POOL_ID AND rpw.WORKER_ID=v_id
+mysql.core.pool.by.name=SELECT hp.HOSTING_POOL_ID, hp.HOSTING_POOL_NAME, hp.ENV_ID, rel.AM_POOL_ID, rel.TM_POOL_ID FROM TMC_Hosting_Pool hp, TMC_REL_HOSTING_MODULES rel Where rel.HOSTING_POOL_ID = hp.HOSTING_POOL_ID AND lower(hp.HOSTING_POOL_name) like lower(?)
+mysql.core.pool.by.apachepool=SELECT hp.HOSTING_POOL_ID, hp.HOSTING_POOL_NAME, hp.ENV_ID, rel.AM_POOL_ID, rel.TM_POOL_ID FROM TMC_Hosting_Pool hp, TMC_REL_HOSTING_MODULES rel, AM_REL_POOL_WORKER rpw Where rel.HOSTING_POOL_ID = hp.HOSTING_POOL_ID AND rel.AM_POOL_ID=v_id
+mysql.core.instance.by.id=SELECT i.INSTANCE_NAME, i.INSTANCE_ID, i.COMMENTS FROM TMC_INSTANCE i WHERE i.INSTANCE_ID = ?
+mysql.core.instance.all=SELECT i.INSTANCE_NAME, i.INSTANCE_ID, i.COMMENTS FROM TMC_INSTANCE i
+mysql.core.instance.by.name=SELECT i.INSTANCE_NAME, i.INSTANCE_ID, i.COMMENTS FROM TMC_INSTANCE i WHERE i.INSTANCE_NAME = ?
+mysql.core.instance.store=sp_tmc_store_instance
+mysql.core.instance.delete=sp_tmc_drop_instance
+mysql.core.instance.update=sp_tmc_update_instance
+mysql.core.ip.by.id=SELECT i.IP_ID, i.IP FROM TMC_IP i WHERE i.IP_ID = ?
+mysql.core.ip.by.name=SELECT i.IP_ID, i.IP FROM TMC_IP i WHERE i.IP = ?
+mysql.core.ip.by.hardware=SELECT hr.HARDWARE_ID, i.IP_ID, i.IP FROM TMC_REL_HARDWARE_IP hr, TMC_IP i WHERE hr.HARDWARE_ID = ? AND i.IP_ID = hr.IP_ID
+mysql.core.ip.by.virtualhost=SELECT i.IP_ID, i.IP FROM TMC_IP i, AM_REL_VHOST_IP rel WHERE i.IP_ID = rel.IP_ID AND rel.VHOST_ID=?
+mysql.core.ip.all=SELECT i.IP_ID, i.IP FROM TMC_IP i
+mysql.core.ip.store=sp_tmc_store_ip
+mysql.core.ip.update=sp_tmc_update_ip
+mysql.core.ip.delete=sp_tmc_drop_ip
+mysql.core.job.by.id=SELECT j.JOB_ID, j.POOL_ID, j.JOB_NAME, j.SERVER_ID, j.START_TIME, j.FINISH_TIME, j.PARENT_ID, j.STATE_ID, j.OPTIONS, j.FUNCTION_ID, j.INSTANCE_ID, j.RESULT FROM TMC_JOB j WHERE j.JOB_ID = ?
+mysql.core.job.all=SELECT j.JOB_ID, j.POOL_ID, j.JOB_NAME, j.SERVER_ID, j.START_TIME, j.FINISH_TIME, j.PARENT_ID, j.STATE_ID, j.OPTIONS, j.FUNCTION_ID, j.INSTANCE_ID, j.RESULT FROM TMC_JOB j
+mysql.core.job.by.name=SELECT j.JOB_ID, j.POOL_ID, j.JOB_NAME, j.SERVER_ID, j.START_TIME, j.FINISH_TIME, j.PARENT_ID, j.STATE_ID, j.OPTIONS, j.FUNCTION_ID, j.INSTANCE_ID, j.RESULT FROM TMC_JOB j WHERE j.JOB_NAME = ?
+mysql.core.job.by.instance.state=SELECT j.JOB_ID, j.POOL_ID, j.JOB_NAME, j.SERVER_ID, j.START_TIME, j.FINISH_TIME, j.PARENT_ID, j.STATE_ID, j.OPTIONS, j.FUNCTION_ID, j.INSTANCE_ID, j.RESULT FROM TMC_JOB j, TMC_HARDWARE h WHERE j.INSTANCE_ID = ? AND j.STATE_ID=? AND h.hardware_id=j.SERVER_ID AND h.status_id=8
+mysql.core.job.by.pool=SELECT j.JOB_ID, j.POOL_ID, j.JOB_NAME, j.SERVER_ID, j.START_TIME, j.FINISH_TIME, j.PARENT_ID, j.STATE_ID, j.OPTIONS, j.FUNCTION_ID, j.INSTANCE_ID, j.RESULT FROM TMC_JOB j WHERE j.POOL_ID = ?
+mysql.core.jobpool.update=sp_tmc_update_jobpool
+mysql.core.jobpool.store=sp_tmc_add_jobpool
+mysql.core.jobpool.finalize=sp_tmc_finalize_jobpool
+mysql.core.jobpool.by.id=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE JOB_POOL_ID = ?
+mysql.core.jobpool.by.project=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE Project_ID = ? ORDER BY JOB_POOL_ID DESC
+mysql.core.jobpool.by.user=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE USER_ID = ? ORDER BY JOB_POOL_ID DESC
+# TODO: Figure out how the filter string should be coded
+mysql.core.jobpool.search.user=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE USER_ID = ? AND JOB_POOL_NAME LIKE ?
+mysql.core.jobpool.search.user.date=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE USER_ID = ? AND JOB_POOL_NAME LIKE ? AND START_DATE >= ?
+mysql.core.jobpool.search.user.function=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE USER_ID = ? AND JOB_POOL_NAME LIKE ? AND FUNCTION_ID = ?;
+mysql.core.jobpool.by.state=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE State_ID = ?
+mysql.core.jobpool.by.state.limited=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp WHERE State_ID = ? and rownum < 21 order by job_pool_id
+# TODO: Check if adequate
+mysql.core.jobpool.all=SELECT JOB_POOL_ID, JOB_POOL_NAME, PROJECT_ID, USER_ID, START_TIME, FINISH_TIME, STATE_ID, OPTIONS, FUNCTION_ID FROM TMC_JOB_POOL tjp
+mysql.core.project.store=sp_tmc_store_project
+mysql.core.project.update=sp_tmc_update_project
+# TODO: There is no data param send by the method call: so as i see it's the same function than core.project.by.user
+# TODO: Convert to MySql, here is the plain Oracle statement: 
+#mysql.core.project.recent=(select max(job_pool_id), project_id  from tmc_job_pool where user_id = ? group by project_id order by 1 desc) join tmc_project using (project_id) where rownum <11;
+mysql.core.project.recent=SELECT proj.PROJECT_ID, proj.PROJECT_NAME FROM TMC_USER tu, TMC_REL_USER_PROJECT rel, TMC_PROJECT proj WHERE tu.USER_ID = ? AND tu.USER_ID = rel.USER_ID AND rel.PROJECT_ID = proj.PROJECT_ID
+mysql.core.project.all=SELECT proj.PROJECT_ID, proj.PROJECT_NAME FROM TMC_PROJECT proj
+mysql.core.project.delete=sp_tmc_delete_project
+mysql.core.project.rel.context.store=sp_TM_STORE_CTXT_REL_PROJECT
+mysql.core.project.rel.context.delete=sp_tm_drop_ctxt_rel_project
+mysql.core.project.rel.vhost.store=SP_AM_STORE_VHOSTS_REL_PROJECT
+mysql.core.project.rel.vhost.delete=sp_am_drop_vhosts_rel_project
+mysql.core.project.by.vhost=f_tmc_get_projects_by_vhost
+mysql.core.project.by.context=f_tmc_get_projects_by_context
+mysql.core.project.by.user=SELECT proj.PROJECT_ID, proj.PROJECT_NAME FROM TMC_USER tu, TMC_REL_USER_PROJECT rel, TMC_PROJECT proj WHERE tu.USER_ID = ? AND tu.USER_ID = rel.USER_ID AND rel.PROJECT_ID = proj.PROJECT_ID
+mysql.core.project.search=SELECT proj.PROJECT_ID, proj.PROJECT_NAME FROM TMC_PROJECT proj WHERE lower(proj.PROJECT_NAME) like lower(?)
+mysql.core.project.by.id=SELECT proj.PROJECT_ID, proj.PROJECT_NAME FROM TMC_PROJECT proj WHERE proj.PROJECT_ID = ?
+mysql.tomcat.server.update=sp_tm_update_tomcat4
+mysql.tomcat.server.store=sp_tm_store_tomcat4
+mysql.tomcat.server.all=SELECT * FROM TM_CONTAINER tc
+mysql.tomcat.server.by.id=SELECT * FROM TM_CONTAINER tc WHERE tc.CONTAINER_ID = ?
+mysql.tomcat.server.delete=sp_tm_drop_server
+mysql.tomcat.entity.by.projectId=SELECT * FROM TM_ENTITY_VIEW join TM_REL_ENTITY_PROJECT USING (ENTITY_ID) where project_id = ?
+mysql.tomcat.entity.all=SELECT * FROM TM_ENTITY_VIEW tc
+mysql.tomcat.entity.by.vhost=SELECT tc.* FROM TM_ENTITY_view tc, TMC_REL_VHOST_CONTEXT rel WHERE tc.ENTITY_ID=rel.CONTEXT_ID AND rel.VHOST_ID=?
+mysql.tomcat.entity.by.pool=SELECT * FROM TM_ENTITY_VIEW tc WHERE tc.TOMCAT_POOL_ID=?
+mysql.tomcat.entity.by.worker=SELECT tc.* FROM TM_ENTITY_view tc, TM_REL_POOL_WORKER rel WHERE rel.WORKER_ID=? AND rel.POOL_ID=tc.TOMCAT_POOL_ID
+mysql.tomcat.entity.by.id=SELECT tc.* FROM TM_ENTITY_view tc WHERE tc.ENTITY_ID=?
+mysql.tomcat.entity.by.name=SELECT * FROM TM_ENTITY_view where lower(entity_name) like lower('%'||?||'%')
+mysql.tomcat.entity.update=sp_tm_update_entity
+mysql.tomcat.entity.store=sp_tm_store_entity
+mysql.tomcat.entity.delete=sp_tm_drop_entity
+mysql.tomcat.pool.rel.worker.add= sp_tm_store_worker_pool
+mysql.tomcat.pool.rel.worker.delete=sp_tm_delete_worker_pool
+mysql.tomcat.pool.update=sp_tm_update_pool
+mysql.tomcat.pool.delete=sp_tm_drop_pool
+mysql.tomcat.pool.store=sp_tm_store_pool
+mysql.tomcat.pool.by.id=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM TM_POOL p WHERE p.POOL_ID=?
+mysql.tomcat.pool.by.context=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM TM_POOL p, TM_ENTITY e WHERE p.POOL_ID=e.TOMCAT_POOL_ID AND e.ENTITY_ID=?
+mysql.tomcat.pool.all=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM TM_POOL p
+mysql.tomcat.pool.by.name=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM TM_POOL p WHERE lower(p.pool_name) like lower(?)
+mysql.tomcat.pool.by.worker=SELECT p.POOL_ID, p.POOL_NAME, p.ENV_ID FROM TM_POOL p, TM_REL_POOL_WORKER rel WHERE p.POOL_ID=rel.POOL_ID AND rel.WORKER_ID=?
+mysql.tomcat.worker.update=sp_tm_update_worker
+mysql.tomcat.worker.delete=sp_tm_drop_worker
+mysql.tomcat.worker.store=sp_tm_store_worker
+mysql.tomcat.worker.by.pool=SELECT * FROM (TM_WORKER_VIEW tw JOIN TM_REL_POOL_WORKER using (WORKER_ID)) WHERE POOL_ID= ?
+mysql.tomcat.worker.all=SELECT * FROM TM_WORKER_VIEW
+mysql.tomcat.worker.by.id=SELECT * FROM TM_WORKER_VIEW tw WHERE tw.WORKER_ID = ?
+mysql.tomcat.worker.by.hardware.server=SELECT * FROM TM_WORKER_VIEW tw WHERE tw.CONTAINER_ID = ? AND tw.HARDWARE_ID = v_hId
+mysql.tomcat.worker.by.hardware=SELECT * FROM TM_WORKER_VIEW tw WHERE tw.HARDWARE_ID = ?
+mysql.tomcat.worker.by.name=SELECT * FROM TM_WORKER_VIEW tw WHERE lower(hardware_name) like lower(?)
+mysql.tomcat.worker.by.name.instance=SELECT * FROM TM_WORKER_VIEW tw WHERE hardware_name like "?" and instance_id = ?
+mysql.core.user.rel.project.add=sp_tmc_store_user_proj
+mysql.core.user.rel.project.delete=sp_tmc_delete_user_proj
+mysql.core.user.by.username=SELECT u.USER_ID, u.COMMENTS, u.JOB_TITLE, u.FIRST_NAME, u.LAST_NAME, u.EMAIL, u.USER_NAME, U.State_id FROM TMC_USER u WHERE u.USER_NAME = ?
+mysql.core.user.by.id=SELECT u.USER_ID, u.COMMENTS, u.JOB_TITLE, u.FIRST_NAME, u.LAST_NAME, u.EMAIL, u.USER_NAME, U.State_id FROM TMC_USER u WHERE u.USER_ID = ?
+mysql.core.user.all=SELECT u.USER_ID, u.COMMENTS, u.JOB_TITLE, u.FIRST_NAME, u.LAST_NAME, u.EMAIL, u.USER_NAME, U.STATE_ID FROM TMC_USER u
+mysql.core.user.by.project=SELECT u.USER_ID, u.COMMENTS, u.JOB_TITLE, u.FIRST_NAME, u.LAST_NAME, u.EMAIL, u.USER_NAME, u.State_id FROM TMC_USER u, TMC_REL_USER_PROJECT rel WHERE u.USER_ID = rel.user_ID AND rel.project_ID = ?
+mysql.core.user.update=sp_tmc_update_user
+mysql.core.user.store=sp_tmc_store_user
+mysql.core.user.delete=sp_tmc_drop_user
+mysql.apache.entity.rel.ip.add=sp_am_store_vhosts_rel_ip
+mysql.apache.entity.rel.context.add=sp_am_store_vhosts_rel_context
+mysql.apache.entity.delete=sp_am_drop_entity
+mysql.apache.entity.rel.ip.delete=sp_am_drop_vhost_rel_ip
+mysql.apache.entity.rel.context.delete=sp_am_drop_vhost_rel_ctxt
+mysql.apache.entity.update=sp_am_update_vhost
+mysql.apache.entity.store=sp_am_store_vhost
+mysql.apache.entity.all=SELECT * FROM AM_ENTITY_VIEW
+mysql.apache.entity.by.projectid=SELECT * FROM AM_ENTITY_VIEW join AM_REL_ENTITY_PROJECT USING (VHOST_ID) where project_id = ?
+mysql.apache.entity.by.hostingpool=SELECT * FROM AM_ENTITY_VIEW vh where vh.hosting_POOL_ID=?
+mysql.apache.entity.by.worker=SELECT vh.VHOST_ID, vh.ENV_ID, vh.STATE_ID, vh.VHOST_NAME, vh.HOSTING_POOL_ID, vh.NAMEBASED, vh.CATCHALL, vh.VHOST_ENTRY, vh.EX_PROJECT_ID, vh.POOL_ID, vh.POOL_NAME, vh.POOL_ENV_ID FROM AM_ENTITY_VIEW vh, AM_REL_POOL_WORKER aw where vh.pool_id = aw.pool_ID AND aw.WORKER_ID=?
+mysql.apache.entity.by.id=SELECT * FROM AM_ENTITY_VIEW vh where vh.vhost_ID=?
+mysql.apache.entity.by.name=SELECT * FROM AM_ENTITY_VIEW vh where lower(vh.vhost_name) like lower(?)
+mysql.util.alert.all=SELECT a.ALERT_ID, a.SUBMISION_DATE, a.SUBMITTER_ID, a.ALERT_TITLE, a.ALERT_LINK, a.alert_contents FROM TMC_ALERTS a;
+mysql.util.alert.by.id=SELECT a.ALERT_ID, a.SUBMISION_DATE, a.SUBMITTER_ID, a.ALERT_TITLE, a.ALERT_LINK, a.alert_contents FROM TMC_ALERTS a where a.ALERT_ID=?
+mysql.util.alert.delete=sp_tmc_drop_alert
+mysql.util.alert.delete.rel.project=sp_tmc_drop_alert_rel
+mysql.util.alert.store=sp_tmc_store_alert
+mysql.util.alert.update=sp_tmc_update_alert
+mysql.util.alert.rel.project.store=sp_tmc_store_alert_rel
+mysql.util.help.by.id=SELECT hi.HELP_ITEM_ID, hi.HELP_ITEM_TITLE, hi.VALID, hi.SUMMARY, hi.content, top.TOPIC_NAME, hi.FUNCTION_ID, st.TOPIC_NAME as SUBTOPIC_NAME FROM TMC_HELP_ITEM hi, TMC_TOPIC top, TMC_TOPIC st, TMC_REL_HELP_TOPIC th WHERE hi.HELP_ITEM_ID=? AND th.HELP_ITEM_ID=hi.HELP_ITEM_ID AND top.TOPIC_ID = th.TOPIC_ID AND st.TOPIC_ID = th.SUBTOPIC_ID
+mysql.util.help.by.function=SELECT hi.HELP_ITEM_ID, hi.HELP_ITEM_TITLE, hi.VALID, hi.content, hi.SUMMARY, top.TOPIC_NAME, hi.FUNCTION_ID, st.TOPIC_NAME as SUBTOPIC_NAME FROM TMC_HELP_ITEM hi, TMC_TOPIC top, TMC_TOPIC st, TMC_REL_HELP_TOPIC th WHERE hi.FUNCTION_ID=? AND hi.valid = ? AND th.HELP_ITEM_ID=hi.HELP_ITEM_ID AND top.TOPIC_ID = th.TOPIC_ID AND st.TOPIC_ID = th.SUBTOPIC_ID
+mysql.util.help.all=SELECT hi.HELP_ITEM_ID, hi.HELP_ITEM_TITLE, hi.VALID, hi.SUMMARY, hi.content, top.TOPIC_NAME, hi.FUNCTION_ID, st.TOPIC_NAME as SUBTOPIC_NAME FROM TMC_HELP_ITEM hi, TMC_TOPIC top, TMC_TOPIC st, TMC_REL_HELP_TOPIC th WHERE th.HELP_ITEM_ID=hi.HELP_ITEM_ID AND top.TOPIC_ID = th.TOPIC_ID AND st.TOPIC_ID = th.SUBTOPIC_ID
+mysql.util.help.by.keyword=SELECT hi.HELP_ITEM_ID, hi.HELP_ITEM_TITLE, hi.VALID, hi.content,hi.SUMMARY, top.TOPIC_NAME, hi.FUNCTION_ID, st.TOPIC_NAME as SUBTOPIC_NAME FROM TMC_HELP_ITEM hi, TMC_TOPIC top, TMC_TOPIC st, TMC_REL_HELP_TOPIC th, TMC_REL_HELP_keyword tk, TMC_KEYWORD kw WHERE kw.KEYWORD_NAME like '%'|| "?" ||'%' AND tk.KEYWORD_ID = kw.KEYWORD_ID AND hi.HELP_ITEM_ID = tk.HELP_ITEM_ID AND hi.valid = ? AND th.HELP_ITEM_ID = hi.HELP_ITEM_ID AND top.TOPIC_ID = th.TOPIC_ID AND st.TOPIC_ID = th.SUBTOPIC_ID
+mysql.util.help.store=sp_tmc_store_help_item
+mysql.util.help.delete=sp_tmc_drop_help_item
+mysql.util.help.update=sp_tmc_update_help_item
+mysql.util.help.keyword.add=sp_tmc_store_keyword
+mysql.util.help.topic.store=sp_tmc_store_topic
+mysql.util.help.rel.topic.add=sp_tmc_store_help_rel_topic
+mysql.util.help.rel.topic.update=sp_tmc_update_help_rel_topic
+mysql.util.help.rel.keyword.add=sp_tmc_store_help_rel_keyword
+mysql.util.help.rel.keyword.update=sp_tmc_update_help_rel_keyword
+mysql.core.ability.rel.user.delete=sp_tmc_delete_user_abil
+mysql.core.ability.rel.user.store=sp_tmc_store_user_abil
+mysql.core.ability.by.user=SELECT USER_ID, PROJECT_ID, OBJECT_TYPE, OBJECT_ID, FUNCTION_ID FROM TMC_rel_function_user WHERE USER_ID = ?
+mysql.core.exproject.add=sp_tmc_store_ex_project
+mysql.core.exproject.delete=sp_tmc_delete_ex_project
+mysql.core.file.content.update=UPDATE TMC_FILES SET FILE_CONTENT = ? where FILE_id=?
+mysql.core.file.content.lock=SELECT FILE_CONTENT FROM TMC_FILES where FILE_id=? FOR UPDATE
+mysql.core.file.store=sp_tmc_store_file
+mysql.core.file.update=sp_tmc_update_file
+mysql.core.job.store=sp_tmc_store_job
+mysql.core.job.set.result=UPDATE TMC_JOB  SET RESULT = ? where job_id=?
+mysql.core.job.lock.result=SELECT RESULT FROM TMC_JOB where job_id=? FOR UPDATE
+mysql.core.job.store.finish=sp_tmc_add_job2
+mysql.core.job.update=sp_tmc_job_update
+mysql.core.file.prep.blob={call sp_tmc_prep_file_content(?,EMPTY_BLOB())}
+mysql.core.job.prep.blob={call sp_TMC_prep_job(?,EMPTY_BLOB())}
+mysql.tomcat.server.by.name=SELECT * FROM TM_CONTAINER tc WHERE lower(tc.CONTAINER_NAME) like lower(?)
+mysql.core.server.by.name=SELECT h.HARDWARE_ID, h.INSTANCE_ID, h.ENV_ID, h.PHYSICAL_LOCATION, h.HARDWARE_NAME, h.STATUS_ID, h.COMMENTS, h.DEFAULT_IP_ID FROM TMC_HARDWARE h WHERE lower(h.HARDWARE_NAME) like lower(?)
+mysql.apache.server.by.name=SELECT ap.CONTAINER_ID, ap.CONTAINER_NAME, ap.LOG_LOCATION, ap.ENV_VARIBLES, ap.FORK_WAIT, ap.PIDFILE_LOCATION, ap.RESTART_COMMAND, ap.START_COMMAND, ap.STOP_COMMAND, ap.SYS_GROUP, ap.SYS_USER, ap.SERVER_ROOT, ap.MAIN_ID FROM AM_CONTAINER ap WHERE lower(ap.CONTAINER_name) like lower(?)
+mysql.tomcat.worker.by.server=SELECT * FROM TM_WORKER_VIEW tw WHERE tw.CONTAINER_ID = ?
+mysql.apache.worker.by.server=SELECT * FROM AM_WORKER_VIEW aw where aw.CONTAINER_ID=?
+mysql.core.pool.by.tomcatpool=SELECT hp.HOSTING_POOL_ID, hp.HOSTING_POOL_NAME, hp.ENV_ID, rel.AM_POOL_ID, rel.TM_POOL_ID FROM TMC_Hosting_Pool hp, TMC_REL_HOSTING_MODULES rel Where rel.HOSTING_POOL_ID = hp.HOSTING_POOL_ID AND rel.TM_POOL_ID=v_id

Modified: incubator/lokahi/lokahi/branches/mysql/conf/lokahi.properties
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/branches/mysql/conf/lokahi.properties?view=diff&rev=451332&r1=451331&r2=451332
==============================================================================
--- incubator/lokahi/lokahi/branches/mysql/conf/lokahi.properties (original)
+++ incubator/lokahi/lokahi/branches/mysql/conf/lokahi.properties Fri Sep 29 09:04:36 2006
@@ -46,9 +46,14 @@
 SleepTimeForMainThread=60
 SleepTimeForChildThread=60
 
-wap.function.HostingPool=RestartTomcat,StartTomcat,StopTomcat,DeployTomcatConfig,DeployApacheConfig,ConfigtestApache,GracefulApache,
-StopApache,StartApache
+wap.function.HostingPool=RestartTomcat,StartTomcat,StopTomcat,DeployTomcatConfig,DeployApacheConfig,ConfigtestApache,GracefulApache,StopApache,StartApache
 wap.function.ApachePool=DeployApacheConfig,ConfigtestApache,GracefulApache,StopApache,StartApache
 wap.function.TomcatPool=RestartTomcat,StartTomcat,StopTomcat,DeployTomcatConfig
 wap.function.ApacheWorker=DeployApacheConfig,ConfigtestApache,GracefulApache,StopApache,StartApache
-wap.function.TomcatWorker=RestartTomcat,StartTomcat,StopTomcat,DeployTomcatConfig
\ No newline at end of file
+wap.function.TomcatWorker=RestartTomcat,StartTomcat,StopTomcat,DeployTomcatConfig
+
+# Generic DB support
+#lokahi.broker.implementation=org.apache.lokahi.core.common.database.MySqlBroker
+lokahi.broker.implementation=org.apache.lokahi.core.common.database.OracleBroker
+lokahi.broker.autocommit=true
+