insertDataV1.sim

sql connect

print ================ insert data
$dbNamme  = d0
$tbPrefix = ct
$tbNum    = 10
$rowNum   = 100
$tstart   = 1640966400000  # 2022-01-01 00:00:00.000

sql use $dbNamme

$loop_cnt = 0

loop_insert:
print ====> loop $loop_cnt insert
$loop_cnt = $loop_cnt + 1

$i = 0
while $i < $tbNum
  $tb = $tbPrefix . $i

  $x = 0
  while $x < $rowNum
    $binary = ' . binary
    $binary = $binary . $i
    $binary = $binary . '

    #print ====> insert into $tb values ($tstart , $i , $x , $binary )
    #print ====> insert into ntb values ($tstart , $i , $x , $binary )
    sql insert into $tb values ($tstart , $i , $x , $binary )
    sql insert into ntb values ($tstart , 999 , 999 , 'binary-ntb' )
    $tstart = $tstart + 1
    $x = $x + 1
  endw
  
  print ====> insert rows: $rowNum into $tb and ntb

  $i = $i + 1
#  $tstart = 1640966400000
endw
goto loop_insert