com.yahoo.squidb.sql.Query.compile()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(12.9k)|赞(0)|评价(0)|浏览(279)

本文整理了Java中com.yahoo.squidb.sql.Query.compile方法的一些代码示例，展示了Query.compile的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Query.compile方法的具体详情如下：
包路径：com.yahoo.squidb.sql.Query
类名称：Query
方法名：compile

Query.compile介绍

暂无

代码示例

代码示例来源：origin: yahoo/squidb

  1. /**
  2.  * Execute a statement that returns a 1x1 long result. If you know your result set will only have one row and
  3.  * column, this is much more efficient than calling {@link #rawQuery(String, Object[])} and parsing the cursor.
  4.  * <br>
  5.  * Note: This will throw an exception if the given SQL query returns a result that is not a single column
  6.  *
  7.  * @param query a sql query
  8.  * @return the long result of the query
  9.  */
  10. public long simpleQueryForLong(Query query) {
  11.   CompiledStatement compiled = query.compile(getCompileContext());
  12.   return simpleQueryForLong(compiled.sql, compiled.sqlArgs);
  13. }

代码示例来源：origin: yahoo/squidb

  1. /**
  2.  * Execute a statement that returns a 1x1 String result. If you know your result set will only have one row and
  3.  * column, this is much more efficient than calling {@link #rawQuery(String, Object[])} and parsing the cursor.
  4.  * <br>
  5.  * Note: This will throw an exception if the given SQL query returns a result that is not a single column
  6.  *
  7.  * @param query a sql query
  8.  * @return the String result of the query
  9.  */
  10. public String simpleQueryForString(Query query) {
  11.   CompiledStatement compiled = query.compile(getCompileContext());
  12.   return simpleQueryForString(compiled.sql, compiled.sqlArgs);
  13. }

代码示例来源：origin: yahoo/squidb

  1. /**
  2.  * Directly analogous to {@link #query(Class, Query)}, but instead of returning a result, this method just logs the
  3.  * output of EXPLAIN QUERY PLAN for the given query. This is method is intended for debugging purposes only.
  4.  */
  5. public void explainQueryPlan(Class<? extends AbstractModel> modelClass, Query query) {
  6.   query = inferTableForQuery(modelClass, query);
  7.   CompiledStatement compiled = query.compile(getCompileContext());
  8.   ICursor cursor = rawQuery("EXPLAIN QUERY PLAN " + compiled.sql, compiled.sqlArgs);
  9.   try {
  10.     Logger.d(Logger.LOG_TAG, "Query plan for: " + compiled.sql);
  11.     SquidUtilities.dumpCursor(cursor, -1);
  12.   } finally {
  13.     cursor.close();
  14.   }
  15. }

代码示例来源：origin: yahoo/squidb

  1. /**
  2.  * Query the database
  3.  *
  4.  * @param modelClass the type to parameterize the cursor by. If the query does not contain a FROM clause, the table
  5.  * or view corresponding to this model class will be used.
  6.  * @param query the query to execute
  7.  * @return a {@link SquidCursor} containing the query results
  8.  */
  9. public <TYPE extends AbstractModel> SquidCursor<TYPE> query(Class<TYPE> modelClass, Query query) {
  10.   query = inferTableForQuery(modelClass, query);
  11.   CompiledStatement compiled = query.compile(getCompileContext());
  12.   if (compiled.needsValidation) {
  13.     String validateSql = query.sqlForValidation(getCompileContext());
  14.     ensureSqlCompiles(validateSql); // throws if the statement fails to compile
  15.   }
  16.   ICursor cursor = rawQuery(compiled.sql, compiled.sqlArgs);
  17.   return new SquidCursor<>(cursor, modelClass, query.getFields());
  18. }

代码示例来源：origin: yahoo/squidb

  1. /**
  2.  * Count the number of rows matching a given {@link Criterion}. Use null to count all rows.
  3.  *
  4.  * @param modelClass the model class corresponding to the table
  5.  * @param criterion the criterion to match
  6.  * @return the number of rows matching the given criterion
  7.  */
  8. public int count(Class<? extends AbstractModel> modelClass, Criterion criterion) {
  9.   Property.IntegerProperty countProperty = Property.IntegerProperty.countProperty();
  10.   Query query = Query.select(countProperty);
  11.   if (criterion != null) {
  12.     query.where(criterion);
  13.   }
  14.   query = inferTableForQuery(modelClass, query);
  15.   CompiledStatement compiled = query.compile(getCompileContext());
  16.   acquireNonExclusiveLock();
  17.   try {
  18.     return (int) getDatabase().simpleQueryForLong(compiled.sql, compiled.sqlArgs);
  19.   } finally {
  20.     releaseNonExclusiveLock();
  21.   }
  22. }

代码示例来源：origin: yahoo/squidb

  1. public void testDatabaseProvidedArgumentResolver() {
  2.   database.useCustomArgumentBinder = true;
  3.   Query query = Query.select(TestModel.SOME_ENUM).from(TestModel.TABLE)
  4.       .where(TestModel.SOME_ENUM.eq(TestEnum.APPLE));
  5.   CompiledStatement compiledStatement = query.compile(database.getCompileContext());
  6.   verifyCompiledSqlArgs(compiledStatement, 1, 0);
  7. }

代码示例来源：origin: yahoo/squidb

  1. public void testEnumResolvedUsingName() {
  2.   Query query = Query.select(TestModel.SOME_ENUM).from(TestModel.TABLE)
  3.       .where(TestModel.SOME_ENUM.eq(TestEnum.APPLE));
  4.   CompiledStatement compiledStatement = query.compile(database.getCompileContext());
  5.   verifyCompiledSqlArgs(compiledStatement, 1, "APPLE");
  6. }

代码示例来源：origin: yahoo/squidb

  1. if (tableOrView instanceof SubqueryTable) {
  2.   expectedSql.append("(");
  3.   String compiledSql = ((SubqueryTable) tableOrView).query.compile(database.getCompileContext()).sql;
  4.   expectedSql.append(compiledSql).append(") AS testModelAlias");
  5. } else {
  6.   expectedSql.append(tableOrView.getName()).append(" AS testModelAlias");
  7. assertEquals(expectedSql.toString(), query.compile(database.getCompileContext()).sql);

代码示例来源：origin: yahoo/squidb

  1. public void testNeedsValidationUpdatedBySubqueryTable() {
  2.   Query subquery = Query.select(Thing.PROPERTIES).from(Thing.TABLE).where(Criterion.literal(123));
  3.   subquery.requestValidation();
  4.   assertTrue(subquery.compile(database.getCompileContext()).sql.contains("WHERE (?)"));
  5.   Query baseTestQuery = Query.select().from(Thing.TABLE).where(Thing.FOO.isNotEmpty()).freeze();
  6.   assertFalse(baseTestQuery.needsValidation());
  7.   Query testQuery = baseTestQuery.from(subquery.as("t1"));
  8.   assertTrue(testQuery.compile(database.getCompileContext()).needsValidation);
  9.   assertTrue(testQuery.sqlForValidation(database.getCompileContext()).contains("WHERE ((?))"));
  10.   testQuery = baseTestQuery.innerJoin(subquery.as("t2"), (Criterion[]) null);
  11.   assertTrue(testQuery.compile(database.getCompileContext()).needsValidation);
  12.   assertTrue(testQuery.sqlForValidation(database.getCompileContext()).contains("WHERE ((?))"));
  13.   testQuery = baseTestQuery.union(subquery);
  14.   assertTrue(testQuery.compile(database.getCompileContext()).needsValidation);
  15.   assertTrue(testQuery.sqlForValidation(database.getCompileContext()).contains("WHERE ((?))"));
  16. }

代码示例来源：origin: yahoo/squidb

  1. public void testNeedsValidationUpdatedByQueryFunction() {
  2.   Query subquery = Query.select(Function.max(Thing.ID)).from(Thing.TABLE).where(Criterion.literal(123));
  3.   subquery.requestValidation();
  4.   assertTrue(subquery.compile(database.getCompileContext()).sql.contains("WHERE (?)"));
  5.   Query baseTestQuery = Query.select().from(Thing.TABLE).where(Thing.FOO.isNotEmpty()).freeze();
  6.   assertFalse(baseTestQuery.needsValidation());
  7.   Query testQuery = baseTestQuery.selectMore(subquery.asFunction());
  8.   assertTrue(testQuery.compile(database.getCompileContext()).needsValidation);
  9.   assertTrue(testQuery.sqlForValidation(database.getCompileContext()).contains("WHERE ((?))"));
  10. }

代码示例来源：origin: yahoo/squidb

  1. public void testSelectionArgsGeneration() {
  2.   Query query = Query.select(TestModel.PROPERTIES)
  3.       .where(TestModel.FIRST_NAME.eq("Sam")
  4.           .and(TestModel.BIRTHDAY.gt(17))
  5.           .and(TestModel.LAST_NAME.neq("Smith")));
  6.   CompiledStatement compiledQuery = query.compile(database.getCompileContext());
  7.   verifyCompiledSqlArgs(compiledQuery, 3, "Sam", 17, "Smith");
  8. }

代码示例来源：origin: yahoo/squidb

  1. public void testValidationPropagatesToSubqueryJoinAndCompoundSelect() {
  2.   Query subquery = Query.select(Thing.FOO).from(Thing.TABLE).where(Thing.BAR.gt(0));
  3.   Query joinSubquery = Query.select(Thing.BAR).from(Thing.TABLE).where(Thing.FOO.isNotEmpty());
  4.   Query compoundSubquery = Query.select(Thing.BAZ).from(Thing.TABLE).where(Thing.IS_ALIVE.isTrue());
  5.   SubqueryTable subqueryTable = subquery.as("t1");
  6.   SubqueryTable joinTable = joinSubquery.as("t2");
  7.   Query query = Query.select().from(subqueryTable).innerJoin(joinTable, (Criterion[]) null)
  8.       .union(compoundSubquery);
  9.   final int queryLength = query.compile(database.getCompileContext()).sql.length();
  10.   String withValidation = query.sqlForValidation(database.getCompileContext());
  11.   assertEquals(queryLength + 6, withValidation.length());
  12. }

代码示例来源：origin: com.yahoo.squidb/squidb

  1. /**
  2.  * Execute a statement that returns a 1x1 String result. If you know your result set will only have one row and
  3.  * column, this is much more efficient than calling {@link #rawQuery(String, Object[])} and parsing the cursor.
  4.  * <br>
  5.  * Note: This will throw an exception if the given SQL query returns a result that is not a single column
  6.  *
  7.  * @param query a sql query
  8.  * @return the String result of the query
  9.  */
  10. public String simpleQueryForString(Query query) {
  11.   CompiledStatement compiled = query.compile(getCompileContext());
  12.   return simpleQueryForString(compiled.sql, compiled.sqlArgs);
  13. }

代码示例来源：origin: yahoo/squidb

  1. public void testRawSelection() {
  2.   String selection = COL_LUCKY_NUMBER + " > ? AND " + COL_IS_HAPPY + " != ?";
  3.   String[] selectionArgs = new String[]{"50", "0"};
  4.   ContentProviderQueryBuilder builder = getBuilder();
  5.   Query query = builder.setDataSource(TestModel.TABLE).build(null, selection, selectionArgs, null);
  6.   CompiledStatement compiled = query.compile(database.getCompileContext());
  7.   verifyCompiledSqlArgs(compiled, 2, "50", "0");
  8.   SquidCursor<TestModel> cursor = null;
  9.   try {
  10.     cursor = database.query(TestModel.class, query);
  11.     assertEquals(1, cursor.getCount());
  12.     cursor.moveToFirst();
  13.     assertEquals(model2, buildModelFromCursor(cursor));
  14.   } finally {
  15.     if (cursor != null) {
  16.       cursor.close();
  17.     }
  18.   }
  19. }

代码示例来源：origin: com.yahoo.squidb/squidb

  1. /**
  2.  * Execute a statement that returns a 1x1 long result. If you know your result set will only have one row and
  3.  * column, this is much more efficient than calling {@link #rawQuery(String, Object[])} and parsing the cursor.
  4.  * <br>
  5.  * Note: This will throw an exception if the given SQL query returns a result that is not a single column
  6.  *
  7.  * @param query a sql query
  8.  * @return the long result of the query
  9.  */
  10. public long simpleQueryForLong(Query query) {
  11.   CompiledStatement compiled = query.compile(getCompileContext());
  12.   return simpleQueryForLong(compiled.sql, compiled.sqlArgs);
  13. }

代码示例来源：origin: yahoo/squidb

  1. public void testRawOrderBy() {
  2.   String sortOrder = COL_GIVEN_NAME + " ASC";
  3.   ContentProviderQueryBuilder builder = getBuilder();
  4.   Query query = builder.setDataSource(TestModel.TABLE).build(null, null, null, sortOrder);
  5.   CompiledStatement compiled = query.compile(database.getCompileContext());
  6.   verifyCompiledSqlArgs(compiled, 0);
  7.   SquidCursor<TestModel> cursor = null;
  8.   try {
  9.     cursor = database.query(TestModel.class, query);
  10.     assertEquals(3, cursor.getCount());
  11.     cursor.moveToFirst();
  12.     assertEquals(model3, buildModelFromCursor(cursor));
  13.     cursor.moveToNext();
  14.     assertEquals(model2, buildModelFromCursor(cursor));
  15.     cursor.moveToNext();
  16.     assertEquals(model1, buildModelFromCursor(cursor));
  17.   } finally {
  18.     if (cursor != null) {
  19.       cursor.close();
  20.     }
  21.   }
  22. }

代码示例来源：origin: yahoo/squidb

  1. public void testDefaultOrderBy() {
  2.   ContentProviderQueryBuilder builder = getBuilder();
  3.   builder.setDefaultOrder(TestModel.LUCKY_NUMBER.desc());
  4.   Query query = builder.setDataSource(TestModel.TABLE).build(null, null, null, null);
  5.   CompiledStatement compiled = query.compile(database.getCompileContext());
  6.   verifyCompiledSqlArgs(compiled, 0);
  7.   SquidCursor<TestModel> cursor = null;
  8.   try {
  9.     cursor = database.query(TestModel.class, query);
  10.     assertEquals(3, cursor.getCount());
  11.     cursor.moveToFirst();
  12.     assertEquals(model2, buildModelFromCursor(cursor));
  13.     cursor.moveToNext();
  14.     assertEquals(model1, buildModelFromCursor(cursor));
  15.     cursor.moveToNext();
  16.     assertEquals(model3, buildModelFromCursor(cursor));
  17.   } finally {
  18.     if (cursor != null) {
  19.       cursor.close();
  20.     }
  21.   }
  22. }

代码示例来源：origin: com.yahoo.squidb/squidb

  1. /**
  2.  * Directly analogous to {@link #query(Class, Query)}, but instead of returning a result, this method just logs the
  3.  * output of EXPLAIN QUERY PLAN for the given query. This is method is intended for debugging purposes only.
  4.  */
  5. public void explainQueryPlan(Class<? extends AbstractModel> modelClass, Query query) {
  6.   query = inferTableForQuery(modelClass, query);
  7.   CompiledStatement compiled = query.compile(getCompileContext());
  8.   ICursor cursor = rawQuery("EXPLAIN QUERY PLAN " + compiled.sql, compiled.sqlArgs);
  9.   try {
  10.     Logger.d(Logger.LOG_TAG, "Query plan for: " + compiled.sql);
  11.     SquidUtilities.dumpCursor(cursor, -1);
  12.   } finally {
  13.     cursor.close();
  14.   }
  15. }

代码示例来源：origin: com.yahoo.squidb/squidb

  1. /**
  2.  * Query the database
  3.  *
  4.  * @param modelClass the type to parameterize the cursor by. If the query does not contain a FROM clause, the table
  5.  * or view corresponding to this model class will be used.
  6.  * @param query the query to execute
  7.  * @return a {@link SquidCursor} containing the query results
  8.  */
  9. public <TYPE extends AbstractModel> SquidCursor<TYPE> query(Class<TYPE> modelClass, Query query) {
  10.   query = inferTableForQuery(modelClass, query);
  11.   CompiledStatement compiled = query.compile(getCompileContext());
  12.   if (compiled.needsValidation) {
  13.     String validateSql = query.sqlForValidation(getCompileContext());
  14.     ensureSqlCompiles(validateSql); // throws if the statement fails to compile
  15.   }
  16.   ICursor cursor = rawQuery(compiled.sql, compiled.sqlArgs);
  17.   return new SquidCursor<>(cursor, modelClass, query.getFields());
  18. }

代码示例来源：origin: com.yahoo.squidb/squidb

  1. /**
  2.  * Count the number of rows matching a given {@link Criterion}. Use null to count all rows.
  3.  *
  4.  * @param modelClass the model class corresponding to the table
  5.  * @param criterion the criterion to match
  6.  * @return the number of rows matching the given criterion
  7.  */
  8. public int count(Class<? extends AbstractModel> modelClass, Criterion criterion) {
  9.   Property.IntegerProperty countProperty = Property.IntegerProperty.countProperty();
  10.   Query query = Query.select(countProperty);
  11.   if (criterion != null) {
  12.     query.where(criterion);
  13.   }
  14.   query = inferTableForQuery(modelClass, query);
  15.   CompiledStatement compiled = query.compile(getCompileContext());
  16.   acquireNonExclusiveLock();
  17.   try {
  18.     return (int) getDatabase().simpleQueryForLong(compiled.sql, compiled.sqlArgs);
  19.   } finally {
  20.     releaseNonExclusiveLock();
  21.   }
  22. }

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com