+# -*- coding: utf-8 -*-
+
+# Copyright (c) 2018 Michael Rasmussen <mir@datanom.net>
+
+# This file is part of SecureMail.
+
+# SecureMail is free software: you can redistribute it and/or modify
+# it under the terms of the GNU General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# SecureMail is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with SecureMail. If not, see <https://www.gnu.org/licenses/>.
+
+# sqlite
+sqlite_sql = """create table account (
+id int auto_increment,
+token char(128) unique not null,
+cipher text not null,
+primary key (id))"""
+
+# mysql
+mysql_sql = """create table account (
+id int auto_increment,
+token char(128) unique not null,
+cipher text not null,
+primary key (id))"""
+
+# postgresql
+postgresql_sql = """create table account (
+id serial,
+token char(128) unique not null,
+cipher bytea not null,
+primary key (id))"""
+
+import base64
+from config import DBTYPE, DBNAME
+try:
+ from config import DBUID
+except ImportError:
+ DBUID = 'backend'
+try:
+ from config import DBPWD
+except ImportError:
+ DBPWD = 'clV77B2ZJQxr'
+try:
+ from config import DBHOST
+except ImportError:
+ DBHOST = 'localhost'
+try:
+ from config import DBPORT
+except ImportError:
+ if DBTYPE == 'mysql':
+ DBPORT = 3306
+ elif DBTYPE == 'postgresql':
+ DBPORT = 5432
+from cryptonize import Cryptonize
+
+class Singleton:
+ def __init__(self, klass):
+ self.klass = klass
+ self.instance = None
+
+ def __call__(self, *args, **kwargs):
+ if self.instance == None:
+ self.instance = self.klass(*args, **kwargs)
+ return self.instance
+
+@Singleton
+class DB:
+ conn = None
+
+ def get_connection(self):
+ if self.conn is None:
+ if DBTYPE == 'mysql':
+ import MySQLdb
+ self.conn = MySQLdb.connect(host=DBHOST, port=DBPORT, user=DBUID, passwd=DBPWD, db=DBNAME)
+ elif DBTYPE == 'postgresql':
+ import psycopg2
+ self.conn = psycopg2.connect(host=DBHOST, port=DBPORT, user=DBUID, password=DBPWD, dbname=DBNAME)
+ elif DBTYPE == 'sqlite':
+ import apsw
+ self.conn = apsw.Connection('./{0}.db'.format(DBNAME))
+ else:
+ raise ValueError('{0}: Unsupported database'.format(DBTYPE))
+ return self.conn
+
+ def __del__(self):
+ if self.conn is not None:
+ self.conn.close()
+
+class DBInterface:
+ @staticmethod
+ def load_user(key):
+ conn = DB().get_connection()
+ cursor = conn.cursor()
+ cursor.execute("select a.cipher from account a where token = '{0}'".format(key))
+ row = cursor.fetchone()
+ if row is None:
+ obj = None
+ else:
+ c = Cryptonize()
+ msg = base64.b64decode(row[0])
+ obj = c.create_EncryptedMessage(msg)
+ cursor.close()
+
+ return obj
+
+ @staticmethod
+ def store_user(key, cipher):
+ if DBTYPE == 'mysql':
+ from MySQLdb import Error as DBError
+ elif DBTYPE == 'postgresql':
+ from psycopg2 import Error as DBError
+ elif DBTYPE == 'sqlite':
+ from apsw import Error as DBError
+ conn = DB().get_connection()
+ cursor = conn.cursor()
+ raw = base64.b64encode(cipher)
+ try:
+ if DBTYPE != 'sqlite':
+ cursor.execute("insert into account(token, cipher) values(%s, %s)", (key, raw))
+ conn.commit()
+ else:
+ cursor.execute('begin')
+ cursor.execute("insert into account(token, cipher) values(?, ?)", (key, raw))
+ cursor.execute('commit')
+ except DBError as e:
+ print (e)
+ if DBTYPE != 'sqlite':
+ conn.rollback()
+ else:
+ cursor.execute('rollback')
+ raise e
+ finally:
+ cursor.close()
+
+ @staticmethod
+ def create_database():
+ if DBTYPE == 'mysql':
+ from MySQLdb import Error as DBError
+ elif DBTYPE == 'postgresql':
+ from psycopg2 import Error as DBError
+ elif DBTYPE == 'sqlite':
+ from apsw import Error as DBError
+ conn = DB().get_connection()
+ cursor = conn.cursor()
+ try:
+ if DBTYPE != 'sqlite':
+ if DBTYPE == 'mysql':
+ sql = mysql_sql
+ elif DBTYPE == 'postgresql':
+ sql = postgresql_sql
+ cursor.execute(sql)
+ conn.commit()
+ else:
+ cursor.execute('begin')
+ cursor.execute(sqlite_sql)
+ cursor.execute('commit')
+ except DBError as e:
+ if DBTYPE != 'sqlite':
+ conn.rollback()
+ else:
+ cursor.execute('rollback')
+ raise e
+ finally:
+ cursor.close()
+
+def main():
+ from optparse import OptionParser
+
+ usage = "usage: %prog [options] arg"
+ parser = OptionParser(usage)
+ parser.add_option("-c", "--create", action="store_true", dest="create",
+ help="Create tables in database using config.py", default=False)
+ parser.add_option("-v", "--verbose", action="store_true", dest="verbose",
+ help="Run in verbose mode", default=False)
+ (options, args) = parser.parse_args()
+
+ if options.create:
+ try:
+ if options.verbose:
+ print("Creating empty database")
+ print("Database Engine: {0}".format(DBTYPE))
+ if DBTYPE != 'sqlite':
+ print("Database Host: {0}".format(DBHOST))
+ print("Database Port: {0}".format(DBPORT))
+ else:
+ print("Database File: ./{0}.db".format(DBNAME))
+ DBInterface.create_database()
+ print("Database created")
+ except Exception as e:
+ print("Creating database failed!")
+ print(e)
+
+if __name__ == '__main__':
+ main()