#!/usr/bin/env bash

source "$(dirname "$0")/db_common.sh"

run_query "insert into hosts (hostid, host, name, status, description) values (20000, 'dummy host 20000', 'dummy host 20000', 0, 'dummy description');"
run_query "insert into hosts (hostid, host, name, status, description) values (20001, 'dummy host 20001', 'dummy host 20001', 0, 'dummy description');"
run_query "insert into hosts (hostid, host, name, status, description) values (20002, 'dummy host 20002', 'dummy host 20002', 0, 'dummy description');"
run_query "insert into hosts (hostid, host, name, status, description) values (20003, 'dummy host 20003', 'dummy host 20003', 0, 'dummy description');"
run_query "insert into hosts (hostid, host, name, status, description) values (20004, 'dummy host 20004', 'dummy host 20004', 0, 'dummy description');"

run_query "insert into hstgrp (groupid,name,flags,uuid,type) values (1000, 'dummy host group 1000', 0, 'dummy uuid 1000', 0);"
run_query "insert into hstgrp (groupid,name,flags,uuid,type) values (1001, 'dummy host group 1001', 0, 'dummy uuid 1001', 0);"
run_query "insert into hstgrp (groupid,name,flags,uuid,type) values (1002, 'dummy host group 1002', 0, 'dummy uuid 1002', 0);"
run_query "insert into hstgrp (groupid,name,flags,uuid,type) values (1003, 'dummy host group 1003', 0, 'dummy uuid 1003', 0);"
run_query "insert into hstgrp (groupid,name,flags,uuid,type) values (1004, 'dummy host group 1004', 0, 'dummy uuid 1004', 0);"

run_query "insert into hgset (hgsetid, hash) values (100, 'dummy hash 100');"
run_query "insert into hgset (hgsetid, hash) values (101, 'dummy hash 101');"
run_query "insert into hgset (hgsetid, hash) values (102, 'dummy hash 102');"
run_query "insert into hgset (hgsetid, hash) values (103, 'dummy hash 103');"
run_query "insert into hgset (hgsetid, hash) values (104, 'dummy hash 104');"

run_query "insert into hgset_group (hgsetid, groupid) values (100, 1000);"
run_query "insert into hgset_group (hgsetid, groupid) values (101, 1000);"
run_query "insert into hgset_group (hgsetid, groupid) values (102, 1000);"
run_query "insert into hgset_group (hgsetid, groupid) values (103, 1000);"
run_query "insert into hgset_group (hgsetid, groupid) values (104, 1000);"

run_query "insert into users (userid,username,name,surname,passwd,url,autologin,autologout,refresh,rows_per_page,roleid) values ('10','user10','John','Doe10','password','','1','0','30s','50','3')"
run_query "insert into users (userid,username,name,surname,passwd,url,autologin,autologout,refresh,rows_per_page,roleid) values ('11','user11','John','Doe11','password','','1','0','30s','50','3')"
run_query "insert into users (userid,username,name,surname,passwd,url,autologin,autologout,refresh,rows_per_page,roleid) values ('12','user12','John','Doe12','password','','1','0','30s','50','3')"
run_query "insert into users (userid,username,name,surname,passwd,url,autologin,autologout,refresh,rows_per_page,roleid) values ('13','user13','John','Doe13','password','','1','0','30s','50','3')"
run_query "insert into users (userid,username,name,surname,passwd,url,autologin,autologout,refresh,rows_per_page,roleid) values ('14','user14','John','Doe14','password','','1','0','30s','50','3')"

run_query "insert into usrgrp (usrgrpid, name, gui_access, users_status, debug_mode, userdirectoryid,mfa_status,mfaid) values (2000, 'dummy user group 2000', 0, 0, 0, null, 0, null);"
run_query "insert into usrgrp (usrgrpid, name, gui_access, users_status, debug_mode, userdirectoryid,mfa_status,mfaid) values (2001, 'dummy user group 2001', 0, 0, 0, null, 0, null);"
run_query "insert into usrgrp (usrgrpid, name, gui_access, users_status, debug_mode, userdirectoryid,mfa_status,mfaid) values (2002, 'dummy user group 2002', 0, 0, 0, null, 0, null);"
run_query "insert into usrgrp (usrgrpid, name, gui_access, users_status, debug_mode, userdirectoryid,mfa_status,mfaid) values (2003, 'dummy user group 2003', 0, 0, 0, null, 0, null);"
run_query "insert into usrgrp (usrgrpid, name, gui_access, users_status, debug_mode, userdirectoryid,mfa_status,mfaid) values (2004, 'dummy user group 2004', 0, 0, 0, null, 0, null);"

run_query "insert into ugset (ugsetid, hash) values (200, 'dummy hash 200');"
run_query "insert into ugset (ugsetid, hash) values (201, 'dummy hash 201');"
run_query "insert into ugset (ugsetid, hash) values (202, 'dummy hash 202');"
run_query "insert into ugset (ugsetid, hash) values (203, 'dummy hash 203');"
run_query "insert into ugset (ugsetid, hash) values (204, 'dummy hash 204');"

run_query "insert into ugset_group (ugsetid, usrgrpid) values (200, 2000);"
run_query "insert into ugset_group (ugsetid, usrgrpid) values (201, 2000);"
run_query "insert into ugset_group (ugsetid, usrgrpid) values (202, 2000);"
run_query "insert into ugset_group (ugsetid, usrgrpid) values (203, 2000);"
run_query "insert into ugset_group (ugsetid, usrgrpid) values (204, 2000);"

run_query "insert into permission (ugsetid, hgsetid, permission) values (200, 100, 0);"
run_query "insert into permission (ugsetid, hgsetid, permission) values (201, 101, 0);"
run_query "insert into permission (ugsetid, hgsetid, permission) values (202, 102, 0);"
run_query "insert into permission (ugsetid, hgsetid, permission) values (203, 103, 0);"
run_query "insert into permission (ugsetid, hgsetid, permission) values (204, 104, 0);"


# ----------------------------------------------------------------------------------------------------------------------
# optional part
# ----------------------------------------------------------------------------------------------------------------------

run_query "insert into host_hgset (hostid, hgsetid) values (20000, 100);"
run_query "insert into host_hgset (hostid, hgsetid) values (20001, 101);"
run_query "insert into host_hgset (hostid, hgsetid) values (20002, 102);"
run_query "insert into host_hgset (hostid, hgsetid) values (20003, 103);"
run_query "insert into host_hgset (hostid, hgsetid) values (20004, 104);"

run_query "insert into user_ugset (userid, ugsetid) values (10, 200);"
run_query "insert into user_ugset (userid, ugsetid) values (11, 201);"
run_query "insert into user_ugset (userid, ugsetid) values (12, 202);"
run_query "insert into user_ugset (userid, ugsetid) values (13, 203);"
run_query "insert into user_ugset (userid, ugsetid) values (14, 204);"