示例#1
0
 /**
  * Get the databaseId for specified controlnode in table "controlnode".
  *
  * @param fragmentID the databaseID of the fragment the controlNode belongs to
  * @param modelID the modelId of the controlnode
  * @return the databaseID of the selected controlnode
  */
 public int getControlNodeID(int fragmentID, String modelID) {
   DbDataObject dbDataObject = new DbDataObject();
   String select =
       "SELECT id "
           + "FROM controlnode "
           + "WHERE fragment_id = "
           + fragmentID
           + " AND modelid = "
           + modelID;
   return dbDataObject.executeStatementReturnsInt(select, "id");
 }
示例#2
0
 /**
  * Get the databaseId for the specified fragment in table "fragment".
  *
  * @param scenarioID the shbaseID for which the fragment is selected
  * @param modelID the modelId of the fragment
  * @return the databaseID of the selected fragment
  */
 public int getFragmentID(int scenarioID, long modelID) {
   DbDataObject dbDataObject = new DbDataObject();
   String select =
       "SELECT id "
           + "FROM fragment "
           + "WHERE scenario_id = "
           + scenarioID
           + " AND modelid = "
           + modelID;
   return dbDataObject.executeStatementReturnsInt(select, "id");
 }
示例#3
0
 /**
  * Get the dataobjectID of the specified dataObject in table "dataobject".
  *
  * @param scenarioID the scenarioDatabaseID for which the dataobjectID is selected
  * @param dataObjectName the name of the dataObject (we assume that a scenario can't hold
  *     dataObjects with the same name)
  * @return the dataobject_id of the selected dataObject
  */
 public int getDataObjectID(int scenarioID, String dataObjectName) {
   DbDataObject dbDataObject = new DbDataObject();
   String select =
       "SELECT id "
           + "FROM dataobject "
           + "WHERE scenario_id = "
           + scenarioID
           + " AND name = '"
           + dataObjectName
           + "'";
   return dbDataObject.executeStatementReturnsInt(select, "id");
 }
示例#4
0
 /**
  * Find out if the scenario in the database is marked a s deleted.
  *
  * @param scenarioID DatabaseID of the scenario
  * @return The value of the deleted flag (1 if scenario is deleted; 0 otherwise)
  */
 public int isScenarioDeleted(int scenarioID) {
   DbDataObject dbDataObject = new DbDataObject();
   String select = "SELECT deleted " + "FROM scenario " + "WHERE id = " + scenarioID;
   return dbDataObject.executeStatementReturnsInt(select, "deleted");
 }
示例#5
0
 /**
  * Get the version of the domainModel that belongs to the specified scenario.
  *
  * @param scenarioID DatabaseID of the scenario
  * @return The version of the domainModel
  */
 public int getDataModelVersion(int scenarioID) {
   DbDataObject dbDataObject = new DbDataObject();
   String select = "SELECT datamodelversion " + "FROM scenario " + "WHERE id = " + scenarioID;
   return dbDataObject.executeStatementReturnsInt(select, "datamodelversion");
 }