querysqlite.py

# -----------------------------------------------------
# Query sqlite using sqlalchemy
# dependencies: Pandas & sqlalchemy
#
# -----------------------------------------------------
# {Modification Log}
# -----------------------------------------------------
# Author: Senthilnathan
# Maintainer: {maintainer}
# Created At: 12/14/2019
# Last Modified: 12/14/2019
# Status: production
# -----------------------------------------------------
import pandas as pd
from sqlalchemy import create_engine
import datetime as dt
# variables (Start)
dbname='meetup'
tname='members'
encoding='ISO-8859-1'
start = dt.datetime.now()
# variables (End)
try:
    csv_database = create_engine('sqlite:///{}.db'.format(dbname))
    df = pd.read_sql_query('select * from {} ORDER BY random() limit 5'.format(tname), csv_database)
    print(df)
except Exception as e:
      print('Exception while querying {} - [{}]'.format(dbname,str(e)))