schemacrawler.utility.Query.<init>()方法的使用及代码示例

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

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

Query.<init>介绍

[英]Definition of a query, including a name, and parameterized or regular SQL.
[中]查询的定义，包括名称和参数化或常规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.  * 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.  * Query.
  3.  *
  4.  * @return Query
  5.  */
  6. public Query getQuery()
  7. {
  8.  return new Query(name(), queryString);
  9. }

代码示例来源：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. }

代码示例来源：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. private Query getQuery()
  2. {
  3.  final Operation operation = getOperation();
  4.  final Query query;
  5.  if (operation == null)
  6.  {
  7.   final String queryName = command;
  8.   final String queryString;
  9.   if (additionalConfiguration != null)
  10.   {
  11.    queryString = additionalConfiguration.get(queryName);
  12.   }
  13.   else
  14.   {
  15.    queryString = null;
  16.   }
  17.   query = new Query(queryName, queryString);
  18.  }
  19.  else
  20.  {
  21.   query = operation.getQuery();
  22.  }
  23.  return query;
  24. }

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

  1. @Test
  2. public void executeAgainstSchemaNoMatch(final TestContext testContext,
  3.                     final Connection cxn)
  4.  throws Exception
  5. {
  6.  final Query query = new Query("Tables for schema",
  7.                 "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE REGEXP_MATCHES(TABLE_SCHEMA, '${schemas}') ORDER BY TABLE_NAME");
  8.  final InclusionRule schemaInclusionRule = new RegularExpressionInclusionRule("NONE");
  9.  int rows = 0;
  10.  try (final Connection connection = cxn;
  11.    final Statement statement = connection.createStatement();
  12.    final ResultSet resultSet = QueryUtility
  13.     .executeAgainstSchema(query, statement, schemaInclusionRule);)
  14.  {
  15.   while (resultSet.next())
  16.   {
  17.    rows++;
  18.   }
  19.  }
  20.  assertThat(rows, is(0));
  21. }

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

  1. @Test
  2. public void executeAgainstSchema(final TestContext testContext,
  3.                  final Connection cxn)
  4.  throws Exception
  5. {
  6.  final Query query = new Query("Tables for schema",
  7.                 "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE REGEXP_MATCHES(TABLE_SCHEMA, '${schemas}') ORDER BY TABLE_NAME");
  8.  final InclusionRule schemaInclusionRule = new RegularExpressionInclusionRule("BOOKS");
  9.  executeAgainstSchemaTest(testContext, cxn, query, schemaInclusionRule);
  10. }

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

  1. @Test
  2. public void executeAgainstSchemaNoTemplate(final TestContext testContext,
  3.                       final Connection cxn)
  4.  throws Exception
  5. {
  6.  final Query query = new Query("Tables for schema",
  7.                 "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= 'BOOKS' ORDER BY TABLE_NAME");
  8.  final InclusionRule schemaInclusionRule = new RegularExpressionInclusionRule("NONE");
  9.  executeAgainstSchemaTest(testContext, cxn, query, schemaInclusionRule);
  10. }

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

  1. private String getCatalogScope(final Connection connection)
  2. {
  3.  String catalogScope = "ALL";
  4.  try
  5.  {
  6.   final Query query = new Query("Check access to DBA tables",
  7.                  "SELECT TABLE_NAME FROM DBA_TABLES WHERE ROWNUM = 1");
  8.   final Object scalar = executeForScalar(query, connection);
  9.   if (scalar != null)
  10.   {
  11.    catalogScope = "DBA";
  12.   }
  13.  }
  14.  catch (final SchemaCrawlerException e)
  15.  {
  16.   LOGGER.log(Level.FINE, e.getMessage(), e);
  17.   catalogScope = "ALL";
  18.  }
  19.  LOGGER
  20.   .log(Level.INFO,
  21.      new StringFormat("Using Oracle data dictionary catalog scope <%s>",
  22.              catalogScope));
  23.  return catalogScope;
  24. }

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

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

代码示例来源：origin: us.fatehi/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: us.fatehi/schemacrawler-tools

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

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

  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: us.fatehi/schemacrawler-tools

  1. private Query getQuery()
  2. {
  3.  final Operation operation = getOperation();
  4.  final Query query;
  5.  if (operation == null)
  6.  {
  7.   final String queryName = command;
  8.   final String queryString;
  9.   if (additionalConfiguration != null)
  10.   {
  11.    queryString = additionalConfiguration.get(queryName);
  12.   }
  13.   else
  14.   {
  15.    queryString = null;
  16.   }
  17.   query = new Query(queryName, queryString);
  18.  }
  19.  else
  20.  {
  21.   query = operation.getQuery();
  22.  }
  23.  return query;
  24. }

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

  1. private Query getQuery()
  2. {
  3.  final Operation operation = getOperation();
  4.  final Query query;
  5.  if (operation == null)
  6.  {
  7.   final String queryName = command;
  8.   final String queryString;
  9.   if (additionalConfiguration != null)
  10.   {
  11.    queryString = additionalConfiguration.get(queryName);
  12.   }
  13.   else
  14.   {
  15.    queryString = null;
  16.   }
  17.   query = new Query(queryName, queryString);
  18.  }
  19.  else
  20.  {
  21.   query = operation.getQuery();
  22.  }
  23.  return query;
  24. }

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

  1. private String getCatalogScope(final Connection connection)
  2. {
  3.  String catalogScope = "ALL";
  4.  try
  5.  {
  6.   final Query query = new Query("Check access to DBA tables",
  7.                  "SELECT TABLE_NAME FROM DBA_TABLES WHERE ROWNUM = 1");
  8.   final Object scalar = executeForScalar(query, connection);
  9.   if (scalar != null)
  10.   {
  11.    catalogScope = "DBA";
  12.   }
  13.  }
  14.  catch (final SchemaCrawlerException e)
  15.  {
  16.   LOGGER.log(Level.FINE, e.getMessage(), e);
  17.   catalogScope = "ALL";
  18.  }
  19.  LOGGER
  20.   .log(Level.INFO,
  21.      new StringFormat("Using Oracle data dictionary catalog scope <%s>",
  22.              catalogScope));
  23.  return catalogScope;
  24. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

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