How to display the table in sqlite3 by creating the table via Python

Question

I just used the Pycharm and the package Sqlite3 to generate a table in sqlite3. Meanwhile, I am using SqliteStudio to visualize the relationship between databases and tables. However, the table created from Pycharm cannot be seen in SqliteStudio. Any idea how can I achieve it?

here is the code:

import sqlite3


def conSqlite():
  conn = sqlite3.connect('C:\\Users\jet.cai\Documents\Logsitic.db')

  conn.execute('''CREATE TABLE CNAME
  (ID INT PRIMARY KEY  NOT NULL,
  NAME            TEXT NOT NULL,
  AGE             TEXT NOT NULL)''')

  print('Done')

  cursor = conn.execute("select id from cname")
  for row in cursor:
      print('ID = ', row[0], 'NAME = ', row[1], 'AGE = ', row[2] )


  conSqlite()

You can use another app to see what is in your database (I personnally use Spatialite) — tgrandje
– tgrandje, Commented Oct 14, 2020 at 14:16

tgrandje · Accepted Answer · 2020-10-14 14:18:04Z

3

If you want to stay with python, you may find interesting to use pandas.

import pandas as pd
import sqlite3
con = sqlite3.connect('C:\\Users\jet.cai\Documents\Logsitic.db')
df = pd.read_sql_query("select id from cname", con)
print(df)

answered Oct 14, 2020 at 14:18

tgrandje

2,5623 gold badges20 silver badges39 bronze badges

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

5 Comments

晓天蔡 Over a year ago

Oh yes, also forgot this package, pandas will do me the favor when checking the data in Python of course, Thanks!

tgrandje Over a year ago

You're welcome. Please mark this answer as accepted if this has resolved your problem ;-)

晓天蔡 Over a year ago

let me check the Spatialite first, I wanna a GUI way to demonstrate what has been created, SQLite is obviously out of the way. Thanks again.

tgrandje Over a year ago

Sure, I use Spatialite for that same purpose (particularly when when I'm not sure what occured in my database...) !

晓天蔡 Over a year ago

Hola, sir, yes you are absolutely right, spatialite is finely able to do me the favor! Thanks again.

Collectives™ on Stack Overflow

How to display the table in sqlite3 by creating the table via Python

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related