Django interacts with MySQL

See all the software that Ubuntu has installed:

Dpkg-l Dpkg-l | grep MySQL

View the path to the software installation

Dpkg-l | grep MySQL

Check the boot-up software to install additional plugins:

sudo apt-get install rcconfrcconf a whole bit more: sudo apt-get install sysv-rc-confsysv-rc-conf

Install MySQL:

# apt-get Install python-setuptools libmysqld-dev Libmysqlclient-dev # easy_install Mysql-python or #pip install MYSQL-PYT Hon

Django Setting Configuration:

DATABASES = {' default ': {' ENGINE ': ' Django.db.backends.mysql ', ' NAME ': ' Books ', #你的数据库名称 ' US  ER ': ' Root ', #你的数据库用户名 ' PASSWORD ': ', #你的数据库密码 ' HOST ': ', #你的数据库主机, leave blank default to localhost ' PORT ': ' 3306 ', #你的数据库端口}}

Add the following table statement in the Model module:

From django.db import models# Create your models Here.class publisher (models. Model): Name=models. Charfield (max_length=30) address=models. Charfield (max_length=50) city=models. Charfield (max_length=60) state_province=models. Charfield (max_length=30) county=models. Charfield (default= "CN", max_length=50) website=models. Urlfield () class author (models. Model): First_name=models. Charfield (max_length=30) last_name=models. Charfield (max_length=40) email=models. Emailfield (Blank=true) class book (Models. Model): Title=models. Charfield (max_length=100) authors=models. Manytomanyfield (author) publisher=models. ForeignKey (publisher) Publication_date=models. Datefield ()

Django will automatically change these to SQL statements.

Python manage.py validate #测试上面的语句是否有问题.

Python manage.py sqlall app #把上面的内容生成sql语句.

Run the above command error: Commanderror:app ' App ' has migrations. Only the sqlmigrate and Sqlflush commands can is used when a app has migrations. FIX: Delete the Migrations folder in the app.

Python manage.py syncdb #把这些语句写入数据库中.

#选yes建立数据库后台管理的账号和密码.

#如果这步跳过了, the execution:

Python manage.py createsuperuser #创建用户python manage.py ChangePassword #更改密码

#练习在python交互模式下操作数据库:

./manage.py Shell #进入django变量的交互器from app.models Import publisher #导入publisher数据库.

#插入一条数据:

P1=publisher (name= ' Qinghua University ', address= ' Wudaokou ', city= ' Beijing ', state_province= ' Beijing ', county= ' China ', website= ' www.qinghua.com ')

P1.name #查看插入的name

P1.address #查看插入的address

P1.save () #插入的数据写入数据库中

#更新一条数据:

p1.address= "Qinghualu" P1.save ()

#查看所有的数据

In the models module, the following is added below the build Table statement:

def __unicode__ (self): return self.name,self.address

Then go to the swap window to see all the data:

Publisher.objects.all ()

#查询国家等于中国的一条数据:

Publisher.objects.filter (country= "China")

#查询出来的数据进行更改:

A=publisher.objects.get (name= "Beijing Daxue") a.county= "USA" A.save ()

#高效的更新数据方式, and no save required:

Publisher.objects.filter (id=1). Update (name= "Qingdaodaxue")

#在浏览器中打开后台管理数据库界面:

http://192.168.110.106/admin/

The account is the user name and password created when synchronizing the database, log in.

Create a admin.py file under the app

VI admin.py

From Django.contrib import adminfrom app.models import publisher,author,bookadmin.site.register (publisher) Admin.site.register (author) admin.site.register (book)

When you are finished, reopen the page.

#django中引用bootstrap:

In the setting.py:

media_root= '/root/project/statics/bootstrap/'

In the url.py:

From django.conf Import settings

Django interacts with MySQL