问python与sqlite3 cli工具之间的数据库传输

EN

def sqlite_cli(self):
    # Spawn the original sqlite3 cli interface
    # Dump the database in a named temporary file. Read it back into
    # memory. At close() the tempfile will be erased.
    with tempfile.NamedTemporaryFile(delete=True) as tf:
        for line in self.connection.iterdump():
            tf.write(bytes(line, 'ascii'))

        # Work with the database through sqlite3
        subprocess.call(['sqlite3', '-init', tf.name])

        # Read the potentially modified database
        # !!!!!!!!!!!!!!!!
        # Here happens the logic gap: The sqlite3 tool doesn't 
        # save modifications to the file opend as the -init argument.
        # How can I save the modifications done within sqlite3 as a 
        # sql text file ready to be read back into the app?!
        tf.seek(0)
        edited_db = tf.read()

        # Delete all tables residing in memory
        try:
            for t in ACCMAN_TABLES:
                self.cursor.execute('DROP TABLE IF EXISTS %s' % t)
            self.connection.commit()
            # Add the (maybe) edited one
            self.cursor.executescript(edited_db.decode(encoding='utf-8'))
            self.connection.commit()
        except sqlite3.Error as e:
            logger.error("sqlite_cli(): %s" % e.args[0])

        tf.close()

.output outfile.sql
.dump
.quit