search for: is_deleted

...a migrations question here. Using: rails 2.0.2 ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin] mysql 5.0.45 Platform: windows xp The problem: ---------- I created a migration that is designed to add a column named "deleted_at" (timestamp) and then remove a column named "is_deleted" (boolean). The idea is to upgrade from merely tracking whether a record has been non-destructively deleted to tracking both if and when it has been non-destructively deleted. NULL values in "deleted_at" indicate a normal, non-deleted record. The trick and problem is to keep existin...

I dont want to delete the records from my tables but just set a column is_deleted to true. What is the best (clean)way to implement this? Is there any way of defining a model which includes only a set of records which satisfy a certain conditions.eg a condition to include the records for which is_deleted is false some thing like this def User << ActiveRecord::Base :co...

...g, because records must be kept for auditing and customer service tracking purposes. In the past, I''ve implemented logical deletes as follows: 1. Oracle implementation: Each table that must implement logical deletes has a view, eg: USERS_RAW => real table, has columns: is_deleted(boolean,default false) date_deleted(timestamp, default null) USERS => is a view on USERS_RAW (where isdeleted = false) Oracle allows updating such a view without any extra triggers, so from RoR point of view this is completely transparent. PostgreSQL allows updating views, b...

hi! short question about aaf: is there a builtin functionality in acts_as_ferret to exclude records from being indexed when for example a column "is_deleted" / "is_disabled" / "dont_index" has a certain value? regards neongrau -- Posted via http://www.ruby-forum.com/.

...esc_short` AS t0_r2, employees.`picture_url` AS t0_r3, employees.`contract` AS t0_r4, employees.`available` AS t0_r5, employees.`address` AS t0_r6, employees.`comments` AS t0_r7, employees.`creation_date` AS t0_r9, employees.`last_update` AS t0_r10, employees.`is_featured` AS t0_r11, employees.`is_deleted` AS t0_r12, employees.`is_hidden` AS t0_r13, skills.`id` AS t1_r0, skills.`parent_id` AS t1_r1, skills.`name` AS t1_r2, skills.`desc_short` AS t1_r3 FROM employees LEFT OUTER JOIN skills_employees ON skills_employees.recipe_id = employees.id LEFT OUTER JOIN skills ON skills.id = skills_employe...

...mber of forum topics based on a category name passed via the URI: @topic_pages, @topics = paginate :topics, :joins => "INNER JOIN categories ON topics.category_id = categories.id", :conditions => ["topics.is_deleted != 1 AND categories.safe_name = ?", params[:category_name]], :order_by => "topics.is_sticky DESC, topics.id DESC", :per_page => 20 Then, on my topics listing page I try this: for topic in @topics link_to h(...

Hi, My name is santoshkumar r Patil. I am using ferret for searching. I am using mult_search for searching a query on multiple modal and there are different conditions on different model. EX User.multi_search(search_query+" AND NOT is_deleted:1 ",[Program],{:limit=>limit,:offset=>offset}) And I have to condition "is_visible = true" on program model. How can I modify above query. Can we you INNER JOIN query in find_by_contents and in mult_search -- Regads Santosh R Patil Antiz Technologes (P) Limited Mobile No...

...nil, "updated_at"=>nil, "security_token"=>nil, "role"=>nil, "country"= >nil, "zip_code"=>"265", "gender"=>nil, "token_expiry"=>nil, "is_verified"=>0, "birthday"=>nil, "is_deleted"=>0, "display_name"=>"invalid zip", "logged_in_at"=>nil, "salted_password"=>"", "created_at"=>nil, "email"=>"invalid...@myapp.com"}, @password_confirmation="asecurepassword", @new_passwo...