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()