Hello, Any view how to delete the Spiceb schema via rest api or cli ? I am using PostgreSQL and had a specific schema loaded. I wish to delete the same and push a new one which seems to fail. Don't see delete API nor via zed cli any option to delete ? Any view ?

👋🏻 there is no delete operation because the write schema API method replaces the entirety of the schema stored. If you are hitting an error is because you have relationships stored, so you'll need to first delete relationships and then write the new schema

Thanks

are you using the same prefix as before or a different one?

Do you mean namespace ? Yes I am using different namespace, I was under assumption that if all existing schema specific relation are deleted then we can update the existing schema and add more definition which could be under different namespace

Yeah no, I believe you have to use the same namespace prefix

Let me share an example, If I use rest api to write following schema [v1/schema/write] and fetch the same via read [v1/schema/read] it fails But if same schema is pushed via Python script and then read via rest read api , it works .

curl --location --request POST 'http://localhost:8443/v1/schema/write' \
--header 'Authorization: Bearer graphToken' \
--header 'Content-Type: application/json' \
--data-raw '{
    "schemaText": "definition authznamespace/namespace {}\n\ndefinition authznamespace/user {}"
}'

Any reason why write of above schema via rest api is not working ? [Note, rest api response is 200 ] @vroldanbet

@romil it probably wants

schema_text

Just tried that as well and it didnt work , still returns 200 but then the read is not returning same schema . Also the swagger api says it has to be

schemaText

ah that worked !! thanks for correcting

the reason it didn't give an error is that an empty schema is valid; its just ignored

yeah, thought so