Ticket #1418 (new enhancement)

Opened 11 months ago

Last modified 7 months ago

Improve "tg-admin sql" for SQLAlchemy

Reported by: paj Assigned to: paj
Priority: normal Milestone: 1.1
Component: SQLAlchemy Version: 1.0.2
Severity: normal Keywords:
Cc:

Description

Currently "tg-admin sql" only supports create for SQLAlchemy - SQLObject supports more functions. The important ones missing are (IMHO) "tg-admin sql sql" and "tg-admin sql status".

Change History

07/01/07 08:39:18 changed by paj

  • type changed from defect to enhancement.

09/02/07 13:34:01 changed by paj

  • owner changed from anonymous to paj.

This is the SO util's help: 

Available commands:
  (use "tg-admin-script.py help COMMAND" or "tg-admin-script.py COMMAND -h"
  for more information)
create:  Create tables
drop:    Drop tables
execute: Execute SQL statements
help:    Show help
list:    Show all SQLObject classes found
record:  Record historical information about the database status
sql:     Show SQL CREATE statements
status:  Show status of classes vs. database
upgrade: Update the database to a new version (as created by record)

I'm finishing off a script that does most of these. I going to omit drop as it's potentially dangerous (and rarely needed), and sql as you can do "create -n" equivalently. Also, I'm not going to attempt record or upgrade - that would involve using the Migrate project.

09/02/07 14:37:40 changed by paj

We'll have to hold on "create -n" for now, the SA internals make this difficult to do. Otherwise good to go, a preliminary version is in [3446] and [3447]. This will need some beta testing, so leaving ticket open for now.