快捷導(dǎo)航

Django修改app名稱和數(shù)據(jù)表遷移方案實現(xiàn)

更新時間：2020年09月17日 09:55:47 作者：請叫我算術(shù)嘉

這篇文章主要介紹了Django修改app名稱和數(shù)據(jù)表遷移方案實現(xiàn)，文中通過示例代碼介紹的非常詳細(xì)，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧

項目一開始的設(shè)計很重要，django中app的名稱建議用小寫

我的博客由兩個app組成，Blog和JiaBlog，總覺得不美觀，想改成小寫的oblog和blog，那么最關(guān)鍵的地方在于和orm數(shù)據(jù)表的映射

把JiaBlog.articles改成blog.articles是終極目標(biāo)，這里不推薦用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;

然后其余步驟大概如下
1.修改文件夾名稱
2.修改app中views.py內(nèi)關(guān)于models的引用
3.修改app中urls.py內(nèi)關(guān)于app的views.py的引用
4.修改項目settings.pyapp名稱
5.修改項目urls.py中include的app名稱

到此這篇關(guān)于Django修改app名稱和數(shù)據(jù)表遷移方案實現(xiàn)的文章就介紹到這了,更多相關(guān)Django修改app名稱和數(shù)據(jù)表遷移內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: