• Home
• com.ning.billing
• killbill-usage
• 0.1.43
• source code
• TimelineAggregatorSqlDao.sql.stg

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.ning.billing.usage.timeline.aggregator.TimelineAggregatorSqlDao.sql.stg Maven / Gradle / Ivy

group TimelineAggregatorDAO;

CHECK_TENANT() ::= "tenant_record_id = :tenantRecordId"
AND_CHECK_TENANT() ::= "AND "

getStreamingAggregationCandidates() ::= <<
  select
    chunk_id
  , source_id
  , metric_id
  , start_time
  , end_time
  , in_row_samples
  , blob_samples
  , sample_count
  , aggregation_level
  , not_valid
  , dont_aggregate
  from timeline_chunks
  where source_id != 0 and aggregation_level = :aggregationLevel and not_valid = 0
  
  order by source_id, metric_id, start_time
 >>

 getAggregationCandidatesForSourceIdAndMetricIds(metricIds) ::= <<
  select
    chunk_id
  , source_id
  , metric_id
  , start_time
  , end_time
  , in_row_samples
  , blob_samples
  , sample_count
  , aggregation_level
  , not_valid
  , dont_aggregate
  from timeline_chunks
  where source_id = :source_id
  and metric_id in ()
  
  ;
>>

getLastInsertedId() ::= <<
  select last_insert_id();
>>

makeTimelineChunkValid() ::= <<
  update timeline_chunks
  set not_valid = 0
  where chunk_id = :chunkId
  
  ;
>>

makeTimelineChunksInvalid(chunkIds) ::=<<
  update timeline_chunks
  set not_valid = 1
  where chunk_id in ()
  
  ;
>>

deleteTimelineChunks(chunkIds) ::=<<
  delete from timeline_chunks where chunk_id in () ;
>>