generate sql data code example

Example 1: generating random test data

Mostly I get test data from PO however if 
I need to generate any test data:

	For UI Part : I use "Faker dependency" on Selenium
	
    For API Part: I use "https://www.mockaroo.com/" ==>
    generates multiple format (CSV, JSON, XML, etc)

Example 2: sql insert data

INSERT INTO users (first_name, last_name, address, email)
VALUES (‘Tester’, ‘Jester’, ‘123 Fake Street, Sheffield, United
Kingdom’, ‘[email protected]’);

Example 3: how to generate test data

When=> sprint planning meeting
	Who=> Mostly I get test data from PO
    However in some instances, especially in 
    negative test scenario I may need to 
    generate test data.
    I use java faker to generate data
	How => Faker faker=new Faker();
    or String manupilation(substring concatination etc.)
	I store it  at SharePoint. Saved in my project
    in xls type under data package 

    For API Part: I use "https://www.mockaroo.com/" ==>
    generates multiple format (CSV, JSON, XML, etc)