本文整理汇总了Java中org.skife.jdbi.v2.sqlobject.GetGeneratedKeys类的典型用法代码示例。如果您正苦于以下问题:Java GetGeneratedKeys类的具体用法?Java GetGeneratedKeys怎么用?Java GetGeneratedKeys使用的例子?那么, 这里精选的类代码示例或许可以为您提供帮助。
GetGeneratedKeys类属于org.skife.jdbi.v2.sqlobject包,在下文中一共展示了GetGeneratedKeys类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: resuming_tasks
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("insert into resuming_tasks (attempt_id, source_task_id, full_name, updated_at, local_config, export_config, subtask_config, export_params, store_params, report, error, reset_store_params)" +
" values (:attemptId, :sourceTaskId, :fullName, :updatedAt, :localConfig, :exportConfig, :subtaskConfig, :exportParams, :storeParams, :report, :error, :reset_store_params)")
@GetGeneratedKeys
long insertResumingTask(
@Bind("attemptId") long attemptId,
@Bind("sourceTaskId") long sourceTaskId,
@Bind("fullName") String fullName,
@Bind("updatedAt") java.sql.Timestamp updatedAt,
@Bind("localConfig") Config localConfig,
@Bind("exportConfig") Config exportConfig,
@Bind("subtaskConfig") Config subtaskConfig,
@Bind("exportParams") Config exportParams,
@Bind("reset_store_params") String resetStoreParams,
@Bind("storeParams") Config storeParams,
@Bind("report") Config report,
@Bind("error") Config error);
示例2: jobs
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate(
"INSERT INTO jobs (query, user, uuid, queryStats, state, columns, query_finished, query_started, error) " +
"VALUES (" +
":query, " +
":user, " +
":uuid, " +
":queryStats, " +
":state, " +
":columns, " +
":queryFinished, " +
":queryStarted, " +
":error)")
@GetGeneratedKeys
long createJob(
@RosettaBinder Job job
);
示例3: saveRepresented
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@GetGeneratedKeys
@SqlUpdate("INSERT INTO claim ( "
+ "submitter_id, "
+ "claim, "
+ "issued_on, "
+ "response_deadline, "
+ "external_id, "
+ "submitter_email, "
+ "reference_number"
+ ") "
+ "VALUES ("
+ ":submitterId, "
+ ":claim::JSONB, "
+ ":issuedOn, "
+ ":responseDeadline, "
+ ":externalId, "
+ ":submitterEmail, "
+ "next_legal_rep_reference_number()"
+ ")")
Long saveRepresented(
@Bind("claim") String claim,
@Bind("submitterId") String submitterId,
@Bind("issuedOn") LocalDate issuedOn,
@Bind("responseDeadline") LocalDate responseDeadline,
@Bind("externalId") String externalId,
@Bind("submitterEmail") String submitterEmail
);
示例4: saveSubmittedByClaimant
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@GetGeneratedKeys
@SqlUpdate("INSERT INTO claim ( "
+ "submitter_id, "
+ "claim, "
+ "letter_holder_id, "
+ "issued_on, "
+ "response_deadline, "
+ "external_id, "
+ "submitter_email, "
+ "reference_number"
+ ") "
+ "VALUES ("
+ ":submitterId, "
+ ":claim::JSONB, "
+ ":letterHolderId, "
+ ":issuedOn, "
+ ":responseDeadline, "
+ ":externalId, "
+ ":submitterEmail, "
+ "next_reference_number()"
+ ")")
Long saveSubmittedByClaimant(
@Bind("claim") String claim,
@Bind("submitterId") String submitterId,
@Bind("letterHolderId") String letterHolderId,
@Bind("issuedOn") LocalDate issuedOn,
@Bind("responseDeadline") LocalDate responseDeadline,
@Bind("externalId") String externalId,
@Bind("submitterEmail") String submitterEmail
);
示例5: shards
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO shards (shard_uuid, table_id, create_time, row_count, compressed_size, uncompressed_size)\n" +
"VALUES (:shardUuid, :tableId, CURRENT_TIMESTAMP, :rowCount, :compressedSize, :uncompressedSize)")
@GetGeneratedKeys
long insertShard(
@Bind("shardUuid") UUID shardUuid,
@Bind("tableId") long tableId,
@Bind("rowCount") long rowCount,
@Bind("compressedSize") long compressedSize,
@Bind("uncompressedSize") long uncompressedSize);
示例6: tables
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO tables (schema_name, table_name, compaction_enabled)\n" +
"VALUES (:schemaName, :tableName, :compactionEnabled)")
@GetGeneratedKeys
long insertTable(
@Bind("schemaName") String schemaName,
@Bind("tableName") String tableName,
@Bind("compactionEnabled") boolean compactionEnabled);
示例7: insert
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@GetGeneratedKeys
@SqlUpdate("insert into partitions(name, description, query, cost, destination_id, "
+ "schema_name, table_name, ds_set_id) values(:name, :description, :query, :cost, "
+ ":destination_id, :schema_name, :table_name, :ds_set_id)")
int insert(@Bind("name") String name, @Bind("description") String description,
@Bind("query") String query, @Bind("cost") long cost,
@Bind("destination_id") long destinationId, @Bind("schema_name") String schemaName,
@Bind("table_name") String tableName, @Bind("ds_set_id") long dsSetId);
示例8: insert
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO TimeScheduleParameters "
+ "(startDate, accountingPeriod , reportingPeriod, tol1, tol2, "
+ "samplingPeriod, reportPeriodEA, reportPeriodDTM, compensationPeriod) "
+ "VALUES (:startDate, :accountingPeriod, :reportingPeriod, :tol1, :tol2, "
+ ":samplingPeriod, :reportPeriodEA, :reportPeriodDTM, :compensationPeriod)")
@GetGeneratedKeys
public abstract long insert(@BindBean TimeScheduleParameters tsp);
示例9: insert
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO " + TABLE_NAME
+ " (creationDate, lastModificationDate, inputId, outputId, totalBindings) "
+ "VALUES (CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, :inputId, :outputId, :totalBindings)")
@GetGeneratedKeys
int insert(
@Bind("inputId") int inputId,
@Bind("outputId") int outputId,
@Bind("totalBindings") int totalBindings);
示例10: user
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("insert into user (identity, typeMap, email, name, status,"
+ "googleEmail, googleLink, googleAuthId, googlePicture, "
+ "facebookEmail, facebookLink, facebookAuthId, facebookGender, "
+ "lastLoginTypeMap, lastLoginTimeStamp, lastModifiedTimeStamp) "
+ "values "
+ "(:identity, :typeMap, :email, :name, 1, "
+ ":googleEmail, :googleLink, :googleAuthId, :googlePicture, "
+ ":facebookEmail, :facebookLink, :facebookAuthId, :facebookGender, "
+ ":lastLoginTypeMap, :lastLoginTimeStamp, :lastModifiedTimeStamp )")
@GetGeneratedKeys
long insert(
@Bind("identity") String identity,
@Bind("typeMap") Integer typeMap,
@Bind("email") String email,
@Bind("name") String name,
@Bind("googleEmail") String googleEmail,
@Bind("googleLink") String googleLink,
@Bind("googleAuthId") String googleAuthId,
@Bind("googlePicture") String googlePicture,
@Bind("facebookEmail") String facebookEmail,
@Bind("facebookLink") String facebookLink,
@Bind("facebookAuthId") String facebookAuthId,
@Bind("facebookGender") String facebookGender,
@Bind("lastLoginTypeMap") Integer lastLoginTypeMap,
@Bind("lastLoginTimeStamp") Timestamp lastLoginTimeStamp,
@Bind("lastModifiedTimeStamp") Timestamp lastModifiedTimeStamp
);
示例11: job_outputs
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate(
"INSERT INTO job_outputs (type, description, location, job_id) " +
"VALUES (:type, :description, :location, :jobId)")
@GetGeneratedKeys
long createJobOutput(
@BindBean PersistentJobOutput output,
@Bind("jobId") long jobId
);
示例12: VALUES
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO todo.todoItem(title, completed) VALUES (:title, CASE WHEN :completed IS NULL THEN FALSE ELSE :completed END )")
@GetGeneratedKeys
long insert(@BindBean TodoItem newTodoItem);
示例13: example
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO example (name) values (:name)")
@GetGeneratedKeys
abstract long create(@BindBean Example example);
示例14: users
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@Override
@SqlUpdate("insert into users (name, version) values (:name, :version)")
@GetGeneratedKeys
public abstract long insert(@UserBind User entry);
示例15: states
import org.skife.jdbi.v2.sqlobject.GetGeneratedKeys; //导入依赖的package包/类
@SqlUpdate("INSERT INTO states (ID) VALUES (DEFAULT)")
@GetGeneratedKeys
int insertId();