Пример #1
0
  @Test
  public void testAuthentication() throws Exception {

    Credentials credentials = TestUtil.getCredentials();

    Properties props = new Properties();
    props.setProperty("credentials", credentials.toString());

    con = DriverManager.getConnection(TestUtil.getURL(), props);
    Statement statement = con.createStatement();
    assertNotNull(statement);

    System.err.println(" executing query with default");

    System.err.println(" executing query with default 2");
    ResultSet rs =
        statement.executeQuery(
            "SELECT default.name, count(reviewID) AS  numReviews"
                + " FROM default UNNEST reviewList AS reviewID"
                + " GROUP BY default.defaultId, default.name"
                + " HAVING count(reviewID) >= 20"
                + " ORDER BY numReviews desc");

    System.err.println(" executing query with default 3");
    rs =
        statement.executeQuery(
            "SELECT default.name, ARRAY_LENGTH(reviewList) as numReviews"
                + " FROM default"
                + " WHERE array_length(reviewList) >= 20"
                + " ORDER BY numReviews desc");

    System.err.println(" executing query with default 4");
    rs =
        statement.executeQuery(
            "SELECT default.name, default.categories, reviews"
                + " FROM default"
                + " JOIN reviews ON KEYS default.reviewList"
                + " LIMIT 5");

    System.err.println(" executing query with default 5");
    rs =
        statement.executeQuery(
            "SELECT default.name, AVG(reviews.rating) AS avg_rating"
                + " FROM reviews"
                + " JOIN default ON KEYS reviews.defaultId"
                + " GROUP BY default.name"
                + " ORDER BY avg_rating DESC"
                + " LIMIT 5");

    System.err.println(" executing query with default 6");
    rs =
        statement.executeQuery(
            "SELECT default.name, reviews"
                + " FROM default"
                + " NEST reviews ON KEYS default.reviewList"
                + " LIMIT 5");

    System.err.println(" executing query with default 7");
    rs =
        statement.executeQuery(
            "SELECT default.name,"
                + "  ARRAY review.rating FOR review IN reviews END AS ratings"
                + " FROM default"
                + " NEST reviews ON KEYS default.reviewList"
                + " LIMIT 5");

    System.err.println(" executing query with default 8");
    rs =
        statement.executeQuery(
            "SELECT cat, default, reviews"
                + " FROM default UNNEST default.categories AS cat"
                + " JOIN reviews ON KEYS default.reviewList"
                + " LIMIT 5");

    rs =
        statement.executeQuery(
            "SELECT cat, AVG(reviews.rating) as avg_rating,"
                + "  COUNT(reviews.rating) as num_ratings"
                + " FROM default UNNEST default.categories AS cat"
                + " JOIN reviews ON KEYS default.reviewList"
                + " WHERE substr(reviews.reviewedAt, 0, 4) = '2014'"
                + " GROUP BY cat"
                + " ORDER BY avg_rating desc");

    rs =
        statement.executeQuery(
            "SELECT cat, SUM(lineItems.count * default.unitPrice) AS revenue,"
                + " AVG(lineItems.count * default.unitPrice) AS avg_revenue,"
                + " SUM(lineItems.count) AS units_sold"
                + " FROM purchases UNNEST lineItems"
                + " JOIN default ON KEYS lineItems.default UNNEST default.categories AS cat"
                + " WHERE purchases.purchasedAt IS NOT NULL"
                + " AND SUBSTR(purchases.purchasedAt, 0, 4) = '2013'"
                + " GROUP BY cat ORDER BY cat desc");

    rs =
        statement.executeQuery(
            "SELECT p_sample.default.name,"
                + "  ARRAY_LENGTH(p_sample.default.reviewList) as numReviews"
                + " FROM (select p from default p limit 50) as p_sample"
                + " ORDER BY numReviews desc"
                + " LIMIT 5");
  }
Пример #2
0
 @Before
 public void openConnection() throws Exception {
   TestUtil.resetEnvironmentProperties(null);
   TestUtil.initializeCluster(true);
 }