KDVaznvM

1DO
2  $do$
3      DECLARE startValue integer := 41;
4      DECLARE endValue integer := 60;
5      DECLARE counter integer;
6      DECLARE prefix text = 'bonotox';
7    BEGIN
8      counter := startValue;
9      LOOP exit when counter > endValue;
10        insert into hq_user(id, username, email, fullname, password, created_by, created_at)
11        values (uuid_in(md5(random()::text || clock_timestamp()::text)::cstring),
12                prefix || counter::text,
13                prefix || counter::text || '@gmail.com',
14                prefix || ' ' || counter::text,
15                '$2a$13$1deVQiyDP9Edg8L44jPbP.bzO3WdtOFippfMnSMdMHEtIBtYP7JcS',
16                'dinhnguyen', now());
17        counter := counter + 1;
18      END LOOP;
19    END;
20$do$;