How to insert values in .db file using flask? [duplicate]

Question

I have folder which contains app.py and books.db file now I want to insert values to that db file using flask.

I am able to read it properly but unable to insert values into it.

Any idea how to achieve this ?

@app.route('/insert',methods=['GET','POST'])
def addv():
    conn = sqlite3.connect('books.db')
    conn.row_factory = dict_factory
    cur = conn.cursor()
    cur.execute('insert into books values (NULL,2014,\'Vivank\',\'try\',\'trying\')')
    return "inserted"

This is not inserting values in books.db ?

Or any way around to insert data into it ?

What do you mean, achieve this (and then show something that looks like a solution)? What's wrong with it (besides hardcoding strings in SQL)? — Amadan
– Amadan, Commented Feb 8, 2019 at 5:17
I am unable to insert data in books.db file using python @Amadan — Mansi Shukla
– Mansi Shukla, Commented Feb 8, 2019 at 5:34
I mean, what happens when you run the code you posted? Is there an error? Which one? Do you get "inserted" returned or not? Do your curtains burst into flames? — Amadan
– Amadan, Commented Feb 8, 2019 at 5:39
Try conn.commit()? If the row is updated without an error but not saved, that's probably the only thing missing. — Amadan
– Amadan, Commented Feb 8, 2019 at 5:40
using flask-sqlalchemy is better idea than doing direct insertion — sahasrara62
– sahasrara62, Commented Feb 8, 2019 at 5:44

kellymandem · Accepted Answer · 2019-02-08 05:41:57Z

3

You could change your code to something like:

@app.route('/insert', methods=['GET','POST'])
def addv():
    if request.method == "POST";
        conn = sqlite3.connect('books.db')
        data = [None, 2014, 'Vivank', 'try', 'trying']
        conn.execute('insert into books values (?, ?, ?, ?, ?)', (*data,))
        conn.commit()
        return "inserted"
    return "Testing insert"

answered Feb 8, 2019 at 5:41

kellymandem

1,7693 gold badges18 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

How to insert values in .db file using flask? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related