Need search for key, search sql, apply, delete, reverse, .... ? Reverse would work only if we had a previous statement to run or a previous state to recall. All updates should be full "replace" if possible to make this easier.
2021-08-11 09:42:03 | L1187406039 | LIST | f_list_open | |
2021-08-11 09:42:00 | L1187406039 | LIST | f_list_open | 27-Jun-22 |
2021-03-24 11:42:22 | V1813431028 | EDIT | f_ven_add1 | Oystermouth Road |
2021-01-13 12:54:00 | V1798543557 | EDIT | f_ven_type | ART |
2020-11-20 16:37:16 | L02071577128 | LIST | f_list_ven | V765 |
2020-11-20 16:36:54 | L02071577128 | LIST | f_list_ven | V687 |
2020-11-20 14:37:14 | L0964642303 | LIST | f_list_ven | V01754281771 |
2020-11-20 14:34:42 | L0964642303 | LIST | f_list_ven | V0165922284 |
2020-11-20 14:34:28 | L0964642303 | LIST | f_list_ven | V442 |
2020-11-20 14:34:20 | L0964642303 | LIST | f_list_ven | V944 |
2020-11-20 13:56:32 | L0825651943venue | LIST | L0825651943venue | the blakehay |
2020-11-20 13:56:10 | L0825651943 | LIST | f_list_ven | V01754281771 |
2020-11-20 13:55:00 | L0907087873venue | LIST | L0907087873venue | Hull New Theatre |
2020-11-20 13:54:52 | L0907087873venue | LIST | L0907087873venue | blake |
2020-11-20 13:52:58 | L0907087873venue | LIST | L0907087873venue | the |
2020-11-20 13:48:53 | L0907087873venue | LIST | L0907087873venue | the bla |
2020-11-20 13:43:48 | L0907087873venue | LIST | L0907087873venue | |
2020-11-16 17:05:00 | L0106688191 | LIST | f_list_ph | |
2020-11-16 17:04:51 | L0106688191 | LIST | f_list_ph | 5 |
2020-11-16 16:36:23 | L1407757745 | LIST | f_list_to | 29-Sep-21 |
2020-11-16 16:36:21 | L1407757745 | LIST | f_list_to | 29-Sep-22 |
2020-11-16 11:33:54 | L0106688191 | LIST | f_list_to | 5-Dec-20 |
2020-11-16 11:33:50 | L0106688191 | LIST | f_list_to | 5-Dec-21 |
2020-10-29 13:54:09 | L01183751150 | LIST | f_list_when | |
Action could be EDIT, LIST or SQL (sql in value field) or ADD as we wont have a qtix and can't do any modifications to a record until we have that qtix ... so do we apply all sql first or does an sql trigger immediate processing? so if we get an add the qtix is, e.g., V0, we create a new qtix, update the record and then apply the add?? so the sql for the add needs a dummy that we can replace OR the add is not an sql but a json of the fields/values!