#!/usr/bin/env python

import datetime, os
from sqlalchemy import *
from sqlalchemy import exceptions, sql
from sqlalchemy.orm import *
from sqlalchemy.orm.shard import ShardedSession
from sqlalchemy.sql import operators

from sqlalchemy import create_engine

from blog_engine import *
from lookup import Lookup

from elixir import *
import md5

from lookup_config import *

def load_data():
	load_data_lookup()

def load_data_lookup():
    session = None
    setup_all()
    
    for i in  range(DATA):

        username1 = u"%d" % (i)
        hasha = md5.new()
        hasha.update("%s" % username1)
        valuea = hasha.digest()
        remhexa = valuea.encode("hex")


        rema = long(remhexa, 16)% SHARD
    
        m1 = Lookup(username="%d" % (i), shardname=shard_lookup_dict['%s' % rema])
        sess = create_session_lookup()
        sess.begin()
        sess.save(m1)
        sess.commit()
        sess.clear()

if __name__ == '__main__':
    load_data()