Glyphicus should be able to create db tables if they have not been set up
Bug #493799 reported by
Jefficus
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Glyphicus |
Confirmed
|
Medium
|
mangalagouri |
Bug Description
When a user connects to a newly established MySQL db, it will not have the necessary tables set up. Glyphicus should detect this and offer to create them by presenting the user with a dialog and letting them decide to create or disconnect.
Changed in glyphicus: | |
assignee: | nobody → mangalagouri (mangalagouri-masarakal) |
To post a comment you must log in.
Ideally the nec. sql calls to create tables and such should not be hard coded but rather, should be driven by a script file that is saved as a project resource. The script file should be the one that is produced by running "mysqldump -d -h HOSTNAME -u USERNAME -pPASSWORD DBNAME" against a working copy of the database. That command will produce all the commands nec to recreate the db but the -d option will suppress all the insert statements, so we get a script to build the db tables but not the data - exactly what we want.
The other (maybe obvious) advantage of doing it this way is that we're always guaranteed to be building exactly the db that the code is currently expecting.