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
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.
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"
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.
Seriously, SQLAlchemy is a piece of shit. It just complicates the entire development process. Object orientating a relational data is a recipe of disaster.
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.
The session is well structured, clear and filled with subtle humor. Great content.
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
I was searching for pooling with sqlalchemy and landed here.
so much but not talk about pooling ?
Thanks for the time-stamp!
This should be pinned as the top comment. Thanks for putting this together. Great video content also.
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.
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.
Thanks awesome overview, helped me a lot.
Great Introduction. Thanks!
Didactically brilliant. Thanks!
The way he said "Oh" at the end, makes me feel Im missing out important info lel
But great presentation, thank you very much
47:13
Connect to already existing database :)
Thank you very much saved me some time
Nice video. Thanks!
Great introduction
very nice talk. thanks.
very good, very need, thks
nice presentation
amazing
Thank you very much cookieman 🍪
when i try to enter values into the table cookies
the table gives me the error no such table
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"
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 ?
+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.
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.