dkubb changed the topic of #datamapper to: Datamapper v1.2.0 | Mailing List: http://is.gd/aa9D | Logs: http://is.gd/qWAL7V | DataMapper 2 Renamed to ROM, see #rom-rb for development
zombor has quit [Ping timeout: 240 seconds]
brianpWins has joined #datamapper
mbj has quit [Ping timeout: 245 seconds]
lfox has joined #datamapper
zombor has joined #datamapper
zombor has quit [Ping timeout: 240 seconds]
zombor has joined #datamapper
zombor has quit [Ping timeout: 264 seconds]
zombor has joined #datamapper
zombor has quit [Ping timeout: 246 seconds]
postmodern has quit [Quit: Leaving]
postmodern has joined #datamapper
zombor has joined #datamapper
zombor has quit [Ping timeout: 240 seconds]
zombor has joined #datamapper
zombor has quit [Ping timeout: 264 seconds]
zombor has joined #datamapper
gregf has joined #datamapper
<gregf>
how can I express select * from foo limit 10,-1; in the orm? I expected to be able to do Foo.all(:limit => [10,-1]), but that doesn't work.
zombor has quit [Remote host closed the connection]
lfox has quit [Quit: ZZZzzz…]
<dkubb>
gregf: so what is your intention, returning the last 10 items from the query?
<gregf>
dkubb: in sqlite doing limit 10,-1 will return all rows after 10th item
<dkubb>
gregf: oh I see.. hmm. what about Foo.all(:offset => 10) ?
<gregf>
my end goal is to only keep the first 100 rows in a table
<gregf>
offset might be what i want, i just know enough sql to be dangerous :) let me take a look
<dkubb>
gregf: then you could try: Foo.all(:limit => 100, :offset => 10) or even Foo[10, 100]
<dkubb>
I designed the DM model and collection interfaces to match Array as much as possible, so #[] works the same as Array#[] in most respects
<gregf>
dkubb: thanks a lot, offset is what I was looking for
<gregf>
good to know about the arrays as well
<dkubb>
sweet
<gregf>
ok i can go to sleep without wondering all night now, thank you again
<dkubb>
gregf: no problem
stormwin1 has joined #datamapper
stormwind has quit [Ping timeout: 246 seconds]
dkubb has quit [Ping timeout: 245 seconds]
dkubb has joined #datamapper
postmodern has quit [Quit: Leaving]
mbj has joined #datamapper
mikecmpbll has joined #datamapper
zombor has joined #datamapper
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mikecmpbll has joined #datamapper
mikecmpbll has quit [Client Quit]
mikecmpbll has joined #datamapper
mikecmpbll has quit [Client Quit]
mikecmpbll has joined #datamapper
mikecmpbll has quit [Client Quit]
mikecmpbll has joined #datamapper
zombor has quit [Read error: Connection reset by peer]
zombor_ has joined #datamapper
gregf has quit [Quit: WeeChat 0.4.2]
lfox has joined #datamapper
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mikecmpbll has joined #datamapper
zombor_ has quit [Remote host closed the connection]
lfox has quit [Quit: ZZZzzz…]
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mbj has quit [Ping timeout: 248 seconds]
mikecmpbll has joined #datamapper
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mikecmpbll has joined #datamapper
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mikecmpbll has joined #datamapper
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mbj has joined #datamapper
mikecmpbll has joined #datamapper
mikecmpbll has quit [Quit: Computer has gone to sleep.]
mikecmpbll has joined #datamapper
postmodern has joined #datamapper
brianpWins has quit [Quit: brianpWins]
mikecmpbll has quit [Quit: Computer has gone to sleep.]