com.aoindustries.aoserv.client.SchemaTableTable Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of aoserv-client Show documentation
Show all versions of aoserv-client Show documentation
Java client for the AOServ Platform.
/*
* aoserv-client - Java client for the AOServ platform.
* Copyright (C) 2001-2013, 2016 AO Industries, Inc.
* [email protected]
* 7262 Bull Pen Cir
* Mobile, AL 36695
*
* This file is part of aoserv-client.
*
* aoserv-client is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* aoserv-client is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with aoserv-client. If not, see {
SchemaTableTable(AOServConnector connector) {
super(connector, SchemaTable.class);
}
@Override
OrderBy[] getDefaultOrderBy() {
return null;
}
/**
* Supports Integer (table_id), String(name), and SchemaTable.TableID (table_id) keys.
*/
@Override
public SchemaTable get(Object pkey) throws IOException, SQLException {
if(pkey instanceof Integer) return get(((Number)pkey).intValue());
else if(pkey instanceof String) return get((String)pkey);
else if(pkey instanceof SchemaTable.TableID) return get((SchemaTable.TableID)pkey);
else throw new IllegalArgumentException("Must be an Integer, a String, or a SchemaTable.TableID");
}
@Override
public SchemaTable get(int table_id) throws IOException, SQLException {
return getRows().get(table_id);
}
public SchemaTable get(String name) throws IOException, SQLException {
return getUniqueRow(SchemaTable.COLUMN_NAME, name);
}
public SchemaTable get(SchemaTable.TableID tableID) throws IOException, SQLException {
return get(tableID.ordinal());
}
@Override
public SchemaTable.TableID getTableID() {
return SchemaTable.TableID.SCHEMA_TABLES;
}
@Override
boolean handleCommand(String[] args, Reader in, TerminalWriter out, TerminalWriter err, boolean isInteractive) throws SQLException, IOException {
String command = args[0];
if (command.equalsIgnoreCase(AOSHCommand.DESC) || command.equalsIgnoreCase(AOSHCommand.DESCRIBE)) {
if(AOSH.checkParamCount(AOSHCommand.DESCRIBE, args, 1, err)) {
String tableName=args[1];
SchemaTable table=connector.getSchemaTables().get(tableName);
if(table!=null) {
table.printDescription(connector, out, isInteractive);
out.flush();
} else {
err.print("aosh: "+AOSHCommand.DESCRIBE+": table not found: ");
err.println(tableName);
err.flush();
}
}
return true;
} else if (command.equalsIgnoreCase(AOSHCommand.SELECT)) {
int argCount = args.length;
if (argCount >= 4) {
if (argCount == 4 && args[1].equalsIgnoreCase("count(*)")) {
// Is a select count(*)
if ("from".equalsIgnoreCase(args[2])) {
String tableName = args[3];
SchemaTable table = connector.getSchemaTables().get(tableName);
if (table != null) {
Object[] titles = { "count" };
Object[] values = { table.getAOServTable(connector).size()};
SQLUtility.printTable(titles, values, out, isInteractive, new boolean[] {true});
out.flush();
} else {
err.println("aosh: " + AOSHCommand.SELECT + ": table not found: " + tableName);
err.flush();
}
} else {
err.println("aosh: " + AOSHCommand.SELECT + ": unknown parameter: " + args[2]);
err.flush();
}
} else {
List columnNames=new ArrayList<>();
List orderExpressions=new ArrayList<>();
List sortOrders=new ArrayList<>();
String arg1 = args[1];
String tableName;
// Parse the list of columns until "from" is found
int c = 1;
for (; c < argCount; c++) {
String arg = args[c];
if ("from".equalsIgnoreCase(arg)) break;
columnNames.add(arg);
}
if (c >= argCount - 1) {
// The from was not found
err.println("aosh: " + AOSHCommand.SELECT + ": parameter not found: from");
err.flush();
return true;
}
// Get the table name
tableName = args[++c];
c++;
SchemaTable schemaTable=connector.getSchemaTables().get(tableName);
if(schemaTable!=null) {
// Substitute any * columnName and ,
for(int d=0;d tcolumns = schemaTable.getSchemaColumns(connector);
for (int e = 0; e < tcolumns.size(); e++) {
columnName=tcolumns.get(e).column_name;
if(e==0) columnNames.set(d, columnName);
else columnNames.add(++d, columnName);
}
} else {
if(columnName.indexOf(',')!=-1) {
List tcolumns=StringUtility.splitString(columnName, ',');
int addPos=d--;
int numAdded=0;
for (int e = 0; e < tcolumns.size(); e++) {
columnName=tcolumns.get(e).trim();
if(columnName.length()>0) {
if(numAdded==0) columnNames.set(addPos++, columnName);
else columnNames.add(addPos++, columnName);
numAdded++;
}
}
if(numAdded==0) columnNames.remove(addPos);
}
}
}
AOServTable aoServTable=schemaTable.getAOServTable(connector);
// Parse any order by clause
if(c exprs=StringUtility.splitString(columnName, ',');
for(int d=0;d0
&& (
expr.equalsIgnoreCase("asc")
|| expr.equalsIgnoreCase("ascending")
)
) sortOrders.set(sortOrders.size()-1, AOServTable.ASCENDING);
else if(
orderExpressions.size()>0
&& (
expr.equalsIgnoreCase("desc")
|| expr.equalsIgnoreCase("descending")
)
) sortOrders.set(sortOrders.size()-1, AOServTable.DESCENDING);
else if(expr.length()>0) {
orderExpressions.add(aoServTable.getSQLExpression(expr));
sortOrders.add(AOServTable.ASCENDING);
}
}
}
if(orderExpressions.isEmpty()) throw new SQLException("Parse error: no columns listed after 'order by'");
} else throw new SQLException("Parse error: 'by' expected");
} else throw new SQLException("Parse error: 'by' expected");
} else throw new SQLException("Parse error: 'order' expected, found '"+arg+'\'');
}
// Figure out the expressions for each columns
SQLExpression[] valueExpressions=new SQLExpression[columnNames.size()];
SchemaType[] valueTypes=new SchemaType[columnNames.size()];
boolean[] rightAligns=new boolean[columnNames.size()];
for(int d=0;d0;
List rows=aoServTable.getRows();
// Sort if needed
if(orderExpressions.size()>0) {
SQLExpression[] exprs=orderExpressions.toArray(new SQLExpression[orderExpressions.size()]);
boolean[] orders=new boolean[exprs.length];
for(int d=0;d(rows);
connector.getSchemaTypes().sort(JavaSort.getInstance(), rows, exprs, orders);
}
// Convert the results
int numRows=rows.size();
values=new Object[columnNames.size()*numRows];
int valuePos=0;
for(int d=0;d row=rows.get(d);
for(int e=0;e= 2) {
if ("tables".equalsIgnoreCase(args[1])) {
handleCommand(new String[] { "select", "name,", "description", "from", "schema_tables" }, in, out, err, isInteractive);
} else {
err.println("aosh: "+AOSHCommand.SHOW+": unknown parameter: " + args[1]);
err.flush();
}
} else {
err.println("aosh: "+AOSHCommand.SHOW+": not enough parameters");
err.flush();
}
return true;
}
return false;
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy