Lutece crm plugin – Surefire Report

Surefire Report

Summary

Tests	Errors	Failures	Skipped	Success Rate	Time
11	7	1	0	27,273%	4,31

Note: failures are anticipated and checked for with assertions while errors are unanticipated.

Package List

[Summary] [Package List] [Test Cases]

Package	Tests	Errors	Failures	Success Rate	Time
	1	0	1	0%	1
fr.paris.lutece.plugins.crm.business.notification	1	1	0	0%	0,001
fr.paris.lutece.plugins.crm.business.demand	3	3	0	0%	3,307
fr.paris.lutece.plugins.crm.business.demand.category	1	1	0	0%	0
fr.paris.lutece.plugins.crm.business.user	1	1	0	0%	0,001
fr.paris.lutece.plugins.crm.service	4	1	0	75%	0,001

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.crm.business.notification

	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	NotificationTest	1	1	0	0	0%	0,001

fr.paris.lutece.plugins.crm.business.demand

Class	Tests	Errors	Success Rate	Time
DemandTest	1	1	0%	3,305
DemandTypeTest	1	1	0%	0,001
DemandStatusCRMTest	1	1	0%	0,001

fr.paris.lutece.plugins.crm.business.demand.category

	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	CategoryTest	1	1	0	0	0%	0

fr.paris.lutece.plugins.crm.business.user

	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	CRMUserTest	1	1	0	0	0%	0,001

fr.paris.lutece.plugins.crm.service

	Class	Tests	Errors	Failures	Skipped	Success Rate	Time
	CRMServiceTest	4	1	0	0	75%	0,001

Test Cases

[Summary] [Package List] [Test Cases]

antrunsql

antrunsql

+ [ Detail ]

[sql] Failed to execute:    INSERT INTO core_stylesheet (id_stylesheet, description, file_name, source) VALUES (809, 'Rubrique Type de Demande CRM', 'portlet_demand_type.xsl', 0x3C3F786D6C2076657273696F6E3D22312E30223F3E0D0A093C78736C3A7374796C6573686565742076657273696F6E3D22312E302220786D6C6E733A78736C3D22687474703A2F2F7777772E77332E6F72672F313939392F58534C2F5472616E73666F726D223E0D0A09093C78736C3A706172616D20206E616D653D226931386E2D6C6162656C2D64656D616E642D74797065732D6C697374222073656C6563743D22274C69737465206465732064656D616E6465732070617220636174C3A9676F7269652722202F3E0D0A09093C78736C3A706172616D206E616D653D226931386E2D6C6162656C2D63726D2D696E666F22202F3E0D0A09093C78736C3A706172616D206E616D653D226931386E2D6C6162656C2D63726D2D636F6E7461637422202F3E0D0A09093C78736C3A706172616D206E616D653D226931386E2D6C6162656C2D63726D2D646174652D626567696E22202F3E0D0A09093C78736C3A706172616D206E616D653D226931386E2D6C6162656C2D63726D2D646174652D656E6422202F3E0D0A09093C78736C3A6F7574707574206D6574686F643D2268746D6C2220696E64656E743D22796573222F3E0D0A09093C78736C3A74656D706C617465206D617463683D22706F72746C6574223E0D0A0909093C64697620636C6173733D22706F72746C6574202D6C75746563652D626F726465722D72616469757320617070656E642D626F74746F6D223E0D0A090909093C78736C3A6170706C792D74656D706C617465732073656C6563743D2263726D2D64656D616E642D747970652D706F72746C657422202F3E0D0A0909093C2F6469763E0D0A09093C2F78736C3A74656D706C6174653E0D0A09090D0A09093C78736C3A74656D706C617465206D617463683D2263726D2D64656D616E642D747970652D706F72746C6574223E0D0A0909093C78736C3A6170706C792D74656D706C617465732073656C6563743D2263726D2D64656D616E642D747970652D706F72746C65742D636F6E74656E7422202F3E0D0A09093C2F78736C3A74656D706C6174653E0D0A090D0A09093C78736C3A74656D706C617465206D617463683D2263726D2D64656D616E642D747970652D706F72746C65742D636F6E74656E74223E0D0A0909093C64697620636C6173733D22706F72746C6574223E0D0A090909093C64697620636C6173733D2277656C6C223E0D0A09090909093C64697620636C6173733D22726F772D666C756964223E0D0A0909090909093C78736C3A6170706C792D74656D706C617465732073656C6563743D2263726D2D64656D616E642D747970652D63617465676F72792D6C6973742F63617465676F7279222F3E0D0A09090909093C2F6469763E0D0A090909093C2F6469763E0D0A0909093C2F6469763E0D0A09093C2F78736C3A74656D706C6174653E0D0A090D0A09093C78736C3A74656D706C617465206D617463683D2263617465676F7279223E0D0A0909093C6669656C647365743E0D0A090909093C6C6567656E643E0D0A09090909093C78736C3A696620746573743D2263617465676F72792D6E616D65213D2727223E0D0A0909090909093C78736C3A76616C75652D6F662073656C6563743D2263617465676F72792D6E616D6522202F3E0D0A09090909093C2F78736C3A69663E0D0A090909093C2F6C6567656E643E09090D0A090909093C756C3E0D0A09090909093C78736C3A6170706C792D74656D706C617465732073656C6563743D2264656D616E642D747970652D6C6973742F64656D616E642D74797065222F3E0D0A090909093C2F756C3E0D0A0909093C2F6669656C647365743E0D0A09093C2F78736C3A74656D706C6174653E0D0A090D0A09093C78736C3A74656D706C617465206D617463683D2264656D616E642D74797065223E0D0A0909093C6C693E0909090909090909090909090D0A090909093C6120687265663D226A73702F736974652F706C7567696E732F63726D2F446F4F70656E44656D616E64547970652E6A73703F69645F64656D616E645F747970653D7B64656D616E642D747970652D69647D22207461726765743D227B64656D616E642D747970652D7461726765747D223E0D0A09090909093C78736C3A76616C75652D6F662073656C6563743D2264656D616E642D747970652D6C6162656C22202F3E0D0A090909093C2F613E0D0A090909093C78736C3A696620746573743D2264656D616E642D747970652D75726C2D696E666F213D2727223E0D0A09090909093C62722F3E0D0A09090909093C656D3E0D0A0909090909093C6120687265663D227B64656D616E642D747970652D75726C2D696E666F7D223E0D0A090909090909093C78736C3A76616C75652D6F662073656C6563743D22246931386E2D6C6162656C2D63726D2D696E666F22202F3E0D0A0909090909093C2F613E0D0A09090909093C2F656D3E0D0A090909093C2F78736C3A69663E0D0A090909093C78736C3A696620746573743D2264656D616E642D747970652D75726C2D636F6E74616374213D2727223E0D0A09090909093C6272202F3E0D0A09090909093C656D3E0D0A0909090909093C6120687265663D227B64656D616E642D747970652D75726C2D636F6E746163747D223E0D0A090909090909093C78736C3A76616C75652D6F662073656C6563743D22246931386E2D6C6162656C2D63726D2D636F6E7461637422202F3E0D0A0909090909093C2F613E0D0A09090909093C2F656D3E0D0A090909093C2F78736C3A69663E0D0A090909093C78736C3A696620746573743D2264656D616E642D747970652D646174652D626567696E213D2727223E0D0A09090909093C6272202F3E0D0A09090909093C78736C3A76616C75652D6F662073656C6563743D22246931386E2D6C6162656C2D63726D2D646174652D626567696E22202F3E3A203C78736C3A76616C75652D6F662073656C6563743D2264656D616E642D747970652D646174652D626567696E22202F3E0D0A090909093C2F78736C3A69663E0D0A090909093C78736C3A696620746573743D2264656D616E642D747970652D646174652D656E64213D2727223E0D0A09090909093C6272202F3E0D0A09090909093C78736C3A76616C75652D6F662073656C6563743D22246931386E2D6C6162656C2D63726D2D646174652D656E6422202F3E203A203C78736C3A76616C75652D6F662073656C6563743D2264656D616E642D747970652D646174652D656E6422202F3E0D0A090909093C2F78736C3A69663E0D0A0909093C2F6C693E09090D0A09093C2F78736C3A74656D706C6174653E0D0A3C2F78736C3A7374796C6573686565743E)
      [sql] Failed to execute:  CREATE TABLE crm_demand_type ( id_demand_type INT(11) DEFAULT 0 NOT NULL, label VARCHAR(255) DEFAULT '' NOT NULL, url_resource VARCHAR(255) DEFAULT '' NOT NULL, url_info VARCHAR(255) DEFAULT '' NOT NULL, url_contact VARCHAR(255) DEFAULT '' NOT NULL, demand_type_order INT(11) DEFAULT 1 NOT NULL, id_category INT(11) DEFAULT 0 NOT NULL, date_begin DATE DEFAULT NULL, date_end DATE DEFAULT NULL, workgroup_key VARCHAR(50) DEFAULT '' NOT NULL, role_key VARCHAR(50) DEFAULT '' NOT NULL, target SMALLINT DEFAULT 0 NOT NULL, url_delete VARCHAR(255) DEFAULT '', is_include_id_user SMALLINT DEFAULT 0 NOT NULL, is_need_authentication SMALLINT DEFAULT 0 NOT NULL, is_need_validation SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (id_demand_type) )
      [sql] Failed to execute:  CREATE TABLE crm_demand ( id_demand INT(11) DEFAULT 0 NOT NULL, id_demand_type INT(11) DEFAULT 0 NOT NULL, id_crm_user INT(11) DEFAULT 0 NOT NULL, status_text VARCHAR(255) DEFAULT '' NOT NULL, id_status_crm INT(11) DEFAULT 0 NOT NULL, data VARCHAR(255) DEFAULT '' NOT NULL, date_modification TIMESTAMP DEFAULT '1980-01-01' NOT NULL, remote_id VARCHAR(255), UNIQUE INDEX (id_demand_type,remote_id), PRIMARY KEY (id_demand) )
      [sql] Failed to execute:   ALTER TABLE crm_demand ADD INDEX IDX_CUSTOMER (id_crm_user ASC) 
      [sql] Failed to execute:  CREATE TABLE crm_notification ( id_notification INT(11) DEFAULT 0 NOT NULL, id_demand INT(11) DEFAULT 0 NOT NULL, is_read SMALLINT DEFAULT 0 NOT NULL, object VARCHAR(255) DEFAULT '' NOT NULL, message LONGVARCHAR, date_creation TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, sender VARCHAR(255) DEFAULT '' NOT NULL, PRIMARY KEY (id_notification) )
      [sql] Failed to execute:   ALTER TABLE crm_notification ADD INDEX IDX_NOTIF_DEMAND_ID (id_demand ASC) 
      [sql] Failed to execute:  CREATE TABLE crm_category ( id_category INT(11) DEFAULT 0 NOT NULL, name VARCHAR(50) NOT NULL DEFAULT '', description VARCHAR(255) NOT NULL DEFAULT '', code VARCHAR(50) NOT NULL DEFAULT '', PRIMARY KEY (id_category), UNIQUE (code) )
      [sql] Failed to execute:  CREATE TABLE crm_status_crm ( id_status_crm INT(11) DEFAULT 0 NOT NULL, status_label VARCHAR(50) NOT NULL DEFAULT '', PRIMARY KEY (id_status_crm) )
      [sql] Failed to execute:  CREATE TABLE crm_user ( id_crm_user INT(11) DEFAULT 0 NOT NULL, user_guid VARCHAR(255) DEFAULT '' NOT NULL, status SMALLINT DEFAULT 1 NOT NULL, last_login TIMESTAMP DEFAULT '1980-01-01', current_last_login TIMESTAMP DEFAULT '1980-01-01', must_be_updated SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (id_crm_user, user_guid) )
      [sql] Failed to execute:   ALTER TABLE crm_user ADD UNIQUE (user_guid)
      [sql] Failed to execute:  CREATE INDEX  index_crm_user on crm_user(user_guid)
      [sql] Failed to execute:  CREATE TABLE crm_user_attribute ( id_crm_user INT(11) DEFAULT 0 NOT NULL, user_attribute_key VARCHAR(255) DEFAULT '' NOT NULL, user_attribute_value VARCHAR(255) DEFAULT '' NOT NULL, PRIMARY KEY (id_crm_user, user_attribute_key) )
      [sql] Failed to execute:  INSERT INTO crm_status_crm (id_status_crm, status_label) VALUES (0, 'crm.statusCRM.draft')
      [sql] Failed to execute:  INSERT INTO crm_status_crm (id_status_crm, status_label) VALUES (1, 'crm.statusCRM.validated')

DemandTest

testBusiness

+ [ Detail ]

3,277

DAOUtil error : user lacks privilege or object not found: CRM_DEMAND in statement [ INSERT INTO crm_demand (id_demand, id_demand_type, id_crm_user, status_text, id_status_crm, data, date_modification, remote_id ) VALUES (?,?,?,?,?,?,?,?) ] - SQL statement : - Plugin : crm

DemandTypeTest

testBusiness

+ [ Detail ]

0,001

DAOUtil error : user lacks privilege or object not found: CRM_DEMAND_TYPE in statement [ INSERT INTO crm_demand_type (id_demand_type, label, url_resource, url_info, url_contact, demand_type_order, id_category, date_begin, date_end, workgroup_key, role_key, target, url_delete, is_include_id_user,is_need_authentication , is_need_validation) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ] - SQL statement : - Plugin : crm

DemandStatusCRMTest

testBusiness

+ [ Detail ]

0,001

DAOUtil error : user lacks privilege or object not found: CRM_STATUS_CRM in statement [ SELECT id_status_crm, status_label FROM crm_status_crm WHERE id_status_crm = ? ] - SQL statement : - Plugin : crm

CategoryTest

testBusiness

+ [ Detail ]

DAOUtil error : user lacks privilege or object not found: CRM_CATEGORY in statement [INSERT INTO crm_category ( id_category, name, description, code ) VALUES ( ?, ?, ?, ? ) ] - SQL statement : - Plugin : crm

NotificationTest

testBusiness

+ [ Detail ]

0,001

DAOUtil error : user lacks privilege or object not found: CRM_NOTIFICATION in statement [ INSERT INTO crm_notification (id_notification, id_demand, is_read, object, message, date_creation, sender) VALUES (?,?,?,?,?,?,?) ] - SQL statement : - Plugin : crm

CRMUserTest

testBusiness

+ [ Detail ]

0,001

DAOUtil error : user lacks privilege or object not found: CRM_USER in statement [ INSERT INTO crm_user (id_crm_user, user_guid, status,must_be_updated) VALUES (?,?,?,?) ] - SQL statement : - Plugin : crm

CRMServiceTest

	testDeleteDemand	0
	testSetStatus	0
	testNotify	0,001
	testRegisterDemand + - [ Detail ]	0
	DAOUtil error : user lacks privilege or object not found: CRM_DEMAND in statement [ SELECT id_demand, id_demand_type, id_crm_user, status_text, id_status_crm, data, date_modification, remote_id FROM crm_demand WHERE remote_id = ? AND id_demand_type = ? ] - SQL statement : - Plugin : crm
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_DEMAND in statement [ SELECT id_demand, id_demand_type, id_crm_user, status_text, id_status_crm, data, date_modification, remote_id FROM crm_demand WHERE remote_id = ? AND id_demand_type = ? ] - SQL statement : - Plugin : crm at fr.paris.lutece.plugins.crm.service.CRMServiceTest.testRegisterDemand(CRMServiceTest.java:67) Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: CRM_DEMAND in statement [ SELECT id_demand, id_demand_type, id_crm_user, status_text, id_status_crm, data, date_modification, remote_id FROM crm_demand WHERE remote_id = ? AND id_demand_type = ? ] at fr.paris.lutece.plugins.crm.service.CRMServiceTest.testRegisterDemand(CRMServiceTest.java:67) Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: CRM_DEMAND at fr.paris.lutece.plugins.crm.service.CRMServiceTest.testRegisterDemand(CRMServiceTest.java:67)

Failure Details

[Summary] [Package List] [Test Cases]

	antrunsql
	antrunsql
	antrunsql:
	testBusiness
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_DEMAND in statement [ INSERT INTO crm_demand (id_demand, id_demand_type, id_crm_user, status_text, id_status_crm, data, date_modification, remote_id ) VALUES (?,?,?,?,?,?,?,?) ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.business.demand.DemandTest:82
	testBusiness
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_DEMAND_TYPE in statement [ INSERT INTO crm_demand_type (id_demand_type, label, url_resource, url_info, url_contact, demand_type_order, id_category, date_begin, date_end, workgroup_key, role_key, target, url_delete, is_include_id_user,is_need_authentication , is_need_validation) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.business.demand.DemandTypeTest:92
	testBusiness
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_STATUS_CRM in statement [ SELECT id_status_crm, status_label FROM crm_status_crm WHERE id_status_crm = ? ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.business.demand.DemandStatusCRMTest:53
	testBusiness
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_CATEGORY in statement [INSERT INTO crm_category ( id_category, name, description, code ) VALUES ( ?, ?, ?, ? ) ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.business.demand.category.CategoryTest:61
	testBusiness
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_NOTIFICATION in statement [ INSERT INTO crm_notification (id_notification, id_demand, is_read, object, message, date_creation, sender) VALUES (?,?,?,?,?,?,?) ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.business.notification.NotificationTest:81
	testBusiness
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_USER in statement [ INSERT INTO crm_user (id_crm_user, user_guid, status,must_be_updated) VALUES (?,?,?,?) ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.business.user.CRMUserTest:76
	testRegisterDemand
	fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: CRM_DEMAND in statement [ SELECT id_demand, id_demand_type, id_crm_user, status_text, id_status_crm, data, date_modification, remote_id FROM crm_demand WHERE remote_id = ? AND id_demand_type = ? ] - SQL statement : - Plugin : crm
	fr.paris.lutece.plugins.crm.service.CRMServiceTest:67