Examples of FromItem

com.caucho.amber.query.FromItem
net.sf.jsqlparser.statement.select.FromItem
An item in a "SELECT [...] FROM item1" statement. (for example a table or a sub-select)
org.apache.metamodel.query.FromItem
Represents a FROM item. FROM items can take different forms:
- table FROMs (eg. "FROM products p")
- join FROMs with an ON clause (eg. "FROM products p INNER JOIN orders o ON p.id = o.product_id")
- subquery FROMs (eg. "FROM (SELECT * FROM products) p")
- expression FROM (any string based from item)
@see FromClause
org.openrdf.sail.rdbms.algebra.base.FromItem
An item in the SQL from clause. @author James Leigh

Examples of org.apache.metamodel.query.FromItem

        }
    JdbcDataContext dataContext = getDataContext();
        Schema schema = dataContext.getDefaultSchema();
    Table departmentTable = schema.getTableByName("DEPARTMENT");
    Table employeeTable = schema.getTableByName("EMPLOYEE");
    Query q = new Query().from(new FromItem(JoinType.INNER, departmentTable.getRelationships(employeeTable)[0]));
    q.select(departmentTable.getColumns()[1]);
    q.select(new SelectItem(employeeTable.getColumns()[4]).setAlias("hire-date"));
    assertEquals(
        "SELECT \"DEPARTMENT\".\"DEPARTMENT\", \"EMPLOYEE\".\"HIRE_DATE\" AS hire-date FROM \"EMPLOYEE\" INNER JOIN \"DEPARTMENT\" ON \"EMPLOYEE\".\"EMP_NO\" = \"DEPARTMENT\".\"MNGR_NO\"",
        q.toString());

View Full Code Here

Examples of org.apache.metamodel.query.FromItem

        Relationship relationship = employeeTable.getRelationships(departmentsTable)[0];
        assertEquals(
                "Relationship[primaryTable=EMPLOYEES,primaryColumns={EMPLOYEE_ID},foreignTable=DEPARTMENTS,foreignColumns={MANAGER_ID}]",
                relationship.toString());


        Query q = new Query().from(new FromItem(JoinType.INNER, relationship)).select(
                employeeTable.getColumnByName("EMAIL"), departmentsTable.getColumnByName("DEPARTMENT_NAME"));
        q.getSelectClause().getItem(0).setAlias("e-mail");


        assertEquals(
                "SELECT \"EMPLOYEES\".\"EMAIL\" AS e-mail, \"DEPARTMENTS\".\"DEPARTMENT_NAME\" FROM HR.\"EMPLOYEES\" INNER JOIN HR.\"DEPARTMENTS\" ON \"EMPLOYEES\".\"EMPLOYEE_ID\" = \"DEPARTMENTS\".\"MANAGER_ID\"",

View Full Code Here

Examples of org.apache.metamodel.query.FromItem

    private FromItem fromItem;


    public TableFromBuilderImpl(Table table, Query query, DataContext dataContext) {
        super(query, dataContext);


        fromItem = new FromItem(table);
        query.from(fromItem);
    }

View Full Code Here

Examples of org.apache.metamodel.query.FromItem

        JdbcDataContext dc = new JdbcDataContext(_connection);
        Schema schema = dc.getDefaultSchema();
        Table productsTable = schema.getTableByName("PRODUCTS");
        Table factTable = schema.getTableByName("ORDERFACT");


        Query q = new Query().from(new FromItem(JoinType.INNER, productsTable.getRelationships(factTable)[0])).select(
                productsTable.getColumns()[0], factTable.getColumns()[0]);
        assertEquals(
                "SELECT \"PRODUCTS\".\"PRODUCTCODE\", \"ORDERFACT\".\"ORDERNUMBER\" FROM PUBLIC.\"PRODUCTS\" INNER JOIN PUBLIC.\"ORDERFACT\" ON \"PRODUCTS\".\"PRODUCTCODE\" = \"ORDERFACT\".\"PRODUCTCODE\"",
                q.toString());
        assertEquals(25000, dc.getFetchSizeCalculator().getFetchSize(q));

View Full Code Here

Examples of org.apache.metamodel.query.FromItem

    Relationship relationship = relationships[0];
    assertEquals(
        "Relationship[primaryTable=PRODUCTS,primaryColumns=[PRODUCTCODE],foreignTable=ORDERFACT,foreignColumns=[PRODUCTCODE]]",
        relationship.toString());


    Query q = new Query().from(new FromItem(JoinType.LEFT, relationship))
        .select(relationship.getForeignColumns())
        .select(relationship.getPrimaryColumns());
    assertEquals(
        "SELECT _ORDERFACT_._PRODUCTCODE_, _PRODUCTS_._PRODUCTCODE_ FROM PUBLIC._PRODUCTS_ LEFT JOIN PUBLIC._ORDERFACT_ ON _PRODUCTS_._PRODUCTCODE_ = _ORDERFACT_._PRODUCTCODE_",
        q.toString().replace('\"', '_'));

View Full Code Here

Examples of org.apache.metamodel.query.FromItem

    sq.select(empSelectItem, custSelectItem);
    assertEquals(
        "SELECT e._EMPLOYEENUMBER_, c._CUSTOMERNUMBER_ FROM PUBLIC._EMPLOYEES_ e, PUBLIC._CUSTOMERS_ c",
        sq.toString().replace('\"', '_'));
    Query q = new Query();
    FromItem sqItem = new FromItem(sq).setAlias("sq");


    custSelectItem.setAlias("c_num");
    empSelectItem.setAlias("e_num");


    q.from(sqItem);

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.base.FromItem


  @Override
  public void meetFromItem(FromItem node)
    throws RuntimeException
  {
    FromItem top = gparent;
    gparent = parent;
    parent = node;
    super.meetFromItem(node);
    parent = gparent;
    gparent = top;

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.base.FromItem


  @Override
  public void meetFromItem(FromItem node)
    throws RuntimeException
  {
    FromItem top = parent;
    parent = join;
    join = node;
    super.meetFromItem(node);
    join = parent;
    parent = top;

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.base.FromItem

    join(var, alias, tableName, true);
  }


  private void join(ColumnVar var, String alias, String tableName, boolean left) {
    if (!isJoined(alias)) {
      FromItem valueJoin = valueJoin(alias, tableName, var, left);
      if (join == parent || join.getFromItem(var.getAlias()) != null) {
        join.addJoin(valueJoin);
      }
      else {
        parent.addJoinBefore(valueJoin, join);

View Full Code Here

Examples of org.openrdf.sail.rdbms.algebra.base.FromItem

  }


  @Override
  public FromItem getFromItem(String alias) {
    for (FromItem from : union) {
      FromItem item = from.getFromItem(alias);
      if (item != null) {
        return item;
      }
    }
    return super.getFromItem(alias);

View Full Code Here

0 1 2 3 4 5

TOP

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.