@EntitySqlDaoStringTemplate public interface TenantSqlDao extends EntitySqlDao<TenantModelDao, Tenant> { @SqlQuery public TenantModelDao getByApiKey(@Bind("apiKey") final String apiKey); @SqlQuery public TenantModelDao getSecrets(@Bind("id") final String id); }
@EntitySqlDaoStringTemplate public interface TenantKVSqlDao extends EntitySqlDao<TenantKVModelDao, TenantKV> { @SqlQuery public List<TenantKVModelDao> getTenantValueForKey(@Bind("tenantKey") final String key, @BindBean final InternalTenantContext context); @SqlUpdate @Audited(ChangeType.DELETE) public void markTenantKeyAsDeleted(@Bind("id")final String id, @BindBean final InternalCallContext context); }
@EntitySqlDaoStringTemplate public interface InvoiceItemSqlDao extends EntitySqlDao<InvoiceItemModelDao, InvoiceItem> { @SqlQuery List<InvoiceItemModelDao> getInvoiceItemsByInvoice(@Bind("invoiceId") final String invoiceId, @BindBean final InternalTenantContext context); @SqlQuery List<InvoiceItemModelDao> getInvoiceItemsBySubscription(@Bind("subscriptionId") final String subscriptionId, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface PaymentAttemptSqlDao extends EntitySqlDao<PaymentAttemptModelDao, PaymentAttempt> { @SqlUpdate @Audited(ChangeType.UPDATE) void updatePaymentAttemptStatus(@Bind("id") final String attemptId, @Bind("processingStatus") final String processingStatus, @Bind("gatewayErrorCode") final String gatewayErrorCode, @Bind("gatewayErrorMsg") final String gatewayErrorMsg, @BindBean final InternalCallContext context); @SqlQuery List<PaymentAttemptModelDao> getByPaymentId(@Bind("paymentId") final String paymentId, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface TagDefinitionSqlDao extends EntitySqlDao<TagDefinitionModelDao, TagDefinition> { @SqlQuery public TagDefinitionModelDao getByName(@Bind("name") final String definitionName, @BindBean final InternalTenantContext context); @SqlUpdate @Audited(ChangeType.DELETE) public void markTagDefinitionAsDeleted(@Bind("id") final String definitionId, @BindBean final InternalCallContext context); @SqlQuery public int tagDefinitionUsageCount(@Bind("id") final String definitionId, @BindBean final InternalTenantContext context); @SqlQuery public List<TagDefinitionModelDao> getByIds(@UUIDCollectionBinder final Collection<String> definitionIds, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface InvoiceSqlDao extends EntitySqlDao<InvoiceModelDao, Invoice> { @SqlQuery List<InvoiceModelDao> getInvoicesBySubscription(@Bind("subscriptionId") final String subscriptionId, @BindBean final InternalTenantContext context); @SqlQuery // Magic value to force MySQL to stream from the database // See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation-notes.html (ResultSet) @FetchSize(Integer.MIN_VALUE) public Iterator<InvoiceModelDao> searchInvoices(@Bind("searchKey") final String searchKey, @Bind("offset") final Long offset, @Bind("rowCount") final Long rowCount, @BindBean final InternalTenantContext context); @SqlQuery UUID getInvoiceIdByPaymentId(@Bind("paymentId") final String paymentId, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface CustomFieldSqlDao extends EntitySqlDao<CustomFieldModelDao, CustomField> { @SqlUpdate @Audited(ChangeType.DELETE) void markTagAsDeleted(@Bind("id") String customFieldId, @BindBean InternalCallContext context); @SqlQuery List<CustomFieldModelDao> getCustomFieldsForObject(@Bind("objectId") UUID objectId, @Bind("objectType") ObjectType objectType, @BindBean InternalTenantContext internalTenantContext); @SqlQuery // Magic value to force MySQL to stream from the database // See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation-notes.html (ResultSet) @FetchSize(Integer.MIN_VALUE) public Iterator<CustomFieldModelDao> searchCustomFields(@Bind("searchKey") final String searchKey, @Bind("likeSearchKey") final String likeSearchKey, @Bind("offset") final Long offset, @Bind("rowCount") final Long rowCount, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface TagSqlDao extends EntitySqlDao<TagModelDao, Tag> { @SqlUpdate @Audited(ChangeType.DELETE) void markTagAsDeleted(@Bind("id") String tagId, @BindBean InternalCallContext context); @SqlQuery List<TagModelDao> getTagsForObject(@Bind("objectId") UUID objectId, @Bind("objectType") ObjectType objectType, @BindBean InternalTenantContext internalTenantContext); @SqlQuery List<TagModelDao> getTagsForObjectIncludedDeleted(@Bind("objectId") UUID objectId, @Bind("objectType") ObjectType objectType, @BindBean InternalTenantContext internalTenantContext); @SqlQuery // Magic value to force MySQL to stream from the database // See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation-notes.html (ResultSet) @FetchSize(Integer.MIN_VALUE) public Iterator<TagModelDao> searchTags(@Bind("searchKey") final String searchKey, @Bind("likeSearchKey") final String likeSearchKey, @Bind("offset") final Long offset, @Bind("rowCount") final Long rowCount, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface RefundSqlDao extends EntitySqlDao<RefundModelDao, Refund> { @SqlUpdate @Audited(ChangeType.UPDATE) void updateStatus(@Bind("id") final String refundId, @Bind("refundStatus") final String status, @Bind("processedAmount") final BigDecimal processedAmount, @Bind("processedCurrency") final Currency processedCurrency, @BindBean final InternalCallContext context); @SqlQuery List<RefundModelDao> getRefundsForPayment(@Bind("paymentId") final String paymentId, @BindBean final InternalTenantContext context); @SqlQuery List<RefundModelDao> getRefundsForAccount(@Bind("accountId") final String accountId, @BindBean final InternalTenantContext context); @SqlQuery // Magic value to force MySQL to stream from the database // See http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-implementation-notes.html (ResultSet) @FetchSize(Integer.MIN_VALUE) public Iterator<RefundModelDao> getByPluginName(@Bind("pluginName") final String pluginName, @Bind("offset") final Long offset, @Bind("rowCount") final Long rowCount, @BindBean final InternalTenantContext context); }
@EntitySqlDaoStringTemplate public interface PaymentMethodSqlDao extends EntitySqlDao<PaymentMethodModelDao, PaymentMethod> {
@EntitySqlDaoStringTemplate public interface InvoicePaymentSqlDao extends EntitySqlDao<InvoicePaymentModelDao, InvoicePayment> {
@EntitySqlDaoStringTemplate public interface EntitySqlDao<M extends EntityModelDao<E>, E extends Entity> extends AuditSqlDao, HistorySqlDao<M, E>, Transmogrifier, Transactional<EntitySqlDao<M, E>>, CloseMe {
@EntitySqlDaoStringTemplate public interface PaymentSqlDao extends EntitySqlDao<PaymentModelDao, Payment> {
@EntitySqlDaoStringTemplate("/com/ning/billing/util/entity/dao/EntitySqlDao.sql.stg")
@EntitySqlDaoStringTemplate("/com/ning/billing/util/dao/Kombucha.sql.stg") private static interface KombuchaSqlDao extends EntitySqlDao<KombuchaModelDao, Kombucha> { @SqlQuery public boolean isIsTimeForKombucha(); }
@EntitySqlDaoStringTemplate @RegisterMapper(BlockingStateSqlDao.BlockingHistorySqlMapper.class) public interface BlockingStateSqlDao extends EntitySqlDao<BlockingStateModelDao, BlockingState> {