matteridge.cache¶
Attributes¶
Classes¶
Functions¶
|
Module Contents¶
- matteridge.cache.SCHEMA = Multiline-String[source]¶
Show Value
""" CREATE TABLE server( id INTEGER PRIMARY KEY, server TEXT UNIQUE ); CREATE TABLE user( id INTEGER PRIMARY KEY, server_id INTEGER NON NULL, user_id TEXT NON NULL, username TEXT NON NULL, FOREIGN KEY(server_id) REFERENCES server(id), UNIQUE (server_id, user_id), UNIQUE (server_id, username) ); CREATE TABLE direct_channel( id INTEGER PRIMARY KEY, server_id INTEGER NON NULL, me INTEGER NON NULL, them INTEGER NON NULL, direct_channel_id TEXT NON NULL, FOREIGN KEY(server_id) REFERENCES server(id), FOREIGN KEY(me) REFERENCES user(id), FOREIGN KEY(them) REFERENCES user(id), UNIQUE(me, them, direct_channel_id) ); CREATE INDEX user_server_id ON user(server_id); CREATE INDEX user_user_id ON user(user_id); CREATE INDEX user_username ON user(username); """
- matteridge.cache.user_factory(_cursor, row)[source]¶
- Parameters:
_cursor (sqlite3.Cursor)
- Return type:
- class matteridge.cache.Cache(filename)[source]¶
- Parameters:
filename (os.PathLike)
- get_user_by_direct_channel_id(server, slidge_user_id, direct_channel_id)[source]¶
- Parameters:
- Return type: