BusinessAccountFieldSqlDao.sql.stg

Home / analytics / src / main / resources / com / ning / billing / analytics / dao / BusinessAccountFieldSqlDao.sql.stg

31 lines | 462 B Blame History Raw Download

group BusinessAccountField;

getFieldsForAccount(account_key) ::=<<
select
  account_key
, name
, value
from bac_fields
where account_key = :account_key
;
>>

addField(account_key, name, value) ::=<<
insert into bac_fields (
  account_key
, name
, value
) values (
  :account_key
, :name
, :value
);
>>

removeField(account_key, name) ::= <<
delete from bac_fields where account_key = :account_key and name = :name;
>>

test() ::= <<
select 1 from bac_fields;
>>