*** bigbrother has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
<jcater> beats me
<jcater> had to restart a few things on ash
<derek> lack of donuts
<derek> let me run this by someone since my feeble mind is so rusty
<SachaS> btamis list box works
<derek> if i had a structure with 3 levels
<derek> 3000
<derek> 3000 3001
*** kilo_ has joined #gnuenterprise
<derek> 3000 3001 3002
<derek> for example
<derek> i need to build a stucture to hold them so i can write out hierarchy of them
<derek> 3000
<derek>   3001
<derek>     3002
<derek> i have column that tells me what "level" something is
<kilo_> hi
<derek> so i was thinking if i rolled through the resultset one time
<derek> i could create a dict with key being the level 1 (in this sample 3000)
<derek> then when rolling in the level 2 it could store the values in level 1 dict as that is in the record
<derek> and so on
<derek> so have a dict with two dicts in it
<derek> but i am not sure if that is making it more complicated than it has to be
<jcater> nah
<jcater> basic python
<derek> is there possibly an elegant python solution i am missing
<jcater> do it all the time
<derek> do you have to initialize a dict?
<derek> before you can start to populate it
<Vee> @version
<bigbrother> Vee: The current (running) version of this Supybot is 0.77.1.  The newest version available online is 0.77.2.
<jcater> foo = {}
<jcater> then inside whatever for loop you have
<jcater> traversing the resultset
<jcater>   try:
<jcater>     currentCategory = foo[category]
<jcater>   except KeyError:
<jcater>     currentCategory = {}
<jcater>     foo[category] = currentCategory
<jcater> then you can reference currentCategory as that categories dict
<jcater> category == my wording for your 3000, 3001, etc
<jcater> that's how jcater does it at least
<jcater> are you following? or do you need a better, more concrete example
<jcater> ?
<derek> im not sure i entirely follow, but htat is just cause im having to look at some python syntax
<derek> if you have concrete example great, if not i can figure it out
<jcater> not handy
<derek> no prob
<derek> here is a question
<derek>  resultset = datasource.createResultSet(conditions={"fisc_year": year})
<derek> works but how would i do something like 
<derek>  resultset = datasource.createResultSet(conditions={"fisc_year": year, "agency" : agency})
<derek> i.e. i need to add an AND in there
<jcater> and is implicit when you specify conditions that way
<derek> how would you do OR?
<jcater> you won't like the answer
<jcater> build a condition tree
<jcater> though we do support pass-thru sql now
<derek> hmmm
<derek> it doesnt like agency = '50%'
<derek> i.e. it doesnt do wildcards
<derek> or am i mistaken
<jcater> agency = '50%' and agency like '50%' are two different things
<derek> do
<jcater> hang on...
<derek> h
<derek> my bad
<derek> liking how easy it was started ignoring syntax :)
<dsmith> SachaS: fwiw it was broke for me too.
<SachaS> ok. dsmith, now is fine.
<jcater> yes, anon svn server was down
<derek> doh wait.. i didnt have option to specify
<dsmith> jcater: What did you restart?
<jcater> svnserve
<jcater> some day we should move that to inetd
<dsmith> ok
<jcater> fwiw, you could also do DataSourceWrapper(sql="""select foo from bar where name like 'dneig%'""")
<jcater> though that wouldn't work with appserver, et al
<jcater> I don't recommand that for cross-database projects
<jcater> but do use it internally
<jcater> you still get a resultset back
<jcater> for this script, that might be just as easy
<derek> i would like to do it "right" way
<derek> but if right way isnt implemented yet i could do the sql=
<jcater> right way is implemented
<jcater> you just don't get the convenience of the {} syntax
<derek> so how would you do right way
<jcater> hmm
<derek> if it is overly complex
<derek> i willuse sql=
<derek> but would that be
<jcater> easiest way may be to do createResultSet(conditions=GConditions.buildConditionFromDict({ ...}, coparison=GConditions.GClike))
<derek> DataSourceWrapper(connections, sql="""myquery""")
<derek> or
<jcater> c/coparison/comparison/
<derek> DataSourceWrapper(sql="""myquery""")
<jcater> the former
<derek> hmm GConditions not defined... guess we need an import statement
<jcater> yes
<jcater> gnue.common.datasources.GConditions
<derek> hmmm i spelled something wrong i think
<derek> doh its buildCondition not buildConditions
<derek> class GConditions has no attribute 'buildConditionFromDict'
*** dsmith has quit IRC
<derek> hmmm the code is there
<derek> def buildConditionFromDict (dictionary, comparison = GCeq, logic = GCand):
<jcater> oh
<jcater> what's your import?
<jcater> looks like you went one level too deep, and imported the GCondition class out of the GCondition module
<jcater> instead of importing the GCondition module
<derek> from gnue.common.datasources.GConditions import *
<derek> i tried
<derek> import gnue.common.datasources.GConditions
<derek> as well
*** dsmith has joined #gnuenterprise
<jcater> from gnue.common.datasources import GConditions
<derek> different error now
<derek> checking syntax
<derek> import problem fixed though
<derek> yeah its workign
<derek> other than the import was pretty simple
<derek> now i just need to load my dicts and im near golden
<derek> jcater: my problem i think is more complicated than i had hoped
<derek> as not only do i need
<derek> 3000
<derek>   3001
<derek>     3004
<derek> i need an additional value
<derek> how do you do elseif in python
<jcater> elif
<derek> doh
<derek> that explains why the 40 other combos i used didnt work :)
*** dsmith has quit IRC
*** jcater has quit IRC
*** kilo_ has quit IRC
*** jamest has left #gnuenterprise
*** sjc has left #gnuenterprise
<derek> has anyone seen btami or kilo
<derek> or know wheter svn for windows works?
*** reinhard has joined #gnuenterprise
<reinhard> hmmm
<reinhard> no jcater here
<reinhard> if anybody sees jcater
<reinhard> i think the gnue-common/src/cursing directory in svn misses at least one file
<reinhard> ScreenContainer.py seems to have been removed
<reinhard> and I see no other file taking over its parts
<reinhard> thanks
<derek> reinhard do you have winXP laying around?
<derek> or anyone for that matter?
<derek> i need fsutils.exe and linkd.exe
<derek> they ship on XP and are available on Win2k3 Free Reosource kit
<reinhard> i am in sweden, fsfe meeting
<reinhard> sitting on the floor in the living room of some guy here :)
<reinhard> off to sleep
<reinhard> l8r all
*** reinhard has quit IRC
<derek> i found fsutil.exe on xp but no linkd.exe
<derek> grrr
*** jcater has joined #gnuenterprise
*** tatoo has joined #gnuenterprise
<tatoo> hi everybody!
<jcater> Look Boss! The plane, the plane!
<jcater> hi
<SachaS> courier now working smoothly
<SachaS> :)
<SachaS> i used the duncan font in my terminal
<SachaS> and with my font
<tatoo> does anybody know a women's channel?
<tatoo> i'm not kidding
<tatoo> my girlfriend wanna know.
<SachaS> i could hardly see the difference between . and , : took me a while to catch it.
<SachaS> night all
*** SachaS has left #gnuenterprise
*** tatoo has quit IRC
*** dcmwai has joined #gnuenterprise
*** wayneg has quit IRC
*** wayneg has joined #gnuenterprise
*** holycow has joined #gnuenterprise
*** dcmwai has quit IRC
*** jcater has quit IRC
*** holy_cow has joined #gnuenterprise
*** holy_cow has quit IRC
*** _mixi_ has joined #gnuenterprise