Discover and read the best of Twitter Threads about #sqlalchemy
Most recents (2)
Today is a great day to talk about one of #Python's most popular SQL ORMs - #SQLAlchemy!
SQLAlchemy is an Object Relational Mapper for Python. That means that it can translate Python code to SQL.
🧵👇🐍
SQLAlchemy is an Object Relational Mapper for Python. That means that it can translate Python code to SQL.
🧵👇🐍
Let's take a look at creating a database with #Python and #SQLAlchemy
You need to create classes that model tables in your database.
Then to create the actual database, you use `Base.metadata.create_all()`
You need to create classes that model tables in your database.
Then to create the actual database, you use `Base.metadata.create_all()`
Now let's add some data to our database using #Python and #SQLAlchemy
The following code shows how to add data to both our tables. It also shows how to add multiple rows of data all at once! 🐍🔥
The following code shows how to add data to both our tables. It also shows how to add multiple rows of data all at once! 🐍🔥
Today is a great day to talk about one of #Python's most popular SQL ORMs - SQLAlchemy!
SQLAlchemy is an Object Relational Mapper for Python. That means that it can translate Python code to SQL.
🧵👇🐍
SQLAlchemy is an Object Relational Mapper for Python. That means that it can translate Python code to SQL.
🧵👇🐍
Let's take a look at creating a database with #Python and #SQLAlchemy
You need to create classes that model tables in your database.
Then to create the actual database, you use `Base.metadata.create_all()`
You need to create classes that model tables in your database.
Then to create the actual database, you use `Base.metadata.create_all()`
Now let's add some data to our database using #Python and #SQLAlchemy
The following code shows how to add data to both our tables. It also shows how to add multiple rows of data all at once! 🐍🔥
The following code shows how to add data to both our tables. It also shows how to add multiple rows of data all at once! 🐍🔥
