-- Insert new ekey_users records
require('dbenv')
db = dbenv:new()

-- allowed value <= 200
local max_user_records = 20    

user_records_counted = db:getone('SELECT COUNT(*) FROM ekey_users')
user_records_counted = tonumber(user_records_counted) or 0

if user_records_counted < max_user_records then
  local query = [[
    INSERT INTO ekey_users (id, name, description,
      F0action, F1action, F2action, F3action, F4action,
      F5action, F6action, F7action, F8action, F9action,
      F10action, F11action, F12action)
    VALUES (?, ?, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)
  ]]
  -- create users
  for i = user_records_counted + 1, max_user_records do
    db:query(query, i, string.format('User #%03d', i))
  end

  alert('New user records inserted:  ' .. (user_records_counted + 1) .. ' .. ' .. max_user_records)
 
else 
  alert('No user records inserted:  Already exists ' .. user_records_counted .. ' records')

end

db:close()