/** * Delete bucket for experiment id and label * * @param experimentId * @param label */ @Query("delete from bucket where experiment_id = ? and label = ?") void deleteByExperimentIdAndLabel(UUID experimentId, String label);
/** * Delete by using attributes * * @param appName * @param page * @param uuid * @return Statement */ @Query("delete from page_experiment_index where app_name = ? and page = ? and exp_id = ?") Statement deleteBy(String appName, String page, UUID uuid);
/** * Get by attributes * * @param page * @param appName * @return result */ @Query("select * from app_page_index where page = ? and app_name = ?") Result<AppPage> selectBy(String page, String appName);
/** * Delete entry from experiment label index * * @param appName * @param label * @return result set */ @Query("delete from experiment_label_index where app_name = ? and label = ?") ResultSet deleteBy(String appName, String label); }
/** * Retrieves a limited list of AuditLogEntries for all application and global events. * * @param limit the items retrieved limit * @return a list of auditlog AuditLogEntries */ @Query("SELECT * FROM auditlog limit ?") Result<AuditLog> getCompleteAuditLogEntryList(int limit);
/** * Retrieves a limited list of AuditLogEntries for a specified application. * * @param applicationName the application to select * @param limit the item retireved limit * @return a list of those AuditLogEntries */ @Query("SELECT * FROM auditlog WHERE application_name = ? limit ?") Result<AuditLog> getAuditLogEntryList(String applicationName, int limit);
/** * Get by attributes * * @param appName * @param page * @return result */ @Query("select * from page_experiment_index where app_name = ? and page = ?") Result<PageExperimentByAppNamePage> selectBy(String appName, String page);
/** * Delete the prioritized list for an application * * @param applicationName the app name */ @Query("delete from application where app_name = ?") void deletePriorities(String applicationName); }
/** * Get by attributes * * @param experimentId * @param dayHour * @param context * @param isBucketNull * @return result */ @Query("select * from user_assignment_export where experiment_id = ? and day_hour = ? and context = ? and is_bucket_null = ?") Result<UserAssignmentExport> selectBy(UUID experimentId, Date dayHour, String context, boolean isBucketNull); }
/** * Delete application by name * * @param appName */ @Query("delete from applicationList where app_name = ?") void deleteBy(String appName);
/** * Get experiment by app name and label * * @param appName * @param Label * @return experiment label result */ @Query("select * from experiment_label_index where app_name = ? and label = ?") Result<ExperimentByAppNameLabel> getExperimentBy(String appName, String Label);
/** * Insert a row into the table * * @param index_key * @param experiment_id * @param byteBuffer */ @Query("insert into state_experiment_index(index_key, experiment_id, value) " + "values(?,?,?)") Statement insert(String index_key, UUID experiment_id, ByteBuffer byteBuffer);
/** * Delete from table * * @param index_key * @param experiment_id */ @Query("delete from state_experiment_index where index_key = ? and experiment_id = ?") Statement deleteBy(String index_key, UUID experiment_id);
/** * Create exclusion pair * * @param base the base experiment id * @param pair the exclusion experiment id * @return Statement object */ @Query("insert into exclusion(base, pair) values(?, ?)") Statement createExclusion(UUID base, UUID pair); }
/** * Get all feedbacks * * @return list of feedbacks */ @Query("select * from user_feedback") Result<UserFeedback> getAllUserFeedback(); }
/** * Get bucket for one experiment * * @param experimentId * @return buckets */ @Query("select * from bucket where experiment_id = ?") Result<Bucket> getBucketByExperimentId(UUID experimentId);
/** * Get rows by arguments * * @param experimentId * @param label * @return result */ @Query("select * from bucket_audit_log where experiment_id = ? and label = ? ") Result<BucketAuditLog> selectBy(UUID experimentId, String label);
/** * Delete row from table by argument * * @param experimentId * @param label * @return result */ @Query("delete from bucket_audit_log where experiment_id = ? and label = ? ") ResultSet deleteBy(UUID experimentId, String label); }
/** * Asynchronously fetch experiments associated to given application and page. * * @param appName * @param page * @return result */ @Query("select * from page_experiment_index where app_name = ? and page = ?") ListenableFuture<Result<PageExperimentByAppNamePage>> asyncSelectBy(String appName, String page);
/** * Get the priority list for an application * * @param applicationName name of application * @return application instance */ @Query("select * from application where app_name = ?") Result<Application> getPriorities(String applicationName);