Lutece stock plugin – Surefire Report

Surefire Report

Summary

Tests	Errors	Failures	Skipped	Success Rate	Time
2	0	1	0	50%	4.22
Note: failures are anticipated and checked for with assertions while errors are unanticipated.
Package List

[Summary] [Package List] [Test Cases]
Package	Tests	Errors	Failures	Skipped	Success Rate	Time
	1	0	1	0	0%	1
fr.paris.lutece.plugins.stock	1	0	0	0	100%	3.22
Note: package statistics are not computed recursively, they only sum up all of its testsuites numbers.
	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	antrunsql	1	0	1	0	0%	1
fr.paris.lutece.plugins.stock

	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	CategoryServiceTest	1	0	0	0	100%	3.22
Test Cases

[Summary] [Package List] [Test Cases]
antrunsql

antrunsql
+ [ Detail ]
[sql] Failed to execute:       CREATE TABLE IF NOT EXISTS stock_category ( id_category int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, description varchar(255) COLLATE utf8_unicode_ci NOT NULL, parent_id int(11) DEFAULT NULL, provider_id int(11) DEFAULT NULL, PRIMARY KEY (id_category), KEY FK9792900769015ED5 (provider_id), KEY FK97929007A735EC89 (parent_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_category_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_category_attribute_date ( id int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_category_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer ( id_offer int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, description varchar(255) COLLATE utf8_unicode_ci NOT NULL, quantity int(11) NOT NULL, price float NOT NULL DEFAULT '0', statut varchar(255) COLLATE utf8_unicode_ci NOT NULL, product_id int(11) NOT NULL, offer_genre_id int(11) NOT NULL, min_tickets INT DEFAULT 0 NOT NULL, max_tickets INT DEFAULT 0 NOT NULL, PRIMARY KEY (id_offer), KEY product_id (product_id), KEY offer_genre_id (offer_genre_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_attribute ( id int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), owner_id int(11) NOT NULL, attribute_key varchar(255) NOT NULL, attribute_value text NOT NULL, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_attribute_num ( id int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre ( id_offer_genre int(11) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (id_offer_genre) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_product ( id_product int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, description text COLLATE utf8_unicode_ci, price float DEFAULT NULL, category_id_category int(11) DEFAULT NULL, provider_id_provider int(11) DEFAULT NULL, PRIMARY KEY (id_product), KEY FK1BA2F4C6FC6A399A (category_id_category), KEY provider_id_provider (provider_id_provider), KEY provider_id_provider_2 (provider_id_provider) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:    CREATE TABLE IF NOT EXISTS stock_product_image ( id_product int(11) NOT NULL, tb_image blob, image mediumblob, real_image mediumblob, PRIMARY KEY (id_product) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:      CREATE TABLE IF NOT EXISTS stock_product_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_product_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_product_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:      CREATE TABLE IF NOT EXISTS stock_provider ( id_provider int(11) NOT NULL DEFAULT '0', address varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, contactName varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, mail varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, phone_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id_provider) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_stock_category ( stock_provider_id_provider int(11) NOT NULL DEFAULT '0', products_id_category int(11) NOT NULL DEFAULT '0', UNIQUE KEY products_id_category (products_id_category), KEY FKF592D1EC8CC9E500 (products_id_category), KEY FKF592D1ECF087CD7C (stock_provider_id_provider) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase ( id_purchase int(11) NOT NULL, userName varchar(255) NOT NULL, quantity int(11) NOT NULL, offer_id int(11) NOT NULL, PRIMARY KEY (id_purchase) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase_attribute ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase_attribute_date ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase_attribute_num ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_sequences ( sequence_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', next_val bigint(20) DEFAULT NULL, PRIMARY KEY (sequence_name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_ticket_product_statistic ( id_product_statistic int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), dayOfYear int(11) NOT NULL, `week` int(11) NOT NULL, `month` int(11) NOT NULL, `year` int(11) NOT NULL, product_id_product int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id_product_statistic) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_ticket_purchase_statistic ( id_purchase_statistic int(11) NOT NULL, dayOfYear int(11) NOT NULL, `week` int(11) NOT NULL, `month` int(11) NOT NULL, `year` int(11) NOT NULL, purchase_id_purchase int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id_purchase_statistic) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:    ALTER TABLE `stock_offer` ADD CONSTRAINT stock_offer_ibfk_1 FOREIGN KEY (product_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:   ALTER TABLE `stock_offer_attribute` ADD CONSTRAINT stock_offer_attribute_ibfk_2 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer), ADD CONSTRAINT stock_offer_attribute_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
      [sql] Failed to execute:   ALTER TABLE `stock_offer_attribute_date` ADD CONSTRAINT stock_offer_attribute_date_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
      [sql] Failed to execute:   ALTER TABLE `stock_offer_attribute_num` ADD CONSTRAINT stock_offer_attribute_num_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
      [sql] Failed to execute:   ALTER TABLE `stock_product_attribute` ADD CONSTRAINT stock_product_attribute_ibfk_3 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product), ADD CONSTRAINT stock_product_attribute_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product), ADD CONSTRAINT stock_product_attribute_ibfk_2 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:   ALTER TABLE `stock_product_attribute_date` ADD CONSTRAINT stock_product_attribute_date_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:   ALTER TABLE `stock_product_attribute_num` ADD CONSTRAINT stock_product_attribute_num_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:    CREATE TABLE IF NOT EXISTS stock_product_subscription_user ( id int(11) NOT NULL, userName varchar(255) COLLATE utf8_unicode_ci NOT NULL, id_product int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:    ALTER TABLE `stock_product_subscription_user` ADD CONSTRAINT stock_product_subscription_user_ibfk_1 FOREIGN KEY (id_product) REFERENCES stock_product (id_product)
CategoryServiceTest

	testService	3.193
Failure Details

[Summary] [Package List] [Test Cases]
	antrunsql
	antrunsql
	antrunsql: