May 2015 - Pharo-users - lists.pharo.org

Re: [Pharo-users] Reading rows in a database table (select * from ...)

by Sanjay Minni

Sergio - Are you using DBX - there seem to be (-ve) comments on DBX here http://forum.world.st/Oracle-on-Linux-td4816854.html#a4816876 for Windows ODBC seems to be successfully used across many RDBMS engines here http://forum.world.st/Question-regarding-crashes-using-OpenDBXDriver-td4796… Not sure about a stable approach on Linux ... which I am also looking for Unfortunately RDBMS is central to my world regards Sanjay ----- --- Regards, Sanjay -- View this message in context: http://forum.world.st/Reading-rows-in-a-database-table-select-from-tp482300… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

May 1, 2015

Re: [Pharo-users] OSProcess output to pharo

by David T. Lewis

On Fri, May 01, 2015 at 09:04:59AM +0800, Pierce Ng wrote: > On Tue, Apr 28, 2015 at 11:39:56AM -0400, David T. Lewis wrote: > > Yes, that is the correct way to do it. > > David, > > It seems Command Shell doesn't handle REPL applications like the sqlite3 shell, > tclsh and goodsrv. How difficult is that to implement, in your view? > Alternatively (unless they are the same stuff underneath) how to go about > building something like Expect or pexpect? Hi Pierce, I'm not sure if I am understanding your question, but please have a look at PipeableOSProcess class>>tkExample. This is an example of having your image talking to a REPL shell, /usr/bin/wish in this case, but probably similar to a sqlite3 shell. The wish shell is a tclsh interpreter with Tk gui, so I expect that is close to what you are trying to do. If you are interested in having your squeak/pharo image be the REPL server, then class ExternalCommmandShell may be closer to what you want. Dave

May 1, 2015

Re: [Pharo-users] Reading rows in a database table (select * from ...)

by Pierce Ng

On Thu, Apr 30, 2015 at 06:29:53AM -0700, Sanjay Minni wrote: > the smalltalkhub page shows an example > db execute: 'SELECT * FROM BLOGPOSTS;'. > but how are the rows supposed to be accessed - in the tests i see they have > to be walked thru one by one like a 3GL loop Sanjay, Here's how you can collect all rows: | db resultSet row coll | coll := OrderedCollection new. db := NBSQLite3Connection openOn: '/tmp/so.db'. [ resultSet := db execute: 'select * from posts limit 10'. [ (row := resultSet next) notNil ] whileTrue: [ coll add: row ] ] ensure: [ db close ]. coll inspect. Each row is an NBSQLite3Row instance. Use #at: with the column name as key to get at the data. coll fifth at: 'Title' ==> 'How do I calculate someone''s age in C#?' With the collection you still have to loop through them, no? I am using NBSQLite3 to play with existing data, and I haven't worked with enough different types of data to attempt to generalize a looping construct. So I've always done by-row processing. Another reason is that, while my data sets aren't "Big Data", I am aesthetically inclined against reading everything into RAM. :-) Above example uses the Sep 2011 StackOverflow data dump. The SQLite datafile created from the dump, with full text indexing, is 16GB and the table posts has ~6.5 million rows. HTH. Pierce

May 1, 2015

Re: [Pharo-users] Package comments

by Sean P. DeNigris

EstebanLM wrote > now we also have the concept of âPackage Manifestâ where you can put > comments and other stuff. Why does RPackage>>#packageManifest (which should just be named #manifest) return an instance of the manifest class, but all metadata is on the class side? ----- Cheers, Sean -- View this message in context: http://forum.world.st/Package-comments-tp4823188p4823415.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

May 1, 2015

Re: [Pharo-users] [ANN] Screencast on Versionner (Part 2)

by Sean P. DeNigris

EstebanLM wrote > provide feedback and enhancement requests Now that our fogbugz issues can specify configs, often they need to be copied to the inbox to be picked up by the monkey. That would be a nice option. ----- Cheers, Sean -- View this message in context: http://forum.world.st/ANN-Screencast-on-Versionner-Part-2-tp4823221p4823414… Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

May 1, 2015

Re: [Pharo-users] OSProcess output to pharo

by Pierce Ng

On Tue, Apr 28, 2015 at 11:39:56AM -0400, David T. Lewis wrote: > Yes, that is the correct way to do it. David, It seems Command Shell doesn't handle REPL applications like the sqlite3 shell, tclsh and goodsrv. How difficult is that to implement, in your view? Alternatively (unless they are the same stuff underneath) how to go about building something like Expect or pexpect? Pierce

May 1, 2015

Re: [Pharo-users] Question about Text Editor.

by Pierce Ng

On Wed, Apr 29, 2015 at 06:04:49PM -0300, Mariano Martinez Peck wrote: > Not a text editor, but there was a ScriptManager that was kind of a > worksapce with ability to give scripts a name, save them, and then easily > browse and execute them. But this is a bit old, so not sure if this still > works in Pharo 4.0: Yes it works in Pharo 4. Install it from the config browser. Pierce

May 1, 2015

Re: [Pharo-users] [ANN] Screencast on Versionner (Part 2)

by Mariano Martinez Peck

Esteban, Imagine I do have already the ConfigurationOfMyApp (with everything already setup). I want to commit multiple packages together. By that I mean: 1) Wanna see a "Changes" from all dirty packages of my Configuration 2) I want to write same commit message for all 3) Commit all packages to the correct repository But...I do not want to create a new version in the ConfigurationOfMyApp nor commit it. Can I do that? Thanks in advance, On Thu, Apr 30, 2015 at 7:43 PM, Pablo R. Digonzelli <pdigonzelli(a)gmail.com> wrote: > Esteban, Versionner menu options in Monticello does not work in pharo > 4.0. I am right? > > > > ------------------------------ > *Ing. Pablo Digonzelli* > Software Solutions > IP-Solutiones SRL > Metrotec SRL > 25 de Mayo 521 > San Miguel de TucumÃ¡n > Email: pdigonzelli(a)softsargentina.com > pdigonzelli(a)gmail.com > Cel: 5493815982714 > > ------------------------------ > *De: *"GastÃ³n Dall' Oglio" <gaston.dalloglio(a)gmail.com> > *Para: *"Any question about pharo is welcome" <pharo-users(a)lists.pharo.org > > > *Enviados: *Jueves, 30 de Abril 2015 17:49:34 > *Asunto: *Re: [Pharo-users] [ANN] Screencast on Versionner (Part 2) > > Thanks!!! > > > 2015-04-30 10:31 GMT-03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: > >> Hi again, >> Now I made a small video on how to use Versionner to help you manage your >> releases and commits. >> >> https://youtu.be/cFRJDuWL-Q0 >> >> This is new stuff, so you will need latest Pharo 5 to use it, >> alternatively you can install latest Versionner into Pharo 4 (I donât know >> how it will work on Pharo 3, youâll probably need to load Glamour as well >> others). >> In Pharo 4, you can install it executing: >> >> Gofer it >> smalltalkhubUser: 'PharoExtras' project: 'Versionner'; >> configuration; >> loadVersion: '2.12.2'. >> >> cheers, >> Esteban >> >> >> > -- Mariano http://marianopeck.wordpress.com

May 1, 2015