BusinessOverdueStatusSqlDao.sql.stg

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

31 lines | 408 B Blame History Raw Download

group BusinessOverdueStatus;

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

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

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