BusinessOverdueStatusSqlDao.sql.stg

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

38 lines | 489 B Blame History Raw Download

group BusinessOverdueStatus;

getOverdueStatusesForBundle(external_key) ::= <<
select
  bundle_id
, external_key
, account_key
, status
, start_date
, end_date
from bos
where external_key = :external_key
order by start_date asc
;
>>

createOverdueStatus() ::= <<
insert into bos (
  bundle_id
, external_key
, account_key
, status
, start_date
, end_date
) values (
  :bundle_id
, :external_key
, :account_key
, :status
, :start_date
, :end_date
);
>>

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