diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/gen_insert.pl')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/gen_insert.pl | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/gen_insert.pl b/storage/rocksdb/mysql-test/rocksdb/t/gen_insert.pl new file mode 100644 index 00000000000..c723ec3ca17 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/gen_insert.pl @@ -0,0 +1,32 @@ +#!/usr/bin/perl + +my $table_name= $ARGV[0]; +my $id1= 1; +my $id2= 1; +my $id3= 1; +my $id4= 1; +my $id5= 1; +my $value= 1000; +my $value2= 'aaabbbccc'; +my $max_rows = 1 * 10000; + +for(my $row_id= 1; $row_id <= $max_rows; $row_id++) { + my $value_clause = "($id1, $id2, $id3, $id4, $id5, $value, \"$value2\")"; + + if ($row_id % 100 == 1) { + print "INSERT INTO $table_name VALUES"; + } + + if ($row_id % 100 == 0) { + print "$value_clause;\n"; + }else { + print "$value_clause,"; + } + + $id4++; + $id5++; + $id3++ if($row_id % 5 == 0); + $id2++ if($row_id % 5 == 0); + $id1++ if($row_id % 10 == 0); +} + |