コード例 #1
0
void CCReCalQ::OnRecaleCal() 
{ 
	GetParamFromDlg();
	m_RDB.ReCalculateQ();	 
	UpWindowsText();
	UpdateDB();
}
コード例 #2
0
bool DataSearchConfig::TestConnectivity()
{
    bool succes=false;

    if(!VerifyValues())
        return false;

    UpdateDB();
    bool dbOpen = mDataBase.open();

    qDebug() << mSQLdriverName
            << mHostName
            << mDataBaseName
            << mUserName
            << mPassWord;

    if(dbOpen)
    {
//        QMessageBox::information(this,
//                                     tr("Succes...!"),
//                                     tr("Database succesfully opened."));

        qDebug() << "Tables :" << mDataBase.tables();

        if(mDataBase.tables().contains(mTableName,Qt::CaseInsensitive))
        {
            QMessageBox::information(this,
                                         tr("Table Exists"),
                                         tr("Table '%0' exists in database '%1'")
                                                    .arg(mTableName)
                                                    .arg(mDataBaseName));
            succes = true;
        }
        else
        {
            QMessageBox::critical(this,
                                  tr("Table not found..!"),
                                  tr("Table %0 not found in database %1\n Please create a table using 'Table' tab..!")
                                        .arg(mTableName)
                                        .arg(mDataBaseName));
        }
    }
    else
    {
        QMessageBox::critical(this,
                              tr("Database opening failed..!"),
                              tr("Error :%0\n Please create a proper database first..!").arg(mDataBase.lastError().text()));
    }

    if(mDataBase.isOpen())
        mDataBase.close();



    return succes;
}
コード例 #3
0
bool DataSearchConfig::RunSqlQuery(QString query)
{
    bool succes=false;
    UpdateDB();
    if(mDataBase.open())
    {
        mDataBase.exec(query);
        if(mDataBase.lastError().isValid())
        {
            QMessageBox::critical(this,
                                  tr("Error in sql query"),
                                  tr("Could not excecute sql query..!"));
        }
        else
            succes = true;
    }
    return succes;
}
コード例 #4
0
void DataSearchConfig::on_btn_RefeshTableList_clicked()
{
    ui->lst_Tables->clear();
    UpdateDB();
    if(mDataBase.open())
    {
        ui->lst_Tables->addItems(mDataBase.tables());
    }
    else
    {
        QMessageBox::critical(this,
                              tr("Error"),
                              tr("Could not open database"));
    }

    if(mDataBase.isOpen())
        mDataBase.close();
}
コード例 #5
0
ファイル: app_temp.c プロジェクト: loversmile/mytest
int main(int argc, char *argv[])
{
	int err = 0;
	char path[] = "database.sqlite3";
	sqlite3 * db;
	err = sqlite3_open(path, &db);
	if(SQLITE_OK != err)
	{
		return -1;
	}
	SelectDB(db, "select str from xx");
	InsertDB(db, "insert  or replace into xx values ('007','kkk','5pp')");
	UpdateDB(db, "update xx set str='007' where sss='lll'");
	DeleteDB(db, "delete from xx where str='789'");
	printf("----------!!----------\n");
	OperateDB(db, "create table if not exists nimei(woqu TEXT)");
	SelectDB(db, "select * from xx");

	return 0;
}
コード例 #6
0
ファイル: unwind.c プロジェクト: chutzimir/coda
static void GetFilesAndSpool()
// GFTS assumes we are cd'd into the WorkingDir (main does this)
{
    struct direct **nameList;
    int numfiles = scandir(".",&(nameList),
			   (PFI)ScreenForData,NULL);
    if (numfiles <= 1) {
	LogMsg(0,LogLevel,LogFile,"No data to spool in directory %s",WorkingDir);
	return;
    }
    LogMsg(100,LogLevel,LogFile,"GFAS: Found %d data files",numfiles);
    time_t longest = 0;
    int longestIndex;
    struct stat buf;
    int i;
    for (i = 0; i<numfiles; i++)
    {
	stat(nameList[i]->d_name,&buf);
	if (buf.st_mtime == longest) {
	    LogMsg(0,LogLevel,LogFile,
		   "Two (or more) data files with the same mtime - CYa!");
	    return;
	}
	if (buf.st_mtime > longest) {
	    longest = buf.st_mtime;
	    longestIndex = i;
	}
    }
    LogMsg(10,LogLevel,LogFile,"GFAS: Least recent file: %s",
	nameList[longestIndex]->d_name);
    for (i=0; i<numfiles; i++)
    {
	if (i != longestIndex)
	{
	    LogMsg(10,LogLevel,LogFile,"GFAS: Sending %s",nameList[i]->d_name);
	    SendData(nameList[i]->d_name);
	}
    }
    UpdateDB();
}
コード例 #7
0
void DataSearchConfig::on_btnImportCSV_clicked()
{
    on_btnTestConnectivity_clicked();
    UpdateDB();
    if(!mDataBase.isOpen())
        mDataBase.open();

    if(mDataBase.isOpen())
    {
        QSqlTableModel TableModel(this,mDataBase);
        TableModel.setTable(mTableName);
        TableModel.setEditStrategy(QSqlTableModel::OnManualSubmit);
        TableModel.select();
        CSVimportDialog CSVImpDialog(&TableModel,this);
        if(CSVImpDialog.exec())
        {

        }

        mDataBase.close();
    }
}
コード例 #8
0
ファイル: HTTPClient.cpp プロジェクト: devmario/http_cpp
bool HTTPClient::Run(void* _ptr) {
	if(_ptr) {
		is_raise_error_multi_handle = true;
		code_multi = *(CURLMcode*)_ptr;
		return true;
	}
	if(is_raise_error_multi_handle)
		return true;
	
	if(is_recieve) {
		UpdateDB();
		return true;
	} else {
		if(cache_type == HTTPResponse::CacheType_Expires) {
			code = CURLE_OK;
			response = HTTPResponse(cache_header_file_path, cache_body_file_path, cache_type);
			is_use_cache = true;
			return true;
		} else if(cache_type == HTTPResponse::CacheType_Last_Modified) {
			if(db_last_modified && last_modified) {
				if(last_modified == db_last_modified) {
					code = CURLE_OK;
					response = HTTPResponse(cache_header_file_path, cache_body_file_path, cache_type);
					is_use_cache = true;
					return true;
				} else {
					return false;
				}
			} else {
				return false;
			}
		} else {
			return false;
		}
	}
}
コード例 #9
0
ファイル: app_interfacesql.c プロジェクト: loversmile/mytest
int main(int argc, char *argv[])
{
	int err = 0;
	char path[] = "database.sqlite3";
	sqlite3 * db;
	err = sqlite3_open(path, &db);
	if(SQLITE_OK != err)
	{
		return -1;
	}
	UpdateDB(db, "select str from xx");
	UpdateDB(db, "insert into xx values ('789','kkk','pop')");
//	UpdateDB(db, "update xx set str='007' where sss='lll'");
	UpdateDB(db, "delete from xx where str='789'");
	printf("----------!!----------\n");
	UpdateDB(db, "create table nimei(woqu TEXT)");
	UpdateDB(db, "select * from xx");
	UpdateDB(db, "select * from tt");

	return 0;
}
コード例 #10
0
ファイル: Main.cpp プロジェクト: Mateuus/devsrc
void game::MainLoop()
{
	// init steam we need to initialize this before the renderer for the overlay.
	{
		gSteam.InitSteam();
		if(gSteam.steamID) {
			gUserProfile.RegisterSteamCallbacks();
		}
	}


	InitRender(1);

	CurRenderPipeline = new r3dDefferedRenderer;
	CurRenderPipeline->Init();

	SetFocus(win::hWnd);

	r3dMenuInit();

	r3dParticleSystemInit();

	InitDesktopSystem();

	InitPostFX();
	InitPointLightsRendererV2();

	g_pWind = new r3dWind ;

	g_pEngineConsole = new EngineConsole;
	g_pDefaultConsole = g_pEngineConsole;
	g_pEngineConsole->Init();
	g_pEngineConsole->SetCommandProcessor( g_pCmdProc );

	g_DamageLib = new DamageLib ;
	g_DamageLib->Load();

	g_MeshPropertyLib = new MeshPropertyLib;

#ifndef FINAL_BUILD
	g_Manipulator3d.Init();

	// show non-level specific art bugs
	r3dShowArtBugs() ;
#endif

	g_cursor_mode->SetChangeCallback( &CursorModeCallback ) ;

	_r3d_bTerminateOnZ = r_terminateOnZ->GetInt();

	// set dynamic matlib by default.
	// make it statis only in GAME mode
	r3dMaterialLibrary::IsDynamic = true;

	imgui_SetFixMouseCoords( false );


#ifdef FINAL_BUILD
	int m_ret = Menu_AppSelect::bStartGamePublic; // start game
#else
	int m_ret = 0;
	if ( *d_map_force_load->GetString() || LevelEditName[0]!='\0' )
		m_ret = Menu_AppSelect::bStartLevelEditor;
	else
		CALL_MENU(Menu_AppSelect);
#endif

#ifndef FINAL_BUILD
	// all choises is editors by default
	g_bEditMode = true;
	g_bStartedAsParticleEditor = false;
#endif

	void InitGrass();
	InitGrass();

	g_pHUDCameraEffects = new HUDCameraEffects ;

	r3d_assert(g_pWeaponArmory == NULL);
	g_pWeaponArmory = new ClientWeaponArmory();
	g_pWeaponArmory->Init();
	r3dShowArtBugs();

	// for editors, do not lock mouse. when we start game, in ExecuteNetworkGame we will set that var to true
	d_mouse_window_lock->SetBool(false);

	switch (m_ret)
	{
#ifndef FINAL_BUILD
	case Menu_AppSelect::bUpdateDB:
		g_bEditMode = false;
		UpdateDB("198.50.211.32", "Data/Weapons/itemsDB.xml");
		MessageBox(0, "Successfully updated English DB!", "Result", MB_OK);
		break;
	case Menu_AppSelect::bStartLevelEditor:
		g_pVisibilityGrid = new VisibiltyGrid ;
		ExecuteLevelEditor();
		break;

	case Menu_AppSelect::bStartParticleEditor:
		g_bStartedAsParticleEditor = true;
		ExecuteParticleEditor();
		break;
	case Menu_AppSelect::bStartPhysicsEditor:
		ExecutePhysicsEditor();
		break;
	case Menu_AppSelect::bStartCharacterEditor:
		ExecuteCharacterEditor();
		break;
#endif
	case Menu_AppSelect::bStartGamePublic:
		// override server settings if special key isn't set
		if(strstr(__r3dCmdLine, "-ffgrtvzdf") == NULL)
		{
			// hardcoded IP for now
			//g_serverip->SetString("127.0.0.1");
		}

		// override API settings
		g_api_ip->SetString("198.50.211.32"); // external
		g_serverip->SetString("198.50.211.32"); // external
		g_bEditMode = false;
		ExecuteNetworkGame();
		break;
	};

#ifndef FINAL_BUILD
	if( g_bEditMode )
	{
		SAFE_DELETE( g_pVisibilityGrid );
	}
#endif

	// shutdown steam
	if(gSteam.inited_) {
		gUserProfile.DeregisterSteamCallbacks();
		gSteam.Shutdown();
	}

	SAFE_DELETE( g_pWind ) ;

	r3dMaterialLibrary::UnloadManaged();
	r3dMaterialLibrary::Reset();	
	MeshGlobalBuffer::unloadManaged();

	g_pWeaponArmory->Destroy();
	SAFE_DELETE(g_pWeaponArmory);

#ifndef FINAL_BUILD
	g_Manipulator3d.Close();
#endif

	r3dMenuClose();

	AI_Player_FreeStuff();

	SAFE_DELETE( g_pHUDCameraEffects ) ;

	SAFE_DELETE( g_GameRewards );

	void CloseGrass();
	CloseGrass();

	DestroyPointLightsRendererV2();

	ClosePostFX();

	SAFE_DELETE( g_DamageLib );
	SAFE_DELETE( g_MeshPropertyLib );

	r3dFreeGOBMeshes();

	obj_Zombie::FreePhysSkeletonCache();

	g_pEngineConsole->Release();
	SAFE_DELETE( g_pEngineConsole );

	g_pDefaultConsole = NULL;

	ReleaseDesktopSystem();

	DoneDrawCollections();

	r3dParticleSystemClose();
	CurRenderPipeline->Close();
	SAFE_DELETE(CurRenderPipeline);

	r3dMaterialLibrary::Destroy();

	CloseRender();

	if(gSurveyOutLink)
		ShellExecute(NULL, "open", gSurveyOutLink, "", NULL, SW_SHOW);

	/*r3dOutToLog("HackShield : UnInitialize...\n");
	_AhnHS_StopService();
	_AhnHS_Uninitialize();*/
	HMODULE hMod;
	hMod = LoadLibrary(TEXT("WGCrash.dll"));
	//HackCheck _HackCheck;
	//_HackCheck = (HackCheck)GetProcAddress(hMod,"DetachProcess");
	//_HackCheck();
	FreeLibrary(hMod);
	TerminateProcess(GetCurrentProcess(),-1);
	return;
}
コード例 #11
0
ファイル: main.cpp プロジェクト: douzsh/douzsh
int main(int argc,char* argv[])
{
	if ( argc<6 )
	{
		exit_with_help();
		return 0;
	}
	iDurationDay = atoi(argv[1]);
	iFromHour = atoi(argv[2]);
	iEndHour = atoi(argv[3]);
	strcpy(strDBTableList,argv[4]);
	strcpy(strDBFrom,argv[5]);
	if ( argc>6 )
	{
		strcpy(strIP,argv[6]);
	} 
	else
	{
		strcpy(strIP,"127.0.0.1");
	}//*/

	/*iDurationDay=1;
	iFromHour=9;
	iEndHour=10;
	strcpy(strDBTableList,"IMAGE_CJFD1994,IMAGE_CJFD1995,IMAGE_CJFD1996,IMAGE_CJFD1997,IMAGE_CJFD1998,IMAGE_CJFD1999,IMAGE_CJFD2000,IMAGE_CJFD2001,IMAGE_CJFD2002,IMAGE_CJFD2003,IMAGE_CJFD2004,IMAGE_CJFD2005,IMAGE_CJFD2006,IMAGE_CJFD2007,IMAGE_CJFD2007_ZHAOHUI,IMAGE_CJFD2008,IMAGE_CJFD2008_ZHAOHUI,IMAGE_CJFD2009,IMAGE_CJFD2010,IMAGE_CJFD2011,IMAGE_CJFD2011_INFOTEST,IMAGE_CJFD_UNKNOWN,IMAGE_CPFD1999,IMAGE_CPFD2000,IMAGE_CPFD2001,IMAGE_CPFD2002,IMAGE_CPFD2003,IMAGE_CPFD2004,IMAGE_CPFD2005,IMAGE_CPFD2006,IMAGE_CPFD2007,IMAGE_CPFD2008,IMAGE_CPFD2009,IMAGE_CPFD2010,IMAGE_CPFD2011,IMAGE_CPFD_UNKNOWN,IMAGE_CRFD,IMAGE_SCPD2009,INV_IMAGE_CJFD2007,INV_IMAGE_CJFD2008,INV_IMAGE_CJFD2009,INV_IMAGE_CJFD2010,INV_IMAGE_CJFD2011,INV_IMAGE_CJFD_UNKNOWN");
	strcpy(strDBFrom,"CNKIIMAGE_2011");
	strcpy(strIP,"192.168.100.101");//*/

	TPI_LOGIN_PARA logpara ;
	strcpy(logpara.szUserName,"DBOWN") ;
	strcpy(logpara.szPassWord,"") ;
	strcpy(logpara.UserIp.szIp,strIP);

	int iStat=STAT_NULL;
	time_t timer;
	struct tm *tblock;
	timer=time(NULL);
	tblock=localtime(&timer);

	int iStartDay=-1;

	LogExec("\nbackgroud update begin\n");
	while(true)
	{
		timer=time(NULL);
		tblock=localtime(&timer);
		
		if (( iStat==STAT_START || iStartDay==-1 || (tblock->tm_yday-iStartDay)==iDurationDay ))
		{
			if ( tblock->tm_hour>=iFromHour && ((iEndHour>=iFromHour && tblock->tm_hour<=iEndHour) || (iEndHour<iFromHour)) )
			{
				int errorcode = -1 ;
				kbase_handle = TPI_OpenCon(strIP,4567,logpara,&errorcode) ;
				if(errorcode < 0)
				{
					LogExec("cant connect to server\n");
					Sleep(1000*600);
					continue;
				}
				iStartDay=tblock->tm_yday;
				LogExec(asctime(tblock));
				LogExec("start update\n");
				iStat=UpdateDB();
				timer=time(NULL);
				tblock=localtime(&timer);
				LogExec(asctime(tblock));
				LogExec("update end\n");
				TPI_CloseCon(kbase_handle);
				continue;
			}
		}

		LogExec(".");
		Sleep(600*1000);
	}
	return 0;
}
コード例 #12
0
nsresult
nsPermissionManager::AddInternal(const nsAFlatCString &aHost,
                                 const nsAFlatCString &aType,
                                 PRUint32              aPermission,
                                 PRInt64               aID,
                                 PRUint32              aExpireType,
                                 PRInt64               aExpireTime,
                                 NotifyOperationType   aNotifyOperation,
                                 DBOperationType       aDBOperation)
{
  if (!gHostArena) {
    gHostArena = new PLArenaPool;
    if (!gHostArena)
      return NS_ERROR_OUT_OF_MEMORY;    
    PL_INIT_ARENA_POOL(gHostArena, "PermissionHostArena", HOST_ARENA_SIZE);
  }

  // look up the type index
  PRInt32 typeIndex = GetTypeIndex(aType.get(), PR_TRUE);
  NS_ENSURE_TRUE(typeIndex != -1, NS_ERROR_OUT_OF_MEMORY);

  // When an entry already exists, PutEntry will return that, instead
  // of adding a new one
  nsHostEntry *entry = mHostTable.PutEntry(aHost.get());
  if (!entry) return NS_ERROR_FAILURE;
  if (!entry->GetKey()) {
    mHostTable.RawRemoveEntry(entry);
    return NS_ERROR_OUT_OF_MEMORY;
  }

  // figure out the transaction type, and get any existing permission value
  OperationType op;
  PRInt32 index = entry->GetPermissionIndex(typeIndex);
  if (index == -1) {
    if (aPermission == nsIPermissionManager::UNKNOWN_ACTION)
      op = eOperationNone;
    else
      op = eOperationAdding;

  } else {
    nsPermissionEntry oldPermissionEntry = entry->GetPermissions()[index];

    // remove the permission if the permission is UNKNOWN, update the
    // permission if its value or expire type have changed OR if the time has
    // changed and the expire type is time, otherwise, don't modify.  There's
    // no need to modify a permission that doesn't expire with time when the
    // only thing changed is the expire time.
    if (aPermission == oldPermissionEntry.mPermission && 
        aExpireType == oldPermissionEntry.mExpireType &&
        (aExpireType != nsIPermissionManager::EXPIRE_TIME || 
         aExpireTime == oldPermissionEntry.mExpireTime))
      op = eOperationNone;
    else if (aPermission == nsIPermissionManager::UNKNOWN_ACTION)
      op = eOperationRemoving;
    else
      op = eOperationChanging;
  }

  // do the work for adding, deleting, or changing a permission:
  // update the in-memory list, write to the db, and notify consumers.
  PRInt64 id;
  switch (op) {
  case eOperationNone:
    {
      // nothing to do
      return NS_OK;
    }

  case eOperationAdding:
    {
      if (aDBOperation == eWriteToDB) {
        // we'll be writing to the database - generate a known unique id
        id = ++mLargestID;
      } else {
        // we're reading from the database - use the id already assigned
        id = aID;
      }

      entry->GetPermissions().AppendElement(nsPermissionEntry(typeIndex, aPermission, id, aExpireType, aExpireTime));

      if (aDBOperation == eWriteToDB && aExpireType != nsIPermissionManager::EXPIRE_SESSION)
        UpdateDB(op, mStmtInsert, id, aHost, aType, aPermission, aExpireType, aExpireTime);

      if (aNotifyOperation == eNotify) {
        NotifyObserversWithPermission(aHost,
                                      mTypeArray[typeIndex],
                                      aPermission,
                                      aExpireType,
                                      aExpireTime,
                                      NS_LITERAL_STRING("added").get());
      }

      break;
    }

  case eOperationRemoving:
    {
      nsPermissionEntry oldPermissionEntry = entry->GetPermissions()[index];
      id = oldPermissionEntry.mID;
      entry->GetPermissions().RemoveElementAt(index);

      // If no more types are present, remove the entry
      if (entry->GetPermissions().IsEmpty())
        mHostTable.RawRemoveEntry(entry);

      if (aDBOperation == eWriteToDB)
        UpdateDB(op, mStmtDelete, id, EmptyCString(), EmptyCString(), 0, 
                 nsIPermissionManager::EXPIRE_NEVER, 0);

      if (aNotifyOperation == eNotify) {
        NotifyObserversWithPermission(aHost,
                                      mTypeArray[typeIndex],
                                      oldPermissionEntry.mPermission,
                                      oldPermissionEntry.mExpireType,
                                      oldPermissionEntry.mExpireTime,
                                      NS_LITERAL_STRING("deleted").get());
      }

      break;
    }

  case eOperationChanging:
    {
      id = entry->GetPermissions()[index].mID;
      entry->GetPermissions()[index].mPermission = aPermission;

      if (aDBOperation == eWriteToDB && aExpireType != nsIPermissionManager::EXPIRE_SESSION)
        UpdateDB(op, mStmtUpdate, id, EmptyCString(), EmptyCString(), aPermission, aExpireType, aExpireTime);

      if (aNotifyOperation == eNotify) {
        NotifyObserversWithPermission(aHost,
                                      mTypeArray[typeIndex],
                                      aPermission,
                                      aExpireType,
                                      aExpireTime,
                                      NS_LITERAL_STRING("changed").get());
      }

      break;
    }
  }

  return NS_OK;
}
コード例 #13
0
unsigned WINAPI cashierThread(void *arg)
{
	topUpReader = false;

	while (true)
	{
		//차량신호올때까지 대기
		watiAndcheckExited(T_hiCashier);

		//DB연결
		SOCKET sock = openDB();

		serchDB(sock, paydata.id);
		int visitresult = recvfromDB(sock);

		char buf[100]; sprintf(buf, "받은값 %d", visitresult);
		OutputDebugString(buf);

		if (visitresult == KEY_NOTFOUND)
		{
			exit(-1);
		}
		else
		{
			if (visitresult > 3)
			{
				paydata.cash = paydata.cash - paydata.cash / 2;
				chagneCloud(3, "20% 할인합니다", true);
			}
			else
				chagneCloud(3, "할인대상이 아닙니다", true);
		}

		UpdateDB(sock, "%d.2.%d.5.%d.6.1",
			paydata.id,
			paydata.cash,
			paydata.movietime);

		if (recvfromDB(sock) == KEY_NOTFOUND)
			exit(-1);

		closeDB(sock);

		chagneCloud(3, "계산이 끝났습니다.", true);
		chagneCloud(3, "안녕히 가세요.", true);

		//계산 다했다고 알려줌
		ReleaseSemaphore(T_waitPay, 1, NULL);
		//차량인식기를 올림
		topUpReader = true;
		Update();
		std::this_thread::sleep_for(std::chrono::milliseconds(500));

		chagneCloud(3, "NULL", false);

		//차량인식기를 내리는 신호 대기
		watiAndcheckExited(T_downCashier);
		topUpReader = false;
		Update();
		std::this_thread::sleep_for(std::chrono::milliseconds(500));

		

		//다음차 오라고 신호줌
		ReleaseSemaphore(T_waitCashier, 1, NULL);
	}
	return 0;
}