*** wt has joined #gnuenterprise
<wt> anyone here?
<wt> jcater maybe?
<wt> guess no one
* ajmitch is around
<ajmitch> but probably can't help at all :)
<wt> well...if someone comes on, where can I donate?
<ajmitch> umm
<ajmitch> you could donate to me ;) but definitely ask derek, jcater, or one of the active core people
<wt> ajmitch: what do you do for the project?
<wt> ajmitch: I can't even seem to acquire ssh access to the svn
*** wt has quit IRC
*** holycow has joined #gnuenterprise
*** holycow has quit IRC
*** holycow has joined #gnuenterprise
*** wt has joined #gnuenterprise
<wt> w00t
*** wt has quit IRC
*** sjc has joined #gnuenterprise
*** ccfiel has joined #gnuenterprise
<ccfiel> heloo ppl!!! :D
*** reinhard has joined #gnuenterprise
*** btami has joined #gnuenterprise
<btami> good morning
<reinhard> good moring all
*** aries has joined #gnuenterprise
<aries> hi all
<aries> erm, the setup.py needs the pygettext, but I couldn't find it... On Mandrake, there's no python-i18n, -gettext, others, and it's not in the -devel
<reinhard> pygettext should actually be included in python
<reinhard> or python-devel
<reinhard> but as a workaround
<reinhard> you could edit po/Makefile
<aries> there's no such file, python-devel has installed
<reinhard> and replace "pygettext" by "xgettext --language=Python"
<reinhard> (but keep the --keyword!)
<aries> in the py2.1, there's a package python-tools, but nowadays this pack has disappeared
<btami> hi aries
<aries> btami: hi
* btami is away: i'm busy
<aries> Yesterday, I look inside in to the contribs and I don't understand something.
<aries> You use too much "string" var. types, like gnue_id
<aries> i think they should contains number values where they can
<reinhard> gnue_id is not guaranteed to contain only numbers
<reinhard> apart from that, I doubt all databases can DECIMAL(32)
<aries> reinhard: why can contain nonnumerical values?
*** holycow has quit IRC
<aries> reinhard: why can contain nonnumerical values?
*** ccfiel has quit IRC
*** btami has quit IRC
*** ccfiel has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** kilo has joined #gnuenterprise
<kilo> good morning
<kilo> hi ccfiel
<kilo> hi reinhard
<kilo> hi dimas
<kilo> hi aries
<ccfiel> hello kilo..
<ccfiel> :D
<kilo> hi, how are you?
<ccfiel> fine...how about you...
<ccfiel> :)
<ccfiel> it been long when i visited this IRC..:D
<ccfiel> how is gnue?
<ccfiel> gnuenterprise?:)
*** ccfiel has quit IRC
<kilo> aries: reading you rmail now, will answer that asap
*** ccfiel has joined #gnuenterprise
*** sjc has quit IRC
<reinhard> aries: we intend to use a UUID for gnue_id at some time
<reinhard> which is a 32 char hexadecimal number
<reinhard> i.e. a 128 bit number
*** johannesV has joined #gnuenterprise
*** ccfiel_ has joined #gnuenterprise
*** ccfiel__ has joined #gnuenterprise
*** ccfiel__ has joined #gnuenterprise
*** ccfiel has quit IRC
*** ccfiel_ has quit IRC
<aries> reinhard: in optimizing for performance, the data sizes should be register sizes. Eg on 64bit systems, the number values should be adjusted to 64bit
<reinhard> that would make data non-portable between different systems IMHO
<reinhard> wouldn't it?
<aries> i think not
<aries> it just a constraint about the sizes
<aries> 64bit long integers should be enough for a while :)
<aries> if it's matter, oracle using 64bit integers for primary keys
<aries> but I'll write an essey or a buggy implementation for CRM-ERP-etc and I try to answer this
<kilo> reinhard: code snippet from a procedure
<kilo> szamfejtesek = find('PAYROLL_Szamfejtes', {'PAYROLL_jogviszony': jogviszony}, [], [])
<kilo> ...
<kilo> for szf in szamfejtesek:
<kilo>   if szf.PAYROLL_haviAdo is None:
<kilo>     szf.PAYROLL_haviAdo = VEA/12 * len(szamfejtesek) - eddigiAdo
<kilo>     break
<kilo> 
<kilo> return szf.PAYROLL_haviAdo
<kilo> and then in the calling form:
<kilo> form.commit()
<kilo> and it complains about a non-null field being None. why?
<kilo> isn't szf referencing an existing PAYROLL_Szamfejtes object?
<aries> kilo: hi!
<kilo> hi
<reinhard> kilo: please change the
<reinhard> "if foo is None" to "if foo"
<reinhard> errr
<reinhard> "if not foo" of course
<reinhard> bbl lunch
*** btami has quit IRC
* aries hacked his mandrake with python-tools from python.org, there's no a clear mandrake solution for pygettext yet :(
<kilo> reinhard: thx. still not good
*** dcmwai has quit IRC
*** kilo has quit IRC
*** Amorphous has quit IRC
<aries> bye
*** aries has quit IRC
<johannesV> for the record: kilo, maybe you want to do the same test with all instances in the list (szamfejtesek) ... ?
*** jamest_ has joined #gnuenterprise
*** aries has joined #gnuenterprise
<aries> hi all
<aries> I've a problem with installing gnue-appserver
<aries> (cd ../..; echo "import src; print src.VERSION" | gcvs) >> version.texi
<aries> /bin/sh: line 1: gcvs: command not found
<aries> what is gcvs?
<aries> i can't find it
<reinhard> did you download from svn?
<reinhard> and if yes
<reinhard> did you run setup-cvs.py in common?
<aries> not yet :)
<aries> because I dl it from svn, not cvs
<reinhard> well
<reinhard> we didn't change the filename when we moved from CVS to SVN
<reinhard> sorry if that caused confusion
<aries> okay, nope
*** johannesV_ has joined #gnuenterprise
<jamest_> :)
<jamest_> reinhard: maybe that should be setup-devel.py
<jamest_> that way in the future we can switch to something else without confusion
<jamest_> of course we still have gfcvs gcvs etc etc
*** johannesV has quit IRC
*** aries has quit IRC
<dimas> reinhard: i'm still getting 'demoa' is not valid filter-value for 'base_company'
*** kilo has joined #gnuenterprise
*** wendall911 has joined #gnuenterprise
<reinhard> dimas: you have loaded the samples?
<reinhard> what form do you try?
<dimas> loaded
<dimas> appserver://appserver/form/base_company"
<reinhard> oh
<reinhard> i think i know what your problem is
<reinhard> your test database does contain other data?
<dimas> most probably not
<reinhard> because a property (base_currency) was removed from a class (base_company)
<reinhard> you would have to manually remove it from the class dictionary tables in the db
<reinhard> most easy way: dropdb and reload it again
<dimas> i just loaded base.gcd gl.gcd and demo.gsd
<dimas> i could try again from the beginning
<dimas> yep
<kilo> johannesV_: i search for a given object in the list, the only one with PAYROLL_haviAdo==null. and i want to store a number there. that works ok, but it does not commit changes, because it says that that object has a property null which should not be, although that property is not null for sure. seems like it acts on a not-exact copy of the original object
<dimas> reinhard: what is class dictionary tables?
<reinhard> gnue_property (for example)
<reinhard> but you can't use gnue_forms on them
<reinhard> like I said easiest way is drop db and reload from beginning
<dimas> does it work for you?
<dimas> dropped and reloaded
<dimas> same thing
<dimas> do you have authentication set on?
<reinhard> no
<reinhard> no auth
<dimas> i have --devug-level=8 on both sides and not any string after i hit login button
<reinhard> hmmm
<dimas> just message on login dialog
<reinhard> you have sample.gsd loaded, too?
<reinhard> I think I see a problem
<dimas> no
<dimas> if only i'm not connected to the wrong datasource
<reinhard> I think we hit a bug here
<reinhard> let me please test a few things
<dimas> will it drive to yet another dirtyread rewrite?
<dimas> j/k
<reinhard> you have no sample.gsd?
<reinhard> so actually your base_company table is empty?
<dimas> where it should be?
<dimas> there is demo.gsd
<dimas> with demoa as base_company code
<dimas> base/demo.gsd
<johannesV_> kilo, will look at it later ... (as i'm about to change NullObject anyway)
<johannesV_> anyway, have to leave for a short while now
<kilo> ahm, ok, thx. wont be around really for some hours
<reinhard> dimas: can you please check with psql if your base_company table is empty?
<reinhard> err sorry i meant demo.gsd
<reinhard> did you load demo.gsd?
<dimas> yes load
<dimas> loaded
<reinhard> ok
<dimas> gnue=# select * from base_company;
<dimas>  base_code |          base_name          |             gnue_id              |   gnue_createdate   | gnue_createuser |   gnue_modifydate   | gnue_modifyuser
<dimas> -----------+-----------------------------+----------------------------------+---------------------+-----------------+---------------------+-----------------
<dimas>  demoa     | Austria Elektrohandels-GmbH | 91094290434119931310213246688146 | 2005-01-06 15:03:58 |                 | 2005-01-06 15:04:20 |
<dimas> (1 запись)
<reinhard> it should work then if you enter demoa in your login dialog
<nickr> thats a big id number
<reinhard> dimas: can you please edit gnue-common/src/datasources/drivers/appserver/appserver/Connection.py?
<dimas> wait a minute
<reinhard> line 202 "vDict = item [3][masterkey]"
<reinhard> after that add "print field, vDict"
<dimas> gnue_id [{'gnue_id': '91094290434119931310213246688146'}]
<dimas> is that it?
<reinhard> ah
<reinhard> aaaaaahhhhhhhhh
<reinhard> you didn't read in the gld files?
<dimas> sure not
<reinhard> ok
<reinhard> you should
<reinhard> and we probably should improve the behaviour if people forget...
*** bigbrother has joined #gnuenterprise
*** bigbrother` has joined #gnuenterprise
<reinhard> dimas: when (and where) does that happen?
<reinhard> and does it stop actually?
*** bigbrother has quit IRC
*** agile has quit IRC
<reinhard> we use dictionaries with empty string as key
<dimas> test one more
<dimas> reinhard: it works with py_xmlrpc on python2.2
<reinhard> ok
<reinhard> what was your other test?
<reinhard> where it didn't work?
<dimas> error was with pw_xmlrpc when calling form, before login screen appeared
<reinhard> with python 2.2?
<dimas> yep
<reinhard> ok
<reinhard> thanks
<reinhard> interesting
*** agile has joined #gnuenterprise
<reinhard> pw_xmlrpc 2.2 seems to not like empty dictionary keys
<reinhard> while py_xmlrpc 2.2 and pw_xmlrpc 2.3 get along with it
<reinhard> I think we would have to fix that somehow
<dimas> reinhard: why gld is so important at this point?
<reinhard> to define which of the fields of base_company should be asked
<reinhard> base_company has several fields
<reinhard> code, name, could have even more
<reinhard> so forms has to know whether the user should enter a code or a name
<dimas> it's what i did not get before
<reinhard> without gld it was undefined
<reinhard> so forms expected you to enter the gnue_id of the company
<dimas> search="100" what 100 means here?
<reinhard> it's the order
<dimas> ok
<reinhard> it's not active yet but
<reinhard> we planned to extend the login dialog at some point
<reinhard> to allow for several dropdowns per questino
<reinhard> so for "Company:" you would have a dropdown with all the codes
<reinhard> and another dropdown with all the names
<dimas> i would like to provide default values for filters and ability to exclude it from login dialog
<reinhard> in connections.conf [appserver] section
<reinhard> you can do
<reinhard> base_company=demoa
<reinhard> but currently it only helps if you define *all* login dialog fields
<dimas> great
<dimas> will try that
<dimas> reinhard: round proc is working like that
<dimas> >>> ru=0.01
<dimas> >>> x=23.47+ru/2
<dimas> >>> x
<dimas> 23.474999999999998
<dimas> >>> int(x/ru)*ru
<dimas> 23.469999999999999
<dimas> >>>
<reinhard> ouch
<reinhard> >>> x = 23.47
<reinhard> >>> x
<reinhard> 23.469999999999999
<reinhard> it's not exactly a problem of the round procedure...
<dimas> ok
*** holycow has joined #gnuenterprise
<johannesV_> reinhard, this is a number you can't express correctly using binary system
<reinhard> yes
<johannesV_> like x = 0.1
<reinhard> I even think it's not a problem for us
<reinhard> I *hope* the db would store it correctly in a DECIMAL (9.2) field
<johannesV_> haven't looked at that till now
<johannesV_> but i can add it onto my *todo* list :)
<johannesV_> i'm off again but will bbl
<johannesV_> looks like i can commit the null_first_asc/dsc option for appserver today, as well as an improved version of NullObject
<johannesV_> but the latter one is still in test-cycle
*** btami has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** kilo has quit IRC
*** kilo has joined #gnuenterprise
*** kilo has quit IRC
*** kilo has joined #gnuenterprise
*** johannesV_ has quit IRC
*** jcater has quit IRC
*** johannesV has joined #gnuenterprise
*** johannesV_ has joined #gnuenterprise
*** btami has quit IRC
<johannesV> kilo, are you still there ?
*** btami has joined #gnuenterprise
*** sjc has joined #gnuenterprise
*** suitable has joined #gnuenterprise
*** jcater has joined #gnuenterprise
<johannesV> for the record: kilo, please svn-up and try it again
<johannesV> off for today
*** johannesV has left #gnuenterprise
*** SachaS has joined #gnuenterprise
<SachaS> i see unittest in appserver directory
<SachaS> :)
<SachaS> ohh that is gnue-commons sorry
*** jamest_ has left #gnuenterprise
<reinhard> night all
*** reinhard has left #gnuenterprise
<btami> good night
*** btami has quit IRC
*** SachaS has quit IRC
<mnemoc> hi, what's the standard --connection=foo or --database=foo?
<jcater> --connection
<jcater> where do you see --database ?
<mnemoc> appserver
<kilo> it depends
<jcater> hmm
<mnemoc> at least on the win32 version available on the site
<jcater> then they may be 2 different things
<mnemoc> but real database is specified on connections.conf isn't it?
<jcater> I know gnue-common deprecated --database a long time ago, but appserver may still use it for something else
*** jamest_ has joined #gnuenterprise
<mnemoc> i tryed --connection and it screamed
<jcater> mnemoc: I'm not sure about appserver
<jcater> sorry
<mnemoc> is it normal that gnue-schema say nothing always?
<kilo> appserver uses --database, and that corresponds to the backend database appserver should use, as defined in the connections.conf
<kilo> you can see several examples for that in gnue-contrib
<mnemoc> psycopg instead of gnue?
<kilo> not the provider, the db itself
<mnemoc> oh
<mnemoc> gnue-schema.exe does nothing :(
*** suitable has left #gnuenterprise
<kilo> what do you want it to do?
<mnemoc> create schema needed by appserver
<mnemoc> bin\gnue-schema.exe --conection=socomep share\gnue\appserver\gnue.gsd <--- no output, no tables created
<kilo> hmmm, will report to btami tomorrow. i guess all paths are valid, and 'connection' includes 3 'n' characters
<mnemoc> good point
<mnemoc> what's the --help argument? --help -? -h /? /h show nothing
<jcater> --help iirc
<mnemoc> :\
<kilo> dunno about windozie version
<kilo> but should be --help, as jcater said
<mnemoc> --help works for gnue-appserver
<mnemoc> i don'0t know python, can i add something somewhere to see what it is doing and where it is failing? (trace or something)
<kilo> --debug-level=10
<mnemoc> no output!
<mnemoc> :\
*** holy_cow has joined #gnuenterprise
<mnemoc> i guess i'll have to install python on the server :'( ... without boss notice it
<kilo> no, you can use it completely locally
<mnemoc> that was what i was trying to do, but this silent gnue-schema is not helping my 'newbie experience'
<mnemoc> gnue-appserver tries to start but 'DB000:  ProgrammingError: relation "gnue_module" does not exist'
<kilo> that's ok, since you dont have the system database, that gnue-schema should build up
<kilo> i cannot start a windows machine now, sorry, but will try it tomorrow
* mnemoc wants strace for win32 :(
<kilo> you only want to build up the main - or system - database for appserver?
<mnemoc> that's my start point i guess
<mnemoc> do you have sql for postgres to do that?
<kilo> in fact we use interbase/firebird, not postgres.
<mnemoc> :(
<kilo> is your connection.conf set up ok, and are you sure gnue-schema tries to read that conf file, not some other?
<mnemoc> i 'next next next' those .exe --> http://www.gnuenterprise.org/downloads/current.php
<mnemoc> and modify connections.conf
<mnemoc> at least gnue-appserver is happy with my changes
<mnemoc> i'll try installing -debug.exe-s
*** holycow has quit IRC
<mnemoc> kilo: gnue-common-debug.exe gives output :)
<mnemoc> and works
<kilo> and does gnue-schema work?
<mnemoc> uhm, no
<mnemoc> DB000:    File "C:\Archivos de programa\GNUe\bin\gnue\common\datasources\driver\postgresql\Schema\Discovery\Introspection.py", line 77, in find
<mnemoc> DB000:  TypeError: iteration over non-sequence
<mnemoc> DB000:
<mnemoc> is that my fault?
<mnemoc> Introspection.py:77      for rs in cursor.fetchall ():
<kilo> what version of postgresql do you use?
<mnemoc> 8rc2
<kilo> i ask only for reporting the error...
<kilo> and which driver?
<mnemoc> i installed none, but connections.conf has psycopg as provider
<mnemoc> pypgsql worked
<kilo> did you follow http://www.gnuenterprise.org/cgi-bin/twiki/view/Main/WindowsQuickStart ?
<mnemoc> it looks outdated, because you now provide: gnue-runtime-environment-2004.07.31.exe
<kilo> hmmm, ok, will modify it then, thx for the info
<kilo> 'pypgsql worked' - what does that mean?
<mnemoc>   updating table 'gnue_parameter' ...
<mnemoc>     Rows: 4 inserted, 0 updated, 0 unchanged.
<mnemoc> pygresql is not installed and psycopg gives the "iteration over non-sequence" error
*** jamest_ has left #gnuenterprise
<kilo> have you tried pypgsql?
<kilo> http://pypgsql.sourceforge.net/
<mnemoc> it created the tables, that was my only test
<mnemoc> 2003-07-16: pyPgSQL 2.4 released! <--- is it alive?
<kilo> well, i have a 31-yr old wife, and she still works 8-)))
<mnemoc> :D
<kilo> in the irc log for 2004-12-21, btami said "just tried win32 packages, pypgsql is working with"
<mnemoc> at least i'm not the problem :p
<kilo> and also on 2004-12-23
<kilo> <btami> dimas: i find that the psycopg module in setup exe is for pg 7.4, so
<kilo> <btami> you have to overwrite the psycopg.pyd in installed bin dir from
<kilo> <btami> http://stickpeople.com/projects/python/win-psycopg/win-psycopg23.zip
<kilo> <btami> it's for 7.3
<kilo> <dimas> great
<kilo> <dimas> will try now
<kilo> <btami> provider = pypgsql is ok for me too
<kilo> *** ra3vat has quit IRC
<kilo> *** jcater has joined #gnuenterprise
<kilo> <dimas> btami: it works with psycopg now
<kilo> *** holycow has joined #gnuenterprise
<kilo> <dimas> btami: thanks
<kilo> <dimas> with pypgsql also works
<kilo> if you try with older versions of Postgresql
<kilo> like 7.3
<kilo> 
<kilo> and
<kilo> 
<kilo> <btami> dimas: just tried win32 packages, pypgsql is working with
<kilo> <btami> postgresql 8.0 RC1 on XP
<kilo> <btami> psycopg fails
<kilo> <btami> tryed with appserver's sample.gfd
<kilo> 
<kilo> so i think you should try pypgsql
<kilo> @monologue
<bigbrother`> kilo: Your current monologue is at least 26 lines long.
<kilo> wow
<kilo> @roulette
<bigbrother`> kilo: *click*
<kilo> huh
<ajmitch> hehe
*** kilo has quit IRC
*** lxf has joined #gnuenterprise
*** mmealling has joined #gnuenterprise
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** sjc has quit IRC
*** holy_cow has quit IRC
*** lxf has quit IRC
*** holycow has joined #gnuenterprise
*** dcmwai has joined #gnuenterprise
*** booyaa has joined #gnuenterprise
*** booyaa has left #gnuenterprise