switching to sqlite3

6 files changed, 11 insertions, 11 deletions

diff --git a/noncore/apps/qashmoney/account.h b/noncore/apps/qashmoney/account.h
index f77f400..5bad4a1 100755
--- a/noncore/apps/qashmoney/account.h
+++ b/noncore/apps/qashmoney/account.h
@@ -1,100 +1,100 @@
 #ifndef ACCOUNT_H
 #define ACCOUNT_H
 
 #include <qstring.h>
 #include <qlistview.h>
 #include <qcombobox.h>
-#include <sqlite.h>
+#include <sqlite3.h>
 
 class Account
   {
     public:
 
       Account ();
       ~Account ();
 
       // This function adds a new account to the database.  It takes the account name, parent,
       // initial balance and the account type, description, credit limit, statementbalancedate
       // as three integers, and the statementbalance amount
       // The parent is an integer account id.  Its -1 if there is no parent
       // The account types (so far)  are 0=not defined 1=parent checking 2=child checking
       void addAccount ( QString, int, float, int, QString, float, int, int, int, float, const char * );
 
       // updates certain parts of an account
       void updateAccount ( QString name, QString description, QString currencycode, int accountid );
 
       void setAccountExpanded ( int expanded, int accountid );
       int getAccountExpanded ( int id );
 
       // Deletes an account
       // Takes the accountid as its parameter
       void deleteAccount ( int );
 
       // Returns the number of accounts
       int getNumberOfAccounts ();
 
       // returns number of child accounts for a given parent
       // this function is useless for child accounts.  It will
       // always return 0
       int getNumberOfChildAccounts ( int );
 
       // This function retrieves all transactions for an account and updates the
       // account balance based on the transactions
       void updateAccountBalance ( int accountid );
       //void changeAccountBalance ( int accountid, float amount );
 
       // updates a parent account
       void changeParentAccountBalance ( int parentid );
 
       // Returns the parent account ID for an account
       // Takes the account name as its parameter or the account id
       int getParentAccountID ( QString accountname );
       int getParentAccountID ( int id );
 
       // This takes a QListView and puts parents and children memorys
       // into the list view
       void displayAccounts ( QListView * );
 
       // This function displays a sorted list of account names in a combobox
       // Takes the combobox address for its parameter
       int displayParentAccountNames ( QComboBox *, QString );
 
       int getAccountType ( int );  // returns account type for given account id
 
       // The next three collectively return a date or balance
       // They take the accountid as their parameters
       int getStatementDay ( int );
       int getStatementMonth ( int );
       int getStatementYear ( int );
       float getStatementBalance ( int );
 
       // Returns account description and name
       QString getAccountDescription ( int accountid );
       QString getCurrencyCode ( int accountid );
       QString getAccountName ( int accountid );
       QStringList getAccountNames ();
       QStringList getAccountIDs ();
       QString getAccountBalance ( int accountid );
 
       // returns account credit limit
       float getAccountCreditLimit ( int );
 
       // The primary database that stores all our data
-      sqlite *adb;
+      sqlite3 *adb;
   };
 
 class GreyBackgroundItem : public QListViewItem
   {
     public:
 
       GreyBackgroundItem ( QListView *parent );
       GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3 );
       GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4 );
       GreyBackgroundItem ( QListView *parent, QString label1, QString label2, QString label3, QString label4, QString label5 );
 
       virtual void paintCell ( QPainter *p, const QColorGroup &cg, int column, int width, int alignment );
 
   };
 
 #endif
 
diff --git a/noncore/apps/qashmoney/budget.h b/noncore/apps/qashmoney/budget.h
index 16af26a..f82e048 100755
--- a/noncore/apps/qashmoney/budget.h
+++ b/noncore/apps/qashmoney/budget.h
@@ -1,45 +1,45 @@
 #ifndef BUDGET_H
 #define BUDGET_H
 
 #include <qstring.h>
 #include <qstringlist.h>
 #include <qlistview.h>
-#include <sqlite.h>
+#include <sqlite3.h>
 
 class Budget
   {
     public:
 
       Budget ();
       ~Budget ();
 
       int addBudget ( QString name, int type, QString description, QString currency, int startday, int startmonth, int startyear, int endday, int endmonth, int endyear, int defaultview );
       void updateBudget ( QString name, QString description, QString currency, int budgetid );
       void deleteBudget ( int budgetid );
       int getNumberOfBudgets ();
       int getNumberOfLineItems ( int budgetid );
 
       QStringList* getBudgetNames ();
       QStringList* getBudgetIDs ();
       QStringList getLineItems ( int budgetid );
       QStringList getLineItemIDs ( int budgetid );
       QString getBudgetName ( int budgetid );
       QString getBudgetDescription ( int budgetid );
       QString getCurrency ( int budgetid );
       QString getBudgetTotal ( int budgetid, int viewtype );
 
       int getLastAdded ();
 
       int addLineItem ( int budgetid, QString lineitemname, float lineitemamount, int lineitemtype );
       void updateLineItem ( QString lineitemname, float lineitemamount, int lineitemtype, int budgetid, int lineitemid );
       void displayLineItems ( int budgetid, QListView *listview, int month, int year, int viewtype );
       void deleteLineItem ( int budgetid, int lineitemid );
       int getLineItemTime ( int budgetid, int lineitemid );
       float getLineItemAmount ( int budgetid, int lineitemid );
 
     private:
-      sqlite *bdb;
+      sqlite3 *bdb;
   };
 
 #endif
 
diff --git a/noncore/apps/qashmoney/memory.h b/noncore/apps/qashmoney/memory.h
index 6f3f100..6e8ae46 100755
--- a/noncore/apps/qashmoney/memory.h
+++ b/noncore/apps/qashmoney/memory.h
@@ -1,45 +1,45 @@
 #ifndef MEMORY_H
 #define MEMORY_H
 
 #include <qstring.h>
 #include <qlistbox.h>
 #include <qcombobox.h>
-#include <sqlite.h>
+#include <sqlite3.h>
 
 class Memory : public QObject
   {
 
     Q_OBJECT
 
     public:
 
       Memory ();
       ~Memory ();
 
       // This function adds a new memory to the database.  It takes the memory name, parent,
       // initial balance, a displayed variable, and the memory type
       // The parent is an integer memory id.  Its -1 if there is not parent
       // The memory types  are 0=not defined 1=parent 2=child
       void addMemoryItem ( QString );
 
       // Returns the number of checking memorys
       int getNumberOfMemoryItems ();
 
       void changeMemoryName ( QString );
 
       // This takes a QListView and puts parents and children memorys
       // into the list view
       void displayMemoryItems ( QListBox * );
       void displayMemoryItems ( QComboBox * );
 
       // The primary database that stores all our data
-      sqlite *db;
+      sqlite3 *db;
 
     public slots:
 
       // Deletes a memory item.  Takes the memoryid as its parameter
       void deleteMemoryItem ( QString );
   };
 
 #endif
 
diff --git a/noncore/apps/qashmoney/preferences.h b/noncore/apps/qashmoney/preferences.h
index 10ec6e9..38579ad 100755
--- a/noncore/apps/qashmoney/preferences.h
+++ b/noncore/apps/qashmoney/preferences.h
@@ -1,53 +1,53 @@
-#include <sqlite.h>
+#include <sqlite3.h>
 #include <qstring.h>
 
 #ifndef PREFERENCES_H
 #define PREFERENCES_H
 
 class Preferences
   {
     public:
       Preferences ();
       ~Preferences ();
 
       void addPreferences ();
       void initializeColumnPreferences ();
       void initializeSortingPreferences ();
 
       // Returns a preference value for the given preferences ID
       int getPreference ( int );
       int getColumnPreference ( int id );
       void getSortingPreference ( int id, int *column, int *direction );
 
       // Convenience for getting date separator with one function
       // call.  Takes the preference id as its argument
       QString getSeparator ( );
 
       //  Changes a preference for the given ID
       void changePreference ( int , int );
       void changeColumnPreference ( int id, int width );
       void changeSortingPreference ( int id, int column );
 
       // The primary database that stores all our data
-      sqlite *db;
+      sqlite3 *db;
 
       // This function returns a Qstring for the year first date formats
       // for displaying.  It takes the date numbers
       QString getDate ( int, int, int );
       QString getDate ( int y, int m );
 
       void setDefaultDatePreferences ();
   };
 
 #endif
 
 
 
 
 
 
 
 
 
 
 
diff --git a/noncore/apps/qashmoney/qashmoney.pro b/noncore/apps/qashmoney/qashmoney.pro
index 4222a25..faa898b 100755
--- a/noncore/apps/qashmoney/qashmoney.pro
+++ b/noncore/apps/qashmoney/qashmoney.pro
@@ -1,55 +1,55 @@
 TEMPLATE = app
 CONFIG = qt warn_on
 HEADERS =   qashmoney.h \
             accountdisplay.h \
                         account.h \
                         transaction.h \
                         transactiondisplay.h \
                         newtransaction.h \
                         transfer.h \
                         transferdialog.h \
                         preferences.h \
                         preferencedialogs.h \
                         memory.h \
                         memorydialog.h \
                         newaccount.h \
                         calculator.h \
                         datepicker.h \
                         budget.h \
                         budgetdisplay.h \
                         currency.h
 SOURCES =   qashmoney.cpp \
             accountdisplay.cpp \
                         account.cpp \
                         transaction.cpp \
                         transactiondisplay.cpp \
                         newtransaction.cpp \
                         transfer.cpp \
                         transferdialog.cpp \
                         preferences.cpp \
                         preferencedialogs.cpp \
                         memory.cpp \
                         memorydialog.cpp \
                         newaccount.cpp \
                         calculator.cpp \
                         datepicker.cpp \
             main.cpp \
                         budget.cpp \
                         budgetdisplay.cpp \
                         currency.cpp
 INCLUDEPATH = $(OPIEDIR)/include
 DEPENDPATH = $(OPIEDIR)/include
 TARGET = qashmoney
 DESTDIR = $(OPIEDIR)/bin
 
 unix:LIBS += -lm
-LIBS += -lqpe -lopiecore2 -lsqlite
+LIBS += -lqpe -lopiecore2 -lsqlite3
 
 include ( $(OPIEDIR)/include.pro )
 
 !isEmpty( LIBSQLITE_INC_DIR ) {
     INCLUDEPATH = $$LIBSQLITE_INC_DIR $$INCLUDEPATH
 }
 !isEmpty( LIBSQLITE_LIB_DIR ) {
     LIBS = -L$$LIBSQLITE_LIB_DIR $$LIBS
 }
diff --git a/noncore/apps/qashmoney/transaction.h b/noncore/apps/qashmoney/transaction.h
index 5871555..3df43a8 100755
--- a/noncore/apps/qashmoney/transaction.h
+++ b/noncore/apps/qashmoney/transaction.h
@@ -1,73 +1,73 @@
 #ifndef TRANSACTION_H
 #define TRANSACTION_H
 
 #include <qstring.h>
 #include <qlistview.h>
 #include <qdatetime.h>
-#include <sqlite.h>
+#include <sqlite3.h>
 
 #include "preferences.h"
 
 class Transaction
   {
     public:
 
       Transaction ();
       ~Transaction ();
 
       // This function adds a new transaction to the database.  It takes the  payee, accountid,
       // budgetid, number, day, month, year, amount, cleared
       void addTransaction ( QString description, QString payee, int accountid, int parentid, int number, int day, int month, int year, float amount, int cleared, int budgetid, int lineitemid );
 
       // This updates an already existing transaction
       void updateTransaction ( QString, QString, int, int, int, int, float, int, int, int, int );
 
       // Deletes a transaction.  Takes the transid as its parameter
       void deleteTransaction ( int );
 
       // Returns the number of transactions
       int getNumberOfTransactions ();
 
       // this is an overloaded function that returns the number of
       // transactions for an account
       int getNumberOfTransactions ( int );
 
       // deletes all transactions for the provided accountid
       void deleteAllTransactions ( int accountid );
 
       QString getBudgetTotal ( int budgetid, int lineitemid, int year, int month, int viewtype );
       QString getActualTotal ( int budgetid, int year, int month, int viewtype );
 
       // These two functions clear budget ids is either a line item or an entire budget is deleted
       void clearBudgetIDs ( int, int );
       void clearBudgetIDs ( int );
 
     public slots:
 
       void displayTransactions ( QListView *, int, bool, const char *, QDate );
       char ** selectAllTransactions ( QDate fromdate, bool children, const char *limit, int id );
       char ** selectNonClearedTransactions ( QDate fromdate, bool children, const char *limit, int id );
       QString getPayee ( int );
       QString getTransactionDescription ( int );
       QString getNumber ( int );
       QString getAmount ( int );
       QString getAbsoluteAmount ( int );
       int getCleared ( int );
       void setCleared ( int id, int cleared );
       int getBudgetID ( int id );
       int getLineItemID ( int id );
       int getDay ( int );
       int getMonth ( int );
       int getYear ( int );
       int getAccountID ( int id );
 
     private:
 
-      sqlite *tdb;
+      sqlite3 *tdb;
       int rows, columns;
   };
 
 #endif