Python - MySql access for inserting data into db

I have created a Django application.Now i am trying to populate some data into SQL database tabel EmployeeDetails, using normal python script. But i am not able to insert data into db. I guess its because my db is not connecting with this external python script. I am new with Python, so please help me to solve this.This is my python script :

import MySQLdb
    db=MySQLdb.connect("localhost","root","password123","employee")
    def dumpdata():
        userName = 'John'
        designation = 'Software Engineer'
        employeeID = '2312'
        contactNumber = '9495321257'
        project = 'cricket'
        dateOfJoin = '2009-10-10'
        EmployeeDetails(userName,designation,employeeID,contactNumber,project,dateOfJoin).save()

My settings.py in Django is :

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'.
   开发者_StackOverflow     'NAME': 'employee',                      # Or path to database file if using sqlite3.
        'USER': 'root',                      # Not used with sqlite3.
        'PASSWORD': 'password123',                  # Not used with sqlite3.
        'HOST': '',                      # Set to empty string for localhost. Not used with sqlite3.
        'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
    }
}

My final need is to put the insertion code in a loop and populate as many data i need into db. Somebody please look into my code and help me to solve this.

---

1. Don't import MySQLdb. Use Django instead.

2. Don't bother connecting to the database directly. Use Django instead.

3. If you are going to create objects from your models, you need to import those. They will take care of importing all of the necessary Django modules, if you have written them correctly.

4. Model.objects.create() is a shorthand for creating a new object and saving it.

Something like this:

from myapp.models import EmployeeDetails

def dumpdata():
    userName = 'John'
    designation = 'Software Engineer'
    employeeID = '2312'
    contactNumber = '9495321257'
    project = 'cricket'
    dateOfJoin = '2009-10-10'
    EmployeeDetails.objects.create(userName,designation,employeeID,contactNumber,project,dateOfJoin)

Or this (using keyword arguments means that you don't have to remember the exact order of parameters to create the object):

EmployeeDetails.objects.create(
    userName='John',
    designation='Software Engineer',
    employeeID='2312',
    contactNumber='9495321257',
    project='cricket',
    dateOfJoin='2009-10-10')

You'll have to run that with the Django package on your Python path, and with your DJANGO_SETTINGS_MODULE environment variable set correctly. Something like this usually works for me:

PYTHONPATH=. DJANGO_SETTINGS_MODULE=settings python my_script.py

But that invocation can depend a lot on your system setup.

---

Have you installed MySQL support for python yet?

In case you're on Windows, the simplest would be to use a precompiled distribution - this one's limited to Python 2.6. I haven't found any precompiled version for higher Python versions.