【Python 串連SQLite資料庫檔案】

標籤：擷取資料   factory   dict   isolation   mon   common   imm   hone   _id   

涉及：

• Python串連db檔案
• 如何按照列名擷取資料
• 如何傳入參數

範例程式碼如下：

# encoding=utf-8import sqlite3def get_signal_names(db_file_path):    names = list()    with sqlite3.connect(db_file_path, isolation_level="IMMEDIATE", timeout=60, check_same_thread=False) as con:        # 設定可以使用名稱來擷取查詢後的資料        con.row_factory = sqlite3.Row        cur = con.cursor()        sql = "select distinct(Name) from Channels order by Name asc"        cur.execute(sql)        results = cur.fetchall()        for row in results:            names.append(row["Name"])        return namesdef get_channel_record(db_file_path, signal_name):    channel = dict()    with sqlite3.connect(db_file_path, isolation_level="IMMEDIATE", timeout=60, check_same_thread=False) as con:        con.row_factory = sqlite3.Row        cur = con.cursor()        sql = "select MessageId, MessageChannel, SignalType from test_tb where Name = ?"        # 注意(signal_name,)元群組類型後的逗號        cur.execute(sql, (signal_name,))        re = cur.fetchone()        channel["message_id"] = re["MessageId"]        channel["signal_type"] = re["SignalType"]        channel["message_channel"] = re["MessageChannel"]    return channel

更多請關注公眾號

【Python 串連SQLite資料庫檔案】