create_table.py

import random
import sqlite3

conn = sqlite3.connect('btreedemo.sqlite')
c = conn.cursor()

c.execute('''DROP TABLE IF EXISTS keyword_campaigns''')

c.execute('''CREATE TABLE keyword_campaigns
            (keyword, campaign_id, budget, spent, primary key(keyword, campaign_id)) without rowid''')


for i in xrange(5000000):
    if i % 1000 == 0:
        random_keyword = ''.join(chr(random.randint(97, 122)) for i in range(7))
    c.execute('''INSERT INTO keyword_campaigns VALUES(?,?,?,?)''', (random_keyword, i + 1, i, i))

for i in xrange(100):
    c.execute('''INSERT INTO keyword_campaigns VALUES(?,?,?,?)''', ('halloween', i, 99 + i, 0))

for i in xrange(5000000, 10000000):
    if i % 1000 == 0:
        random_keyword = ''.join(chr(random.randint(97, 122)) for i in range(7))
    c.execute('''INSERT INTO keyword_campaigns VALUES(?,?,?,?)''', (random_keyword, i + 1, i, i))


#c.execute('''CREATE INDEX idx1 ON keyword_campaigns (campaign_id)''')

conn.commit()