thanks. <div>On 12/03/2008, James Henstridge <<a href="mailto:james@jamesh.id.au">james@jamesh.id.au</a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> On 12/03/2008, mark. a. brand <<a href="mailto:mark.a.brand@gmail.com">mark.a.brand@gmail.com</a>> wrote: > hi: > > *** newbie-alert ***:  both python and storm > > the bit of code below - apparently works in sqlalchemy with sqlalchemy > syntax of course. > > my question is how can i do the same thing in storm, ie create a whole bunch > or instances at once via a dict. > > database = create_database("sqlite:hc.db") > store = Store(database) > > class Process(Storm): >      __storm_table__ = "process" >      ProcessId = Int(primary = True) >      Caption = Unicode() > >  store.execute("CREATE TABLE process " "( \ >  ProcessId        VARCHAR, \ >  Caption            VARCHAR)", >  noresult = True \ >  ) > >  c = wmi.WMI () >  for process in c.Win32_Process (['ProcessId', 'Caption']): >      d = dict ((p, getattr (process, p)) for p in process.properties) >      Process (**d) You need to add these process objects to the store:     store.add(Process(**d)) > storm.flush() > storm.commit() And this should be store.commit() rather than storm.commit().  You should not need the flush() call. James. </blockquote></div>