io.odysz.semantic.util

Class DAHelper

java.lang.Object

io.odysz.semantic.util.DAHelper

public class DAHelper
extends Object

Constructor Summary

Constructors

Constructor and Description
DAHelper()

Method Summary

Modifier and Type	Method and Description
static int	count_(DATranscxt b, String conn, String t, String field, String v) Deprecated. replaced by count(DATranscxt, String, String, Object...)
static int	count(DATranscxt b, String conn, String t, Object... kvs)
static Nyquence	getNyquence(DATranscxt trb, String conn, io.odysz.semantics.meta.TableMeta m, String nyqfield, String... where_eqs)
static long	getValong(DATranscxt trb, String conn, io.odysz.semantics.meta.TableMeta m, String field, String... kvs)
static String	getValstr(io.odysz.transact.sql.Transcxt trb, String conn, io.odysz.semantics.meta.TableMeta m, String valfield, Object... kvs) Load a field from table m.tbl.
static long	loadRecLong(DATranscxt trb, String conn, io.odysz.semantics.meta.TableMeta m, String recId, String field) Deprecated. call getValong(DATranscxt, String, TableMeta, String, String...), e.g. getValong(t, m, target-field, m.pk, recId, ...).
static Nyquence	loadRecNyquence(DATranscxt trb, String conn, io.odysz.semantics.meta.TableMeta m, String recId, String field) Deprecated. replaced by getNyquence(DATranscxt, String, TableMeta, String, String...).
static io.odysz.semantics.SemanticObject	updateFieldByPk(DATranscxt trb, String conn, io.odysz.semantics.meta.TableMeta m, String recId, String field, Object v, io.odysz.semantics.IUser usr) Commit to DB(conn) as user usr, with SQL: update m.tbl set field = v where m.pk = recId
static io.odysz.semantics.SemanticObject	updateFieldWhereEqs(DATranscxt trb, String conn, io.odysz.semantics.IUser usr, io.odysz.semantics.meta.TableMeta m, String field, Object v, Object... whereqs) Commit to DB(conn) as user usr, with SQL: update m.tbl set field = v where whereqs[0] = whereqs[1] and whereqs[2] = whereqs[3] ...

Methods inherited from class java.lang.Object

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

Constructor Detail

DAHelper

public DAHelper()

Method Detail

getValstr

public static String getValstr(io.odysz.transact.sql.Transcxt trb,
                               String conn,
                               io.odysz.semantics.meta.TableMeta m,
                               String valfield,
                               Object... kvs)
                        throws SQLException,
                               io.odysz.transact.x.TransException

Load a field from table m.tbl.

Parameters:

trb - transaction builder

conn -

m - the table must have a pk.

valfield -

kvs -

Returns:

field's value in row[kvs[0] = kvs[1], kvs[1] = kvs[2], ...]

Throws:

SQLException

io.odysz.transact.x.TransException

loadRecLong

public static long loadRecLong(DATranscxt trb,
                               String conn,
                               io.odysz.semantics.meta.TableMeta m,
                               String recId,
                               String field)
                        throws SQLException,
                               io.odysz.transact.x.TransException

Deprecated. call getValong(DATranscxt, String, TableMeta, String, String...), e.g. getValong(t, m, target-field, m.pk, recId, ...).

Parameters:

trb -

conn -

m -

recId -

field -

Returns:

long value

Throws:

SQLException

io.odysz.transact.x.TransException

getValong

public static long getValong(DATranscxt trb,
                             String conn,
                             io.odysz.semantics.meta.TableMeta m,
                             String field,
                             String... kvs)
                      throws SQLException,
                             io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

loadRecNyquence

public static Nyquence loadRecNyquence(DATranscxt trb,
                                       String conn,
                                       io.odysz.semantics.meta.TableMeta m,
                                       String recId,
                                       String field)
                                throws SQLException,
                                       io.odysz.transact.x.TransException

Deprecated. replaced by getNyquence(DATranscxt, String, TableMeta, String, String...).

Parameters:

trb -

conn -

m -

recId -

field -

Returns:

Nyquence

Throws:

SQLException

io.odysz.transact.x.TransException

getNyquence

public static Nyquence getNyquence(DATranscxt trb,
                                   String conn,
                                   io.odysz.semantics.meta.TableMeta m,
                                   String nyqfield,
                                   String... where_eqs)
                            throws SQLException,
                                   io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

updateFieldByPk

public static io.odysz.semantics.SemanticObject updateFieldByPk(DATranscxt trb,
                                                                String conn,
                                                                io.odysz.semantics.meta.TableMeta m,
                                                                String recId,
                                                                String field,
                                                                Object v,
                                                                io.odysz.semantics.IUser usr)
                                                         throws io.odysz.transact.x.TransException,
                                                                SQLException

Commit to DB(conn) as user usr, with SQL:
update m.tbl set field = v where m.pk = recId

Parameters:

trb -

conn -

m -

recId -

field -

v -

usr -

Returns:

affected rows

Throws:

io.odysz.transact.x.TransException

SQLException

updateFieldWhereEqs

public static io.odysz.semantics.SemanticObject updateFieldWhereEqs(DATranscxt trb,
                                                                    String conn,
                                                                    io.odysz.semantics.IUser usr,
                                                                    io.odysz.semantics.meta.TableMeta m,
                                                                    String field,
                                                                    Object v,
                                                                    Object... whereqs)
                                                             throws io.odysz.transact.x.TransException,
                                                                    SQLException

Commit to DB(conn) as user usr, with SQL:
update m.tbl set field = v where whereqs[0] = whereqs[1] and whereqs[2] = whereqs[3] ...

Parameters:

trb -

conn -

usr -

m -

field -

v -

whereqs -

Returns:

affected rows

Throws:

io.odysz.transact.x.TransException

SQLException

count_

public static int count_(DATranscxt b,
                         String conn,
                         String t,
                         String field,
                         String v)
                  throws SQLException,
                         io.odysz.transact.x.TransException

Deprecated. replaced by count(DATranscxt, String, String, Object...)

Parameters:

b -

conn -

t -

field -

v -

Returns:

Throws:

SQLException

io.odysz.transact.x.TransException

count

public static int count(DATranscxt b,
                        String conn,
                        String t,
                        Object... kvs)
                 throws SQLException,
                        io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException