Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
latest update_index method
def self.update_index(observer_search_data)
# Would be nice to use AR here but not sure how to execut Postgres functions
# when inserting data like this.
rows = Post.exec_sql_row_count("UPDATE #{observer_search_data.table_name} SET search_data = TO_TSVECTOR('english', ?) WHERE #{observer_search_data.foreign_key} = ?", observer_search_data.search_data, observer_search_data.id)
if rows == 0
Post.exec_sql("INSERT INTO #{observer_search_data.table_name} (#{observer_search_data.foreign_key}, search_data) VALUES (?, TO_TSVECTOR('english', ?))", observer_search_data.id, observer_search_data.search_data)
end
rescue
# don't allow concurrency to mess up saving a post
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment