Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #45679

More general way of generating PyODBC queries as a dict?

Show all headers | View raw

Here are my averagely general class methods for creating a dictionary from the result of database queries:

def make_schema_dict(self):
    schema = [i[2] for i in self.cursor.tables()
              if i[2].startswith('tbl_') or i[2].startswith('vw_')]

    self.schema = {table: {'scheme': [row.column_name for row
                                      in self.cursor.columns(table)]}
                   for table in schema}

def last_table_query_as_dict(self, table):
    return {'data': [{col: row.__getattribute__(col) for col in self.schema[table]['scheme']
                      if col != 'RowNum'} for row in self.cursor.fetchall()]}
Unfortunately as you can see, there are many complications.

For example, when multiple tables are queried; some hackish lambdas are required to generate the resulting dictionary.

Can you think of some more general methods?

(and yes I know this is against the PEP; and that this is also on SO)

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

More general way of generating PyODBC queries as a dict? stackoverflowuser95@gmail.com - 2013-05-21 10:27 -0700
  Re: More general way of generating PyODBC queries as a dict? Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-05-21 19:33 -0400
  Re: More general way of generating PyODBC queries as a dict? stackoverflowuser95@gmail.com - 2013-05-22 02:31 -0700

csiph-web