#!/usr/bin/python
# -*- coding: utf-8 -*-

import psycopg2
import sys


con = None

try:
    con = psycopg2.connect(host='127.0.0.1', database='dropbox', user='dropbox', password='12345', port=5432)
    cur = con.cursor()
    cur.execute('SELECT version()')
    ver = cur.fetchone()
    print ver


except psycopg2.DatabaseError, e:
    print 'Error %s' % e
    sys.exit(1)


finally:
    with open('/home/muhammadtaqi/Downloads/dropbox/bf_1.txt') as fp:
        for line in fp:
            currentline = line.split(":")
            email = str(currentline[0])
	    password = str(currentline[1])
            cur.execute('INSERT INTO users (email, password) VALUES (%s, %s)', (email, password))
        con.commit()

    if con:
        con.close()