On 12/3/2010 7:52 PM, Frank Church 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?
Hello, I apologize, I didn't even see this message until I saw Mariano's reply. I use SqueakDBX directly without Glorp connecting to a PostgreSQL database with about 50 million rows currently. I am storing minutes of financial data. Since my data is by its nature very tabular I saw no need for using an ORM. My use is very simple but maybe it will help. I currently only use SqueakDBX for retrieving this data. The data is inserted via a different program. Here is the method I use to get my data and insert it into a Matrix. loadOHLC "Loads the Open High Low Close (bid/ask) and hlavg, hlcavg columns from the database. Creates a OneWeekData (Matrix) object for the data." | con rows | con := self otogConnection. rows := (con execute: 'select startdate, bidopen, bidhigh, bidlow, bidclose, askopen, askhigh, asklow, askclose from ', self instrument, ' where (', self week asDbxString, ' < startdate) AND (startdate < ', self weekEnd asDbxString , ')') rows. ohlc := OneWeekData rows: (rows size) columns: 10. 1 to: rows size do: [:row || newRow | newRow := ((rows at: row) values). newRow := newRow copyWith: (((newRow at: 3) + (newRow at: 4) + (newRow at: 5)) / 3). ohlc atRow: row put: newRow ]. Maybe this real world example will help. As I said my usage is simple. SqueakDBX has worked very well for me. I simply wrote the sql statement I wanted executed with my columns ordered as I wanted for the rows retrieved. If I remember correctly each rows values are when passed the "values" message return an Array which is what I pass to my Matrix. If we aren't providing the answers desired. Please provide more information to direct us. Mariano has been very helpful for any of my questions. Jimmie