@isTest
private class SoqlHelperTest {
    static testMethod void testMethod1() {
    	String sql = 'SELECT Id,Name FROM Contact WHERE Name != null Limit 1';
    	Account accupdate = TestDataUtility.CreateAccounts(1)[0];
    	accupdate.Name = 'update1';
    	List<Account> updateAccList = new List<Account>();

    	Profile p = [select Id from Profile where id =:System.Label.ProfileId_SystemAdmin];
    	User hpOwner = new User(Test_staff__c = true, LastName = 'TestUserA', FirstName = 'owner', Alias = 'hp', CommunityNickname = 'hpOwner', Email = 'olympus_hpowner@sunbridge.com', Username = 'olympus_hpowner@sunbridge.com', IsActive = true, EmailEncodingKey = 'ISO-2022-JP', TimeZoneSidKey = 'Asia/Tokyo', LocaleSidKey = 'ja_JP', LanguageLocaleKey = 'ja', ProfileId = p.id);
    	List<User> userList = new List<User>();

    	userList.add(hpOwner);

    	Contact con = TestDataUtility.CreateContacts(1)[0];
    	List<String> conidList = new List<String>();
    	conidList.add(con.Id); 

        Set<String> strSet = new Set<String>();
        strSet.add('test1');
        strSet.add('test2');
        Test.startTest();
        //ToInCondition
        //UpsertList
        SoqlHelper.ToInCondition(strSet);
        SoqlHelper.DistinctQueryFields(sql);
        SoqlHelper.WId(sql);
        SoqlHelper.InsertList(userList);
        SoqlHelper.UpdateList(updateAccList);
        SoqlHelper.DeleteList(updateAccList);
        SoqlHelper.DeleteListAsync(conidList);
        Test.stopTest();

    }
}