import psycopg2
import socket
import threading
from models import *

try:
    dbhandle.connect()
except Exception:
    print('Error of connection')


sock = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
sock.bind(('127.0.0.1', 9092))
sock.listen(20)


class client_work():
    def __init__(self):
        # self.conn = conn
        # self.addr = addr
        # self.data = sock.recv(4096)
        with open('test_data2.json', 'r') as read_file:
            self.json = json.load(read_file)
        self.db_obj = get_db_obj(self.json)
        self.work_with_db()

    def work_with_db(self):
        if self.json['command'] == 'insert':
            self.db_obj.save()
        if self.json['command'] == 'change':
            n_db_obj = dict_of_obj[self.json['table']].get(dict_of_obj[self.json['table']].id == self.json['id'])
            update_model_from_dict(n_db_obj, self.json['columns'])
            n_db_obj.save()
        if self.json['command'] == 'delete':
            pass


def new_connection():
    pass

client_work()
while True:
    pass
    # conn, addr = sock.accept()
    # th = threading.Thread(target=client_data(conn, addr))
