sqlit3，数据库读取

sqlit3 emmm，轻量级，读取数据库是方便，但是写入就比较麻烦了。

-没事用来练习还是比较好用。

import sqlite3
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import os
import re
import warnings

warnings.filterwarnings('ignore')

'''
(1)顺序查询获取
'''
con = sqlite3.connect(r'D:\sqlite3\douya_info.db',timeout=5.0)
#python 连接sqlite数据库

cur = con.cursor()
#创建游标

sql = """
select id,
    time,
    messageid
from msgrecord_isrv67
"""
#编辑SQL查询语句

cur.execute(sql)
#执行sqlite的sql查询

con.commit()
result = cur.fetchall()
#提取查询结果，赋值给result

print('查询语句的数据行数：%i ' %len(result))
pd.DataFrame(result,columns=['id','time','messageid']).head()

'''
(2)函数式获取
'''
def load_sqlite(path,sql):
    conect = sqlite3.connect(path,timeout=5)
    #连接
    cur = conect.cursor()
    #游标
    cur.execute(sql)
    #执行sql查询
    res = cur.fetchall()
    #获取查询结果
    conect.commit()
    #print(res[1])
    return pd.DataFrame(res)

#调用函数
path = r'D:\sqlite3\douya_info.db'
sql = """
select id,
    time,
    messageid
from msgrecord_isrv67
"""

data = load_sqlite(path,sql)
data.columns=['id','time','messageid']
data.head()