def __init__(self):
self.name = "billboard"
self.datasets = [
DataSet("hot100",
"https://billboard.com/charts/the-billboard-hot-100",
datetime.date(1958, 8, 4))
]
self.cookie_header = os.getenv("BILLBOARD_COOKIE_HEADER")
def addData(filename):
total = 0
f = open('./data/' + filename, "r")
if f.mode == 'r':
reader = csv.DictReader(f, dialect='excel-tab')
for row in reader:
revenuePerItem = float(row['Item_price']) * float(
row['Item_count'])
total = total + revenuePerItem
db.session.add(
DataInfo(filename, row['Item'], row['Item_description'],
row['Item_price'], row['Item_count'], row['Vendor'],
row['Vendor_address']))
db.session.add(DataSet(filename, total))
db.session.commit()
