nsmcp::AccessRecordStoreSQLite method rollBatch (protected)

 <instance of nsmcp::AccessRecordStoreSQLite> rollBatch

Defined in /usr/local/ns/tcl/nsmcp/log-traffic-record-store.tcl

Testcases:

No testcase defined.

Source code:

${:db} execute {INSERT INTO nsmcp_records.minutes SELECT fid,CAST(t/60 AS INTEGER)*60,status,pool,method,source,count(*),sum(bytes) FROM temp.nsmcp_ingest_batch WHERE kind=0 GROUP BY fid,CAST(t/60 AS INTEGER),status,pool,method,source
    ON CONFLICT(fid,slot,status,pool,method,source) DO UPDATE SET n=n+excluded.n,bytes=bytes+excluded.bytes}

XQL Not present:

Generic, PostgreSQL, Oracle