OpenGamma / ElSql

Manage external SQL files in Java with a little DSL goodness
Other
101 stars 26 forks source link

Provide simple looping support #7

Closed jodastephen closed 11 years ago

jodastephen commented 11 years ago

The aim of elsql is to keep complex SQL in the code, however a simple looping facility can occasionally be useful in the elsql file.

@NAME(Test1)
  SELECT * FROM foo WHERE
  @LOOP(:size)
    (a = :a@LOOPINDEX AND b = :b@LOOPINDEX)
    @LOOPJOIN OR