pwman3/pwman/exchange/importer.py

# ============================================================================
# This file is part of Pwman3.
#
# Pwman3 is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License, version 2
# as published by the Free Software Foundation;
#
# Pwman3 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 Pwman3; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
# ============================================================================
# Copyright (C) 2014 Oz Nahum Tiram <nahumoz@gmail.com>
# ============================================================================
'''
A module to hold the importer class
'''
import csv
from pwman.data.nodes import Node


class BaseImporter(object):

    """
    The base class which defines the action needed to import data
    to pwman database
    """

    def __init__(self):
        pass


class CSVImporter(BaseImporter):

    """
    A reference implementation which imports a CSV to the pwman database
    """
    def __init__(self, args, config, db):
        self.args = args
        self.config = config
        self._db = db
import ipdb; ipdb.set_trace()

    def _read_file(self):
        """read the csv file, remove empty lines and the header"""
        with open(self.args.import_file) as fh:
            csv_f = csv.reader(fh, delimiter=';')
            lines = [line for line in csv_f]
            lines = list(filter(None, lines))
        return lines[1:]

    def _create_node(self, row):
        """create a node object with encrypted properties"""
        n = {'clear_text': True,
             'username': row[0], 'password': row[2], 'url': row[1], 'notes': row[3],
             'tags': row[4].split(',')}
        node = Node(**n)
        return node

    def _insert_node(self, node):
        "insert the node object to the database"
        self._db.add_node(node)

    def _open_db(self):
        """
        open existing db or create a new db

        This will expect a CRYPTO table!
        Hence if not CRYPTO table one should create it...
        """
        self._db._open()
        self._db._create_tables()
        self._db._con.commit()
        self._db.open()

    def runner(self):
        self._open_db()

        for row in self._read_file():
            node = self._create_node(row)
            self._insert_node(node)

class Importer(object):

    """
    The actual job runner which by default runs a csv importer instance.
    This could be changes by calling other instance which for example import
    from KeePass XML or other formats.
    """
    def __init__(self, invoke=CSVImporter):
        self.runner = invoke()

    def run(self):
        self.runner()