org.skife.jdbi.v2.sqlobject.BindBean Java Examples

@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
);
 

@GetGeneratedKeys
@SqlUpdate("update jdbc_sources set username = :j.username,"
    + " password = :j.password where id = :j.id")
protected abstract int updateJdbc(@BindBean("j") JdbcSource source);
 

@SqlQuery("SELECT * FROM saved_queries WHERE user = :userName")
@Override
public abstract List<SavedQuery> getSavedQueries(@BindBean AirpalUser airpalUser);
 

@SqlBatch(
        "INSERT INTO job_tables (job_id, table_id) " +
                "VALUES (:jobId, :tableId)")
public void createJobTables(@BindBean Iterable<JobTableRow> jobTableRows);
 

@SqlQuery("select * from dependency where name = :dependency.id and service = :service.id order by timestamp desc")
ImmutableList<DependencyModel> all(@BindBean("dependency") DependencyId dependencyId, @BindBean("service") ServiceId serviceId);
 

@SqlQuery("select * from dependency where name = :dependency.id and service = :service.id order by timestamp desc limit 1")
DependencyModel findLatest(@BindBean("dependency") DependencyId dependencyId, @BindBean("service") ServiceId serviceId);
 

@SqlUpdate("delete from dependency where name = :dependency.id and timestamp = :timestamp.millis")
int delete(@BindBean("dependency") DependencyId dependencyId, @BindBean("timestamp") DateTime timestamp);
 

@SqlUpdate("insert into dependency (name, timestamp, tenacity_configuration, username, service) values " +
           "(:dependency.dependencyId, :dependency.dateTime, :dependency.tenacityConfiguration," +
           " :dependency.user, :dependency.serviceId)")
int insert(@BindBean("dependency") DependencyModel dependencyModel);
 

@SqlQuery("select * from dependency where name = :dependency.id and timestamp = :timestamp.millis")
DependencyModel find(@BindBean("dependency") DependencyId dependencyId, @BindBean("timestamp") DateTime timestamp);
 

@SqlQuery("select * from service where name = :serviceId.id")
ImmutableList<ServiceModel> all(@BindBean("serviceId") ServiceId serviceId);
 

@SqlUpdate("delete from service where name = :service.serviceId and dependency = :service.dependencyId")
int delete(@BindBean("service") ServiceModel serviceModel);
 

@SqlUpdate("insert into service (name, dependency) values (:service.serviceId, :service.dependencyId)")
int insert(@BindBean("service") ServiceModel service);
 

@SqlQuery("select * from service where name = :service.serviceId and dependency = :service.dependencyId")
ServiceModel find(@BindBean("service") ServiceModel service);
 

@SqlUpdate("update partitions set name = :v.name, description = :v.description, "
    + "query = :v.query, cost = :v.cost, schema_name = :v.schema, "
    + "table_name = :v.table, destination_id = :v.destinationId where id = :v.id and ds_set_id = :ds_set_id")
int update(@BindBean("v") View view, @Bind("ds_set_id") long dsSetId);
 

@GetGeneratedKeys
@SqlUpdate("update data_sources set name = :d.name,"
    + " type = :d.type, datasource_type = :d.datasourceType,"
    + " url = :d.url, ds_set_id = :d.dsSetId where id = :d.id")
public abstract int update(@BindBean("d") DataSource ds);
 

@GetGeneratedKeys
@SqlUpdate("update quboledb_sources set dbtap_id = :d.dbTapId,"
    + " auth_token = :d.authToken where id = :d.id")
protected abstract int updateQubole(@BindBean("d") QuboleDbSource db);
 

@SqlUpdate("INSERT INTO SNM_MONITOR (MONITOR_ID, VERSION, ACCOUNT_ID, NAME, COUNTRY, PROVINCE, CITY, ISP, AREA, IP, NIPING_T, STATUS, CREATION_TIME, MODIFIED_TIME) " +
        " VALUES (:monitorId, :version, :accountId, :name, :country, :province, :city, :isp, :area, :ip, :nipingT, :status, :creationTime, :modifiedTime)")
void insertMonitor(@BindBean Monitor monitor);
 

@SqlUpdate(SQL_INSERT_EVENT_SUBSCRIPTION)
@GetGeneratedKeys
long insertDiagEventSubscription(
        @BindBean DiagEventSubscription subscription);
 

@SqlUpdate(SQL_SAVE_SNAPSHOT)
int saveSnapshot(@BindBean Snapshot snapshot);
 

@SqlUpdate(SQL_UPDATE_REPAIR_SCHEDULE)
int updateRepairSchedule(
    @BindBean RepairSchedule newRepairSchedule);
 

@SqlUpdate(SQL_INSERT_REPAIR_SCHEDULE)
@GetGeneratedKeys
long insertRepairSchedule(
    @BindBean RepairSchedule newRepairSchedule);
 

@SqlUpdate(SQL_UPDATE_REPAIR_SEGMENT)
int updateRepairSegment(
    @BindBean RepairSegment newRepairSegment);
 

@SqlBatch(SQL_INSERT_REPAIR_SEGMENT)
@BatchChunkSize(500)
void insertRepairSegments(@BindBean Iterator<PostgresRepairSegment> iterator);
 

@SqlUpdate(SQL_INSERT_REPAIR_UNIT)
@GetGeneratedKeys
long insertRepairUnit(
    @BindBean RepairUnit newRepairUnit);
 

@SqlUpdate(SQL_UPDATE_REPAIR_RUN)
int updateRepairRun(
    @BindBean RepairRun newRepairRun);
 

@SqlUpdate(SQL_INSERT_REPAIR_RUN)
@GetGeneratedKeys
long insertRepairRun(
    @BindBean RepairRun newRepairRun);
 

@SqlUpdate(SQL_UPDATE_CLUSTER)
int updateCluster(
    @BindBean Cluster newCluster);
 

@RegisterMapper(UserMapper.class)
@SqlUpdate("insert into rufususer (EMAIL, PASSWORD) values (:email, :password)")
void addUser(@BindBean User user);
 

@SqlUpdate("INSERT INTO SNM_NIPING_RESULT (ACCOUNT_ID, MONITOR_ID, TASK_ID, COLLECTED_TIME, TYPE, START_TIME, END_TIME, ERRNO, AVG, " +
        "MAX, MIN, TR, AV2, TR2, ERRMSG, CREATION_TIME, MODIFIED_TIME) " +
        " VALUES (:accountId, :monitorId, :taskId, :collectedTime, :type, :startTime, :endTime, :errno, :avg, :max, :min, :tr, :av2, " +
        ":tr2, :errmsg, :creationTime, :modifiedTime)")
void saveMonitorNiPingResult(@BindBean MonitorNiPingResult monitorNiPingResult);
 

@SqlUpdate("UPDATE SNM_TASK SET NAME = :name, TASK_INTERVAL = :interval, CONFIG_JSON = :configJson, MODIFIED_TIME = :modifiedTime WHERE TASK_ID = :taskId AND ACCOUNT_ID = :accountId")
void updateTask(@BindBean Task task) ;