項目一開始的設計很重要，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;

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

到此這篇關于Django修改app名稱和數據表遷移方案實現的文章就介紹到這了,更多相關Django修改app名稱和數據表遷移內容請搜索好吧啦網以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持好吧啦網！