📄 isam0001.tst
字号:
##get 0 FIRST# pblIsamGet( 4, 0 )# rc -1, pbl_errno 1003, errno 0#### Start a transaction##transaction START# pblIsamStartTransaction( )# rc 0#### insert 1000 records, the keys are "key10" to "key1999" for 0001key0, ...##ninsert 1000 key1,key2,key3 dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa# pblIsamInsert( 1, ,key10,key20,key30, 18, dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa, 52 )# inserted 1000 records, rc 0#### Read Data of current record##readdata# pblIsamReadData( currentrecord )# datalen 52, data dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa#### Read alphabetically last record according to index 0001key0## this sets the current record##get 0 LAST# pblIsamGet( 5, 0 )# keylen 7, key key1999#### Read alphabetically first record according to index 0001key0## this sets the current record##get 0 FIRST# pblIsamGet( 4, 0 )# keylen 5, key key10#### Rollback the transaction, do not commit the 1000 inserts done above##transaction ROLLBACK# pblIsamCommit( ROLLBACK )# rc 1, pbl_errno 0, errno 0#### Read alphabetically last record according to index 0001key0## There is no such record##get 0 LAST# pblIsamGet( 5, 0 )# rc -1, pbl_errno 1003, errno 0#### Read alphabetically first record according to index 0001key0## There is no such record##get 0 FIRST# pblIsamGet( 4, 0 )# rc -1, pbl_errno 1003, errno 0#### Start a transaction##transaction START# pblIsamStartTransaction( )# rc 0#### Reinsert the 1000 records##ninsert 1000 key1,key2,key3 dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa# pblIsamInsert( 1, ,key10,key20,key30, 18, dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa, 52 )# inserted 1000 records, rc 0#### Read last and first record##get 0 LAST# pblIsamGet( 5, 0 )# keylen 7, key key1999get 0 FIRST# pblIsamGet( 4, 0 )# keylen 5, key key10#### Commit the 1000 inserts##transaction COMMIT# pblIsamCommit( COMMIT )# rc 0#### Read last and first record##get 0 LAST# pblIsamGet( 5, 0 )# keylen 7, key key1999get 0 FIRST# pblIsamGet( 4, 0 )# keylen 5, key key10get 0 THIS# pblIsamGet( 1, 0 )# keylen 5, key key10ndelete 1000# pblIsamDelete( 1000 records )# deleted 1000 records, rc 0#### Delete 1000 records,##flush# pblIsamFlush( 1 )# rc 0#### Close the empty file##close# pblIsamClose( 1 )# rc 0#### Open the file again##open isamtest/0001main 0001key0,0001dup1,0001key2 1# pblIsamOpen( isamtest/0001main, 3, 1 )# ok!#### insert 10000 records##ninsert 10000 loooooooooooooooongkey1,loooooooooooooooongkey2,loooooooooooooooongkey3 dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa# pblIsamInsert( 1, ,loooooooooooooooongkey10,loooooooooooooooongkey20,loooooooooooooooongkey30, 75, dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa, 134 )# inserted 10000 records, rc 0#### Read alphabetically first record according to index 0001key0## this sets the current record##get 0 FIRST# pblIsamGet( 4, 0 )# keylen 24, key loooooooooooooooongkey10readdata# pblIsamReadData( currentrecord )# datalen 134, data dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa#### Find a record with an index 0001key0 value## lower than loooooooooooooooongkey12555##find 0 loooooooooooooooongkey12555 LT# pblIsamFind( LT, loooooooooooooooongkey12555, 27 )# keylen 27, key loooooooooooooooongkey12554#### Find a record with an index 0001key0 value## lower than or equal to loooooooooooooooongkey13666##find 0 loooooooooooooooongkey13666 LE# pblIsamFind( LE, loooooooooooooooongkey13666, 27 )# keylen 27, key loooooooooooooooongkey13666#### Find the first record with an index 0001key0 value## equal to loooooooooooooooongkey13666##find 0 loooooooooooooooongkey14777 FI# pblIsamFind( FI, loooooooooooooooongkey14777, 27 )# keylen 27, key loooooooooooooooongkey14777#### Find any record with an index 0001key0 value## equal to loooooooooooooooongkey15888##find 0 loooooooooooooooongkey15888 EQ# pblIsamFind( EQ, loooooooooooooooongkey15888, 27 )# keylen 27, key loooooooooooooooongkey15888#### Find the last record with an index 0001key0 value## equal to loooooooooooooooongkey16999##find 0 loooooooooooooooongkey16999 LA# pblIsamFind( LA, loooooooooooooooongkey16999, 27 )# keylen 27, key loooooooooooooooongkey16999#### Find a record with an index 0001key0 value## equal to or bigger than loooooooooooooooongkey17111##find 0 loooooooooooooooongkey17111 GE# pblIsamFind( GE, loooooooooooooooongkey17111, 27 )# keylen 27, key loooooooooooooooongkey17111#### Find a record with an index 0001key0 value## bigger than loooooooooooooooongkey18222##find 0 loooooooooooooooongkey18222 GT# pblIsamFind( GT, loooooooooooooooongkey18222, 27 )# keylen 27, key loooooooooooooooongkey18223#### Get the next record according to index 0001key0##get 0 NEXT# pblIsamGet( 2, 0 )# keylen 27, key loooooooooooooooongkey18224#### Do some finds on index 0001dup1##find 1 loooooooooooooooongkey22555 LE# pblIsamFind( LE, loooooooooooooooongkey22555, 27 )# keylen 27, key loooooooooooooooongkey22555find 1 loooooooooooooooongkey23666 FI# pblIsamFind( FI, loooooooooooooooongkey23666, 27 )# keylen 27, key loooooooooooooooongkey23666get 1 NEXT# pblIsamGet( 2, 1 )# keylen 27, key loooooooooooooooongkey23667get 1 NEXT# pblIsamGet( 2, 1 )# keylen 27, key loooooooooooooooongkey23668get 1 NEXT# pblIsamGet( 2, 1 )# keylen 27, key loooooooooooooooongkey23669get 1 NEXT# pblIsamGet( 2, 1 )# keylen 26, key loooooooooooooooongkey2367get 1 NEXT# pblIsamGet( 2, 1 )# keylen 27, key loooooooooooooooongkey23670get 1 PREV# pblIsamGet( 3, 1 )# keylen 26, key loooooooooooooooongkey2367#### Do some finds on index 0001key2##find 2 loooooooooooooooongkey32555 LT# pblIsamFind( LT, loooooooooooooooongkey32555, 27 )# keylen 27, key loooooooooooooooongkey32554find 2 loooooooooooooooongkey33666 LE# pblIsamFind( LE, loooooooooooooooongkey33666, 27 )# keylen 27, key loooooooooooooooongkey33666find 2 loooooooooooooooongkey34777 FI# pblIsamFind( FI, loooooooooooooooongkey34777, 27 )# keylen 27, key loooooooooooooooongkey34777find 2 loooooooooooooooongkey35888 EQ# pblIsamFind( EQ, loooooooooooooooongkey35888, 27 )# keylen 27, key loooooooooooooooongkey35888find 2 loooooooooooooooongkey36999 LA# pblIsamFind( LA, loooooooooooooooongkey36999, 27 )# keylen 27, key loooooooooooooooongkey36999find 2 loooooooooooooooongkey37111 GE# pblIsamFind( GE, loooooooooooooooongkey37111, 27 )# keylen 27, key loooooooooooooooongkey37111find 2 loooooooooooooooongkey38222 GT# pblIsamFind( GT, loooooooooooooooongkey38222, 27 )# keylen 27, key loooooooooooooooongkey38223#### Start a transaction##transaction START# pblIsamStartTransaction( )# rc 0#### Read alphabetically first record according to index 0001key0## this sets the current record##get 0 FIRST# pblIsamGet( 4, 0 )# keylen 24, key loooooooooooooooongkey10#### Delete 800 records##ndelete 800# pblIsamDelete( 800 records )# deleted 800 records, rc 0readdata# pblIsamReadData( currentrecord )# datalen 134, data dataaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa#### Delete 200 records##ndelete 200# pblIsamDelete( 200 records )# deleted 200 records, rc 0#### Read alphabetically first record according to index 0001key0## this sets the current record##get 0 FIRST# pblIsamGet( 4, 0 )# keylen 27, key loooooooooooooooongkey11000#### Rollback the transaction##transaction ROLLBACK# pblIsamCommit( ROLLBACK )# rc 1, pbl_errno 0, errno 0get 0 FIRST# pblIsamGet( 4, 0 )# keylen 24, key loooooooooooooooongkey10#### Start a transaction##transaction START# pblIsamStartTransaction( )# rc 0get 0 FIRST# pblIsamGet( 4, 0 )# keylen 24, key loooooooooooooooongkey10#### Delete 1000 records##ndelete 1000# pblIsamDelete( 1000 records )# deleted 1000 records, rc 0get 0 FIRST# pblIsamGet( 4, 0 )# keylen 27, key loooooooooooooooongkey11000transaction COMMIT# pblIsamCommit( COMMIT )# rc 0get 0 FIRST# pblIsamGet( 4, 0 )# keylen 27, key loooooooooooooooongkey11000#### Delete 1000 records##ndelete 1000# pblIsamDelete( 1000 records )# deleted 1000 records, rc 0get 0 FIRST# pblIsamGet( 4, 0 )# keylen 27, key loooooooooooooooongkey12000#### Delete 8000 records, i.e. all of them##ndelete 8000# pblIsamDelete( 8000 records )# deleted 8000 records, rc 0#### Verify the file is empty now##get 0 FIRST# pblIsamGet( 4, 0 )# rc -1, pbl_errno 1003, errno 0get 1 FIRST# pblIsamGet( 4, 1 )# rc -1, pbl_errno 1003, errno 0get 2 FIRST# pblIsamGet( 4, 2 )# rc -1, pbl_errno 1003, errno 0#### Close the file##close# pblIsamClose( 1 )# rc 0quit⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -