"""Explicit, optional fictional demo data. No business routes are hard-coded."""
from db import now

def seed(db):
    for idx,day in enumerate(['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday']):
        rid=db.execute('INSERT INTO routes(business_id,name,weekday) VALUES(1,?,?)',(day+' Demo Route',idx)).lastrowid
        aid=db.execute('INSERT INTO areas(business_id,name,city) VALUES(1,?,?)',('Demo Market '+chr(65+idx),'Demo City')).lastrowid
        db.execute('INSERT INTO route_stops(route_id,area_id,position) VALUES(?,?,1)',(rid,aid))
        db.execute('INSERT INTO customers(business_id,name,shop,phone,area_id,address) VALUES(1,?,?,?,?,?)',('Demo Retailer '+str(idx+1),'Sample Store '+str(idx+1),'91900000000'+str(idx),aid,'Example address, replace before use'))
    for name,sku,unit,price,aliases in [('Floor Cleaner','FC-01','box',500,'cleaner,floor cleaner,blue cleaner'),('Handwash','HW-01','pcs',90,'handwash,hand wash'),('Tissue','TS-01','carton',800,'tissue,tissues')]:
        db.execute('INSERT INTO products(business_id,name,sku,unit,price,aliases) VALUES(1,?,?,?,?,?)',(name,sku,unit,price,aliases))
    db.execute("INSERT INTO vehicles(business_id,name,registration) VALUES(1,'Demo Van','DEMO-001')")
    db.execute("INSERT INTO drivers(business_id,name,phone) VALUES(1,'Demo Driver','919000000099')")