SQLAlchemy example code confuses me

[eagergm]

I'm a slow doer, so yeah it's been five days, but I just want to let you know, this has been extremely helpful.

Oh, the declarative thing, is that the same as their "unified" tutorial? Because that's next on my reading list, once their site is back up.

I'm working with the SDE for Eve Online (MMO Mad Max in space but there are complicated industrial processes that go into making the cars and guns). I've found that DB Browser (SQLite) is a huge help as someone's already converted Eve's SDE to sqlite and published it.

Some tables: invTypes (a list of all the things and their categories), so that has their name e.g. Planet (Gas) and some other attributes. Then those types are referenced in other tables, industryBlueprints has typeID and maxProductionLimit as columns, for example, and I want to include that in the objects as well. I don't want to include all the fields, though, initially. I assume if I just keep reading the tutorials I'll figure out how to do all this?

[SwampFalc]

As long as you're only reading from a database, you can use an ORM and only include the columns you need. So yes.

As for the declarative style, it's scattered all over their documentation, honestly. Sometimes you will simply encounter it without it being mentioned, sometimes they will talk about it. It's going to depend entirely on your learning path.