tim golden cggctimgoldenmeuk markabrand wrote sorry client customer ah see didnt think try explain better quite clear mind achievable build database tables queries happening form list win32_process add instance tableprocess list win32_service add instance tableservice etc etc win32_ query wanted implement looking object based pythonic way replace loops certainly possible several levels number orm packages around general favourite probably sqlalchemy 1 spinoff elixir 2 said theres nothing stop working straight dbapi 3 level calling executemany tables want certainly could table structure exactly mimic column structure corresponding wmi class push things along bit way fairly trivial turn wmi attribute values dictionary could passed something like elixirs rowcreation import os sys elixir import import wmi db_filename ospathabspath wmidb metadatabind sqlites db_filename class process entity processid field integer primary_keytrue caption field unicode 100 __name__ __main__ setup_all true c wmiwmi process cwin32_process processid caption dict p getattr process p p processproperties process sessionflush sessionclose obviously mere stub least work might useful basis definite scope factoring things might better function took inferred relevant class table names ymmv thanks assistance tim glad service tjg 1 httpsqlalchemyorg 2 httpelixirematiadetracwiki 3 httpwwwpythonorgdevpepspep0249 _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 wed 06 aug 2008 064415 0000 pythonwin32 advice architecting program design python