Your question is very unclear. You should probably go through the django-tutorial. But sure you can insert data into the db from views. Assume you have a model called Foo: models.py class Foo(models.Model): name = models.CharField(max_length=100) view.py from .models import Foo def some_name(request): foo_instance = Foo.objects.create(name=”test”) return render(request, ‘some_name.html.html’)
PyMySQL and MySQLdb provide the same functionality – they are both database connectors. The difference is in the implementation where MySQLdb is a C extension and PyMySQL is pure Python. There are a few reasons to try PyMySQL: it might be easier to get running on some systems it works with PyPy it can be … Read more
You can dump all results to the csv file without looping: rows = cursor.fetchall() fp = open(‘/tmp/file.csv’, ‘w’) myFile = csv.writer(fp) myFile.writerows(rows) fp.close()
Did you commit it? conn.commit()
Sort of already answered this in the comments, but just so this question has an answer, the problem was resolved through running: sudo apt-get install python3-pymysql