io.odysz.semantic.DA

Class DatasetCfg

java.lang.Object

io.odysz.semantic.DA.DatasetCfg

public class DatasetCfg
extends Object

Configured dataset.xml manager and helper.
- won't care using CP data source or DB manager (2019.2.28).

Author:

odys-z@github.com

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DatasetCfg.AnTreeNode Representing each tree node.
static class	DatasetCfg.Dataset POJO dataset element as configured in dataset.xml. (oracle mapping information also initialized according to mapping file and the "cols" tag.)
static class	DatasetCfg.TreeSemantics Data structure of s-tree configuration.

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	cfgFile
protected static String	deftId
protected static HashMap<String,DatasetCfg.Dataset>	dss
static int	ixMs2k
static int	ixMysql
static int	ixOrcl
static int	ixSqlit
static int	ixUnknow
protected static String	tag

Constructor Summary

Constructors

Constructor and Description
DatasetCfg()

Method Summary

Modifier and Type	Method and Description
static List<?>	buildForest(AnResultset rs, DatasetCfg.TreeSemantics treeSemtcs) Convert the result set to a forest.
static AnResultset	dataset(String conn, String sk, int page, int size, String... args)
static DatasetCfg.AnTreeNode	formatSemanticNode(DatasetCfg.TreeSemantics treeSmx, AnResultset rs, int level) Create a SemanticObject for tree node with current rs row. TODO should this moved to TreeSemantics?
static DatasetCfg.TreeSemantics	getTreeSemtcs(String sk)
static void	init(String path)
protected static void	load(HashMap<String,DatasetCfg.Dataset> cfgs, String xmlPath) Load all dataset.xml into the argument cfgs. When return, cfgs is loaded with dataset configurations like [id, mysql:sql, orcl:sql, ...].
static AnResultset	loadDataset(String conn, String sk)
static AnResultset	loadDataset(String conn, String sk, int page, int size, String... args)
static AnResultset	loadDataset(String conn, String sk, String... args)
static List<?>	loadStree(String conn, String sk, int page, int size, String... args)
static List<?>	loadStree(String conn, String sk, io.odysz.transact.sql.PageInf page) Load semantic tree configured in dataset.xml.
static void	parseConfigs(HashMap<String,DatasetCfg.Dataset> cfgs, XMLTable xSmtcs)
static Set<String>	sks()

Methods inherited from class java.lang.Object

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

Field Detail

ixMysql

public static final int ixMysql

See Also:

Constant Field Values

ixOrcl

public static final int ixOrcl

See Also:

Constant Field Values

ixMs2k

public static final int ixMs2k

See Also:

Constant Field Values

ixSqlit

public static final int ixSqlit

See Also:

Constant Field Values

ixUnknow

public static final int ixUnknow

See Also:

Constant Field Values

tag

protected static final String tag

See Also:

Constant Field Values

cfgFile

protected static final String cfgFile

See Also:

Constant Field Values

deftId

protected static final String deftId

See Also:

Constant Field Values

dss

protected static HashMap<String,DatasetCfg.Dataset> dss

Constructor Detail

DatasetCfg

public DatasetCfg()

Method Detail

init

public static void init(String path)
                 throws SAXException,
                        IOException

Throws:

SAXException

IOException

sks

public static Set<String> sks()

load

protected static void load(HashMap<String,DatasetCfg.Dataset> cfgs,
                           String xmlPath)
                    throws SAXException,
                           IOException

Load all dataset.xml into the argument cfgs.
When return, cfgs is loaded with dataset configurations like [id, mysql:sql, orcl:sql, ...].

Parameters:

cfgs -

xmlPath -

Throws:

IOException

SAXException

parseConfigs

public static void parseConfigs(HashMap<String,DatasetCfg.Dataset> cfgs,
                                XMLTable xSmtcs)

dataset

public static AnResultset dataset(String conn,
                                  String sk,
                                  int page,
                                  int size,
                                  String... args)
                           throws SQLException,
                                  io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

getTreeSemtcs

public static DatasetCfg.TreeSemantics getTreeSemtcs(String sk)

loadDataset

public static AnResultset loadDataset(String conn,
                                      String sk,
                                      int page,
                                      int size,
                                      String... args)
                               throws SQLException,
                                      io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

loadDataset

public static AnResultset loadDataset(String conn,
                                      String sk)
                               throws SQLException,
                                      io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

loadDataset

public static AnResultset loadDataset(String conn,
                                      String sk,
                                      String... args)
                               throws SQLException,
                                      io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

loadStree

public static List<?> loadStree(String conn,
                                String sk,
                                int page,
                                int size,
                                String... args)
                         throws SQLException,
                                io.odysz.transact.x.TransException

Throws:

SQLException

io.odysz.transact.x.TransException

loadStree

public static List<?> loadStree(String conn,
                                String sk,
                                io.odysz.transact.sql.PageInf page)
                         throws SQLException,
                                io.odysz.transact.x.TransException

Load semantic tree configured in dataset.xml.

Parameters:

conn -

sk -

page - cannot be null

Returns:

forest

Throws:

SQLException

io.odysz.transact.x.TransException

buildForest

public static List<?> buildForest(AnResultset rs,
                                  DatasetCfg.TreeSemantics treeSemtcs)
                           throws SQLException,
                                  SemanticException

Convert the result set to a forest.

Parameters:

rs -

treeSemtcs -

Returns:

built forest

Throws:

SQLException

SemanticException - data structure can not build tree / forest

formatSemanticNode

public static DatasetCfg.AnTreeNode formatSemanticNode(DatasetCfg.TreeSemantics treeSmx,
                                                       AnResultset rs,
                                                       int level)
                                                throws SQLException

Create a SemanticObject for tree node with current rs row.
TODO should this moved to TreeSemantics?

Parameters:

treeSmx -

rs -

level - depth of this node

Returns:

SemanticObject of node

Throws:

SQLException