Refine search
@SqlQuery public CatalogOverrideBlockDefinitionModelDao getByAttributes(@Bind("parentUnitName") final String parentUnitName, @Bind("currency") final String currency, @Bind("price") final BigDecimal price, @Bind("max") final double max, @Bind("size") final double size, @SmartBindBean final InternalTenantContext context);
@Mapper(MessageMapper.class) @SqlQuery("DELETE FROM messages WHERE " + ID + " IN (SELECT " + ID + " FROM messages WHERE " + DESTINATION + " = :destination AND " + DESTINATION_DEVICE + " = :destination_device AND " + SOURCE + " = :source AND " + TIMESTAMP + " = :timestamp ORDER BY " + ID + " LIMIT 1) RETURNING *") abstract OutgoingMessageEntity remove(@Bind("destination") String destination, @Bind("destination_device") long destinationDevice, @Bind("source") String source, @Bind("timestamp") long timestamp);
@SqlUpdate @Audited(ChangeType.UPDATE) public void updateBundleLastSysTime(@Bind("id") String id, @Bind("lastSysUpdateDate") Date lastSysUpdate, @SmartBindBean final InternalCallContext context);
@SqlQuery public List<CatalogOverridePhaseDefinitionModelDao> getByAttributes(@Bind("parentPhaseName") String parentPhaseName, @Bind("currency") String currency, @Bind("fixedPrice") BigDecimal fixedPrice, @Bind("recurringPrice") BigDecimal recurringPrice, @SmartBindBean final InternalTenantContext context);
@SqlUpdate @Audited(ChangeType.UPDATE) public Object updatePaymentMethod(@Bind("id") String accountId, @Bind("paymentMethodId") String paymentMethodId, @SmartBindBean final InternalCallContext context);
@SqlUpdate @Audited(ChangeType.UPDATE) public Object updateTenantValueKey(@Bind("id") final String id, @Bind("tenantValue") final String tenantValue, @SmartBindBean final InternalCallContext context); }
@SqlQuery List<RolledUpUsageModelDao> getAllUsageForSubscription(@Bind("subscriptionId") final UUID subscriptionId, @Bind("startDate") final Date startDate, @Bind("endDate") final Date endDate, @SmartBindBean final InternalTenantContext context);
@SqlUpdate("WITH upsert AS (UPDATE pending_accounts SET verification_code = :verification_code, timestamp = :timestamp WHERE number = :number RETURNING *) " + "INSERT INTO pending_accounts (number, verification_code, timestamp) SELECT :number, :verification_code, :timestamp WHERE NOT EXISTS (SELECT * FROM upsert)") void insert(@Bind("number") String number, @Bind("verification_code") String verificationCode, @Bind("timestamp") long timestamp);
@SqlUpdate @Audited(ChangeType.UPDATE) void updateValue(@Bind("id") String customFieldId, @Bind("fieldValue") String fieldValue, @SmartBindBean InternalCallContext context);
@SqlQuery List<TagModelDao> getTagsForObjectIncludedDeleted(@Bind("objectId") UUID objectId, @Bind("objectType") ObjectType objectType, @SmartBindBean InternalTenantContext internalTenantContext); }
@SqlUpdate("WITH upsert AS (UPDATE pending_devices SET verification_code = :verification_code, timestamp = :timestamp WHERE number = :number RETURNING *) " + "INSERT INTO pending_devices (number, verification_code, timestamp) SELECT :number, :verification_code, :timestamp WHERE NOT EXISTS (SELECT * FROM upsert)") void insert(@Bind("number") String number, @Bind("verification_code") String verificationCode, @Bind("timestamp") long timestamp);
@SqlUpdate @Audited(ChangeType.UPDATE) public void updateBundleExternalKey(@Bind("id") String id, @Bind("externalKey") String externalKey, @SmartBindBean final InternalCallContext context);