Develop and Download Open Source Software

XooNIps

Browse CVS Repository

/[OSDN]/xoonips/AL/commonal.cc

Diff of /xoonips/AL/commonal.cc

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.115 by tani, Thu Nov 17 10:59:36 2005 UTC revision 1.116 by tani, Tue Nov 22 11:29:54 2005 UTC
# Line 22  Line 22 
22   *   *
23   * $Revision$   * $Revision$
24   * $Log$   * $Log$
25     * Revision 1.116  2005/11/22 11:29:54  tani
26     * deleteItem: アイテム削除と同時にRelated toも削除する.
27     * getRelatedTo: isActivatedBySessionのチェックを外す(冗長なので).
28     *
29   * Revision 1.115  2005/11/17 10:59:36  tani   * Revision 1.115  2005/11/17 10:59:36  tani
30   * アイテム間リンク機能: insertRelatedTo, deleteRelatedTo, getRelatedToを追加.   * アイテム間リンク機能: insertRelatedTo, deleteRelatedTo, getRelatedToを追加.
31   *   *
# Line 4363  result_t updateItem( sessionid_t sid, co Line 4367  result_t updateItem( sessionid_t sid, co
4367  /**  /**
4368   *   *
4369   * アイテム(Basic Information)を削除する.   * アイテム(Basic Information)を削除する.
4370     * インデックスキーワード，アイテム間リンクからも削除する．
4371     *
4372   *   *
4373   * @param sid セッションID   * @param sid セッションID
4374   * @param item 削除したいアイテムの情報   * @param item 削除したいアイテムの情報
# Line 4405  result_t deleteItem( sessionid_t sid, it Line 4411  result_t deleteItem( sessionid_t sid, it
4411        1. delete item from index keywords        1. delete item from index keywords
4412        2. delete item from binders        2. delete item from binders
4413        3. delete item        3. delete item
4414          4. delete item from related_to
4415      */      */
4416            
4417      //1. delete item from index keywords      //1. delete item from index keywords
# Line 4470  result_t deleteItem( sessionid_t sid, it Line 4477  result_t deleteItem( sessionid_t sid, it
4477          ret = RES_ERROR;          ret = RES_ERROR;
4478      }      }
4479            
       
4480      // 3. delete item      // 3. delete item
4481      sql = "DELETE FROM " + dbprefix + "_xoonips_item_basic ";      sql = "DELETE FROM " + dbprefix + "_xoonips_item_basic ";
4482      sql += "WHERE item_id = " + string( unsignedIntToString( itemid ) );      sql += "WHERE item_id = " + string( unsignedIntToString( itemid ) );
# Line 4502  result_t deleteItem( sessionid_t sid, it Line 4508  result_t deleteItem( sessionid_t sid, it
4508          ret = RES_ERROR;          ret = RES_ERROR;
4509      }      }
4510            
4511        // 4. delete records from related_to
4512        sql = "DELETE FROM " + dbprefix + "_xoonips_related_to ";
4513        sql += "WHERE parent_id = " + string( unsignedIntToString( itemid ) );
4514        if( ( sqlcode = SQLAllocHandle( SQL_HANDLE_STMT, hdbc, &hstmt ) ) == SQL_SUCCESS ) {
4515            SQLExecDirect( hstmt, (SQLCHAR*)sql.c_str(), sql.length() );
4516        }
4517    
4518      if ( ret == RES_OK ){      if ( ret == RES_OK ){
4519          ret = insertMetadataEventAuto( itemid );          ret = insertMetadataEventAuto( itemid );
4520      }      }
# Line 8400  result_t insertRelatedTo( sessionid_t si Line 8413  result_t insertRelatedTo( sessionid_t si
8413      if( !isValidSessionID( sid ) ) return RES_NO_SUCH_SESSION;      if( !isValidSessionID( sid ) ) return RES_NO_SUCH_SESSION;
8414      if( !isActivatedBySession( sid ) ) return RES_NO_WRITE_ACCESS_RIGHT;      if( !isActivatedBySession( sid ) ) return RES_NO_WRITE_ACCESS_RIGHT;
8415      if( !getItemPermission( sid, parentid, item::OP_MODIFY ) ) return RES_NO_WRITE_ACCESS_RIGHT;      if( !getItemPermission( sid, parentid, item::OP_MODIFY ) ) return RES_NO_WRITE_ACCESS_RIGHT;
8416      if( !getItemPermission( sid, itemid, item::OP_READ ) ) return RES_NO_WRITE_ACCESS_RIGHT;      if( !getItemPermission( sid, itemid, item::OP_READ ) ) return RES_NO_READ_ACCESS_RIGHT;
8417            
8418      string sql;      string sql;
8419      SQLHANDLE hstmt = NULL;      SQLHANDLE hstmt = NULL;
# Line 8518  result_t getRelatedTo( sessionid_t sid, Line 8531  result_t getRelatedTo( sessionid_t sid,
8531  {  {
8532      if( hdbc == NULL ) return RES_DB_NOT_INITIALIZED;      if( hdbc == NULL ) return RES_DB_NOT_INITIALIZED;
8533      if( !isValidSessionID( sid ) ) return RES_NO_SUCH_SESSION;      if( !isValidSessionID( sid ) ) return RES_NO_SUCH_SESSION;
8534      if( !isActivatedBySession( sid ) ) return RES_NO_WRITE_ACCESS_RIGHT;      if( !getItemPermission( sid, parentid, item::OP_READ ) ) return RES_NO_READ_ACCESS_RIGHT;
     if( !getItemPermission( sid, parentid, item::OP_READ ) ) return RES_NO_WRITE_ACCESS_RIGHT;  
8535            
8536      result_t ret = RES_ERROR;      result_t ret = RES_ERROR;
8537      string sql;      string sql;
Legend:
Removed from v.1.115  
changed lines
  Added in v.1.116
Back to OSDN">Back to OSDN
 ViewVC Help
Powered by ViewVC 1.1.26  
About OSDN
Find Software
Develop Software
Help