going / casbin-postgres-adapter

PostgreSQL Adapter for Casbin

going

Going

casbin-postgres-adapter's Issues

adapter.go:172:29: undefined: stm

Hello, I made a mistake in executing this order:

go get github.com/going/casbin-postgres-adapter

E:\GoWorks\src\github.com\going\casbin-postgres-adapter\adapter.go:172:29: undefined: stm

The performance of SavePolicy() is poor.

A user complained in Twitter that the performance of saving policy to PostgreSQL is poor. See the below code:

casbin-postgres-adapter/adapter.go

Lines 162 to 191 in 3a172af

	func (a *Adapter) SavePolicy(model model.Model) error {
	a.open()
	defer a.close()
	a.dropTable()
	a.createTable()
	stm, err := a.db.Prepare("insert into policy values($1, $2, $3, $4, $5, $6, $7)")
	if err != nil {
	return err
	}
	defer stm.Close()
	for ptype, ast := range model["p"] {
	for _, rule := range ast.Policy {
	if err = a.writeTableLine(stm, ptype, rule); err != nil {
	return err
	}
	}
	}
	for ptype, ast := range model["g"] {
	for _, rule := range ast.Policy {
	if err = a.writeTableLine(stm, ptype, rule); err != nil {
	return err
	}
	}
	}
	return nil
	}

Each Casbin policy rule is inserted into DB separatedly with an insert into, which causes the performance downgrade. Can you fix it by inserting all policy rules in one statement? Thanks.

Documentation

A minimal example of how to run it (like in https://github.com/casbin/mongodb-adapter/blob/master/README.md) would be greatly appreciated

Need change a Package name?

go get

got this error message:

D:\prj\job\src\github.com\going\casbin-postgres-adaptor\adaptor.go:15: syntax error: unexpected -, e
xpecting ;

Spelling error: rename casbin-postgres-adaptor to casbin-postgres-adapter

RT.