Instead, print prints to the command line. When you use print in the Flask app, it doesn’t print to the web page. nothing changed? But pop on over to your command line, and you’ll see a secret little line hiding in the debug output:ġ27.0.0.1 - "GET / HTTP/1.1" 200. Let’s edit the /about route to make it print something out: "/")
#Flask sqlite how to
We don’t know how to make our database talk to the web page yet, so we’re going to cheat a little bit. Give your page a refresh to make sure you don’t have any typos or other little issues, and then we’ll charge ahead to actually using this model. LOC_CODE = db.Column(db.Text, primary_key = True) It’ll look like this: app = Flask( _name_)Īpp.config = 'sqlite:///schools.sqlite3'
#Flask sqlite code
Going back to our code - right after we make our Flask app with app = Flask(_name_), you’ll want to tell SQLAlchemy everything important about the database and its tables. (Although we only have one table in this case, so we’ll only have one model) Every table gets a model, and we use that model to play around with its associated table from Python. Now the real work begins! We need to define our Model, which is the Python version of our SQL table. The world - sadly, predictably - just doesn’t listen.
Ruby is a lot like Python, but ActiveRecord is not like SQLAlchemy: ActiveRecord is a beautiful angel sent from heaven to cure the world of all ills. ** Ever since I was a little baby I was programming in a language called Ruby and using an ORM called ActiveRecord. SQLAlchemy is… an acquired taste, but it’s very popular, and because it’s so popular I am absolutely certain that my distaste for SQLAlchemy is because I’m too stupid to understand it**, so we’re going to use it for this example. Peewee is one that’s pretty simple to get running with, but it isn’t as popular as SQLAlchemy. There are a handful of ORMs that work for Python, and plenty that work with Flask. ORM means Object-relational mapping, which doesn’t mean anything to anyone and no one will ever ask you about that So the Gods invented ORMs, which basically mean “instead of writing SQL you’ll just write Python and the ORM will talk to the database for you.” Then everyone else was invented, and they didn’t like writing SQL, they just liked writing Python. Once upon a time there were databases, and there was SQL, and there were people who loved writing SQL. That’s a fate worse than ten or twenty unimaginable terrors. Return dict((scription, value)ĭear Reader, my Sweet Friend, that’s horrible. Oof, eef, aaf, this “simple example” it hurts parts of my body I didn’t even know I had.Īnd then under the header “Easy Querying” it shows you this real baller piece of work: def make_dicts(cursor, row): Brace yourself and take a look at this awesome “simple example of how you can use SQLite 3 with Flask” DATABASE = '/path/to/database.db' def get_db():ĭb = g._database = sqlite3. If you’ve used things like sqlite3 or pg8000 to talk to databases before, you know it can really be a pain to wrangle your data.
0 kommentar(er)
