Displaying 1 result from an estimated 1 matches for "uncommented_posts".
2013 Mar 11
0
Any interest in various features from "schema_plus" gem?
...actually has ''foreign_key: true'' as the default behavior,
for rails i''d probably make the default be false (configurable)
Views:
create_view :posts_commented_by_staff, Post.joins(comment:
user).where(users: {role: ''staff''}).uniq
create_view :uncommented_posts, "SELECT * FROM posts LEFT OUTER JOIN
comments ON comments.post_id = posts.id WHERE comments.id IS NULL"
And a few other smaller things:
drop_table :table_name, if_exists: true, cascade: true # :if_exists
and :cascade options to drop_table
t.datetime :seen_at, default: { ex...