Return a sequence of (name,type) pairs where type is
      either "table" or "view".

def tablesAndViews(self):
      """Return a sequence of (name,type) pairs where type is
      either "table" or "view"."""
      result = self.execute(
        u'SELECT name,type FROM sqlite_master WHERE type in ("table", "view")',
        commit=False)
      return ((row['name'],row['type']) for row in result)