include/CacheTableLoader.h

   1 /***************************************************************************
   2  *   Copyright (C) 2007 by www.databasecache.com                           *
   3  *   Contact: praba_tuty@databasecache.com                                 *
   4  *                                                                         *
   5  *   This program is free software; you can redistribute it and/or modify  *
   6  *   it under the terms of the GNU General Public License as published by  *
   7  *   the Free Software Foundation; either version 2 of the License, or     *
   8  *   (at your option) any later version.                                   *
   9  *                                                                         *
  10  *   This program is distributed in the hope that it will be useful,       *
  11  *   but WITHOUT ANY WARRANTY; without even the implied warranty of        *
  12  *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *
  13  *   GNU General Public License for more details.                          *
  14  *                                                                         *
  15   ***************************************************************************/
  16 #include <CSql.h>
  17 #include <sql.h>
  18 #include <sqlext.h>
  19 #include <Network.h>
  20
  21 class CacheTableLoader
  22 {
  23     char tableName[IDENTIFIER_LENGTH];
  24     char userName[IDENTIFIER_LENGTH];
  25     char password[IDENTIFIER_LENGTH];
  26
  27     DataSyncMode syncMode;
  28
  29     public:
  30     CacheTableLoader(){strcpy(tableName,"");}
  31     void setConnParam(char *user, char *pass){ strcpy(userName, user); strcpy(password, pass); }
  32     void setTable(char *tablename) { strcpy(tableName,tablename); }
  33     void setSyncMode(DataSyncMode  mode) { syncMode = mode; }
  34     DbRetVal addToCacheTableFile();
  35     DbRetVal removeFromCacheTableFile();
  36     DbRetVal load(bool tabDef=true);
  37     DbRetVal reload();
  38     DbRetVal unload(bool tabDefinition = true);
  39     DbRetVal refresh();
  40     DbRetVal recoverAllCachedTables();
  41
  42
  43
  44     DbRetVal load(DatabaseManager *dbMgr, bool tabDef);
  45
  46
  47 };
  48
  49 class BindBuffer
  50 {
  51     public:
  52     void *csql;
  53     void *targetdb;
  54     DataType type;
  55 };
  56