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
