don't overwrite casbin_rule if table exists already about typeorm-adapter HOT 7 CLOSED

Can you be more specific?

from typeorm-adapter.

@GopherJ We should use typeorm to synchronize casbin_rule.
If typeorm-adapter cannot meet your needs, you can create own adapter.

from typeorm-adapter.

hello @hsluoyz @nodece , sure it meets my needs, I was wondering if it overwrites casbin_rule even it exists already, because I added some CONTRAINT to this table to meet my needs.

Also my issue is that I have a casbin server with some management apis, I use postgresql for storing these policies, yesterday I was trying to add a new function to load policy.csv into postgresql while starting or restarting, using this way I can have some default policies, but if I restart this server or run multiple times the server, it duplicates my default policies...

Here the code to load one row of csv into postgresql:

 enforcer.addPolicy(addPrefix(role), domain, object, action).catch(console.error);

So I tried to create casbin_rule manually using rust diesel, and I added some constraints to casbin_rule table, but it seems that it doesn't help, so I think it's typeorm-adapter overited my own casbin_rule table.

// rbac with domain
CONSTRAINT unique_key UNIQUE(ptype, v0, v1, v2, v3)

from typeorm-adapter.

@GopherJ
My Solution:
Please check manually whether the table exists then set synchronize in typeorm option.

from typeorm-adapter.

@nodece my setup script will garantee that this table exists (it will be created by diesel), so I need to set synchronize: false right?

from typeorm-adapter.

@GopherJ Right!

from typeorm-adapter.

@nodece thanks!

from typeorm-adapter.