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 has quit [Quit: leaving]
Sylvain1 has quit [Quit: Leaving.]
g0bl1n has quit [Ping timeout: 245 seconds]
careo has quit [Quit: careo]
Sylvain1 has joined #datamapper
<dkubb>
!memo mbj can you create a PR for your flexible-rspec branch?
<Cinchy>
dkubb: Memo recorded for mbj.
Sylvain2 has joined #datamapper
zombor has joined #datamapper
zombor has joined #datamapper
zombor has quit [Changing host]
Sylvain1 has quit [Ping timeout: 240 seconds]
zombor has quit [Ping timeout: 256 seconds]
cobbr2 has quit [Quit: Leaving.]
kurko_ has quit [Quit: Computer has gone to sleep.]
<snusnu>
dkubb: you could just create that PR for yourself and start commenting?
kurko_ has joined #datamapper
myobie has joined #datamapper
kurko_ has quit [Quit: Computer has gone to sleep.]
Sylvain1 has joined #datamapper
Sylvain2 has quit [Ping timeout: 245 seconds]
Sylvain1 has quit [Client Quit]
kurko_ has joined #datamapper
theCrab has quit [Ping timeout: 245 seconds]
myobie has quit [Quit: myobie]
myobie has joined #datamapper
maxzda__ has joined #datamapper
maxzda__ has quit [Client Quit]
maxzda_ has quit [Ping timeout: 260 seconds]
myobie has quit [Quit: myobie]
postmodern has quit [Quit: Leaving]
franckverrot_ has joined #datamapper
franckverrot has quit [Ping timeout: 240 seconds]
kurko_ has quit [Quit: Computer has gone to sleep.]
zombor has joined #datamapper
snusnu has quit [Quit: Leaving.]
myobie has joined #datamapper
kurko_ has joined #datamapper
kurko__ has joined #datamapper
MarcWebe1 has joined #datamapper
<mralk3>
if i have a record in my database with the column title and the title is 'Hello World', how would i write select title from contents where title like '%World%'; as a query in data mapper?
<mralk3>
trying to make a search engine and it doesnt find the article with similar keywords or upper / lower case
kurko_ has quit [Ping timeout: 240 seconds]
irclogger_com has quit [Ping timeout: 240 seconds]
<onewheelskyward>
You can say Model.all(title.like: 'world')
<onewheelskyward>
If you case it the way it is in the database. Titlecase I hope?
<onewheelskyward>
If not you can do a direct query.
<onewheelskyward>
lower(title) like '%world%'
<mralk3>
alright
kurko_ has quit [Quit: Computer has gone to sleep.]
<onewheelskyward>
Actually, you might have to use (title.like => 'world') I can't remember if the new syntax works with those guys.
<mralk3>
.like works but i dont know how to make it recognize lower case or uppercase words
<mralk3>
which is what i am looking at now lol
cobbr2 has joined #datamapper
<mralk3>
result = Content.first(:title.like => '%world%')
<mralk3>
works
zombor has quit [Remote host closed the connection]
<onewheelskyward>
nice.
<mralk3>
if you had a parameter sent to it
<mralk3>
result = Content.first(:title.like => '%' + keyword + '%')
<onewheelskyward>
Try "%#{keyword}%"
<mralk3>
ok so then "%#{params[:title]}%" ?
<mralk3>
trying to get sinatra to pass the keyword to datamapper
myobie has quit [Quit: myobie]
<dkubb>
be careful about passing params directly to a query
<dkubb>
well, hmm.. lemme think about that
<dkubb>
actually, after confirming with the SQL generation that'll get transformed into "title LIKE ?" with a bind value of "%#{keyword}%" which should get escaped properly
<mralk3>
@results = Content.first(:title.like => "%#{params[:title]}%" ) gives WHERE `title` LIKE '%world%'
<mralk3>
i know how to do this with php / sql
rsim has joined #datamapper
<dkubb>
yeah, what actually happens is that DataMapper generates a query with the ? placeholder, then sends it off to the database driver which uses the database's native quoting method to merge it in. the result is what gets logged
<mralk3>
ok so then i need to manipulate the string prior to sending it to datamapper
cobbr2 has quit [Quit: Leaving.]
cobbr2 has joined #datamapper
rsim has quit [Quit: Leaving.]
rsim has joined #datamapper
v0n has joined #datamapper
v0n has quit [Ping timeout: 245 seconds]
solnic has joined #datamapper
solnic has quit [Quit: Leaving...]
solnic has joined #datamapper
solnic has quit [Read error: Connection reset by peer]
postmodern has joined #datamapper
snusnu has joined #datamapper
solnic has joined #datamapper
solnic has quit [Quit: Leaving...]
mbj has joined #datamapper
<mbj>
.
<Cinchy>
mbj: [10h 19m 50s ago] <dkubb> can you create a PR for your flexible-rspec branch?
mbj has quit [Quit: leaving]
tchebb has quit [Ping timeout: 264 seconds]
postmodern has quit [Quit: Leaving]
dbussink has quit [Read error: Operation timed out]
cobbr2 has quit [Quit: Leaving.]
dbussink has joined #datamapper
irclogger_com has quit [Ping timeout: 240 seconds]
irclogger_com has joined #datamapper
tchebb has joined #datamapper
zombor has joined #datamapper
mbj has joined #datamapper
zombor has quit [Remote host closed the connection]
g0bl1n has joined #datamapper
zombor has joined #datamapper
g0bl1n has quit [Ping timeout: 245 seconds]
rsim has quit [Quit: Leaving.]
v0n has joined #datamapper
CWSpear has joined #datamapper
CWSpear has left #datamapper [#datamapper]
rsim has joined #datamapper
rsim has quit [Ping timeout: 240 seconds]
rsim has joined #datamapper
snusnu has quit [Quit: Leaving.]
zombor has quit [Remote host closed the connection]
<dkubb>
!memo solnic lmk what I can do to make yardstick more usable during development. I'll work on it early next week until it's at the point where we can enable it, if only partially
<Cinchy>
dkubb: Memo recorded for solnic.
<dkubb>
!memo snusnu lmk what I can do to make yardstick more usable during development. I'll work on it early next week until it's at the point where we can enable it, if only partially
<Cinchy>
dkubb: Memo recorded for snusnu.
mbj has quit [Ping timeout: 245 seconds]
solnic has joined #datamapper
<solnic>
!memo dkubb cool although I wouldn't call this a priority right now, maybe after 0.0.1 it'll become more important (at least from my pov)
<Cinchy>
solnic: Memo recorded for dkubb.
Eiam has quit [Quit: ╯°□°）╯︵ǝpouǝǝɹɟ]
mbj has joined #datamapper
solnic has quit [Quit: Leaving...]
Eiam has joined #datamapper
kurko_ has joined #datamapper
<dkubb>
!memo solnic it's important to me. if it's important enough to you guys to discuss it regularly and actually disable it in the gems then I'm going to take care of it before moving on. I don't like having broken windows in our process.
<Cinchy>
dkubb: [1h 0m 18s ago] <solnic> cool although I wouldn't call this a priority right now, maybe after 0.0.1 it'll become more important (at least from my pov)
<Cinchy>
dkubb: Memo recorded for solnic.
zombor has joined #datamapper
rsim has quit [Quit: Leaving.]
rsim has joined #datamapper
rsim has quit [Ping timeout: 240 seconds]
v0n has quit [Ping timeout: 264 seconds]
<Eiam>
dkubb: email? =)
kurko_ has quit [Quit: Computer has gone to sleep.]
kurko_ has joined #datamapper
<Eiam>
!memo dkubb why don't you use email?
<Cinchy>
Eiam: Memo recorded for dkubb.
mbj has quit [Ping timeout: 240 seconds]
zombor has quit [Remote host closed the connection]
myobie has joined #datamapper
<dkubb>
!memo Eiam because this is easier :P
<Cinchy>
dkubb: [1h 23m 49s ago] <Eiam> why don't you use email?
<Cinchy>
dkubb: Memo recorded for Eiam.
<Eiam>
=p
<Cinchy>
Eiam: [18s ago] <dkubb> because this is easier :P
<dkubb>
Eiam: also, we try to be as transparent as possible when discussing things
<dkubb>
I hate it when lots of stuff in an oss project are decided behind closed doors
<Eiam>
open mailing list
<Eiam>
datamapper-dev ?
<dkubb>
that's true too
<Eiam>
(I don't particularly care)
<dkubb>
I don't really like mailing lists tbh
<Eiam>
i just thought it was amusing, as I have not seen !memo in a long long time
<dkubb>
I just don't like to context switch
<Eiam>
and I've been on IRC for way too long
<dkubb>
really? I think we use !memo everyday. that's weird you haven't seen in
<Eiam>
i love irc and wish everyone would use it more often
rsim has joined #datamapper
<Eiam>
dkubb: yes, its very much a this channel thing for me =p
<dkubb>
actually, if we had the bot in #rom-rb we'd probably leave messages there too
<dkubb>
it does feel a bit weird to have most discussion about ROM in one place and then have to leave messages in another support channel
<Eiam>
probably should have called it data mapper 3
<Eiam>
and kept the community in one place
<dkubb>
lol
<dkubb>
nah, we talked about that
<Eiam>
I'm sure you have =)
<dkubb>
the problem is ROM is so completely different from the misnamed DataMapper 1
<Eiam>
I doubt I'm the first random joe to mention it
<dkubb>
actually, I argued the most for keeping the name DataMapper
rsim has quit [Ping timeout: 240 seconds]
<dkubb>
I felt like we had some brand recognition, but then I was like "ok, I'll entertain some names if we can actually pick some good contenders instead of just talking about the possibility of renaming"
<dkubb>
it was bugging me people wanted to change the name without actually having a proposal
<dkubb>
ROM == Ruby Object Mapper is pretty good imho, and it doesn't use a pattern for a name. plus we have a nice logo: https://github.com/rom-rb