ysinjab

# in users app i added this model
class User(models.Model):
    name = models.CharField(max_length=10)
    
# in django shell execute the following
from users.models import *

# the object will hold all the logic
new_user = User(name='Yasser')
# this will execute an INSERT

ysinjab

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('sqlite:///users.db', echo=True)
Base = declarative_base()


class User(Base):
    __tablename__ = 'users'

ysinjab

def append_to_list(size=1000000):
    result = []
    for i in range(size):
        result.append(1)

def fill_pre_allocated_list(size=1000000):
    result = size * [None]
    for i in range(size):
        result[i]= 1
        

ysinjab

from timeit import default_timer as timer
import seaborn as sns
import pandas as pd
import sys

times = {}
numbers = []
for i in xrange(3000000):
    start = timer()
    numbers.append(random.randint(0, 100000))

ysinjab

import bisect
import random
def search_index(numbers, number):
    i = bisect.bisect_left(numbers, number)
    if i == len(numbers):
        return i - 1
    elif numbers[i] == number:
        return i
    elif i > 0:
        j = i - 1