Converts a case class to a Map
Converts a case class to a Map
This should probably go in CaseClassConfigParser but needs to cover all scenarios first
For SQlServer temporal tables, using com.coxautodata.waimak.storage.AuditTable.snapshot(ts) to snapshot will not work due to the extra complication of resolving the main and history tables to find delete events.
For SQlServer temporal tables, using com.coxautodata.waimak.storage.AuditTable.snapshot(ts) to snapshot will not work due to the extra complication of resolving the main and history tables to find delete events. To correctly snapshot a temporal table, for each pk we need to: 1. order by start col desc, end col asc 2. take the first record in this ordering IF the snapshot timestamp is between the start col and the end col, otherwise return no record for this pk (this record has been deleted)
The dataset to snapshot
the snapshot timestamp
the metadata for the temporal table
a snapshot of the dataset for the given snapshot timestamp
RuntimeException
if the table is not temporal
Created by Vicky Avison on 04/04/18.