*** reinhard has joined #gnuenterprise
*** btami has joined #gnuenterprise
<btami> good morning
*** sjc has joined #gnuenterprise
*** rynik has joined #gnuenterprise
<rynik> good morning
*** johannesV has joined #gnuenterprise
*** kilo has joined #gnuenterprise
<kilo> good morning
*** btami has quit IRC
*** aries_mindworks has joined #gnuenterprise
<aries_mindworks> hi
<kilo> haho
<johannesV> hi
*** btami has joined #gnuenterprise
<aries_mindworks> if I want to do an "SQL-query", how can i do it in gnue? Eg: I have a table, which stores the relation between two other tables' records
<aries_mindworks> like customers - email - email types
<aries_mindworks> email stores the email address,  the type's ID and customers ID
<aries_mindworks> kilo, johannesV: hi
<aries_mindworks> how can i do it,
<aries_mindworks> ?
<aries_mindworks> a hard question :)
<btami> what is your goal with that "SQL-query"?
<btami> is this a form question?
<aries_mindworks> btami: hi! to show in a new tab the customer's email addresses
<btami> or appserver?
<btami> btw. hi :)
<aries_mindworks> btami: i use appserver
<btami> use master-detail
<btami> datasources
<aries_mindworks> erm, in gcd?
* aries_mindworks don't see the gnue's fetures through
<btami> look at zip3tier in gnue-contrib
<btami> it's a minimalist example
<aries_mindworks> looking
<btami> it's a 3-tier version of zipcode sample from gnue-forms
<aries_mindworks> ahhaaa
<aries_mindworks> i see
<aries_mindworks> thanks
<btami> np
<aries_mindworks> on my grave you'll see one sentence: the man, whose want to learn how gnue works in his whole life
<aries_mindworks> :D
<btami> lol
*** dimas has quit IRC
*** johannesV has quit IRC
*** johannesV has joined #gnuenterprise
*** sjc has quit IRC
*** aries_mindworks has left #gnuenterprise
<kilo> docelic: committed your changes to DevGuide (also added a little bit on debug levels)
<kilo> thx for your contribution, great work
<btami> bbl
*** btami has quit IRC
<rynik> kilo: Is the new version of the DevGuide allready on the web or will it take a while?
<kilo> it is in svn
<kilo> iirc it should be updated on the webpage manually
<kilo> which someone has to do
<kilo> someone!
<kilo> someone?
<kilo> ok, i'll do...
*** mnemoc_ has joined #gnuenterprise
<kilo> rynik: i scp-ed it there, in some minutes it will be available
*** mnemoc has quit IRC
*** kilo has quit IRC
*** dcmwai has joined #gnuenterprise
*** jamest_ has joined #gnuenterprise
*** johannesV_ has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** titopbs has joined #gnuenterprise
*** dcmwai has quit IRC
*** johannesV has quit IRC
*** SachaS has quit IRC
*** titopbs has quit IRC
*** dimas has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
<mnemoc_> hi, there is any example about how to use dbf or csv on a GClientApp?
*** titopbs has joined #gnuenterprise
*** jcater has joined #gnuenterprise
<reinhard> mnemoc: please be aware that both dbf and csv are read only
<reinhard> and I'm not really sure how functional these drivers are in the last release (I rewrote them completely meanwhile)
<reinhard> but basically they should work like any other backend
<reinhard> they have a file=.. parameter in connections.conf
<reinhard> and you don't have to pass a table
<mnemoc> where on API should i look for functions to get available tables and fields?
<mnemoc> i want to migrate from dbf to appserver
<reinhard> GIntrospection
<reinhard> but tables you will need to know yourself
<reinhard> (AFAICT, every dbf file is a table)
<mnemoc> yep
<mnemoc> i was just wondering for the tests :)
<mnemoc> i have never coded python apps
<mnemoc> reinhard: file= .... that means i have to do a connection for each .dbf... there is any better way considering i have to loop over around 25 .dbf-s?
<mnemoc> i thought initial you handled the dir as 'database' and .dbf as tables
*** jamest_ has left #gnuenterprise
<docelic> thanks kilo, cya later folks
*** docelic has quit IRC
*** titopbs has quit IRC
*** jamest_ has joined #gnuenterprise
<mnemoc> aha... i'll generate a connections.conf file using bash :)
<mnemoc> i have 72 months x 26 tables to import :\
*** SachaS has quit IRC
<johannesV_> hmm, i think the approach using a dictionary 'as database' and all files in there as tables is a good idea
<johannesV_> erm, sorry
<johannesV_> i meant a directory
<johannesV_> damn, i'm to pythonic in my thoughts ...
<johannesV_> looks like i'm doing to much gnue-stuff ... :)
*** johannesV_ has quit IRC
<mnemoc> :)
<mnemoc> there can be file= to preserve current behavior and dbname= for directory based
*** kilo has joined #gnuenterprise
*** wendall911 has joined #gnuenterprise
*** sjc has joined #gnuenterprise
*** titopbs has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
<mnemoc> DB000:  LoadError: Cannot load plugin dbf
<mnemoc> DB000: The following plugins failed:
<mnemoc> DB000: * gnue.common.datasources.drivers.dbf.dbf: ImportError: No module named dbf
<mnemoc> what am i missing?
*** sjc has quit IRC
<mnemoc> gnue-common 0.5.14
<mnemoc> reinhard: awake?
<reinhard> mnemoc: back
<reinhard> mnemoc: you need a dbf python module, I think the source contains an URL where you can get it
<reinhard> "http://schwinger.harvard.edu/~mspal/pystuff/dbf.txt"
<mnemoc> broken
<reinhard> mnemoc: exactly the dir=db approach will be supported in next release
<reinhard> oh
<reinhard> bad :(
*** jamest_ has quit IRC
<mnemoc> ok, if i use svn... what should i do on my GClientApp to use _that_ libraries instead of system ones?
<reinhard> without that link given above the svn version won't work either :(
<mnemoc> outch
<reinhard> maybe you can find out where it has moved to
<mnemoc> ~mspal still there
<mnemoc> full of family pictures
<mnemoc> http://ftp.madnom.com/kldp/download/dbf2sql/dbf.py <--- looks correct or it will kill my pet?
<reinhard> hmmm
<reinhard> I'd say give it a try
<reinhard> (after making a backup of your data) :)
<mnemoc> :(
<reinhard> I think the last person really using the dbf driver left the project 3 years ago or so
<mnemoc> oh
<mnemoc> why don't you adopt it?
<reinhard> I don't need it
<mnemoc> gnue i mean
<mnemoc> you told me even cvs version depends on it
<reinhard> and I am not motivated in putting effort into supporting a format of a proprieatary database
<mnemoc> ic
<reinhard> if the time comes we will need it ourselves
<reinhard> or we will get paid for some project needing it
<reinhard> johannesV stands in line for reimplementing the whole dbf stuff
<reinhard> but for now we have to set our priorities
<reinhard> and in doubt we set priorities for free software
<reinhard> and free backends
<mnemoc> or masking :)
<reinhard>  good night all
*** reinhard has quit IRC
<mnemoc> AttributeError: Connection instance has no attribute 'defaultBehavior' ?
<mnemoc> uhm... he left :(
*** jcater has quit IRC
*** cilkay has joined #gnuenterprise
*** cilkay has left #gnuenterprise
*** kilo has quit IRC
*** jcater has joined #gnuenterprise
*** jcater has quit IRC
*** titopbs has quit IRC
*** titopbs has joined #gnuenterprise
*** ajmitch_ has quit IRC
*** ajmitch_ has joined #gnuenterprise
*** dcmwai has joined #gnuenterprise
*** dcmwai has quit IRC
*** dcmwai has joined #gnuenterprise