August 2016 - Pharo-users - lists.pharo.org

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

by Holger Freyther

> On 12 Aug 2016, at 12:10, Blondeau Vincent <vincent.blondeau(a)worldline.com> wrote: > > BTW, even with prepared statements, it doesn't work either: > SQL query : EXECUTE preparedStmtd2qbaa1ap7ceiaq643sxlkyyw('Quand l'utilisateur est connectÃ© sur "son serveur"', '1277') > -> 'ERREUR: erreur de syntaxe sur ou prÃ¨s de Â« utilisateur Â» au caractÃ¨re 56' (Syntax error near char 56) Which database? What does the statement look like? What are the bound variables? E.g. is the string supposed to be UTF8 or a blob?

Aug. 12, 2016

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

by Blondeau Vincent

BTW, even with prepared statements, it doesn't work either: SQL query : EXECUTE preparedStmtd2qbaa1ap7ceiaq643sxlkyyw('Quand l'utilisateur est connectÃ© sur "son serveur"', '1277') -> 'ERREUR: erreur de syntaxe sur ou prÃ¨s de Â« utilisateur Â» au caractÃ¨re 56' (Syntax error near char 56) Vincent > -----Message d'origine----- > De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la part de > Holger Freyther > EnvoyÃ© : vendredi 12 aoÃ»t 2016 10:45 > Ã : Any question about pharo is welcome > Objet : Re: [Pharo-users] [Garage] How to espace sql special chars in a query? > > > > On 12 Aug 2016, at 10:34, Blondeau Vincent > <vincent.blondeau(a)worldline.com> wrote: > > > > Hello, > > Hi > > > > I am looking for a method that escape special characters for SQL queries. > > E.g.: I want to escape : â in a where expression: ââ¦.Where field1 = âââ, > myvariable , âââ â¦..â with myvariable := âdonâât doâ. > > I am using garage and haven't found it in the package. Does someone know > where I can found it? > > > I have used prepared statements for that. They allow me to bind the variable > to the statement and I don't have to worry about escaping (at least that is the > theory). > > holger !!!************************************************************************************* "Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre protÃ©gÃ© par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de le dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre recherchÃ©e quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage rÃ©sultant d'un virus transmis. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.!!!"

Aug. 12, 2016

Re: [Pharo-users] SUnit and "data driven" tests

by Henrik Nergaard

One possibility is to move the assertions to another method and have each test method invoke that method with a specific input. For example testPacketA self assertJitterIn: #( 1 2 3 4) equals: 42 Best regards, Henrik -----Original Message----- From: Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] On Behalf Of Holger Freyther Sent: Friday, August 12, 2016 10:21 AM To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Subject: [Pharo-users] SUnit and "data driven" tests Hi, I have a test/algorithm that I would like to test with different sets of input (and matching expected) output. Let's imagine I write a protocol library for the RTP streaming protocol and would like to verify my implementation of sequence number wrapping and jitter delay, e.g. the difficulty is to deal with the sequence number counter wrapping. My test-input is an array of sequence numbers and their arrival time and the expected result would be a calculation of "packet loss", jitter. I would like SUnit to call my testcase multiple times with different data being available. Is something like this supported with SUnit? thank you holger

Aug. 12, 2016

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

by Blondeau Vincent

Hi, Prepared statements can be a solution but I would like to have a simpler one. In the worst case, I may use that. Vincent > -----Message d'origine----- > De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la part de > Holger Freyther > EnvoyÃ© : vendredi 12 aoÃ»t 2016 10:45 > Ã : Any question about pharo is welcome > Objet : Re: [Pharo-users] [Garage] How to espace sql special chars in a query? > > > > On 12 Aug 2016, at 10:34, Blondeau Vincent > <vincent.blondeau(a)worldline.com> wrote: > > > > Hello, > > Hi > > > > I am looking for a method that escape special characters for SQL queries. > > E.g.: I want to escape : â in a where expression: ââ¦.Where field1 = âââ, > myvariable , âââ â¦..â with myvariable := âdonâât doâ. > > I am using garage and haven't found it in the package. Does someone know > where I can found it? > > > I have used prepared statements for that. They allow me to bind the variable > to the statement and I don't have to worry about escaping (at least that is the > theory). > > holger !!!************************************************************************************* "Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre protÃ©gÃ© par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de le dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre recherchÃ©e quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage rÃ©sultant d'un virus transmis. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.!!!"

Aug. 12, 2016

Re: [Pharo-users] [Garage] How to espace sql special chars in a query?

by Holger Freyther

> On 12 Aug 2016, at 10:34, Blondeau Vincent <vincent.blondeau(a)worldline.com> wrote: > > Hello, Hi > I am looking for a method that escape special characters for SQL queries. > E.g.: I want to escape : â in a where expression: ââ¦.Where field1 = âââ, myvariable , âââ â¦..â with myvariable := âdonâât doâ. > I am using garage and haven't found it in the package. Does someone know where I can found it? I have used prepared statements for that. They allow me to bind the variable to the statement and I don't have to worry about escaping (at least that is the theory). holger

Aug. 12, 2016

[Garage] How to espace sql special chars in a query?

by Blondeau Vincent

Hello, I am looking for a method that escape special characters for SQL queries. E.g.: I want to escape : ' in a where expression: '....Where field1 = ''', myvariable , ''' .....' with myvariable := 'don''t do'. I am using garage and haven't found it in the package. Does someone know where I can found it? Thanks in advance, Best regards, Vincent !!!************************************************************************************* "Ce message et les pi?ces jointes sont confidentiels et r?serv?s ? l'usage exclusif de ses destinataires. Il peut ?galement ?tre prot?g? par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir imm?diatement l'exp?diteur et de le d?truire. L'int?grit? du message ne pouvant ?tre assur?e sur Internet, la responsabilit? de Worldline ne pourra ?tre recherch?e quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'exp?diteur ne donne aucune garantie ? cet ?gard et sa responsabilit? ne saurait ?tre recherch?e pour tout dommage r?sultant d'un virus transmis. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Worldline liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.!!!"

Aug. 12, 2016

SUnit and "data driven" tests

by Holger Freyther

Hi, I have a test/algorithm that I would like to test with different sets of input (and matching expected) output. Let's imagine I write a protocol library for the RTP streaming protocol and would like to verify my implementation of sequence number wrapping and jitter delay, e.g. the difficulty is to deal with the sequence number counter wrapping. My test-input is an array of sequence numbers and their arrival time and the expected result would be a calculation of "packet loss", jitter. I would like SUnit to call my testcase multiple times with different data being available. Is something like this supported with SUnit? thank you holger

Aug. 12, 2016

Re: [Pharo-users] Spec > TreeModel: Updating the tree selection after a deletion

by Nicolai Hess

2016-08-10 21:03 GMT+02:00 Nicolai Hess <nicolaihess(a)gmail.com>: > > > 2016-08-10 20:42 GMT+02:00 Nicolai Hess <nicolaihess(a)gmail.com>: > >> >> >> 2016-08-10 19:12 GMT+02:00 Nicolai Hess <nicolaihess(a)gmail.com>: >> >>> >>> >>> 2016-08-10 19:05 GMT+02:00 Offray Vladimir Luna CÃ¡rdenas < >>> offray.luna(a)mutabit.com>: >>> >>>> Hi, >>>> >>>> I have been fighting with this for several hours until now. I can't >>>> understand how to manage change on selections on TreeModels with Spec, >>>> which is really frustrating.... >>>> >>>> Here is what I have: >>>> >>>> GrafoscopioNotebook>>initializePresenter >>>> tree whenSelectedItemChanged: [ :item | >>>> self updateBodyFor: item. >>>> header whenTextChanged: [ :arg | >>>> (tree selectedItem content header) = arg >>>> ifFalse: [ >>>> (tree highlightedItem) content header: arg. >>>> tree roots: tree roots]]] >>>> >>>> GrafoscopioNotebook>>updateBodyFor: item >>>> item >>>> ifNotNil: [ self changeBody: item ] >>>> ifNil: [ self inform: 'Nil node' ] >>>> >>>> and #changeBody: deals with putting a textual or code pane according to >>>> some tags on the selected node (and it's working properly). >>>> >>>> The problem seems that when I add/delete nodes to my tree, or while >>>> changing the selection between nodes, the item variable becomes temporarily >>>> nil and I can't update the contents of the body to correspond to the >>>> current selection. I would like to say explicitly that a new tree added >>>> node gets the selection and that the deletion of nodes gives selection to >>>> its siblings or parent (if there are not siblings) and that node body pane >>>> should be updated accordingly. >>>> >>>> Again, any hint would be really valuable... I'll take a break from the >>>> computer to dissipate current frustration... Pharo is generally a happy >>>> productive place... but not today :-/... anyway some hits are part of >>>> learning to play with it. >>>> >>> >>> Hi Offray, >>> I do remember that I tried this as well, I will if I can find out how >>> far I got it to work. >>> >> >> a simiple example: >> >> |t nodeBlock | >> nodeBlock:= [:class | |node| >> node := TreeNodeModel new. >> node hasChildren:[ class subclasses isEmpty not]. >> node children: [class subclasses collect:[:subclass | nodeBlock >> value: subclass]]. >> node content: class]. >> t:=TreeModel new. >> t roots: (Morph subclasses collect:[:class | nodeBlock value:class]). >> t whenBuiltDo:[ t selectedItem:( t roots first >> selected:true;takeHighlight;yourself)]. >> t openWithSpec >> >> the important part is the "takeHighlight" and to call it after the widget >> is built >> >> >> > > > And an awfull example on how to modify selection (only the nodes of the > root, couldn't find out how to do it for arbitrary subnodes) > > |t nodeBlock | > nodeBlock:= [:class | |node| > node := TreeNodeModel new. > node hasChildren:[ class subclasses isEmpty not]. > node children: [class subclasses collect:[:subclass | nodeBlock value: > subclass]]. > node content: class]. > t:=TreeModel new. > t autoDeselection:true. > t roots: (Morph subclasses collect:[:class | nodeBlock value:class]). > t menu:[:menu ||group| > group := MenuGroupModel new. > menu addMenuGroup: group. > group addMenuItem:(MenuItemModel new name:'next';action:[ > |item| > item := t selectedItem. > item ifNotNil:[|allItems index| > allItems := item container roots. > index := allItems indexOf: item. > (index < allItems size) ifTrue:[item selected:false. item > container selectedItem:((allItems at:(index+1)) selected:true;takeHighlight; > yourself)] > ] > ])]. > t whenBuiltDo:[ t selectedItem:( t roots first selected:true;takeHighlight; > yourself)]. > t openWithSpec > > again, the important part is #selectedItem: and #takeHighlight, otherwise > the model doesn't know about the selection change. > > > Hm, yes, updating the selection after deletion is much more difficult. The problem is that most in spec TreeModel is done for creating the tree widget, not for managing nodes and changes afterwards. > > >> >>> >>>> >>>> Cheers, >>>> >>>> Offray >>>> >>>> >>>> On 07/08/16 16:11, Offray Vladimir Luna CÃ¡rdenas wrote: >>>> >>>>> Hi, >>>>> >>>>> I have a Spec TreeModel to represent the GUI of a grafoscopio notebook. >>>>> >>>>> The message that deletes nodes is something like this: >>>>> >>>>> ============ >>>>> >>>>> GrafoscopioNotebook>>removeNode >>>>> | nodeToDelete | >>>>> nodeToDelete := tree selectedItem content. >>>>> nodeToDelete parent removeNode: nodeToDelete. >>>>> tree selectedItem: tree selectedItem parentNode. >>>>> tree needRebuild: true. >>>>> tree roots: tree roots. >>>>> self buildWithSpecLayout: self class defaultSpec. >>>>> >>>>> ============= >>>>> >>>>> And its working fine in the sense that it deletes the selected node, >>>>> but after the deletion the contents of the old node are showed no matter if >>>>> I change the node selection on the tree. I would like to manage selections >>>>> in a smart way, so if I add a new node to the notebook, the new node gets >>>>> the selection. If I delete a notebook node, the previous node gets selected >>>>> or the parent if no more siblings are encountered and so on. There is some >>>>> simple example to look for, about managing and updating selections in a >>>>> TreeModel interface? >>>>> >>>>> Thanks, >>>>> >>>>> Offray >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >> >

Aug. 11, 2016

Re: [Pharo-users] RewriteTool matching parts of an array

by Peter UhnÃ¡k

Nvm, I've misread it. Ok, I will do it manually then, and submit a bug report. :) Thanks, Peter On Thu, Aug 11, 2016 at 3:31 PM, Peter UhnÃ¡k <i.uhnak(a)gmail.com> wrote: > I get the exact same error when executing the script, I am running this on > Pharo 5 (50760) btw. > > On Thu, Aug 11, 2016 at 3:15 PM, Mark Rizun <mrizun(a)gmail.com> wrote: > >> Hi Peter, >> >> I tried to perform this transformation with RewriteTool and got the same >> DNU. >> >> >>> However when I tried to execute it I was met with DNU >>> OrderedCollection>>parent: >>> >>> It seems that the @first/@second part are not matched properly. >>> >> >> Actually they are matched properly, because if you try to put in >> transformation part, for example, {``@first.``@second} everything works >> fine. >> >> >>> Any way to fix this? Or am I doing it wrong? >>> >> >> I believe you are doing everything just fine. However, it is definately >> the problem of RBParseTreeRewriter or something related to it. >> Try to execute following code in playground and you will get the same DNU: >> >> | rewriter | >> rewriter := RBParseTreeRewriter new replace: '| base | >> base := {(#Department >> -> >> {``@first. >> ``@second})}' with: '| base | >> base := {#Department -> (Array with: ``@first with: ``@second)}'. >> >> (rewriter executeTree: (RBParser parseRewriteExpression: '| base | >> base := {(#Department >> -> >> {(1 @ 255). >> (Color lightMagenta)})}')) >> ifTrue: [ rewriter tree asString inspect ]. >> >> This code does exactly the same that RewriteTool should do when you put >> all the parts into it. >> Thus, I think, it is not a problem with the tool. >> >> Cheers, >> Mark >> >> >

Aug. 11, 2016

Re: [Pharo-users] RewriteTool matching parts of an array

by Peter UhnÃ¡k

I get the exact same error when executing the script, I am running this on Pharo 5 (50760) btw. On Thu, Aug 11, 2016 at 3:15 PM, Mark Rizun <mrizun(a)gmail.com> wrote: > Hi Peter, > > I tried to perform this transformation with RewriteTool and got the same > DNU. > > >> However when I tried to execute it I was met with DNU >> OrderedCollection>>parent: >> >> It seems that the @first/@second part are not matched properly. >> > > Actually they are matched properly, because if you try to put in > transformation part, for example, {``@first.``@second} everything works > fine. > > >> Any way to fix this? Or am I doing it wrong? >> > > I believe you are doing everything just fine. However, it is definately > the problem of RBParseTreeRewriter or something related to it. > Try to execute following code in playground and you will get the same DNU: > > | rewriter | > rewriter := RBParseTreeRewriter new replace: '| base | > base := {(#Department > -> > {``@first. > ``@second})}' with: '| base | > base := {#Department -> (Array with: ``@first with: ``@second)}'. > > (rewriter executeTree: (RBParser parseRewriteExpression: '| base | > base := {(#Department > -> > {(1 @ 255). > (Color lightMagenta)})}')) > ifTrue: [ rewriter tree asString inspect ]. > > This code does exactly the same that RewriteTool should do when you put > all the parts into it. > Thus, I think, it is not a problem with the tool. > > Cheers, > Mark > >

Aug. 11, 2016