shihabsikder

postgres Database populate - python script

Feb 12th, 2022
1,183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.61 KB | None | 0 0
  1. import random
  2. import string
  3.  
  4. def random_char(y):
  5.        return ''.join(random.choice(string.ascii_letters) for x in range(y))
  6.  
  7. def random_number(y):
  8.        return ''.join(str(random.randint(0, 9)) for x in range(y))
  9.  
  10. f = open("insert.sql",'w');
  11. for i in range(200):
  12.     command = "INSERT INTO accounts(username,password,email,contact,postcode,age,height) VALUES('{}','{}','{}@gmail.com',{},{},{},{});".format(random_char(7),random_char(10),random_char(6).lower(),random_number(random.randint(8, 12)),random_number(random.randint(4, 7)),random.randint(13, 65),random.randint(130, 200))
  13.     f.writelines(command+"\n")
Advertisement
Add Comment
Please, Sign In to add comment