Fork me on GitHub

Surefire Report

Summary

[Summary] [Package List] [Test Cases]


Tests Errors Failures Skipped Success Rate Time
74 8 10 0 75.676% 4.82

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.directory.modules.multiview.business.record.column.querypart 11 8 0 0 27.273% 0.05
fr.paris.lutece.plugins.directory.modules.multiview.business.service 10 0 0 0 100% 0.029
fr.paris.lutece.plugins.directory.modules.multiview.business.record.filter 6 0 0 0 100% 0.001
fr.paris.lutece.plugins.directory.modules.multiview.business.record 16 0 9 0 43.75% 3.265
fr.paris.lutece.plugins.directory.modules.multiview.util 12 0 0 0 100% 0.007
fr.paris.lutece.plugins.directory.modules.multiview.business.service.search 10 0 0 0 100% 0.467
fr.paris.lutece.plugins.directory.modules.multiview.business.record.column 8 0 0 0 100% 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.directory.modules.multiview.business.record.column.querypart

Class Tests Errors Failures Skipped Success Rate Time
RecordColumnWorkflowStateQueryPartTest 2 2 0 0 0% 0.01
RecordColumnEntryRecordFieldQueryPartTest 5 2 0 0 60% 0.016
RecordColumnRecordDateCreationQueryPartTest 2 2 0 0 0% 0.011
RecordColumnDirectoryQueryPartTest 2 2 0 0 0% 0.013

fr.paris.lutece.plugins.directory.modules.multiview.business.service

Class Tests Errors Failures Skipped Success Rate Time
DirectoryMultiviewAuthorizationServiceTest 4 0 0 0 100% 0.026
DirectoryMultiviewServiceTest 6 0 0 0 100% 0.003

fr.paris.lutece.plugins.directory.modules.multiview.business.record.filter

Class Tests Errors Failures Skipped Success Rate Time
RecordFilterQueryBuilderTest 6 0 0 0 100% 0.001

fr.paris.lutece.plugins.directory.modules.multiview.business.record

Class Tests Errors Failures Skipped Success Rate Time
QueryBuilderTest 11 0 9 0 18.182% 3.264
DirectoryRecordItemComparatorTest 5 0 0 0 100% 0.001

fr.paris.lutece.plugins.directory.modules.multiview.util

Class Tests Errors Failures Skipped Success Rate Time
ReferenceItemComparatorTest 6 0 0 0 100% 0.001
ReferenceListFactoryTest 6 0 0 0 100% 0.006

fr.paris.lutece.plugins.directory.modules.multiview.business.service.search

Class Tests Errors Failures Skipped Success Rate Time
DirectoryMultiviewSearchServiceTest 10 0 0 0 100% 0.467

fr.paris.lutece.plugins.directory.modules.multiview.business.record.column

Class Tests Errors Failures Skipped Success Rate Time
RecordColumnCellComparatorTest 8 0 0 0 100% 0.001

Test Cases

[Summary] [Package List] [Test Cases]

RecordColumnWorkflowStateQueryPartTest

testGetRecordColumnCellWorkflowState 0.005
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellWorkflowStateWithWrongColumnName 0.004
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece

RecordColumnEntryRecordFieldQueryPartTest

testGetRecordColumnJoinQueriesWithoutEntryTitle 0
testGetRecordColumnJoinQueries 0
testGetRecordColumnCellEntryRecordField 0.005
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellEntryRecordFieldWithWrongColumnName 0.01
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnJoinQueriesWithoutEntryTitleAndColumnPosition 0.001

DirectoryMultiviewSearchServiceTest

testFilterBySearchedTextWithoutResult 0.409
testFilterBySearchedTextWithoutDirectory 0.011
testFilterBySearchedTextWithEmptyTextSearch 0.002
testFilterBySearchedTextWithNullTextSearch 0.005
testFilterBySearchedText 0.009
testResultSearchUpdatedAfterDocumentAddition 0.013
testFilterBySearchedTextWithoutDirectoryAndAnalyzer 0.006
testFilterBySearchedTextWithoutAnalyzer 0.005
testFilterBySearchedTextWithPanelWithoutItem 0.002
testFilterBySearchedTextTwoResult 0.005

RecordColumnCellComparatorTest

testCompareWithoutSortKey 0.001
testCompareWithIntegerValues 0
testCompareWithOneMissingKey 0
testCompareWithFirstCellNullValue 0
testCompareWithSecondCellNullValue 0
testCompareWithoutValues 0
testCompareWithFirstCellValueGreater 0
testCompareWithSecondCellValueGreater 0

ReferenceItemComparatorTest

testCompareReferenceItemWithSecondEmpty 0
testCompareReferenceItemFirstGreater 0
testCompareReferenceItemSecondGreater 0
testCompareEmptyReferenceItem 0
testCompareReferenceItemSameNames 0
testCompareReferenceItemWithFirstEmpty 0

ReferenceListFactoryTest

testCreateReferenceListWithSort 0.005
testCreateReferenceListWithoutNumericCode 0
testCreateReferenceListWithDuplicates 0
testCreateReferenceLisCheckedNameReplacement 0
testCreateReferenceList 0
testCreateReferenceListWithChangedDefaultName 0

RecordFilterQueryBuilderTest

testBuildRecordFilterQueryWithNullValue 0
testBuildRecordFilterQueryWithoutElementToReplace 0
testBuildRecordFilterQueryWithMultipleName 0
testBuildRecordFilterQueryWithDirectoryPattern 0
testBuildRecordFilterQueryWithMultipleNameWithWrongValue 0
testBuildRecordFilterQueryWithWrongName 0

antrunsql

antrunsql 1

DirectoryMultiviewAuthorizationServiceTest

testIsUserAthorizedWithEmptyPanel 0.012
testIsUserAthorizedOnRecordOnUnauthorizedRecord 0.012
testIsUserAthorizedWithBadIdRecord 0.001
testIsUserAthorizedOnRecordOnAuthorizedRecord 0

DirectoryMultiviewServiceTest

testFindActiveRecordPanelWithNullList 0.001
testFindActiveRecordPanel 0
testFindActiveRecordPanelWithNoneActivePanels 0.001
testFindActiveRecordPanelWithEmptyList 0
testFindActiveRecordPanelWithSeveralActivePanels 0
testFindActiveRecordPanelWithSeveralPanels 0

QueryBuilderTest

testBuildQueryWithThreeColumnEntryRecordFields 3.165
Expected: is "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value, column_7.column_7_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record LEFT JOIN ( SELECT record_7.id_record AS id_record_7, record_field_7.record_field_value AS column_7_value FROM directory_record_field AS record_field_7 INNER JOIN directory_record AS record_7 ON record_field_7.id_record = record_7.id_record INNER JOIN directory_entry AS entry_7 ON entry_7.id_entry = record_field_7.id_entry WHERE entry_7.title IN ( 'Adresse', 'Téléphone' ) ) AS column_7 ON column_7.id_record_7 = record.id_record" but: was "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value, column_7.column_7_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record LEFT JOIN ( SELECT record_7.id_record AS id_record_7, record_field_7.record_field_value AS column_7_value FROM directory_record_field AS record_field_7 INNER JOIN directory_record AS record_7 ON record_field_7.id_record = record_7.id_record INNER JOIN directory_entry AS entry_7 ON entry_7.id_entry = record_field_7.id_entry WHERE entry_7.title IN ( 'Adresse', 'Téléphone' ) ) AS column_7 ON column_7.id_record_7 = record.id_record GROUP BY record.id_record"
testBuildQueryWithColumnWithoutRecordPanelInitializer 0.001
testBuildQueryWithColumnDirectory 0
Expected: is "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory" but: was "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory GROUP BY record.id_record"
testBuildQueryWithRecordPanelWithoutColumn 0
testBuildQueryWithTwoColumnsAndTwoFilters 0.006
Expected: is "SELECT id_directory, id_record, id_directory, title, workflow_state_name FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state WHERE 1=1 AND ( directory.id_directory = ? ) AND ( ws_workflow_state.id_state = ? )" but: was "SELECT id_directory, id_record, id_directory, title, workflow_state_name FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state WHERE 1=1 AND ( directory.id_directory = ? ) AND ( ws_workflow_state.id_state = ? ) GROUP BY record.id_record"
testBuildQueryWithColumnEntryRecordFieldsWithFilter 0.001
Expected: is "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record WHERE 1=1 AND ( column_5.column_5_value = ? )" but: was "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record WHERE 1=1 AND ( column_5.column_5_value = ? ) GROUP BY record.id_record"
testBuildQueryWithOneColumnEntryRecordField 0
Expected: is "SELECT id_directory, id_record, column_3.column_3_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record" but: was "SELECT id_directory, id_record, column_3.column_3_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record GROUP BY record.id_record"
testBuildQueryWithColumnDirectoryWorkflowStateDate 0.003
Expected: is "SELECT id_directory, id_record, id_directory, title, workflow_state_name, record_date_creation FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state" but: was "SELECT id_directory, id_record, id_directory, title, workflow_state_name, record_date_creation FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state GROUP BY record.id_record"
testBuildQueryWithDirectoryColumnWithFilterWithoutName 0
Expected: is "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1" but: was "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1 GROUP BY record.id_record"
testBuildQueryWithColumnDirectoryWithoutDirectoryInitializer 0
Expected: is "SELECT id_directory, title FROM" but: was "SELECT id_directory, title FROM GROUP BY record.id_record"
testBuildQueryWithDirectoryColumnWithFilter 0
Expected: is "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1 AND ( directory.id_directory = ? )" but: was "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1 AND ( directory.id_directory = ? ) GROUP BY record.id_record"

RecordColumnRecordDateCreationQueryPartTest

testGetRecordColumnCellRecordDateCreation 0.006
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellRecordDateCreationWithWrongColumnName 0.005
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece

DirectoryRecordItemComparatorTest

testCompareDescendantSortWithSecondDirectoryRecordItemEmpty 0
testCompareAscendantSortWithFirstDirectoryRecordItemEmpty 0
testCompareWithEmptyDirectoryRecordItems 0
testCompareAscendantSortWithSecondDirectoryRecordItemEmpty 0
testCompareDescendantSortWithFirstDirectoryRecordItemEmpty 0.001

RecordColumnDirectoryQueryPartTest

testGetRecordColumnCellDirectoryWithWrongColumnName 0.006
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellDirectory 0.007
DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece

Failure Details

[Summary] [Package List] [Test Cases]


testGetRecordColumnCellWorkflowState
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellWorkflowStateWithWrongColumnName
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellEntryRecordField
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellEntryRecordFieldWithWrongColumnName
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
antrunsql
antrunsql
testBuildQueryWithThreeColumnEntryRecordFields
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value, column_7.column_7_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record LEFT JOIN ( SELECT record_7.id_record AS id_record_7, record_field_7.record_field_value AS column_7_value FROM directory_record_field AS record_field_7 INNER JOIN directory_record AS record_7 ON record_field_7.id_record = record_7.id_record INNER JOIN directory_entry AS entry_7 ON entry_7.id_entry = record_field_7.id_entry WHERE entry_7.title IN ( 'Adresse', 'Téléphone' ) ) AS column_7 ON column_7.id_record_7 = record.id_record" but: was "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value, column_7.column_7_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record LEFT JOIN ( SELECT record_7.id_record AS id_record_7, record_field_7.record_field_value AS column_7_value FROM directory_record_field AS record_field_7 INNER JOIN directory_record AS record_7 ON record_field_7.id_record = record_7.id_record INNER JOIN directory_entry AS entry_7 ON entry_7.id_entry = record_field_7.id_entry WHERE entry_7.title IN ( 'Adresse', 'Téléphone' ) ) AS column_7 ON column_7.id_record_7 = record.id_record GROUP BY record.id_record"
testBuildQueryWithColumnDirectory
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory" but: was "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory GROUP BY record.id_record"
testBuildQueryWithTwoColumnsAndTwoFilters
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, id_directory, title, workflow_state_name FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state WHERE 1=1 AND ( directory.id_directory = ? ) AND ( ws_workflow_state.id_state = ? )" but: was "SELECT id_directory, id_record, id_directory, title, workflow_state_name FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state WHERE 1=1 AND ( directory.id_directory = ? ) AND ( ws_workflow_state.id_state = ? ) GROUP BY record.id_record"
testBuildQueryWithColumnEntryRecordFieldsWithFilter
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record WHERE 1=1 AND ( column_5.column_5_value = ? )" but: was "SELECT id_directory, id_record, column_3.column_3_value, column_5.column_5_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record LEFT JOIN ( SELECT record_5.id_record AS id_record_5, record_field_5.record_field_value AS column_5_value FROM directory_record_field AS record_field_5 INNER JOIN directory_record AS record_5 ON record_field_5.id_record = record_5.id_record INNER JOIN directory_entry AS entry_5 ON entry_5.id_entry = record_field_5.id_entry WHERE entry_5.title IN ( 'Date de naissance' ) ) AS column_5 ON column_5.id_record_5 = record.id_record WHERE 1=1 AND ( column_5.column_5_value = ? ) GROUP BY record.id_record"
testBuildQueryWithOneColumnEntryRecordField
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, column_3.column_3_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record" but: was "SELECT id_directory, id_record, column_3.column_3_value FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN ( SELECT record_3.id_record AS id_record_3, record_field_3.record_field_value AS column_3_value FROM directory_record_field AS record_field_3 INNER JOIN directory_record AS record_3 ON record_field_3.id_record = record_3.id_record INNER JOIN directory_entry AS entry_3 ON entry_3.id_entry = record_field_3.id_entry WHERE entry_3.title IN ( 'Nom', 'Prénom' ) ) AS column_3 ON column_3.id_record_3 = record.id_record GROUP BY record.id_record"
testBuildQueryWithColumnDirectoryWorkflowStateDate
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, id_directory, title, workflow_state_name, record_date_creation FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state" but: was "SELECT id_directory, id_record, id_directory, title, workflow_state_name, record_date_creation FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory LEFT JOIN workflow_resource_workflow AS wf_resource_workflow ON wf_resource_workflow.id_resource = record.id_record LEFT JOIN workflow_state AS ws_workflow_state ON ws_workflow_state.id_state = wf_resource_workflow.id_state GROUP BY record.id_record"
testBuildQueryWithDirectoryColumnWithFilterWithoutName
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1" but: was "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1 GROUP BY record.id_record"
testBuildQueryWithColumnDirectoryWithoutDirectoryInitializer
java.lang.AssertionError: Expected: is "SELECT id_directory, title FROM" but: was "SELECT id_directory, title FROM GROUP BY record.id_record"
testBuildQueryWithDirectoryColumnWithFilter
java.lang.AssertionError: Expected: is "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1 AND ( directory.id_directory = ? )" but: was "SELECT id_directory, id_record, id_directory, title FROM directory_directory AS directory INNER JOIN directory_record AS record ON record.id_directory = directory.id_directory WHERE 1=1 AND ( directory.id_directory = ? ) GROUP BY record.id_record"
testGetRecordColumnCellRecordDateCreation
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellRecordDateCreationWithWrongColumnName
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellDirectoryWithWrongColumnName
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece
testGetRecordColumnCellDirectory
fr.paris.lutece.portal.service.util.AppException: DAOUtil error : unexpected end of statement in statement [] - SQL statement : - Plugin : lutece