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)
