org.jdbi.v3.sqlobject.customizer.BindBean Java Examples

@SqlUpdate("update endpoint set environment_id = :evId, name = :ep.name, type = :ep.type, " +
        "description = :ep.description, url = :ep.url, username = :ep.username, password = CASE " +
            "WHEN COALESCE(password, '') <> COALESCE(:ep.password, '') " + // encrypt only when password is changed
                "THEN ENCRYPT('AES', '" + ENDPOINT_PASSWORD_ENCRYPTION_KEY + "', STRINGTOUTF8(:ep.password)) " +
            "ELSE password END, " +
        "other_properties = :ep.otherProperties, updated = CURRENT_TIMESTAMP where id = :ep.id")
void _update(@BindBean("ep") Endpoint endpoint, @Bind("evId") Long environmentId);
 

@SqlUpdate("update property_extractor set property_name = :propertyName, other_properties = :otherProperties, " +
        "updated = CURRENT_TIMESTAMP where id = :id")
void update(@BindBean PropertyExtractor propertyExtractor);
 

/**
 * This method considers test step insertion from both Create (test step) button on UI and test case duplicating.
 * @param teststep
 * @param request
 * @param endpointId
 * @return
 */
@SqlUpdate("insert into teststep (testcase_id, sequence, type, request, api_request, endpoint_id, " +
        "other_properties) values (:t.testcaseId, " +
          "(select coalesce(max(sequence), 0) + 1 from teststep where testcase_id = :t.testcaseId), " +
        ":t.type, :request, :apiRequest, :endpointId, :t.otherProperties)")
@GetGeneratedKeys
long _insertWithoutName(@BindBean("t") Teststep teststep, @Bind("request") Object request,
                        @Bind("endpointId") Long endpointId, @Bind("apiRequest") String apiRequest);
 

@SqlUpdate("insert into teststep (testcase_id, sequence, name, type, description, action, request, request_type, " +
        "request_filename, api_request, endpoint_id, endpoint_property, other_properties) values (:t.testcaseId, " +
        "select coalesce(max(sequence), 0) + 1 from teststep where testcase_id = :t.testcaseId, :t.name, " +
        ":t.type, :t.description, :t.action, :request, :requestType, :t.requestFilename, :apiRequest, " +
        ":endpointId, :t.endpointProperty, :t.otherProperties)")
@GetGeneratedKeys
long _insertWithName(@BindBean("t") Teststep teststep, @Bind("request") byte[] request,
                     @Bind("requestType") String requestType, @Bind("apiRequest") String apiRequest,
                     @Bind("endpointId") Long endpointId);
 

@SqlUpdate("update teststep set name = :t.name, description = :t.description, action = :t.action, request = :request, " +
        "request_type = :requestType, request_filename = :t.requestFilename, api_request = :apiRequest, " +
        "endpoint_id = :endpointId, endpoint_property = :t.endpointProperty, other_properties = :t.otherProperties, " +
        "updated = CURRENT_TIMESTAMP where id = :t.id")
void _updateWithStringRequest(@BindBean("t") Teststep teststep, @Bind("request") Object request,
                              @Bind("requestType") String requestType,
                              @Bind("apiRequest") String apiRequest,
                              @Bind("endpointId") Long endpointId);
 

@SqlUpdate("update datatable_cell set value = :cell.value, endpoint_id = :endpointId, updated = CURRENT_TIMESTAMP " +
        "where id = :cell.id")
void update(@BindBean("cell") DataTableCell cell, @Bind("endpointId") Long endpointId);
 

@SqlBatch("insert")
@GetGeneratedKeys
List<Long> bulkInsert(@BindBean List<CarMaker> carMakers);
 

@SqlUpdate
@GetGeneratedKeys
Long insert(@BindBean CarMaker carMaker);
 

@SqlBatch("insert")
@GetGeneratedKeys
List<Long> bulkInsert(@BindBean List<CarModel> models);
 

@SqlUpdate("insert")
@GetGeneratedKeys
Long insert(@BindBean CarModel carModel);
 

@SqlBatch("update world set randomNumber = :p.randomNumber where id = :p.id")
@Transaction
void update(@BindBean("p") World...worlds);
 

@SqlUpdate("insert into property_extractor (teststep_id, property_name, type, other_properties) values " +
        "(:teststepId, :p.propertyName, :p.type, :p.otherProperties)")
@GetGeneratedKeys
long insert(@Bind("teststepId") long teststepId, @BindBean("p") PropertyExtractor propertyExtractor);
 

@SqlUpdate("update udp set name = :name, value = :value, updated = CURRENT_TIMESTAMP where id = :id")
void update(@BindBean UserDefinedProperty udp);
 

@SqlUpdate("update article set title = :title, content = :content, updated = CURRENT_TIMESTAMP where id = :id")
int update(@BindBean Article article);
 

@SqlUpdate("insert into article (title, content) values (:title, :content)")
@GetGeneratedKeys
long insert(@BindBean Article article);
 

@SqlUpdate("update testcase set name = :name, description = :description, " +
        "check_http_stubs_hit_order = :checkHTTPStubsHitOrder, updated = CURRENT_TIMESTAMP where id = :id")
void update(@BindBean Testcase testcase);
 

@SqlUpdate("insert into testcase (name, description, parent_folder_id, check_http_stubs_hit_order) values (" +
        ":name, :description, :parentFolderId, :checkHTTPStubsHitOrder)")
@GetGeneratedKeys
long _insertWithName(@BindBean Testcase testcase);
 

@SqlUpdate("insert into testcase (description, parent_folder_id) values (:description, :parentFolderId)")
@GetGeneratedKeys
long _insertWithoutName(@BindBean Testcase testcase);
 

@SqlUpdate("update teststep set name = :t.name, description = :t.description, request_type = :requestType, " +
        "request_filename = :t.requestFilename, action = :t.action, endpoint_id = :endpointId, " +
        "endpoint_property = :t.endpointProperty, other_properties = :t.otherProperties, updated = CURRENT_TIMESTAMP " +
        "where id = :t.id")
void _updateWithoutRequest(@BindBean("t") Teststep teststep, @Bind("requestType") String requestType,
                           @Bind("endpointId") Long endpointId);
 

@SqlUpdate("update assertion set name = :a.name, other_properties = :a.otherProperties, " +
        "updated = CURRENT_TIMESTAMP where id = :a.id")
void update(@BindBean("a") Assertion assertion);
 

@SqlUpdate("insert into assertion (teststep_id, name, type, other_properties) values " +
        "(:a.teststepId, :a.name, :a.type, :a.otherProperties)")
@GetGeneratedKeys
long insert(@BindBean("a") Assertion assertion);
 

@SqlUpdate("update environment set name = :name, description = :description, updated = CURRENT_TIMESTAMP where id = :id")
void update(@BindBean Environment environment);
 

@SqlUpdate("update folder set name = :name, description = :description, " +
        "updated = CURRENT_TIMESTAMP where id = :id")
void update(@BindBean Folder folder);
 

@SqlUpdate("insert into endpoint (environment_id, type, other_properties) values (:evId, :ep.type, :ep.otherProperties)")
@GetGeneratedKeys
long _insertManagedEndpoint(@BindBean("ep") Endpoint endpoint, @Bind("evId") long environmentId);
 

@SqlUpdate("insert into datatable_cell (column_id, row_sequence, value, endpoint_id) values (:columnId, " +
        ":cell.rowSequence, :cell.value, :endpointId)")
void _insert(@Bind("columnId") long columnId, @BindBean("cell") DataTableCell cell, @Bind("endpointId") Long endpointId);
 

@SqlUpdate("INSERT INTO book(id, title) VALUES (:id, :title)")
void insertBook(@BindBean Book book);
 

/**
 * @param testcaseId
 * @param column
 * @param type for enum, name instead of value is bound by JDBI, so use a separate @Bind here instead of taking advantage of the @BindBean.
 * @return
 */
@SqlUpdate("insert into datatable_column (name, type, sequence, testcase_id) values (:c.name, :type, " +
        ":c.sequence, :testcaseId)")
@GetGeneratedKeys
long insert(@Bind("testcaseId") long testcaseId, @BindBean("c") DataTableColumn column,
            @Bind("type") String type);
 

/**
 * Here assuming endpoint.password is already encrypted.
 * @param endpoint
 * @return
 */
@SqlUpdate("insert into endpoint (name, type, description, url, username, password, other_properties) " +
           "values (:ep.name, :ep.type, :ep.description, :ep.url, :ep.username, :ep.password, :ep.otherProperties)")
@GetGeneratedKeys
long insertUnmanagedEndpoint(@BindBean("ep") Endpoint endpoint);