- Pharo-users - lists.pharo.org

UK Smalltalk User Group meeting - Monday, 24th April

by Giovanni Corriga

The next meeting of the UK Smalltalk User Group Meeting will be on Monday, 24th April. We'll meet at our usual venue The Counting House ( http://www.the-counting-house.com/) at 7pm. If you'd like to join us, you can just show up at the pub. You can also sign up in advance at the meeting's Meetup page: https://www.meetup.com/UKSTUG/events/238935668/ . See you there!

April 17, 2017

Re: [Pharo-users] PostgreSQL and Pharo 6

by Benoit St-Jean

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] Parser for javascript mongodb (json) notation selects

by Tudor Girba

Hi, Take a look at the SmaCCParseNode to see the API to traverse the resulting AST. Furthermore, you can also use the query engine that SmaCC ships with. In your case, you seem to be interested only in the one argument of the find call. So, you can do this: ast := JSParser parse: 'db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, {description: { $regex: /test/i } } ] } )'. pattern := JSParser parse: '`something`.find(`arg1`)' startingAt: JSParser startingStateForExpression. matches := OrderedCollection new. ast withAllNodesDo: [:each | mapping := Dictionary new. (pattern match: each inContext: mapping) ifTrue: [ matches add: (each -> (mapping associations collect: [:assoc | assoc key name -> assoc value]) asDictionary) ] ]. matches. The âmatchesâ variable will contain all matches of all find arguments. In our case, you can do: (matches anyOne value at: 'arg1â) and this will give you the literal node with the argument from your script: {$or: [ { name: { $regex: /test/i } }, {description: { $regex: /test/i } } ] } Next, you would need to parse the contents of the source as a JSON document. For example, the NeoJSONReader would be able to get the dictionary you need like this: NeoJSONReader fromString: '{"or": [ { "name": { "regex": "/test/i" } }, {"description": { "regex": "/test/i" } } ] }â Note that the sources contain ââ, so this means that you would need to traverse the original source through a visitor and print it so that you can parse it with a JSON parser. This is a piece of code you should write. Once you get the dictionary, you can use the storeString: (NeoJSONReader fromString: '{"or": [ { "name": { "regex": "/test/i" } }, {"description": { "regex": "/test/i" } } ] }') storeString ==> ((Dictionary new) add: ('or'->((Array new: 2) at: 1 put: ((Dictionary new) add: ('name'->((Dictionary new) add: ('regex'->'/test/i'); yourself)); yourself); at: 2 put: ((Dictionary new) add: ('description'->((Dictionary new) add: ('regex'->'/test/i'); yourself)); yourself); yourself)); yourself) I hope this helps. Cheers, Doru > On Apr 16, 2017, at 10:17 PM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com> wrote: > > How to iterate over it result parse tree? > > 2017-04-16 22:44 GMT+03:00 Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com>: > That's so cool plugin. Thank you very very much! > > But I'm a bit confused how to transform that tree into needed code f.e. > into > someCollection select: { > '$or' -> { > { 'name' -> { > '$regex' -> 'test' . > '$options' -> 'i' } asDictionary } asDictionary. > { 'description' -> { > '$regex' -> 'test' . > '$options' -> 'i' } asDictionary } asDictionary > } > } asDictionary > > Could you help me, please? > > 2017-04-16 21:41 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: > Hi, > > Here is how to load it in Pharo 6: > Metacello new > smalltalkhubUser: 'JohnBrant' project: 'SmaCC'; > configuration: 'SmaCC'; > version: #'development'; > load > > Then you can do: > JSParser parse: 'db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, {description: { $regex: /test/i } } ] } )â > > And you get the AST that you can play with (and transform into what you want): > > <Playground-JS.png> > > Cheers, > Doru > > >> On Apr 16, 2017, at 8:06 PM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com> wrote: >> >> Thank you very much! >> But could you help me, please, to setup SmaCC into my Pharo? >> >> Your's faithfully, >> Khrystyna Mykhailiuk >> >> 2017-04-16 20:57 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: >> Hi, >> >> SmaCC ships with a JS parser. Please take a look at it. >> >> Cheers, >> Doru >> >> >> > On Apr 16, 2017, at 3:42 PM, chrismihaylyk <chrismihaylyk(a)gmail.com> wrote: >> > >> > Hello, friends! >> > >> > I'm creating MongoDBBrowser that have all CRUD operations and I need a >> > parser that translates javascript queries to MongoDB into the queries (for >> > making selects, inserts etc.) using MongoQuery class. >> > For example, I have query >> > >> > db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, { >> > description: { $regex: /test/i } } ] } ) >> > >> > that is manually rewriting into >> > someCollection select: { >> > '$or' -> { >> > { 'name' -> { >> > '$regex' -> 'test' . >> > '$options' -> 'i' } asDictionary } asDictionary. >> > { 'description' -> { >> > '$regex' -> 'test' . >> > '$options' -> 'i' } asDictionary } asDictionary >> > } >> > } asDictionary >> > >> > But I need to have a parser that will do it automatically. >> > >> > Maybe there are already exist one? If not, how to write my own? >> > Please help. >> > >> > Thanks a lot, Khrystyna=) >> > >> > >> > >> > -- >> > View this message in context: http://forum.world.st/Parser-for-javascript-mongodb-json-notation-selects-t… >> > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >> > >> >> -- >> www.tudorgirba.com >> www.feenk.com >> >> "Reasonable is what we are accustomed with." >> >> >> > > -- > www.tudorgirba.com > www.feenk.com > > "Every thing should have the right to be different." > > > > > > -- www.tudorgirba.com www.feenk.com "We can create beautiful models in a vacuum. But, to get them effective we have to deal with the inconvenience of reality."

April 16, 2017

Re: [Pharo-users] Parser for javascript mongodb (json) notation selects

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

How to iterate over it result parse tree? 2017-04-16 22:44 GMT+03:00 Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com>: > That's so cool plugin. Thank you very very much! > > But I'm a bit confused how to transform that tree into needed code f.e. > into > someCollection select: { > '$or' -> { > { 'name' -> { > '$regex' -> 'test' . > '$options' -> 'i' } asDictionary } asDictionary. > { 'description' -> { > '$regex' -> 'test' . > '$options' -> 'i' } asDictionary } asDictionary > } > } asDictionary > > Could you help me, please? > > 2017-04-16 21:41 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: > >> Hi, >> >> Here is how to load it in Pharo 6: >> Metacello new >> smalltalkhubUser: 'JohnBrant' project: 'SmaCC'; >> configuration: 'SmaCC'; >> version: #'development'; >> load >> >> Then you can do: >> JSParser parse: 'db.SomeCollection.find( {$or: [ { name: { $regex: >> /test/i } }, {description: { $regex: /test/i } } ] } )â >> >> And you get the AST that you can play with (and transform into what you >> want): >> >> >> Cheers, >> Doru >> >> >> On Apr 16, 2017, at 8:06 PM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com> >> wrote: >> >> Thank you very much! >> But could you help me, please, to setup SmaCC into my Pharo? >> >> Your's faithfully, >> Khrystyna Mykhailiuk >> >> 2017-04-16 20:57 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: >> Hi, >> >> SmaCC ships with a JS parser. Please take a look at it. >> >> Cheers, >> Doru >> >> >> > On Apr 16, 2017, at 3:42 PM, chrismihaylyk <chrismihaylyk(a)gmail.com> >> wrote: >> > >> > Hello, friends! >> > >> > I'm creating MongoDBBrowser that have all CRUD operations and I need a >> > parser that translates javascript queries to MongoDB into the queries >> (for >> > making selects, inserts etc.) using MongoQuery class. >> > For example, I have query >> > >> > db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, { >> > description: { $regex: /test/i } } ] } ) >> > >> > that is manually rewriting into >> > someCollection select: { >> > '$or' -> { >> > { 'name' -> { >> > '$regex' -> 'test' . >> > '$options' -> 'i' } asDictionary } asDictionary. >> > { 'description' -> { >> > '$regex' -> 'test' . >> > '$options' -> 'i' } asDictionary } asDictionary >> > } >> > } asDictionary >> > >> > But I need to have a parser that will do it automatically. >> > >> > Maybe there are already exist one? If not, how to write my own? >> > Please help. >> > >> > Thanks a lot, Khrystyna=) >> > >> > >> > >> > -- >> > View this message in context: http://forum.world.st >> /Parser-for-javascript-mongodb-json-notation-selects-tp4942299.html >> > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >> > >> >> -- >> www.tudorgirba.com >> www.feenk.com >> >> "Reasonable is what we are accustomed with." >> >> >> >> >> -- >> www.tudorgirba.com >> www.feenk.com >> >> "Every thing should have the right to be different." >> >> >> >> >> >

April 16, 2017

Re: [Pharo-users] Parser for javascript mongodb (json) notation selects

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

That's so cool plugin. Thank you very very much! But I'm a bit confused how to transform that tree into needed code f.e. into someCollection select: { '$or' -> { { 'name' -> { '$regex' -> 'test' . '$options' -> 'i' } asDictionary } asDictionary. { 'description' -> { '$regex' -> 'test' . '$options' -> 'i' } asDictionary } asDictionary } } asDictionary Could you help me, please? 2017-04-16 21:41 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: > Hi, > > Here is how to load it in Pharo 6: > Metacello new > smalltalkhubUser: 'JohnBrant' project: 'SmaCC'; > configuration: 'SmaCC'; > version: #'development'; > load > > Then you can do: > JSParser parse: 'db.SomeCollection.find( {$or: [ { name: { $regex: /test/i > } }, {description: { $regex: /test/i } } ] } )â > > And you get the AST that you can play with (and transform into what you > want): > > > Cheers, > Doru > > > On Apr 16, 2017, at 8:06 PM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com> > wrote: > > Thank you very much! > But could you help me, please, to setup SmaCC into my Pharo? > > Your's faithfully, > Khrystyna Mykhailiuk > > 2017-04-16 20:57 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: > Hi, > > SmaCC ships with a JS parser. Please take a look at it. > > Cheers, > Doru > > > > On Apr 16, 2017, at 3:42 PM, chrismihaylyk <chrismihaylyk(a)gmail.com> > wrote: > > > > Hello, friends! > > > > I'm creating MongoDBBrowser that have all CRUD operations and I need a > > parser that translates javascript queries to MongoDB into the queries > (for > > making selects, inserts etc.) using MongoQuery class. > > For example, I have query > > > > db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, { > > description: { $regex: /test/i } } ] } ) > > > > that is manually rewriting into > > someCollection select: { > > '$or' -> { > > { 'name' -> { > > '$regex' -> 'test' . > > '$options' -> 'i' } asDictionary } asDictionary. > > { 'description' -> { > > '$regex' -> 'test' . > > '$options' -> 'i' } asDictionary } asDictionary > > } > > } asDictionary > > > > But I need to have a parser that will do it automatically. > > > > Maybe there are already exist one? If not, how to write my own? > > Please help. > > > > Thanks a lot, Khrystyna=) > > > > > > > > -- > > View this message in context: http://forum.world. > st/Parser-for-javascript-mongodb-json-notation-selects-tp4942299.html > > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > > > > -- > www.tudorgirba.com > www.feenk.com > > "Reasonable is what we are accustomed with." > > > > > -- > www.tudorgirba.com > www.feenk.com > > "Every thing should have the right to be different." > > > > >

April 16, 2017

Re: [Pharo-users] Parser for javascript mongodb (json) notation selects

by Tudor Girba

Hi, Here is how to load it in Pharo 6: Metacello new smalltalkhubUser: 'JohnBrant' project: 'SmaCC'; configuration: 'SmaCC'; version: #'development'; load Then you can do: JSParser parse: 'db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, {description: { $regex: /test/i } } ] } )â And you get the AST that you can play with (and transform into what you want): Cheers, Doru > On Apr 16, 2017, at 8:06 PM, Ð¥ÑÐ¸ÑÑÐ¸Ð½Ð° ÐÐ¸ÑÐ°Ð¹Ð»ÑÐº <chrismihaylyk(a)gmail.com> wrote: > > Thank you very much! > But could you help me, please, to setup SmaCC into my Pharo? > > Your's faithfully, > Khrystyna Mykhailiuk > > 2017-04-16 20:57 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: > Hi, > > SmaCC ships with a JS parser. Please take a look at it. > > Cheers, > Doru > > > > On Apr 16, 2017, at 3:42 PM, chrismihaylyk <chrismihaylyk(a)gmail.com> wrote: > > > > Hello, friends! > > > > I'm creating MongoDBBrowser that have all CRUD operations and I need a > > parser that translates javascript queries to MongoDB into the queries (for > > making selects, inserts etc.) using MongoQuery class. > > For example, I have query > > > > db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, { > > description: { $regex: /test/i } } ] } ) > > > > that is manually rewriting into > > someCollection select: { > > '$or' -> { > > { 'name' -> { > > '$regex' -> 'test' . > > '$options' -> 'i' } asDictionary } asDictionary. > > { 'description' -> { > > '$regex' -> 'test' . > > '$options' -> 'i' } asDictionary } asDictionary > > } > > } asDictionary > > > > But I need to have a parser that will do it automatically. > > > > Maybe there are already exist one? If not, how to write my own? > > Please help. > > > > Thanks a lot, Khrystyna=) > > > > > > > > -- > > View this message in context: http://forum.world.st/Parser-for-javascript-mongodb-json-notation-selects-t… > > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > > > > -- > www.tudorgirba.com > www.feenk.com > > "Reasonable is what we are accustomed with." > > > -- www.tudorgirba.com www.feenk.com "Every thing should have the right to be different."

April 16, 2017

Re: [Pharo-users] Parser for javascript mongodb (json) notation selects

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

Thank you very much! But could you help me, please, to setup SmaCC into my Pharo? Your's faithfully, Khrystyna Mykhailiuk 2017-04-16 20:57 GMT+03:00 Tudor Girba <tudor(a)tudorgirba.com>: > Hi, > > SmaCC ships with a JS parser. Please take a look at it. > > Cheers, > Doru > > > > On Apr 16, 2017, at 3:42 PM, chrismihaylyk <chrismihaylyk(a)gmail.com> > wrote: > > > > Hello, friends! > > > > I'm creating MongoDBBrowser that have all CRUD operations and I need a > > parser that translates javascript queries to MongoDB into the queries > (for > > making selects, inserts etc.) using MongoQuery class. > > For example, I have query > > > > db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, { > > description: { $regex: /test/i } } ] } ) > > > > that is manually rewriting into > > someCollection select: { > > '$or' -> { > > { 'name' -> { > > '$regex' -> 'test' . > > '$options' -> 'i' } asDictionary } asDictionary. > > { 'description' -> { > > '$regex' -> 'test' . > > '$options' -> 'i' } asDictionary } asDictionary > > } > > } asDictionary > > > > But I need to have a parser that will do it automatically. > > > > Maybe there are already exist one? If not, how to write my own? > > Please help. > > > > Thanks a lot, Khrystyna=) > > > > > > > > -- > > View this message in context: http://forum.world.st/Parser- > for-javascript-mongodb-json-notation-selects-tp4942299.html > > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > > > > -- > www.tudorgirba.com > www.feenk.com > > "Reasonable is what we are accustomed with." > > >

April 16, 2017

Re: [Pharo-users] Parser for javascript mongodb (json) notation selects

by Tudor Girba

Hi, SmaCC ships with a JS parser. Please take a look at it. Cheers, Doru > On Apr 16, 2017, at 3:42 PM, chrismihaylyk <chrismihaylyk(a)gmail.com> wrote: > > Hello, friends! > > I'm creating MongoDBBrowser that have all CRUD operations and I need a > parser that translates javascript queries to MongoDB into the queries (for > making selects, inserts etc.) using MongoQuery class. > For example, I have query > > db.SomeCollection.find( {$or: [ { name: { $regex: /test/i } }, { > description: { $regex: /test/i } } ] } ) > > that is manually rewriting into > someCollection select: { > '$or' -> { > { 'name' -> { > '$regex' -> 'test' . > '$options' -> 'i' } asDictionary } asDictionary. > { 'description' -> { > '$regex' -> 'test' . > '$options' -> 'i' } asDictionary } asDictionary > } > } asDictionary > > But I need to have a parser that will do it automatically. > > Maybe there are already exist one? If not, how to write my own? > Please help. > > Thanks a lot, Khrystyna=) > > > > -- > View this message in context: http://forum.world.st/Parser-for-javascript-mongodb-json-notation-selects-t… > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > -- www.tudorgirba.com www.feenk.com "Reasonable is what we are accustomed with."

April 16, 2017

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

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

Thank you very much! Now I understand. 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? 2017-04-16 18:19 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: > > > On 16 Apr 2017, at 16:37, chrismihaylyk <chrismihaylyk(a)gmail.com> wrote: > > > > HI, friends! > > > > Can anyone help me how to convert literal array: #(2 3 4) > > into the dynamic array: {2. 3. 4}? > > this is not a dynamic array (that does not exist on Pharo). > check, if you do: > > #(2 3 4) = {2. 3. 4} ==> true > > and: > > #(2 3 4) class = {2. 3. 4} class ==> true > > in fact, the only difference between them is that the first is literal (it > will be as is in the compiled code) and the second is a runtime array (it > will be evaluated on execution). > > Now, perhaps what you want is to transform an Array into a Collection that > accepts additions (that would be a âdynamicâ collection on Pharo).. > > For that you can do: > > a := #(2 3 4) asOrderedCollection. > a add: 5. > > a ==> anOrderedCollection(2 3 4 5). > > (note that you could want a Setâ¦ or whateverâ¦ but the most common > transformation is an array into an OrderedCollection (because it preserves > order, etc.) > > cheers, > Esteban > > > > > Thanks a lot, Khrystyna! > > > > > > > > -- > > View this message in context: http://forum.world.st/Convert- > Literal-array-into-Dynamic-array-tp4942305.html > > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. > > > > >

April 16, 2017

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

by Esteban Lorenzano

> On 16 Apr 2017, at 16:37, chrismihaylyk <chrismihaylyk(a)gmail.com> wrote: > > HI, friends! > > Can anyone help me how to convert literal array: #(2 3 4) > into the dynamic array: {2. 3. 4}? this is not a dynamic array (that does not exist on Pharo). check, if you do: #(2 3 4) = {2. 3. 4} ==> true and: #(2 3 4) class = {2. 3. 4} class ==> true in fact, the only difference between them is that the first is literal (it will be as is in the compiled code) and the second is a runtime array (it will be evaluated on execution). Now, perhaps what you want is to transform an Array into a Collection that accepts additions (that would be a âdynamicâ collection on Pharo).. For that you can do: a := #(2 3 4) asOrderedCollection. a add: 5. a ==> anOrderedCollection(2 3 4 5). (note that you could want a Setâ¦ or whateverâ¦ but the most common transformation is an array into an OrderedCollection (because it preserves order, etc.) cheers, Esteban > > Thanks a lot, Khrystyna! > > > > -- > View this message in context: http://forum.world.st/Convert-Literal-array-into-Dynamic-array-tp4942305.ht… > Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com. >

April 16, 2017