Tim Golden wrote:
[... snip Elixir-based solution ...]
I realise, rereading my post that it doesn't really solve
your concern about multiple loops etc. I doubt it's really
a problem, but in the spirit of the question, here's a raw
sqlite solution, again Noddy and untested.
You've said you're newish to Python and while
there's no black magic here, I am being fairly free with
generator expressions and getattr-fu. If you think the
approach might be useful and need further explanation
feel free to ask.
<code>
import os, sys
import sqlite3
import wmi
os.remove ("c:/temp/wmi.db")
db = sqlite3.connect ("c:/temp/wmi.db")
classes_wanted = ["Win32_Process", "Win32_Service"]
#
# Generate a dictionary of class name -> WMI class
#
c = wmi.WMI ()
wmi_classes = dict (
(class_wanted, getattr (c, class_wanted)) \
for class_wanted in classes_wanted
)
#
# Create a simplistic Sqlite table for each WMI
# class with one (untyped) column per attribute.
#
for class_name, wmi_class in wmi_classes.items ():
db.execute ("CREATE TABLE %s (%s)" % (
class_name,
", ".join (p for p in wmi_class.properties)
))
db.commit ()
#
# For each WMI class, add all its instances as
# rows to the corresponding sqlite table.
#
for class_name, wmi_class in wmi_classes.items ():
db.executemany (
"INSERT INTO %s (%s) VALUES (%s)" % (
class_name,
", ".join (p for p in wmi_class.properties),
", ".join ("?" for p in wmi_class.properties)
),
[[getattr (c, p) for p in c.properties] for c in wmi_class ()]
)
db.commit ()
</code>
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
