模型开发与数据库交互－－数据库处理

models.py

from django.db import models
class Mysite(models.Model):
    title = models.CharField(max_length = 100)
    url = models.URLField()
    author = models.CharField(max_length = 100)
    num = models.IntegerField()

    class Meta:
        ordering = ['num']

settings.py

DATABASES = {
    'default': {
        #'ENGINE': 'django.db.backends.sqlite3',
        'ENGINE': 'django.db.backends.mysql',
        #'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
        'NAME':'test01',
        'USER':'root',
        'PASSWORD':'123',
        'HOST':'localhost',

    }
}

1、基本数据访问

python manage.py sqlall mylesson
python manage.py syncdb

2、插入和更新数据

m = Mysite.objects.all()
m = Mysite(title = ‘django’,num = 2)
m.save()

3、数据过滤

m=Mysite.objects.get(num=2)

4、数据排序

m = Mysite.objects.all().order_by(’num’)(‘-num')

5、更新多个对象，删除对象等

m.delete()
m.save()
m = Mysite.objects.all()[0:2]