01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/content/MediaDeleteUnreferenced.java,v 1.1 2001/05/23 09:12:49 marwan Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.content;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: public class MediaDeleteUnreferenced extends TKPrepQuery implements
12: QueryConstants {
13:
14: public final static boolean isPrepared = true;
15:
16: public final static String[] paramOrder = null;
17:
18: public final static Object[][] paramTypes = null;
19:
20: public final static boolean[] setRelevants = null;
21:
22: public final static String sqlString =
23:
24: " DELETE FROM MEDIA ME " + " WHERE NOT EXISTS " + " ( "
25: + " SELECT MEDIA_ID " + " FROM CONTENT_VALUE C_VAL "
26: + " WHERE C_VAL.MEDIA_ID = ME.MEDIA_ID " + " ) "
27:
28: ;
29:
30: public void initQuery(Connection con) {
31: super.initQuery(con, isPrepared, paramOrder, paramTypes,
32: setRelevants, sqlString);
33: }
34: }
|