package com.ibm.websphere.userprofile.beans;

// Finder Helper class
public interface UPBaseChildBeanFinderHelper
{

        // All the query Strings are pointing to table UserProfile.
        // Using Visual Age for Java, you can  map your CMP fields
        // to existing UserProfile table.

         public static String findUserProfilesByPrimaryKeyQueryString="select * from userprofile where username = ?";

         // In base implementation, this String is modified dynamically in the persister class to handle datawrapper
         // extensions adding new columns using UserProfileExtender (i.e. to handle queries by newly added columns
         // when the UserProfile EJB is extended and specified in administrative console, base implementation is not
         // used at all). So for the EJB extensions of UserProfile, this query function is not supported. Thus, the function
         // UPBaseChildBeanHome.findUserProfiles(String,String) is not useful.

         public static String findUserProfilesQueryString="select * from userprofile where newColumn = ? and value = ?";
         public static String findUserProfilesQueryString="select * from userprofile where type = ? and userName = ?";
         public static String findUserProfilesByAddress1QueryString="select * from userprofile where address1=?";
         public static String findUserProfilesByAddress2QueryString="select * from userprofile where address2=?";
         public static String findUserProfilesByNationQueryString="select * from userprofile where nation=?";
         public static String findUserProfilesByDayPhoneQueryString="select * from userprofile where dayPhone=?";
         public static String findUserProfilesByEMailQueryString="select * from userprofile where email=?";
         public static String findUserProfilesByEmployerQueryString="select * from userprofile where employer=?";
         public static String findUserProfilesByFaxQueryString="select * from userprofile where fax=?";
         public static String findUserProfilesByFirstNameQueryString="select * from userprofile where firstname=?";
         public static String findUserProfilesByLanguageQueryString="select * from userprofile where language=?";
         public static String findUserProfilesBySurNameQueryString="select * from userprofile where surname=?";
         public static String findUserProfilesByNightPhoneQueryString="select * from userprofile where nightphone=?";
         public static String findUserProfilesByStateOrProvinceQueryString="select * from userprofile where stateorprovince=?";
         public static String findUserProfilesByCityQueryString="select * from userprofile where city=?";
         public static String findUserProfilesByPostalCodeQueryString="select * from userprofile where postalcode=?";  

}