/** * Method declaration * * * @param name * @param channel * * @return * * @throws Exception */ public Table getSystemTable(string name, Channel channel) { if (name.Equals("SYSTEM_PROCEDURES")) { Table t = createTable(name); t.addColumn("PROCEDURE_" + META_CAT, Column.VARCHAR); t.addColumn("PROCEDURE_" + META_SCHEM, Column.VARCHAR); t.addColumn("PROCEDURE_NAME", Column.VARCHAR); t.addColumn("NUM_INPUT_PARAMS", Column.INTEGER); t.addColumn("NUM_OUTPUT_PARAMS", Column.INTEGER); t.addColumn("NUM_RESULT_SETS", Column.INTEGER); t.addColumn("REMARKS", Column.VARCHAR); t.addColumn("PROCEDURE_TYPE", Column.SMALLINT); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_PROCEDURECOLUMNS")) { Table t = createTable(name); t.addColumn("PROCEDURE_" + META_CAT, Column.VARCHAR); t.addColumn("PROCEDURE_" + META_SCHEM, Column.VARCHAR); t.addColumn("PROCEDURE_NAME", Column.VARCHAR); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn("COLUMN_TYPE", Column.SMALLINT); t.addColumn("DATA_TYPE", Column.SMALLINT); t.addColumn("TYPE_NAME", Column.VARCHAR); t.addColumn("PRECISION", Column.INTEGER); t.addColumn("LENGTH", Column.INTEGER); t.addColumn("SCALE", Column.SMALLINT); t.addColumn("RADIX", Column.SMALLINT); t.addColumn("NULLABLE", Column.SMALLINT); t.addColumn("REMARKS", Column.VARCHAR); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_TABLES")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TABLE_NAME", Column.VARCHAR); t.addColumn("TABLE_TYPE", Column.VARCHAR); t.addColumn("REMARKS", Column.VARCHAR); t.createPrimaryKey(); for (int i = 0; i < tTable.Count; i++) { Table table = (Table)tTable[i]; object[] o = t.getNewRow(); o[2] = table.getName(); o[3] = "TABLE"; t.insert(o, null); } return(t); } else if (name.Equals("SYSTEM_SCHEMAS")) { Table t = createTable(name); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_CATALOGS")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_TABLETYPES")) { Table t = createTable(name); t.addColumn("TABLE_TYPE", Column.VARCHAR); t.createPrimaryKey(); object[] o = t.getNewRow(); o[0] = "TABLE"; t.insert(o, null); return(t); } else if (name.Equals("SYSTEM_COLUMNS")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TABLE_NAME", Column.VARCHAR); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn("DATA_TYPE", Column.SMALLINT); t.addColumn("TYPE_NAME", Column.VARCHAR); t.addColumn(META_COLUMN_SIZE, Column.INTEGER); t.addColumn(META_BUFFER_LENGTH, Column.INTEGER); t.addColumn(META_DECIMAL_DIGITS, Column.INTEGER); t.addColumn(META_NUM_PREC_RADIX, Column.INTEGER); t.addColumn("NULLABLE", Column.INTEGER); t.addColumn("REMARKS", Column.VARCHAR); // Access and Intersolv do not return this fields t.addColumn("COLUMN_DEF", Column.VARCHAR); t.addColumn("SQL_DATA_TYPE", Column.VARCHAR); t.addColumn("SQL_DATETIME_SUB", Column.INTEGER); t.addColumn("CHAR_OCTET_LENGTH", Column.INTEGER); t.addColumn("ORDINAL_POSITION", Column.VARCHAR); t.addColumn("IS_NULLABLE", Column.VARCHAR); t.createPrimaryKey(); for (int i = 0; i < tTable.Count; i++) { Table table = (Table)tTable[i]; int columns = table.getColumnCount(); for (int j = 0; j < columns; j++) { object[] o = t.getNewRow(); o[2] = table.getName(); o[3] = table.getColumnName(j); o[4] = table.getColumnType(j); o[5] = Column.getType(table.getColumnType(j)); int nullable; if (table.getColumnIsNullable(j)) { nullable = true.ToInt32(); } else { nullable = false.ToInt32(); } o[10] = nullable; if (table.getIdentityColumn() == j) { o[11] = "IDENTITY"; } t.insert(o, null); } } return(t); } else if (name.Equals("SYSTEM_COLUMNPRIVILEGES")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TABLE_NAME", Column.VARCHAR); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn("GRANTOR", Column.VARCHAR); t.addColumn("GRANTEE", Column.VARCHAR); t.addColumn("PRIVILEGE", Column.VARCHAR); t.addColumn("IS_GRANTABLE", Column.VARCHAR); t.createPrimaryKey(); /* * // todo: get correct info * for(int i=0;i<tTable.size();i++) { * Table table=(Table)tTable.elementAt(i); * int columns=table.getColumnCount(); * for(int j=0;j<columns;j++) { * object o[]=t.getNewRow(); * o[2]=table.getName(); * o[3]=table.getColumnName(j); * o[4]="sa"; * o[6]="FULL"; * o[7]="NO"; * t.insert(o,null); * } * } */ return(t); } else if (name.Equals("SYSTEM_TABLEPRIVILEGES")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TABLE_NAME", Column.VARCHAR); t.addColumn("GRANTOR", Column.VARCHAR); t.addColumn("GRANTEE", Column.VARCHAR); t.addColumn("PRIVILEGE", Column.VARCHAR); t.addColumn("IS_GRANTABLE", Column.VARCHAR); t.createPrimaryKey(); for (int i = 0; i < tTable.Count; i++) { Table table = (Table)tTable[i]; object[] o = t.getNewRow(); o[2] = table.getName(); o[3] = "sa"; o[5] = "FULL"; t.insert(o, null); } return(t); } else if (name.Equals("SYSTEM_BESTROWIDENTIFIER")) { Table t = createTable(name); t.addColumn("SCOPE", Column.SMALLINT); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn("DATA_TYPE", Column.SMALLINT); t.addColumn("TYPE_NAME", Column.VARCHAR); t.addColumn(META_COLUMN_SIZE, Column.INTEGER); t.addColumn(META_BUFFER_LENGTH, Column.INTEGER); t.addColumn(META_DECIMAL_DIGITS, Column.SMALLINT); t.addColumn("PSEUDO_COLUMN", Column.SMALLINT); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_VERSIONCOLUMNS")) { Table t = createTable(name); t.addColumn("SCOPE", Column.INTEGER); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn("DATA_TYPE", Column.SMALLINT); t.addColumn("TYPE_NAME", Column.VARCHAR); t.addColumn(META_COLUMN_SIZE, Column.SMALLINT); t.addColumn(META_BUFFER_LENGTH, Column.INTEGER); t.addColumn(META_DECIMAL_DIGITS, Column.SMALLINT); t.addColumn("PSEUDO_COLUMN", Column.SMALLINT); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_PRIMARYKEYS")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TABLE_NAME", Column.VARCHAR); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn("KEY_SEQ", Column.SMALLINT); t.addColumn("PK_NAME", Column.VARCHAR); t.createPrimaryKey(); for (int i = 0; i < tTable.Count; i++) { Table table = (Table)tTable[i]; Index index = table.getIndex("SYSTEM_PK"); int[] cols = index.getColumns(); int len = cols.Length; for (int j = 0; j < len; j++) { object[] o = t.getNewRow(); o[2] = table.getName(); o[3] = table.getColumnName(cols[j]); o[4] = j + 1; o[5] = "SYSTEM_PK"; t.insert(o, null); } } return(t); } else if (name.Equals("SYSTEM_IMPORTEDKEYS")) { Table t = createTable(name); t.addColumn("PKTABLE_" + META_CAT, Column.VARCHAR); t.addColumn("PKTABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("PKTABLE_NAME", Column.VARCHAR); t.addColumn("PKCOLUMN_NAME", Column.VARCHAR); t.addColumn("FKTABLE_" + META_CAT, Column.VARCHAR); t.addColumn("FKTABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("FKTABLE_NAME", Column.VARCHAR); t.addColumn("FKCOLUMN_NAME", Column.VARCHAR); t.addColumn("KEY_SEQ", Column.SMALLINT); t.addColumn("UPDATE_RULE", Column.SMALLINT); t.addColumn("DELETE_RULE", Column.SMALLINT); t.addColumn("FK_NAME", Column.VARCHAR); t.addColumn("PK_NAME", Column.VARCHAR); t.addColumn("DEFERRABILITY", Column.SMALLINT); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_EXPORTEDKEYS")) { Table t = createTable(name); t.addColumn("PKTABLE_" + META_CAT, Column.VARCHAR); t.addColumn("PKTABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("PKTABLE_NAME", Column.VARCHAR); t.addColumn("PKCOLUMN_NAME", Column.VARCHAR); t.addColumn("FKTABLE_" + META_CAT, Column.VARCHAR); t.addColumn("FKTABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("FKTABLE_NAME", Column.VARCHAR); t.addColumn("FKCOLUMN_NAME", Column.VARCHAR); t.addColumn("KEY_SEQ", Column.SMALLINT); t.addColumn("UPDATE_RULE", Column.SMALLINT); t.addColumn("DELETE_RULE", Column.SMALLINT); t.addColumn("FK_NAME", Column.VARCHAR); t.addColumn("PK_NAME", Column.VARCHAR); t.addColumn("DEFERRABILITY", Column.SMALLINT); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_CROSSREFERENCE")) { Table t = createTable(name); t.addColumn("PKTABLE_" + META_CAT, Column.VARCHAR); t.addColumn("PKTABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("PKTABLE_NAME", Column.VARCHAR); t.addColumn("PKCOLUMN_NAME", Column.VARCHAR); t.addColumn("FKTABLE_" + META_CAT, Column.VARCHAR); t.addColumn("FKTABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("FKTABLE_NAME", Column.VARCHAR); t.addColumn("FKCOLUMN_NAME", Column.VARCHAR); t.addColumn("KEY_SEQ", Column.INTEGER); t.addColumn("UPDATE_RULE", Column.SMALLINT); t.addColumn("DELETE_RULE", Column.SMALLINT); t.addColumn("FK_NAME", Column.VARCHAR); t.addColumn("PK_NAME", Column.VARCHAR); t.addColumn("DEFERRABILITY", Column.SMALLINT); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_TYPEINFO")) { Table t = createTable(name); t.addColumn("TYPE_NAME", Column.VARCHAR); t.addColumn("DATA_TYPE", Column.SMALLINT); t.addColumn("PRECISION", Column.INTEGER); t.addColumn("LITERAL_PREFIX", Column.VARCHAR); t.addColumn("LITERAL_SUFFIX", Column.VARCHAR); t.addColumn("CREATE_PARAMS", Column.VARCHAR); t.addColumn("NULLABLE", Column.SMALLINT); t.addColumn("CASE_SENSITIVE", Column.VARCHAR); t.addColumn("SEARCHABLE", Column.SMALLINT); t.addColumn("UNSIGNED_ATTRIBUTE", Column.BIT); t.addColumn(META_FIXED_PREC_SCALE, Column.BIT); t.addColumn("AUTO_INCREMENT", Column.BIT); t.addColumn("LOCAL_TYPE_NAME", Column.VARCHAR); t.addColumn("MINIMUM_SCALE", Column.SMALLINT); t.addColumn("MAXIMUM_SCALE", Column.SMALLINT); // this columns are not supported by Access and Intersolv t.addColumn("SQL_DATE_TYPE", Column.INTEGER); t.addColumn("SQL_DATETIME_SUB", Column.INTEGER); t.addColumn("NUM_PREC_RADIX", Column.INTEGER); t.createPrimaryKey(); for (int i = 0; i < Column.TYPES.Length; i++) { object[] o = t.getNewRow(); int type = Column.TYPES[i]; o[0] = Column.getType(type); o[1] = type; o[2] = 0; // precision o[6] = true; // need Column to track nullable for this o[7] = true; // case sensitive o[8] = true;; o[9] = false; // unsigned o[10] = (type == Column.NUMERIC || type == Column.DECIMAL); o[11] = (type == Column.INTEGER); o[12] = o[0]; o[13] = 0; o[14] = 0; // maximum scale o[15] = 0; o[16] = o[15]; o[17] = 10; t.insert(o, null); } return(t); } else if (name.Equals("SYSTEM_INDEXINFO")) { Table t = createTable(name); t.addColumn("TABLE_" + META_CAT, Column.VARCHAR); t.addColumn("TABLE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TABLE_NAME", Column.VARCHAR); t.addColumn("NON_UNIQUE", Column.BIT); t.addColumn("INDEX_QUALIFIER", Column.VARCHAR); t.addColumn("INDEX_NAME", Column.VARCHAR); t.addColumn("TYPE", Column.SMALLINT); t.addColumn(META_ORDINAL_POSITON, Column.SMALLINT); t.addColumn("COLUMN_NAME", Column.VARCHAR); t.addColumn(META_ASC_OR_DESC, Column.VARCHAR); t.addColumn("CARDINALITY", Column.INTEGER); t.addColumn("PAGES", Column.INTEGER); t.addColumn("FILTER_CONDITION", Column.VARCHAR); t.createPrimaryKey(); for (int i = 0; i < tTable.Count; i++) { Table table = (Table)tTable[i]; Index index = null; while (true) { index = table.getNextIndex(index); if (index == null) { break; } int[] cols = index.getColumns(); int len = cols.Length; // this removes the column that makes every index unique if (!index.isUnique()) { len--; } for (int j = 0; j < len; j++) { object[] o = t.getNewRow(); o[2] = table.getName(); o[3] = !index.isUnique(); o[5] = index.getName(); o[6] = 1; o[7] = (j + 1); o[8] = table.getColumnName(cols[j]); o[9] = "A"; t.insert(o, null); } } } return(t); } else if (name.Equals("SYSTEM_UDTS")) { Table t = createTable(name); t.addColumn("TYPE_" + META_CAT, Column.VARCHAR); t.addColumn("TYPE_" + META_SCHEM, Column.VARCHAR); t.addColumn("TYPE_NAME", Column.VARCHAR); t.addColumn("CLASS_NAME", Column.BIT); t.addColumn("DATA_TYPE", Column.VARCHAR); t.addColumn("REMARKS", Column.VARCHAR); t.createPrimaryKey(); return(t); } else if (name.Equals("SYSTEM_CONNECTIONINFO")) { Table t = createTable(name); t.addColumn("KEY", Column.VARCHAR); t.addColumn("VALUE", Column.VARCHAR); t.createPrimaryKey(); object[] o = t.getNewRow(); o[0] = "USER"; o[1] = channel.getUsername(); t.insert(o, null); o = t.getNewRow(); o[0] = "READONLY"; o[1] = channel.isReadOnly() ? "TRUE" : "FALSE"; t.insert(o, null); o = t.getNewRow(); o[0] = "MAXROWS"; o[1] = "" + channel.getMaxRows(); t.insert(o, null); o = t.getNewRow(); o[0] = "DATABASE"; o[1] = "" + channel.getDatabase().getName(); t.insert(o, null); o = t.getNewRow(); o[0] = "IDENTITY"; o[1] = "" + channel.getLastIdentity(); t.insert(o, null); return(t); } else if (name.Equals("SYSTEM_USERS")) { Table t = createTable(name); t.addColumn("USER", Column.VARCHAR); t.addColumn("ADMIN", Column.BIT); t.createPrimaryKey(); ArrayList v = aAccess.getUsers(); for (int i = 0; i < v.Count; i++) { User u = (User)v[i]; // todo: this is not a nice implementation if (u == null) { continue; } string user = u.getName(); if (!user.Equals("PUBLIC")) { object[] o = t.getNewRow(); o[0] = user; o[1] = u.isAdmin(); t.insert(o, null); } } return(t); } return(null); }
/** * Method declaration * * * @param bDrop * @param bInsert * @param bCached * @param channel * * @return * * @throws Exception */ public Result getScript(bool bDrop, bool bInsert, bool bCached, Channel channel) { channel.checkAdmin(); Result r = new Result(1); r.iType[0] = Column.VARCHAR; r.sTable[0] = "SYSTEM_SCRIPT"; r.sLabel[0] = "COMMAND"; r.sName[0] = "COMMAND"; StringBuilder a = new StringBuilder(); for (int i = 0; i < tTable.Count; i++) { Table t = (Table)tTable[i]; if (bDrop) { addRow(r, "DROP TABLE " + t.getName()); } a.Remove(0, a.Length); a.Append("CREATE "); if (t.isCached()) { a.Append("CACHED "); } a.Append("TABLE "); a.Append(t.getName()); a.Append("("); int columns = t.getColumnCount(); Index pki = t.getIndex("SYSTEM_PK"); int pk = (pki == null) ? -1 : pki.getColumns()[0]; for (int j = 0; j < columns; j++) { a.Append(t.getColumnName(j)); a.Append(" "); a.Append(Column.getType(t.getType(j))); if (!t.getColumnIsNullable(j)) { a.Append(" NOT NULL"); } if (j == t.getIdentityColumn()) { a.Append(" IDENTITY"); } if (j == pk) { a.Append(" PRIMARY KEY"); } if (j < columns - 1) { a.Append(","); } } ArrayList v = t.getConstraints(); for (int j = 0; j < v.Count; j++) { Constraint c = (Constraint)v[j]; if (c.getType() == Constraint.FOREIGN_KEY) { a.Append(",FOREIGN KEY"); int[] col = c.getRefColumns(); a.Append(getColumnList(c.getRef(), col, col.Length)); a.Append("REFERENCES "); a.Append(c.getMain().getName()); col = c.getMainColumns(); a.Append(getColumnList(c.getMain(), col, col.Length)); } else if (c.getType() == Constraint.UNIQUE) { a.Append(",UNIQUE"); int[] col = c.getMainColumns(); a.Append(getColumnList(c.getMain(), col, col.Length)); } } a.Append(")"); addRow(r, a.ToString()); Index index = null; while (true) { index = t.getNextIndex(index); if (index == null) { break; } string indexname = index.getName(); if (indexname.Equals("SYSTEM_PK")) { continue; } else if (indexname.StartsWith("SYSTEM_FOREIGN_KEY")) { // foreign keys where created in the 'create table' continue; } else if (indexname.StartsWith("SYSTEM_CONSTRAINT")) { // constraints where created in the 'create table' continue; } a.Remove(0, a.Length); a.Append("CREATE "); if (index.isUnique()) { a.Append("UNIQUE "); } a.Append("INDEX "); a.Append(indexname); a.Append(" ON "); a.Append(t.getName()); int[] col = index.getColumns(); int len = col.Length; if (!index.isUnique()) { len--; } a.Append(getColumnList(t, col, len)); addRow(r, a.ToString()); } if (bInsert) { Index primary = t.getPrimaryIndex(); Node x = primary.first(); bool integrity = true; if (x != null) { integrity = false; addRow(r, "SET REFERENTIAL_INTEGRITY FALSE"); } while (x != null) { addRow(r, t.getInsertStatement(x.getData())); x = primary.next(x); } if (!integrity) { addRow(r, "SET REFERENTIAL_INTEGRITY TRUE"); } } if (bCached && t.isCached()) { a.Remove(0, a.Length); a.Append("SET TABLE "); a.Append(t.getName()); a.Append(" INDEX '"); a.Append(t.getIndexRoots()); a.Append("'"); addRow(r, a.ToString()); } } ArrayList uList = aAccess.getUsers(); for (int i = 0; i < uList.Count; i++) { User u = (User)uList[i]; // todo: this is not a nice implementation if (u == null) { continue; } string name = u.getName(); if (!name.Equals("PUBLIC")) { a.Remove(0, a.Length); a.Append("CREATE USER "); a.Append(name); a.Append(" PASSWORD "); a.Append("\"" + u.getPassword() + "\""); if (u.isAdmin()) { a.Append(" ADMIN"); } addRow(r, a.ToString()); } Hashtable rights = u.getRights(); if (rights == null) { continue; } foreach (string dbObject in rights.Keys) { int right = (int)rights[dbObject]; if (right == 0) { continue; } a.Remove(0, a.Length); a.Append("GRANT "); a.Append(Access.getRight(right)); a.Append(" ON "); a.Append(dbObject); a.Append(" TO "); a.Append(u.getName()); addRow(r, a.ToString()); } } if (dDatabase.isIgnoreCase()) { addRow(r, "SET IGNORECASE TRUE"); } Hashtable h = dDatabase.getAlias(); foreach (string alias in h.Keys) { string java = (string)h[alias]; addRow(r, "CREATE ALIAS " + alias + " FOR \"" + java + "\""); } return(r); }
/** * Method declaration * * ALTER TABLE tableName ADD COLUMN columnName columnType; * ALTER TABLE tableName DELETE COLUMN columnName; * * <B>Note: </B>The only change I've made to Sergio's original code was * changing the insert's to call insertNoCheck to bypass the trigger * mechanism that is a part of hsqldb 1.60 and beyond. - Mark Tutt * * @return * * @throws Exception */ public Result processAlter() { tTokenizer.getThis("TABLE"); string token = tTokenizer.getstring(); cChannel.checkReadWrite(); // cChannel.check(token,Access.ALTER); --> Accessul nu-l inca controleaza... string tName = token; string swap = tName + "SWAP"; // nimicirea swapului... dDatabase.execute("DROP TABLE " + swap, cChannel); Table initialTable = dDatabase.getTable(token, cChannel); int count = 0; token = tTokenizer.getstring(); if (token.Equals("ADD")) { token = tTokenizer.getstring(); if (token.Equals("COLUMN")) { Table swapTable = new Table(dDatabase, true, swap, initialTable.isCached()); // copiem coloanele (fara date) din tabelul initial in swap for (int i = 0; i < initialTable.getColumnCount(); i++) { Column aColumn = initialTable.getColumn(i); swapTable.addColumn(aColumn); } // end Of copiem coloanele... // aflam daca are PrimaryKey & o cream... string cName = tTokenizer.getstring(); string cType = tTokenizer.getstring(); int iType = Column.getTypeNr(cType); string sToken = cType; // int primarykeycolumn = -1; bool identity = false; int column = initialTable.getColumnCount() + 1; // !-- // stolen from CREATE TABLE... string sColumn = cName; if (iType == Column.VARCHAR && dDatabase.isIgnoreCase()) { iType = Column.VARCHAR_IGNORECASE; } sToken = tTokenizer.getstring(); if (iType == Column.DOUBLE && sToken.Equals("PRECISION")) { sToken = tTokenizer.getstring(); } if (sToken.Equals("(")) { // overread length do { sToken = tTokenizer.getstring(); } while (!sToken.Equals(")")); sToken = tTokenizer.getstring(); } // !-- bool nullable = true; if (sToken.Equals("NULL")) { sToken = tTokenizer.getstring(); } else if (sToken.Equals("NOT")) { tTokenizer.getThis("NULL"); nullable = false; sToken = tTokenizer.getstring(); } /* * if(sToken.Equals("IDENTITY")) { * identity=true; * Trace.check(primarykeycolumn==-1,Trace.SECOND_PRIMARY_KEY,sColumn); * sToken=tTokenizer.getstring(); * primarykeycolumn=column; * } * * if(sToken.Equals("PRIMARY")) { * tTokenizer.getThis("KEY"); * Trace.check(identity || primarykeycolumn==-1, * Trace.SECOND_PRIMARY_KEY,sColumn); * primarykeycolumn=column; * //sToken=tTokenizer.getstring(); * } * //end of STOLEN... */ swapTable.addColumn(cName, iType, nullable, identity); // under construction... if (initialTable.getColumnCount() < initialTable.getInternalColumnCount()) { swapTable.createPrimaryKey(); } else { swapTable.createPrimaryKey(initialTable.getPrimaryIndex().getColumns()[0]); } // endof PrimaryKey... // sa ne farimam cu indicii... ;-(( Index idx = null; while (true) { idx = initialTable.getNextIndex(idx); if (idx == null) { break; } if (idx == initialTable.getPrimaryIndex()) { continue; } swapTable.createIndex(idx); } // end of Index... cChannel.commit(); dDatabase.linkTable(swapTable); Tokenizer tmpTokenizer = new Tokenizer("SELECT * FROM " + tName); Parser pp = new Parser(dDatabase, tmpTokenizer, cChannel); string ff = tmpTokenizer.getstring(); if (!initialTable.isEmpty()) { Record n = ((Result) pp.processSelect()).rRoot; do { object[] row = swapTable.getNewRow(); object[] row1 = n.data; for (int i = 0; i < initialTable.getColumnCount(); i++) { row[i] = row1[i]; } swapTable.insertNoCheck(row, cChannel); n = n.next; } while (n != null); } dDatabase.execute("DROP TABLE " + tName, cChannel); // cream tabelul vechi cu proprietatile celui nou... initialTable = new Table(dDatabase, true, tName, swapTable.isCached()); for (int i = 0; i < swapTable.getColumnCount(); i++) { Column aColumn = swapTable.getColumn(i); initialTable.addColumn(aColumn); } if (swapTable.getColumnCount() < swapTable.getInternalColumnCount()) { initialTable.createPrimaryKey(); } else { initialTable.createPrimaryKey(swapTable.getPrimaryIndex().getColumns()[0]); } // endof PrimaryKey... // sa ne farimam cu indicii... ;-(( idx = null; while (true) { idx = swapTable.getNextIndex(idx); if (idx == null) { break; } if (idx == swapTable.getPrimaryIndex()) { continue; } initialTable.createIndex(idx); } // end of Index... cChannel.commit(); dDatabase.linkTable(initialTable); // end of cream... // copiem datele din swap in tabel... tmpTokenizer = new Tokenizer("SELECT * FROM " + swap); pp = new Parser(dDatabase, tmpTokenizer, cChannel); ff = tmpTokenizer.getstring(); if (!swapTable.isEmpty()) { Record n = ((Result) pp.processSelect()).rRoot; do { object[] row = initialTable.getNewRow(); object[] row1 = n.data; for (int i = 0; i < swapTable.getColumnCount(); i++) { row[i] = row1[i]; } initialTable.insertNoCheck(row, cChannel); n = n.next; } while (n != null); // end of copiem... } dDatabase.execute("DROP TABLE " + swap, cChannel); count = 4; } else { throw Trace.error(Trace.UNEXPECTED_TOKEN, token); } } else if (token.Equals("DELETE")) { token = tTokenizer.getstring(); if (token.Equals("COLUMN")) { Table swapTable = new Table(dDatabase, true, swap, initialTable.isCached()); string cName = tTokenizer.getstring(); int undesired = initialTable.getColumnNr(cName); for (int i = 0; i < initialTable.getColumnCount(); i++) { Column aColumn = initialTable.getColumn(i); if (i != undesired) { swapTable.addColumn(aColumn); } } int pKey = -1; // !-- if (initialTable.getColumnCount() < initialTable.getInternalColumnCount()) { swapTable.createPrimaryKey(); } else { int[] cols = initialTable.getPrimaryIndex().getColumns(); pKey = cols[0]; if ((cols[0] > undesired) || (cols[0] + cols.Length < undesired)) { if (undesired < initialTable.getPrimaryIndex().getColumns()[0]) { // reindexarea... for (int i = 0; i < cols.Length; i++) { cols[i]--; } // endOf reindexarea... } // MT: This initially wouldn't compile, missing the array index on cols[] swapTable.createPrimaryKey(cols[0]); } else { swapTable.createPrimaryKey(); } } // endof PrimaryKey... // sa ne farimam cu indicii... ;-(( Index idx = null; while (true) { idx = initialTable.getNextIndex(idx); if (idx == null) { break; } if (idx == initialTable.getPrimaryIndex()) { continue; } bool flag = true; int[] cols = idx.getColumns(); for (int i = 0; i < cols.Length; i++) { if (cols[i] == undesired) { flag = false; } } if (flag) { Index tIdx; for (int i = 0; i < cols.Length; i++) { if (cols[i] > undesired) { cols[i]--; } } tIdx = new Index(idx.getName(), idx.getColumns(), idx.getType(), idx.isUnique()); swapTable.createIndex(tIdx); } } // !-- cChannel.commit(); dDatabase.linkTable(swapTable); Tokenizer tmpTokenizer = new Tokenizer("SELECT * FROM " + tName); Parser pp = new Parser(dDatabase, tmpTokenizer, cChannel); string ff = tmpTokenizer.getstring(); if (!initialTable.isEmpty()) { Record n = ((Result) pp.processSelect()).rRoot; do { object[] row = swapTable.getNewRow(); object[] row1 = n.data; int j = 0; for (int i = 0; i < initialTable.getColumnCount(); i++) { if (i != undesired) { row[j] = row1[i]; j++; } } swapTable.insertNoCheck(row, cChannel); n = n.next; } while (n != null); } dDatabase.execute("DROP TABLE " + tName, cChannel); // cream tabelul vechi cu proprietatile celui nou... initialTable = new Table(dDatabase, true, tName, swapTable.isCached()); for (int i = 0; i < swapTable.getColumnCount(); i++) { Column aColumn = swapTable.getColumn(i); initialTable.addColumn(aColumn); } // !-- if (swapTable.getColumnCount() < swapTable.getInternalColumnCount()) { initialTable.createPrimaryKey(); } else { initialTable.createPrimaryKey(swapTable.getPrimaryIndex().getColumns()[0]); } // endof PrimaryKey... // sa ne farimam cu indicii... ;-(( idx = null; while (true) { idx = swapTable.getNextIndex(idx); if (idx == null) { break; } if (idx == swapTable.getPrimaryIndex()) { continue; } initialTable.createIndex(idx); } // end of Index... // !-- cChannel.commit(); dDatabase.linkTable(initialTable); // end of cream... // copiem datele din swap in tabel... tmpTokenizer = new Tokenizer("SELECT * FROM " + swap); pp = new Parser(dDatabase, tmpTokenizer, cChannel); ff = tmpTokenizer.getstring(); if (!swapTable.isEmpty()) { Record n = ((Result) pp.processSelect()).rRoot; do { object[] row = initialTable.getNewRow(); object[] row1 = n.data; for (int i = 0; i < swapTable.getColumnCount(); i++) { row[i] = row1[i]; } initialTable.insertNoCheck(row, cChannel); n = n.next; } while (n != null); // end of copiem... } dDatabase.execute("DROP TABLE " + swap, cChannel); count = 3; } else { throw Trace.error(Trace.UNEXPECTED_TOKEN, token); } count = 3; } Result r = new Result(); r.iUpdateCount = count; // --> nu tre inca...?? return r; }