def populateBars():
connection = mdb.connect('localhost', 'user', 'pass', 'barlytics')
current = connection.cursor()
f = open('bars.txt', 'r')
for line in f:
print line
name = line.strip()
print line
license = str(randint(1000000, 9000000))
city = str(address.city())
phone = str(phone_number.phone_number_format(0))
addr = str(randint(1, 255)) + " " + address.street_name()
query = 'insert into bars values("' + name + '", "' + license + '", "' + city + '", "' + phone + '", "' + addr + '"); '
print query
try:
current.execute(query)
except mdb.IntegrityError:
print "integrity error:"
print 'commit'
connection.commit()
def populateBars():
connection = mdb.connect('localhost', 'user', 'pass', 'barlytics')
current = connection.cursor()
nounsList = []
adjectiveList = []
cityList = ['San Francisco', 'Chicago', 'New York', 'Austin', 'Seattle']
print "here"
count = 0
for synset in list(wn.all_synsets('n')):
nounsList.append(str(synset.name).split('.')[0])
count = count + 1
if count >= 50000:
break
count= 0
print "here"
for synset in list(wn.all_synsets('a')):
adjectiveList.append(str(synset.name).split('.')[0])
count = count + 1
if count >= 50000:
break
print "here"
finalList = []
for i in range(10000):
string = ''
string = "The " + adjectiveList[randint(0, len(adjectiveList) - 1)].capitalize()
string = string + " " + nounsList[randint(0, len(nounsList) - 1)].capitalize()
finalList.append(string)
name = string
license = str(randint(1000000, 9000000))
city = str(address.city())
phone = str(phone_number.phone_number_format(0))
addr = str(randint(1, 255)) + " " + address.street_name()
query = 'insert into bars values("' + name + '", "' + license + '", "' + city + '", "' + phone + '", "' + addr + '"); '
print query
try:
current.execute(query)
except mdb.IntegrityError:
print "integrity error:"
print 'commit'
connection.commit()
def create_card():
return {
"name":
name.find_name(),
"username":
internet.user_name(),
"email":
internet.email(),
"address": {
"streetA": address.street_name(),
"streetB": address.street_address(),
"streetC": address.street_address(True),
"streetD": address.secondary_address(),
"city": address.city(),
"ukCounty": address.uk_county(),
"ukCountry": address.uk_country(),
"zipcode": address.zip_code()
},
"phone":
phone_number.phone_number(),
"website":
internet.domain_name(),
"company": {
"name": company.company_name(),
"catchPhrase": company.catch_phrase(),
"bs": company.bs()
},
"posts": [{
"words": lorem.words(),
"sentence": lorem.sentence(),
"sentences": lorem.sentences(),
"paragraph": lorem.paragraph()
}, {
"words": lorem.words(),
"sentence": lorem.sentence(),
"sentences": lorem.sentences(),
"paragraph": lorem.paragraph()
}, {
"words": lorem.words(),
"sentence": lorem.sentence(),
"sentences": lorem.sentences(),
"paragraph": lorem.paragraph()
}]
}
def user_card():
return {
"name": name.find_name(),
"username": internet.user_name(),
"email": internet.email(),
"address": {
"street": address.street_name(),
"suite": address.secondary_address(),
"city": address.city(),
"zipcode": address.zip_code()
},
"phone": phone_number.phone_number(),
"website": internet.domain_name(),
"company": {
"name": company.company_name(),
"catchPhrase": company.catch_phrase(),
"bs": company.bs()
}
}
def create_card():
return {
"name": name.find_name(),
"username": internet.user_name(),
"email": internet.email(),
"address": {
"streetA": address.street_name(),
"streetB": address.street_address(),
"streetC": address.street_address(True),
"streetD": address.secondary_address(),
"city": address.city(),
"ukCounty": address.uk_county(),
"ukCountry": address.uk_country(),
"zipcode": address.zip_code()
},
"phone": phone_number.phone_number(),
"website": internet.domain_name(),
"company": {
"name": company.company_name(),
"catchPhrase": company.catch_phrase(),
"bs": company.bs()
},
"posts": [
{
"words": lorem.words(),
"sentence": lorem.sentence(),
"sentences": lorem.sentences(),
"paragraph": lorem.paragraph()
},
{
"words": lorem.words(),
"sentence": lorem.sentence(),
"sentences": lorem.sentences(),
"paragraph": lorem.paragraph()
},
{
"words": lorem.words(),
"sentence": lorem.sentence(),
"sentences": lorem.sentences(),
"paragraph": lorem.paragraph()
}
]
}
def user_card():
return {
"name": name.find_name(),
"username": internet.user_name(),
"email": internet.email(),
"address": {
"street": address.street_name(),
"suite": address.secondary_address(),
"city": address.city(),
"zipcode": address.zip_code()
},
"phone": phone_number.phone_number(),
"website": internet.domain_name(),
"company": {
"name": company.company_name(),
"catchPhrase": company.catch_phrase(),
"bs": company.bs()
}
}
def populateDrinkers():
con = mdb.connect('localhost', 'user', 'pass', 'barlytics')
curr = con.cursor()
professions = [['doctor', 2], ['lawyer',2], ['engineer',2], ['teacher',1], ['contruction worker', 1], ['dentist', 1], ['nurse',1], ['cashier',0], ['janitor',0], ['garbage man', 0], ['driver', 0]]
genders = ['m', 'f']
for i in range(0, 9002):
name = names.get_full_name()
rand = choice(professions)
profession = rand[0]
income = rand[1];
gender = choice(genders)
age = choice([randint(18,21), randint(21, 35), randint(21,35), randint(21,35), randint(35, 55), randint (35, 55), randint(55,100)])
phone = phone_number.phone_number()
city = address.city()
addr = str(randint(1,255)) + address.street_name()
try:
curr.execute('INSERT INTO drinkers VALUES ("' + str(name) + '", "' + city + '", "' + str(phone) + '", "' + str(addr) + '", "' + profession + '", "' + str(age) + '", "' + str(income) + '", "' + gender + '");')
except mdb.IntegrityError:
print "Integrity Error: "
i = i - 1
# print 'INSERT INTO drinkers VALUES ("' + name + '", "' + city + '", "' + phone + '", "' + addr + '", "' + profession + '", "' + str(age) + '", "' + str(income) + '");'
con.commit()
