SQLDatabase db = new SQLDatabase(AppLocal.APP_NAME + " - Database.");
try {
BaseSentence sent = new MetaSentence(m_App.getSession(), "getTables"
, new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})
, new SerializerReadBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING}));
DataResultSet rs = sent.openExec( new Object[] {null, null});
while (rs.next()) {
Object[] aTable = (Object[]) rs.getCurrent();
db.addTable((String) aTable[2]);
}
rs.close();
sent.closeExec();
sent = new MetaSentence(m_App.getSession(), "getColumns"
, new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING})
, new SerializerReadBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING}));
rs = sent.openExec(new Object[] {null, null, null});
while (rs.next()) {
Object[] aColumn = (Object[]) rs.getCurrent();
SQLTable t = db.getTable((String) aColumn[2]);
if (t != null) {
t.addColumn((String) aColumn[3]);
}
}
rs.close();
sent.closeExec();
} catch (BasicException e) {
// e.printStackTrace();
}