insert or replace into target_table
   select * from source_table

void CFlylinkDBManager::ratio(const string& p_hub,const string& p_nick, 
							  __int64 p_size, const string& p_ip, bool p_is_download)
{
 try {
    Lock l(m_cs);
	__int64 l_hub_id;
	const string l_key = getCFlyRatioKey(p_nick,p_hub,l_hub_id);
	CFlyRatioItem& l_new_item = m_ratio_cache[l_key]; 
	l_new_item.m_ip = p_ip;
     if(p_is_download)
	 {
		l_new_item.m_download += p_size;
  	    m_global_ratio.m_download += p_size;
 	 }
	 else
	 {
		l_new_item.m_upload   += p_size; 
  	    m_global_ratio.m_upload   += p_size;
	 }
    const __int64 l_nick =  getDIC_ID(p_nick,e_DIC_NICK);
    const __int64 l_ip   =  getDIC_ID(p_ip,e_DIC_IP);
	sqlite3_command* l_sql =  0 ;
	if(!m_select_ratio.get())
        m_select_ratio = auto_ptr<sqlite3_command>(new sqlite3_command(m_flySQLiteDB,
          "select max(id) from fly_ratio where dic_nick=? and dic_hub=? and dic_ip=?"));
	l_sql = m_select_ratio.get();
    l_sql->bind( 1 , l_nick);
    l_sql->bind( 2 , l_hub_id);
    l_sql->bind( 3 , l_ip);
	__int64 l_id_ratio = l_sql->executeint64();
	if(l_id_ratio)
	{
	  if(p_size)
	  {
	  sqlite3_transaction l_trans(m_flySQLiteDB);
	  if(!m_update_ratio.get())
         m_update_ratio = auto_ptr<sqlite3_command>(new sqlite3_command(m_flySQLiteDB,
        "update fly_ratio set upload = upload + ?, download = download + ? where id=?"));
	     l_sql = m_update_ratio.get();
	     if(p_is_download)
		 {
		   l_sql->bind( 1 ,  0 );
		   l_sql->bind( 2 , p_size);
		 }
		 else
		 {
           l_sql->bind( 2 ,  0 );
           l_sql->bind( 1 , p_size);
		 }
         l_sql->bind( 3 , l_id_ratio);
 	     l_sql->executenonquery();
         l_trans.commit();
	  }
	}
	else
	{
      sqlite3_transaction l_trans(m_flySQLiteDB);
	  if(!m_insert_ratio.get())
         m_insert_ratio = auto_ptr<sqlite3_command>(new sqlite3_command(m_flySQLiteDB,
        "insert into fly_ratio (dic_ip,dic_nick,dic_hub,upload,download) values(?,?,?,?,?)"));
	     l_sql = m_insert_ratio.get();
         l_sql->bind( 1 , l_ip);
         l_sql->bind( 2 , l_nick);
         l_sql->bind( 3 , l_hub_id);
	     if(p_is_download)
		 {
			 l_sql->bind( 4 ,  0 );
			 l_sql->bind( 5 , p_size);
		 }
	     else
		 {
			 l_sql->bind( 4 , p_size);
			 l_sql->bind( 5 ,  0 );
		 }
 	      l_sql->executenonquery();
         l_trans.commit();
	}
	}
 	catch(const database_error& e)
	{
		LogManager::getInstance()->message("SQLite - ratio: " + e.getError());
	}
}