Kamu bisa mendengarkan dan download lagu MP3 Build a To-Do List App in Python With SQLite: Command Line Project, Step by Step secara gratis di lagu123.biz. Jangan lupa untuk membeli kaset dan CD original serta menjadikan lagu ini sebagai ringtone kamu.
Data lagu:
Build a to-do list app in Python with SQLite and a command line, explained with everyday comparisons and run for real on Python 3.12 (standard library plus pytest). First the problem (a list in memory is wiped when the program ends), then a JSON file version, then why a database is better, then SQLite: a tasks table, parameterized queries (question-mark placeholders) with a real SQL injection attempt that is stored as harmless text, input checks, transactions with the with-conn block, and an argparse command line with add, list, done and delete commands (list hides done tasks, sorts dated tasks first). The run shows each command as a separate program start with the data surviving, and 18 passing pytest tests (in-memory database fixture, CLI tests through an injectable out function). Edit, search, priorities and multi-user use are left as next steps.
Chapters:
0:00 Hook
1:04 The plan
1:21 Memory is not enough
1:59 A file or a database
3:27 The table
4:37 Adding safely
6:38 Listing and ticking
8:13 Commands
11:43 Run it
13:09 Tests
14:56 Make it yours
15:39 Quiz
16:12 Recap
What you will learn:
- Why memory is not enough and where to keep data
- JSON file versus SQLite database
- How to create a table and run INSERT, SELECT, UPDATE and DELETE
- How placeholders stop SQL injection
- How a transaction saves all or nothing
- How argparse builds commands with sub-commands and checks
- How to test a database and a command line with pytest
- Ideas to extend the app: edit, search, p