Closed Bug 858802 Opened 12 years ago Closed 12 years ago

Replace schema.sql with a SQLAlchemy model

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Platform:
x86_64
Linux
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

Details

(Whiteboard: [qa-])

Replacing our schema.sql and sql/upgrades/* with a SQLAlchemy model and alembic migrations.
Target Milestone: 44 → 42
Assignee: nobody → sdeckelmann
Commits pushed to master at https://github.com/mozilla/socorro https://github.com/mozilla/socorro/commit/52269b21e354fc422704f4aca50ace3f0a70d3b6 bug 858802 Replace schema.sql with SQLAlchemy model * Recreated setupdb_app.py * Added ~140 UDFs to schema creation in separate files * Create a SQLAlchemy Postgres connection manager for setupdb_app.py * one integration test only to test setupdb_app * Moved model definitions into models.py * Example alembic migrations * Removed deprecated partitioning test and testSchema.py * generated fresh set of data using fakedata.py tool Many thanks to Peter Bengtsson, Rob Helmer and Lars Lohn. https://github.com/mozilla/socorro/commit/c142d5599e3ff26055f19ac6f00440efd706be5a Merge pull request #1177 from selenamarie/bug858802-sqlalchemy-model bug 858802 Replace schema.sql with SQLAlchemy model
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Whiteboard: [qa-]
You need to log in before you can comment on or make changes to this bug.