Python for Entrepreneurs Transcripts
Chapter: Accessing databases from Python: SQLAlchemy ORM
Lecture: Demo: Web form for creating albums and tracks

Login or purchase this course to watch this video and the rest of the course contents.
0:01 It's time to actually insert some data into our web application. Now, you can see I've added right here an admin_controller,
0:07 it has this standard GET / POST / Redirect pattern for editing data. And we've done this before. We did this in the advanced web section.
0:15 Part two of web development. Remember, we just changed stuff in memory We just printed out something, we didn't actually put something in the database,
0:22 because we didn't have SQLAlchemy or any data access technology that we had talked about. But we're going to follow the same pattern
0:29 GET - it's gonna show the form, POST is going handle it and you can see I've got a "todo" down here and we're going to insert some data,
0:36 We'll insert an album and a bunch of tracks that go with it and we're gonna log the fact tht that was done and just a printout,
0:42 Not really logging, we'll get to that later. And we can look at this Alright, a really simple form here, I've done a little bit of work
0:50 to make it look prettier, so for example I've added some Bootstrap here, some Bootstrap stuff over here, so it's gonna look a little bit nicer
0:59 but we basically have the things you need to create an album. We've got title here, price, album image and URL and
1:05 then, we're not gonna go all-in and create a huge backend for managing albums and tracks and reordering them and so on.
1:13 What we're gonna do is we're just gonna take a bunch of track titles, and we're gonna use that to sort of build a some kind of data relationship
1:21 and in the real life, you could of course use this technique to go on and extend what we're doing to let you manage and reorder tracks
1:27 or whatever your equivalent of nested related items are. OK, so we're gonna take this, we also have down here
1:37 a newalbumviewmodel, but that just basically will transfer that stuff to and from the form and then also has this cool property that I added to it
1:47 that given "new line separated", so one per line, text that represents the track titles, it will turn that into
1:55 a tightened-up list of track titles and we're going to use that to create the tracks, like I said in the real one, we'd wanna have
2:03 the length of the track, then various things, maybe audio link to an mp3 that would let us preview it and so on, but this is just gonna be a
2:11 a simple little trick for us to get started

Talk Python's Mastodon Michael Kennedy's Mastodon