| java.lang.Object
 org.objectweb.salome_tmf.databaseSQL.SQLCampaign
| Method Summary | |
| public int | addAttachFile(int idCamp, SalomeFileWrapper file, String description)
| | public int | addAttachUrl(int idCamp, String url, String description)
| | public void | delete(int idCamp)
| | public void | delete(int idCamp, boolean reorder)
| | public void | deleteAllAttach(int idCamp)
| | public void | deleteAllDataset(int idCamp)
| | public void | deleteAllExec(int idCamp)
| | public void | deleteAttach(int idCamp, int idAttach)
| | public void | deleteTest(int idCamp, int testId, boolean deleteExec)
| | public void | deleteTest(int idCamp, int testId, boolean deleteExec, boolean reorder)
| | public void | deleteTestInAllCampaign(int idTest)
| | public CampaignWrapper[] | getAllCampaigns(int idProject)
| | public FileAttachementWrapper[] | getAttachFiles(int idCamp)
| | public UrlAttachementWrapper[] | getAttachUrls(int idCamp)
| | public AttachementWrapper[] | getAttachs(int idCamp)
| | public CampaignWrapper | getCampaign(int idCamp)
| | public CampaignWrapper | getCampaignByOrder(int idProject, int order)
| | public DataSetWrapper[] | getDatsets(int idCamp)
| | public ExecutionWrapper[] | getExecutions(int idCamp)
| | public int | getID(int idProject, String name)
| | TestCampWrapper | getInCampaignFirstTestInFamily(int idCamp, int idFamily)
| | TestCampWrapper | getInCampaignFirstTestInSuite(int idCamp, int idSuite)
| | TestCampWrapper | getInCampaignLastTestInFamily(int idCamp, int idFamily)
| | TestCampWrapper | getInCampaignLastTestInSuite(int idCamp, int idSuite)
| | public int | getNumberOfCampaign(int idProject)
| | public int | getNumberOfTestInCampaign(int idCamp)
| | public ExecutionAttachmentWrapper[] | getResExecutionsAttachment(int idCamp)
| | public int | getSizeOfFamilyInCampaign(int idCamp, int idFamily)
| | public int | getSizeOfSuiteInCampaign(int idCamp, int idSuite)
| | public TestCampWrapper | getTestCampById(int idCamp, int idTest)
| | public TestCampWrapper | getTestCampByOrder(int idCamp, int order)
| | public TestCampWrapper[] | getTestsByOrder(int idCamp)
| | public int | importTest(int idCamp, int idTest, int userID)
| | public int | insert(int idProject, String name, String description, int idPers)
| | void | purgeTest(int idCamp, int idTest, boolean deleteExec)
| | public void | update(int idCamp, String name, String description)
| | public void | updateCampagneAssignationRef(int idCamp, int assignedNewID)
| | public void | updateFamilyAssignation(int idCamp, int idFamille, int assignedID)
| | void | updateOrder(int idCamp, int order)
| | public int | updateOrder(int idCamp, boolean increment)
| | public void | updateSuiteAssignation(int idCamp, int idSuite, int assignedID)
| | public void | updateTestAssignation(int idCamp, int idTest, int assignedID)
| | public void | updateTestAssignationRef(int idCamp, int assignedOldID, int assignedNewID)
| | public void | updateTestFamilyOrder(int idCamp, int idFamily, boolean increment)
| | void | updateTestOrder(int idCamp, int idTest, int order)
| | public int | updateTestOrder(int idCamp, int idTest, boolean increment)
| | public void | updateTestSuiteOrder(int idCamp, int idSuite, boolean increment)
| | public void | updateUserRef(int idCamp, int oldIdUser, int newIdUser)
|
| addAttachFile | | public int addAttachFile(int idCamp, SalomeFileWrapper file, String description) throws Exception(Code) | | Attach a file to a campaign identified by idCamp (table CAMPAGNE_ATTACHEMENT)
Parameters:
idCamp -
Parameters:
file - : the file to insert in the database
Parameters:
description - the id of the attachement in the table ATTACHEMENT
throws:
Exception -
See Also: ISQLFileAttachment.insert(File, String)
See Also: no permission needed |
| addAttachUrl | | public int addAttachUrl(int idCamp, String url, String description) throws Exception(Code) | | Attach a URL to a campaign identified by idCamp (table CAMPAGNE_ATTACHEMENT)
Parameters:
idCamp -
Parameters:
url - : the url to insert in the database
Parameters:
description - the id of the attachement in the table ATTACHEMENT
throws:
Exception -
See Also: ISQLUrlAttachment.insert(String String)
See Also: no permission needed |
| delete | | public void delete(int idCamp) throws Exception(Code) | | Delete a campaign and it's related links in the database
include : delete test in campaign, dataset, execution (and result), and attachment
reorder the campaign in the project
Parameters:
idCamp -
throws:
Exception - need permission canDeleteCamp
See Also: deleteTest(int,int)
See Also: deleteAllExec(int)
See Also: deleteAllAttach(int)
See Also: deleteAllDataset(int)
See Also: need permission canDeleteCamp |
| delete | | public void delete(int idCamp, boolean reorder) throws Exception(Code) | | Delete a campaign and it's related links in the database
include : delete test in campaign, dataset, execution (and result), and attachment
reorder the campaign in the project if reorder = true
Parameters:
idCamp -
throws:
Exception - need permission canDeleteCamp
See Also: deleteTest(int,int)
See Also: deleteAllExec(int)
See Also: deleteAllAttach(int)
See Also: deleteAllDataset(int)
See Also: need permission canDeleteCamp |
| deleteAllAttach | | public void deleteAllAttach(int idCamp) throws Exception(Code) | | Delete all attachments in the campaign (table CAMPAGNE_ATTACHEMENT and ATTACHEMENT)
Parameters:
idCamp -
See Also: deleteAttach(int, int)
throws:
Exception - |
| deleteAllDataset | | public void deleteAllDataset(int idCamp) throws Exception(Code) | | Delete all datasets reference for the campaign identified by idCamp
Parameters:
idCamp -
throws:
Exception -
See Also: ISQLDataset.delete(int)
See Also: need permission canExecutCamp or canDeleteCamp |
| deleteAllExec | | public void deleteAllExec(int idCamp) throws Exception(Code) | | Delete all executions reference (and it's result) for the campaign identified by idCamp
Parameters:
idCamp -
throws:
Exception -
See Also: ISQLExecution.delete(int)
See Also: need permission canExecutCamp or canDeleteCamp |
| deleteAttach | | public void deleteAttach(int idCamp, int idAttach) throws Exception(Code) | | Delete an attachment idAttach in the campaign (table CAMPAGNE_ATTACHEMENT and ATTACHEMENT)
Parameters:
idCamp -
Parameters:
idAttach -
throws:
Exception -
See Also: ISQLAttachment.delete(int)
See Also: no permission needed |
| deleteTest | | public void deleteTest(int idCamp, int testId, boolean deleteExec) throws Exception(Code) | | |
| deleteTest | | public void deleteTest(int idCamp, int testId, boolean deleteExec, boolean reorder) throws Exception(Code) | | Delete a test reference for the campaign identified by idCamp
then reoder the test in the campaign, and clean result on Excecution
then delete execution if empty and deleteExec = true
Parameters:
idCamp -
Parameters:
testId -
Parameters:
deleteExec -
throws:
Exception - need permission canDeleteCamp |
| deleteTestInAllCampaign | | public void deleteTestInAllCampaign(int idTest) throws Exception(Code) | | Delete a test reference in all campaign and then reorder the tests in the campaign
Parameters:
idTest -
See Also: deleteTest(int, int)
See Also: need permission canDeleteCamp
throws:
Exception - |
| getAllCampaigns | | public CampaignWrapper[] getAllCampaigns(int idProject) throws Exception(Code) | | Return a Vector of CampaignWrapper representing the campaign of the project identified by idProject
Parameters:
idProject -
throws:
Exception - |
| getAttachFiles | | public FileAttachementWrapper[] getAttachFiles(int idCamp) throws Exception(Code) | | Get a Vector of FileAttachementWrapper for the campaign identified by idCamp
Parameters:
idCamp - : id of the campaign
throws:
Exception - |
| getAttachUrls | | public UrlAttachementWrapper[] getAttachUrls(int idCamp) throws Exception(Code) | | Get a Vector of UrlAttachementWrapper for the campaign identified by idCamp
Parameters:
idCamp - : id of the campaign
throws:
Exception - |
| getAttachs | | public AttachementWrapper[] getAttachs(int idCamp) throws Exception(Code) | | Get a Vector of AttachementWrapper (FileAttachementWrapper, UrlAttachementWrapper)
for the campaign identified by idCamp
Parameters:
idCamp - : id of the campaign
throws:
Exception - |
| getCampaignByOrder | | public CampaignWrapper getCampaignByOrder(int idProject, int order) throws Exception(Code) | | Return a CampaignWrapper representing a campaign at order 'order' in the project identified by idProject
Parameters:
idProject -
Parameters:
order -
throws:
Exception - |
| getID | | public int getID(int idProject, String name) throws Exception(Code) | | Get the id of the campaign identified by name in the project identified by idProject
Parameters:
idProject -
Parameters:
name -
throws:
Exception - |
| getNumberOfCampaign | | public int getNumberOfCampaign(int idProject) throws Exception(Code) | | Return the number of campaign in the project identified by idProject
Parameters:
idProject -
throws:
Exception - |
| getNumberOfTestInCampaign | | public int getNumberOfTestInCampaign(int idCamp) throws Exception(Code) | | Return the number of tests in the campaign identified by idCamp
Parameters:
idCamp -
throws:
Exception - |
| getResExecutionsAttachment | | public ExecutionAttachmentWrapper[] getResExecutionsAttachment(int idCamp) throws Exception(Code) | | Get an Array of ExecutionAttachmentWrapper
representing all attachement of all execution result
Parameters:
idCamp -
throws:
Exception - |
| getSizeOfFamilyInCampaign | | public int getSizeOfFamilyInCampaign(int idCamp, int idFamily) throws Exception(Code) | | Get the number of tests in the family idFamily in the campaign idCamp
Parameters:
idCamp -
Parameters:
idFamily -
throws:
Exception - |
| getSizeOfSuiteInCampaign | | public int getSizeOfSuiteInCampaign(int idCamp, int idSuite) throws Exception(Code) | | Get the number of tests in the suite idSuite in the campaign idCamp
Parameters:
idCamp -
Parameters:
idSuite -
throws:
Exception - |
| getTestCampById | | public TestCampWrapper getTestCampById(int idCamp, int idTest) throws Exception(Code) | | Get a TestCampWrapper representing the test idTest in the campagne idCamp
Parameters:
idCamp -
Parameters:
idTest -
throws:
Exception - |
| getTestCampByOrder | | public TestCampWrapper getTestCampByOrder(int idCamp, int order) throws Exception(Code) | | Get a TestCampWrapper representing the test at defined order in the campagne idCamp
Parameters:
idCamp -
Parameters:
order -
throws:
Exception - |
| getTestsByOrder | | public TestCampWrapper[] getTestsByOrder(int idCamp) throws Exception(Code) | | Get an ordered Vector of TestCampWrapper representing test available in the campaign idCamp
Parameters:
idCamp -
throws:
Exception - |
| importTest | | public int importTest(int idCamp, int idTest, int userID) throws Exception(Code) | | Import a test identified by idTest (in table CAS_TEST) in the campaign identified by idCamp
in table CAMPAGNE_CAS
Parameters:
idCamp -
Parameters:
idTest - the order of the test in the campaign
throws:
Exception - need permission canCreateCamp |
| insert | | public int insert(int idProject, String name, String description, int idPers) throws Exception(Code) | | Inset a campaign in table CAMPAGNE_TEST
Parameters:
idProject - : id of the projet where to insert the campaign
Parameters:
name - of the campaign
Parameters:
description - of the campaign
Parameters:
idPers - : id of the user who insert the campaign the id (id_camp) of new campaign
throws:
Exception - need permission canCreateCamp |
| purgeTest | | void purgeTest(int idCamp, int idTest, boolean deleteExec) throws Exception(Code) | | |
| update | | public void update(int idCamp, String name, String description) throws Exception(Code) | | Update the name and the description of the campaign identified by idCamp
Parameters:
idCamp - of the campaign
Parameters:
name - : new name of the campaign
Parameters:
description - : new description of the campaign
throws:
Exception - need permission canUpdateCamp |
| updateCampagneAssignationRef | | public void updateCampagneAssignationRef(int idCamp, int assignedNewID) throws Exception(Code) | | Update All test Assignation (field assigned_user_id) in CAMPAGNE_CAS
Parameters:
idCamp -
Parameters:
idTest -
Parameters:
assignedID -
throws:
Exception - |
| updateFamilyAssignation | | public void updateFamilyAssignation(int idCamp, int idFamille, int assignedID) throws Exception(Code) | | Update Suite Assignation (field assigned_user_id for all tests in the suite) in CAMPAGNE_CAS
Parameters:
idCamp -
Parameters:
idTest -
Parameters:
assignedID -
throws:
Exception - |
| updateOrder | | public int updateOrder(int idCamp, boolean increment) throws Exception(Code) | | Update the order of the campaign by incrementation (if increment = true) or decrementation
Parameters:
idCamp - : id of the campaign
Parameters:
increment -
throws:
Exception - need permission canUpdateCamp or canExecutCamp |
| updateSuiteAssignation | | public void updateSuiteAssignation(int idCamp, int idSuite, int assignedID) throws Exception(Code) | | Update Suite Assignation (field assigned_user_id for all tests in the suite) in CAMPAGNE_CAS
Parameters:
idCamp -
Parameters:
idTest -
Parameters:
assignedID -
throws:
Exception - |
| updateTestAssignation | | public void updateTestAssignation(int idCamp, int idTest, int assignedID) throws Exception(Code) | | Update test Assignation (field assigned_user_id) in CAMPAGNE_CAS
Parameters:
idCamp -
Parameters:
idTest -
Parameters:
assignedID -
throws:
Exception - |
| updateTestAssignationRef | | public void updateTestAssignationRef(int idCamp, int assignedOldID, int assignedNewID) throws Exception(Code) | | Update test Assignation for all reference of old assignation (field assigned_user_id) in CAMPAGNE_CAS
Parameters:
idCamp -
Parameters:
idTest -
Parameters:
assignedID -
throws:
Exception - |
| updateTestFamilyOrder | | public void updateTestFamilyOrder(int idCamp, int idFamily, boolean increment) throws Exception(Code) | | Update a family order in the campaign (+1 if increment = true) or -1
Parameters:
idCamp -
Parameters:
idFamily - : id of the suite in table FAMILLE_TEST
Parameters:
increment -
throws:
Exception - need permission canUpdateCamp or canExecutCamp |
| updateTestOrder | | void updateTestOrder(int idCamp, int idTest, int order) throws Exception(Code) | | |
| updateTestOrder | | public int updateTestOrder(int idCamp, int idTest, boolean increment) throws Exception(Code) | | Update a test order in the campaign (+1 if increment = true) or -1
Parameters:
idCamp -
Parameters:
idTest - : id of the test in the table CAS_TEST
Parameters:
increment -
throws:
Exception - need permission canUpdateCamp |
| updateTestSuiteOrder | | public void updateTestSuiteOrder(int idCamp, int idSuite, boolean increment) throws Exception(Code) | | Update test suite order in the campaign (+1 if increment = true) or -1
Parameters:
idCamp - : id of the campaign
Parameters:
idSuite - : id of the suite in table SUITE_TEST
Parameters:
increment -
throws:
Exception - need permission canUpdateCamp or canExecutCamp |
| updateUserRef | | public void updateUserRef(int idCamp, int oldIdUser, int newIdUser) throws Exception(Code) | | replace all reference of user oldIdUser by newIdUser in the table (CAMPAGNE_CAS) whrerre campagne = idCamp
Parameters:
oldIdUser -
Parameters:
newIdUser -
throws:
Exception - no permission needed |
|
|