- Pharo-users - lists.pharo.org

Re: [Pharo-users] PostgreSQL and Pharo 6

by Benoit St-Jean

You have to #connect before executing SQL statements! Something like (in your code): conn connect.Â ----------------- BenoÃ®t St-Jean Yahoo! Messenger: bstjean Twitter: @BenLeChialeux Pinterest: benoitstjean Instagram: Chef_Benito IRC: lamneth Blogue: endormitoire.wordpress.com "A standpoint is an intellectual horizon of radius zero".Â (A. Einstein) From: Dimitris Chloupis <kilon.alios(a)gmail.com> To: Benoit St-Jean <bstjean(a)yahoo.com>; Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Sent: Monday, April 17, 2017 3:54 PM Subject: Re: [Pharo-users] PostgreSQL and Pharo 6 Installing from Catalog Browser fails I installed it via the the website instructions, it installs fine But if I use it this wayÂ conn := GAConnection new. ca := GAConnectionArgs hostname: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com'Â portno: '****'databaseName:'*******' Â userName: '*****' Â password:''***'. conn connectionArgs: ca. conn execute: 'select * from search_terms'. it fails with no connection, is there anything else i need to do ?is there a guide for how to use this ?Â On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.alios(a)gmail.com> wrote: thank you BenoitÂ On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users <pharo-users(a)lists.pharo.org> wrote: ODBC worked fine as well if you don't need native driver accessÂ ----------------- BenoÃ®t St-Jean Yahoo! Messenger: bstjean Twitter: @BenLeChialeux Pinterest: benoitstjean Instagram: Chef_Benito IRC: lamneth Blogue: endormitoire.wordpress.com "A standpoint is an intellectual horizon of radius zero".Â (A. Einstein) From: Dimitris Chloupis <kilon.alios(a)gmail.com> To: Any question about pharo is welcome <pharo-users(a)lists.pharo.org> Sent: Sunday, April 16, 2017 4:37 AM Subject: [Pharo-users] PostgreSQL and Pharo 6 Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D I am using Python for it but I would like to give access also to Pharo to my database. I was informed that Garage has a driver for PostgreSQL , is there any other candidate ? Any advice ?Â

April 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

Installing from Catalog Browser fails I installed it via the the website instructions, it installs fine But if I use it this way conn := GAConnection new. ca := GAConnectionArgs hostname: 'ec2-**-***-***- 185.eu-west-1.compute.amazonaws.com' portno: '****' databaseName:'*******' userName: '*****' password:''***'. conn connectionArgs: ca. conn execute: 'select * from search_terms'. it fails with no connection, is there anything else i need to do ? is there a guide for how to use this ? On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.alios(a)gmail.com> wrote: > thank you Benoit > > On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users < > pharo-users(a)lists.pharo.org> wrote: > >> ODBC worked fine as well if you don't need native driver access >> >> ----------------- >> BenoÃ®t St-Jean >> Yahoo! Messenger: bstjean >> Twitter: @BenLeChialeux >> Pinterest: benoitstjean >> Instagram: Chef_Benito >> IRC: lamneth >> Blogue: endormitoire.wordpress.com >> "A standpoint is an intellectual horizon of radius zero". (A. Einstein) >> >> >> ------------------------------ >> *From:* Dimitris Chloupis <kilon.alios(a)gmail.com> >> *To:* Any question about pharo is welcome <pharo-users(a)lists.pharo.org> >> *Sent:* Sunday, April 16, 2017 4:37 AM >> *Subject:* [Pharo-users] PostgreSQL and Pharo 6 >> >> Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D >> >> I am using Python for it but I would like to give access also to Pharo to >> my database. I was informed that Garage has a driver for PostgreSQL , is >> there any other candidate ? Any advice ? >> >> >>

April 17, 2017

Re: [Pharo-users] Exporting Packages to Cincom Smalltalk (VisualWorks)

by Esteban A. Maringolo

Thank you Peter. Alexandre Bergel pointed me to Roassal export classes, which does something similar to the code you pointed me to (yours seems more tidy). Thanks again, Esteban A. Maringolo 2017-04-17 12:57 GMT-03:00 Peter Uhnak <i.uhnak(a)gmail.com>: > Some time ago I hacked together a very simple thing that generates VW XML from code represented in Moose/UML... I guess you could use it as a starting point: https://github.com/OpenPonk/class-editor/tree/master/repository/UML-CodeGen… > > Also take a look at SIF (which is quite easy to use on both Pharo and VW side): > > * https://github.com/peteruhnak/sif > * https://github.com/peteruhnak/sif/blob/master/docs.md > * http://www.samadhiweb.com/blog/2016.01.06.sif.html > * http://www.pocketsmalltalk.com/sif/ > > Peter > > On Mon, Apr 17, 2017 at 10:37:52AM -0300, Esteban A. Maringolo wrote: >> Is there any exporter than can convert an RPackage into a VW Parcel >> (.pst), in XML or Chunk format? >> >> I need to migrate a few libraries of my own and couldn't find >> anything, so I'm asking before start writing something :) >> >> Regards! >> >> Esteban A. Maringolo >> >

April 17, 2017

Re: [Pharo-users] How childrenBlock: in TreeModel works

by Peter Uhnak

I guess something like this could work... ``` d := { Dictionary with: #n -> 'whatever' with: #d -> { Dictionary with: #a -> #AA with: #b -> #BB. Dictionary with: #c -> #CC with: #d -> #DD }. Dictionary with: #n -> 'wherever' with: #d -> { Dictionary with: #a -> #AA with: #b -> #BB. Dictionary with: #c -> #CC with: #d -> #DD }. }. TreeModel new roots: d; childrenBlock: [ :item | item isDictionary ifTrue: [ item associations flatCollect: [ :pair | pair value isArray ifTrue: [ pair value ] ifFalse: [ {pair} ]. ] ] ifFalse: [ #() ] ]; openWithSpec ``` but forcing this much behavior is a bad practice... because it's hard to read, hard to understand, and hard to test. So I suggest using custom classes as nodes (so each node can simply tell what its children are), and then delegate the retrieval... you could also add extension methods to the respective classes' protocols to acheive the same... TreeModel new childrenBlock: [ :item | item children ]; displayBlock: [ :item | item name ] Peter On Mon, Apr 17, 2017 at 09:12:47AM -0700, chrismihaylyk wrote: > Hello! > > Could anyone help me, please? > > I have faced with a problem of TreeModel childrenBlock: for more complex > build in structure. > > For example, I have anOrderedCollection of Dictionary, and in each > dictionary, there are exist associations, which values are > anArray(aDictionary, aDictionary ...). > > I need to make drop downs for all of these entire levels of arrays and > dictionaries. > For first level I made it: > > collectionsList > ifNil: [ ^ nil ] > ifNotNil: [ collectionsList hasChildrenBlock: [ :item | item > isMyDictionary. ]. > collectionsList > childrenBlock: [ :item | item associations > collect: [ :assoc | > assoc key asString , ' -> ' , assoc value asString. ] ] ] > > MyDictionaly is the class, inherited from Dictionary, just to override > method printOn: > > At the first picture, it's how it looks like, how I made it. > At the second - how I expect it to be (taken from Inspector window). > > Thanks a lot! > <http://forum.world.st/file/n4942409/before.jpg> > <http://forum.world.st/file/n4942409/after.jpg> > > > > > -- > View this message in context: http://forum.world.st/How-childrenBlock-in-TreeModel-works-tp4940884p494240… > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >

April 17, 2017

Re: [Pharo-users] Convert Literal array into Dynamic array

by Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº

Thanks! But I've just handled it by using STON fromString: Khrystyna. 2017-04-17 19:14 GMT+03:00 Ben Coman <btc(a)openinworld.com>: > > On Mon, Apr 17, 2017 at 1:30 AM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº < > chrismihaylyk(a)gmail.com> wrote: >> >> >> Actually, I need this interpretation {7. 8. "f"} for writing parser of >> javascript queries which is used in MongoDB shell, to be able to execute >> this with MongoQuery Pharo class. >> Maybe, you could help me how to implement it? >> > > Do you mean parsing Json syntax? <https://www.mongodb.com/json-and-bson> > https://www.mongodb.com/json-and-bson > > Maybe this is useful > https://ci.inria.fr/pharo-contribution/job/EnterprisePharoBo > ok/lastSuccessfulBuild/artifact/book-result/NeoJSON/NeoJSON.html > cheers -ben > > >

April 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Dimitris Chloupis

thank you Benoit On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users < pharo-users(a)lists.pharo.org> wrote: > ODBC worked fine as well if you don't need native driver access > > ----------------- > BenoÃ®t St-Jean > Yahoo! Messenger: bstjean > Twitter: @BenLeChialeux > Pinterest: benoitstjean > Instagram: Chef_Benito > IRC: lamneth > Blogue: endormitoire.wordpress.com > "A standpoint is an intellectual horizon of radius zero". (A. Einstein) > > > ------------------------------ > *From:* Dimitris Chloupis <kilon.alios(a)gmail.com> > *To:* Any question about pharo is welcome <pharo-users(a)lists.pharo.org> > *Sent:* Sunday, April 16, 2017 4:37 AM > *Subject:* [Pharo-users] PostgreSQL and Pharo 6 > > Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D > > I am using Python for it but I would like to give access also to Pharo to > my database. I was informed that Garage has a driver for PostgreSQL , is > there any other candidate ? Any advice ? > > >

April 17, 2017

Re: [Pharo-users] Convert Literal array into Dynamic array

by Ben Coman

On Mon, Apr 17, 2017 at 1:30 AM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com> wrote: > > > Actually, I need this interpretation {7. 8. "f"} for writing parser of > javascript queries which is used in MongoDB shell, to be able to execute > this with MongoQuery Pharo class. > Maybe, you could help me how to implement it? > Do you mean parsing Json syntax? <https://www.mongodb.com/json-and-bson> https://www.mongodb.com/json-and-bson Maybe this is useful https://ci.inria.fr/pharo-contribution/job/EnterprisePharoBo ok/lastSuccessfulBuild/artifact/book-result/NeoJSON/NeoJSON.html cheers -ben

April 17, 2017

Re: [Pharo-users] How childrenBlock: in TreeModel works

by chrismihaylyk

Hello! Could anyone help me, please? I have faced with a problem of TreeModel childrenBlock: for more complex build in structure. For example, I have anOrderedCollection of Dictionary, and in each dictionary, there are exist associations, which values are anArray(aDictionary, aDictionary ...). I need to make drop downs for all of these entire levels of arrays and dictionaries. For first level I made it: collectionsList ifNil: [ ^ nil ] ifNotNil: [ collectionsList hasChildrenBlock: [ :item | item isMyDictionary. ]. collectionsList childrenBlock: [ :item | item associations collect: [ :assoc | assoc key asString , ' -> ' , assoc value asString. ] ] ] MyDictionaly is the class, inherited from Dictionary, just to override method printOn: At the first picture, it's how it looks like, how I made it. At the second - how I expect it to be (taken from Inspector window). Thanks a lot! <http://forum.world.st/file/n4942409/before.jpg> <http://forum.world.st/file/n4942409/after.jpg> -- View this message in context: http://forum.world.st/How-childrenBlock-in-TreeModel-works-tp4940884p494240… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

April 17, 2017

Re: [Pharo-users] best practices for using external files for testing

by Dimitris Chloupis

ah ok that changes everything, I agree. Why use an XML file instead of a ST source file ? maybe using ST may be faster ? On Mon, Apr 17, 2017 at 7:02 PM Peter Uhnak <i.uhnak(a)gmail.com> wrote: > On Mon, Apr 17, 2017 at 12:56:42PM +0000, Dimitris Chloupis wrote: > > 1 mb is not big for git , 1 gb is. It's small. > > I meant big for Pharo/to be compiled as a method source code, i.e. > Something>>xmlFile ^ '<xml> ... 1MB of string...</xml>' > > > > > I version control blender files of 100-500mbs with ease . Git is always > > very fast. > > > > I have used image files (PNG) for my project ChronosManager ,it fetches > > them together with the repo, they sit in their own image folder inside > the > > repo folder that contains the code . I then open them with a path I get > > using filesystem currentdirectory method and then I navigate inside the > > folder searching using the name of folderminside the github-cache > > subfolder. You can find the code in that project. > > > > Don't know if that is the best way to do this , it works for me. I also > > check to make sure that images are not already loaded in the image > because > > git may be fast but Pharo is very slow when loading PNG files. I load > them > > once and save the image in them and I reload only if I change one of the > > PNGs. > > > > I have also created a mechanism to detect whether there is an update in > the > > github repo and only then pull the git repo. It's a cheap hack where I > put > > version info in the README which I access online and parse. I have > created > > this way an auto update API. I could fine tune it to provide precise meta > > data of which png is updated and fetch only that but I have not felt the > > need so far to do this. > > On Sat, 15 Apr 2017 at 19:52, Peter Uhnak <i.uhnak(a)gmail.com> wrote: > > > > > Hi, > > > > > > is there a common/best practice for using external files in tests? > > > > > > In my specific case I am interested in git-based projects, where I > have a > > > big (~1MB) file stored in repository and I would like to use it in my > tests. > > > > > > For GitFileTree project I could presumably use the following to access > it: > > > > > > 'OP-XMI' asPackage mcPackage workingCopy repositoryGroup remotes first > > > directory / 'tests' / 'my-test-file.xmi' > > > > > > This will retrieve the MCPackage of the Package and then retireve > where it > > > the repo is actually stored on the disk. > > > > > > Are there better ways to do this? Could something similar be done with > > > IceBerg? > > > > > > (p.s. in theory I could compile the entire file (e.g. 1MB) to a method, > > > but that is very ugly to me) > > > > > > Thanks, > > > Peter > > > > > > > >

April 17, 2017

Re: [Pharo-users] best practices for using external files for testing

by Peter Uhnak

On Mon, Apr 17, 2017 at 12:56:42PM +0000, Dimitris Chloupis wrote: > 1 mb is not big for git , 1 gb is. It's small. I meant big for Pharo/to be compiled as a method source code, i.e. Something>>xmlFile ^ '<xml> ... 1MB of string...</xml>' > > I version control blender files of 100-500mbs with ease . Git is always > very fast. > > I have used image files (PNG) for my project ChronosManager ,it fetches > them together with the repo, they sit in their own image folder inside the > repo folder that contains the code . I then open them with a path I get > using filesystem currentdirectory method and then I navigate inside the > folder searching using the name of folderminside the github-cache > subfolder. You can find the code in that project. > > Don't know if that is the best way to do this , it works for me. I also > check to make sure that images are not already loaded in the image because > git may be fast but Pharo is very slow when loading PNG files. I load them > once and save the image in them and I reload only if I change one of the > PNGs. > > I have also created a mechanism to detect whether there is an update in the > github repo and only then pull the git repo. It's a cheap hack where I put > version info in the README which I access online and parse. I have created > this way an auto update API. I could fine tune it to provide precise meta > data of which png is updated and fetch only that but I have not felt the > need so far to do this. > On Sat, 15 Apr 2017 at 19:52, Peter Uhnak <i.uhnak(a)gmail.com> wrote: > > > Hi, > > > > is there a common/best practice for using external files in tests? > > > > In my specific case I am interested in git-based projects, where I have a > > big (~1MB) file stored in repository and I would like to use it in my tests. > > > > For GitFileTree project I could presumably use the following to access it: > > > > 'OP-XMI' asPackage mcPackage workingCopy repositoryGroup remotes first > > directory / 'tests' / 'my-test-file.xmi' > > > > This will retrieve the MCPackage of the Package and then retireve where it > > the repo is actually stored on the disk. > > > > Are there better ways to do this? Could something similar be done with > > IceBerg? > > > > (p.s. in theory I could compile the entire file (e.g. 1MB) to a method, > > but that is very ugly to me) > > > > Thanks, > > Peter > > > >

April 17, 2017