import_file.sim

system sh/stop_dnodes.sh
system sh/ip.sh -i 1 -s up
system sh/deploy.sh -n dnode1 -m 192.168.0.1 -i 192.168.0.1
system sh/cfg.sh -n dnode1 -c commitLog -v 0
system sh/exec.sh -n dnode1 -s start
sleep 2000
sql connect
sleep 2000

sql drop database if exists indb

sql create database if not exists indb

sql use indb

$inFileName = '~/data.csv'
$numOfRows = 10000
#system sh/gendata.sh $inFileName $numOfRows  # input file invalid
system sh/gendata.sh ~/data.csv $numOfRows

sql create table tbx (ts TIMESTAMP, collect_area NCHAR(12), device_id BINARY(16), imsi BINARY(16),  imei BINARY(16),  mdn BINARY(10), net_type BINARY(4), mno NCHAR(4), province NCHAR(10), city NCHAR(16), alarm BINARY(2))
print ====== create tables success, starting import data

sql import into tbx file $inFileName

sql select count(*) from tbx
if $rows != 1 then
  return -1
endi
if $data00 != $numOfRows then
  print "expect: $numOfRows, act: $data00"
  return -1
endi


#system rm -f $inFileName     # invalid shell
system rm -f ~/data.csv