Displaying 1 result from an estimated 1 matches for "posts_commented_by_staff".
2013 Mar 11
0
Any interest in various features from "schema_plus" gem?
...gnKeyDefinition
objects
# and add_foreign_key, remove_foreign_key,
connection.reverse_foreign_keys
# schema_plus 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_ex...