mysql django orm 实例
时间: 2023-10-12 12:18:36 浏览: 44
下面是一个 Django ORM 的示例,使用 MySQL 数据库:
1. 在 settings.py 文件中,指定数据库连接信息:
```python
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'mydatabase',
'USER': 'mydatabaseuser',
'PASSWORD': 'mypassword',
'HOST': 'localhost',
'PORT': '3306',
}
}
```
2. 创建一个模型类,定义数据表的结构和字段:
```python
from django.db import models
class Book(models.Model):
title = models.CharField(max_length=100)
author = models.CharField(max_length=50)
publisher = models.CharField(max_length=50)
price = models.DecimalField(max_digits=6, decimal_places=2)
```
3. 使用 Django 的 ORM 进行数据库操作,例如:
```python
# 添加数据
book = Book(title='Python Web 开发', author='Tom', publisher='人民邮电出版社', price=69.9)
book.save()
# 查询数据
books = Book.objects.filter(publisher__contains='邮电')
for book in books:
print(book.title, book.author, book.price)
# 更新数据
book = Book.objects.get(title='Python Web 开发')
book.price = 59.9
book.save()
# 删除数据
book = Book.objects.get(title='Python Web 开发')
book.delete()
```