org.jdbi.v3.sqlobject.customizer.Bind.<init>()方法的使用及代码示例

x33g5p2x  于2022-01-17 转载在 其他  
字(10.3k)|赞(0)|评价(0)|浏览(180)

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

Bind.<init>介绍

暂无

代码示例

代码示例来源：origin: prestodb/presto

  1. /**
  2.    * Returns the most specific exact-match selector for a given environment, source and query type.
  3.    * NULL values in the environment and query type fields signify wildcards.
  4.    */
  5.   @SqlQuery("SELECT resource_group_id\n" +
  6.       "FROM exact_match_source_selectors\n" +
  7.       "WHERE source = :source\n" +
  8.       "  AND (environment = :environment OR environment IS NULL)\n" +
  9.       "  AND (query_type = :query_type OR query_type IS NULL)\n" +
  10.       "ORDER BY environment IS NULL, query_type IS NULL\n" +
  11.       "LIMIT 1")
  12.   String getExactMatchResourceGroup(
  13.       @Bind("environment") String environment,
  14.       @Bind("source") String source,
  15.       @Bind("query_type") String queryType);
  16. }

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("INSERT INTO selectors\n" +
  2.     "(resource_group_id, priority, user_regex, source_regex, query_type, client_tags, selector_resource_estimate)\n" +
  3.     "VALUES (:resource_group_id, :priority, :user_regex, :source_regex, :query_type, :client_tags, :selector_resource_estimate)")
  4. void insertSelector(
  5.     @Bind("resource_group_id") long resourceGroupId,
  6.     @Bind("priority") long priority,
  7.     @Bind("user_regex") String userRegex,
  8.     @Bind("source_regex") String sourceRegex,
  9.     @Bind("query_type") String queryType,
  10.     @Bind("client_tags") String clientTags,
  11.     @Bind("selector_resource_estimate") String selectorResourceEstimate);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("INSERT INTO exact_match_source_selectors (environment, source, query_type, update_time, resource_group_id)\n" +
  2.     "VALUES (:environment, :source, :query_type, now(), :resourceGroupId)\n")
  3. void insertExactMatchSelector(
  4.     @Bind("environment") String environment,
  5.     @Bind("source") String source,
  6.     @Bind("query_type") String queryType,
  7.     @Bind("resourceGroupId") String resourceGroupId);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("DELETE FROM selectors WHERE resource_group_id = :resource_group_id\n" +
  2.     " AND ((user_regex IS NULL AND :user_regex IS NULL) OR user_regex = :user_regex)\n" +
  3.     " AND ((source_regex IS NULL AND :source_regex IS NULL) OR source_regex = :source_regex)\n" +
  4.     " AND ((client_tags IS NULL AND :client_tags IS NULL) OR client_tags = :client_tags)")
  5. void deleteSelector(
  6.     @Bind("resource_group_id") long resourceGroupId,
  7.     @Bind("user_regex") String userRegex,
  8.     @Bind("source_regex") String sourceRegex,
  9.     @Bind("client_tags") String clientTags);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("INSERT INTO resource_groups\n" +
  2.     "(resource_group_id, name, soft_memory_limit, max_queued, soft_concurrency_limit, hard_concurrency_limit, scheduling_policy, scheduling_weight, jmx_export, soft_cpu_limit, hard_cpu_limit, parent, environment)\n" +
  3.     "VALUES (:resource_group_id, :name, :soft_memory_limit, :max_queued, :soft_concurrency_limit, :hard_concurrency_limit, :scheduling_policy, :scheduling_weight, :jmx_export, :soft_cpu_limit, :hard_cpu_limit, :parent, :environment)")
  4. void insertResourceGroup(
  5.     @Bind("resource_group_id") long resourceGroupId,
  6.     @Bind("name") String name,
  7.     @Bind("soft_memory_limit") String softMemoryLimit,
  8.     @Bind("max_queued") int maxQueued,
  9.     @Bind("soft_concurrency_limit") Integer softConcurrencyLimit,
  10.     @Bind("hard_concurrency_limit") int hardConcurrencyLimit,
  11.     @Bind("scheduling_policy") String schedulingPolicy,
  12.     @Bind("scheduling_weight") Integer schedulingWeight,
  13.     @Bind("jmx_export") Boolean jmxExport,
  14.     @Bind("soft_cpu_limit") String softCpuLimit,
  15.     @Bind("hard_cpu_limit") String hardCpuLimit,
  16.     @Bind("parent") Long parent,
  17.     @Bind("environment") String environment);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("UPDATE selectors SET\n" +
  2.     " resource_group_id = :resource_group_id\n" +
  3.     ", user_regex = :user_regex\n" +
  4.     ", source_regex = :source_regex\n" +
  5.     ", client_tags = :client_tags\n" +
  6.     "WHERE resource_group_id = :resource_group_id\n" +
  7.     " AND ((user_regex IS NULL AND :old_user_regex IS NULL) OR user_regex = :old_user_regex)\n" +
  8.     " AND ((source_regex IS NULL AND :old_source_regex IS NULL) OR source_regex = :old_source_regex)\n" +
  9.     " AND ((client_tags IS NULL AND :old_client_tags IS NULL) OR client_tags = :old_client_tags)")
  10. void updateSelector(
  11.     @Bind("resource_group_id") long resourceGroupId,
  12.     @Bind("user_regex") String newUserRegex,
  13.     @Bind("source_regex") String newSourceRegex,
  14.     @Bind("client_tags") String newClientTags,
  15.     @Bind("old_user_regex") String oldUserRegex,
  16.     @Bind("old_source_regex") String oldSourceRegex,
  17.     @Bind("old_client_tags") String oldClientTags);

代码示例来源：origin: prestodb/presto

  1. @SqlQuery("" +
  2.       "SELECT\n" +
  3.       "  suite\n" +
  4.       ", name\n" +
  5.       ", test_catalog\n" +
  6.       ", test_schema\n" +
  7.       ", test_prequeries\n" +
  8.       ", test_query\n" +
  9.       ", test_postqueries\n" +
  10.       ", test_username\n" +
  11.       ", test_password\n" +
  12.       ", control_catalog\n" +
  13.       ", control_schema\n" +
  14.       ", control_prequeries\n" +
  15.       ", control_query\n" +
  16.       ", control_postqueries\n" +
  17.       ", control_username\n" +
  18.       ", control_password\n" +
  19.       ", session_properties_json\n" +
  20.       "FROM verifier_queries\n" +
  21.       "WHERE suite = :suite\n" +
  22.       "ORDER BY id\n" +
  23.       "LIMIT :limit")
  24.   @UseRowMapper(QueryPairMapper.class)
  25.   List<QueryPair> getQueriesBySuite(@Bind("suite") String suite, @Bind("limit") int limit);
  26. }

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("INSERT INTO resource_groups_global_properties\n" +
  2.     "(name, value) VALUES (:name, :value)")
  3. void insertResourceGroupsGlobalProperties(
  4.     @Bind("name") String name,
  5.     @Bind("value") String value);

代码示例来源：origin: prestodb/presto

  1. @SqlQuery("SELECT S.resource_group_id, S.priority, S.user_regex, S.source_regex, S.query_type, S.client_tags, S.selector_resource_estimate\n" +
  2.     "FROM selectors S\n" +
  3.     "JOIN resource_groups R ON (S.resource_group_id = R.resource_group_id)\n" +
  4.     "WHERE R.environment = :environment\n" +
  5.     "ORDER by priority DESC")
  6. @UseRowMapper(SelectorRecord.Mapper.class)
  7. List<SelectorRecord> getSelectors(@Bind("environment") String environment);

代码示例来源：origin: prestodb/presto

  1. @SqlQuery("SELECT resource_group_id, name, soft_memory_limit, max_queued, soft_concurrency_limit, " +
  2.     "  hard_concurrency_limit, scheduling_policy, scheduling_weight, jmx_export, soft_cpu_limit, " +
  3.     "  hard_cpu_limit, parent\n" +
  4.     "FROM resource_groups\n" +
  5.     "WHERE environment = :environment\n")
  6. @UseRowMapper(ResourceGroupSpecBuilder.Mapper.class)
  7. List<ResourceGroupSpecBuilder> getResourceGroups(@Bind("environment") String environment);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("UPDATE resource_groups SET\n" +
  2.     " resource_group_id = :resource_group_id\n" +
  3.     ", name = :name\n" +
  4.     ", soft_memory_limit = :soft_memory_limit\n" +
  5.     ", max_queued = :max_queued\n" +
  6.     ", soft_concurrency_limit = :soft_concurrency_limit\n" +
  7.     ", hard_concurrency_limit = :hard_concurrency_limit\n" +
  8.     ", scheduling_policy = :scheduling_policy\n" +
  9.     ", scheduling_weight = :scheduling_weight\n" +
  10.     ", jmx_export = :jmx_export\n" +
  11.     ", soft_cpu_limit = :soft_cpu_limit\n" +
  12.     ", hard_cpu_limit = :hard_cpu_limit\n" +
  13.     ", parent = :parent\n" +
  14.     ", environment = :environment\n" +
  15.     "WHERE resource_group_id = :resource_group_id")
  16. void updateResourceGroup(
  17.     @Bind("resource_group_id") long resourceGroupId,
  18.     @Bind("name") String resourceGroup,
  19.     @Bind("soft_memory_limit") String softMemoryLimit,
  20.     @Bind("max_queued") int maxQueued,
  21.     @Bind("soft_concurrency_limit") Integer softConcurrencyLimit,
  22.     @Bind("hard_concurrency_limit") int hardConcurrencyLimit,
  23.     @Bind("scheduling_policy") String schedulingPolicy,
  24.     @Bind("scheduling_weight") Integer schedulingWeight,
  25.     @Bind("jmx_export") Boolean jmxExport,
  26.     @Bind("soft_cpu_limit") String softCpuLimit,
  27.     @Bind("hard_cpu_limit") String hardCpuLimit,
  28.     @Bind("parent") Long parent,
  29.     @Bind("environment") String environment);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("DELETE FROM resource_groups WHERE resource_group_id = :resource_group_id")
  2. void deleteResourceGroup(@Bind("resource_group_id") long resourceGroupId);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("UPDATE resource_groups_global_properties SET name = :name")
  2. void updateResourceGroupsGlobalProperties(@Bind("name") String name);

代码示例来源：origin: prestodb/presto

  1. @SqlUpdate("DELETE FROM selectors WHERE resource_group_id = :resource_group_id")
  2. void deleteSelectors(@Bind("resource_group_id") long resourceGroup);

代码示例来源：origin: jdbi/jdbi

  1. @SqlBatch("insert into something (id, name) values (:id, :first || ' ' || :last)")
  2. @BatchChunkSize(2)
  3. void insertFamily(@Bind("id") List<Integer> ids,
  4.          @Bind("first") Iterator<String> firstNames,
  5.          @Bind("last") String lastName);

代码示例来源：origin: jdbi/jdbi

  1. @Override
  2.   @UseRowMapper(SomethingMapper.class)
  3.   @SqlQuery("select id, name from something where id = :id")
  4.   Something insertAndReturn(@Bind int id, @Bind String name);
  5. }

代码示例来源：origin: jdbi/jdbi

  1. @GetGeneratedKeys
  2.   @SqlUpdate("insert into bind_local_date_test(date_column) values (:date)")
  3.   long insert(@Bind("date") LocalDate date);
  4. }

代码示例来源：origin: jdbi/jdbi

  1. @SqlUpdate
  2. void weirdInsert(@Define("table") String table,
  3.          @Define("id_column") String idColumn,
  4.          @Define("value_column") String valueColumn,
  5.          @Bind("id") int id,
  6.          @Bind("value") String name);

代码示例来源：origin: jdbi/jdbi

  1. @SqlUpdate
  2. void weirdInsert(@Define("table") String table,
  3.          @Define("id_column") String idColumn,
  4.          @Define("value_column") String valueColumn,
  5.          @Bind("id") int id,
  6.          @Bind("value") String name);

代码示例来源：origin: jdbi/jdbi

  1. @SqlQuery("select caps from campaigns where id=:id")
  2. @SingleValue
  3. @HStore
  4. Map<String, String> getCampaignsCaps(@Bind("id") long campaignsId);

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

Bind

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Bind类方法

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