Esempio n. 1
0
 // ---------------------------------------------------------------------------------
 success Project::assign_query_values_to_entity ( QSqlQuery& query, dp::Project& p ) const
 {
   p.setName ( query.value ( 1 ).toString() );
   p.setCreationDate ( query.value ( 2 ).toDateTime() );
   p.setComment( query.value(3).toString() );
   return successful();
 }
Esempio n. 2
0
 // ---------------------------------------------------------------------------------
 bool operator == (dp::Project const& lhs, dp::Project const& rhs)
 {
   if(lhs.id().isNull())
   {
     return (rhs.id().isNull());
   }
   return lhs.id() == rhs.id();
 }
Esempio n. 3
0
 // ---------------------------------------------------------------------------------
 success Project::update ( const dp::Project& _p ) const
 {
   if ( _p.id().isNull())
   {
     return error();
   }
   QSqlQuery query;
   query.prepare ( UPDATE_PROJECT );
   query.addBindValue ( _p.name() );
   query.addBindValue ( _p.creationDate() );
   query.addBindValue( _p.comment() );
   query.addBindValue ( _p.id().toString() );
   return execute ( query );
 }
Esempio n. 4
0
 // ---------------------------------------------------------------------------------
 // private stuff:
 // ---------------------------------------------------------------------------------
 bool Project::exists ( const dp::Project& _project ) const
 {
   if ( _project.id().isNull() )
   {
     return false;
   }
   QSqlQuery query;
   query.prepare ( SELECT_DISTINCT_PROJECT );
   query.addBindValue ( _project.id().toString() );
   if ( execute ( query ).has_failed() )
   {
     return false;
   }
   return query.first();
 }
Esempio n. 5
0
 // ---------------------------------------------------------------------------------
 success Project::insert ( dp::Project const& _p ) const
 {
   if ( _p.id().isNull())
   {
     return error();
   }
   QSqlQuery query;
   query.prepare ( INSERT_PROJECT );
   query.addBindValue ( _p.id().toString() );
   query.addBindValue ( _p.name() );
   query.addBindValue ( _p.creationDate() );
   query.addBindValue( _p.comment() );
   if ( execute ( query ).has_failed() )
   {
     return error();
   }
   return successful();
 }
Esempio n. 6
0
 // ---------------------------------------------------------------------------------
 success Project::remove(dp::Project const& _project) const
 {
   if ( _project.id().isNull())
   {
     return error();
   }
   if(!exists(_project))
   {
       return successful();
   }
   QSqlQuery query;
   query.prepare(REMOVE_PROJECT);
   query.addBindValue(_project.id().toString());
   if(execute(query).has_failed())
   {
     return error();
   }
   return successful();
 }
Esempio n. 7
0
 // ---------------------------------------------------------------------------------
 success Project::load ( dp::Project &p ) const
 {
   if ( p.id().isNull())
   {
     return error();
   }
   QSqlQuery query;
   query.prepare ( SELECT_DISTINCT_PROJECT );
   query.addBindValue ( p.id().toString() );
   if ( execute ( query ).has_failed() )
   {
     kWarning()<<"last error: "<<query.lastError();
     return error();
   }
   if ( !query.first() )
   {
     kWarning()<<"last error: "<<query.lastError();
     return error();
   }
   return assign_query_values_to_entity ( query, p );
 }