python - Can I still use modles.py to operate mysql after using pymysql in django?

Question

My environment is: Python3.6 + django1.11.1 + mysql. I use pymysql. When I learned it before, I used sqlite3. Now I use pymysql. Should I still create tables by defining classes in models.py? Why do I write like this and then execute {code...} and it doesn't work in mysql...

巴扎黑 · Answer

makemigrations, which is responsible for creating new migrations based on the changes you have made to your models.

1.先把sqlite3替换成mysql,其他的代码不变，看能不能生成表．
2.如果使用pymysql,一般不用django内置model来写类对象．因为pymysql是对数据库进行操作，
　如
　   cursor.execute(sql, args)
 
 此时可定义类,创建表可以类里面进行（仅仅是例子，不代表唯一）
 
 class Bar(object):
     TABLE = 'bar'
     TABLE_SCHEMA = '''
         create table if not exist `bar`(
             foo ...
         )
     '''
 
     def __init__(self, sql_connection):
         self.sql_connection = sql_connection
     　　 self.__create_table()
     
     def __create_table(self):
         cursor = self.sql_connection.cursor()
         cursor.execute(self.TABLE_SCHEMA)
     
     def get(self, foo):
         cursor = self.sql_connection.cursor()
         cursor.execute(...)

学习ing · Answer

You need to configure your model folder in INSTALLED_APPS of setting. For example, if you have a file called models.py and the upper-level folder is called app, then you need to configure the app into INSTALLED_APPS before it will be created

怪我咯 · Answer

Add two lines of code to xxx/xxx/__init__.py:

import pymysql
pymysql.install_as_MySQLdb()