1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
/*
* Copyright (c) 2007-2009, 2011-2013 Eike Stepper (Berlin, Germany) and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
* Eike Stepper - initial API and implementation
*/
package org.eclipse.net4j.jms.server.internal.jdbc;
import org.eclipse.net4j.db.DBType;
import org.eclipse.net4j.db.DBUtil;
import org.eclipse.net4j.db.ddl.IDBField;
import org.eclipse.net4j.db.ddl.IDBIndex;
import org.eclipse.net4j.db.ddl.IDBSchema;
import org.eclipse.net4j.db.ddl.IDBTable;
import org.eclipse.net4j.spi.db.ddl.InternalDBSchema;
/**
* @author Eike Stepper
*/
public class JMSSchema
{
public static final IDBSchema INSTANCE = DBUtil.createSchema("JMS");
/**
* DBTable Destinations
*/
public static final IDBTable DESTINATIONS = INSTANCE.addTable("destinations"); //$NON-NLS-1$
public static final IDBField DESTINATIONS_NAME = //
DESTINATIONS.addField("name", DBType.VARCHAR, 255); //$NON-NLS-1$
public static final IDBField DESTINATIONS_TYPE = //
DESTINATIONS.addField("type", DBType.INTEGER); //$NON-NLS-1$
public static final IDBIndex INDEX_DESTINATIONS_PK = //
DESTINATIONS.addIndex(IDBIndex.Type.PRIMARY_KEY, DESTINATIONS_NAME);
/**
* DBTable Messages
*/
public static final IDBTable MESSAGES = INSTANCE.addTable("messages"); //$NON-NLS-1$
public static final IDBField MESSAGES_ID = //
MESSAGES.addField("id", DBType.VARCHAR); //$NON-NLS-1$
public static final IDBField MESSAGES_DESTINATION = //
MESSAGES.addField("destination", DBType.VARCHAR); //$NON-NLS-1$
public static final IDBField MESSAGES_PRIORITY = //
MESSAGES.addField("priority", DBType.INTEGER); //$NON-NLS-1$
public static final IDBIndex INDEX_MESSAGES_PK = //
MESSAGES.addIndex(IDBIndex.Type.PRIMARY_KEY, MESSAGES_ID);
/**
* Queries
*/
public static final String QUERY = "SELECT " + DESTINATIONS_TYPE + ", " + MESSAGES_ID + ", " + MESSAGES_PRIORITY //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
+ " FROM " + DESTINATIONS + ", " + MESSAGES + " WHERE " + DESTINATIONS_NAME + "=" + MESSAGES_DESTINATION //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
+ " AND " + DESTINATIONS_NAME + "=?"; //$NON-NLS-1$ //$NON-NLS-2$
static
{
((InternalDBSchema)INSTANCE).lock();
}
}
|
