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