void InputVariableRecord::constructRelatedRecords(const analysis::InputVariable& inputVariable) {
AttributeVector attributes, dbAttributes;
InputVariableRecord copyOfThis(getImpl<detail::InputVariableRecord_Impl>());
if (analysis::OptionalUncertaintyDescription dbUDesc = uncertaintyDescription()) {
dbAttributes = dbUDesc->cast<analysis::GenericUncertaintyDescription>().attributes();
}
if (analysis::OptionalUncertaintyDescription udesc = inputVariable.uncertaintyDescription()) {
attributes = udesc->cast<analysis::GenericUncertaintyDescription>().attributes();
}
for (const Attribute& attribute : attributes) {
// find in dbOptions
auto dbIt = std::find_if(dbAttributes.begin(),dbAttributes.end(),
std::bind(uuidsEqual<Attribute,Attribute>,std::placeholders::_1,attribute));
// if not there, or if different versionUUID, save it
if ((dbIt == dbAttributes.end()) || (attribute.versionUUID() != dbIt->versionUUID())) {
AttributeRecord udescAttributeRecord(attribute,copyOfThis);
}
// if there, erase from dbOptions
if (dbIt != dbAttributes.end()) {
dbAttributes.erase(dbIt);
}
}
// any attributes left in dbAttributes should be removed from the database
ProjectDatabase database = projectDatabase();
for (const Attribute& toRemove : dbAttributes) {
AttributeRecord dbUDescAttributeRecord = database.getObjectRecordByHandle<AttributeRecord>(toRemove.uuid()).get();
database.removeRecord(dbUDescAttributeRecord);
}
}
// Test not yet to scale re: data points.
TEST_F(ProjectFixture,Profile_ClearAnalysisResults) {
ProjectDatabase db = getPopulatedDatabase(100,500,true,toPath("./ClearAnalysisResults"));
// mimic code in AnalysisDriver to avoid adding AnalysisDriver as a dependency
// time the process of retrieving response function data
ptime start = microsec_clock::local_time();
db.unloadUnusedCleanRecords();
ASSERT_TRUE(db.startTransaction());
DataPointRecordVector dataPointRecords = DataPointRecord::getDataPointRecords(db);
EXPECT_EQ(500u,dataPointRecords.size());
BOOST_FOREACH(project::DataPointRecord& dataPointRecord,dataPointRecords) {
// in AnalysisDriver, removes DataPoint directories, but they don't exist here
db.removeRecord(dataPointRecord);
}
static bool unlink(int leftId, int rightId, ProjectDatabase projectDatabase)
{
bool result = false;
QSqlQuery query(*(projectDatabase.qSqlDatabase()));
query.prepare(toQString("SELECT * FROM " + T::databaseTableName() + " WHERE leftId=:leftId AND rightId=:rightId"));
query.bindValue(":leftId", leftId);
query.bindValue(":rightId", rightId);
assertExec(query);
if (query.first()){
T object(std::shared_ptr<typename T::ImplType>(new typename T::ImplType(query, projectDatabase)), projectDatabase);
result = projectDatabase.removeRecord(object);
}
return result;
}
static bool unlinkLeft(int leftId, ProjectDatabase projectDatabase)
{
bool result = false;
std::vector<T> toRemove;
QSqlQuery query(*(projectDatabase.qSqlDatabase()));
query.prepare(toQString("SELECT * FROM " + T::databaseTableName() + " WHERE leftId=:leftId"));
query.bindValue(":leftId", leftId);
assertExec(query);
while(query.next()){
T object(boost::shared_ptr<typename T::ImplType>(new typename T::ImplType(query, projectDatabase)), projectDatabase);
toRemove.push_back(object);
}
BOOST_FOREACH(T object, toRemove){
result = projectDatabase.removeRecord(object);
}
static bool unlinkRight(int rightId, ProjectDatabase projectDatabase)
{
bool result = false;
std::vector<T> toRemove;
QSqlQuery query(*(projectDatabase.qSqlDatabase()));
query.prepare(toQString("SELECT * FROM " + T::databaseTableName() + " WHERE rightId=:rightId"));
query.bindValue(":rightId", rightId);
assertExec(query);
while(query.next()){
T object(std::shared_ptr<typename T::ImplType>(new typename T::ImplType(query, projectDatabase)), projectDatabase);
toRemove.push_back(object);
}
for (T object : toRemove){
result = projectDatabase.removeRecord(object);
}
return result;
}
void CloudSessionRecord::constructRelatedRecords(const CloudSession& cloudSession,
ProjectDatabase& database)
{
CloudSessionRecord copyOfThis(getImpl<detail::CloudSessionRecord_Impl>());
bool isNew = database.isNewRecord(copyOfThis);
if (!isNew) {
getImpl<detail::CloudSessionRecord_Impl>()->revertToLastRecordIds();
}
if (isNew || (getImpl<detail::CloudSessionRecord_Impl>()->lastUuidLast() != cloudSession.versionUUID())) {
// remove any existing UrlRecords that have this object as its parent
ObjectRecordVector childUrls = children();
for (ObjectRecord& childUrl : childUrls) {
database.removeRecord(childUrl);
}
// create new UrlRecords
OptionalAWSSession awsSession = cloudSession.optionalCast<AWSSession>();
if (OptionalUrl serverUrl = cloudSession.serverUrl()) {
UrlRecord serverRecord(*serverUrl,copyOfThis);
if (awsSession) {
serverRecord.setName(awsSession->serverId());
}
getImpl<detail::CloudSessionRecord_Impl>()->setServerUrlRecordId(serverRecord.id());
}
StringVector workerIds;
if (awsSession) {
workerIds = awsSession->workerIds();
}
unsigned index(0);
for (const Url& workerUrl : cloudSession.workerUrls()) {
UrlRecord workerRecord(workerUrl,copyOfThis);
if (index < workerIds.size()) {
workerRecord.setName(workerIds[index]);
}
++index;
}
}
}
void MeasureGroupRecord::removeMeasureRecords(const std::vector<UUID>& uuidsToKeep,
ProjectDatabase& database)
{
QSqlQuery query(*(database.qSqlDatabase()));
std::stringstream ss;
ss << "SELECT * FROM " + MeasureRecord::databaseTableName() +
" WHERE (variableRecordId=:variableRecordId) AND (handle NOT IN (";
std::string sep("");
for (const UUID& handle : uuidsToKeep) {
ss << sep << "'" << toString(handle) << "'";
sep = std::string(", ");
}
ss << "))";
query.prepare(toQString(ss.str()));
query.bindValue(":variableRecordId",id());
assertExec(query);
while (query.next()) {
OptionalMeasureRecord measureRecord = MeasureRecord::factoryFromQuery(query, database);
if (measureRecord) {
database.removeRecord(*measureRecord);
}
}
}
void RubyContinuousVariableRecord::constructRelatedRecords(const analysis::Variable& variable)
{
analysis::RubyContinuousVariable rubyContinuousVariable = variable.cast<analysis::RubyContinuousVariable>();
RubyContinuousVariableRecord copyOfThis(getImpl<detail::RubyContinuousVariableRecord_Impl>());
ProjectDatabase database = projectDatabase();
bool isNew = database.isNewRecord(copyOfThis);
if (!isNew) {
getImpl<detail::RubyContinuousVariableRecord_Impl>()->revertToLastRecordIds();
}
// Save resource RubyMeasure
if (isNew || rubyContinuousVariable.perturbation().isDirty()) {
RubyMeasureRecord rubyMeasureRecord(rubyContinuousVariable.measure(),database);
getImpl<detail::RubyContinuousVariableRecord_Impl>()->setRubyMeasureRecordId(rubyMeasureRecord.id());
}
// Save child OSArgument
OSArgument argument = rubyContinuousVariable.argument();
bool saveArgument = false;
if (!isNew) {
{
// see if old argument record should be removed
OSArgumentRecord oldArgumentRecord = osArgumentRecord();
if (oldArgumentRecord.handle() != argument.uuid()) {
database.removeRecord(oldArgumentRecord);
saveArgument = true;
}
else if (oldArgumentRecord.uuidLast() != argument.versionUUID()) {
saveArgument = true;
}
}
database.unloadUnusedCleanRecords();
}
if (saveArgument || isNew) {
OSArgumentRecord osArgumentRecord(argument,copyOfThis);
}
}
TEST_F(ProjectFixture, WorkflowRecord_Base) {
ProjectDatabase database = getCleanDatabase("WorkflowRecord_Base");
EXPECT_EQ(database.timestampCreate(), database.timestampLast());
EXPECT_EQ(database.handle(), database.uuidLast());
openstudio::System::msleep(1000);
EXPECT_EQ(static_cast<unsigned>(0), WorkflowRecord::getWorkflowRecords(database).size());
openstudio::runmanager::Workflow rmWorkflow;
rmWorkflow.addJob(openstudio::runmanager::JobType::Null, "");
// Fake ProblemRecord so can test WorkflowRecord
Problem problem("Dummy",WorkflowStepVector());
ProblemRecord problemRecord = ProblemRecord::factoryFromProblem(problem,database);
WorkflowRecord workflowRecord(rmWorkflow, problemRecord, 0);
EXPECT_EQ("", workflowRecord.name());
EXPECT_EQ("", workflowRecord.displayName());
EXPECT_EQ("", workflowRecord.description());
EXPECT_TRUE(workflowRecord.timestampCreate() > database.timestampCreate());
EXPECT_EQ(workflowRecord.timestampCreate(), workflowRecord.timestampLast());
EXPECT_EQ(workflowRecord.handle(), rmWorkflow.uuid());
EXPECT_EQ(database.timestampLast(), database.timestampCreate());
EXPECT_EQ(database.handle(), database.uuidLast());
openstudio::System::msleep(1000);
database.save();
EXPECT_TRUE(database.timestampLast() > database.timestampCreate());
EXPECT_NE(database.handle(), database.uuidLast());
DateTime databaseTimestampLast = database.timestampLast();
UUID databaseUUIDLast = database.uuidLast();
openstudio::System::msleep(1000);
database.save();
EXPECT_EQ(database.timestampLast(), databaseTimestampLast);
EXPECT_EQ(database.uuidLast(), databaseUUIDLast);
EXPECT_EQ(static_cast<unsigned>(1), WorkflowRecord::getWorkflowRecords(database).size());
EXPECT_EQ(database.timestampLast(), databaseTimestampLast);
EXPECT_EQ(database.uuidLast(), databaseUUIDLast);
EXPECT_EQ(workflowRecord.timestampCreate(), workflowRecord.timestampLast());
EXPECT_EQ(workflowRecord.handle(), rmWorkflow.uuid());
EXPECT_TRUE(workflowRecord.setDescription("A simple workflowRecord"));
EXPECT_EQ(database.timestampLast(), databaseTimestampLast);
EXPECT_EQ(database.uuidLast(), databaseUUIDLast);
EXPECT_TRUE(workflowRecord.timestampCreate() < workflowRecord.timestampLast());
EXPECT_NE(workflowRecord.handle(), workflowRecord.uuidLast());
openstudio::System::msleep(1000);
database.save();
EXPECT_TRUE(databaseTimestampLast < database.timestampLast());
EXPECT_NE(database.uuidLast(), databaseUUIDLast);
EXPECT_TRUE(workflowRecord.timestampCreate() < workflowRecord.timestampLast());
EXPECT_NE(workflowRecord.handle(), workflowRecord.uuidLast());
databaseTimestampLast = database.timestampLast();
databaseUUIDLast = database.uuidLast();
DateTime workflowTimestampLast = workflowRecord.timestampLast();
UUID workflowUUIDLast = workflowRecord.uuidLast();
EXPECT_EQ(static_cast<unsigned>(1), WorkflowRecord::getWorkflowRecords(database).size());
EXPECT_EQ(database.timestampLast(), databaseTimestampLast);
EXPECT_EQ(database.uuidLast(), databaseUUIDLast);
EXPECT_EQ(workflowRecord.timestampLast(), workflowTimestampLast);
EXPECT_EQ(workflowRecord.uuidLast(), workflowUUIDLast);
EXPECT_TRUE(database.removeRecord(workflowRecord));
EXPECT_EQ(static_cast<unsigned>(0), WorkflowRecord::getWorkflowRecords(database).size());
EXPECT_EQ(database.timestampLast(), databaseTimestampLast);
EXPECT_EQ(database.uuidLast(), databaseUUIDLast);
EXPECT_EQ(workflowTimestampLast, workflowRecord.timestampLast());
EXPECT_EQ(workflowUUIDLast, workflowRecord.uuidLast());
openstudio::System::msleep(1000);
database.save();
EXPECT_TRUE(databaseTimestampLast < database.timestampLast());
EXPECT_NE(database.uuidLast(), databaseUUIDLast);
EXPECT_EQ(workflowTimestampLast, workflowRecord.timestampLast());
EXPECT_EQ(workflowUUIDLast, workflowRecord.uuidLast());
}
void OptimizationDataPointRecord_Impl::clearResults() {
ProjectDatabase database = projectDatabase();
DataPointValueRecordVector ovrs = objectiveValueRecords();
BOOST_FOREACH(DataPointValueRecord& ovr,ovrs) {
database.removeRecord(ovr);
}
// this is a monster test that is more for testing the database than attributes
TEST_F(ProjectFixture, AttributeRecord_LoadSave)
{
int id;
UUID handle;
Attribute attribute("name", 1.0, std::string("m"));
{
ProjectDatabase database = getCleanDatabase("AttributeRecord_LoadSave");
EXPECT_EQ(static_cast<unsigned>(0), AttributeRecord::getAttributeRecords(database).size());
FileReferenceRecord model(FileReference(toPath("./in.osm")),database);
AttributeRecord attributeRecord(attribute,model);
id = attributeRecord.id();
handle = attributeRecord.handle();
EXPECT_EQ("name", attributeRecord.name());
EXPECT_EQ("name", attributeRecord.displayName());
EXPECT_EQ("", attributeRecord.description());
EXPECT_EQ(AttributeValueType::Double, attributeRecord.attributeValueType().value());
EXPECT_EQ(1.0, attributeRecord.attributeValueAsDouble());
ASSERT_TRUE(attributeRecord.attributeUnits());
EXPECT_EQ("m", attributeRecord.attributeUnits().get());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_TRUE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_FALSE(database.isCleanRecord(attributeRecord));
EXPECT_FALSE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
}
{
// open existing database
ProjectDatabase database = getExistingDatabase("AttributeRecord_LoadSave");
// new objects were removed
EXPECT_EQ(static_cast<unsigned>(0), AnalysisRecord::getAnalysisRecords(database).size());
EXPECT_EQ(static_cast<unsigned>(0), FileReferenceRecord::getFileReferenceRecords(database).size());
EXPECT_EQ(static_cast<unsigned>(0), AttributeRecord::getAttributeRecords(database).size());
FileReferenceRecord model(FileReference(toPath("./in.osm")),database);
// create AttributeRecord
AttributeRecord attributeRecord(attribute, model);
id = attributeRecord.id();
handle = attributeRecord.handle();
EXPECT_EQ("name", attributeRecord.name());
EXPECT_EQ("name", attributeRecord.displayName());
EXPECT_EQ("", attributeRecord.description());
EXPECT_EQ(AttributeValueType::Double, attributeRecord.attributeValueType().value());
EXPECT_EQ(1.0, attributeRecord.attributeValueAsDouble());
ASSERT_TRUE(attributeRecord.attributeUnits());
EXPECT_EQ("m", attributeRecord.attributeUnits().get());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_TRUE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_FALSE(database.isCleanRecord(attributeRecord));
EXPECT_FALSE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
// save to database
EXPECT_TRUE(database.save());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_FALSE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_TRUE(database.isCleanRecord(attributeRecord));
EXPECT_FALSE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
}
{
// open existing database
ProjectDatabase database = getExistingDatabase("AttributeRecord_LoadSave");
// saved objects were not removed
ASSERT_EQ(static_cast<unsigned>(1), FileReferenceRecord::getFileReferenceRecords(database).size());
ASSERT_EQ(static_cast<unsigned>(1), AttributeRecord::getAttributeRecords(database).size());
std::vector<FileReferenceRecord> fileReferenceRecords = FileReferenceRecord::getFileReferenceRecords(database);
FileReferenceRecord model = fileReferenceRecords.at(0);
EXPECT_EQ(static_cast<unsigned>(1), model.attributeRecords().size());
AttributeRecord attributeRecord = model.attributeRecords()[0];
EXPECT_EQ(id, attributeRecord.id());
EXPECT_EQ(handle, attributeRecord.handle());
EXPECT_EQ("name", attributeRecord.name());
EXPECT_EQ("name", attributeRecord.displayName());
EXPECT_EQ("", attributeRecord.description());
EXPECT_EQ(AttributeValueType::Double, attributeRecord.attributeValueType().value());
EXPECT_EQ(1.0, attributeRecord.attributeValueAsDouble());
ASSERT_TRUE(attributeRecord.attributeUnits());
EXPECT_EQ("m", attributeRecord.attributeUnits().get());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_FALSE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_TRUE(database.isCleanRecord(attributeRecord));
EXPECT_FALSE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
// remove record but don't save
EXPECT_TRUE(database.removeRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(1), FileReferenceRecord::getFileReferenceRecords(database).size());
EXPECT_EQ(static_cast<unsigned>(0), AttributeRecord::getAttributeRecords(database).size());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_FALSE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_FALSE(database.isCleanRecord(attributeRecord));
EXPECT_TRUE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
}
{
// open existing database
ProjectDatabase database = getExistingDatabase("AttributeRecord_LoadSave");
// saved objects were not removed
ASSERT_EQ(static_cast<unsigned>(1), FileReferenceRecord::getFileReferenceRecords(database).size());
ASSERT_EQ(static_cast<unsigned>(1), AttributeRecord::getAttributeRecords(database).size());
std::vector<FileReferenceRecord> fileReferenceRecords = FileReferenceRecord::getFileReferenceRecords(database);
FileReferenceRecord model = fileReferenceRecords.at(0);
EXPECT_EQ(static_cast<unsigned>(1), model.attributeRecords().size());
AttributeRecord attributeRecord = model.attributeRecords()[0];
EXPECT_EQ(id, attributeRecord.id());
EXPECT_EQ(handle, attributeRecord.handle());
EXPECT_EQ("name", attributeRecord.name());
EXPECT_EQ("name", attributeRecord.displayName());
EXPECT_EQ("", attributeRecord.description());
EXPECT_EQ(AttributeValueType::Double, attributeRecord.attributeValueType().value());
EXPECT_EQ(1.0, attributeRecord.attributeValueAsDouble());
ASSERT_TRUE(attributeRecord.attributeUnits());
EXPECT_EQ("m", attributeRecord.attributeUnits().get());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_FALSE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_TRUE(database.isCleanRecord(attributeRecord));
EXPECT_FALSE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
// remove record then save save
EXPECT_TRUE(database.removeRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(1), FileReferenceRecord::getFileReferenceRecords(database).size());
EXPECT_EQ(static_cast<unsigned>(0), AttributeRecord::getAttributeRecords(database).size());
EXPECT_TRUE(database.includesRecord(attributeRecord));
EXPECT_FALSE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_FALSE(database.isCleanRecord(attributeRecord));
EXPECT_TRUE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(2), attributeRecord.useCount());
EXPECT_TRUE(database.save());
EXPECT_EQ(static_cast<unsigned>(1), FileReferenceRecord::getFileReferenceRecords(database).size());
EXPECT_EQ(static_cast<unsigned>(0), AttributeRecord::getAttributeRecords(database).size());
EXPECT_FALSE(database.includesRecord(attributeRecord));
EXPECT_FALSE(database.isNewRecord(attributeRecord));
EXPECT_FALSE(database.isDirtyRecord(attributeRecord));
EXPECT_FALSE(database.isCleanRecord(attributeRecord));
EXPECT_FALSE(database.isRemovedRecord(attributeRecord));
EXPECT_EQ(static_cast<unsigned>(1), attributeRecord.useCount());
}
{
// open existing database
ProjectDatabase database = getExistingDatabase("AttributeRecord_LoadSave");
// objects were removed
EXPECT_EQ(static_cast<unsigned>(1), FileReferenceRecord::getFileReferenceRecords(database).size());
EXPECT_EQ(static_cast<unsigned>(0), AttributeRecord::getAttributeRecords(database).size());
}
}
