00001 #ifndef SYSIMPORT_KEYS 00002 #define SYSIMPORT_KEYS 00003 00004 #include "read_write_base.hpp" 00005 00006 class SysImport_Keys : public read_write_base 00007 { 00008 public: 00009 string Table_Name; 00010 long long Imported_Id; 00011 long long Current_Id; 00012 string errors; 00013 SysImport_Keys():Imported_Id(0LL),Current_Id(0LL) 00014 { 00015 data_name("SysImport_Keys"); 00016 addDXMap( new llongXfer("Imported_Id", &Imported_Id) ); 00017 addDXMap( new llongXfer("Current_Id", &Current_Id) ); 00018 addDXMap( new stringXfer("Table_Name", &Table_Name) ); 00019 actDerived = true; 00020 } 00021 ~SysImport_Keys(){;} 00022 00023 bool get( string Table_Name, long long Imported_Id ) 00024 { 00025 ocString where = "Table_Name = '"; 00026 where += Table_Name; 00027 where += "' and Imported_Id = "; 00028 where.append(Imported_Id); 00029 return get_data(where); 00030 } 00031 bool get( string Table_Name, string Column_Name, string Column_Ret, string Lookup_Value ) 00032 { 00033 bool ret = false; 00034 ocString where = "select "; 00035 where += Column_Ret; 00036 where += " from "; 00037 where += Table_Name; 00038 where += " where "; 00039 where += Column_Name; 00040 where += " ='"; 00041 where += Lookup_Value; 00042 where += "'"; 00043 ret = rs.open(where); 00044 if( ret ) 00045 { 00046 Current_Id = atoll( rs.getField(0).format().c_str() ); 00047 rs.close(); 00048 } 00049 else 00050 { 00051 errors = "Open Error! SQL: "; 00052 errors += where; 00053 errors += " message: "; 00054 errors += rs.getErrors(); 00055 } 00056 return ret; 00057 } 00058 bool insert( void ) 00059 { 00060 return db_insert(); 00061 } 00062 }; 00063 00064 #endif
1.5.5