convert django model's verbose_name to a modified sql
you have a table named book
as below
class Book(Model):
ISBN = CharField(max_length=32, null=False, default="", db_column="ISBN", verbose_name=r"book ISBN")
name = CharField(max_length=32, null=True, db_column="name", verbose_name=r"book name")
price = FloatField(null=False, default=0, db_column="price", verbose_name=r"book price")
create_time = DateTimeField(auto_now_add=True, db_column="create_time", verbose_name=r"book created time")
_db = "black_book_shop"
class Meta:
db_table = "book"
it will dumps serveral lines of sql as below
ALTER TABLE `black_book_shop`.`book` MODIFY `id` int NOT NULL COMMENT 'ID';
ALTER TABLE `black_book_shop`.`book` MODIFY `ISBN` varchar(32) NOT NULL COMMENT 'book ISBN';
ALTER TABLE `black_book_shop`.`book` MODIFY `name` varchar(32) DEFAULT NULL COMMENT 'book name';
ALTER TABLE `black_book_shop`.`book` MODIFY `price` double NOT NULL COMMENT 'book price';
ALTER TABLE `black_book_shop`.`book` MODIFY `create_time` datetime NOT NULL COMMENT 'book created time'
git clone git@github.com:Altynai/django-column-comment.git --depth=1
cd django-column-comment
python setup.py install
Usage: dcc.py [options] path
path django project's path
Options:
-h, --help show this help message and exit
-r, --recursion serach for the possible django projects hierarchically
-o OUTPUT, --output=OUTPUT
save the the result sql file to the path [default: .]
-n NAME, --name=NAME save result to the named file [default: models-comment.sql]