Initialise DB in Flask

Question

I have read the Flask documentation and Python documentation to try to understand what these codes do. I know that it is initialise the Database but would like to know in very detail and with normal language, easy language for beginner.

Can anyone please explain me about this?

import sqlite3
from contextlib import closing

DATABASE = 'flaskr.db'

def connect_db():
    return sqlite3.connect(app.config[’DATABASE’])


def init_db():
    with closing(connect_db()) as db:
        with app.open_resource(’schema.sql’, mode=’r’) as f:
            db.cursor().executescript(f.read())
        db.commit()

Ashok Kumar Sahoo · Accepted Answer · 2013-11-18 10:12:20Z

1

import sqlite3

Imports Data base connectors

from contextlib import closing

No idea why its used. Documentetion here

DATABASE = 'flaskr.db'

Defines database,in this case it is a db file.

def connect_db():
    return sqlite3.connect(app.config[’DATABASE’])

Connect DB method which returns a sqlite3 connection, using sqlite3 import and invoking connect() on it. Hint: try >>> dir(sqlite3) after importing in your python console

def init_db():
  with closing(connect_db()) as db:
    with app.open_resource(’schema.sql’, mode=’r’) as f:
        db.cursor().executescript(f.read())
    db.commit()

Initialize database method, it takes a schema.sql and executes it on DB by f.read method. After executing you need to commit changes to db, hence db.commit()

You can find it explained clearly here

edited Nov 18, 2013 at 10:12

answered Nov 18, 2013 at 9:57

Ashok Kumar Sahoo

5903 gold badges8 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sean Vieira Over a year ago

contextlib.closing is used so that init_db can use it rather than the more verbose try: db = connect_db() try: f = app.open_resource(...) # snip finally: f.close() finally: db.close()

Collectives™ on Stack Overflow

Initialise DB in Flask

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related