How to skip due diligent and eKYC when onboarding¶

To enable onboarding testing without performing real KYC,
by inserting mock onboarding data into the database in advance.

Content¶

Please follow this order strictly:

1. Create an account through Web Trade
2. Log in and retrieve the user_id from JWT
3. Update all required variables in the SQL script
4. Run the SQL script on the database : onboarding_service
5. Proceed with onboarding via Web or Mobile

Require Variables¶

DO $$
DECLARE
    _user_id text := value;
    _id_number text := value;
    _email text :=  value; 
    _mobile text := value;
	_fullname_th text := value 
	_fullname_en text := value
	_laser_code text := value
	_serial_number text := value
	_idcard_address text := value
	_date_birth_en text := value
	_date_birth_th text := value
	_date_issue_en text:= value
	_date_issue_th text:= value
	_date_expire_en text:= value
	_date_expire_th text:= value
    _pre_member_id uuid := gen_random_uuid();
    _verification_id uuid := gen_random_uuid();
    _appman_id uuid := gen_random_uuid();
    _idcard_id uuid := gen_random_uuid();
BEGIN
    INSERT INTO pre_members (
        id, email, mobile, member_id, user_id, created_at, updated_at
    ) VALUES (
        _pre_member_id, _email, _mobile, _user_id, NULL, NOW(), NOW()
    );
    INSERT INTO appman (
        id, member_id, verification_id, is_front_id_card, is_back_id_card,
        is_liveness, is_recognition, status,verified_status, type,dopa_status,face_similarity, created_at, updated_at
    ) VALUES (
        _appman_id, _user_id, _verification_id, TRUE, TRUE, TRUE, TRUE,
        'completed',TRUE,1,TRUE,99,  NOW(), NOW()
    );
    INSERT INTO appman_idcard (
        id, member_id, verification_id, id_number, address_th,
        full_name_th, full_name_en, serial_number, created_at, updated_at, laser_code,
		date_birth_en,date_birth_th,date_issue_en,date_issue_th,date_expire_en,date_expire_th
    ) VALUES (
        _idcard_id, _user_id, _verification_id, _id_number,
        _idcard_address,
        _fullname_th,
        _fullname_en,
       _serial_number,
        NOW(), NOW(), _laser_code,
		_date_birth_en,
		_date_birth_th,
		_date_issue_en,
		_date_issue_th,
		_date_expire_en,
		_date_expire_th
    );
END $$;

2.Proceed with onboarding until

3.run sql script

update customer_details set type = 1 where member_id ='115';

onboarding process is done

4. approve with admin