Example with SQL placed in code

[Eduardo M. Cavalcanti]

Hi,
Is it possible to show or point out an example of issuing a query with
orbroker having the SQL placed inside the code?
Thank you

[Nils Kilden-Pedersen]

http://code.google.com/p/orbroker/wiki/HelloWorld

[Nils Kilden-Pedersen]

Or, if you need apply an extractor, use Token like this:

val token = Token("SELECT * FROM TABLE", 'id, Extractor, "foo"->bar)

[Eduardo M. Cavalcanti]

Hi,
Is it possible to show or point out an example of issuing a transaction
with Orbroker?
Thank you

[Nicholas Ustinov]

Hello.
Well, simple example you can find here:
http://code.google.com/p/orbroker/wiki/GeneratedKeys
i speak about last code block:
...
val savedItem = broker.transaction() { txn =>
val newId = txn.executeForKey(InsertItem, "item"->newItem)
item.copy(id = newId)
}

all calls in transaction(){ } block are executed in single
transaction, which is commited by default or rollbacked if any
exceptions arised.

also smth interesting you can find in tests, e.g. here:
http://code.google.com/p/orbroker/source/browse/src/test/scala/test/orbroker/example/TestBroker.scala?name=3.2
especially with "transactional" blocks, where you can commit/rollback explicitly

Nicholas

2011/5/28 Eduardo M. Cavalcanti <eduardo.c...@eversystems.com.br>:

[Nils]

On Thursday, May 12, 2011 3:31:49 PM UTC-5, Nils wrote:

Or, if you need apply an extractor, use Token like this:

val token = Token("SELECT * FROM TABLE", 'id, Extractor, "foo"->bar)

This is of course wrong. The parameters are not supplied in the token definition. Should be:

val token = Token("SELECT * FROM TABLE", 'id, Extractor)

[Eduardo M. Cavalcanti]

Thank you, Nils.
By the way, I have been using Orbroker with pleasure.