700902 - balrog's client.wsgi app shouldn't try to create database tables

Status: RESOLVED FIXED

(Release Engineering :: General, defect)

Description

[[e-mail] (:bhearsum)]

The client app is meant to be run with read-only access to the database, and attempting to create the tables is probably causing the app to throw an Exception. We'll also need to figure out what _should_ be creating the tables. The two obvious options are the admin app (admin.wsgi) and some separate script that gets run by hand on request.

Comment 1

[[e-mail] (:bhearsum)]

Attachment: make table creation explicit, disable it in client.wsgi; add manage-db.py script

I gave this a quick run through locally against sqlite and mysql, both worked fine.

Comment 2

[Chris AtLee [:catlee]]

Comment on attachment 573497 [details] [diff] [review]
make table creation explicit, disable it in client.wsgi; add manage-db.py script

Review of attachment 573497 [details] [diff] [review]:
-----------------------------------------------------------------

Looks good, as long as we fix up the naming of AUS-server.py / client.wsgi eventually

Comment 3

[[e-mail] (:bhearsum)]

Comment on attachment 573497 [details] [diff] [review]
make table creation explicit, disable it in client.wsgi; add manage-db.py script

Landed, and passed on Jenkins: https://jenkins.mozilla.org/job/Balrog/31/