diff options
author | Aaron Williamson <aaron@copiesofcopies.org> | 2013-03-06 09:37:45 -0500 |
---|---|---|
committer | Aaron Williamson <aaron@copiesofcopies.org> | 2013-03-06 09:37:45 -0500 |
commit | 7b0d82539e2d8a451b8ea9ee54baab0f308a4d8a (patch) | |
tree | 677e5e8f5ec032f9403175b1bc78f378bd0d2d5c /stashbox/models.py | |
parent | 673b5ffc0f4fe267901d2acef5212bc158b7885e (diff) |
Added license notices, rebranded.
Diffstat (limited to 'stashbox/models.py')
-rw-r--r-- | stashbox/models.py | 126 |
1 files changed, 0 insertions, 126 deletions
diff --git a/stashbox/models.py b/stashbox/models.py deleted file mode 100644 index 0f402ba..0000000 --- a/stashbox/models.py +++ /dev/null @@ -1,126 +0,0 @@ -import web - -db = web.database(dbn='sqlite', db='stashbox.db') - -def get_folders(): - folder_result = db.query(""" -SELECT DISTINCT d.id, d.name, u.username as owner - FROM directory d - JOIN user u ON d.owner_id = u.id - ORDER BY d.name -""") - - folders = [] - - for row in folder_result: - folder = {} - folder['id'] = row.id - folder['name'] = row.name - folder['owner'] = row.owner - folder['users'] = [] - - user_result = db.query(""" - SELECT DISTINCT u.username - FROM user u, directory_user a - WHERE a.user_id = u.id - AND a.directory_id = %s - ORDER BY u.username - """ % row.id) - - for user in user_result: - folder['users'].append(user.username) - - folders.append(folder) - - return folders - -def add_folder(name, owner): - where_vars = {'name': name} - folders = db.select('directory', where=web.db.sqlwhere(where_vars)) - - if not folders: - return db.insert('directory', name=name.replace("/",""), owner_id=owner) - else: - # Can't add non-unique folders - return False - -def get_folder(id): - where_vars = {'id': id} - directories = db.select('directory', where=web.db.sqlwhere(where_vars)) - return get_single(directories) - -def update_folder(update_values): - db.update('directory', where="id=$id", vars={'id':update_values['id']}, - name=update_values['name'], owner_id=update_values['owner_id']) - - db.delete('directory_user', where="directory_id=$did", - vars={'did':update_values['id']}) - - for id in update_values['users']: - db.insert('directory_user', directory_id=update_values['id'], - user_id=id) - -def get_folder_users(folder_id): - where_vars = {'directory_id': folder_id} - result = db.select('directory_user', where=web.db.sqlwhere(where_vars)) - users = [] - - for item in result: - users.append(item.user_id) - - return users - -def delete_folder(id): - db.delete('directory', where="id=$id", vars=locals()) - db.delete('directory_user', where="directory_id=$id", vars=locals()) - -def delete_user(id): - db.delete('user', where="id=$id", vars=locals()) - db.delete('directory_user', where="user_id=$id", vars=locals()) - db.delete('directory', where="owner_id=$id", vars=locals()) - -def get_users(as_list=False): - result = db.select('user') - - if as_list: - users = [] - - for user in result: - users.append((user.id, user.username)) - - return users - else: - return result - -def get_user(id): - where_vars = {'id': id} - return get_single(db.select('user', where=web.db.sqlwhere(where_vars))) - -def update_user(id, username, password): - db.update('user', where="id=$id", vars=locals(), - username=username, password=password) - -def authorize_user(user_id, folder_id): - if not is_authorized(user_id, folder_id): - db.insert('directory_user', directory_id=folder_id, user_id=user_id) - -def is_authorized(user_id, folder_id): - where_vars = {'directory_id': folder_id, 'user_id': user_id} - auths = db.select('directory_user', where=web.db.sqlwhere(where_vars)) - - if not auths: - return False - else: - return True - -def add_user(username, password): - users = db.select('user', where="username=$username", vars=locals()) - - if not users: - return db.insert('user', username=username, password=password) - else: - user = users.list().pop() - return user["id"] - -def get_single(obj): - return obj[0] |