/ 
Interchange6-Schema-0.080
River stage one • 1 direct dependent • 1 total dependent
⭐ Starred 8 GitHub stars

Changes for version 0.080 - 2015-03-15

  • FEATURES
    • Add support for password reset (Peter Mottram):
      • Add columns reset_token and reset_expires to users table.
      • Add User resultset class with find_user_with_reset_token method.
      • Add methods to User class (reset_token_generate, reset_token_verify, reset_token_checksum).
    • Add DBIx::Class::Schema::Config component (GH#162, Peter Mottram).
  • ENHANCEMENTS
    • Product resultset listing method split into multiple chainable methods each using correlated subqueries instead of joins (Peter Mottram).
    • Add new Product result set methods (Peter Mottram):
      • with_average_rating
      • with_lowest_selling_price
      • with_highest_price
      • with_quantity_in_stock
      • with_variant_count
    • Update/add Product class methods to use cached column data from new result set methods when available (Peter Mottram):
      • average_rating
      • selling_price
      • highest_price
      • quantity_in_stock
      • variant_count
    • Add OrderStatus class (GH #154, #167, Peter Mottram).
    • Add attributes many-to-many relationship to Navigation class (GH #95, Peter Mottram).
    • Add random helper (Peter Mottram).
    • Add canonical_only method to Product resultset (Peter Mottram).
    • Add navigations many-to-many relationship to Product class (GH #164, #165, Sam Batschelet).
    • Add explicit attribute definition in add_variants method of Product class (GH #118, Peter Mottram).
    • Add active_children relationship to Navigation class (Peter Mottram).
    • Add unique constraint merchandising_products_sku_sku_related_type to MerchandisingProduct class (Peter Mottram).
    • Allow parameters to be passed to Product resultset listing method (Peter Mottram).
    • Add format and parent_id to Message class (GH #156, Peter Mottram).
    • Use "Me helper" in ResultSet::Product for safety reasons (Peter Mottram).
    • Use join_type left for the following relationships (Peter Mottram):
      • canonical in Product class
      • user and session in Cart class
      • author in Media class
      • order and user in PaymentOrder class
    • Add discount_percent method to Product (Peter Mottram).
    • Add valid_from and valid_to columns to ShipmentRate class (Peter Mottram).
    • Add unique constraint on navigation_id and attributes_id in NavigationAttribute class (Peter Mottram).
    • Add unique constraint on sku and attributes_id in ProductAttribute class (Peter Mottram).
    • Add unique constraint on users_id and attributes_id in UserAttribute class (Peter Mottram).
    • Add is_anonymous column to User class. If a user is created with username undef and is_anonymous true then a random username starting with 'anonymous-' is created and active is set to false. (GH#92, Peter Mottram).
    • Add discount column to PriceModifier class to allow modified prices to be calculated based on a percentage discount (GH#126, Peter Mottram).
    • ShipmentRate class min/max_weight columns renamed to min/max_value and value_type and value_unit columns added (GH#71, Peter Mottram).
    • Remove status and approved columns from Cart (GH#135, Peter Mottram).
  • BUG FIXES
    • Increase version number of DBIx::Class::Helpers prerequisite in order to fix Dancer::Plugin::Interchange GH issue #48 (Peter Mottram).
    • Add has_variants method to Product for backwards-compatibility (Peter Mottram).
  • DOCUMENTATION
    • Remove boilerplate from POD for Media, MediaDisplay, MediaProduct, MediaType, MerchandisingAttribute, MerchandisingProduct, Navigation, NavigationAttributeValue, Orderline, PaymentOrder, Permission, PriceModifier, ProductAttribute, ProductAttributeValue, Role, Session, Setting, Shipment, ShipmentCarrier, ShipmentDestination, ShipmentMethod, State, Tax, User, UserAttribute, UserAttributeValue, UserRole, Zone, ZoneCountry and ZoneState classes (GH #134, Peter Mottram).
    • Add ResultSet::Product to Manual::Classes (Peter Mottram).
    • Improve pod for quantity_in_stock method in Product class (Peter Mottram).
    • Improve pod for Populate::Role (Peter Mottram).
  • TESTS
    • Add test for left join with nullable FK closes (GH #146, Peter Mottram).
    • Adjust tests now that selling_price is always defined (Peter Mottram).

Documentation

interchange6-create-schema-png
create PNG image graph of Interchange6::Schema
Interchange6::Schema::Manual
Index of the Manual
Interchange6::Schema::Manual::Classes
Result, ResultSet and Populate classes for Interchange6::Schema
Interchange6::Schema::Manual::DatabaseSupport
Details of database engine support for Interchange6

Modules

Interchange6::Schema
Database Schema for Interchange 6
Interchange6::Schema::Base::Attribute
Interchange6::Schema::Candy
add DBIx::Class::Candy to our Result classes
Interchange6::Schema::Component::Validation
Interchange6::Schema::Populate::CountryLocale
Interchange6::Schema::Populate::MessageType
Interchange6::Schema::Populate::Role
Interchange6::Schema::Populate::StateLocale
Interchange6::Schema::Populate::Zone
Interchange6::Schema::Result::Address
Interchange6::Schema::Result::Attribute
Interchange6::Schema::Result::AttributeValue
Interchange6::Schema::Result::Cart
Interchange6::Schema::Result::CartProduct
Interchange6::Schema::Result::Country
Interchange6::Schema::Result::Inventory
Interchange6::Schema::Result::Media
Interchange6::Schema::Result::MediaDisplay
Interchange6::Schema::Result::MediaProduct
Interchange6::Schema::Result::MediaType
Interchange6::Schema::Result::MerchandisingAttribute
Interchange6::Schema::Result::MerchandisingProduct
Interchange6::Schema::Result::Message
Interchange6::Schema::Result::MessageType
Interchange6::Schema::Result::Navigation
Interchange6::Schema::Result::NavigationAttribute
Interchange6::Schema::Result::NavigationAttributeValue
Interchange6::Schema::Result::NavigationProduct
Interchange6::Schema::Result::Order
Interchange6::Schema::Result::OrderComment
Interchange6::Schema::Result::OrderStatus
Interchange6::Schema::Result::Orderline
Interchange6::Schema::Result::OrderlinesShipping
Interchange6::Schema::Result::PaymentOrder
Interchange6::Schema::Result::Permission
Interchange6::Schema::Result::PriceModifier
Interchange6::Schema::Result::Product
Interchange6::Schema::Result::ProductAttribute
Interchange6::Schema::Result::ProductAttributeValue
Interchange6::Schema::Result::ProductReview
Interchange6::Schema::Result::Role
Interchange6::Schema::Result::Session
Interchange6::Schema::Result::Setting
Interchange6::Schema::Result::Shipment
Interchange6::Schema::Result::ShipmentCarrier
Interchange6::Schema::Result::ShipmentDestination
Interchange6::Schema::Result::ShipmentMethod
Interchange6::Schema::Result::ShipmentRate
Interchange6::Schema::Result::State
Interchange6::Schema::Result::Tax
Interchange6::Schema::Result::User
Interchange6::Schema::Result::UserAttribute
Interchange6::Schema::Result::UserAttributeValue
Interchange6::Schema::Result::UserRole
Interchange6::Schema::Result::Zone
Interchange6::Schema::Result::ZoneCountry
Interchange6::Schema::Result::ZoneState
Interchange6::Schema::ResultSet
the default resultset class for Interchange6
Interchange6::Schema::ResultSet::Order
Interchange6::Schema::ResultSet::Product
Interchange6::Schema::ResultSet::Session
Interchange6::Schema::ResultSet::Tax
Interchange6::Schema::ResultSet::User
Interchange6::Test::Role::Database
Interchange6::Test::Role::Fixtures
Interchange6::Test::Role::MySQL
Interchange6::Test::Role::PostgreSQL
Interchange6::Test::Role::SQLite

Other files