Menu
▾
▴
[Moneymanagerex-commits] SF.net SVN: moneymanagerex:[2140] branches/lua_integration/mmex/src
|
From: <gua...@us...> - 2012-04-11 06:14:55
|
Revision: 2140
http://moneymanagerex.svn.sourceforge.net/moneymanagerex/?rev=2140&view=rev
Author: guanlisheng
Date: 2012-04-11 06:14:45 +0000 (Wed, 11 Apr 2012)
Log Message:
-----------
more api
Modified Paths:
--------------
branches/lua_integration/mmex/src/mmex_db_view.h
branches/lua_integration/mmex/src/utils/mmex.py
Modified: branches/lua_integration/mmex/src/mmex_db_view.h
===================================================================
--- branches/lua_integration/mmex/src/mmex_db_view.h 2012-04-11 03:53:16 UTC (rev 2139)
+++ branches/lua_integration/mmex/src/mmex_db_view.h 2012-04-11 06:14:45 UTC (rev 2140)
@@ -10,7 +10,7 @@
* @brief
*
* Revision History:
- * AUTO GENERATED at 2012-04-10 10:35:26.316000.
+ * AUTO GENERATED at 2012-04-11 14:13:16.128342.
* DO NOT EDIT!
*/
//=============================================================================
@@ -58,7 +58,7 @@
int id() const { return ACCOUNTID; }
void id(int id) { ACCOUNTID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -88,19 +88,85 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ ACCOUNTID = 0
+ , ACCOUNTNAME = 1
+ , ACCOUNTTYPE = 2
+ , ACCOUNTNUM = 3
+ , STATUS = 4
+ , NOTES = 5
+ , HELDAT = 6
+ , WEBSITE = 7
+ , CONTACTINFO = 8
+ , ACCESSINFO = 9
+ , INITIALBAL = 10
+ , FAVORITEACCT = 11
+ , CURRENCYID = 12
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case ACCOUNTID: return wxT("ACCOUNTID");
+ case ACCOUNTNAME: return wxT("ACCOUNTNAME");
+ case ACCOUNTTYPE: return wxT("ACCOUNTTYPE");
+ case ACCOUNTNUM: return wxT("ACCOUNTNUM");
+ case STATUS: return wxT("STATUS");
+ case NOTES: return wxT("NOTES");
+ case HELDAT: return wxT("HELDAT");
+ case WEBSITE: return wxT("WEBSITE");
+ case CONTACTINFO: return wxT("CONTACTINFO");
+ case ACCESSINFO: return wxT("ACCESSINFO");
+ case INITIALBAL: return wxT("INITIALBAL");
+ case FAVORITEACCT: return wxT("FAVORITEACCT");
+ case CURRENCYID: return wxT("CURRENCYID");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("ACCOUNTID") == name) return ACCOUNTID;
+ else if (wxT("ACCOUNTNAME") == name) return ACCOUNTNAME;
+ else if (wxT("ACCOUNTTYPE") == name) return ACCOUNTTYPE;
+ else if (wxT("ACCOUNTNUM") == name) return ACCOUNTNUM;
+ else if (wxT("STATUS") == name) return STATUS;
+ else if (wxT("NOTES") == name) return NOTES;
+ else if (wxT("HELDAT") == name) return HELDAT;
+ else if (wxT("WEBSITE") == name) return WEBSITE;
+ else if (wxT("CONTACTINFO") == name) return CONTACTINFO;
+ else if (wxT("ACCESSINFO") == name) return ACCESSINFO;
+ else if (wxT("INITIALBAL") == name) return INITIALBAL;
+ else if (wxT("FAVORITEACCT") == name) return FAVORITEACCT;
+ else if (wxT("CURRENCYID") == name) return CURRENCYID;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 13
@@ -263,7 +329,7 @@
int id() const { return ASSETID; }
void id(int id) { ASSETID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -288,19 +354,70 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ ASSETID = 0
+ , STARTDATE = 1
+ , ASSETNAME = 2
+ , VALUE = 3
+ , VALUECHANGE = 4
+ , NOTES = 5
+ , VALUECHANGERATE = 6
+ , ASSETTYPE = 7
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case ASSETID: return wxT("ASSETID");
+ case STARTDATE: return wxT("STARTDATE");
+ case ASSETNAME: return wxT("ASSETNAME");
+ case VALUE: return wxT("VALUE");
+ case VALUECHANGE: return wxT("VALUECHANGE");
+ case NOTES: return wxT("NOTES");
+ case VALUECHANGERATE: return wxT("VALUECHANGERATE");
+ case ASSETTYPE: return wxT("ASSETTYPE");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("ASSETID") == name) return ASSETID;
+ else if (wxT("STARTDATE") == name) return STARTDATE;
+ else if (wxT("ASSETNAME") == name) return ASSETNAME;
+ else if (wxT("VALUE") == name) return VALUE;
+ else if (wxT("VALUECHANGE") == name) return VALUECHANGE;
+ else if (wxT("NOTES") == name) return NOTES;
+ else if (wxT("VALUECHANGERATE") == name) return VALUECHANGERATE;
+ else if (wxT("ASSETTYPE") == name) return ASSETTYPE;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 8
@@ -467,7 +584,7 @@
int id() const { return BDID; }
void id(int id) { BDID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -509,19 +626,97 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ BDID = 0
+ , ACCOUNTID = 1
+ , TOACCOUNTID = 2
+ , PAYEEID = 3
+ , TRANSCODE = 4
+ , TRANSAMOUNT = 5
+ , STATUS = 6
+ , TRANSACTIONNUMBER = 7
+ , NOTES = 8
+ , CATEGID = 9
+ , SUBCATEGID = 10
+ , TRANSDATE = 11
+ , FOLLOWUPID = 12
+ , TOTRANSAMOUNT = 13
+ , REPEATS = 14
+ , NEXTOCCURRENCEDATE = 15
+ , NUMOCCURRENCES = 16
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case BDID: return wxT("BDID");
+ case ACCOUNTID: return wxT("ACCOUNTID");
+ case TOACCOUNTID: return wxT("TOACCOUNTID");
+ case PAYEEID: return wxT("PAYEEID");
+ case TRANSCODE: return wxT("TRANSCODE");
+ case TRANSAMOUNT: return wxT("TRANSAMOUNT");
+ case STATUS: return wxT("STATUS");
+ case TRANSACTIONNUMBER: return wxT("TRANSACTIONNUMBER");
+ case NOTES: return wxT("NOTES");
+ case CATEGID: return wxT("CATEGID");
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ case TRANSDATE: return wxT("TRANSDATE");
+ case FOLLOWUPID: return wxT("FOLLOWUPID");
+ case TOTRANSAMOUNT: return wxT("TOTRANSAMOUNT");
+ case REPEATS: return wxT("REPEATS");
+ case NEXTOCCURRENCEDATE: return wxT("NEXTOCCURRENCEDATE");
+ case NUMOCCURRENCES: return wxT("NUMOCCURRENCES");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("BDID") == name) return BDID;
+ else if (wxT("ACCOUNTID") == name) return ACCOUNTID;
+ else if (wxT("TOACCOUNTID") == name) return TOACCOUNTID;
+ else if (wxT("PAYEEID") == name) return PAYEEID;
+ else if (wxT("TRANSCODE") == name) return TRANSCODE;
+ else if (wxT("TRANSAMOUNT") == name) return TRANSAMOUNT;
+ else if (wxT("STATUS") == name) return STATUS;
+ else if (wxT("TRANSACTIONNUMBER") == name) return TRANSACTIONNUMBER;
+ else if (wxT("NOTES") == name) return NOTES;
+ else if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+ else if (wxT("TRANSDATE") == name) return TRANSDATE;
+ else if (wxT("FOLLOWUPID") == name) return FOLLOWUPID;
+ else if (wxT("TOTRANSAMOUNT") == name) return TOTRANSAMOUNT;
+ else if (wxT("REPEATS") == name) return REPEATS;
+ else if (wxT("NEXTOCCURRENCEDATE") == name) return NEXTOCCURRENCEDATE;
+ else if (wxT("NUMOCCURRENCES") == name) return NUMOCCURRENCES;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 17
@@ -685,7 +880,7 @@
int id() const { return SPLITTRANSID; }
void id(int id) { SPLITTRANSID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -709,19 +904,61 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ SPLITTRANSID = 0
+ , TRANSID = 1
+ , CATEGID = 2
+ , SUBCATEGID = 3
+ , SPLITTRANSAMOUNT = 4
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case SPLITTRANSID: return wxT("SPLITTRANSID");
+ case TRANSID: return wxT("TRANSID");
+ case CATEGID: return wxT("CATEGID");
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ case SPLITTRANSAMOUNT: return wxT("SPLITTRANSAMOUNT");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("SPLITTRANSID") == name) return SPLITTRANSID;
+ else if (wxT("TRANSID") == name) return TRANSID;
+ else if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+ else if (wxT("SPLITTRANSAMOUNT") == name) return SPLITTRANSAMOUNT;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 5
@@ -874,7 +1111,7 @@
int id() const { return BUDGETENTRYID; }
void id(int id) { BUDGETENTRYID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -899,19 +1136,64 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ BUDGETENTRYID = 0
+ , BUDGETYEARID = 1
+ , CATEGID = 2
+ , SUBCATEGID = 3
+ , PERIOD = 4
+ , AMOUNT = 5
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case BUDGETENTRYID: return wxT("BUDGETENTRYID");
+ case BUDGETYEARID: return wxT("BUDGETYEARID");
+ case CATEGID: return wxT("CATEGID");
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ case PERIOD: return wxT("PERIOD");
+ case AMOUNT: return wxT("AMOUNT");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("BUDGETENTRYID") == name) return BUDGETENTRYID;
+ else if (wxT("BUDGETYEARID") == name) return BUDGETYEARID;
+ else if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+ else if (wxT("PERIOD") == name) return PERIOD;
+ else if (wxT("AMOUNT") == name) return AMOUNT;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 6
@@ -1061,7 +1343,7 @@
int id() const { return BUDGETYEARID; }
void id(int id) { BUDGETYEARID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -1078,19 +1360,52 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ BUDGETYEARID = 0
+ , BUDGETYEARNAME = 1
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case BUDGETYEARID: return wxT("BUDGETYEARID");
+ case BUDGETYEARNAME: return wxT("BUDGETYEARNAME");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("BUDGETYEARID") == name) return BUDGETYEARID;
+ else if (wxT("BUDGETYEARNAME") == name) return BUDGETYEARNAME;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 2
@@ -1236,7 +1551,7 @@
int id() const { return CATEGID; }
void id(int id) { CATEGID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -1253,19 +1568,52 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ CATEGID = 0
+ , CATEGNAME = 1
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case CATEGID: return wxT("CATEGID");
+ case CATEGNAME: return wxT("CATEGNAME");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("CATEGNAME") == name) return CATEGNAME;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 2
@@ -1423,7 +1771,7 @@
int id() const { return TRANSID; }
void id(int id) { TRANSID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -1460,19 +1808,88 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ TRANSID = 0
+ , ACCOUNTID = 1
+ , TOACCOUNTID = 2
+ , PAYEEID = 3
+ , TRANSCODE = 4
+ , TRANSAMOUNT = 5
+ , STATUS = 6
+ , TRANSACTIONNUMBER = 7
+ , NOTES = 8
+ , CATEGID = 9
+ , SUBCATEGID = 10
+ , TRANSDATE = 11
+ , FOLLOWUPID = 12
+ , TOTRANSAMOUNT = 13
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case TRANSID: return wxT("TRANSID");
+ case ACCOUNTID: return wxT("ACCOUNTID");
+ case TOACCOUNTID: return wxT("TOACCOUNTID");
+ case PAYEEID: return wxT("PAYEEID");
+ case TRANSCODE: return wxT("TRANSCODE");
+ case TRANSAMOUNT: return wxT("TRANSAMOUNT");
+ case STATUS: return wxT("STATUS");
+ case TRANSACTIONNUMBER: return wxT("TRANSACTIONNUMBER");
+ case NOTES: return wxT("NOTES");
+ case CATEGID: return wxT("CATEGID");
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ case TRANSDATE: return wxT("TRANSDATE");
+ case FOLLOWUPID: return wxT("FOLLOWUPID");
+ case TOTRANSAMOUNT: return wxT("TOTRANSAMOUNT");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("TRANSID") == name) return TRANSID;
+ else if (wxT("ACCOUNTID") == name) return ACCOUNTID;
+ else if (wxT("TOACCOUNTID") == name) return TOACCOUNTID;
+ else if (wxT("PAYEEID") == name) return PAYEEID;
+ else if (wxT("TRANSCODE") == name) return TRANSCODE;
+ else if (wxT("TRANSAMOUNT") == name) return TRANSAMOUNT;
+ else if (wxT("STATUS") == name) return STATUS;
+ else if (wxT("TRANSACTIONNUMBER") == name) return TRANSACTIONNUMBER;
+ else if (wxT("NOTES") == name) return NOTES;
+ else if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+ else if (wxT("TRANSDATE") == name) return TRANSDATE;
+ else if (wxT("FOLLOWUPID") == name) return FOLLOWUPID;
+ else if (wxT("TOTRANSAMOUNT") == name) return TOTRANSAMOUNT;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 14
@@ -1639,7 +2056,7 @@
int id() const { return CURRENCYID; }
void id(int id) { CURRENCYID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -1667,19 +2084,79 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ CURRENCYID = 0
+ , CURRENCYNAME = 1
+ , PFX_SYMBOL = 2
+ , SFX_SYMBOL = 3
+ , DECIMAL_POINT = 4
+ , GROUP_SEPARATOR = 5
+ , UNIT_NAME = 6
+ , CENT_NAME = 7
+ , SCALE = 8
+ , BASECONVRATE = 9
+ , CURRENCY_SYMBOL = 10
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case CURRENCYID: return wxT("CURRENCYID");
+ case CURRENCYNAME: return wxT("CURRENCYNAME");
+ case PFX_SYMBOL: return wxT("PFX_SYMBOL");
+ case SFX_SYMBOL: return wxT("SFX_SYMBOL");
+ case DECIMAL_POINT: return wxT("DECIMAL_POINT");
+ case GROUP_SEPARATOR: return wxT("GROUP_SEPARATOR");
+ case UNIT_NAME: return wxT("UNIT_NAME");
+ case CENT_NAME: return wxT("CENT_NAME");
+ case SCALE: return wxT("SCALE");
+ case BASECONVRATE: return wxT("BASECONVRATE");
+ case CURRENCY_SYMBOL: return wxT("CURRENCY_SYMBOL");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("CURRENCYID") == name) return CURRENCYID;
+ else if (wxT("CURRENCYNAME") == name) return CURRENCYNAME;
+ else if (wxT("PFX_SYMBOL") == name) return PFX_SYMBOL;
+ else if (wxT("SFX_SYMBOL") == name) return SFX_SYMBOL;
+ else if (wxT("DECIMAL_POINT") == name) return DECIMAL_POINT;
+ else if (wxT("GROUP_SEPARATOR") == name) return GROUP_SEPARATOR;
+ else if (wxT("UNIT_NAME") == name) return UNIT_NAME;
+ else if (wxT("CENT_NAME") == name) return CENT_NAME;
+ else if (wxT("SCALE") == name) return SCALE;
+ else if (wxT("BASECONVRATE") == name) return BASECONVRATE;
+ else if (wxT("CURRENCY_SYMBOL") == name) return CURRENCY_SYMBOL;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 11
@@ -1835,7 +2312,7 @@
int id() const { return INFOID; }
void id(int id) { INFOID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -1853,19 +2330,55 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ INFOID = 0
+ , INFONAME = 1
+ , INFOVALUE = 2
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case INFOID: return wxT("INFOID");
+ case INFONAME: return wxT("INFONAME");
+ case INFOVALUE: return wxT("INFOVALUE");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("INFOID") == name) return INFOID;
+ else if (wxT("INFONAME") == name) return INFONAME;
+ else if (wxT("INFOVALUE") == name) return INFOVALUE;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 3
@@ -2014,7 +2527,7 @@
int id() const { return PAYEEID; }
void id(int id) { PAYEEID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -2035,19 +2548,58 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ PAYEEID = 0
+ , PAYEENAME = 1
+ , CATEGID = 2
+ , SUBCATEGID = 3
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case PAYEEID: return wxT("PAYEEID");
+ case PAYEENAME: return wxT("PAYEENAME");
+ case CATEGID: return wxT("CATEGID");
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("PAYEEID") == name) return PAYEEID;
+ else if (wxT("PAYEENAME") == name) return PAYEENAME;
+ else if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 4
@@ -2198,7 +2750,7 @@
int id() const { return SPLITTRANSID; }
void id(int id) { SPLITTRANSID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -2222,19 +2774,61 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ SPLITTRANSID = 0
+ , TRANSID = 1
+ , CATEGID = 2
+ , SUBCATEGID = 3
+ , SPLITTRANSAMOUNT = 4
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case SPLITTRANSID: return wxT("SPLITTRANSID");
+ case TRANSID: return wxT("TRANSID");
+ case CATEGID: return wxT("CATEGID");
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ case SPLITTRANSAMOUNT: return wxT("SPLITTRANSAMOUNT");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("SPLITTRANSID") == name) return SPLITTRANSID;
+ else if (wxT("TRANSID") == name) return TRANSID;
+ else if (wxT("CATEGID") == name) return CATEGID;
+ else if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+ else if (wxT("SPLITTRANSAMOUNT") == name) return SPLITTRANSAMOUNT;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 5
@@ -2392,7 +2986,7 @@
int id() const { return STOCKID; }
void id(int id) { STOCKID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -2424,19 +3018,79 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ STOCKID = 0
+ , HELDAT = 1
+ , PURCHASEDATE = 2
+ , STOCKNAME = 3
+ , SYMBOL = 4
+ , NUMSHARES = 5
+ , PURCHASEPRICE = 6
+ , NOTES = 7
+ , CURRENTPRICE = 8
+ , VALUE = 9
+ , COMMISSION = 10
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case STOCKID: return wxT("STOCKID");
+ case HELDAT: return wxT("HELDAT");
+ case PURCHASEDATE: return wxT("PURCHASEDATE");
+ case STOCKNAME: return wxT("STOCKNAME");
+ case SYMBOL: return wxT("SYMBOL");
+ case NUMSHARES: return wxT("NUMSHARES");
+ case PURCHASEPRICE: return wxT("PURCHASEPRICE");
+ case NOTES: return wxT("NOTES");
+ case CURRENTPRICE: return wxT("CURRENTPRICE");
+ case VALUE: return wxT("VALUE");
+ case COMMISSION: return wxT("COMMISSION");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("STOCKID") == name) return STOCKID;
+ else if (wxT("HELDAT") == name) return HELDAT;
+ else if (wxT("PURCHASEDATE") == name) return PURCHASEDATE;
+ else if (wxT("STOCKNAME") == name) return STOCKNAME;
+ else if (wxT("SYMBOL") == name) return SYMBOL;
+ else if (wxT("NUMSHARES") == name) return NUMSHARES;
+ else if (wxT("PURCHASEPRICE") == name) return PURCHASEPRICE;
+ else if (wxT("NOTES") == name) return NOTES;
+ else if (wxT("CURRENTPRICE") == name) return CURRENTPRICE;
+ else if (wxT("VALUE") == name) return VALUE;
+ else if (wxT("COMMISSION") == name) return COMMISSION;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 11
@@ -2592,7 +3246,7 @@
int id() const { return SUBCATEGID; }
void id(int id) { SUBCATEGID = id; }
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
@@ -2611,19 +3265,55 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
+ enum COLUMN
+ {
+ SUBCATEGID = 0
+ , SUBCATEGNAME = 1
+ , CATEGID = 2
+ };
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case SUBCATEGID: return wxT("SUBCATEGID");
+ case SUBCATEGNAME: return wxT("SUBCATEGNAME");
+ case CATEGID: return wxT("CATEGID");
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("SUBCATEGID") == name) return SUBCATEGID;
+ else if (wxT("SUBCATEGNAME") == name) return SUBCATEGNAME;
+ else if (wxT("CATEGID") == name) return CATEGID;
+
+ return COLUMN(-1);
+ }
+
enum
{
NUM_COLUMNS = 3
Modified: branches/lua_integration/mmex/src/utils/mmex.py
===================================================================
--- branches/lua_integration/mmex/src/utils/mmex.py 2012-04-11 03:53:16 UTC (rev 2139)
+++ branches/lua_integration/mmex/src/utils/mmex.py 2012-04-11 06:14:45 UTC (rev 2140)
@@ -70,7 +70,7 @@
''' % (primay_key, primay_key)
s += '''
- Data(Self* view)
+ Data(Self* view = 0)
{
view_ = view;
'''
@@ -104,21 +104,72 @@
bool save(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not save"));
+ return false;
+ }
return view_->save(this, db);
}
bool remove(wxSQLite3Database* db)
{
- if (! view_ || !db) return false;
+ if (! view_ || !db)
+ {
+ wxLogError(wxT("can not remove"));
+ return false;
+ }
return view_->remove(this, db);
}
};
'''
-
s += '''
+ enum COLUMN
+ {
+ %s = 0''' % primay_key
+
+ for index, name in enumerate([field['name'] for field in self._fields if not field['pk']]):
+ s += '''
+ , %s = %d''' % (name.upper(), index +1)
+
+ s +='''
+ };'''
+
+ s +='''
+ wxString column_to_name(COLUMN col) const
+ {
+ switch(col)
+ {
+ case %s: return wxT("%s");''' % (primay_key.upper(), primay_key)
+
+ for index, name in enumerate([field['name'] for field in self._fields if not field['pk']]):
+ s += '''
+ case %s: return wxT("%s");''' %(name.upper(), name)
+ s +='''
+ default: break;
+ }
+
+ return wxT("UNKNOWN");
+ }
+ '''
+ s +='''
+ COLUMN name_to_column(const wxString& name) const
+ {
+ if (wxT("%s") == name) return %s;''' % (primay_key, primay_key.upper())
+
+ for index, name in enumerate([field['name'] for field in self._fields if not field['pk']]):
+ s += '''
+ else if (wxT("%s") == name) return %s;''' %(name, name.upper())
+
+ s += '''
+
+ return COLUMN(-1);
+ }
+ '''
+
+ s +='''
enum
{
NUM_COLUMNS = %d
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|