Easy way


#1

Best way to do this:

Pseudo code

(word is unique)

1 Select * from words where word = “test”
2 If result > 0 then update words set count = coun +1
3 else Insert into words (word, count) values (“test”, 1)


#2

Sorry

2 If result > 0 then update words set count = coun + 1 where word = “test”


#3

On Tue, Nov 25, 2008 at 5:10 PM, Gi Ga
removed_email_address@domain.invalid wrote:

Best way to do this:

Pseudo code

(word is unique)

1 Select * from words where word = “test”
2 If result > 0 then update words set count = coun +1
3 else Insert into words (word, count) values (“test”, 1)

class Word < ActiveRecord::Base
end

word = Word.find_or_create_by_name(“test”)
word.count = word.count + 1
word.save

will propably do the job


Gabriel L. removed_email_address@domain.invalid