CREATE TABLE IF NOT EXISTS messenger.user (userid serial PRIMARY KEY, name varchar(45), password varchar(256), status varchar(45), createdat timestamp); CREATE TABLE IF NOT EXISTS messenger.chat (chatid serial PRIMARY KEY, owner integer REFERENCES messenger.user (userid), createdat timestamp); CREATE TABLE IF NOT EXISTS messenger.message (messageid serial PRIMARY KEY, sender integer REFERENCES messenger.user (userid), time timestamp, text text, chatid integer REFERENCES messenger.chat (chatid)); CREATE TABLE IF NOT EXISTS messenger.chat_participants (chatid integer REFERENCES messenger.chat (chatid), participant integer REFERENCES messenger.user (userid)); CREATE TABLE IF NOT EXISTS messenger.contacts (userid integer REFERENCES messenger.user (userid), contact integer REFERENCES messenger.user (userid)); """) conn.commit() usr1 = User('Alice', '1111111') usr2 = User('Ted', '2222222') usr3 = User('Bob', '3333333') usr4 = User('Fred', '4444444') usr5 = User('Ed', '555555') usr6 = User('Bob', '6666666') usr1.addContact(usr2) usr1.addContact(usr3) usr1.addContact(usr4) usr1.addContact(usr5) usr1.addContact(usr6) usr2.addContact(usr1) usr2.addContact(usr3) usr2.addContact(usr4) def start_clients(user): ''' conn_string = "host='localhost' dbname='postgres' user='******' password='******'" conn = psycopg2.connect(conn_string) cur = conn.cursor() cur.execute(
добавлению пользователей к списку контактов, отправке сообщений и отображения их истории 20.04.17 - Добавлено взаимодействие с СУБД PostgreSQL ''' conn_string = "host='localhost' dbname='postgres' user='******' password='******'" conn = psycopg2.connect(conn_string) cur = conn.cursor() cur.execute("""DELETE FROM messenger.contacts;""") cur.execute("""DELETE FROM messenger.chat_participants;""") cur.execute("""DELETE FROM messenger.message;""") cur.execute("""DELETE FROM messenger.chat;""") cur.execute("""DELETE FROM messenger.user;""") conn.commit() Alice = User('Alice', '1111111') Bob = User('Bob', '2222222') Ted = User('Ted', '3333333') Fred = User('Fred', '4444444') Alice.addContact(Bob) Alice.addContact(Ted) Alice.addContact(Fred) Alice.getContacts() Bob.addContact(Ted) Bob.getContacts() Alice.startChat(Bob, Ted, Fred)