Examples of findColumn()


Examples of jimm.datavision.Report.findColumn()

    Column col = report.findColumn("jobs.ID");
    assertNotNull(col);
    assertEquals("public.jobs.ID", col.getId());

    // Found due to exact match
    col = report.findColumn("public.jobs.ID");
    assertNotNull(col);
    assertEquals("public.jobs.ID", col.getId());

    // Not found because schema doesn't match table's schema
    col = report.findColumn("dv_example.jobs.ID");
View Full Code Here

Examples of jimm.datavision.Report.findColumn()

    col = report.findColumn("public.jobs.ID");
    assertNotNull(col);
    assertEquals("public.jobs.ID", col.getId());

    // Not found because schema doesn't match table's schema
    col = report.findColumn("dv_example.jobs.ID");
    assertNull(col);
}

public static void main(String[] args) {
    junit.textui.TestRunner.run(suite());
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  Database db = (Database)report.getDataSource();
  SQLQuery query = (SQLQuery)db.getQuery();

  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("jobs.fk_office_id"));
  assertNotNull(db.findColumn("office.email"));
  assertNotNull(db.findColumn("aggregate_test.value"));

  // We should only have two tables in the query.
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  Database db = (Database)report.getDataSource();
  SQLQuery query = (SQLQuery)db.getQuery();

  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("jobs.fk_office_id"));
  assertNotNull(db.findColumn("office.email"));
  assertNotNull(db.findColumn("aggregate_test.value"));

  // We should only have two tables in the query.
  query.findSelectablesUsed();
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  SQLQuery query = (SQLQuery)db.getQuery();

  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("jobs.fk_office_id"));
  assertNotNull(db.findColumn("office.email"));
  assertNotNull(db.findColumn("aggregate_test.value"));

  // We should only have two tables in the query.
  query.findSelectablesUsed();
  assertEquals(2, query.getNumTables());
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("jobs.fk_office_id"));
  assertNotNull(db.findColumn("office.email"));
  assertNotNull(db.findColumn("aggregate_test.value"));

  // We should only have two tables in the query.
  query.findSelectablesUsed();
  assertEquals(2, query.getNumTables());
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  db.reset(DRIVER_CLASS_NAME, CONNECTION_INFO, DB_NAME, DB_USER,
     DB_PASSWORD);
  // The query doesn't have to be the same object, but it's where
  // clause (and all other information) should darned well be the same.
  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("public.ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("public.jobs.fk_office_id"));
  assertNotNull(db.findColumn("public.office.email"));
  assertNotNull(db.findColumn("public.aggregate_test.value"));

  // Make sure we still have two tables in the query.
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

     DB_PASSWORD);
  // The query doesn't have to be the same object, but it's where
  // clause (and all other information) should darned well be the same.
  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("public.ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("public.jobs.fk_office_id"));
  assertNotNull(db.findColumn("public.office.email"));
  assertNotNull(db.findColumn("public.aggregate_test.value"));

  // Make sure we still have two tables in the query.
  query.findSelectablesUsed();
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  // The query doesn't have to be the same object, but it's where
  // clause (and all other information) should darned well be the same.
  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("public.ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("public.jobs.fk_office_id"));
  assertNotNull(db.findColumn("public.office.email"));
  assertNotNull(db.findColumn("public.aggregate_test.value"));

  // Make sure we still have two tables in the query.
  query.findSelectablesUsed();
  assertEquals(2, query.getNumTables());
View Full Code Here

Examples of jimm.datavision.source.sql.Database.findColumn()

  // clause (and all other information) should darned well be the same.
  assertEquals("{jobs.ID} < 100", query.getWhereClause());
  assertNotNull(db.findColumn("public.ALL_CAPS.COL1"));
  assertNotNull(db.findColumn("public.jobs.fk_office_id"));
  assertNotNull(db.findColumn("public.office.email"));
  assertNotNull(db.findColumn("public.aggregate_test.value"));

  // Make sure we still have two tables in the query.
  query.findSelectablesUsed();
  assertEquals(2, query.getNumTables());
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.