import random

if __name__ == "__main__":
    random.seed()
    # Create landlords
    landlords = []
    landlords.append([100000000, 'l1', 'p1', 'Bob Sapp', 1234567,'l1@gmail.com'])
    landlords.append([100000001, 'l2', 'p2', 'George Clooney', 1234567,'l2@gmail.com'])
    landlords.append([100000002, 'l3', 'p3', 'Patches O\'Houlihan', 1234567,'l3@gmail.com'])
    fp = open('landlord.csv', 'w')
    for l in landlords:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # Create apartments
    apts = []
    for i in range(0, 20):
        apt = [i,100000002,random.randint(1,3000),'address' + str(i),random.randint(1,10)]
        apts.append(apt);

    fp = open('apts.csv', 'w')
    for l in apts:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # Create tenants
    tenants = []
    for i in range(0, 70):
        tenant = [200000000+i,'email2'+str(i)+'@gmail.com','tenant'+str(i),random.randint(1000000,9999999),random.randint(0,20)]
        tenants.append(tenant)

    fp = open('tenants.csv', 'w')
    for l in tenants:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # Create contractors
    contractors = []
    for i in range(0, 8):
        contractors.append([300000000 + i, 'contractor' + str(i)])
    fp = open('contractors.csv', 'w')
    for l in contractors:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # Create utility companies
    utils = []
    for i in range(0, 5):
        utils.append([300000000 + i, 'utilco' + str(i)])
    fp = open('utilities.csv', 'w')
    for l in utils:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # Create bills
    bills = []
    for i in range(0, 10):
        bill = [i, 'This is bill #' + str(i), random.randint(0,1000), '', random.randint(0, 10000), 100000002, random.randint(0,8), '']
        bills.append(bill)
    for i in range(10, 15):
        bill = [i, 'This is bill #' + str(i), random.randint(0,1000), '', random.randint(0, 10000), 100000002, '',random.randint(0,5)]
        bills.append(bill)
    fp = open('bills.csv', 'w')
    for l in bills:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()


    # Create incidents
    incidents = [[0, 'Late rent'], [1, 'No water'], [2, 'No power']]
    fp = open('incidents.csv', 'w')
    for l in incidents:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # Create amenities
    amenities = [[0, 'Parking'], [1, 'Laundry machine'], [2,'Heating included']]
    fp = open('amenities.csv', 'w')
    for l in amenities:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    # m2m shit needs to correspond
    ai = [[12,0],[12,2],[4,1],[5,2]]
    fp = open('ai.csv', 'w')
    for l in ai:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()

    aa = [[15,0],[15,0],[17,1],[10,2],[11,0],[7,1]]
    fp = open('aa.csv', 'w')
    for l in aa:
        for i in range(0, len(l)):
            fp.write(str(l[i]))
            if i != len(l)-1:
                fp.write(',')
        fp.write('\n')
    fp.close()