mirror of
https://github.com/zyycn/codex-proxy-rs.git
synced 2026-11-06 08:06:19 +00:00
ZyyandCodex
cca89f2f96
Add per-account model allowlists and denylists to frozen routing, account settings, and CPR import/export. Preserve existing scheduling and account state boundaries. Closes #97 Co-authored-by: Codex <noreply@openai.com>
19 lines
1021 B
SQL
19 lines
1021 B
SQL
-- 账号模型政策独立于凭据与上游模型目录；已有账号保持不限制。
|
|
alter table provider_accounts
|
|
add column model_access_json jsonb not null default '{"mode":"all","models":[]}'::jsonb,
|
|
add constraint provider_accounts_model_access_ck check (
|
|
jsonb_typeof(model_access_json) = 'object'
|
|
and model_access_json ?& array['mode', 'models']
|
|
and model_access_json - 'mode' - 'models' = '{}'::jsonb
|
|
and octet_length(model_access_json::text) <= 131072
|
|
and case when jsonb_typeof(model_access_json -> 'models') = 'array' then
|
|
case model_access_json ->> 'mode'
|
|
when 'all' then jsonb_array_length(model_access_json -> 'models') = 0
|
|
when 'allowlist' then jsonb_array_length(model_access_json -> 'models') between 1 and 256
|
|
when 'denylist' then jsonb_array_length(model_access_json -> 'models') between 1 and 256
|
|
else false
|
|
end
|
|
and not jsonb_path_exists(model_access_json, '$.models[*] ? (@.type() != "string")')
|
|
else false end
|
|
);
|