import sqlite3
import random
import string
conn = sqlite3.connect('test.db')
c = conn.cursor()
def generate_random_strings(number=6000, min_length=6, max_length=16):
for index in range(number):
yield ''.join(
[random.choice(string.ascii_letters) for _ in range(random.randint(min_length, max_length))]
)
# drop
c.execute('''DROP TABLE users;''')
# Create table
c.execute('''CREATE TABLE users
(name text, user_id integer)''')
# Insert a row of data
for index, name in enumerate(generate_random_strings()):
c.execute("INSERT INTO users VALUES ('{}','{}')".format(name, index))
conn.commit()
for row in c.execute('''SELECT name FROM users WHERE (user_id > 1234 AND user_id < 1334) ORDER BY name'''):
print row
conn.close()