man my birthday is coming up real soon now Action: chillywi1ly feels old ;) ok, I've got a question for the SQL wizards in here. shoot ;) does anyone mind if I paste my schema first, it's about 10 lines. (not counting the indexes, which I really don't need to paste) cursor.execute("""CREATE TABLE words ( id INTEGER PRIMARY KEY, word TEXT UNIQUE ON CONFLICT IGNORE )""") cursor.execute("""CREATE TABLE word_stats ( id INTEGER PRIMARY KEY, word_id INTEGER, user_id INTEGER, count INTEGER, UNIQUE (word_id, user_id) ON CONFLICT IGNORE )""") I'm keeping stats on how often users have said any of the words in the words table. so my questino is what's the most efficient way to update this table, if I have a list of words the user just said? hmmm Action: jemfinch can paste what he's doing now, though it's in Python. it's another 8 lines. ah, shoot, what I'm doing doesn't work, either. ah, it does (though I haven't tested it) create a dict of worsds w/ counts for the user, select that word..if word exists update the (count + whatever), otherwise insert the row(s)...I dunno ;) Action: jemfinch will paste what he's doing. of course you join the 2 tables criteria = ['word=%s'] * len(words) criterion = ' OR '.join(criteria) cursor.execute("SELECT id, word FROM words WHERE %s"%criterion, *words) for (wordId, word) in cursor.fetchall(): cursor.execute("""INSERT INTO word_stats VALUES(NULL, %s, %s, 0)""", wordId, id) cursor.execute("""UPDATE word_stats SET count=count+%s WHERE word_id=%s AND user_id=%s""", words.count(word), wordId, id) Action: chillywi1ly python is rusty you could do, cursor.execute("SELECT id, word FROM words WHERE word IN (%s), ','.join(words)) I think...bah they have to be qutoed ah, good, it works. oh, that's true. I wonder which is faster. chillywi1ly: they way to do that so they get quoted is this: criteria = ['%s'] * len(words) criterion = 'IN (%s)' % ', '.join(criteria) cursor.execute("SELECT id, word FROM words WHERE %s" % criterion, *words) yea the count for a word is initially 0? your code looks fine to me yeah, it works :) that's all that matters ;) if you can think of a more efficient way to do it, lemme know...I thought about inserting from a select statement, but I dunno. I don't think I can avoid iterating over the words in the words table in Python. chillywi1ly: Hey my birthday is also comming :) chillywi1ly: Mine is on 13rd when is your... mdupont (mdupont@p5080E981.dip0.t-ipconnect.de) joined #gnuenterprise. FredFrog (FredFrog@199.243.96.229) joined #gnuenterprise. dcmwai: Nov. 10th jemfinch (~jfincher@dhcp065-024-075-056.columbus.rr.com) left #gnuenterprise ("Client exiting"). chillywi1ly: We are Very Near ... :) reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise. Nick change: SachaAwaz -> SachaS chillywi1ly: you are redoing the appserver i hear? dimas (~dimas@195.218.177.46) left irc: Read error: 110 (Connection timed out) mdupont: uh, no :) Nick change: mdupont -> md-work siesel: awaken yet? Action: siesel is wake, but looking for children today hi hi chillywilly. how's scotty? he's doing good FredFrog (FredFrog@199.243.96.229) left irc: fine. Nick change: siesel -> siesel-shopping- children? lol. dcmwai you have to share siesel with his children ;) SachaS: We always share everybody isn't that right :) true :) SachaS: But most of the time... We didn't want to... The server returned an error (1): exceptions.AttributeError:'module' object has no attribute 'supportedDataObjects' does this message meant anything to you... Meanning not database support or... em.. anyone can tell me did the gnue-common came with the mysql database support? yes gnue-common supports mysql Could not load MySQLdb. For MySQL support, please install mysql-python 0.9.0 or later fromhttp://sourceforge.net/projects/mysql-python Error: No module named MySQLdb reinhard: what is wrong with it? reinhard: did you think that this is the answer? siesel-shopping- (jan@xdsl-213-196-192-25.netcologne.de) left irc: Read error: 104 (Connection reset by peer) http://sourceforge.net/forum/forum.php?thread_id=964249&forum_id=70461 reinhard: hello ... dcmwai: sorry was not looking i think you need to install mysql-python what distribution do you use? Redhat reinhard: I think I suppose to be with it? reinhard: I think "this" suppose to be with python? i think it's a separate package reinhard: Someone is going to kill me for installing so many packages To just get an "REPORT" server running :( siesel-shopping- (jan@xdsl-213-196-195-138.netcologne.de) joined #gnuenterprise. Hum ... login deny.. Action: dcmwai will solve this soon s/soon/later hi reinhard Action: SachaS wants to do 1000 things Action: SachaS gets done 0 (maybe 1 ;) SachaS: thats's ok Action: reinhard *does* 1000 things thanks that's much worse :) Action: SachaS is jealous I'd rather do 1 thing right than 100 things half-done thats also true well back to ... do nothing ;) not true ;) :) btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) dcmwai (~dcmwai@219.95.173.165) left irc: Remote closed the connection Nick change: siesel-shopping- -> siesel FredFrog (FredFrog@199.243.96.235) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. brb reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: "Never wrestle with a pig. You both get dirty and the pig likes it." reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise. dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Connection timed out FredFrog (FredFrog@199.243.96.235) left irc: btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: ajmitch_ (~ajmitch@wlg1-port14.jetstart.maxnet.co.nz) joined #gnuenterprise. siesel (jan@xdsl-213-196-195-138.netcologne.de) left irc: "Client exiting" ajmitch (~ajmitch@wlg1-port30.jetstart.maxnet.co.nz) left irc: Read error: 110 (Connection timed out) siesel (~jan@xdsl-213-196-193-120.netcologne.de) joined #gnuenterprise. thierry (~thierry@musashi.xtensive.com) left irc: Read error: 110 (Connection timed out) thierry_ (~thierry@musashi.xtensive.com) joined #gnuenterprise. Nick change: md-work -> mdupont lxf (~agus_tea@202.73.120.39) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. lxf (~agus_tea@202.73.120.39) left irc: Read error: 54 (Connection reset by peer) mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. dcmwai (~dcmwai@219.95.58.204) joined #gnuenterprise. hello all :) jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise. hi dcmwai, hi jamest jamest: I've some questions to the master of the GTrigger code :) Action: siesel hopes he doesn't mix up again which is jcater and what is jamest's work :) do you have ca. 5 minutes time? i can try I'm beginning to split the GTrigger code into language specific and trigger specific parts to archive two goals: 1. make it easy to reuse from appserver 2. add new trigger languages first an naming issue: what do you think about putting the language specific stuff in subdirectorys of gnue/common/logic/connector like gnue/common/logic/connector/python/ ToyMan (~stuq@smtp.dstoys.com) got netsplit. chillywi1ly (danielb@CPE-24-167-193-166.wi.rr.com) got netsplit. jamest (~jamest@gw.math.ksu.edu) got netsplit. mcuria (~maxy@29-185-89-200.fibertel.com.ar) got netsplit. Stoke (~stoker@dpvc-141-149-254-50.buff.east.verizon.net) got netsplit. wtg (~merlinx@ppp190-50.lns1.bne1.internode.on.net) got netsplit. SachaS (~sacha@online.havanawave.com) got netsplit. jelque_ (~jelque@adsl-65-71-148-18.dsl.ltrkar.swbell.net) got netsplit. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) got netsplit. gnue/common/logic/connector/ECMAscript etc. Action: siesel hates netsplits LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) returned to #gnuenterprise. jelque_ (~jelque@adsl-65-71-148-18.dsl.ltrkar.swbell.net) returned to #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) returned to #gnuenterprise. chillywi1ly (danielb@CPE-24-167-193-166.wi.rr.com) returned to #gnuenterprise. wtg (~merlinx@ppp190-50.lns1.bne1.internode.on.net) returned to #gnuenterprise. SachaS (~sacha@online.havanawave.com) returned to #gnuenterprise. jamest (~jamest@gw.math.ksu.edu) returned to #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) returned to #gnuenterprise. Stoke (~stoker@dpvc-141-149-254-50.buff.east.verizon.net) returned to #gnuenterprise. etc. jamest: could you read everything? or should I repeat? jbailey (~jbailey@atlas.fundserv.com) joined #gnuenterprise. huh? the only line i got was do you have ca. 5 minutes time? which i read in it's entirety :) oops, I really hate netsplits I'm beginning to split the GTrigger code into language specific and trigger specific parts to archive two goals: 1. make it easy to reuse from appserver 2. add new trigger languages first an naming issue: what do you thin k about putting the language specific stuff in subdirectorys of gnue/common/logic/connector like gnue/common/logic/connector/python/ gnue/common/logic/connector/ECMAscript etc. Action: dcmwai will be back after bath why connector? I thought about language connector. I don't want to use "driver". Do you have a better name? not off the top of my head just that connector makes me think of networking for some reason same could be said for logic/interface I thought of adding a "remote connector" which calls the trigger on the application server and nothing application specific is going in there right? no. IIRC the trigger stuff is finally app neutral all the forms baggage is gone Action: siesel is testing changes with reports now. :) :) cool reports triggers are working? yes. Action: jamest started to add them long ago but stopped i'm good at that :) :) Even the ECMAscript ones :) that connector name just feels odd They are just missing namespace support. but I can't think of a better one the other change I planned was to add a procedure type, because the triggers we have now, are very similar to methods. and when you say language specific /vs trigger specific are you talking about the execution code in the trigger code yes, its mostly the setFunction code in GTrigger and the namespace constructor the namespace issue i haven't started, i like the split idea Because I don't know if the current code is generic enough it was something we wanted long ago but have been too lazy to implement the namespace stuff is very python specific i wouldn't even know where to start with some other language so we'd end up with a generic trigger system that manages triggers there are functions to globaly bind python objects into the ECMAscript namespace, so probably a simple bind_object(globalns) is sufficient and language specific execution and namespace logic is that what you're saying? and we can keep using the nowadays namespace code. But for other languages we probably need a total split up as you said. what will the procedure type do? vs the methods It won't have a "self" method, i.e. it will just have a global namespace. hmmm, and how will this impact the way we define trigger namespace extensions in internal gnue objects It should not have any. probably we don't need this procedures, .. but they will be easier to implement in other languages, ... I thought of doing making procedures the base object and by inheritation create a "method" object. ok Action: jamest just found the emails on the main list about this reading...... ok i'm ok with all of this seems like we're finally going to get multilanguage trigger support :) go siesel! man why can't these appserver guys keep their hands out of common ;-) common is a form of gnue crack you get a small hit for free then paying for it in devel time for months to come yeah it's like the joint we all share and pass around reinhard: you canadian? *rofl* lol =) you guys are making want to gnue again s/want/me want damn customers! paying me money to do java you want the joint passed along to you? nah i know where it's been lol on the remote call at one time i was trying to think of a way to make that trasparent to the end user in an optional mannor jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. that probably made no sense which remote call? you mean remote trigger? yes so that a trigger could be ran either from the appserver or from the frontend client depending on the functionality of the client i don't know if that is still worth even thinking about morning mr cater IMHO it makes sense for some clients (like the ECMAscript one) siesel and reinhard are hooked on the gnue-crack^H^H^H^Hommon the plan worked /rename jamest "Dr. Evil" :) lol Action: jamest puts pinky to the side of mouth I demand 1 billion commits! rofl lol (just make sure they're in stuff jcater's working on) what's the state of common now anyway did all jcater's stuff get commited nope life hit me hard so it's still branched Action: jcater really wants to get it committed Action: jamest really wants jcater to get it committed /msg jamest so then I can trick siesel into maintaining it err, um sigh that's what I used to do with you it brings back memories Action: jcater has this aweful, burning desire to work heavily on gnue-reports but am making myself NOT do that until the common stuff is finished and committed commit the connection stuff please :) pooh. Action: jcater grunts as I assume this will let me use our connection objects sans datasources? yes, please finish the branch :) as application server will need it urgent :) jamest: yes does it provide a sql passthru? siesel: I might be able to work on it this afternoon, actually jamest: actually, that's why I started doing it in the first place because I wanted to add sql pass-thru support to datasources for gnue-sql but you know how that goes first one change, then another, which leads to another and I assume it has access to the standard login handlers then yes commit it Action: jamest begs of you i've got way too many gnue-common apps i kludge login support into ? i use python db drivers directly which means all the login crap repeated in each app to setup/tear down the connection jcater: thats great jcater: short question about triggers: do you know a better name for directory with the language specific parts? I've choosen gnue/common/logic/connector/(python|ECMAScript|..) for now. gnue-common/logic/language/python gnue-common/logic/langdep/python gnue-common/logic/python I thought about the last one too. i like them being in a subdir as then we can have a language/base unless logic is the subdir i guess ok, so which name to use? i like reinhards suggestion of language but i understand how that would work with your remote connector plans oh, we could just make that remote connector a seperate thing. on a side note so I agree on language then. currently the code in the "logic" subdirectory in common seems to be quite XML centric reinhard: ? well i don't understand it completely but it seems to me that the code does both loading the trigger code from an xml file as well as then executing it it was more a hint for siesel :) because what we need in appserver is more or less only a way to execute code we already have it's got ties into the GParser system and that hasn't got to do anything with XML files I left the xml code in GTrigger.py and appserver will directly access the language specific code. but I don't recall anything requiring trigger instanances be created from an xml file i would think you could create an instance of a trigger in pure code or via some other markup language ok it was just a spontaneous feeling from a first view on the code we had the same game with the datasources ? where we had to "fake" some things because we don't have an underlying xml structure but we worked it out and it was no problem at all i guess it will be the same for triggers reinhard, I'm not quite shure how to do it in the end. Everything depend on how we implement the namespace concept how do you define datasources in appserver ? there is a gdatasourcehelper which builds the GDatasource object out of a list of attributes yes jamest: we do attributes = {} attributes ["name"] = "" attributes ["database"] = self._session.database attributes ["table"] = self._classdef.table if self._sortColumns != []: attributes ["order_by"] = string.joinfields (self._sortColumns, ",") # create the datasource self._datasource = GDataSource.DataSourceWrapper ( connections = self._session.connections, attributes = attributes, fields = self._prefColumns) and the DataSourceWrapper was created by siesel (jcater?) to help with that without that we had to fake an XML tree in memory IIRC or something like that I don't quite remember ah, ok, gotcha yes these things do expect to be created via a GParser so that's the simplest method of using them reinhard: it was jcater. :) however it's usable outside that namespace construction however is going to expect a valid GObj tree where do you currently define your datasources? or how? we create them on the fly depending on the request appserver gets from the front end ah ok Action: jcater plans on doing a real DataSourceManager as part of this cleanup though appserver works so differently than the client tools that it may or may not be beneficial for y'all mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. jelque_ (~jelque@adsl-65-71-148-18.dsl.ltrkar.swbell.net) left irc: Read error: 54 (Connection reset by peer) wendall911 (~wendallc@198.31.172.218) joined #gnuenterprise. Action: dcmwai think it is hard to design grd... I think the plan is to eventually be able to do that in designer Vee, Ah.. that is a very Good idea :) siesel, something about the gnue-report server siesel, how we provided username and password for the database grdcvs -u username -p password? Or We do it on the client site (phpxmlrpc) almost: no, its right, but you can use the long form --user --password too its on server side siesel, can we do it on the client (phpxmlrpc) there yes, that's possible too. but need some code changes siesel, The code change is on gcomm.php ? or grdcvs? in grdcvs. You have to change the loginhandler siesel, would it be difficult? hmmm, not necessarily. siesel, Because I'm having a hard time to get grdcvs to connect to the mysql (aria DB) using the same foobulations sql ;) DB000: return apply(Connection, args, kwargs) DB000: File "/usr/lib/python2.2/site-packages/MySQLdb/connections.py", line 58, in __init__ DB000: self._db = apply(connect, args, kwargs2) DB000: TypeError: connect() argument 2 must be string, not None dcmwai (~dcmwai@219.95.58.204) left irc: "Client exiting" dcmwai (~dcmwai@219.95.58.204) joined #gnuenterprise. but it would mean to have different GConnection objects. damn xchat... quit without a Prompt.. :( that seems to be a mysql problem. but it run when using grcvs sure a username and password prompt is there hmmm. get in and have a try on monthly3.grd dcmwai: can you try to pipe the output of the report server to a file like /tmp/reportlog? sure siesel, what is the command to pipe all error isn't that &> could be, I'm not shure :) 2>/dev/null or 2>&1 to send errors to standard stream dcmwai: yes &> redirects both stdout and stderr to the same file foo &> x is short for foo > x 2>&1 mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) reinhard, but it don't seem to to work here . reinhard, seem that all the error are here on stdio siesel, I've shut the grdcvs on my name.. siesel, you try to start Your and see the output Action: dcmwai have no idea why it is hard to put all error into a log files, (where most of the time &> work but not this case) its connected with the daemonizing of the server, seems like input output is both detached. can you try if it works with -Z option? siesel, har.. I think you can try right... It would be better as you have the output directly. trying :) mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. siesel (~jan@xdsl-213-196-193-120.netcologne.de) left irc: "Client exiting" dcmwai (~dcmwai@219.95.58.204) left irc: "Client exiting" mouns (mouns@kali.mouns.org) joined #gnuenterprise. Arturas2 (~arturas@gsk.vtu.lt) joined #gnuenterprise. Hello does anyone know Ogart real name? he has joined recently Arturas2 (~arturas@gsk.vtu.lt) left irc: "BitchX: now Y2K compatible!" Nick change: mdupont -> md-afk ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" wendall911 (~wendallc@198.31.172.218) left irc: Read error: 110 (Connection timed out) wendall911 (~wendallc@198.31.172.218) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) left irc: Client Quit ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. btami (~btami@ngprs.pannongsm.hu) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 54 (Connection reset by peer) R45 (~r45@cuscon1883.tstt.net.tt) joined #gnuenterprise. Nick change: md-afk -> mdupont mdupont (mdupont@p5080E981.dip0.t-ipconnect.de) left irc: "Client exiting" mdupont (mdupont@p5080E981.dip0.t-ipconnect.de) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. http://www.cnn.com/2003/SHOWBIZ/TV/11/05/offbeat.pornstar.tv.ap/index.html we need to sign jcater up as a judge of cource course heh just a judge? I have excellent python skilz, ya know though my recursive style might throw some off uuuuuuhhhhh ba-da-bing i was willing to introduce a little fun, stress relief into your life i'm not willing to risk seeing you newd no friggen way btami_ (~btami@ngprs.pannongsm.hu) joined #gnuenterprise. \t (~r45@209.94.208.243) joined #gnuenterprise. R45 (~r45@cuscon1883.tstt.net.tt) left irc: Read error: 110 (Connection timed out) mouns (mouns@kali.mouns.org) left irc: Remote closed the connection btami (~btami@ngprs.pannongsm.hu) left irc: Read error: 104 (Connection reset by peer) Nick change: btami_ -> btami mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) btami (~btami@ngprs.pannongsm.hu) left irc: "night all" reinhard_ (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise. reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: Read error: 111 (Connection refused) R45 (~R45@cuscon629.tstt.net.tt) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. \t (~r45@209.94.208.243) left irc: Nick collision from services. \t (~r45@cuscon1883.tstt.net.tt) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) \t (~r45@cuscon1883.tstt.net.tt) left irc: Nick collision from services. \t (~r45@cuscon1883.tstt.net.tt) joined #gnuenterprise. \t (~r45@cuscon1883.tstt.net.tt) left irc: Nick collision from services. \t (~r45@cuscon1883.tstt.net.tt) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" kalbun (~sauron@ppp-217-133-200-17.cust-adsl.tiscali.it) joined #gnuenterprise. mcuria (~maxy@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. \t (~r45@cuscon1883.tstt.net.tt) left irc: Read error: 110 (Connection timed out) jamest (~jamest@gw.math.ksu.edu) left irc: "Client exiting" \t (~R45@cuscon3187.tstt.net.tt) joined #gnuenterprise. R45 (~R45@cuscon629.tstt.net.tt) left irc: Nick collision from services. Nick change: \t -> R45 Nick change: ajmitch_ -> ajmitch ajmitch: ! hello ! hi kalbun: hi there is not much talk in this moment, uhu?? uhu. ToyMan (~stuq@user-0cevdks.cable.mindspring.com) joined #gnuenterprise. kalbun (~sauron@ppp-217-133-200-17.cust-adsl.tiscali.it) left #gnuenterprise. jamest (~jamest@adsl-65-71-169-190.dsl.tpkaks.swbell.net) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "Client exiting" reinhard_ (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: "Those are 10 kinds of people: those who understand binary numbers, and those who don't." ah users you got to love them i'm quering a database for zip info zipcode is set to CALLED i inherited this app and has been sticking input blocks all over it but earlier data is a mess love em? do we? they used to use the work phone field to notes