com.joanju.cg.db
Class XrefTable

java.lang.Object
  com.joanju.cg.db.XrefTable

public class XrefTable
extends java.lang.Object

Provides inter-package access to the Xref table. Not part of the public API.

Field Summary

static int

X_ANY Use ANY as an argument to query() or delete().

Constructor Summary

XrefTable()

Method Summary

static void	delete(int sc, int sa, int tc, int ta) Delete from the Xref table with a given search criteria.
static void	delete(Xref x) Delete an xref record from the database.
static java.util.HashSet<java.lang.Integer>	flushWrittenCuidSet() Get and empty the written CUID set.
static java.util.ArrayList<Xref>	query(int sc, int sa, int tc, int ta) Get a list of Xref records matching a search criteria.
static void	store(java.util.Collection<Xref> list) Store Xref records into the xref table.
static void	store(int sc, int sa, int tc, int ta) Store a record into the xref table.
static void	store(Xref xref) Store an Xref record into the xref table.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

X_ANY

public static final int X_ANY

Use ANY as an argument to query() or delete().

See Also:

Constant Field Values

Constructor Detail

XrefTable

public XrefTable()

Method Detail

delete

public static void delete(Xref x)
                   throws java.sql.SQLException

Delete an xref record from the database.

Throws:

java.sql.SQLException

delete

public static void delete(int sc,
                          int sa,
                          int tc,
                          int ta)
                   throws java.sql.SQLException

Delete from the Xref table with a given search criteria. Columns are: SourceCU, SourceAddress, TargetCU, TargetAddress. Use ANY for the columns you don't have values for.

Throws:

java.sql.SQLException

flushWrittenCuidSet

public static java.util.HashSet<java.lang.Integer> flushWrittenCuidSet()
                                                                throws java.sql.SQLException

Get and empty the written CUID set. The written CUID set is the set of all CUIDs which have had xref records written or deleted, where the CUID is in the xref source.

Throws:

java.sql.SQLException

query

public static java.util.ArrayList<Xref> query(int sc,
                                              int sa,
                                              int tc,
                                              int ta)
                                       throws java.sql.SQLException

Get a list of Xref records matching a search criteria. Columns are: SourceCU, SourceAddress, TargetCU, TargetAddress. Use ANY for the columns you don't have values for.

Throws:

java.sql.SQLException

store

public static void store(int sc,
                         int sa,
                         int tc,
                         int ta)
                  throws java.sql.SQLException

Store a record into the xref table.

Throws:

java.sql.SQLException

store

public static void store(java.util.Collection<Xref> list)
                  throws java.sql.SQLException

Store Xref records into the xref table.

Throws:

java.sql.SQLException

store

public static void store(Xref xref)
                  throws java.sql.SQLException

Store an Xref record into the xref table.

Throws:

java.sql.SQLException