svn commit: r417824 - in /incubator/lokahi/lokahi/trunk: conf/db.properties database/procs.sql

[to...@apache.org]

Author: toback
Date: Wed Jun 28 10:33:31 2006
New Revision: 417824

URL: http://svn.apache.org/viewvc?rev=417824&view=rev
Log:
added a missing procedure to delete files.

Modified:
    incubator/lokahi/lokahi/trunk/conf/db.properties
    incubator/lokahi/lokahi/trunk/database/procs.sql

Modified: incubator/lokahi/lokahi/trunk/conf/db.properties
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/conf/db.properties?rev=417824&r1=417823&r2=417824&view=diff
==============================================================================
--- incubator/lokahi/lokahi/trunk/conf/db.properties (original)
+++ incubator/lokahi/lokahi/trunk/conf/db.properties Wed Jun 28 10:33:31 2006
@@ -30,7 +30,7 @@
 oracle.core.environment.update=sp_tmc_update_enviroment
 oracle.core.environment.delete=sp_tmc_drop_environment
 oracle.core.file.by.id=f_tmc_get_file_by_id
-oracle.core.file.delete=
+oracle.core.file.delete=sp_tmc_delete_file
 oracle.core.file.all=f_tmc_get_all_files
 oracle.core.function.by.id=f_tmc_get_function_by_id
 oracle.core.function.by.command=f_tmc_get_function_by_command

Modified: incubator/lokahi/lokahi/trunk/database/procs.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/procs.sql?rev=417824&r1=417823&r2=417824&view=diff
==============================================================================
--- incubator/lokahi/lokahi/trunk/database/procs.sql (original)
+++ incubator/lokahi/lokahi/trunk/database/procs.sql Wed Jun 28 10:33:31 2006
@@ -1,3 +1,15 @@
+CREATE OR REPLACE PROCEDURE sp_tmc_delete_file (v_id IN NUMBER,
+	   	  		  							    v_return OUT NUMBER)
+
+AS
+BEGIN
+	v_return:=0;
+	DELETE FROM TMC_FILES
+	WHERE FILE_ID=v_id;
+	IF SQL%NOTFOUND THEN v_return:=1;
+	END IF;
+END;
+/
 CREATE OR REPLACE PROCEDURE sp_am_delete_apache (v_aId IN NUMBER,
 	   	  		  							    v_return OUT NUMBER)