#!/usr/bin/python

import pandas as pd
from django.conf import settings
from sqlalchemy import create_engine
user = settings.DATABASES['default']['USER']
password = settings.DATABASES['default']['PASSWORD']
database_name = settings.DATABASES['default']['NAME']
# host = settings.DATABASES['default']['HOST']
# port = settings.DATABASES['default']['PORT']

database_url = 'postgresql://{user}:{password}@localhost:8000/{database_name}'.format(
    user=user,
    password=password,
    database_name=database_name,
)

engine = create_engine(database_url, echo=False)

mydataframe = pd.read_pickle('vcf.test.pk')

print 'loaded'

mydataframe.to_sql('mytable', engine,if_exists='append',index=False)