"""Load users from u.users into database."""

# print "Users"

# Delete all rows in table to avoid adding duplicates

User.query.delete()

# Read u.user file and insert data

for row in open("data/u.users"):

row = row.rstrip()

user_id, fname, lname, email, password = row.split("|")

user = User(user_id=user_id,

fname=fname,

lname=lname,

email=email,

password=password)

# user = [user_id, fname, lname, email, password]

print user

# Add the user to the database

db.session.add(user)

# Commit all additons to database

"""Load landlords from u.landlords into database."""

# Delete all rows in table to avoid adding duplicates

Landlord.query.delete()

for row in open("data/u.landlords"):

row = row.rstrip()

landlord_id, fname, lname = row.split("|")

landlord = Landlord(landlord_id=landlord_id,

fname=fname,

lname=lname)

# Add the landlord to the database

db.session.add(landlord)

# Commit all additions to database

"""Load buildings from u.buildings into database."""

# Delete all rows in table to avoid adding duplicates

Building.query.delete()

for row in open("data/u.buildings"):

row = row.rstrip()

building_id, name = row.split("|")

building = Building(building_id=building_id,

name=name)

# Add the building to the database

db.session.add(building)

# Commit all additions to database

"""Load addresses from u.addresses into database."""

# Delete all rows in table to avoid adding duplicates

Address.query.delete()

for row in open("data/u.addresses"):

row = row.rstrip()

address_id, street, city, state, zipcode, country, unit, lat, lng, building_id = row.split("|")

address = Address(address_id=address_id,

street=street,

city=city,

state=state,

zipcode=zipcode,

country=country,

unit=unit,

lat=lat,

lng=lng,

building_id=building_id)

# Add the address to the database

db.session.add(address)

# Commit all additions to database