SQLAlchemy Core allows you to interact with relational databases using statements written in pure Python. This allows you to form queries and use your database without that much knowledge of SQL.
This video will give you a guide on how to connect to an SQL database as well as to Create, Read, Update, and Delete records from your database.
#python #sqlalchemy #sql
SOURCE CODE:
github.com/jod35/SQLAlchemy-2...
DB BROWSER FOR SQLITE:
sqlitebrowser.org/
PLEASE BUY ME A COFFEE:
www.buymeacoffee.com/jod35
GITHUB:
github.com/jod35
TWITTER:
/ jod35_
CHAPTERS:
(0:00) Introduction
(1:27) Setting up the environment
(4:24) Connecting to the database
(7:38) Testing database connection
(11:21) Define database tables
(16:40) The metadata object
(24:31) Create tables in the database
(30:31) Insert statements
(39:29) select statements
(44:46) select-where
(48:19) Update statements
(52:40) delete statements
(54:36) Conclusion
26 июн 2024