On Sat, Dec 4, 2010 at 2:52 AM, Frank Church <[email protected]> wrote:
>
> I am looking for a SqueakDBX demo that shows how to display the output of
> records from the database, like outputting them in a tabular format.
>
Does anyone know of an example somewhere?
>
>
HI Frank. All the applications I know are using SqueakDBX but trought
GlorpDBX (an ORM). But anyway, I am not sure I undertand your problem. I
recommend you to take a look to all the tests in the class DBXQueryTest.
For example, you can do this:
testIterateResultSet
| conn result select aRow |
conn := self doConnectAndOpen.
select := 'SELECT * FROM student'.
result := conn execute: select.
[ aRow := result nextRow.
"Do something with aRow"
] doWhileTrue: [ aRow notNil ].
self assert: aRow isNil.
result releaseResult.
conn disconnect
And to DBXRow, you can ask values (accessing by index or by name),
descriptions, converting or not so String, etc...
For example, check the class DBXTranscript >> showResultSet: resultSet
showResultSet: resultSet
| stream |
stream := String new writeStream.
resultSet columnDescriptions
do: [:each | stream nextPutAll: each name]
separatedBy: [stream nextPutAll: ' | '].
Transcript show: stream contents;
cr.
resultSet
rowsDo: [:row |
stream := String new writeStream.
row values
do: [:each | stream nextPutAll: each asDbxString]
separatedBy: [stream nextPutAll: ' | '].
Transcript show: stream contents;
cr]
What I mean is that since you have reified DBXRow, DBXResultSet, etc...then
you can do whatever you want with that.
Cheers
Mariano
> --
> Frank Church
>
> =======================
> http://devblog.brahmancreations.com
>
