libopie1 goes into unsupported

1 files changed, 0 insertions, 694 deletions

diff --git a/libopie/pim/otodoaccesssql.cpp b/libopie/pim/otodoaccesssql.cpp
deleted file mode 100644
index fd01a42..0000000
--- a/libopie/pim/otodoaccesssql.cpp
+++ b/dev/null
@@ -1,694 +0,0 @@
-
-#include <qdatetime.h>
-
-#include <qpe/global.h>
-
-#include <opie2/osqldriver.h>
-#include <opie2/osqlresult.h>
-#include <opie2/osqlmanager.h>
-#include <opie2/osqlquery.h>
-
-#include "otodoaccesssql.h"
-#include "opimstate.h"
-#include "opimnotifymanager.h"
-#include "orecur.h"
-
-using namespace Opie::DB;
-/*
- * first some query
- * CREATE query
- * LOAD query
- * INSERT
- * REMOVE
- * CLEAR
- */
-namespace {
-    /**
-     * CreateQuery for the Todolist Table
-     */
-    class CreateQuery : public OSQLQuery {
-    public:
-        CreateQuery();
-        ~CreateQuery();
-        QString query()const;
-    };
-
-    /**
-     * LoadQuery
-     * this one queries for all uids
-     */
-    class LoadQuery : public OSQLQuery {
-    public:
-        LoadQuery();
-        ~LoadQuery();
-        QString query()const;
-    };
-
-    /**
-     * inserts/adds a OTodo to the table
-     */
-    class InsertQuery : public OSQLQuery {
-    public:
-        InsertQuery(const OTodo& );
-        ~InsertQuery();
-        QString query()const;
-    private:
-        OTodo m_todo;
-    };
-
-    /**
-     * removes one from the table
-     */
-    class RemoveQuery : public OSQLQuery {
-    public:
-        RemoveQuery(int uid );
-        ~RemoveQuery();
-        QString query()const;
-    private:
-        int m_uid;
-    };
-
-    /**
-     * Clears (delete) a Table
-     */
-    class ClearQuery : public OSQLQuery {
-    public:
-        ClearQuery();
-        ~ClearQuery();
-        QString query()const;
-
-    };
-
-    /**
-     * a find query
-     */
-    class FindQuery : public OSQLQuery {
-    public:
-        FindQuery(int uid);
-        FindQuery(const QArray<int>& );
-        ~FindQuery();
-        QString query()const;
-    private:
-        QString single()const;
-        QString multi()const;
-        QArray<int> m_uids;
-        int m_uid;
-    };
-
-    /**
-     * overdue query
-     */
-    class OverDueQuery : public OSQLQuery {
-    public:
-        OverDueQuery();
-        ~OverDueQuery();
-        QString query()const;
-    };
-    class EffQuery : public OSQLQuery {
-    public:
-        EffQuery( const QDate&, const QDate&, bool inc );
-        ~EffQuery();
-        QString query()const;
-    private:
-        QString with()const;
-        QString out()const;
-        QDate m_start;
-        QDate m_end;
-        bool m_inc :1;
-    };
-
-
-    CreateQuery::CreateQuery() : OSQLQuery() {}
-    CreateQuery::~CreateQuery() {}
-    QString CreateQuery::query()const {
-        QString qu;
-        qu += "create table todolist( uid PRIMARY KEY, categories, completed, ";
-        qu += "description, summary, priority, DueDate, progress ,  state, ";
-	// This is the recurrance-stuff .. Exceptions are currently not supported (see ORecur.cpp) ! (eilers)
-	qu += "RType, RWeekdays, RPosition, RFreq, RHasEndDate, EndDate, Created, Exceptions, "; 
-	qu += "reminders, alarms, maintainer, startdate, completeddate);";
-	qu += "create table custom_data( uid INTEGER, id INTEGER, type VARCHAR(10), value VARCHAR(10), PRIMARY KEY /* identifier */ (uid, id) );";
-        return qu;
-    }
-
-    LoadQuery::LoadQuery() : OSQLQuery() {}
-    LoadQuery::~LoadQuery() {}
-    QString LoadQuery::query()const {
-        QString qu;
-	// We do not need "distinct" here. The primary key is always unique..
-        //qu += "select distinct uid from todolist";
-        qu += "select uid from todolist";
-
-        return qu;
-    }
-
-    InsertQuery::InsertQuery( const OTodo& todo )
-        : OSQLQuery(), m_todo( todo ) {
-    }
-    InsertQuery::~InsertQuery() {
-    }
-    /*
-     * converts from a OTodo to a query
-     * we leave out X-Ref + Alarms
-     */
-    QString InsertQuery::query()const{
-
-        int year, month, day;
-        year = month = day = 0;
-        if (m_todo.hasDueDate() ) {
-            QDate date = m_todo.dueDate();
-            year = date.year();
-            month = date.month();
-            day = date.day();
-	}
-	int sYear = 0, sMonth = 0, sDay = 0;
-	if( m_todo.hasStartDate() ){
-		QDate sDate = m_todo.startDate();
-		sYear = sDate.year();
-		sMonth= sDate.month();
-		sDay  = sDate.day();
-	} 
-
-	int eYear = 0, eMonth = 0, eDay = 0;
-	if( m_todo.hasCompletedDate() ){
-		QDate eDate = m_todo.completedDate();
-		eYear = eDate.year();
-		eMonth= eDate.month();
-		eDay  = eDate.day();
-	} 
-        QString qu;
-	QMap<int, QString> recMap = m_todo.recurrence().toMap();
-        qu  = "insert into todolist VALUES(" 
-		+  QString::number( m_todo.uid() ) + "," 
-		+ "'" + m_todo.idsToString( m_todo.categories() ) + "'" + ","
-		+       QString::number( m_todo.isCompleted() )         + ","  
-		+ "'" + m_todo.description()                      + "'" + ","
-		+ "'" + m_todo.summary()                          + "'" + "," 
-		+       QString::number(m_todo.priority() )             + ","
-		+ "'" + QString::number(year) + "-" 
-		+       QString::number(month)
-		+       "-" + QString::number( day )              + "'" + ","
-		+       QString::number( m_todo.progress() )            + ","
- 		+       QString::number( m_todo.state().state() )       + ","
-		+ "'" + recMap[ ORecur::RType ]                   + "'" + ","
-		+ "'" + recMap[ ORecur::RWeekdays ]               + "'" + ","
-		+ "'" + recMap[ ORecur::RPosition ]               + "'" + ","
-		+ "'" + recMap[ ORecur::RFreq ]                   + "'" + ","
-		+ "'" + recMap[ ORecur::RHasEndDate ]             + "'" + ","
-		+ "'" + recMap[ ORecur::EndDate ]                 + "'" + ","
-		+ "'" + recMap[ ORecur::Created ]                 + "'" + ","
-		+ "'" + recMap[ ORecur::Exceptions ]              + "'" + ",";
-	
-	if ( m_todo.hasNotifiers() ) {
-		OPimNotifyManager manager = m_todo.notifiers();
-		qu += "'" + manager.remindersToString()           + "'" + ","		
-			+ "'" + manager.alarmsToString()          + "'" + ",";
-	}
-	else{
-		qu += QString( "''" )                                   + ","
-			+ "''"                                          + ",";
-	}
-
-	qu +=   QString( "''" )                             + QString( "," ) // Maintainers (cur. not supported !)
-		+ "'" + QString::number(sYear) + "-" 
-		+ QString::number(sMonth)
-		+ "-" + QString::number(sDay)                     + "'" + ","
-		+ "'" + QString::number(eYear) + "-"
-		+       QString::number(eMonth)
-		+       "-"+QString::number(eDay)                 + "'"
-		+ ")";
-
-        qWarning("add %s", qu.latin1() );
-        return qu;
-    }
-
-    RemoveQuery::RemoveQuery(int uid )
-        : OSQLQuery(), m_uid( uid ) {}
-    RemoveQuery::~RemoveQuery() {}
-    QString RemoveQuery::query()const {
-        QString qu = "DELETE from todolist where uid = " + QString::number(m_uid);
-        return qu;
-    }
-
-
-    ClearQuery::ClearQuery()
-        : OSQLQuery() {}
-    ClearQuery::~ClearQuery() {}
-    QString ClearQuery::query()const {
-        QString qu = "drop table todolist";
-        return qu;
-    }
-    FindQuery::FindQuery(int uid)
-        : OSQLQuery(), m_uid(uid ) {
-    }
-    FindQuery::FindQuery(const QArray<int>& ints)
-        : OSQLQuery(), m_uids(ints){
-    }
-    FindQuery::~FindQuery() {
-    }
-    QString FindQuery::query()const{
-        if (m_uids.count() == 0 )
-            return single();
-        else
-            return multi();
-    }
-    QString FindQuery::single()const{
-        QString qu = "select * from todolist where uid = " + QString::number(m_uid);
-        return qu;
-    }
-    QString FindQuery::multi()const {
-        QString qu = "select * from todolist where ";
-        for (uint i = 0; i < m_uids.count(); i++ ) {
-            qu += " UID = " + QString::number( m_uids[i] ) + " OR";
-        }
-        qu.remove( qu.length()-2, 2 );
-        return qu;
-    }
-
-    OverDueQuery::OverDueQuery(): OSQLQuery() {}
-    OverDueQuery::~OverDueQuery() {}
-    QString OverDueQuery::query()const {
-        QDate date = QDate::currentDate();
-        QString str;
-        str = QString("select uid from todolist where DueDate ='%1-%2-%3'").arg(date.year() ).arg(date.month() ).arg(date.day() );
-
-        return str;
-    }
-
-
-    EffQuery::EffQuery( const QDate& start, const QDate& end, bool inc )
-        : OSQLQuery(), m_start( start ), m_end( end ),m_inc(inc) {}
-    EffQuery::~EffQuery() {}
-    QString EffQuery::query()const {
-        return m_inc ? with() : out();
-    }
-    QString EffQuery::with()const {
-        QString str;
-        str = QString("select uid from todolist where ( DueDate >= '%1-%2-%3' AND DueDate <= '%4-%5-%6' ) OR DueDate = '0-0-0' ")
-            .arg( m_start.year() ).arg( m_start.month() ).arg( m_start.day() )
-            .arg( m_end  .year() ).arg( m_end  .month() ).arg( m_end  .day() );
-        return str;
-    }
-    QString EffQuery::out()const {
-        QString str;
-        str = QString("select uid from todolist where DueDate >= '%1-%2-%3' AND  DueDate <= '%4-%5-%6'")
-            .arg(m_start.year() ).arg(m_start.month() ).arg( m_start.day() )
-            .arg(m_end.  year() ).arg(m_end.  month() ).arg(m_end.day() );
-
-        return str;
-    }
-};
-
-OTodoAccessBackendSQL::OTodoAccessBackendSQL( const QString& file )
-    : OTodoAccessBackend(), m_dict(15), m_driver(NULL), m_dirty(true)
-{
-    QString fi = file;
-    if ( fi.isEmpty() )
-        fi = Global::applicationFileName( "todolist", "todolist.db" );
-    OSQLManager man;
-    m_driver = man.standard();
-    m_driver->setUrl(fi);
-    // fillDict();
-}
-
-OTodoAccessBackendSQL::~OTodoAccessBackendSQL(){
-	if( m_driver )
-		delete m_driver;
-}
-
-bool OTodoAccessBackendSQL::load(){
-    if (!m_driver->open() )
-        return false;
-
-    CreateQuery creat;
-    OSQLResult res = m_driver->query(&creat );
-
-    m_dirty = true;
-    return true;
-}
-bool OTodoAccessBackendSQL::reload(){
-    return load();
-}
-
-bool OTodoAccessBackendSQL::save(){
-    return m_driver->close();  // Shouldn't m_driver->sync be better than close ? (eilers)
-}
-QArray<int> OTodoAccessBackendSQL::allRecords()const {
-    if (m_dirty )
-        update();
-
-    return m_uids;
-}
-QArray<int> OTodoAccessBackendSQL::queryByExample( const OTodo& , int, const QDateTime& ){
-    QArray<int> ints(0);
-    return ints;
-}
-OTodo OTodoAccessBackendSQL::find(int uid ) const{
-    FindQuery query( uid );
-    return todo( m_driver->query(&query) );
-
-}
-OTodo OTodoAccessBackendSQL::find( int uid, const QArray<int>& ints,
-                                   uint cur, Frontend::CacheDirection dir ) const{
-    uint CACHE = readAhead();
-    qWarning("searching for %d", uid );
-    QArray<int> search( CACHE );
-    uint size =0;
-    OTodo to;
-
-    // we try to cache CACHE items
-    switch( dir ) {
-        /* forward */
-    case 0: // FIXME: Not a good style to use magic numbers here (eilers)
-        for (uint i = cur; i < ints.count() && size < CACHE; i++ ) {
-            qWarning("size %d %d", size,  ints[i] );
-            search[size] = ints[i];
-            size++;
-        }
-        break;
-        /* reverse */
-    case 1: // FIXME: Not a good style to use magic numbers here (eilers)
-        for (uint i = cur; i != 0 && size <  CACHE; i-- ) {
-            search[size] = ints[i];
-            size++;
-        }
-        break;
-    }
-    search.resize( size );
-    FindQuery query( search );
-    OSQLResult res = m_driver->query( &query  );
-    if ( res.state() != OSQLResult::Success )
-        return to;
-
-    return todo( res );
-}
-void OTodoAccessBackendSQL::clear() {
-    ClearQuery cle;
-    OSQLResult res = m_driver->query( &cle );
-    CreateQuery qu;
-    res = m_driver->query(&qu);
-}
-bool OTodoAccessBackendSQL::add( const OTodo& t) {
-    InsertQuery ins( t );
-    OSQLResult res = m_driver->query( &ins );
-
-    if ( res.state() == OSQLResult::Failure )
-        return false;
-    int c = m_uids.count();
-    m_uids.resize( c+1 );
-    m_uids[c] = t.uid();
-
-    return true;
-}
-bool OTodoAccessBackendSQL::remove( int uid ) {
-    RemoveQuery rem( uid );
-    OSQLResult res = m_driver->query(&rem );
-
-    if ( res.state() == OSQLResult::Failure )
-        return false;
-
-    m_dirty = true;
-    return true;
-}
-/*
- * FIXME better set query
- * but we need the cache for that
- * now we remove
- */
-bool OTodoAccessBackendSQL::replace( const OTodo& t) {
-    remove( t.uid() );
-    bool b= add(t);
-    m_dirty = false; // we changed some stuff but the UID stayed the same
-    return b;
-}
-QArray<int> OTodoAccessBackendSQL::overDue() {
-    OverDueQuery qu;
-    return uids( m_driver->query(&qu ) );
-}
-QArray<int> OTodoAccessBackendSQL::effectiveToDos( const QDate& s,
-                                                   const QDate& t,
-                                                   bool u) {
-    EffQuery ef(s, t, u );
-    return uids (m_driver->query(&ef) );
-}
-/*
- *
- */
-QArray<int> OTodoAccessBackendSQL::sorted( bool asc, int sortOrder,
-                                           int sortFilter, int cat ) {
-    qWarning("sorted %d, %d", asc, sortOrder );
-    QString query;
-    query = "select uid from todolist WHERE ";
-
-    /*
-     * Sort Filter stuff
-     * not that straight forward
-     * FIXME: Replace magic numbers
-     *
-     */
-    /* Category */
-    if ( sortFilter & 1 ) {
-        QString str;
-        if (cat != 0 ) str = QString::number( cat );
-        query += " categories like '%" +str+"%' AND";
-    }
-    /* Show only overdue */
-    if ( sortFilter & 2 ) {
-        QDate date = QDate::currentDate();
-        QString due;
-        QString base;
-        base = QString("DueDate <= '%1-%2-%3' AND completed = 0").arg( date.year() ).arg( date.month() ).arg( date.day() );
-        query += " " + base + " AND";
-    }
-    /* not show completed */
-    if ( sortFilter & 4 ) {
-        query += " completed = 0 AND";
-    }else{
-       query += " ( completed = 1 OR  completed = 0) AND";
-    }
-    /* srtip the end */
-    query = query.remove( query.length()-3, 3 );
-
-
-    /*
-     * sort order stuff
-     * quite straight forward
-     */
-    query += "ORDER BY ";
-    switch( sortOrder ) {
-        /* completed */
-    case 0:
-        query += "completed";
-        break;
-    case 1:
-        query += "priority";
-        break;
-    case 2:
-        query += "summary";
-        break;
-    case 3:
-        query += "DueDate";
-        break;
-    }
-
-    if ( !asc ) {
-        qWarning("not ascending!");
-        query += " DESC";
-    }
-
-    qWarning( query );
-    OSQLRawQuery raw(query );
-    return uids( m_driver->query(&raw) );
-}
-bool OTodoAccessBackendSQL::date( QDate& da, const QString& str ) const{
-    if ( str == "0-0-0" )
-        return false;
-    else{
-        int day, year, month;
-        QStringList list = QStringList::split("-", str );
-        year = list[0].toInt();
-        month = list[1].toInt();
-        day = list[2].toInt();
-        da.setYMD( year, month, day );
-        return true;
-    }
-}
-OTodo OTodoAccessBackendSQL::todo( const OSQLResult& res) const{
-    if ( res.state() == OSQLResult::Failure ) {
-        OTodo to;
-        return to;
-    }
-
-    OSQLResultItem::ValueList list = res.results();
-    OSQLResultItem::ValueList::Iterator it = list.begin();
-    qWarning("todo1");
-    OTodo to = todo( (*it) );
-    cache( to );
-    ++it;
-
-    for ( ; it != list.end(); ++it ) {
-        qWarning("caching");
-        cache( todo( (*it) ) );
-    }
-    return to;
-}
-OTodo OTodoAccessBackendSQL::todo( OSQLResultItem& item )const {
-    qWarning("todo");
-    bool hasDueDate = false; QDate dueDate = QDate::currentDate();
-    hasDueDate = date( dueDate, item.data("DueDate") );
-    QStringList cats = QStringList::split(";", item.data("categories") );
-
-    qWarning("Item is completed: %d", item.data("completed").toInt() );
-
-    OTodo to( (bool)item.data("completed").toInt(), item.data("priority").toInt(),
-              cats, item.data("summary"), item.data("description"),
-              item.data("progress").toUShort(), hasDueDate, dueDate,
-              item.data("uid").toInt() );
-
-    bool isOk;
-    int prioInt = QString( item.data("priority") ).toInt( &isOk );
-    if ( isOk )
-	    to.setPriority( prioInt );
-
-    bool hasStartDate = false; QDate startDate = QDate::currentDate();
-    hasStartDate = date( startDate, item.data("startdate") );
-    bool hasCompletedDate = false; QDate completedDate = QDate::currentDate();
-    hasCompletedDate = date( completedDate, item.data("completeddate") );
-
-    if ( hasStartDate )
-	    to.setStartDate( startDate );
-    if ( hasCompletedDate )
-	    to.setCompletedDate( completedDate );
-    
-    OPimNotifyManager& manager = to.notifiers();
-    manager.alarmsFromString( item.data("alarms") );
-    manager.remindersFromString( item.data("reminders") );
-
-    OPimState pimState;
-    pimState.setState( QString( item.data("state") ).toInt() );
-    to.setState( pimState );
-
-    QMap<int, QString> recMap;
-    recMap.insert( ORecur::RType      , item.data("RType") );
-    recMap.insert( ORecur::RWeekdays  , item.data("RWeekdays") );
-    recMap.insert( ORecur::RPosition  , item.data("RPosition") );
-    recMap.insert( ORecur::RFreq      , item.data("RFreq") );
-    recMap.insert( ORecur::RHasEndDate, item.data("RHasEndDate") );
-    recMap.insert( ORecur::EndDate    , item.data("EndDate") );
-    recMap.insert( ORecur::Created    , item.data("Created") );
-    recMap.insert( ORecur::Exceptions , item.data("Exceptions") );
-    
-    ORecur recur;
-    recur.fromMap( recMap );
-    to.setRecurrence( recur );
-
-    return to;
-}
-OTodo OTodoAccessBackendSQL::todo( int uid )const {
-    FindQuery find( uid );
-    return todo( m_driver->query(&find) );
-}
-/*
- * update the dict
- */
-void OTodoAccessBackendSQL::fillDict() {
-    /* initialize dict */
-    /*
-     * UPDATE dict if you change anything!!!
-     * FIXME: Isn't this dict obsolete ? (eilers)
-     */
-    m_dict.setAutoDelete( TRUE );
-    m_dict.insert("Categories" ,     new int(OTodo::Category)         );
-    m_dict.insert("Uid" ,            new int(OTodo::Uid)              );
-    m_dict.insert("HasDate" ,        new int(OTodo::HasDate)          );
-    m_dict.insert("Completed" ,      new int(OTodo::Completed)        );
-    m_dict.insert("Description" ,    new int(OTodo::Description)      );
-    m_dict.insert("Summary" ,        new int(OTodo::Summary)          );
-    m_dict.insert("Priority" ,       new int(OTodo::Priority)         );
-    m_dict.insert("DateDay" ,        new int(OTodo::DateDay)          );
-    m_dict.insert("DateMonth" ,      new int(OTodo::DateMonth)        );
-    m_dict.insert("DateYear" ,       new int(OTodo::DateYear)         );
-    m_dict.insert("Progress" ,       new int(OTodo::Progress)         );
-    m_dict.insert("Completed",       new int(OTodo::Completed)        ); // Why twice ? (eilers)
-    m_dict.insert("CrossReference",  new int(OTodo::CrossReference)   );
-//    m_dict.insert("HasAlarmDateTime",new int(OTodo::HasAlarmDateTime) ); // old stuff (eilers)
-//    m_dict.insert("AlarmDateTime",   new int(OTodo::AlarmDateTime)    ); // old stuff (eilers)
-}
-/*
- * need to be const so let's fool the
- * compiler :(
- */
-void OTodoAccessBackendSQL::update()const {
-    ((OTodoAccessBackendSQL*)this)->m_dirty = false;
-    LoadQuery lo;
-    OSQLResult res = m_driver->query(&lo);
-    if ( res.state() != OSQLResult::Success )
-        return;
-
-    ((OTodoAccessBackendSQL*)this)->m_uids = uids( res );
-}
-QArray<int> OTodoAccessBackendSQL::uids( const OSQLResult& res) const{
-
-    OSQLResultItem::ValueList list = res.results();
-    OSQLResultItem::ValueList::Iterator it;
-    QArray<int> ints(list.count() );
-    qWarning(" count = %d", list.count() );
-
-    int i = 0;
-    for (it = list.begin(); it != list.end(); ++it ) {
-        ints[i] =  (*it).data("uid").toInt();
-        i++;
-    }
-    return ints;
-}
-
-QArray<int> OTodoAccessBackendSQL::matchRegexp(  const QRegExp &r ) const
-{
-
-#warning OTodoAccessBackendSQL::matchRegexp() not implemented !!
-
-#if 0
-
-	Copied from xml-backend by not adapted to sql (eilers)
-
-	QArray<int> m_currentQuery( m_events.count() );
-	uint arraycounter = 0;
-
-
-
-        QMap<int, OTodo>::ConstIterator it;
-        for (it = m_events.begin(); it != m_events.end(); ++it ) {
-		if ( it.data().match( r ) )
-			m_currentQuery[arraycounter++] = it.data().uid();
-
-	}
-	// Shrink to fit..
-	m_currentQuery.resize(arraycounter);
-
-	return m_currentQuery;
-#endif
-	QArray<int> empty;
-	return empty;
-}
-QBitArray OTodoAccessBackendSQL::supports()const {
-
-	return sup();
-}
-
-QBitArray OTodoAccessBackendSQL::sup() const{
-
-	QBitArray ar( OTodo::CompletedDate + 1 );
-	ar.fill( true );
-	ar[OTodo::CrossReference] = false;
-	ar[OTodo::State ] = false;
-	ar[OTodo::Reminders] = false;
-	ar[OTodo::Notifiers] = false;
-	ar[OTodo::Maintainer] = false;
-	
-	return ar;
-}
-
-void OTodoAccessBackendSQL::removeAllCompleted(){
-#warning OTodoAccessBackendSQL::removeAllCompleted() not implemented !!
-
-}