sql_request.py

import sqlite3

def send_sql_request(request, fetchall = 1):
    '''Execute sql request on bdd_for_labels database.
    If second parameter is 0 return one line of the response
    else return all lines.
    '''
    conn = sqlite3.connect('app/bdd_for_labels.db')
    c = conn.cursor()
    c.execute(request)
    conn.commit()
    if (fetchall == 1):
        res = c.fetchall()
    else:
        res = c.fetchone()
    return (res)