sqlite3.Connection.iterdump() does not work with row_factory = sqlite3.Row

Lib/sqlite3/dump.py

 # Mimic the sqlite3 console shell's .dump command
 # Author: Paul Kippes <kippesp@gmail.com>
 
 # Every identifier in sql is quoted based on a comment in sqlite
 # documentation "SQLite adds new keywords from time to time when it
 # takes on new features. So to prevent your code from being broken by
 # future enhancements, you should normally quote any identifier that
 # is an English language word, even if you do not have to."
 
 def _iterdump(connection):
     """
     Returns an iterator to the dump of the database in an SQL text format.
 
     Used to produce an SQL dump of the database.  Useful to save an in-memory
     database for later restoration.  This function should not be called
     directly but instead called from the Connection method, iterdump().
     """
 
     cu = connection.cursor()
     yield('BEGIN TRANSACTION;')
 
     # sqlite_master table contains the SQL CREATE statements for the database.
     q = """
         SELECT "name", "type", "sql"
         FROM "sqlite_master"
             WHERE "sql" NOT NULL AND
             "type" == 'table'
+            ORDER BY "name";
         """
-    schema_res = cu.execute(q)
-    for table_name, type, sql in sorted(schema_res.fetchall()):
+    schema_res = cu.execute(q).fetchall()
+    for table_name, type, sql in schema_res:
         if table_name == 'sqlite_sequence':
             yield('DELETE FROM "sqlite_sequence";')
         elif table_name == 'sqlite_stat1':
             yield('ANALYZE "sqlite_master";')
         elif table_name.startswith('sqlite_'):
             continue
         # NOTE: Virtual table support not implemented
         #elif sql.startswith('CREATE VIRTUAL TABLE'):
         #    qtable = table_name.replace("'", "''")
         #    yield("INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)"\
@@ skipping 19 matching lines @@
         SELECT "name", "type", "sql"
         FROM "sqlite_master"
             WHERE "sql" NOT NULL AND
             "type" IN ('index', 'trigger', 'view')
         """
     schema_res = cu.execute(q)
     for name, type, sql in schema_res.fetchall():
         yield('{0};'.format(sql))
 
     yield('COMMIT;')