int database::dbPrivate::baseRecord::selectFromId()
{
clearNewValue();
clearError();
QString queryS=selectStr();
queryS.append(" WHERE id=?");
#ifdef QUERY_DEBUG
qDebug()<<"SELECT "<<queryS;
#endif
QSqlQuery q(databs);
q.prepare(queryS);
q.addBindValue(_id);
int ret= execSelect(q);
// saveValue();
return ret;
}
void CameraTrackSettingDialog::OnInfoListBoxDoubleClick( wxCommandEvent &event )
{
Ogre::String selectStr( mCameraInfoListBox->GetString( event.GetSelection() ).c_str() );
Ogre::StringVector infos = Ogre::StringUtil::split(selectStr, ",");
if (infos.size() == 3)
{
mPointIndexTextCtrl->SetValue( Ogre::StringConverter::toString(event.GetSelection() + 1).c_str() );
mPositionTextCtrl->SetValue( infos[0].c_str() );
mOrientationTextCtrl->SetValue( infos[1].c_str() );
mTimeTextCtrl->SetValue( infos[2].c_str() );
// 定位摄像机
mCamera->setPosition( Ogre::StringConverter::parseVector3(infos[0]) );
mCamera->setOrientation( Ogre::StringConverter::parseQuaternion(infos[1]) );
}
}
int database::dbPrivate::baseRecord::selectFromUnique()
{
clearError();
// saveDataLocaly();
QString queryS=selectStr();
queryS.append(" WHERE ");
entryIter i=nextUnique(entries.begin() );
if(i==entries.end() )
{
setError("No unigue entries");
return Basic::DBERR;
}
for(entryIter i=entries.begin();i!=entries.end();i++)
{
entry *e=i.value();
if(e->isUnique() )
{
queryS.append(e->name()+"=? AND ");
}
}
//remove last AND
queryS.resize(queryS.size()-5);
#ifdef QUERY_DEBUG
qDebug()<<"SELECT "<<queryS;
#endif
QSqlQuery q(databs);
q.prepare(queryS);
for(constEntryIter i=entries.constBegin();i!=entries.constEnd();i++)
{
const entry *e=i.value();
if(e->isUnique() )
{
q.addBindValue(e->chosenValue() );
}
}
return execSelect(q);
}
