Comment utiliser SQLite en Python

#codeing:UTF-8

import sqlite3
import pandas as pd

#Sinon, un nouveau sera créé
con = sqlite3.connect('/Users/Desktop/web_data.db')
drop_table = "drop table gas_portal_access_log"

create_table = """
create table gas_portal_access_log (
  user text,
  pv integer,
  page_id text
  );
"""
insert_table = """
insert into gas_portal_access_log values('yamada taro',3 ,'1234');
"""
insert2_table = """
insert into gas_portal_access_log values('hoge',2 ,'1234');
"""

con.execute(drop_table)
con.execute(create_table)
con.execute(insert_table)
con.execute(insert2_table)

#N'oubliez pas de vous engager
con.commit()

check_sql = """
select * from gas_portal_access_log
"""
df = pd.read_sql(check_sql,con)
con.close

print df

Recommended Posts