ORM framework Tortoise ORM in Python in practice
Jun 10, 2023 pm 06:05 PM
Tortoise ORM is an asynchronous ORM framework developed based on the Python language and can be used to manage relational databases in Python asynchronous applications.
This article will introduce how to use the Tortoise ORM framework to create, read, update and delete data. You will also learn how to perform simple and complex queries from a relational database.
Preparation
Before starting this tutorial, you need to install Python (Python3.6 is recommended) and install the Tortoise ORM framework.
You can install the Tortoise ORM framework via pip using the following command:
pip install tortoise-orm
Next, we will set up the database and model structure.
Create database connection
Using Tortoise ORM to perform database operations requires connecting to the database first. In this tutorial, we will use a SQLite database.
Tortoise ORM uses environment variables or .config files to manage database connection information. Create a file named .env and the following configuration to achieve database connection.
DATABASE_URL=sqlite://db.sqlite3
Where db.sqlite3 is the file name of the new database you want to create.
At the same time, we also need to use a function in the code to initialize Tortoise ORM:
import os
from dotenv import load_dotenv
from tortoise import Tortoise
# 加載環(huán)境變量
load_dotenv()
async def init_db():
await Tortoise.init(config={
'connections': {
'default': os.getenv('DATABASE_URL')
},
'apps': {
'models': {
'models': ['app.models',],
'default_connection': 'default'
}
}
})
await Tortoise.generate_schemas()In the above code, we use environment variables to obtain the database connection information and pass it to Tortoise ORM for initialization. Then call the Tortoise.generate_schemas() method to generate the corresponding data table for the defined model.
After completing the above operations, we can start creating the model.
Create Model
In this tutorial, we will create a simple blog model that contains title, content, creation time, update time, and author.
from tortoise import fields
from tortoise.models import Model
class Blog(Model):
id = fields.IntField(pk=True)
title = fields.CharField(max_length=100)
content = fields.TextField()
created_at = fields.DatetimeField(auto_now_add=True)
updated_at = fields.DatetimeField(auto_now=True)
author = fields.CharField(max_length=100)In the Blog model of the above code, we use the Model base class and create some fields id, title, content, created_at, updated_at, and author. pk=True specifies that the id field is the primary key. auto_now_add=True and auto_now=True specify that the created_at and updated_at fields should be automatically updated when created and updated respectively.
Now that we have successfully defined a model, let's learn how to use Tortoise ORM for CRUD operations.
Reading and creating data
Reading and creating data using Tortoise ORM is very simple, here is some sample code:
from app.models import Blog
# 創(chuàng)建一個新博客
blog = await Blog.create(title='Tortoise ORM', content='使用Tortoise ORM操作數(shù)據(jù)庫非常方便', author='Alice')
# 讀取所有博客
blogs = await Blog.all()
for blog in blogs:
print(blog.title)
# 根據(jù)標(biāo)題讀取指定博客
blog = await Blog.get(title='Tortoise ORM')
print(blog.content)In the above code, we used The Blog.create() method creates a new blog, uses the Blog.all() method to read all blogs, and uses the Blog.get() The method reads the specified blog based on the title.
Update and delete data
Tortoise ORM also provides methods to update and delete data. Here is some sample code:
# 更新博客的內(nèi)容 blog.content = 'Tortoise ORM提供了豐富的API來管理數(shù)據(jù)庫' await blog.save() # 刪除指定的博客 await Blog.filter(title='Tortoise ORM').delete()
In the above code, we have updated the content of the blog using the save() method and filter() and delete()The method deletes the specified blog based on the title.
Execute complex queries
In addition to basic CRUD operations, Tortoise ORM also allows the execution of complex queries. Here are some examples:
# 使用where子句查詢特定日期創(chuàng)建的博客
blogs = await Blog.filter(created_at__date='2021-07-12').all()
# 使用order_by子句將博客按更新日期升序排列
blogs = await Blog.all().order_by('updated_at')
# 連接多個過濾器查詢具有特定條件的博客
blogs = await Blog.all().filter(title__contains='ORM', author__icontains='Alice') In the above code, we used filter(), all() and order_by() Method combined with some query parameters, eg. created_at__date, title__contains, and author__icontains, etc., to perform complex queries.
Conclusion
In this tutorial, we learned how to use the Tortoise ORM framework to implement CRUD operations, initialize the database and create models, and perform complex database queries. As we can see, Tortoise ORM makes managing databases in Python asynchronous applications very simple and intuitive.
The above is the detailed content of ORM framework Tortoise ORM in Python in 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)
PHP calls AI intelligent voice assistant PHP voice interaction system construction
Jul 25, 2025 pm 08:45 PM
User voice input is captured and sent to the PHP backend through the MediaRecorder API of the front-end JavaScript; 2. PHP saves the audio as a temporary file and calls STTAPI (such as Google or Baidu voice recognition) to convert it into text; 3. PHP sends the text to an AI service (such as OpenAIGPT) to obtain intelligent reply; 4. PHP then calls TTSAPI (such as Baidu or Google voice synthesis) to convert the reply to a voice file; 5. PHP streams the voice file back to the front-end to play, completing interaction. The entire process is dominated by PHP to ensure seamless connection between all links.
How to use PHP combined with AI to achieve text error correction PHP syntax detection and optimization
Jul 25, 2025 pm 08:57 PM
To realize text error correction and syntax optimization with AI, you need to follow the following steps: 1. Select a suitable AI model or API, such as Baidu, Tencent API or open source NLP library; 2. Call the API through PHP's curl or Guzzle and process the return results; 3. Display error correction information in the application and allow users to choose whether to adopt it; 4. Use php-l and PHP_CodeSniffer for syntax detection and code optimization; 5. Continuously collect feedback and update the model or rules to improve the effect. When choosing AIAPI, focus on evaluating accuracy, response speed, price and support for PHP. Code optimization should follow PSR specifications, use cache reasonably, avoid circular queries, review code regularly, and use X
Object-Relational Mapping (ORM) Performance Tuning in PHP
Jul 29, 2025 am 05:00 AM
Avoid N 1 query problems, reduce the number of database queries by loading associated data in advance; 2. Select only the required fields to avoid loading complete entities to save memory and bandwidth; 3. Use cache strategies reasonably, such as Doctrine's secondary cache or Redis cache high-frequency query results; 4. Optimize the entity life cycle and call clear() regularly to free up memory to prevent memory overflow; 5. Ensure that the database index exists and analyze the generated SQL statements to avoid inefficient queries; 6. Disable automatic change tracking in scenarios where changes are not required, and use arrays or lightweight modes to improve performance. Correct use of ORM requires combining SQL monitoring, caching, batch processing and appropriate optimization to ensure application performance while maintaining development efficiency.
How to develop AI intelligent form system with PHP PHP intelligent form design and analysis
Jul 25, 2025 pm 05:54 PM
When choosing a suitable PHP framework, you need to consider comprehensively according to project needs: Laravel is suitable for rapid development and provides EloquentORM and Blade template engines, which are convenient for database operation and dynamic form rendering; Symfony is more flexible and suitable for complex systems; CodeIgniter is lightweight and suitable for simple applications with high performance requirements. 2. To ensure the accuracy of AI models, we need to start with high-quality data training, reasonable selection of evaluation indicators (such as accuracy, recall, F1 value), regular performance evaluation and model tuning, and ensure code quality through unit testing and integration testing, while continuously monitoring the input data to prevent data drift. 3. Many measures are required to protect user privacy: encrypt and store sensitive data (such as AES
python seaborn jointplot example
Jul 26, 2025 am 08:11 AM
Use Seaborn's jointplot to quickly visualize the relationship and distribution between two variables; 2. The basic scatter plot is implemented by sns.jointplot(data=tips,x="total_bill",y="tip",kind="scatter"), the center is a scatter plot, and the histogram is displayed on the upper and lower and right sides; 3. Add regression lines and density information to a kind="reg", and combine marginal_kws to set the edge plot style; 4. When the data volume is large, it is recommended to use "hex"
How to use PHP combined with AI to analyze video content PHP intelligent video tag generation
Jul 25, 2025 pm 06:15 PM
The core idea of PHP combining AI for video content analysis is to let PHP serve as the backend "glue", first upload video to cloud storage, and then call AI services (such as Google CloudVideoAI, etc.) for asynchronous analysis; 2. PHP parses the JSON results, extract people, objects, scenes, voice and other information to generate intelligent tags and store them in the database; 3. The advantage is to use PHP's mature web ecosystem to quickly integrate AI capabilities, which is suitable for projects with existing PHP systems to efficiently implement; 4. Common challenges include large file processing (directly transmitted to cloud storage with pre-signed URLs), asynchronous tasks (introducing message queues), cost control (on-demand analysis, budget monitoring) and result optimization (label standardization); 5. Smart tags significantly improve visual
PHP integrated AI emotional computing technology PHP user feedback intelligent analysis
Jul 25, 2025 pm 06:54 PM
To integrate AI sentiment computing technology into PHP applications, the core is to use cloud services AIAPI (such as Google, AWS, and Azure) for sentiment analysis, send text through HTTP requests and parse returned JSON results, and store emotional data into the database, thereby realizing automated processing and data insights of user feedback. The specific steps include: 1. Select a suitable AI sentiment analysis API, considering accuracy, cost, language support and integration complexity; 2. Use Guzzle or curl to send requests, store sentiment scores, labels, and intensity information; 3. Build a visual dashboard to support priority sorting, trend analysis, product iteration direction and user segmentation; 4. Respond to technical challenges, such as API call restrictions and numbers
How to develop AI-based text summary with PHP Quick Refining Technology
Jul 25, 2025 pm 05:57 PM
The core of PHP's development of AI text summary is to call external AI service APIs (such as OpenAI, HuggingFace) as a coordinator to realize text preprocessing, API requests, response analysis and result display; 2. The limitation is that the computing performance is weak and the AI ecosystem is weak. The response strategy is to leverage APIs, service decoupling and asynchronous processing; 3. Model selection needs to weigh summary quality, cost, delay, concurrency, data privacy, and abstract models such as GPT or BART/T5 are recommended; 4. Performance optimization includes cache, asynchronous queues, batch processing and nearby area selection. Error processing needs to cover current limit retry, network timeout, key security, input verification and logging to ensure the stable and efficient operation of the system.
