Django修改app名称和数据表迁移方案实现_Python

Django修改app名称和数据表迁移方案实现

2020-09-17 13:31请叫我算术嘉 Python

这篇文章主要介绍了Django修改app名称和数据表迁移方案实现，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧

项目一开始的设计很重要，django中app的名称建议用小写

我的博客由两个app组成，Blog和JiaBlog，总觉得不美观，想改成小写的oblog和blog，那么最关键的地方在于和orm数据表的映射

把JiaBlog.articles改成blog.articles是终极目标，这里不推荐用django的migrate

写一个sql批量生成mysql改表名的语句

				?

									SELECT

									 CONCAT(

									 'ALTER TABLE ',

									 table_name,

									 ' RENAME TO b',

									 substring(table_name, 5),

									 ';'

									 )

									FROM

									 information_schema.tables Where table_name LIKE 'JiaBlog_%';

这样就批量生成了sql语句

				?

									ALTER TABLE JiaBlog_Love RENAME TO blog_Love;

									ALTER TABLE JiaBlog_area RENAME TO blog_area;

									ALTER TABLE JiaBlog_articlebodypic RENAME TO blog_articlebodypic;

									ALTER TABLE JiaBlog_articles RENAME TO blog_articles;

									ALTER TABLE JiaBlog_articles_tags RENAME TO blog_articles_tags;

									ALTER TABLE JiaBlog_blogauth RENAME TO blog_blogauth;

									ALTER TABLE JiaBlog_blogrole RENAME TO blog_blogrole;

									ALTER TABLE JiaBlog_bloguser RENAME TO blog_bloguser;

									ALTER TABLE JiaBlog_bloguser_role RENAME TO blog_bloguser_role;

									ALTER TABLE JiaBlog_blogusercollect RENAME TO blog_blogusercollect;

									ALTER TABLE JiaBlog_category RENAME TO blog_category;

									ALTER TABLE JiaBlog_codemodel RENAME TO blog_codemodel;

									ALTER TABLE JiaBlog_comment RENAME TO blog_comment;

									ALTER TABLE JiaBlog_daynumber RENAME TO blog_daynumber;

									ALTER TABLE JiaBlog_genre RENAME TO blog_genre;

									ALTER TABLE JiaBlog_graduation RENAME TO blog_graduation;

									ALTER TABLE JiaBlog_hits RENAME TO blog_hits;

									ALTER TABLE JiaBlog_honour RENAME TO blog_honour;

									ALTER TABLE JiaBlog_jia RENAME TO blog_jia;

									ALTER TABLE JiaBlog_jiafile RENAME TO blog_jiafile;

									ALTER TABLE JiaBlog_message RENAME TO blog_message;

									ALTER TABLE JiaBlog_movie RENAME TO blog_movie;

									ALTER TABLE JiaBlog_note RENAME TO blog_note;

									ALTER TABLE JiaBlog_paper RENAME TO blog_paper;

									ALTER TABLE JiaBlog_params RENAME TO blog_params;

									ALTER TABLE JiaBlog_project RENAME TO blog_project;

									ALTER TABLE JiaBlog_recruinfo RENAME TO blog_recruinfo;

									ALTER TABLE JiaBlog_recruitment RENAME TO blog_recruitment;

									ALTER TABLE JiaBlog_resume RENAME TO blog_resume;

									ALTER TABLE JiaBlog_sysrecord RENAME TO blog_sysrecord;

									ALTER TABLE JiaBlog_tag RENAME TO blog_tag;

									ALTER TABLE JiaBlog_teacher RENAME TO blog_teacher;

									ALTER TABLE JiaBlog_userip RENAME TO blog_userip;

									ALTER TABLE JiaBlog_version RENAME TO blog_version;

									ALTER TABLE JiaBlog_visitnumber RENAME TO blog_visitnumber;