TEST(collectonspace,sdbCreateCollection) { sdbConnectionHandle connection = 0 ; sdbCSHandle collectionspace = 0 ; sdbCollectionHandle collection = 0 ; INT32 rc = SDB_OK ; rc = initEnv( HOST, SERVER, USER, PASSWD ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbConnect ( HOST, SERVER, USER, PASSWD, &connection ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = getCollectionSpace ( connection, COLLECTION_SPACE_NAME, &collectionspace ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbDropCollection ( collectionspace, COLLECTION_NAME ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbCreateCollection ( collectionspace, COLLECTION_NAME, &collection ) ; ASSERT_EQ( SDB_OK, rc ) ; sdbDisconnect ( connection ) ; sdbReleaseCollection ( collection ) ; sdbReleaseCS ( collectionspace ) ; sdbReleaseConnection ( connection ) ; }
TEST(collectonspace,sdbCreateCollection1_without_options) { sdbConnectionHandle connection = 0 ; sdbCSHandle collectionspace = 0 ; sdbCollectionHandle collection = 0 ; INT32 rc = SDB_OK ; bson option ; rc = initEnv( HOST, SERVER, USER, PASSWD ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbConnect ( HOST, SERVER, USER, PASSWD, &connection ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = getCollectionSpace ( connection, COLLECTION_SPACE_NAME, &collectionspace ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbDropCollection ( collectionspace, COLLECTION_NAME ) ; ASSERT_EQ( SDB_OK, rc ) ; bson_init( &option ); bson_append_int( &option, "ReplSize", 0 ); bson_finish( &option ) ; rc = sdbCreateCollection1 ( collectionspace, COLLECTION_NAME, &option, &collection ) ; ASSERT_EQ( SDB_OK, rc ) ; bson_destroy( &option ) ; sdbDisconnect ( connection ) ; sdbReleaseCollection ( collection ) ; sdbReleaseCS ( collectionspace ) ; sdbReleaseConnection ( connection ) ; }
INT32 main ( INT32 argc, CHAR **argv ) { // initialize local variables CHAR *pHostName = NULL ; CHAR *pServiceName = NULL ; CHAR *pUsr = NULL ; CHAR *pPasswd = NULL ; // define a connetion handle; use to connect to database sdbConnectionHandle connection = 0 ; // define a collection space handle sdbCSHandle collectionspace = 0 ; // define a collection handle sdbCollectionHandle collection = 0 ; // define a cursor handle for query sdbCursorHandle cursor = 0 ; // define local variables // initialize them before use INT32 rc = SDB_OK ; INT32 count = 0 ; bson obj ; bson rule ; bson objList [ NUM_RECORD ] ; // verify syntax if ( 5 != argc ) { displaySyntax ( (CHAR*)argv[0] ) ; exit ( 0 ) ; } // read argument pHostName = (CHAR*)argv[1] ; pServiceName = (CHAR*)argv[2] ; pUsr = (CHAR*)argv[3] ; pPasswd = (CHAR*)argv[4] ; // connect to database rc = sdbConnect ( pHostName, pServiceName, pUsr, pPasswd, &connection ) ; CHECK_RC ( rc, "Failed to connet to database" ) ; // create collection space rc = sdbCreateCollectionSpace ( connection, COLLECTION_SPACE_NAME, SDB_PAGESIZE_4K, &collectionspace ) ; CHECK_RC ( rc, "Failed to create collection space" ) ; // create collection in a specified colletion space. // Here,we build it up in the new collection. rc = sdbCreateCollection ( collectionspace, COLLECTION_NAME, &collection ) ; CHECK_RC ( rc, "Failed to create collection" ) ; // create record list using objList createRecordList ( &objList[0], NUM_RECORD ) ; // insert obj and free memory that allocated by createRecordList for ( count = 0; count < NUM_RECORD; count++ ) { // all the contents of inserted record are the same except _id rc = sdbInsert ( collection, &objList[count] ) ; if ( rc ) { printf ( "Failed to insert record, rc = %d" OSS_NEWLINE, rc ) ; } bson_destroy ( &objList[count] ) ; } // query all the record in this collection // and return the result by the cursor handle rc = sdbQuery(collection, NULL, NULL, NULL, NULL, 0, -1, &cursor ) ; CHECK_RC ( rc, "Failed to query" ) ; // get all the qureied records bson_init(&obj); while( !( rc=sdbNext( cursor, &obj ) ) ) { bson_print( &obj ) ; bson_destroy(&obj) ; bson_init(&obj); } bson_destroy(&obj) ; if( rc==SDB_DMS_EOC ) { printf("All the record had been list." OSS_NEWLINE ) ; } else if( rc!=SDB_OK ) { CHECK_RC ( rc, "Failed to get the record" ) ; } // drop the specified collection rc = sdbDropCollection( collectionspace,COLLECTION_NAME ) ; CHECK_RC ( rc, "Failed to drop the specified collection" ) ; // drop the specified collection space rc = sdbDropCollectionSpace( connection,COLLECTION_SPACE_NAME ) ; CHECK_RC ( rc, "Failed to drop the specified collection space" ) ; done: // disconnect the connection sdbDisconnect ( connection ) ; // release the local variables sdbReleaseCursor ( cursor ) ; sdbReleaseCollection ( collection ) ; sdbReleaseCS ( collectionspace ) ; sdbReleaseConnection ( connection ) ; return 0; error: goto done ; }
INT32 main ( INT32 argc, CHAR **argv ) { // initialize local variables CHAR *pHostName = NULL ; CHAR *pServiceName = NULL ; CHAR *pUsr = NULL ; CHAR *pPasswd = NULL ; // define a connetion handle; use to connect to database sdbConnectionHandle connection = 0 ; // define a collection space handle sdbCSHandle collectionspace = 0 ; // define a collection handle sdbCollectionHandle collection = 0 ; // define a cursor handle for query sdbCursorHandle cursor = 0 ; // define local variables // initialize them before use bson obj ; bson rule ; INT32 rc = SDB_OK ; // read argument pHostName = (CHAR*)argv[1] ; pServiceName = (CHAR*)argv[2] ; pUsr = (CHAR*)argv[3] ; pPasswd = (CHAR*)argv[4] ; // verify syntax if ( 5 != argc ) { displaySyntax ( (CHAR*)argv[0] ) ; exit ( 0 ) ; } // connect to database rc = sdbConnect ( pHostName, pServiceName, pUsr, pPasswd, &connection ) ; CHECK_RC ( rc, "Failed to connet to database" ) ; // create collection space rc = sdbCreateCollectionSpace ( connection, COLLECTION_SPACE_NAME, SDB_PAGESIZE_4K, &collectionspace ) ; CHECK_RC ( rc, "Failed to create collection space" ) ; // create collection in a specified colletion space. rc = sdbCreateCollection ( collectionspace, COLLECTION_NAME, &collection ) ; CHECK_RC ( rc, "Failed to create collection" ) ; // insert records to the collection bson_init ( &obj ) ; // build a English record createEnglishRecord ( &obj ) ; // insert rc = sdbInsert ( collection, &obj ) ; CHECK_RC ( rc, "Failed to insert record" ) ; // query the records // the result is in the cursor handle rc = sdbQuery(collection, NULL, NULL, NULL, NULL, 0, -1, &cursor ) ; CHECK_RC ( rc, "Failed to query" ) ; // update the record // let's set the rule and query condition first // here,we make the condition to be NULL // so all the records will be update bson_init ( &rule ) ; bson_append_start_object ( &rule, "$set" ) ; bson_append_int ( &rule, "age", 19 ) ; bson_append_finish_object ( &rule ) ; bson_finish ( &rule ) ; CHECK_RC ( rc, "Failed to build bson" ) ; printf ( "The update rule is:" ) ; bson_print( &rule ) ; // update rc = sdbUpdate ( collection, &rule, NULL, NULL ) ; CHECK_RC ( rc, "Failed to update the record" ) ; // free memory after finish using bson bson_destroy ( &rule ) ; printf ( "Success to update!" OSS_NEWLINE ) ; // drop the specified collection rc = sdbDropCollection ( collectionspace,COLLECTION_NAME ) ; CHECK_RC ( rc, "Failed to drop the specified collection" ) ; // drop the specified collection space rc = sdbDropCollectionSpace ( connection,COLLECTION_SPACE_NAME ) ; CHECK_RC ( rc, "Failed to drop the specified collection" ) ; done: // disconnect the connection sdbDisconnect ( connection ) ; // release the local variables sdbReleaseCursor ( cursor ) ; sdbReleaseCollection ( collection ) ; sdbReleaseCS ( collectionspace ) ; sdbReleaseConnection ( connection ) ; return 0; error: goto done ; }
INT32 main ( INT32 argc, CHAR **argv ) { // initialize local variables CHAR *pHostName = NULL ; CHAR *pServiceName = NULL ; CHAR *pUsr = NULL ; CHAR *pPasswd = NULL ; // define handles sdbConnectionHandle db = SDB_INVALID_HANDLE ; sdbCSHandle cs = SDB_INVALID_HANDLE ; sdbCollectionHandle cl = SDB_INVALID_HANDLE ; sdbLobHandle lob = SDB_INVALID_HANDLE ; INT32 rc = SDB_OK ; CHAR buf[BUFSIZE] = { 'a' } ; bson_oid_t oid ; // verify syntax if ( 5 != argc ) { displaySyntax ( (CHAR*)argv[0] ) ; exit ( 0 ) ; } // read argument pHostName = (CHAR*)argv[1] ; pServiceName = (CHAR*)argv[2] ; pUsr = (CHAR*)argv[3] ; pPasswd = (CHAR*)argv[4] ; // connect to database rc = sdbConnect ( pHostName, pServiceName, pUsr, pPasswd, &db ) ; CHECK_RC ( rc, "Failed to connet to database" ) ; // create collection space rc = sdbCreateCollectionSpace ( db, COLLECTION_SPACE_NAME, SDB_PAGESIZE_4K, &cs ) ; CHECK_RC ( rc, "Failed to create collection space" ) ; // create collection rc = sdbCreateCollection ( cs, COLLECTION_NAME, &cl ) ; CHECK_RC ( rc, "Failed to create collection" ) ; // create a large object and than write something to it // we need to gen an oid for the creating large object bson_oid_gen( &oid ) ; rc = sdbOpenLob( cl, &oid, SDB_LOB_CREATEONLY, &lob ) ; CHECK_RC ( rc, "Failed to create large object" ) ; // write something to the newly created large object rc = sdbWriteLob( lob, buf, BUFSIZE ) ; CHECK_RC ( rc, "Failed to write to large object" ) ; // close the newly created large object rc = sdbCloseLob( &lob ) ; CHECK_RC ( rc, "Failed to close large object" ) ; printf( "Success to create a large object and write something to it!\n" ) ; // drop the collection rc = sdbDropCollection( cs,COLLECTION_NAME ) ; CHECK_RC ( rc, "Failed to drop the specified collection" ) ; // drop the collection space rc = sdbDropCollectionSpace( db,COLLECTION_SPACE_NAME ) ; CHECK_RC ( rc, "Failed to drop the specified collection space" ) ; done: // disconnect the connection sdbDisconnect ( db ) ; // release the handles // sdbReleaseLob ( lob ) ; sdbReleaseCollection ( cl ) ; sdbReleaseCS ( cs ) ; sdbReleaseConnection ( db ) ; return 0; error: goto done ; }
printf("The test work in cluster environment\ with at least 2 data notes.\n") ; sdbConnectionHandle connection = 0 ; sdbCSHandle collectionspace = 0 ; sdbCollectionHandle collection = 0 ; INT32 rc = SDB_OK ; bson options ; rc = initEnv( HOST, SERVER, USER, PASSWD ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbConnect ( HOST, SERVER, USER, PASSWD, &connection ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = getCollectionSpace ( connection, COLLECTION_SPACE_NAME, &collectionspace ) ; ASSERT_EQ( SDB_OK, rc ) ; rc = sdbDropCollection ( collectionspace, COLLECTION_NAME ) ; ASSERT_EQ( SDB_OK, rc ) ; bson_init ( &options ) ; bson_append_start_object ( &options, "ShardingKey" ) ; bson_append_int ( &options, "age", 1 ) ; bson_append_int ( &options, "name", -1 ) ; bson_append_finish_object ( &options ) ; bson_append_int ( &options, "ReplSize", 2 ) ; bson_append_bool ( &options, "Compressed", true ) ; bson_finish ( &options ) ; bson_print ( &options ) ; rc = sdbCreateCollection1 ( collectionspace, COLLECTION_NAME, &options, &collection ) ;