def faker(con: sqlite3.Connection, count=100_000): con.execute('BEGIN') for _ in range(count): age = get_random_age() active = get_random_active() # switch for area code if get_random_bool(): # random 6 digit number area = get_random_area_code() con.execute('INSERT INTO user VALUES (NULL,?,?,?)', (area, age, active)) else: con.execute('INSERT INTO user VALUES (NULL,NULL,?,?)', (age, active)) con.commit()
def faker(count=100_000): min_batch_size = 1_000_000 for _ in range(int(count / min_batch_size)): with_area = get_random_bool() current_batch = [] for _ in range(min_batch_size): age = get_random_age() active = get_random_active() # switch for area code if with_area: # random 6 digit number area = get_random_area_code() current_batch.append((area, age, active)) else: current_batch.append((age, active))
def producer(count: int): min_batch_size = 1_000_000 for _ in range(int(count / min_batch_size)): with_area = get_random_bool() current_batch = [] for _ in range(min_batch_size): age = get_random_age() active = get_random_active() # switch for area code if with_area: # random 6 digit number area = get_random_area_code() current_batch.append((area, age, active)) else: current_batch.append((age, active)) if with_area: q.put(('INSERT INTO user VALUES (NULL,?,?,?)', current_batch)) else: q.put(('INSERT INTO user VALUES (NULL,NULL,?,?)', current_batch))
def faker(con: sqlite3.Connection, count=100_000): min_batch_size = 1_00_000 for _ in range(int(count / min_batch_size)): with_area = get_random_bool() current_batch = [] for _ in range(min_batch_size): age = get_random_age() active = get_random_active() if with_area: area = get_random_area_code() current_batch.append((area, age, active)) else: current_batch.append((age, active)) if with_area: con.executemany('INSERT INTO user VALUES (NULL,?,?,?)', current_batch) else: con.executemany('INSERT INTO user VALUES (NULL,NULL,?,?)', current_batch) con.commit()