پیشنهاد فرادرس

آموزش استفاده از پایگاه داده در پایتون

دسته بندی ها: پایگاه داده ، آموزش های TreeHouse ، آموزش پایتون (Python) ، آموزش SQLite

زمانیکه می خواهید داده را از برنامه ذخیره کنید، 2 انتخاب کلی خواهید داشت: فایل ها و پایگاه داده ها. در این دوره با استفاده از پایگاه داده از داخل Python با ORM Peewee آشنا می شوید. در این دوره ما یک اپلیکیشن خاطره  خط فرمان را خواهیم ساخت که افکار و یادداشت های ما در یک پایگاه داده SQLite ذخیره می کند، به ما اجازه می دهد آنها را بررسی و حذف کنیم، و حتی یک ویژگی جستجو داشته باشیم!

سرفصل:

  • ORM
  • مدل سازی
  • ایجاد جدول ها و پایگاه داده ها
  • انجام Data Entry
  • افزودن Entry
  • ایجاد تابع
  • View and Search Entries
  • حذف Entry
  • حذف تابع
  • استفاده از پایگاه داده در پایتون
آیا این نوشته را دوست داشتید؟
Using Databases in Python Course Publisher:TeamTreeHouse Author:Kenneth Love Level:Intermediate

When you want to store data from a program, you have two general choices: files or databases. In this course, we're going to explore using a database from within Python by using the excellent ORM Peewee. We'll build a command line diary application that stores our thoughts and notes in a SQLite database, lets us review and delete them, and even has a search feature!
About this Course
When you want to store data from a program, you have two general choices: files or databases. In this course, we're going to explore using a database from within Python by using the excellent ORM Peewee. We'll build a command line diary application that stores our thoughts and notes in a SQLite database, lets us review and delete them, and even has a search feature!
What you'll learn
ORMs
Peewee
OrderedDictMeet Peewee
One way of interacting with a database from Python is to use the Peewee ORM. An ORM, or Object Relational Mapping, turns database tables into Python objects and vice versa. Let's see how to create tables and manipulate data in them.
7 steps
Meet Peewee, Our ORM
1:46
ORM
5 questions
Modeling
6:45
Create Table
4 objectives
Creating Databases and Tables
2 questions
Queries Are Your Friend
9:28
First Queries
4 objectives
Our Diary App
Now that we understand Peewee, let's build the app that we're here to build. We want an application we can run from the command line that we can read, write, and delete entries through.
6 steps
What We're Going To Do
3:27
Short Review
4 questions
Doing Data Entry
5:10
Initialize Database & Create Tables
3 objectives
Switching It Up
7:01
OrderedDict Practice
2 objectives
Gettin' CRUD-y With It
It's time to build the real core of our application. Let's capture entries and save them, show them, search them, and delete them!
8 steps
Add An Entry
4:04
CRUD: Create Function
1 objective
View and Search Entries
9:11
CRUD: Search Function
1 objective
Delete An Entry
4:43
CRUD: Delete Function
1 objective
Clean Up
4:50
Review: Using Databases in Python
8 questions
Extra Credit
Use textwrap and Blessings to make your application more professional and interesting.

پیشنهاد فرادرس

لینک های دانلود حجم فایل: 119.0MB TeamTreeHouse Using Databases in Python Course_git.ir.rar
da در 1397/12/23 ساعت 19:04

cool