dump_load.py

class Database(object):

  def dump(self, url):
        import sqlite3
        db = sqlite3.connect(url)
        script = '\n'.join(db.iterdump())
        with open('test.sql', 'w') as f:
            f.write(script)
        db.close()

    def load(self):
        with open('test.sql') as f:
            sql = ''
            for line in f:
                line = line.strip()
                if line.startswith('--'):
                    continue
                sql += line
                if not line.endswith(';'):
                    continue
                try:
                    self.session.execute(sql)
                except Exception as e:
                    print(e)
                finally:
                    sql = ''

it's better to use with closing statement