HomoCodens

db_ts_get_last_update (and probably others) fail with empty key array

1

``` db_ts_get_last_update(con, names(list()), schema = "kofcast") Error in .local(conn, name, value, ...) : !any(is.na(field_types_idx)) is not TRUE Error: Failed to fetch row: ERROR: table "tmp_ts_read_keys" does not exist ```

grant schema access to <schema>_reader

1

Currently db admins need to `grant all on schema to ` for each individual user who needs to work with a specific schema. Would it not be easier to grant...

https://github.com/r-lib/mockery#comparison-to-with_mock It seems I mistook the fact that `with_mock` works as a sign that the warning it should be avoided is outdated. Apparently this is not so...

Coverage is generated via the following bit: `SET coverage = concat('[', ts_data->'time'->0, ',', ts_data->'time'->-1, ')')::daterange;` However this means the last timestamp of a series is always excluded (leading to empty...

db_ts_store.list with empty list

1

calling `db_ts_store.list` (i.e. storing a plain list of ts) with an empty list causes an error. Reason is that the following bit results in a `list()` instead of a vector...

add logging/statistics

1

I'm thinking things like `last_accessed_at` and `_by` in catalog (or on vintage level) and such. This would help identify stale data, power users, unaothorized access to series and be generally...

make db_ts_find_keys return a vector

1

closes #227

db_ts_store.tslist already does that closes #239

closes #243

* db_ts_store.tslist already has such a check * if an empty list is passed to the .list variant this causes an error because sapply returns a list(), not a vector....