Interchange6-Schema
view release on metacpan or search on metacpan
Revision history for Interchange6::Schema
0.133 Sun Oct 30 11:59:33 2016 CET
[ENHANCEMENTS]
* Add real email address for company user in fixtures (Stefan Hornburg/Racke).
[TESTS]
* Switch to new Test::Postgresql58 for PostgreSQL tests (Peter Mottram).
0.132 Sat Oct 1 09:59:22 2016 CEST
0.110 Wed May 25 12:16:11 2016 CEST
[ENHANCEMENTS]
* Add combine and extra column to CartProduct result class (Peter
Mottram).
* Add combine column ot Product result class (Peter Mottram).
* Remove prerequisite on Crypt::Eksblowfish::Bcrypt (Peter Mottram).
0.102 Thu Mar 3 18:35:23 2016 CET
[ENHANCEMENTS]
* Pass arrayref to set_roles method as single hashref will be
deprecated in DBIx::Class (Peter Mottram)
* Zone result tweaks (Peter Mottram)
- in _get_state_obj combine 2 queries using a subquery
- use resultset 'single' method instead of search->single in add_states
- this also removes potential for leaked cursor
* Add column accessor image to Product result class (Peter Mottram).
* Use 'inherited' instead of 'simple' for schema attributes so they
are available in subclassed schemas (Peter Mottram).
[DOCUMENTATION]
* Add notes about using Schema::Config in inherited classes
(Peter Mottram).
0.101 Mon Feb 29 12:28:49 2016 CET
[BUG FIXES]
* Use cmp_deeply with num to prevent SQLite test failure fixes
(Peter Mottram, Slaven Rezić, Stefan Hornburg/Racke, GH #195, #196).
0.100 Sat Feb 27 17:35:12 2016 CET
[BUG FIXES]
* Fix bug causing exception in find_variant method from the
Product class (Peter Mottram).
* Correct CASCADE behaviour in Cart class (Peter Mottram).
[ENHANCEMENTS]
* Add user_locale attribute to Schema (Peter Mottram, GH #127).
* Add with_media method to Product ResultSet class (Peter Mottram).
* Add current_user attribute to Schema (Peter Mottram).
* Replace ProductReview result class with ProductMessage (Peter Mottram).
* Resize numeric columns holding prices (Peter Mottram).
* Support old Perls (Peter Mottram).
[TESTS]
* Full code coverage of tests (Peter Mottram).
0.092 Mon Jan 18 16:28:41 2016 CET
[BUG FIXES]
* Use crypt encoding for password column in User result class
(Peter Mottram, GH #188)
0.091 Mon Nov 23 09:23:44 2015 CET
[BUG FIXES]
* Use DBIx::Class::Schema::Config as base instead of as component
(Peter Mottram, Stefan Hornburg/Racke).
0.090 Wed Nov 18 12:20:44 2015 CET
[ENHANCEMENTS]
* Switch to Authen::Passphrase for User password column
(Peter Mottram).
* Use Helper::Row::ProxyResultSetMethod for Product->average_rating
and Product->variant_count (Peter Mottram).
* Remove stale prerequisites on MooX:: modules (Peter Mottram).
* Add Devel::Cover uncoverable comments to Schema (Peter Mottram).
* Change product weight to NOT NULL with default value of 0 (Peter Mottram).
[ENHANCEMENTS]
* Create order status on order create (Peter Mottram, GH #173).
[TESTS]
* Remove Pod::POM module check from sanity test (Peter Mottram).
0.083 Sun Mar 22 06:38:42 2015 CET
[BUG FIXES]
* Fix prerequisite on DBIx::Class::Schema::Config which causes build
problems on NetBSD when using non-Gnu make (Peter Mottram, GH #169).
0.082 Thu Mar 19 16:28:23 2015 CET
[ENHANCEMENTS]
* Add unique constraint on uri column in Message class (Marco Pessotto, GH #168).
[BUG FIXES]
* Add extra comma to SET SQL_MODE CONCAT (Peter Mottram, GH #149),
[TESTS]
* Reduce noise in tests (Peter Mottram).
0.081 Wed Mar 18 11:23:10 2015 CET
[DOCUMENTATION]
* Add Manual::Cookbook with information on modifying the schema (Peter Mottram).
[TESTS]
* Stop using File::Slurp in tests (Peter Mottram, GH #171).
* Remove extra debug code that was added to test_mysql.t.
It hasn't helped significantly and caused test failures on some linux smoker
(Peter Mottram).
0.080 Sun Mar 15 08:00:40 2015 CET
[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).
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).
0.070 Wed Dec 31 11:39:33 2014 CET
[ENHANCEMENTS]
* Set default value of title in Attribute and Attribute value class
from name and value column respectively (Peter Mottram).
* Add "SetOperations" DBIx::Class::Helper (Peter Mottram).
0.060_93 Fri Dec 26 10:41:23 2014 CET
[ENHANCEMENTS]
* Add "me" DBIx::Class::Helper (Peter Mottram).
* Add SQL literal AS to selling_price query within listing method from
Product class (Peter Mottram).
[TESTS]
* Stop using t/var as temporary directory in tests and set TMPDIR => 1 instead.
Prevents exhausting of socket file path max length (108 on Linux systems).
(Sam Batschelet, Stefan Hornburg, Peter Mottram).
* Recheck DBIx::Class deployment dependencies before running tests
(Peter Mottram).
* Retrieve and display mysqld version info in top-level test script to help debug
GH #149 (Peter Mottram).
* Fix BaseAttribute test array order bug (Peter Mottram).
0.060_92 Mon Dec 22 13:44:34 2014 CET
[ENHANCEMENTS]
* Ensure that selling_price method in Product class always return defined price
(Peter Mottram).
[BUG FIXES]
* Use DBIx::Class::Optional::Dependencies to ensure correct deployment
prerequsites for DBIx::Class (Peter Mottram).
* Add version to prerequisite on DBIx::Class::Helpers to ensure that
DBIx::Class::Helpers::DateTime is available (Peter Mottram).
* Fix test problems with PriceModifier and SQLite floats
(Peter Mottram, GH #148).
0.060_91 Sat Dec 20 14:56:52 2014 CET
[ENHANCEMENTS]
* Add base ResultSet class which loads shortcut and correlate relationship
helper class (Peter Mottram).
* Replace count method with has_rows in Message class (Peter Mottram).
* Add ResultSet class for products including listing method (Peter Mottram).
* Add priority column to NavigationProduct (Peter Mottram).
* Add role 'user' to user on insert (Peter Mottram).
* Remove anonymous and authenticated roles and adjust selling_price and
(Peter Mottram).
* Add test for attribute_iterator method from Product class
with hashref argument (Peter Mottram).
* Clean up relationship tests (Peter Mottram).
* Allow fixtures to avoid some foreign key constraints on clear_orders
(Peter Mottram).
* Add tests for Address delete cascades (Peter Mottram).
* Add fixtures for ShipmentCarrier and ShipmentRate classes (Peter Mottram).
* Remove pod tests from schema_sanity.t (Peter Mottram).
0.060 Thu Nov 27 16:30:51 2014 CET
[BUG FIXES]
* Fix many-to-many zones relationship in State class
(GH #132, Grega Pompe, Peter Mottram).
0.060_03 Thu Nov 27 11:43:22 2014 CET
[ENHANCEMENTS]
* Add name method to User class (Peter Mottram).
* Add quantity_in_stock to Product class (Peter Mottram).
[BUG FIXES]
* Fix columns and relations with same name in the Message class (Peter Mottram).
[TESTS]
* Add first_name and last_name data to user fixtures (Peter Mottram).
* Use hashrefs in fixtures for add_attributes calls prevent warnings (Peter Mottram).
* Add more variants and also simple product attributes to fixtures (Peter Mottram).
* Change Test::Role::Fixtures to use Moo::Role (Peter Mottram).
* Add navigation fixture tests (Peter Mottram).
0.060_02 Thu Nov 6 16:13:18 2014 CET
[ENHANCEMENTS]
* Allow optional argument for precision in average_rating method
of the Product class (Peter Mottram).
[TESTS]
* Add load_all_fixtures method to test fixtures (Peter Mottram).
* Add fixtures to Test::Fixtures that were previously missed (Peter Mottram).
* Test fixtures can now be used by consuming modules (Peter Mottram).
* Merge all fixtures from the populate_ic5 script in the demo shop (Peter Mottram).
0.060_01 Tue Nov 4 21:05:45 2014 CET
[API CHANGES]
* Switch to DBIx::Class::Candy (Peter Mottram).
* Pricing changes (Peter Mottram, Sam Batschelet, GH #117, #122):
- GroupPricing class renamed to PriceModifier
- start_date and end_date columns added
* Fix primary key columns with multiple plurals (Jure Kodzoman, Peter Mottram):
* Add Component::Validation class (Peter Mottram, GH #48).
[BUG FIXES]
* Fix definition of numeric fields (Peter Mottram, GH #49).
[DOCUMENTATION]
* Reorganize classes in main POD.
0.019 Fri Mar 21 09:11:06 2014 CET
[ENHANCEMENTS]
* Inflate data from datetime columns into DateTime objects, alongside
with tests for classes missing the inflation component (Peter Mottram).
[API CHANGES]
* Change states_iso_code column to states_id foreign_key in Address
result class (Sam Batschelet).
[BUG FIXES]
* Prevent warning originating from find_variant method caused by missing
values in input (Stefan Hornburg (Racke)).
[TESTS]
* Avoid DBIC::Storage::DBI::SQLite RT79576 by adding a prerequisite on
DBD::SQLite 1.38_01 (Peter Mottram).
0.018 Tue Mar 11 17:11:35 2014 CET
[API CHANGES]
* Replace order_number with orders_id as foreign key for PaymentOrder and
Orderline resultsets.
* Remove shipping_method and tracking_number from Orderline resultset.
* Fix many_to_many relationships.
0.017 Mon Mar 10 01:00:54 2014 CET
[API CHANGES]
* Increase size of sku column from 32 to 64 (GH #19, Šimun Kodžoman).
0.016 Sat Mar 8 18:32:53 2014 CET
[API CHANGES]
* Remove tracking_number field from Order schema.
[ENHANCEMENTS]
* Add methods find_attribute_value, update_attribute_value and
find_or_create_attribute to User result class.
[DOCUMENTATION]
* Move column descriptions for the Product resultset to the individual
columns.
0.015 Sun Feb 23 10:41:44 2014 CET
[API CHANGES]
* Add users_id column to PaymentOrder result class.
* Add shipping_addresses_id column to Order result class.
[BUG FIXES]
* Fix User to Role many_to_many relationship (GH #15).
0.014 Sat Feb 15 15:52:37 2014 CET
[API CHANGES]
* Add nickname column to User result class.
* Add created and last_modified columns to Product result class.
0.013 Mon Jan 27 14:25:43 2014 CET
[API CHANGES]
* Change author column to author_users_id in Media result class and link it to User result class.
* Add canonical and Variant accessors to Product result class.
This implies is_nullable for canonical_sku column.
* Add UserAttributeValue result class.
* Add type, priority and dynamic column to Attribute result class.
* Add recommend, proper sku relationship and drop name from Review result class.
* Add methods for adding, updating and deleting attributes to User result class.
* Add add_variants and find_variant method to Product result class.
* Let attributes_iterator method of Product result class return hash reference on request.
* Add selected column to output of attribute_iterator method.
* Return all attributes of children resp. sibling products from attribute_iterator method.
[TESTS]
* Add attribute_iterator tests.
0.012 Tue Jan 7 16:07:29 2014 CET
[API CHANGES]
* Rename when_added column of CartProduct result class to created.
* Add last_modified column to CartProduct result class.
[ENHANCEMENTS]
* Add attribute_iterator method to Product result class.
* Add custom Session resultset with expire method.
0.011 Thu Jan 2 14:14:18 2014 CET
[API CHANGES]
* Add Attribute, AttributeValue and ProductAttributeValue result classes.
* Change ProductValue result class.
* Remove ProductAttributes result class.
0.010 Fri Dec 27 13:24:45 2013 CET
[API CHANGES]
* Use created and last_modified columns for Navigation result set
instead of entered.
* Rename zip column in Address result set to postal_code.
* Make order_number in PaymentOrder result class nullable.
[BUG FIXES]
* Add tests for Navigation result class and path method from Product
result class.
* Test password encryption.
* Add POD tests.
[DOCUMENTATION]
* Add documentation for records method in Populate classes.
* Fix is_nullable value in documentation of Cart result class.
0.009 Sat Dec 21 01:23:04 2013 CET
[API CHANGES]
* Use datetime type for all created and last modified columns.
* Use set_on_update for all last_modified columns.
* Change uri and gtin in Product result class to allow NULL and require unique.
* Change weight to include two digits.
* Change column types for primary keys of Country and State result class.
[TESTS]
[ENHANCEMENTS]
* Added command line parameters to interchange6-create-database. -Kaare Rasmussen
* Added StateLocale and CountryLocale populate classes.
[TESTS]
* Add a few additional tests with State and Country resultset.
0.007 Thu Dec 12 09:30:25 2013 CET
[API CHANGES]
* Remove ProductClass from Schema.
[TESTS]
* Add a few more tests with Product and Country resultset.
[DOCUMENTATION]
* Add a list of resultsets to main POD.
* Add description to main POD.
0.006 Mon Dec 9 16:19:42 2013 CET
[API CHANGES]
* Change primary key for Country resultset to country_iso_code.
* Change default value of show_states in Country resultset to false.
[ENHANCEMENTS]
* Add State resultset.
[BUG FIXES]
* Make parent_id in Navigation resultset nullable.
Otherwise we can't add toplevel records because of the constraint
imposed by DBIx::Tree.
[DOCUMENTATION]
* Fix mismatch of POD for when_added column in CartProduct resultset (GH #4).
0.005 Sat Dec 7 20:59:04 2013 CET
[API CHANGES]
* Change column parent in Navigation resultset to parent_id.
[ENHANCEMENTS]
* Use Tree::AdjacencyList with Navigation resultset.
* Add Country and Review resultset.
* Add path method to Product resultset.
0.004 Sat Nov 30 14:47:13 2013 CET
[BUG FIXES]
* Allow NULL values for foreign keys users_id and sessions_id.
* Add missing primary key directive to CartProduct resultset.
* Use datetime type in CartProduct resultset.
0.003 Tue Nov 19 20:58:07 2013 CET
[BUG FIXES]
* Pass mysql_version to producer to avoid broken booleans (GH #1).
* Remove default value from sessions' last_modified column.
* Use datetime types in user resultset.
[ENHANCEMENTS]
* Add simple schema test with DBICx::TestDatabase.
* Added EncodedColumn for password field.
0.002 Fri Nov 15 12:24:47 2013 CET
* Mark interchange6-create-database for install.
0.001 Fri Nov 15 10:31:02 2013 CET
* Initial release.
( run in 1.421 second using v1.01-cache-2.11-cpan-49f99fa48dc )