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
<mbj> dkubb: I need to handle it, yeah!
<mbj> will go to sleep now, cu later
mbj has quit [Quit: leaving]
dkubb has quit [Quit: Linkinus - http://linkinus.com]
snusnu has quit [Quit: Leaving.]
zombor_ has quit [Remote host closed the connection]
rsim has joined #datamapper
rsim has quit [Ping timeout: 240 seconds]
dkubb has joined #datamapper
dkubb has quit [Quit: Leaving...]
rsim has joined #datamapper
rsim has quit [Ping timeout: 241 seconds]
mbj has joined #datamapper
mbj_ has joined #datamapper
<mbj_> .
mbj has quit [Ping timeout: 260 seconds]
mbj_ is now known as mbj
snusnu has joined #datamapper
postmodern has quit [Quit: Leaving]
didlix_ is now known as didlix
zombor has joined #datamapper
zombor has joined #datamapper
zombor has quit [Changing host]
zombor has quit [Remote host closed the connection]
rsim has joined #datamapper
zombor has joined #datamapper
rsim has quit [Ping timeout: 240 seconds]
hansli has joined #datamapper
<hansli> hi. are there issues with ARM and gem install data_mapper?
hansli has quit [Quit: Page closed]
hansli has joined #datamapper
hansli has quit [Client Quit]
rsim has joined #datamapper
rsim has quit [Ping timeout: 241 seconds]
rsim has joined #datamapper
solnic has joined #datamapper
rsim has quit [Quit: Leaving.]
solnic has quit [Quit: Leaving...]
rsim has joined #datamapper
rsim has quit [Ping timeout: 240 seconds]
PolarFox has quit [Quit: leaving]
rsim has joined #datamapper
v0n has joined #datamapper
zombor has quit [Remote host closed the connection]
zombor has joined #datamapper
zombor has joined #datamapper
zombor has quit [Changing host]
zombor has quit [Ping timeout: 256 seconds]
markalanevans has joined #datamapper
<markalanevans> Hey folks, i'm trying to do a group by count
<markalanevans> For ex:
<markalanevans> SELECT count(*)
<markalanevans> FROM product_comparrisons pc
<markalanevans> WHERE pc.created_at >= #{from} AND pc.created_at < #{to} AND NOT (pc.upc IS NULL)
<markalanevans> GROUP by pc.app_id
<markalanevans> where to and from params that i would pass into a function
<markalanevans> The docs for grouping are kinda vaque
<markalanevans> I started to go down a route using: repository.adapter.query
<markalanevans> but there is now docs on that, just stack overflow mentions
<markalanevans> and so i'm not sure about how to go about using that concept witha method in my model of which I can pass params.
<markalanevans> the to / from params.
zombor has joined #datamapper
zombor has joined #datamapper
zombor has quit [Changing host]
zombor has quit [Ping timeout: 264 seconds]
zombor has joined #datamapper
zombor has quit [Changing host]
zombor has joined #datamapper
zombor has quit [Ping timeout: 264 seconds]
rsim has quit [Quit: Leaving.]
v0n has quit [Ping timeout: 260 seconds]
zombor has joined #datamapper
zombor has quit [Ping timeout: 246 seconds]
rsim has joined #datamapper
rsim has quit [Ping timeout: 240 seconds]
<markalanevans> How do i do group by and counts ?
<markalanevans> How do you do a group by in Datamapper?
<mbj> markalanevans: dm-aggregates might do the job
<mbj> But AFAIK your use case is not possible with plain dm-1, sorry.
<mbj> dm-2 AKA rom will feature this stuff.
<markalanevans> mbj: ok. So thats fine, but what do they suggest we do ?
<markalanevans> how do i still use the datamapper object or model to write my own custom queries?
<markalanevans> I need to select count(*) and group by, and then i need to sum up the totals of those grouped.
<mbj> markalanevans: Define a view, and a readonly model, helps you?
<mbj> markalanevans: So you could query that view.
<mbj> markalanevans: But look into dm-aggregates, it maybe allows your grouping!
<mbj> Never used all of its features.
<markalanevans> Ok. Ill check that first, but the view idea might work also
PolarFox has joined #datamapper
postmodern has joined #datamapper
zombor has joined #datamapper
zombor has joined #datamapper
zombor has quit [Changing host]
zombor has quit [Remote host closed the connection]
v0n has joined #datamapper