Python database示例

示例#1

#!/usr/bin/env python3

import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.ticker as ticker
import matplotlib.dates as mpl_dates
import seaborn as sns
import database_driver

# Handle date time conversions between pandas and matplotlib
from pandas.plotting import register_matplotlib_converters
register_matplotlib_converters()

dbname = 'sensorsData.db'
db = database_driver.database(dbname)

sns.set()

con = db.create_connection()
dfFloor = pd.read_sql_query(
    'SELECT timestamp, temperature, humidity FROM DHT_data WHERE sensor=1 ORDER BY timestamp',
    con,
    parse_dates=['timestamp'],
    index_col=['timestamp'])
dfDesk = pd.read_sql_query(
    'SELECT timestamp, temperature, humidity FROM DHT_data WHERE sensor=2 ORDER BY timestamp',
    con,
    parse_dates=['timestamp'],
    index_col=['timestamp'])
con.close()

示例#2

文件： process_adjustments.py 项目： CodeTheCity/historical_harbour_arrivals_api

 def __init__(self):
     self.db = database_driver.database(dbname)