Allow var_store to be assigned to accounts
At the moment, it is only possible to assign var_store key/value pairs to applications. This will very likely lead to a fair amount of duplication and inconvenience to admins.
Give the ability to assign a var_store row to an account or an application.
- add a new column
accid
to allow users to associate vars with accounts
The following processors will need to be updated:
-
var_store_create -
inputs appid
,accid
,key
,value
-
ensure there are no similar vars already created
-
-
var_store_delete -
delete by vid
or byaccid
orappid
-
- var_store_read
-
filter vars by vid
appid
,accid
,key
,value
-
- var_store_update
-
update appid
,accid
,value
byvid
,accid
&&key
,appid
&&key
-
Additional tasks:
-
dbDefinition.yaml -
accid allow null -
appid allow null -
val allow null
-
-
update function for existing databases -
add accid column -
update appid column -
update val column
-
-
DB classes -
ApiOpenStudio\Db\VarStoreMapper -
ApiOpenStudio\Db\VarStore
-
Update the associated tests:
-
VarStoreCept
Edited by laughing man