CustomFieldSqlDao.sql.stg

Home / util / src / main / resources / com / ning / billing / util / customfield / dao / CustomFieldSqlDao.sql.stg

19 lines | 496 B Blame History Raw Download

group CustomFieldSqlDao : EntitySqlDao;


updateFromTransaction() ::= <<
    UPDATE custom_fields
    SET field_value = :fieldValue, updated_by = :userName, updated_date = :updatedDate
    WHERE object_id = :objectId AND object_type = :objectType AND field_name = :fieldName
    <AND_CHECK_TENANT()>
    ;
>>

deleteFromTransaction() ::= <<
    DELETE FROM custom_fields
    WHERE object_id = :objectId AND object_type = :objectType AND field_name = :fieldName
    <AND_CHECK_TENANT()>
    ;
>>