retract question. Got it.
On Oct 11, 11:20 pm, mart <[email protected]> wrote: > Hi, > > Can anyone help with the following. I need to have some back end, out > of sight, server stuff happening. But, need to share the SQLite DB > with web2py. So, i copied the gluon environment (the folder) where I > can reference it to handle the data stuff at the back end - oiut of > the web2py normal environment (doing this because, this must not be > run anywhere near a web front end)... everything seems to be happening > fine, except that it doesn't work ;) and I think it should work... I > have no problems referencing what I need from gluon, i can create > tables, I get good logging from sql.log, etc... but the tables are > empty, and no exception is being thrown.... (relevant code is below - > unless you need more) > > Any help, would be appreciated. I am promoting the use of web2py to a > bunch of snarly upper management types, who were hard to convince. > This is for a home grown, in house build system, where i am trying to > implement lots of new ideas & strategies. I would like to have web2py > hold everything together. If this could be implemented, I will then > push the idea company wide (~ 7000 employees). This would offer good > exposure to web2py as lots of people will be looking at this with the > hope of replacing existing build infrastructure. So, here is a snippet > of my grief (in line comments are related to the question). > > Thanks in advance, > Mart :) > > I have this; > > MODEL: > db.define_table("cumulativeProperties", > SQLField("name"), # just the key/value pairs of > SQLField("value" )) # a properties object > > db.define_table("objBuildAll", > SQLField("cumulativeProperties", "upload"), # the > properties object > SQLField("etree_builtIn", "upload"), # an xml etree object > SQLField("etree_builder", "upload"), # an xml etree > object > SQLField("x2_builtIn", "upload"), # a dict with object > function > > #__init__, __getattr__,__setattr__,__str__ > SQLField("x2_builder", "upload")) # another dict with object > function > > AND THIS, WHICH SHOULD EXECUTE: > > pObj = bluePickles.pickles() # reference to object Pickler > > # I have quite a few of the following > pObj.pickledToFile('{0}/ > x2_builtIn'.format(self.etherRoot),self.x2_builtIn) #pickle to file > (they are fine and get created > > # this is web2py stuff, taken from the book. I want to insert objects > as blobs (not images). > stream = open('{0}/x2_builtIn'.format(self.etherRoot),'rb') > db.objBuildAll.insert(x2_builtIn=db.objBuildAll.x2_builtIn.store(stream,'{0}/ > x2_builtIn'.format(self.etherRoot))) > > # store the key/value pairs as strings, separate from the stored > properties object > keys = self.cumulativeProperties.getPropKeys() > for key in keys: > db.cumulativeProperties.insert(name=key,value=self.cumulativeProperties.getPropertyValue(key)) > > db.commit() > del pObj > > THEN, I WANT TO SEE IF THERE IS SOMETHING, SO I DO: > > class setCmd(baseCmd): > def cmd(self): > rows = db().select(db.objBuildAll.ALL) > for row in rows: > print row > > AND I GET THESE ERRORS (I am not trying to delete any records, so > don't know why I get the 'delete_record') > > <Row {'update_record': <function <lambda> at 0x10163cb90>, > 'etree_cmdInit': None, 'id': 1, 'delete_record': <function <lambda> at > 0x10163cc08>, 'x2_cmdInit': 'objCmdInit.x2_cmdInit.90b447efe2beeb4e. > 78325f62616e6e6572.txt'}> > <Row {'update_record': <function <lambda> at 0x10163cc80>, > 'etree_cmdInit': > 'objCmdInit.etree_cmdInit.aa0fe61a0eb59c46.78325f62616e6e6572.txt', > 'id': 2, 'delete_record': <function <lambda> at 0x101666848>, > 'x2_cmdInit': None}> > <Row {'update_record': <function <lambda> at 0x1016668c0>, > 'etree_cmdInit': None, 'id': 3, 'delete_record': <function <lambda> at > 0x101666938>, 'x2_cmdInit': 'objCmdInit.x2_cmdInit.9326c3985102299d. > 78325f696e69744275696c64.txt'}> > <Row {'update_record': <function <lambda> at 0x1016669b0>, > 'etree_cmdInit': 'objCmdInit.etree_cmdInit. > 98a5ce6fb36e2ac1.78325f696e69744275696c64.txt', 'id': 4, > 'delete_record': <function <lambda> at 0x101666a28>, 'x2_cmdInit': > None}>
