billingkey = os.environ.get('%sBill_Key' % account)

billingsecret = os.environ.get('%sBill_Secret' % account)

myRegion = get_region('us-east-1') #create cloudwatch for billing alert first. the default area is us-east-1

conn = boto.ec2.cloudwatch.connect_to_region('us-east-1',aws_access_key_id=billingkey,aws_secret_access_key=billingsecret)

Metrics=conn.list_metrics(metric_name=u'EstimatedCharges',namespace=u'AWS/Billing')

#Last = datetime.datetime(2015,3,26)

#Start = datetime.datetime(2015,3,20)

Last = datetime.date.today()

#Last = datetime.date.today()+timedelta(days=-5)

during = timedelta(days=-1)

Start = Last + during

file="%s_total.out" % account

f=open(file,'w')

for metric in Metrics:

if [id] in metric.dimensions.values() and u'ServiceName' not in metric.dimensions :

#print Start,metric.query(Start,Last,'Average',period=86400)

f.write(str(Start)+'\t'+str(metric.query(Start,Last,'Average',period=86400))+'\n')

f.close()

cost_cmd="echo `cat %s |awk -F':' '{print $3}'|awk -F'.' '{print $1}'`" % file

date_cmd="echo `awk '{print $1}' %s`" % file

cost=int(os.popen(cost_cmd).read().strip('\n'))

date=str(os.popen(date_cmd).read().strip('\n'))

conn = MySQLdb.connect(user='root', db='instance', passwd='', host='localhost')

cursor = conn.cursor()

sql="insert into billing_info_%s(date,total_all) values('%s',%s)" % (account,date,cost)

cursor.execute(sql)

conn.commit()

cursor.close()