|
Revision 152
(checked in by thejimmyg, 8 months ago)
|
Added a series of updates to SQLAlchemy code plus a fix to the OpenID support and an encoding problem with form.py
|
| Line | |
|---|
| 1 |
import model |
|---|
| 2 |
from authkit.users.sqlalchemy_driver import UsersFromDatabase |
|---|
| 3 |
|
|---|
| 4 |
# Setup SQLAlchemy database engine |
|---|
| 5 |
from sqlalchemy import engine_from_config |
|---|
| 6 |
engine = engine_from_config({'sqlalchemy.url':'sqlite:///test.db'}, 'sqlalchemy.') |
|---|
| 7 |
model.init_model(engine) |
|---|
| 8 |
model.engine = engine |
|---|
| 9 |
|
|---|
| 10 |
users = UsersFromDatabase(model) |
|---|
| 11 |
model.meta.metadata.create_all(model.engine) |
|---|
| 12 |
users.group_create("pylons") |
|---|
| 13 |
users.role_create("admin") |
|---|
| 14 |
users.user_create("james", password="password1", group="pylons") |
|---|
| 15 |
users.user_create("ben", password="password2") |
|---|
| 16 |
users.user_add_role("ben", role="admin") |
|---|
| 17 |
|
|---|
| 18 |
# Commit the changes |
|---|
| 19 |
model.meta.Session.commit() |
|---|
| 20 |
model.meta.Session.remove() |
|---|
| 21 |
|
|---|
