schemacrawler.utility.Query类的使用及代码示例

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

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

Query介绍

[英]A SQL query. May be parameterized with ant-like variable references.
[中]SQL查询。可以使用类似蚂蚁的变量引用进行参数化。

代码示例

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * Gets the additional attributes SQL for columns, from the additional
  3.  * configuration.
  4.  *
  5.  * @return Additional attributes SQL for columns.
  6.  */
  7. public Query getQuery(final InformationSchemaKey key)
  8. {
  9.  requireNonNull(key, "No SQL query key provided");
  10.  return new Query(key.name(), informationSchemaQueries.get(key));
  11. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * {@inheritDoc}
  3.  */
  4. @Override
  5. public void handleData(final Query query, final ResultSet rows)
  6.  throws SchemaCrawlerException
  7. {
  8.  String title;
  9.  if (query != null)
  10.  {
  11.   title = query.getName();
  12.  }
  13.  else
  14.  {
  15.   title = "";
  16.  }
  17.  handleData(title, rows);
  18. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. private static String getQuery(final Query query)
  2. {
  3.  return expandTemplate(query.getQuery());
  4. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. MetadataResultSet(final Query query,
  2.          final Statement statement,
  3.          final InclusionRule schemaInclusionRule)
  4.  throws SQLException
  5. {
  6.  this(executeAgainstSchema(query, statement, schemaInclusionRule));
  7.  if (query.hasName())
  8.  {
  9.   description = query.getName();
  10.  }
  11. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. handler.handleInfoEnd();
  2. if (query.isQueryOver())
  3.  final String sql = query.getQuery();
  4.  try (final ResultSet results = executeSql(statement, sql, true);)

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. MetadataResultSet(final Query query,
  2.          final Statement statement,
  3.          final InclusionRule schemaInclusionRule)
  4.  throws SQLException
  5. {
  6.  this(executeAgainstSchema(query, statement, schemaInclusionRule));
  7.  if (query.hasName())
  8.  {
  9.   description = query.getName();
  10.  }
  11. }

代码示例来源：origin: us.fatehi/schemacrawler-tools

  1. handler.handleInfoEnd();
  2. if (query.isQueryOver())
  3.  final String sql = query.getQuery();
  4.  try (final ResultSet results = executeSql(statement, sql, true);)

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * Gets the additional attributes SQL for columns, from the additional
  3.  * configuration.
  4.  *
  5.  * @return Additional attributes SQL for columns.
  6.  */
  7. public Query getQuery(final InformationSchemaKey key)
  8. {
  9.  requireNonNull(key, "No SQL query key provided");
  10.  return new Query(key.name(), informationSchemaQueries.get(key));
  11. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * {@inheritDoc}
  3.  */
  4. @Override
  5. public void handleData(final Query query, final ResultSet rows)
  6.  throws SchemaCrawlerException
  7. {
  8.  String title;
  9.  if (query != null)
  10.  {
  11.   title = query.getName();
  12.  }
  13.  else
  14.  {
  15.   title = "";
  16.  }
  17.  handleData(title, rows);
  18. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. private static String getQuery(final Query query)
  2. {
  3.  return expandTemplate(query.getQuery());
  4. }

代码示例来源：origin: us.fatehi/schemacrawler

  1. MetadataResultSet(final Query query,
  2.          final Statement statement,
  3.          final InclusionRule schemaInclusionRule)
  4.  throws SQLException
  5. {
  6.  this(executeAgainstSchema(query, statement, schemaInclusionRule));
  7.  if (query.hasName())
  8.  {
  9.   description = query.getName();
  10.  }
  11. }

代码示例来源：origin: us.fatehi/schemacrawler

  1. handler.handleInfoEnd();
  2. if (query.isQueryOver())
  3.  final String sql = query.getQuery();
  4.  try (final ResultSet results = executeSql(statement, sql, true);)

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * Query.
  3.  *
  4.  * @return Query
  5.  */
  6. public Query getQuery()
  7. {
  8.  return new Query(name(), queryString);
  9. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. public static Object executeForScalar(final Query query,
  2.                    final Connection connection)
  3.  throws SchemaCrawlerException
  4. {
  5.  requireNonNull(query, "No query provided");
  6.  final String sql = getQuery(query);
  7.  LOGGER.log(Level.FINE,
  8.        new StringFormat("Executing %s: %n%s", query.getName(), sql));
  9.  return executeSqlForScalar(connection, sql);
  10. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * Gets the query with parameters substituted.
  3.  *
  4.  * @param schemaInclusionRule
  5.  *        Schema inclusion rule
  6.  * @return Ready-to-execute query
  7.  */
  8. private static String getQuery(final Query query,
  9.                 final InclusionRule schemaInclusionRule)
  10. {
  11.  final Map<String, String> properties = new HashMap<>();
  12.  properties.put("schemas", ".*");
  13.  if (schemaInclusionRule != null
  14.    && schemaInclusionRule instanceof InclusionRuleWithRegularExpression)
  15.  {
  16.   final String schemaInclusionPattern = ((InclusionRuleWithRegularExpression) schemaInclusionRule)
  17.    .getInclusionPattern().pattern();
  18.   if (!isBlank(schemaInclusionPattern))
  19.   {
  20.    properties.put("schemas", schemaInclusionPattern);
  21.   }
  22.  }
  23.  String sql = query.getQuery();
  24.  sql = expandTemplate(sql, properties);
  25.  sql = expandTemplate(sql);
  26.  return sql;
  27. }

代码示例来源：origin: us.fatehi/schemacrawler-api

  1. MetadataResultSet(final Query query,
  2.          final Statement statement,
  3.          final InclusionRule schemaInclusionRule)
  4.  throws SQLException
  5. {
  6.  this(executeAgainstSchema(query, statement, schemaInclusionRule));
  7.  if (query.hasName())
  8.  {
  9.   description = query.getName();
  10.  }
  11. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. @Test
  2. public void executeForScalar(final TestContext testContext,
  3.                final Connection cxn)
  4.  throws Exception
  5. {
  6.  final Query query = new Query("Select scalar",
  7.                 "SELECT POSTALCODE FROM PUBLIC.BOOKS.AUTHORS WHERE LASTNAME = 'Shaffer'");
  8.  final Object scalar = QueryUtility.executeForScalar(query, cxn);
  9.  assertThat(scalar, notNullValue());
  10.  assertThat(scalar, is("37032"));
  11. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. public static ResultSet executeAgainstSchema(final Query query,
  2.                        final Statement statement,
  3.                        final InclusionRule schemaInclusionRule)
  4.  throws SQLException
  5. {
  6.  requireNonNull(query, "No query provided");
  7.  final String sql = getQuery(query, schemaInclusionRule);
  8.  LOGGER.log(Level.FINE,
  9.        new StringFormat("Executing %s: %n%s", query.getName(), sql));
  10.  return executeSql(statement, sql);
  11. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. /**
  2.  * Gets the query with parameters substituted.
  3.  *
  4.  * @param schemaInclusionRule
  5.  *        Schema inclusion rule
  6.  * @return Ready-to-execute query
  7.  */
  8. private static String getQuery(final Query query,
  9.                 final InclusionRule schemaInclusionRule)
  10. {
  11.  final Map<String, String> properties = new HashMap<>();
  12.  properties.put("schemas", ".*");
  13.  if (schemaInclusionRule != null
  14.    && schemaInclusionRule instanceof InclusionRuleWithRegularExpression)
  15.  {
  16.   final String schemaInclusionPattern = ((InclusionRuleWithRegularExpression) schemaInclusionRule)
  17.    .getInclusionPattern().pattern();
  18.   if (!isBlank(schemaInclusionPattern))
  19.   {
  20.    properties.put("schemas", schemaInclusionPattern);
  21.   }
  22.  }
  23.  String sql = query.getQuery();
  24.  sql = expandTemplate(sql, properties);
  25.  sql = expandTemplate(sql);
  26.  return sql;
  27. }

代码示例来源：origin: schemacrawler/SchemaCrawler

  1. @Test
  2. public void executeForScalarNotPresent(final TestContext testContext,
  3.                     final Connection cxn)
  4.  throws Exception
  5. {
  6.  final Query query = new Query("Select scalar",
  7.                 "SELECT POSTALCODE FROM PUBLIC.BOOKS.AUTHORS WHERE LASTNAME = 'Fatehi'");
  8.  final Object scalar = QueryUtility.executeForScalar(query, cxn);
  9.  assertThat(scalar, nullValue());
  10. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

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