ORM framework in Python Django ORM practice
With the development of the Internet, development software has become more and more popular. In order to improve development efficiency and code management, many languages provide ORM frameworks, and Python is no exception. Django is a Python web framework that provides a powerful ORM framework - Django ORM. This article will introduce how to use Django ORM to manage databases.
- Installing Django
Before using Django ORM, you need to install Django. You can use pip to install it, the command is as follows:
pip install django
- New Django project
After installing Django, you can use it to create a new project, the command is as follows:
django-admin startproject project_name
This will create a Django project named project_name.
- Create database model
In Django ORM, the database model can be defined as a Python class. In the project's app directory, create a file named models.py and define the model in it. For example, to create a model named Book with title, author, pub_date and price attributes, it can be defined as follows:
from django.db import models
class Book(models.Model):
title = models.CharField(max_length=100)
author = models.CharField(max_length=200)
pub_date = models.DateField()
price = models.DecimalField(max_digits=5, decimal_places=2)Here, Book inherits the Model class in Django ORM and defines four Attributes. CharField represents character type, DateField represents date type, and DecimalField represents decimal type. When defining each property, you can use parameters to control their type, length, precision, etc.
In addition, you can also define methods and class methods for models. For example, define a class method named get_books in the Book model to obtain all books from the database, as follows:
class Book(models.Model):
# 类属性
title = models.CharField(max_length=100)
author = models.CharField(max_length=200)
pub_date = models.DateField()
price = models.DecimalField(max_digits=5, decimal_places=2)
# 类方法
@classmethod
def get_books(cls):
return cls.objects.all()Here, use the classmethod modifier to modify the get_books method, and Defined as a class method. This method uses the objects attribute in Django ORM to get all Book objects.
- Run database migration
After defining the model, you need to create tables in the database. This process can be accomplished using the makemigrations and migrate commands provided by Django ORM. Using the makemigrations command will generate a migration file containing changes to the model. Using the migrate command will execute the migration file and apply the changes to the database. The command is as follows:
python manage.py makemigrations python manage.py migrate
- Use Django ORM to manage the database
After defining the database model and completing the database migration, you can use Django ORM to manage the database. For example, in views.py you can write the following code:
from django.shortcuts import render
from .models import Book
def book_list(request):
books = Book.get_books()
return render(request, 'book_list.html', {'books': books})Here, import the Book model from models.py and use the get_books method to get all the books. They are then passed as parameters into the render function, which will use the template file book_list.html to render the page.
In book_list.html, you can use the following code to display a list of books:
{% for book in books %}
<div class="book">
<h2>{{ book.title }}</h2>
<p>{{ book.author }} - {{ book.pub_date|date:"Y年m月d日" }}</p>
<p>价格：{{ book.price }}</p>
</div>
{% endfor %}Here, use a for loop to traverse all books and output their attributes. It should be noted that when outputting the pub_date attribute, a date filter is used to format the date into the form of year, month and day.
- Summary
Django ORM is a powerful ORM framework that can help developers manage databases easily. This article introduces the process of using Django ORM to create models, run database migrations, and manage databases. I hope this article can help beginners better understand the application of Django ORM.
The above is the detailed content of ORM framework in Python Django ORM practice. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to handle API authentication in Python
Jul 13, 2025 am 02:22 AM
The key to dealing with API authentication is to understand and use the authentication method correctly. 1. APIKey is the simplest authentication method, usually placed in the request header or URL parameters; 2. BasicAuth uses username and password for Base64 encoding transmission, which is suitable for internal systems; 3. OAuth2 needs to obtain the token first through client_id and client_secret, and then bring the BearerToken in the request header; 4. In order to deal with the token expiration, the token management class can be encapsulated and automatically refreshed the token; in short, selecting the appropriate method according to the document and safely storing the key information is the key.
How to parse large JSON files in Python?
Jul 13, 2025 am 01:46 AM
How to efficiently handle large JSON files in Python? 1. Use the ijson library to stream and avoid memory overflow through item-by-item parsing; 2. If it is in JSONLines format, you can read it line by line and process it with json.loads(); 3. Or split the large file into small pieces and then process it separately. These methods effectively solve the memory limitation problem and are suitable for different scenarios.
Python for loop over a tuple
Jul 13, 2025 am 02:55 AM
In Python, the method of traversing tuples with for loops includes directly iterating over elements, getting indexes and elements at the same time, and processing nested tuples. 1. Use the for loop directly to access each element in sequence without managing the index; 2. Use enumerate() to get the index and value at the same time. The default index is 0, and the start parameter can also be specified; 3. Nested tuples can be unpacked in the loop, but it is necessary to ensure that the subtuple structure is consistent, otherwise an unpacking error will be raised; in addition, the tuple is immutable and the content cannot be modified in the loop. Unwanted values can be ignored by \_. It is recommended to check whether the tuple is empty before traversing to avoid errors.
How to make asynchronous API calls in Python
Jul 13, 2025 am 02:01 AM
Python implements asynchronous API calls with async/await with aiohttp. Use async to define coroutine functions and execute them through asyncio.run driver, for example: asyncdeffetch_data(): awaitasyncio.sleep(1); initiate asynchronous HTTP requests through aiohttp, and use asyncwith to create ClientSession and await response result; use asyncio.gather to package the task list; precautions include: avoiding blocking operations, not mixing synchronization code, and Jupyter needs to handle event loops specially. Master eventl
What is a pure function in Python
Jul 14, 2025 am 12:18 AM
Pure functions in Python refer to functions that always return the same output with no side effects given the same input. Its characteristics include: 1. Determinism, that is, the same input always produces the same output; 2. No side effects, that is, no external variables, no input data, and no interaction with the outside world. For example, defadd(a,b):returna b is a pure function because no matter how many times add(2,3) is called, it always returns 5 without changing other content in the program. In contrast, functions that modify global variables or change input parameters are non-pure functions. The advantages of pure functions are: easier to test, more suitable for concurrent execution, cache results to improve performance, and can be well matched with functional programming tools such as map() and filter().
Can a Python class have multiple constructors?
Jul 15, 2025 am 02:54 AM
Yes,aPythonclasscanhavemultipleconstructorsthroughalternativetechniques.1.Usedefaultargumentsinthe__init__methodtoallowflexibleinitializationwithvaryingnumbersofparameters.2.Defineclassmethodsasalternativeconstructorsforclearerandscalableobjectcreati
what is if else in python
Jul 13, 2025 am 02:48 AM
ifelse is the infrastructure used in Python for conditional judgment, and different code blocks are executed through the authenticity of the condition. It supports the use of elif to add branches when multi-condition judgment, and indentation is the syntax key; if num=15, the program outputs "this number is greater than 10"; if the assignment logic is required, ternary operators such as status="adult"ifage>=18else"minor" can be used. 1. Ifelse selects the execution path according to the true or false conditions; 2. Elif can add multiple condition branches; 3. Indentation determines the code's ownership, errors will lead to exceptions; 4. The ternary operator is suitable for simple assignment scenarios.
How to prevent a method from being overridden in Python?
Jul 13, 2025 am 02:56 AM
In Python, although there is no built-in final keyword, it can simulate unsurpassable methods through name rewriting, runtime exceptions, decorators, etc. 1. Use double underscore prefix to trigger name rewriting, making it difficult for subclasses to overwrite methods; 2. judge the caller type in the method and throw an exception to prevent subclass redefinition; 3. Use a custom decorator to mark the method as final, and check it in combination with metaclass or class decorator; 4. The behavior can be encapsulated as property attributes to reduce the possibility of being modified. These methods provide varying degrees of protection, but none of them completely restrict the coverage behavior.
