Examples of com.caucho.db.table.Table

com.caucho.db.table.Table

Table format:

 Block 0: allocation table Block 1: fragment table Block 2: table definition 0    - store data 1024 - table data 1024 - index pointers 2048 - CREATE text Block 3: first data

    throws SQLException
  {
    ArrayList<Expr> exprs = new ArrayList<Expr>();


    for (int i = 0; i < fromItems.length; i++) {
      Table table = fromItems[i].getTable();
      Column []columns = table.getColumns();


      if (_table != null && ! fromItems[i].getName().equals(_table))
        continue;


      for (int j = 0; j < columns.length; j++) {

View Full Code Here

   * Gets a table.
   */
  public Table getTable(String name)
  {
    synchronized (_tables) {
      Table table = _tables.get(name);


      if (table != null)
  return table;
      
      Path dir = _dir;
    
      if (dir == null)
  return null;


      try {
  table = Table.loadFromFile(this, name);


  if (table == null)
    return null;


  table.init();


  _tables.put(name, table);


  return table;
      } catch (Exception e) {

View Full Code Here

   * Drops a table.
   */
  public void dropTable(String name)
    throws SQLException
  {
    Table table = null;


    synchronized (this) {
      table = getTable(name);
      
      if (table == null)
  throw new SQLException(L.l("Table {0} does not exist.  DROP TABLE can only drop an existing table.",
           name));


      _tables.remove(name);


      _cachedQueries.clear();
    }


    table.remove();
  }

View Full Code Here

    if (column == null)
      return Integer.MAX_VALUE;
    
    FromItem fromItem = fromList.get(fromList.size() - 1);
  
    Table table = fromItem.getTable();


    column = table.getColumn(_column);


    if (column == null)
      return 100 * 100 * 100;
    else if (column.isPrimaryKey())
      return 100;

View Full Code Here

  {
    if (_table == null) {
      for (int i = 0; i < fromItems.size(); i++) {
  FromItem fromItem = fromItems.get(i);
  
  Table table = fromItem.getTable();


  Column column = table.getColumn(_column);


  if (column != null)
    return column;
      }


      return null;
    }
    else {
      for (int i = 0; i < fromItems.size(); i++) {
  FromItem fromItem = fromItems.get(i);
  
  if (_table.equals(fromItem.getName())) {
    Table table = fromItem.getTable();


    return table.getColumn(_column);
  }
      }
      
      return null;
    }

View Full Code Here

    String tableName = parseIdentifier();
    
    if (tableName.equalsIgnoreCase("DUAL"))
      return null;


    Table table = _database.getTable(tableName);


    if (table == null)
      throw error(L.l("'{0}' is an unknown table.  'FROM table' requires an existing table.", tableName));


    String name = table.getName();


    int token = scanToken();
    if (token == AS)
      name = parseIdentifier();
    else if (token == IDENTIFIER)

View Full Code Here

      throw error(L.l("expected INTO at `{0}'", tokenName(token)));


    if ((token = scanToken()) != IDENTIFIER)
      throw error(L.l("expected identifier at `{0}'", tokenName(token)));


    Table table = _database.getTable(_lexeme);


    if (table == null)
      throw error(L.l("unknown table `{0}'", tokenName(token)));


    FromItem fromItem = new FromItem(table, table.getName());
    FromItem[] fromList = new FromItem[] { fromItem };


    ArrayList<Column> columns = new ArrayList<Column>();


    if ((token = scanToken()) == '(') {
      do {
  String columnName = parseIdentifier();


  Column column = table.getColumn(columnName);


  if (column == null)
    throw new SQLException(L.l("`{0}' is not a valid column in {1}",
             columnName, table.getName()));
  columns.add(column);
      } while ((token = scanToken()) == ',');


      if (token != ')')
  throw error(L.l("expected ')' at `{0}'", tokenName(token)));


      token = scanToken();
    }
    else {
      Column []columnArray = table.getColumns();


      for (int i = 0; i < columnArray.length; i++)
  columns.add(columnArray[i]);
    }

View Full Code Here

      throw error(L.l("expected FROM at `{0}'", tokenName(token)));


    if ((token = scanToken()) != IDENTIFIER)
      throw error(L.l("expected identifier at `{0}'", tokenName(token)));


    Table table = _database.getTable(_lexeme);


    if (table == null)
      throw error(L.l("unknown table `{0}'", tokenName(token)));


    DeleteQuery query = new DeleteQuery(_database, _sql, table);

View Full Code Here

    int token;


    if ((token = scanToken()) != IDENTIFIER)
      throw error(L.l("expected identifier at '{0}'", tokenName(token)));


    Table table = _database.getTable(_lexeme);


    if (table == null)
      throw error(L.l("unknown table '{0}'", tokenName(token)));


    ValidateQuery query = new ValidateQuery(_database, _sql, table);

View Full Code Here

    if ((token = scanToken()) != IDENTIFIER)
      throw error(L.l("expected identifier at `{0}'", tokenName(token)));


    String name = _lexeme;


    Table table = _database.getTable(name);


    if (table == null)
      throw error(L.l("`{0}' is an unknown table in INSERT.", name));


    if ((token = scanToken()) != SET)

View Full Code Here

0 1 2

TOP

Related Classes of com.caucho.db.table.Table

com.caucho.db.block.Block

com.caucho.db.Database

com.caucho.db.index.BTree

com.caucho.db.index.KeyCompare

com.caucho.db.lock.Lock

com.caucho.db.sql.CreateQuery

com.caucho.db.sql.Expr

com.caucho.db.sql.Parser

com.caucho.db.sql.Query

com.caucho.db.sql.UnboundIdentifierExpr

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.