# -*- coding: utf-8 -*-
"""
Created on Thu Apr  7 11:25:21 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.db')

#query="select * from ParkDataTable where StreetId='B440152' order by Time asc"

query="select * from ParkDataTable where StreetId='B563051'"


streetData=[]

with Dbconnection :
     cur = Dbconnection.cursor()     
     for row in cur.execute(query):
         streetData.append(row)
    

occ=[a[2] for a in streetData]
tavail=[a[3] for a in streetData]

bar=[]
barheight=max(tavail)+1

for a in streetData :
    dt,tm=a[1].split('T')
    if tm == '00:01' or tm== '00:00' :
        bar.append(barheight)
        
    else :
        bar.append(0)
    




for i in range(8):

        fig=plt.figure(figsize=(19,2))
        plt.plot(occ[i*10000:(i+1)*10000-1], 'r', label='occ')
        plt.plot(tavail[i*10000:(i+1)*10000-1], 'b', label='total avail')
        plt.plot(bar[i*10000:(i+1)*10000-1], 'k' )
        #plt.legend()
        #plt.savefig('../Parking_v2/figs/B606011_{0}.eps'.format(i+1), format='eps')
        plt.show()