# -*- coding: utf-8 -*-
"""
Created on Thu Apr  7 21:18:27 2016

@author: aniruddha
"""



from datetime import datetime, date, time
import glob
import numpy
import os
import datetime
import matplotlib.pyplot as plt
import matplotlib.dates as md
from pylab import *
import pickle
import pdb

import sqlite3 as lite
import sys
import re

f1 = open('street_names.pckl', 'rb')
Street_Names = pickle.load(f1)
f1.close()


Dbconnection = lite.connect('ParkData_new.db')     
streetData1=[]

#query="select * from ParkDataTable where StreetId='B422021' and Date='08-04'  order by Time asc"
#query="select * from ParkDataTable where StreetId='B442061' and Date='09-24'"
query="select * from ParkDataTable where StreetId='B442061' and Date between '09-24' and  '09-29'"
with Dbconnection :
     cur = Dbconnection.cursor()     
     for row in cur.execute(query):
         streetData1.append(row)
         
         
         
occ1=[a[3] for a in streetData1]
tavail1=[a[4] for a in streetData1]

fig=plt.figure(figsize=(19,2))
plt.plot(occ1, 'r', label='occ')
plt.plot(tavail1, 'b', label='total avail')
#plt.legend()
plt.show()