Created
November 7, 2014 07:49
-
-
Save osiro/f48cecd28b0d6c09d0a5 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Instance method "open" is already defined in Object, use generic helper instead or set StateMachine::Machine.ignore_method_conflicts = true. | |
Admins can edit a contributor's links | |
{"relname"=>"spree_stock_locations", "rowcount"=>"1"} | |
{"relname"=>"spree_prices", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"2"} | |
{"relname"=>"spree_products", "rowcount"=>"1"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"1"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"1"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"3"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"3"} | |
should have link "http://google.com" | |
Admins can create new e-book product variants | |
{"relname"=>"spree_stock_locations", "rowcount"=>"1"} | |
{"relname"=>"spree_prices", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"2"} | |
{"relname"=>"spree_coverings", "rowcount"=>"2"} | |
{"relname"=>"spree_products", "rowcount"=>"1"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"1"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"1"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"3"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"3"} | |
Create ebook successfully | |
Users can view the Classroom Express news listing | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"2"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
/Users/vinny/.rvm/gems/ruby-2.1.2@fremantlepress/gems/activerecord-4.1.7/lib/active_record/attribute_methods/read.rb:70: warning: redefining `object_id' may cause serious problems | |
should have link "Beatae debitis quos et praesentium dolores eos est sit." | |
Users can view the blog post listing | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"2"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
example at ./spec/features/blog/other/view_post_listing_spec.rb:9 (FAILED - 1) | |
Users can browse books | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"2"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
should not have heading "Books for Young Adults" | |
Users can send author booking requests to Fremantle Press | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"2"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
fill in booking form successfully | |
A user can view a list of contributors | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"3"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
should have link "Nick Cave" | |
As a user I can view a contributor's profile | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"3"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
should have link "Product #3 - 8078" | |
As a user I can view the Fremantle Press homepage | |
{"relname"=>"spree_stock_locations", "rowcount"=>"2"} | |
{"relname"=>"spree_prices", "rowcount"=>"5"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_people", "rowcount"=>"3"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"2"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"2"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"2"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"5"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"5"} | |
Viewing recently added products | |
Users can select to buy a product's ebook | |
{"relname"=>"spree_stock_locations", "rowcount"=>"4"} | |
{"relname"=>"spree_prices", "rowcount"=>"10"} | |
{"relname"=>"spree_option_types", "rowcount"=>"2"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"4"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"3"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"7"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"2"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"4"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"4"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"2"} | |
{"relname"=>"spree_vendors", "rowcount"=>"1"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"2"} | |
{"relname"=>"spree_variants", "rowcount"=>"10"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"4"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"10"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
element div: validity error : ID product-price already defined | |
should have select box "ebook-retailer" with options ["Choose an Ebook Retailer", "Amazon"] | |
A user can see the status of products not available for purchase | |
{"relname"=>"spree_stock_locations", "rowcount"=>"5"} | |
{"relname"=>"spree_prices", "rowcount"=>"12"} | |
{"relname"=>"spree_option_types", "rowcount"=>"3"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"5"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"4"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"8"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"3"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"5"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"5"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"3"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"3"} | |
{"relname"=>"spree_variants", "rowcount"=>"12"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"5"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"12"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
example at ./spec/features/products/view_variant_status_spec.rb:8 (PENDING: No reason given) | |
As a user I can request a quote from Fremantle Press to publish my book | |
{"relname"=>"spree_stock_locations", "rowcount"=>"5"} | |
{"relname"=>"spree_prices", "rowcount"=>"12"} | |
{"relname"=>"spree_option_types", "rowcount"=>"3"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"5"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"4"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"8"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"3"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"5"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"5"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"3"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"3"} | |
{"relname"=>"spree_variants", "rowcount"=>"12"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"5"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"12"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
should text "This is my really awesome book idea" | |
Users can send enquiries to Fremantle Press | |
{"relname"=>"spree_stock_locations", "rowcount"=>"5"} | |
{"relname"=>"spree_prices", "rowcount"=>"12"} | |
{"relname"=>"spree_option_types", "rowcount"=>"3"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"5"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"4"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"8"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"3"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"3"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"5"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"5"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"3"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"3"} | |
{"relname"=>"spree_variants", "rowcount"=>"12"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"5"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"12"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
fill in contact form successfully | |
As a user I can view details about the team at Fremantle Press | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
View the About Us page (FAILED - 2) | |
ApplicationHelper | |
external_link_to | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
opens links in a new window | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
accepts block link syntax without error | |
Wordpress::PageHelper | |
.content_with_galleries | |
for a page with no galleries | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
returns the unaltered content | |
for a page with an embedded gallery | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
returns the content with embedded HTML for a basic gallery (FAILED - 3) | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
can support setting the number of columns in a gallery (FAILED - 4) | |
Spree::OrderMailer | |
order confirmation email | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
BCCs the admin on the email | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
prepends the environment name to the email subject | |
Spree::BookFormat | |
#name | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
should require name to be set | |
Spree::Contributor | |
.beginning_with | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
includes contributors with family names beginning with the provided letter | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
does not include contributors with family names not beginning with the provided letter | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
matches contributors case-insensitively | |
Spree::Covering | |
#name | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
should require name to be set | |
Spree::Link | |
#link_type | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
should require link_type to be set | |
#linkable | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
should belong to linkable | |
#url | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
should require url to be set | |
Spree::Product | |
#authors | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
returns contributors who are marked as the author of the product | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
returns empty if the product has no authors | |
.promoted | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
doesn't include products that have past promotions | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"6"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_states", "rowcount"=>"6"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
doesn't include products that have future promotions | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"1"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"1"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"7"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"2"} | |
{"relname"=>"spree_states", "rowcount"=>"7"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_roles", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_addresses", "rowcount"=>"1"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
doesn't include products that don't have any promotions | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"1"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"1"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"7"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"2"} | |
{"relname"=>"spree_states", "rowcount"=>"7"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_roles", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_addresses", "rowcount"=>"1"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
includes products that have active promotions | |
.random_from_taxon | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"1"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"1"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"7"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"2"} | |
{"relname"=>"spree_states", "rowcount"=>"7"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_roles", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_addresses", "rowcount"=>"1"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
returns products within the specified taxon | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"1"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"1"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"7"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"2"} | |
{"relname"=>"spree_states", "rowcount"=>"7"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_roles", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_addresses", "rowcount"=>"1"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
returns products within the specified taxon's descendant taxons | |
{"relname"=>"spree_stock_locations", "rowcount"=>"6"} | |
{"relname"=>"spree_prices", "rowcount"=>"15"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"1"} | |
{"relname"=>"spree_people", "rowcount"=>"6"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"1"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"1"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"9"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"7"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"2"} | |
{"relname"=>"spree_states", "rowcount"=>"7"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"15"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"6"} | |
{"relname"=>"spree_roles", "rowcount"=>"1"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"15"} | |
{"relname"=>"spree_addresses", "rowcount"=>"1"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"1"} | |
doesn't return products not in the taxon or descendant taxons | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns products in random order | |
#recently_added? | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns products made public within the last 3 months | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not return products made public more than 3 months ago | |
.recently_added | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
only returns the specified number of products | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
orders the products by available_on date, newest first | |
#related_products | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
doesn't return itself | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns other products in the same taxon | |
{"relname"=>"spree_stock_locations", "rowcount"=>"11"} | |
{"relname"=>"spree_prices", "rowcount"=>"20"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_promotions", "rowcount"=>"2"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"3"} | |
{"relname"=>"spree_products", "rowcount"=>"14"} | |
{"relname"=>"spree_taxons", "rowcount"=>"4"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"13"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"13"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"20"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"11"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"20"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not error if the product has no taxons | |
.with_ebooks | |
{"relname"=>"spree_stock_locations", "rowcount"=>"15"} | |
{"relname"=>"spree_prices", "rowcount"=>"25"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"3"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"19"} | |
{"relname"=>"spree_taxons", "rowcount"=>"10"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"17"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"17"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"25"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"25"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not include products with no variants | |
{"relname"=>"spree_stock_locations", "rowcount"=>"15"} | |
{"relname"=>"spree_prices", "rowcount"=>"25"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"3"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"19"} | |
{"relname"=>"spree_taxons", "rowcount"=>"10"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"17"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"17"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"25"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"25"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
includes products that have a variant of e-book covering | |
{"relname"=>"spree_stock_locations", "rowcount"=>"15"} | |
{"relname"=>"spree_prices", "rowcount"=>"25"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"3"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"19"} | |
{"relname"=>"spree_taxons", "rowcount"=>"10"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"17"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"17"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"25"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"25"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not include products with a variant not in e-book covering | |
Spree::Variant | |
#covering | |
{"relname"=>"spree_stock_locations", "rowcount"=>"15"} | |
{"relname"=>"spree_prices", "rowcount"=>"25"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"3"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"19"} | |
{"relname"=>"spree_taxons", "rowcount"=>"10"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"17"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"17"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"25"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"25"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should belong to covering class_name => Spree::Covering | |
{"relname"=>"spree_stock_locations", "rowcount"=>"15"} | |
{"relname"=>"spree_prices", "rowcount"=>"25"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"3"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"19"} | |
{"relname"=>"spree_taxons", "rowcount"=>"10"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"17"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"17"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"25"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"25"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should require covering to be set | |
when the variant is the master variant | |
{"relname"=>"spree_stock_locations", "rowcount"=>"15"} | |
{"relname"=>"spree_prices", "rowcount"=>"25"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"3"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"2"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"19"} | |
{"relname"=>"spree_taxons", "rowcount"=>"10"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"17"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"17"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"25"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"15"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"25"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should not require covering to be set | |
#book_format | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should belong to book_format class_name => Spree::BookFormat | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should require book_format to be set | |
when the variant is the master variant | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should not require book_format to be set | |
when the variant is an ebook | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should not require book_format to be set | |
#sku | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should not require sku to be set | |
for a non-master variant | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
allows blank values | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
accepts strings of exactly 13 digits | |
{"relname"=>"spree_stock_locations", "rowcount"=>"18"} | |
{"relname"=>"spree_prices", "rowcount"=>"29"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"5"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"6"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"6"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"3"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"23"} | |
{"relname"=>"spree_taxons", "rowcount"=>"16"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"5"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"20"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"20"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"5"} | |
{"relname"=>"spree_vendors", "rowcount"=>"2"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"5"} | |
{"relname"=>"spree_variants", "rowcount"=>"29"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"18"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"29"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not accept strings of less than 13 digits | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not accept strings of more than 13 digits | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not accept strings that have alphanumeric characters | |
Spree::Vendor | |
#name | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
should require name to be set | |
Wordpress::Image | |
.find_ordered | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns images in the same order that they were specified | |
#versions | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
example at ./spec/models/wordpress/image_spec.rb:21 (FAILED - 5) | |
Wordpress::Menu | |
.find | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
finds menus that have the provided name (FAILED - 6) | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
doesn't find menus if none exist with that given name | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns a relation if multiple names are searched for | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
can return multiple records (FAILED - 7) | |
Wordpress::Option | |
.find | |
the option exists | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns the option value (FAILED - 8) | |
the option does not exist | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
raises an exception | |
.find_all | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns a hash of the option names and values (FAILED - 9) | |
Wordpress::Post | |
.in_collection | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
finds posts that belong to the taxonomy collection | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not find posts that do not belong to the taxonomy collection | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
does not find things that aren't posts | |
Wordpress::Testimonial | |
.random | |
{"relname"=>"spree_stock_locations", "rowcount"=>"27"} | |
{"relname"=>"spree_prices", "rowcount"=>"41"} | |
{"relname"=>"spree_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_option_types", "rowcount"=>"7"} | |
{"relname"=>"spree_shipping_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_promotions", "rowcount"=>"3"} | |
{"relname"=>"spree_product_contributors", "rowcount"=>"3"} | |
{"relname"=>"spree_people", "rowcount"=>"11"} | |
{"relname"=>"wp_term_relationships", "rowcount"=>"1"} | |
{"relname"=>"spree_coverings", "rowcount"=>"8"} | |
{"relname"=>"spree_orders", "rowcount"=>"2"} | |
{"relname"=>"spree_taxonomies", "rowcount"=>"7"} | |
{"relname"=>"spree_products_taxons", "rowcount"=>"5"} | |
{"relname"=>"spree_roles_users", "rowcount"=>"2"} | |
{"relname"=>"wp_postmeta", "rowcount"=>"3"} | |
{"relname"=>"spree_products_promotion_rules", "rowcount"=>"4"} | |
{"relname"=>"spree_products", "rowcount"=>"33"} | |
{"relname"=>"spree_taxons", "rowcount"=>"18"} | |
{"relname"=>"spree_variant_statuses", "rowcount"=>"5"} | |
{"relname"=>"spree_option_values_variants", "rowcount"=>"7"} | |
{"relname"=>"spree_links", "rowcount"=>"1"} | |
{"relname"=>"schema_migrations", "rowcount"=>"203"} | |
{"relname"=>"spree_countries", "rowcount"=>"29"} | |
{"relname"=>"wp_term_taxonomy", "rowcount"=>"2"} | |
{"relname"=>"spree_preferences", "rowcount"=>"25"} | |
{"relname"=>"spree_users", "rowcount"=>"4"} | |
{"relname"=>"spree_states", "rowcount"=>"29"} | |
{"relname"=>"spree_book_formats", "rowcount"=>"7"} | |
{"relname"=>"spree_vendors", "rowcount"=>"3"} | |
{"relname"=>"wp_posts", "rowcount"=>"2"} | |
{"relname"=>"spree_option_values", "rowcount"=>"7"} | |
{"relname"=>"spree_variants", "rowcount"=>"41"} | |
{"relname"=>"wp_terms", "rowcount"=>"2"} | |
{"relname"=>"spree_tax_categories", "rowcount"=>"28"} | |
{"relname"=>"spree_roles", "rowcount"=>"2"} | |
{"relname"=>"spree_stock_items", "rowcount"=>"41"} | |
{"relname"=>"spree_addresses", "rowcount"=>"2"} | |
{"relname"=>"spree_contributor_roles", "rowcount"=>"3"} | |
returns a single result |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment