svnno****@sourc*****
svnno****@sourc*****
2008年 4月 18日 (金) 16:33:04 JST
Revision: 111
http://svn.sourceforge.jp/cgi-bin/viewcvs.cgi?root=tritonn&view=rev&rev=111
Author: mir
Date: 2008-04-18 16:33:04 +0900 (Fri, 18 Apr 2008)
Log Message:
-----------
fixed a bug for datagen.sh
Modified Paths:
--------------
misc/data/datagen.sh
Modified: misc/data/datagen.sh
===================================================================
--- misc/data/datagen.sh 2008-04-18 06:24:20 UTC (rev 110)
+++ misc/data/datagen.sh 2008-04-18 07:33:04 UTC (rev 111)
@@ -1,7 +1,8 @@
#!/bin/sh
+
#set -x
-ROW_SIZE=1000
-ROW_NUM=100
+ROW_SIZE=40
+ROW_NUM=3
MYSQL="/usr/local/mysql/bin/mysql -uroot --default-character-set=utf8 dict "
@@ -44,21 +45,21 @@
RAITO_SUM=`expr $RAITO_SUM + ${RAITO[$i]}`
i=`expr $i + 1`
done
- DICE=`expr $RANDOM % $RAITO_SUM`
}
TABLE=
ID=
get_table_and_id() {
i=0
+ DICE=`expr $RANDOM % $RAITO_SUM`
while test $i -lt 25
do
if [ $DICE -lt ${RAITO[$i]} ]
then
TABLE=${TABLE_LIST[$i]}
# TODO: should calculate more correctly
- ID=`expr $RANDOM % ${TABLE_ROWS[$i]}`
- break
+ ID=`expr $RANDOM % ${TABLE_ROWS[$i]} + 1`
+ i=25
else
DICE=`expr $DICE - ${RAITO[$i]}`
i=`expr $i + 1`
@@ -77,8 +78,8 @@
WORD=`echo $RESULT | awk '{print $2}'`
}
+STRING=
CUR_SIZE=0
-STRING=
get_string() {
while test $CUR_SIZE -lt $ROW_SIZE
do
@@ -86,10 +87,12 @@
get_word
STRING=${STRING}${WORD}
CUR_SIZE=`expr $CUR_SIZE + $SIZE`
+ TABLE=""
+ ID=""
done
}
-#echo "***** main() *****"
+# main logic
CUR_ROW_NUM=0
load_table_rows
get_raito_sum
@@ -97,6 +100,7 @@
do
get_string
echo $STRING
+ STRING=""
+ CUR_SIZE=0
CUR_ROW_NUM=`expr $CUR_ROW_NUM + 1`
done
-#echo "***** main() *****"