merged stable into default

1 files changed, 21 insertions, 0 deletions

diff --git a/module/database/AccountDatabase.py b/module/database/AccountDatabase.py
new file mode 100644
index 000000000..1602451fa
--- /dev/null
+++ b/module/database/AccountDatabase.py
@@ -0,0 +1,21 @@
+# -*- coding: utf-8 -*-
+
+from module.database import queue, async
+from module.database import DatabaseBackend
+
+class AccountMethods:
+
+    @queue
+    def loadAccounts(db):
+        db.c.execute('SELECT plugin, loginname, activated, password, options FROM accounts;')
+        return db.c.fetchall()
+
+    @async
+    def saveAccounts(db, data):
+        db.c.executemany('INSERT INTO accounts(plugin, loginname, activated, password, options) VALUES(?,?,?,?,?)', data)
+
+    @async
+    def removeAccount(db, plugin, loginname):
+        db.c.execute('DELETE FROM accounts WHERE plugin=? AND loginname=?', (plugin, loginname))
+
+DatabaseBackend.registerSub(AccountMethods)
\ No newline at end of file