messenger_server.database module¶

class messenger_server.database.DatabaseConnection¶

Single SQLite3 Database connection.

Parameters:	_connection (`sqlite3.Connection`) – Connection object for the database _cursor (`sqlite3.Cursor`) – Cursor object returned by _connection

add_contact(user, contact)¶

Insert a record representing a (user, contact) pair.

Parameters:	user (str) – Login of user who is adding a new contact contact (str) – Login of user who is being added as contact
Raises:	`messenger_server.database.ContactExistingError` if such pair already exists in the database
Raises:	`messenger_server.database.UserNotFoundError` if contact does not exist in the users table

add_user(email, login, password)¶

Insert a record representing a single user.

Parameters:	email (str) – User’s email address login (str) – User’s login password (str) – User’s password
Raises:	`messenger_server.database.LoginTakenError` if a record with identical login already exists

get_contacts_list(user)¶

Get a list of given user’s contacts.

Parameters:	user (str) – Login of user whose contacts are being retrieved
Returns:	a list of logins
Return type:	list(str)

get_users_with_contact(contact)¶

Get a list of users who have given contact.

Parameters:	contact (str) – Login of user being searched as a contact
Returns:	a list of logins
Return type:	list(str)

setup()¶

Prepare initial database structure in case it doesn’t exist yet.

This method should be called once before starting the server.

verify_login(login, password)¶

Verify if given login matches given password in the database.

Parameters:	login (str) – Login being matched password (str) – Password being matched
Raises:	`messenger_server.database.LoginNotFoundError` if there is no record with given login
Raises:	`messenger_server.database.PasswordError` if password retrieved from the database does not match the password provided