No video
SQLAlchemy ORM for Beginners
Jason Myers
www.pyvideo.org...
pygotham.org/2...
We'll explore how to get started with SQLAlchemy ORM. We'll learn how to build data models, connect to databases, how the session works, and perform CRUD operations.
Пікірлер: 32
0:42 Core Schema centric, ORM - User Model 1:00 Installing 1:20 Connecting and establishing a session 1:40 Connecting 2:32 Establishing a session 3:54 Defining models 4:15 Model base - declarative base 5:21 Cookie model 7:36 Persisting our table 8:27 Inserting data 9:16 Adding to session 13:54 Accessing attributes 14:15 Bulk inserts 15:30 Bulk insert differences 17:20 Queries 19:30 Particular attributes 20:28 Order by 20:51 Descending 21:25 Limiting 23:34 Database functions (scalar) 25:23 Count 26:54 Labeling 28:28 Filter by 29:21 Filter 30:50 Clause elements 31:30 Clause element methods 31:55 Operators 33:45 Conjunctions 35:24 Updating 36:40 Deleting 38:40 Relationships 38:50 Imports 39:07 User Model 39:18 Order Model 40:46 Lineitem Model 41:30 Persist them 42:57 Defining a User 43:03 Setting up an order 43:32 Preparing Line items 44:10 Associate order and line items 45:05 Using relationships in queries 46:35 Another example 47:23 Automap, Geospatial Queries
@default_youtube_profile
4 жыл бұрын
I was searching for pooling with sqlalchemy and landed here. so much but not talk about pooling ?
@poulameepal8065
3 жыл бұрын
Thanks for the time-stamp!
@ShwetabhKumar
3 жыл бұрын
This should be pinned as the top comment. Thanks for putting this together. Great video content also.
The session is well structured, clear and filled with subtle humor. Great content.
Nice overview of SQLAlchemy. I almost turned this off after you said you'd be mainly talking about cookies in the intro because I thought you meant web cookies.
@workflowinmind
7 жыл бұрын
Ahaha same ! Quite disturbing :)
First time I see tree tables (User, Order, LineItem) joined with Foreign Keys, useful demo!
Great video! Love the coffee mug.
The way he said "Oh" at the end, makes me feel Im missing out important info lel But great presentation, thank you very much
Thanks awesome overview, helped me a lot.
Great Introduction. Thanks!
Didactically brilliant. Thanks!
47:13 Connect to already existing database :)
@engineerhealthyself
6 жыл бұрын
Thank you very much saved me some time
Nice video. Thanks!
when i try to enter values into the table cookies the table gives me the error no such table
Great introduction
very nice talk. thanks.
I have followed this video and get the error below. Can anyone else confirm the code from the video works? Doesn't seem to... cc = session.query(Cookie).filter(Cookie.cookie_name == "chocolate chip").one() line1 = LineItem(cookie=cc, quantity=2, extended_cost=1.00) o1.line_items.append(line1) I get: "TypeError: 'cookie' is an invalid keyword argument for LineItem"
very good, very need, thks
nice presentation
amazing
Thank you very much cookieman 🍪
This guy looks like someone I used to work with in 1996
you mentions that is possible to dump pandas dataframe to sqlalchemy by using some odo ?? (i don't get) can you explain how to do it ?
@paulvbarbar9957
8 жыл бұрын
+Volodymyr Nepyuk odo.pydata.org/en/latest/ may be .
Glad he mentioned automap, but I he should have just used it in the demo. creating classes is SO boring and basic, its not worth dedicating time to, especially in a presentation.
блин, почему я не знаю английский?!
feels just like mongoose..,
Seriously, SQLAlchemy is a piece of shit. It just complicates the entire development process. Object orientating a relational data is a recipe of disaster.
@Colstonewall
7 жыл бұрын
Ridiculous. It works great and people love it. Not to mention, although Django doesn't use SQLAlchemy, they use OOP in their database setup, and it's beautiful.