import_file.sim

system sh/stop_dnodes.sh

system sh/deploy.sh -n dnode1 -i 1
system sh/cfg.sh -n dnode1 -c walLevel -v 1
system sh/exec.sh -n dnode1 -s start
sleep 500
sql connect
sleep 500

sql drop database if exists indb
sql create database if not exists indb
sql use indb

$inFileName = '~/data.csv'
$numOfRows = 10000
system general/parser/gendata.sh

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 '~/data.sql'

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 ~/data.sql

system sh/exec.sh -n dnode1 -s stop -x SIGINT