python从数据库导入数据问题

Question

1.首先需要把这个SQL文件导入到SQLite数据库中

import sqlite3
import sys

if len(sys.argv) < 2:
    print("Error: You must supply at least SQL script.")
    print("Usage: %s table.db ./sql-dump.sql" % (sys.argv[0]))
    sys.exit(1)

script_path = sys.argv[1]

if len(sys.argv) == 3:
    db = sys.argv[2]
else:
    # if DB is not defined 
    # create memory database
    db = ":memory:"

try:
    con = sqlite3.connect(db)
    with con:
        cur = con.cursor()
        with open(script_path,'rb') as f:
            cur.executescript(f.read())
except sqlite3.Error as err:
    print("Error occured: %s" % err)

 

2.从数据库文件读取数据

 

 

import sqlite3
import sys

if len(sys.argv) != 2:

    print("Please specify database file.")
    sys.exit(1)

db = sys.argv[1]

try:
    con = sqlite3.connect(db)
    with con:
        cur = con.cursor()
        query = 'SELECT ID, Name, Population FROM City ORDER BY Population DESC LIMIT 1000'

        con.text_factory = str
        cur.execute(query)

        resultset = cur.fetchall()

        # extract column names

        col_names = [cn[0] for cn in cur.description] 
        print("%10s %30s %10s" % tuple(col_names))
        print("="*(10+1+30+1+10))

        for row in resultset:
            print("%10s %30s %10s" % row)
except sqlite3.Error as err:
    print("[ERROR]:", err)

在运行第一个代码程序的时候,总是提示以下错误:

 

Error: You must supply at least SQL script.
Usage: C:/Users/18902/PycharmProjects/python-data-visualization/02_Code/ch02-sqlite-import.py table.db ./sql-dump.sql

Process finished with exit code 1

有大佬指点一下是什么问题吗???项目里面已经有以下两个文件:

Answer 1

那么问题来了，你的数据库驱动呢？就是driver