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