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

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

把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內(nèi)關于models的引用3.修改app中urls.py內(nèi)關于app的views.py的引用4.修改項目settings.pyapp名稱5.修改項目urls.py中include的app名稱

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