1Revision history for Interchange6::Schema 2 30.133 Sun Oct 30 11:59:33 2016 CET 4 5 [ENHANCEMENTS] 6 7 * Add real email address for company user in fixtures (Stefan Hornburg/Racke). 8 9 [TESTS] 10 11 * Switch to new Test::Postgresql58 for PostgreSQL tests (Peter Mottram). 12 130.132 Sat Oct 1 09:59:22 2016 CEST 14 15 [ENHANCEMENTS] 16 17 * Add company user role (Pattawan Kaewduangdee, GH #204, #205). 18 190.131 Mon Aug 22 12:34:52 2016 CEST 20 21 [BUG FIXES] 22 23 * Fix number of countries in tests (Peter Mottram, GH #201). 24 * Fix MANIFEST.SKIP so sql only matches directory (Peter Mottram, GH #200). 25 26 [TESTS] 27 28 * Manual config for travis so it doesn't run build-dist (Peter Mottram). 29 300.130 Mon Aug 1 10:57:09 2016 CEST 31 32 [ENHANCEMENTS] 33 34 * Add MediaMessage result class (Stefan Hornburg/Racke). 35 36 [BUG FIXES] 37 38 * Fix problems reported by new DBIx::Class SanityChecker (Peter Mottram). 39 * Simplify DBIC/SQLT dependency config to fix travis 5.24 dep problems 40 (Peter Mottram). 41 * Disregard password for reset token checksum in case it isn't yet 42 defined (Peter Mottram). 43 * Add YAML to build dependencies for the sake of Schema::Config 44 (Peter Mottram). 45 46 [TESTS] 47 48 * Add coverage testing to Travis configuration file (Stefan Hornburg/Racke). 49 500.120 Mon Jun 27 16:16:36 2016 CEST 51 52 [ENHANCEMENTS] 53 54 * Remove pg_enable_utf8 parameter which isn't necessary any 55 more with DBD::Pg version 3.0.0 and higher (see 56 https://metacpan.org/pod/DBD::Pg#pg_enable_utf8-integer). 57 Peter Mottram 58 * Remove build dependency on Class::Load (Peter Mottram). 59 * Add useful Message resultset methods: approved, public, 60 with_author, with_children (Peter Mottram). 61 * Add NavigationMessage result class (Peter Mottram). 62 63 [TESTING] 64 65 * Add Perl version 5.24 to Travis configuration (Stefan Hornburg/Racke). 66 670.111 Wed Jun 1 13:27:25 2016 CEST 68 69 [ENHANCEMENTS] 70 71 * Add clone method to Cart result class 72 (Marco Pessotto, Peter Mottram, GH #197). 73 740.110 Wed May 25 12:16:11 2016 CEST 75 76 [ENHANCEMENTS] 77 78 * Add combine and extra column to CartProduct result class (Peter 79 Mottram). 80 * Add combine column ot Product result class (Peter Mottram). 81 * Remove prerequisite on Crypt::Eksblowfish::Bcrypt (Peter Mottram). 82 830.102 Thu Mar 3 18:35:23 2016 CET 84 85 [ENHANCEMENTS] 86 87 * Pass arrayref to set_roles method as single hashref will be 88 deprecated in DBIx::Class (Peter Mottram) 89 * Zone result tweaks (Peter Mottram) 90 - in _get_state_obj combine 2 queries using a subquery 91 - use resultset 'single' method instead of search->single in add_states 92 - this also removes potential for leaked cursor 93 * Add column accessor image to Product result class (Peter Mottram). 94 * Use 'inherited' instead of 'simple' for schema attributes so they 95 are available in subclassed schemas (Peter Mottram). 96 97 [DOCUMENTATION] 98 99 * Add notes about using Schema::Config in inherited classes 100 (Peter Mottram). 101 1020.101 Mon Feb 29 12:28:49 2016 CET 103 104 [BUG FIXES] 105 106 * Use cmp_deeply with num to prevent SQLite test failure fixes 107 (Peter Mottram, Slaven Rezić, Stefan Hornburg/Racke, GH #195, #196). 108 1090.100 Sat Feb 27 17:35:12 2016 CET 110 111 [BUG FIXES] 112 113 * Fix bug causing exception in find_variant method from the 114 Product class (Peter Mottram). 115 * Correct CASCADE behaviour in Cart class (Peter Mottram). 116 117 [ENHANCEMENTS] 118 119 * Add user_locale attribute to Schema (Peter Mottram, GH #127). 120 * Improve usage of Me helper 121 (Peter Mottram, Stefan Hornburg/Racke, GH #194). 122 * Add support for partial shipments (Peter Mottram, GH #192). 123 * Change file column in Media to be nullable (Peter Mottram). 124 * Remove 'is_foreign_key => 1' from result class definitions 125 (Peter Mottram). 126 * Add priority column to Media class (Peter Mottram). 127 * Add Navigation resultset class (Peter Mottram). 128 * Add MediaNavigation link table (Peter Mottram). 129 * Remove unused variable in with_highest_price method 130 (Stefan Hornburg/Racke). 131 * Add with_media method to Product ResultSet class (Peter Mottram). 132 * Add current_user attribute to Schema (Peter Mottram). 133 * Replace ProductReview result class with ProductMessage (Peter Mottram). 134 * Resize numeric columns holding prices (Peter Mottram). 135 * Support old Perls (Peter Mottram). 136 137 [TESTS] 138 139 * Full code coverage of tests (Peter Mottram). 140 1410.092 Mon Jan 18 16:28:41 2016 CET 142 143 [BUG FIXES] 144 145 * Use crypt encoding for password column in User result class 146 (Peter Mottram, GH #188) 147 1480.091 Mon Nov 23 09:23:44 2015 CET 149 150 [BUG FIXES] 151 152 * Use DBIx::Class::Schema::Config as base instead of as component 153 (Peter Mottram, Stefan Hornburg/Racke). 154 1550.090 Wed Nov 18 12:20:44 2015 CET 156 157 [ENHANCEMENTS] 158 159 * Switch to Authen::Passphrase for User password column 160 (Peter Mottram). 161 * Use Helper::Row::ProxyResultSetMethod for Product->average_rating 162 and Product->variant_count (Peter Mottram). 163 * Remove stale prerequisites on MooX:: modules (Peter Mottram). 164 * Add Devel::Cover uncoverable comments to Schema (Peter Mottram). 165 166 [DOCUMENTATION] 167 168 * Update database connect options to current best practice 169 (Peter Mottram). 170 * POD fix in UriRedirect resultset class (Peter Mottram). 171 * Document minimum Perl version (Stefan Hornburg/Racke). 172 173 [TESTS] 174 175 * Remove unnecessary diag call from UriRedirect test 176 (Peter Mottram). 177 * Switch MySQL test role to using set_strict_mode 178 (Peter Mottram). 179 1800.089 Tue Aug 11 11:19:30 2015 CEST 181 182 [ENHANCEMENTS] 183 184 * Add atomic increment and decrement methods to Inventory class 185 (Peter Mottram). 186 187 [DOCUMENTATION] 188 189 * Fix typo in inventory_exempt description (Stefan Hornburg). 190 1910.088 Tue Jul 28 19:06:40 2015 EEST 192 193 [API CHANGES] 194 195 * Add summary column to Message class (Peter Mottram, GH #184). 196 197 [BUG FIXES] 198 199 * Force lowercase on username (Peter Mottram, GH #183). 200 * Return undef instead of throwing exception for circular redirect 201 (Peter Mottram). 202 203 [DOCUMENTATION] 204 205 * Fix links to order status class in POD for order class 206 (Stefan Hornburg). 207 2080.087 Fri Jul 3 18:19:28 2015 CEST 209 210 [API CHANGES] 211 212 * Add manufacturer_sku to Product class (Peter Mottram, GH #181). 213 * Add UriRedirect result and result set class (Sam Batschelet, 214 Peter Mottram, GH #179, GH #180). 215 2160.086 Tue Jun 30 16:46:29 2015 CEST 217 218 [API CHANGES] 219 220 * Move generate_uri method for Navigation result class from insert to new. 221 This skips automatic uri generation in case uri is passed as undef 222 (Peter Mottram, GH #178). 223 224 [BUG FIXES] 225 226 * Fix assumption in 'around check_password' that fail_count is defined 227 (Peter Mottram). 228 229 [TESTS] 230 231 * Add tests to ensure empty password cannot be used for login 232 (Peter Mottram). 233 2340.085 Thu Jun 18 14:01:29 2015 CEST 235 236 [ENHANCEMENTS] 237 238 * Let reset_token_checksum in User result class work without password 239 (Peter Mottram). 240 * Automatically create uri value in Navigation result class if value 241 is not defined instead of if false (Peter Mottram). 242 * Update last_login and fail_count in User result class on check_password 243 call (Peter Mottram). 244 * Add priority to Address result class (Peter Mottram, GH #175). 245 246 [DOCUMENTATION] 247 248 * Add YAML config Dancer::Plugin::DBIC to database support manual 249 (Peter Mottram). 250 * Fix database support manual text regarding set_strict_mode in MySQL 251 (Peter Mottram). 252 * Add cookbook to list of manuals (Stefan Hornburg). 253 254 [TESTS] 255 256 * Fix datetime comparison check in user tests (Peter Mottram). 257 2580.084 Tue Mar 31 16:39:23 2015 CEST 259 260 [API CHANGES] 261 262 * Change product weight to NOT NULL with default value of 0 (Peter Mottram). 263 264 [ENHANCEMENTS] 265 266 * Create order status on order create (Peter Mottram, GH #173). 267 268 [TESTS] 269 270 * Remove Pod::POM module check from sanity test (Peter Mottram). 271 2720.083 Sun Mar 22 06:38:42 2015 CET 273 274 [BUG FIXES] 275 276 * Fix prerequisite on DBIx::Class::Schema::Config which causes build 277 problems on NetBSD when using non-Gnu make (Peter Mottram, GH #169). 278 2790.082 Thu Mar 19 16:28:23 2015 CET 280 281 [ENHANCEMENTS] 282 283 * Add unique constraint on uri column in Message class (Marco Pessotto, GH #168). 284 285 [BUG FIXES] 286 287 * Add extra comma to SET SQL_MODE CONCAT (Peter Mottram, GH #149), 288 289 [TESTS] 290 291 * Reduce noise in tests (Peter Mottram). 292 2930.081 Wed Mar 18 11:23:10 2015 CET 294 295 [DOCUMENTATION] 296 297 * Add Manual::Cookbook with information on modifying the schema (Peter Mottram). 298 299 [TESTS] 300 301 * Stop using File::Slurp in tests (Peter Mottram, GH #171). 302 * Remove extra debug code that was added to test_mysql.t. 303 It hasn't helped significantly and caused test failures on some linux smoker 304 (Peter Mottram). 305 3060.080 Sun Mar 15 08:00:40 2015 CET 307 308 [FEATURES] 309 310 * Add support for password reset (Peter Mottram): 311 - Add columns reset_token and reset_expires to users table. 312 - Add User resultset class with find_user_with_reset_token method. 313 - Add methods to User class (reset_token_generate, reset_token_verify, 314 reset_token_checksum). 315 * Add DBIx::Class::Schema::Config component (GH#162, Peter Mottram). 316 317 [ENHANCEMENTS] 318 319 * Product resultset listing method split into multiple chainable 320 methods each using correlated subqueries instead of joins (Peter Mottram). 321 * Add new Product result set methods (Peter Mottram): 322 - with_average_rating 323 - with_lowest_selling_price 324 - with_highest_price 325 - with_quantity_in_stock 326 - with_variant_count 327 * Update/add Product class methods to use cached column data from new 328 result set methods when available (Peter Mottram): 329 - average_rating 330 - selling_price 331 - highest_price 332 - quantity_in_stock 333 - variant_count 334 * Add OrderStatus class (GH #154, #167, Peter Mottram). 335 * Add attributes many-to-many relationship to Navigation class 336 (GH #95, Peter Mottram). 337 * Add random helper (Peter Mottram). 338 * Add canonical_only method to Product resultset (Peter Mottram). 339 * Add navigations many-to-many relationship to Product class 340 (GH #164, #165, Sam Batschelet). 341 * Add explicit attribute definition in add_variants method of Product class 342 (GH #118, Peter Mottram). 343 * Add active_children relationship to Navigation class (Peter Mottram). 344 * Add unique constraint merchandising_products_sku_sku_related_type to 345 MerchandisingProduct class (Peter Mottram). 346 * Allow parameters to be passed to Product resultset listing method 347 (Peter Mottram). 348 * Add format and parent_id to Message class (GH #156, Peter Mottram). 349 * Use "Me helper" in ResultSet::Product for safety reasons (Peter Mottram). 350 * Use join_type left for the following relationships (Peter Mottram): 351 - canonical in Product class 352 - user and session in Cart class 353 - author in Media class 354 - order and user in PaymentOrder class 355 * Add discount_percent method to Product (Peter Mottram). 356 * Add valid_from and valid_to columns to ShipmentRate class (Peter Mottram). 357 * Add unique constraint on navigation_id and attributes_id in 358 NavigationAttribute class (Peter Mottram). 359 * Add unique constraint on sku and attributes_id in ProductAttribute 360 class (Peter Mottram). 361 * Add unique constraint on users_id and attributes_id in UserAttribute 362 class (Peter Mottram). 363 * Add is_anonymous column to User class. If a user is created with 364 username undef and is_anonymous true then a random username starting 365 with 'anonymous-' is created and active is set to false. 366 (GH#92, Peter Mottram). 367 * Add discount column to PriceModifier class to allow modified prices 368 to be calculated based on a percentage discount (GH#126, Peter Mottram). 369 * ShipmentRate class min/max_weight columns renamed to min/max_value and 370 value_type and value_unit columns added (GH#71, Peter Mottram). 371 * Remove status and approved columns from Cart (GH#135, Peter Mottram). 372 373 [BUG FIXES] 374 375 * Increase version number of DBIx::Class::Helpers prerequisite in order 376 to fix Dancer::Plugin::Interchange GH issue #48 (Peter Mottram). 377 * Add has_variants method to Product for backwards-compatibility 378 (Peter Mottram). 379 380 [DOCUMENTATION] 381 382 * Remove boilerplate from POD for Media, MediaDisplay, MediaProduct, 383 MediaType, MerchandisingAttribute, MerchandisingProduct, Navigation, 384 NavigationAttributeValue, Orderline, PaymentOrder, Permission, 385 PriceModifier, ProductAttribute, ProductAttributeValue, Role, Session, 386 Setting, Shipment, ShipmentCarrier, ShipmentDestination, ShipmentMethod, 387 State, Tax, User, UserAttribute, UserAttributeValue, UserRole, Zone, 388 ZoneCountry and ZoneState classes (GH #134, Peter Mottram). 389 * Add ResultSet::Product to Manual::Classes (Peter Mottram). 390 * Improve pod for quantity_in_stock method in Product class (Peter Mottram). 391 * Improve pod for Populate::Role (Peter Mottram). 392 393 [TESTS] 394 395 * Add test for left join with nullable FK closes (GH #146, Peter Mottram). 396 * Adjust tests now that selling_price is always defined (Peter Mottram). 397 3980.070 Wed Dec 31 11:39:33 2014 CET 399 400 [ENHANCEMENTS] 401 402 * Set default value of title in Attribute and Attribute value class 403 from name and value column respectively (Peter Mottram). 404 * Add "SetOperations" DBIx::Class::Helper (Peter Mottram). 405 4060.060_93 Fri Dec 26 10:41:23 2014 CET 407 408 [ENHANCEMENTS] 409 410 * Add "me" DBIx::Class::Helper (Peter Mottram). 411 * Add SQL literal AS to selling_price query within listing method from 412 Product class (Peter Mottram). 413 414 [TESTS] 415 416 * Stop using t/var as temporary directory in tests and set TMPDIR => 1 instead. 417 Prevents exhausting of socket file path max length (108 on Linux systems). 418 (Sam Batschelet, Stefan Hornburg, Peter Mottram). 419 * Recheck DBIx::Class deployment dependencies before running tests 420 (Peter Mottram). 421 * Retrieve and display mysqld version info in top-level test script to help debug 422 GH #149 (Peter Mottram). 423 * Fix BaseAttribute test array order bug (Peter Mottram). 424 4250.060_92 Mon Dec 22 13:44:34 2014 CET 426 427 [ENHANCEMENTS] 428 429 * Ensure that selling_price method in Product class always return defined price 430 (Peter Mottram). 431 432 [BUG FIXES] 433 434 * Use DBIx::Class::Optional::Dependencies to ensure correct deployment 435 prerequsites for DBIx::Class (Peter Mottram). 436 * Add version to prerequisite on DBIx::Class::Helpers to ensure that 437 DBIx::Class::Helpers::DateTime is available (Peter Mottram). 438 * Fix test problems with PriceModifier and SQLite floats 439 (Peter Mottram, GH #148). 440 4410.060_91 Sat Dec 20 14:56:52 2014 CET 442 443 [ENHANCEMENTS] 444 445 * Add base ResultSet class which loads shortcut and correlate relationship 446 helper class (Peter Mottram). 447 * Replace count method with has_rows in Message class (Peter Mottram). 448 * Add ResultSet class for products including listing method (Peter Mottram). 449 * Add priority column to NavigationProduct (Peter Mottram). 450 * Add role 'user' to user on insert (Peter Mottram). 451 * Remove anonymous and authenticated roles and adjust selling_price and 452 tier_pricing (Peter Mottram). 453 * Add DateTime and QuoteNames helpers to schema (Peter Mottram). 454 455 [BUG FIXES] 456 457 * Fix cascade relationships between User and UserRole classes (Peter Mottram). 458 * Use left join for state relationship of Address class 459 (Jeff Boes, Peter Mottram). 460 * Fix problems with path method in Product class 461 (Peter Mottram, GH #133, #145). 462 * Overload delete in Address and OrderlinesShipping classes (Peter Mottram). 463 464 [DOCUMENTATION] 465 466 * Add note about MySQL strict mode settings and on_connect_do parameters 467 to DatabaseSupport manual (Peter Mottram). 468 * Fix link to PriceModifier class in Manual::Classes (Stefan Hornburg). 469 * Fix start_date and end_date links in POD for PriceModifier class 470 (Stefan Hornburg). 471 * Fix create database statement for MySQL (Marco Pessotto, GH #147). 472 * Fix wrong method name for has_descendant in POD for Navigation class 473 (Sam Batschelet). 474 * Clear out boilerplate from modules (Stefan Hornburg, Sam Batschelet, 475 Peter Mottram, GH #134, #137) 476 * Add description section to POD for Address class (Peter Mottram). 477 478 [TESTS] 479 480 * Update PriceModifier tests (Peter Mottram). 481 * Replace on_connect_call with on_connect_to in MySQL test role 482 (Peter Mottram). 483 * Add test for attribute_iterator method from Product class 484 with hashref argument (Peter Mottram). 485 * Clean up relationship tests (Peter Mottram). 486 * Allow fixtures to avoid some foreign key constraints on clear_orders 487 (Peter Mottram). 488 * Add tests for Address delete cascades (Peter Mottram). 489 * Add fixtures for ShipmentCarrier and ShipmentRate classes (Peter Mottram). 490 * Remove pod tests from schema_sanity.t (Peter Mottram). 491 4920.060 Thu Nov 27 16:30:51 2014 CET 493 494 [BUG FIXES] 495 496 * Fix many-to-many zones relationship in State class 497 (GH #132, Grega Pompe, Peter Mottram). 498 4990.060_03 Thu Nov 27 11:43:22 2014 CET 500 501 [ENHANCEMENTS] 502 503 * Add name method to User class (Peter Mottram). 504 * Add quantity_in_stock to Product class (Peter Mottram). 505 506 [BUG FIXES] 507 508 * Fix columns and relations with same name in the Message class (Peter Mottram). 509 510 [TESTS] 511 512 * Add first_name and last_name data to user fixtures (Peter Mottram). 513 * Use hashrefs in fixtures for add_attributes calls prevent warnings (Peter Mottram). 514 * Add more variants and also simple product attributes to fixtures (Peter Mottram). 515 * Change Test::Role::Fixtures to use Moo::Role (Peter Mottram). 516 * Add navigation fixture tests (Peter Mottram). 517 5180.060_02 Thu Nov 6 16:13:18 2014 CET 519 520 [ENHANCEMENTS] 521 522 * Allow optional argument for precision in average_rating method 523 of the Product class (Peter Mottram). 524 525 [TESTS] 526 527 * Add load_all_fixtures method to test fixtures (Peter Mottram). 528 * Add fixtures to Test::Fixtures that were previously missed (Peter Mottram). 529 * Test fixtures can now be used by consuming modules (Peter Mottram). 530 * Merge all fixtures from the populate_ic5 script in the demo shop (Peter Mottram). 531 5320.060_01 Tue Nov 4 21:05:45 2014 CET 533 534 [API CHANGES] 535 536 * Switch to DBIx::Class::Candy (Peter Mottram). 537 538 * Pricing changes (Peter Mottram, Sam Batschelet, GH #117, #122): 539 - GroupPricing class renamed to PriceModifier 540 - start_date and end_date columns added 541 542 * Fix primary key columns with multiple plurals (Jure Kodzoman, Peter Mottram): 543 - navigation_attributes_values_id to navigation_attribute_values_id 544 - product_attributes_values_id to product_attribute_values_id 545 - user_attributes_values_id to user_attribute_values_id 546 547 * Review related changes (Peter Mottram, Sam Batschelet): 548 - add top_reviews and average_rating to Product class 549 - reviews method now accepts search args 550 551 * Add description to Role class (Peter Mottram). 552 553 [ENHANCEMENTS] 554 555 * Add many_to_many relationship from Navigation to Product class (Peter Mottram). 556 * Add siblings_with_self method to Navigation class (Peter Mottram). 557 * Add tier_pricing and selling_price methods to Product class (Peter Mottram). 558 * New helper interchange6-create-schema-png (Peter Mottram). 559 * Add search_attribute_values (Sam Batschelet, GH #101). 560 561 [BUG FIXES] 562 563 * Fix order_by in attribute_iterator method of the Product class (Peter Mottram). 564 * Make name column of Role class unique (Peter Mottram). 565 566 [DOCUMENTATION] 567 568 * Add instructions on creating databases (Peter Mottram, GH #103). 569 570 [TESTS] 571 572 * Add quote_names to db engine connect_info (Peter Mottram). 573 * Replace Mock::DateTime with MockTime (Peter Mottram). 574 * Add role and pricing fixtures (Peter Mottram, Sam Batschelet). 575 5760.053 Thu Oct 9 14:39:59 2014 EDT 577 578 [BUG FIXES] 579 580 * Remove _map_namespaces method from Interchange6::Schema (Peter Mottram). 581 582 [TESTS] 583 584 * Adjust shipment test to deal with SQLite's notion of numeric columns (Peter Mottram). 585 * Skip MySQL tests if the constructor dies (Peter Mottram). 586 * Force standard locale for PostgreSQL tests (Peter Mottram). 587 5880.052 Sun Oct 5 08:24:24 2014 EDT 589 590 [BUG FIXES] 591 592 * Fix relationship between Session and PaymentOrder result classes (Peter Mottram). 593 5940.051 Fri Aug 15 11:06:33 2014 CEST 595 596 [BUG FIXES] 597 598 * Fix odd error with populating zones (Peter Mottram, Stefan Hornburg, 599 Sam Batschelet, GH #102). 600 * Turn session relationship in PaymentOrder result class into might_have 601 (Stefan Hornburg). 602 603 [DOCUMENTATION] 604 605 * Add explanation of payment_sessions_id and sessions_id fields to the 606 documentation of the PaymentOrder result class (Stefan Hornburg). 607 608 [TESTS] 609 610 * Add checks on payment_orders to expire test (Marco Pessotto, GH #107). 611 * Add test to check if the payment is still there after session removal 612 (Marco Pessotto, GH #106). 613 * Fix flat rate shipping price test (Peter Mottram, GH #105). 614 * Switch from die to plan skip_all if Test::PostgreSQL->new fails 615 (Peter Mottram, GH #104). 616 6170.050 Wed Aug 13 10:37:54 2014 CEST 618 619 [API CHANGES] 620 621 * Add Message, ProductReview and OrderComment result class (Peter Mottram). 622 * Remove filter_column from username in User result class and replace it 623 with overloaded new and update methods (Peter Mottram, see RT #95054). 624 625 [ENHANCEMENTS] 626 627 * Stop using literal defaults for booleans (Peter Mottram). 628 * Add primary key to Permission result class (Peter Mottram, GH #97). 629 * Improve methods of Zone result class to support ISO codes as input 630 (Peter Mottram). 631 * Add unique constraint to State result class (Peter Mottram). 632 633 [BUG FIXES] 634 635 * Remove superfluous many_to_many relationship from ProductAttribute 636 result class (Grega Pompe, GH #94) 637 * Round price in shipment price to avoid SQLite problems. 638 639 [DOCUMENTATION] 640 641 * Add Tree::AdjacencyList accessors to Navigation result class 642 (Peter Mottram, GH #98). 643 * Improve documentation on attribute_iterator method from Product result 644 class (Peter Mottram). 645 646 [TESTS] 647 648 * Extend variant tests (Peter Mottram). 649 * Switch to role based testing with Test::Roo (Peter Mottram). 650 * Remove Test::Most from schema sanity test (Peter Mottram, GH #84). 651 * Update available Perl versions for Travis (Peter Mottram). 652 6530.040 Wed Jul 2 11:13:09 2014 CEST 654 655 [API CHANGES] 656 657 * Update result class relationships and methods with new naming standards 658 outlined in issue (Sam Batschelet, Peter Mottram, GH #76, GH #81). 659 * Nickname is no longer lower-cased in User class (Peter Mottram). 660 * Change precision to decimal_places in Tax class (Peter Mottram). 661 * Remove postal ranges from Zone class (Peter Mottram). 662 663 [ENHANCEMENTS] 664 665 * Change password encryption to bcrypt (Peter Mottram, GH #24). 666 * Add has_many relationship from Country to State (Peter Mottram). 667 * Add zone_states and states relationships to State class 668 (Sam Batschelet, GH #66). 669 * Add shipment_rates has_many relationship to ShipmentMethod class 670 (Sam Batschelet). 671 * Add min_weight, max_weight and shipment_method belongs_to relationship 672 to ShipmentRate class (Sam Batschelet). 673 674 [BUG FIXES] 675 676 * Remove media_displays relationship from Product (Peter Mottram). 677 * Fix cart and cart resultset setup (Peter Mottram, GH #79). 678 * Fix role->users many-to-many relationship (Stefan Hornburg (Racke)). 679 680 [TESTS] 681 682 * Get rid of TEST_DBIC environment variable (Stefan Hornburg (Racke)). 683 * Add travis support (Peter Mottram, GH #69). 684 * Add support for code coverage tests (Peter Mottram). 685 * Add flat rate shipping test (Sam Batschelet). 686 687 [DOCUMENTATION] 688 689 * Add shipment result classes to main POD (Stefan Hornburg (Racke)). 690 * Fix typo in POD of Zone class (Stefan Hornburg (Racke)). 691 6920.032 Mon Apr 7 19:59:30 2014 CEST 693 694 [BUG FIXES] 695 696 * Add missing relationships to country and shipments (Marco Pessotto, GH #65). 697 * Fix Result::Tax and Component::Validation classes due to update bug 698 (Peter Mottram). 699 700 [TESTS] 701 702 * Add tests for specific databases with Test::DBIx::Class (Peter Mottram). 703 * Code coverage tests for zones (Peter Mottram). 704 7050.031 Sat Apr 5 18:08:27 2014 CEST 706 707 [BUG FIXES] 708 709 * Use Test::DBIx::Class safely for RELEASE_TESTING only 710 (Peter Mottram, GH #63). 711 712 [TESTS] 713 714 * Silence media test (Stefan Hornburg (Racke)). 715 7160.030 Fri Apr 4 18:48:47 2014 CEST 717 718 [ENHANCEMENTS] 719 720 * Extend path method from Product result class to use "type" parameter as 721 search option (Stefan Hornburg (Racke)). 722 723 * Overhaul media result classes (Marco Pessotto, GH #54, #59, #61). 724 725 * Add shipment result classes (Sam Batschelet, GH #57). 726 727 * Add basic schema sanity testing and fix result classes based on the 728 result (Peter Mottram, GH #56, #60). 729 730 * Added column payment_fee to PaymentOrder result class 731 (Marco Pessotto, GH #53). 732 733 [BUG FIXES] 734 735 * Fix missing size of foreign keys for country_iso_code. 736 Caused problems which PostgreSQL where columns ended up with size 1 737 (Stefan Hornburg (Racke)). 738 739 * Add unique constraint on zone in Result::Zone (Peter Mottram, GH #55). 740 741 * Bump up Perl requirement to 5.14 (Peter Mottram, GH #51). 742 7430.020 Mon Mar 31 17:12:33 2014 CEST 744 745 [API CHANGES] 746 747 * Switch to using single primary key for CartProduct result class 748 (Stefan Hornburg (Racke)). 749 750 [ENHANCEMENTS] 751 752 * Add NavigationAttribute and NavigationAttributeValue result classes 753 (Sam Batschelet, GH #36). 754 * Add Zone, ZoneCountry and ZoneState result classes (Peter Mottram, GH #33). 755 * Add Role::Errors class (Peter Mottram, GH #33). 756 * Add Tax result and resultset class (Peter Mottram, GH #38). 757 * Add Component::Validation class (Peter Mottram, GH #48). 758 759 [BUG FIXES] 760 761 * Fix definition of numeric fields (Peter Mottram, GH #49). 762 763 [DOCUMENTATION] 764 765 * Reorganize classes in main POD. 766 7670.019 Fri Mar 21 09:11:06 2014 CET 768 769 [ENHANCEMENTS] 770 771 * Inflate data from datetime columns into DateTime objects, alongside 772 with tests for classes missing the inflation component (Peter Mottram). 773 774 [API CHANGES] 775 776 * Change states_iso_code column to states_id foreign_key in Address 777 result class (Sam Batschelet). 778 * Make country_iso_code a foreign key in State result class 779 (Sam Batschelet). 780 * Add State and Country relationships to Address result class 781 (Sam Batschelet). 782 * Change name of primary_key for State result class to states_id 783 (Sam Batschelet). 784 785 [BUG FIXES] 786 787 * Prevent warning originating from find_variant method caused by missing 788 values in input (Stefan Hornburg (Racke)). 789 790 [TESTS] 791 792 * Avoid DBIC::Storage::DBI::SQLite RT79576 by adding a prerequisite on 793 DBD::SQLite 1.38_01 (Peter Mottram). 794 7950.018 Tue Mar 11 17:11:35 2014 CET 796 797 [API CHANGES] 798 799 * Replace order_number with orders_id as foreign key for PaymentOrder and 800 Orderline resultsets. 801 802 * Remove shipping_method and tracking_number from Orderline resultset. 803 804 * Fix many_to_many relationships. 805 8060.017 Mon Mar 10 01:00:54 2014 CET 807 808 [API CHANGES] 809 810 * Increase size of sku column from 32 to 64 (GH #19, Šimun Kodžoman). 811 8120.016 Sat Mar 8 18:32:53 2014 CET 813 814 [API CHANGES] 815 816 * Remove tracking_number field from Order schema. 817 818 [ENHANCEMENTS] 819 820 * Add methods find_attribute_value, update_attribute_value and 821 find_or_create_attribute to User result class. 822 823 [DOCUMENTATION] 824 825 * Move column descriptions for the Product resultset to the individual 826 columns. 827 8280.015 Sun Feb 23 10:41:44 2014 CET 829 830 [API CHANGES] 831 832 * Add users_id column to PaymentOrder result class. 833 * Add shipping_addresses_id column to Order result class. 834 835 [BUG FIXES] 836 837 * Fix User to Role many_to_many relationship (GH #15). 838 8390.014 Sat Feb 15 15:52:37 2014 CET 840 841 [API CHANGES] 842 843 * Add nickname column to User result class. 844 * Add created and last_modified columns to Product result class. 845 8460.013 Mon Jan 27 14:25:43 2014 CET 847 848 [API CHANGES] 849 850 * Change author column to author_users_id in Media result class and link it to User result class. 851 * Add canonical and Variant accessors to Product result class. 852 This implies is_nullable for canonical_sku column. 853 * Add UserAttributeValue result class. 854 * Add type, priority and dynamic column to Attribute result class. 855 * Add recommend, proper sku relationship and drop name from Review result class. 856 857 [ENHANCEMENTS] 858 859 * Add has_many ProductAttribute relationship to Attribute result class. 860 * Add methods for adding, updating and deleting attributes to User result class. 861 * Add add_variants and find_variant method to Product result class. 862 * Let attributes_iterator method of Product result class return hash reference on request. 863 * Add selected column to output of attribute_iterator method. 864 * Return all attributes of children resp. sibling products from attribute_iterator method. 865 866 [TESTS] 867 868 * Add attribute_iterator tests. 869 8700.012 Tue Jan 7 16:07:29 2014 CET 871 872 [API CHANGES] 873 874 * Rename when_added column of CartProduct result class to created. 875 * Add last_modified column to CartProduct result class. 876 877 [ENHANCEMENTS] 878 879 * Add attribute_iterator method to Product result class. 880 * Add custom Session resultset with expire method. 881 8820.011 Thu Jan 2 14:14:18 2014 CET 883 884 [API CHANGES] 885 886 * Add Attribute, AttributeValue and ProductAttributeValue result classes. 887 * Change ProductValue result class. 888 * Remove ProductAttributes result class. 889 8900.010 Fri Dec 27 13:24:45 2013 CET 891 892 [API CHANGES] 893 894 * Use created and last_modified columns for Navigation result set 895 instead of entered. 896 * Rename zip column in Address result set to postal_code. 897 * Make order_number in PaymentOrder result class nullable. 898 899 [BUG FIXES] 900 901 * Add unique constraint on username. 902 903 [TESTS] 904 905 * Add tests for Navigation result class and path method from Product 906 result class. 907 * Test password encryption. 908 * Add POD tests. 909 910 [DOCUMENTATION] 911 912 * Add documentation for records method in Populate classes. 913 * Fix is_nullable value in documentation of Cart result class. 914 9150.009 Sat Dec 21 01:23:04 2013 CET 916 917 [API CHANGES] 918 919 * Use datetime type for all created and last modified columns. 920 * Use set_on_update for all last_modified columns. 921 * Change uri and gtin in Product result class to allow NULL and require unique. 922 * Change weight to include two digits. 923 * Change column types for primary keys of Country and State result class. 924 925 [TESTS] 926 927 * Add simple test for Address and Session result class. 928 9290.008 Mon Dec 16 21:20:27 2013 EST 930 931 [API CHANGES] 932 933 * Remove primary key country_iso_code from State resultset. 934 935 [ENHANCEMENTS] 936 937 * Added command line parameters to interchange6-create-database. -Kaare Rasmussen 938 * Added StateLocale and CountryLocale populate classes. 939 940 [TESTS] 941 942 * Add a few additional tests with State and Country resultset. 943 9440.007 Thu Dec 12 09:30:25 2013 CET 945 946 [API CHANGES] 947 948 * Remove ProductClass from Schema. 949 950 [TESTS] 951 952 * Add a few more tests with Product and Country resultset. 953 954 [DOCUMENTATION] 955 956 * Add a list of resultsets to main POD. 957 * Add description to main POD. 958 9590.006 Mon Dec 9 16:19:42 2013 CET 960 961 [API CHANGES] 962 963 * Change primary key for Country resultset to country_iso_code. 964 * Change default value of show_states in Country resultset to false. 965 966 [ENHANCEMENTS] 967 968 * Add State resultset. 969 970 [BUG FIXES] 971 972 * Make parent_id in Navigation resultset nullable. 973 Otherwise we can't add toplevel records because of the constraint 974 imposed by DBIx::Tree. 975 976 [DOCUMENTATION] 977 978 * Fix mismatch of POD for when_added column in CartProduct resultset (GH #4). 979 9800.005 Sat Dec 7 20:59:04 2013 CET 981 982 [API CHANGES] 983 984 * Change column parent in Navigation resultset to parent_id. 985 986 [ENHANCEMENTS] 987 988 * Use Tree::AdjacencyList with Navigation resultset. 989 * Add Country and Review resultset. 990 * Add path method to Product resultset. 991 9920.004 Sat Nov 30 14:47:13 2013 CET 993 994 [BUG FIXES] 995 996 * Allow NULL values for foreign keys users_id and sessions_id. 997 * Add missing primary key directive to CartProduct resultset. 998 * Use datetime type in CartProduct resultset. 999 10000.003 Tue Nov 19 20:58:07 2013 CET 1001 1002 [BUG FIXES] 1003 1004 * Pass mysql_version to producer to avoid broken booleans (GH #1). 1005 * Remove default value from sessions' last_modified column. 1006 * Use datetime types in user resultset. 1007 1008 [ENHANCEMENTS] 1009 1010 * Add simple schema test with DBICx::TestDatabase. 1011 * Added EncodedColumn for password field. 1012 10130.002 Fri Nov 15 12:24:47 2013 CET 1014 1015 * Mark interchange6-create-database for install. 1016 10170.001 Fri Nov 15 10:31:02 2013 CET 1018 1019 * Initial release. 1020