· 5 years ago · Apr 06, 2020, 05:40 AM
1info = 'INSERT INTO "user" ("username", "email", "name", "password", "isSSO", "role", "studyProgram", "npm") VALUES'
2jumlah = 50 # bisa diganti sesukanya
3for i in range(jumlah):
4 info += "\n('gem1', '{}@gmail.com', 'Gema', 'bl', false, 'Student', 'boo', '{}')".format(i, i)
5 if i == 49:
6 info += ";"
7 else:
8 info += ","
9print(info)
10
11# Copy hasil print(info) ke pgadmin