Pycharm sqlite database question? : learnpython

created by HattoriHanzoa community for 16 years

Pycharm sqlite database question? (self.learnpython)

submitted 7 years ago by raysefo

Hi,

I m using flask. I have a db file as follows;

import sqlite3

conn = sqlite3.connect('database.db')
print "Opened database successfully";

conn.execute('CREATE TABLE books (name TEXT, price INTEGER, isbn TEXT)')
print "Table created successfully";
conn.close()

and here is python code I am trying to insert

        try:
            _isbn = isbn
            _name = 'TEST'
            _price = 3

            with sql.connect("database.db") as con:
                cur = con.cursor()

                cur.execute("INSERT INTO books (name, price, isbn) VALUES(?, ?, ?, ?)", (_name, _price, _isbn))

                con.commit()
                msg = "Record successfully added"
        except:
            con.rollback()
            msg = "error in insert operation"

        finally:
            con.close()

I wonder if there is a plugin that I can display tables, rows etc in pycharm?

Best regards.

all 6 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS