apache / apache/casbin-dashboard

Inconsistent schema?

Open
#3 7 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
88
Forks
46
PR merge metrics
No merged PRs in 30d

Description

The following was created by casbin-dashboard in Postgres:
```
casbin=# select * from casbin_rule;
p_type | v0 | v1 | v2 | v3 | v4 | v5
--------+-------+-------+-------+----+----+----
p | alice | book1 | read | | |
p | bob | book2 | write | | |
g | alice | admin | | | |
(3 rows)
```
But when I go to pycasbin it seems to want an id column:
```
psycopg2.errors.UndefinedColumn: column casbin_rule.id does not exist
LINE 1: SELECT casbin_rule.id AS casbin_rule_id, casbin_rule.ptype A...
```
Are these projects compatible? Also hope to have casbin-server on the same database...

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by comparing the casbin_rule schema shown from Postgres with the query generated by pycasbin, then check how casbin-dashboard defines or expects that table. Reproduce the missing-id error and determine whether casbin-server uses the same database schema. Done means establishing compatibility and documenting or fixing the schema mismatch.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, postgresql, python
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.