Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use User method of package.carina.demo.DBSampleTest class

Best Carina code snippet using package.carina.demo.DBSampleTest.User

Source:DBSampleTest.java

...18import static org.testng.Assert.assertNull;19import org.apache.ibatis.session.SqlSession;20import org.testng.annotations.Test;21import com.qaprosoft.carina.core.foundation.AbstractTest;22import solvd.com.carina.demo.db.mappers.UserMapper;23import solvd.com.carina.demo.db.mappers.UserPreferenceMapper;24import solvd.com.carina.demo.db.models.User;25import solvd.com.carina.demo.db.models.User.Status;26import solvd.com.carina.demo.utils.ConnectionFactory;27import solvd.com.carina.demo.db.models.UserPreference;28/**29 * This sample shows how create DB test.30 * 31 * @author qpsdemo32 */33public class DBSampleTest extends AbstractTest {34	private static User USER = new User() {35		{36			setUsername("bmarley");37			setFirstName("Bob");38			setLastName("Marley");39			setStatus(Status.ACTIVE);40		}41	};42	private static UserPreference USER_PREFERENCE = new UserPreference() {43		{44			setName(Name.DEFAULT_DASHBOARD);45			setValue("Default");46		}47	};48	@Test49	public void createUser() {50		try (SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession(true)) {51			UserMapper userMapper = session.getMapper(UserMapper.class);52			userMapper.create(USER);53			checkUser(userMapper.findById(USER.getId()));54		}55	}56	@Test(dependsOnMethods = "createUser")57	public void createUserPreference() {58		try (SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession(true)) {59			UserMapper userMapper = session.getMapper(UserMapper.class);60			UserPreferenceMapper userPreferenceMapper = session.getMapper(UserPreferenceMapper.class);61			USER_PREFERENCE.setUserId(USER.getId());62			userPreferenceMapper.create(USER_PREFERENCE);63			checkUserPreference(userMapper.findById(USER.getId()).getPreferences().get(0));64		}65	}66	@Test(dependsOnMethods = "createUserPreference")67	public void updateUser() {68		try (SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession(true)) {69			UserMapper userMapper = session.getMapper(UserMapper.class);70			USER.setUsername("rjohns");71			USER.setFirstName("Roy");72			USER.setLastName("Johns");73			USER.setStatus(Status.INACTIVE);74			userMapper.update(USER);75			checkUser(userMapper.findById(USER.getId()));76		}77	}78	@Test(dependsOnMethods = "updateUser")79	public void deleteUser() {80		try (SqlSession session = ConnectionFactory.getSqlSessionFactory().openSession(true)) {81			UserMapper userMapper = session.getMapper(UserMapper.class);82			userMapper.delete(USER);83			assertNull(userMapper.findById(USER.getId()));84		}85	}86	private void checkUser(User user) {87		assertEquals(user.getUsername(), USER.getUsername(), "User name must match");88		assertEquals(user.getFirstName(), USER.getFirstName(), "First name must match");89		assertEquals(user.getLastName(), USER.getLastName(), "Last name must match");90		assertEquals(user.getEmail(), USER.getEmail(), "Email must match");91	}92	private void checkUserPreference(UserPreference userPreference) {93		assertEquals(userPreference.getName(), USER_PREFERENCE.getName(), "Preference name must match");94		assertEquals(userPreference.getValue(), USER_PREFERENCE.getValue(), "Preference value must match");95		assertEquals(userPreference.getUserId(), USER_PREFERENCE.getUserId(), "Preference user id must match");96	}97}...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.