# # COPYRIGHT Javelin/Felstar 2001, ALL RIGHTS RESERVED # # Property file for JobsHive #GENERATOR ########################################## EmptyAsNull=true findByPrimaryKey.useCache=true verbose=false stopOnExit=false stopOnError=false #GENERATE IN THIS DIRECTORY pathName=d:/jobsite/web-inf/classes #PACKAGES $CREATOR=$SELF=$INTERFACE,\ $SELFBean=$BEANEX.$SELF,\ $SELFHome=$HOME,\ $SELFSession=$SESSION,\ $SELFValidator=$VALIDATOR,\ Lazy$SELFBean=$LAZYBEAN.$SELFBean,\ Jdbc$SELFHome=$JDBCHOME.$SELFHome,\ Jdbc$SELFSession=$JDBCSESSION.$SELFSession,\ $SELFHolder=$HOLDER.$SELF, $USERCREATOR=$SELF=$USERINTERFACE,\ $SELFBean=$BEANEX.$SELF,\ $SELFHome=$HOME,\ $SELFSession=$SESSION,\ $SELFValidator=$VALIDATOR,\ Lazy$SELFBean=$LAZYBEAN.$SELFBean,\ Jdbc$SELFHome=$JDBCHOME.$SELFHome,\ Jdbc$SELFSession=$JDBCSESSION.$SELFSession,\ $SELFHolder=$HOLDER.$SELF, $ENUMCREATOR=$SELF=$ENUMERATEDTYPE $OBJECTCREATOR=$SELF=$OBJECTCLASS $GENERATOR=com.javelin.generator $PACKAGE=com.jobshive $UIPACKAGE=$PACKAGE.ui $HOLDER=public class $UIPACKAGE $BEANS=com.javelin.beans $JPOOL=com.javelin.util.jdbc $INTERFACE=public interface $PACKAGE.$THIS extends $BEANS.Bean java.lang.Cloneable $USERINTERFACE=$INTERFACE $PACKAGE.User $OBJECTINTERFACE=public interface $PACKAGE.$THIS $OBJECTEX=public class $PACKAGE.$THIS implements $PACKAGE $BEANEX=public class $PACKAGE.$THIS extends $BEANS.AbstractBean implements $PACKAGE $ENUMERATEDTYPE=public class $PACKAGE.$THIS extends $BEANS.AbstractEnumeratedType $VALIDATOR=public class $PACKAGE.$THIS extends $BEANS.AbstractBeanValidator $HOME=public interface $PACKAGE.$THIS extends $BEANS.BeanHome $SESSION=public interface $PACKAGE.$THIS extends $BEANS.BeanSession $LAZYBEAN=public class $PACKAGE.lazy.$THIS extends $PACKAGE $JDBCHOME=public class $PACKAGE.jdbc.$THIS extends $BEANS.jdbc.JdbcHome implements $PACKAGE $JDBCSESSION=public class $PACKAGE.jdbc.$THIS extends $BEANS.JdbcSession implements $PACKAGE #READ FROM DATABASE reader.0=$GENERATOR.jdbc.JdbcReader #GENERATE THESE FILES writer.0=$GENERATOR.beans.BeanInterfaceWriter writer.1=$GENERATOR.beans.BeanClassWriter writer.2=$GENERATOR.beans.LazyBeanClassWriter writer.3=$GENERATOR.beans.ObjectClassWriter writer.4=$GENERATOR.beans.HomeInterfaceWriter writer.5=$GENERATOR.beans.SessionInterfaceWriter writer.6=$GENERATOR.beans.EnumeratedTypeWriter writer.7=$GENERATOR.beans.ValidatorClassWriter writer.8=$GENERATOR.beans.ClassContextWriter writer.9=$GENERATOR.jdbc.JdbcKeyWriter writer.10=$GENERATOR.jdbc.JdbcHomeClassWriter writer.11=$GENERATOR.jdbc.JdbcWriter writer.12=$GENERATOR.jdbc.JdbcDeleteDataWriter writer.13=$GENERATOR.jdbc.JdbcDropObjectsWriter writer.14=$GENERATOR.jdbc.JdbcSessionWriter writer.15=$PACKAGE.writers.JspFragmentWriter jspFragmentPathName=elements/generated jspLibraryPathName=Library jspRootPathName=d:/jobsite jspUIPackage=$UIPACKAGE writer.16=$PACKAGE.writers.HolderClassWriter # BEAN DEFINITIONS ########################################## #KeyTable KeyTable=com.jobshive useIterator=true #Class Context $PROJECTNAME=JobsHive Context=public class $PACKAGE.$PROJECTNAMEContext extends $BEANS.AbstractClassContext Context.code.0=System.getProperties().put("user.timezone","Europe/London"); Context.code.1=System.getProperties().put("java.protocol.handler.pkgs","com.sun.net.ssl.internal.www.protocol"); Context.code.2= Context.code.3=$JPOOL.JPool.setRelativeClass( $PROJECTNAMEContext.class ); #Header Copyright=Copyright Javelinsoft/Felstar Ltd, All rights reserved. Version=JobsHive - Java 1.0 Author=Javelin/Felstar Software #AUTOMATICALLY CREATE THE INDEXs for Keys index=key #DATA TYPES $NON_NEGATIVE=% >= 0 {The % cannot be >= 0} $NON_POSITIVE=% <= 0 {The % cannot be <= 0} $POSITIVE=% > 0 {The % cannot be > 0} $NEGATIVE=% < 0 {The % cannot be < 0} # DATABASE ########################################## source=jobshive source.read=false #sybase,oracle,ms,ibm target=jobshive target.vendor=ms target.pathName=/com/jobshive jobshive.pathName=/com/jobshive tableType=TABLE # TABLES $CLIENT=$SELF2.$SELF4.client $TOOLTIP=$CLIENT.comment $LABELNAME=$CLIENT.labelname $PASSWORD=$CLIENT.password=true $FORM.edit=$CLIENT.form.edit=true $FORM.new=$CLIENT.form.new=true # READONLY means that we don't set the property via the UI, although the bean itself might well have a set $READONLY=$CLIENT.readOnly=true $NOTINHOLDER=$CLIENT.notInDefaultHolder=true $DEFAULT=$CLIENT.default $MULTILINE=$CLIENT.multiline # $CLIENT.width=0 means make the field size similar to the field maxlength. Other values set to specific size. $SIZETOFIT=$CLIENT.width=0 # OPTIONALSET tells the JspFragmentWriter to only do a set on a bean method if it is not null # allows you to turn off individual set calls inside a Holder.set(Bean) method $OPTIONALSET=$CLIENT.optionalset=true $INTERNALCOMMENT=$SELF2.$SELF4.internalComment $TABLEFORM=$SELF2.client.form readTable.0=Candidate #Candidate.client.form.edit2=true readColumn.Candidate.0=candidateKey INT PRIMARY KEY readColumn.Candidate.1=availableDate DATE NULL readColumn.Candidate.2=suspended BIT NOT NULL $CREATE $NOTINHOLDER readColumn.Candidate.3=permanent BIT NOT NULL $CREATE $TOOLTIP=Will consider permanent work readColumn.Candidate.4=contractor BIT NOT NULL $CREATE $TOOLTIP=Will consider contract work readColumn.Candidate.5=teleWorker BIT NOT NULL $CREATE $TOOLTIP=Desire to telework readColumn.Candidate.6=ir35 BIT NOT NULL $CREATE $TOOLTIP=Desire for an ir35 contract,$LABELNAME=IR35 readColumn.Candidate.7=lastActivity DATETIME NULL Candidate.lastActivity.default=new Timestamp(new java.util.Date().getTime()) readColumn.Candidate.8=lastContactActivity DATETIME NULL readColumn.Candidate.9=companyName VARCHAR(30) NULL $CREATE $TOOLTIP=If contracting it is the name of the limited company readColumn.Candidate.10=title VARCHAR(30) NULL readColumn.Candidate.11=euCitizenPermit BIT NOT NULL $CREATE $TOOLTIP=EU Citizen or valid work permit held readColumn.Candidate.12=citizenship CHAR(2) NULL Candidate.citizenship.type=Country readColumn.Candidate.13=minWage DOUBLE NULL $CREATE $SIZETOFIT readColumn.Candidate.14=minRate DOUBLE NULL $CREATE $SIZETOFIT readColumn.Candidate.15=minContractLength INT NULL readColumn.Candidate.16=offeredSkills VARCHAR(100) NULL readColumn.Candidate.17=currentLocation VARCHAR(50) NULL readColumn.Candidate.18=soughtLocation VARCHAR(50) NULL readColumn.Candidate.19=pictureURL VARCHAR(250) NULL readColumn.Candidate.20=emailAddress VARCHAR(100) NOT NULL readColumn.Candidate.21=password VARCHAR(16) NOT NULL $CREATE $PASSWORD,$OPTIONALSET readColumn.Candidate.22=passwordHint VARCHAR(50) NULL $CREATE $LABELNAME=Hint readColumn.Candidate.23=firstName VARCHAR(20) NOT NULL readColumn.Candidate.24=surname VARCHAR(30) NOT NULL readColumn.Candidate.25=phoneNumber VARCHAR(20) NULL readColumn.Candidate.26=registrationIP VARCHAR(30) NULL $CREATE $READONLY readColumn.Candidate.27=industry CHAR(2) NULL Candidate.industry.type=Industry readColumn.Candidate.28=savedFileKey INT NULL DEPENDENT SavedFile readColumn.Candidate.29=useEmail BIT NOT NULL $CREATE $TOOLTIP=Send incoming contacts via email Candidate.useEmail.default=true readColumn.Candidate.30=dateTimeStamp TIMESTAMP NOT NULL Candidate.uniqueindex.0=CAN0(emailAddress) Candidate.index.1=CAN1(surname) Candidate=$CREATE $USERCREATOR Candidate.password.invalidRule.0=%.length() < 6 {The % length is less than 6.} Candidate.password.invalidRule.1=%.equals( candidate.getEmailAddress() ) {The % cannost be the same as the Email Address.} Candidate.password.invalidRule.2="password".equals( % ) {The % is too obvious.} readTable.1=Employer readColumn.Employer.0=employerKey INT PRIMARY KEY readColumn.Employer.1=suspended BIT NOT NULL $CREATE $NOTINHOLDER readColumn.Employer.2=emailAddress VARCHAR(100) NOT NULL readColumn.Employer.3=password VARCHAR(16) NOT NULL $CREATE $PASSWORD,$OPTIONALSET readColumn.Employer.4=passwordHint VARCHAR(50) NULL $CREATE $LABELNAME=Hint readColumn.Employer.5=firstName VARCHAR(20) NOT NULL readColumn.Employer.6=surname VARCHAR(30) NOT NULL readColumn.Employer.7=companyName VARCHAR(30) NOT NULL readColumn.Employer.8=phoneNumber VARCHAR(20) NULL readColumn.Employer.9=lastContactActivity DATETIME NULL readColumn.Employer.10=lastActivity DATETIME NULL Employer.lastActivity.default=new Timestamp(new java.util.Date().getTime()) readColumn.Employer.11=registrationIP VARCHAR(30) NULL $CREATE $READONLY readColumn.Employer.12=active BIT NOT NULL $CREATE $NOTINHOLDER Employer.active.default=true readColumn.Employer.13=useEmail BIT NOT NULL $CREATE $TOOLTIP=Send incoming contacts via email Employer.useEmail.default=true readColumn.Employer.14=dateTimeStamp TIMESTAMP NOT NULL Employer.uniqueindex.0=EMP0(emailAddress) Employer.index.1=EMP1(companyName) Employer=$CREATE $USERCREATOR Employer.password.invalidRule.0=%.length() < 6 {The % length is less than 6.} Employer.password.invalidRule.1=%.equals( employer.getEmailAddress() ) {The % cannot be the same as the Email Address.} Employer.password.invalidRule.2="password".equals( % ) {The % is too obvious.} readTable.3=Note readColumn.Note.0=noteKey INT PRIMARY KEY readColumn.Note.1=beanKey INT NOT NULL ASSOCIATES Bean readColumn.Note.2=beanType CHAR(2) NOT NULL readColumn.Note.3=ownerKey INT NOT NULL ASSOCIATES Bean readColumn.Note.4=ownerType CHAR(2) NOT NULL readColumn.Note.5=comment VARCHAR(255) NOT NULL $CREATE $MULTILINE.width=40,$MULTILINE.height=4 #readColumn.Note.6=dateTimeStamp TIMESTAMP NOT NULL # need the next line else it won't know that owner type is an enumerate type of type BeanType # Not needed for the beanType line, as it can quite easily guess the type Note.ownerType.type=BeanType Note.index.0=NOTE1(ownerKey,beanKey) Note=$CREATE $CREATOR BeanType=$CREATE $ENUMCREATOR BeanType.type.0=EMPLOYER,"Er",$PACKAGE.Employer BeanType.type.1=CANDIDATE,"Ca",$PACKAGE.Candidate BeanType.type.2=JOB,"Jo",$PACKAGE.Job BeanType.type.3=ADMIN,"Ad",$PACKAGE.Admin readTable.4=Bean Bean=public class com.javelin.beans.Bean Bean.write=false readTable.5=Contact readColumn.Contact.0=contactKey INT PRIMARY KEY readColumn.Contact.1=fromKey INT NOT NULL ASSOCIATES Bean readColumn.Contact.2=fromType CHAR(2) NOT NULL Contact.fromType.type=BeanType readColumn.Contact.3=toKey INT NOT NULL ASSOCIATES Bean readColumn.Contact.4=toType CHAR(2) NOT NULL Contact.toType.type=BeanType readColumn.Contact.5=jobKey INT NOT NULL DEPENDENTS Job readColumn.Contact.6=sentAt DATETIME NULL $CREATE $READONLY Contact.sentAt.default=new Timestamp(new java.util.Date().getTime()) readColumn.Contact.7=readAt DATETIME NULL $CREATE $READONLY readColumn.Contact.8=hiddenFromSender BIT NOT NULL $CREATE $READONLY readColumn.Contact.9=hiddenFromReader BIT NOT NULL $CREATE $READONLY readColumn.Contact.10=comment VARCHAR(100) NOT NULL $CREATE $MULTILINE.width=50,$MULTILINE.height=2 Contact.index.0=CONTACT1(fromKey,toKey) Contact.index.1=CONTACT2(jobKey,fromKey) Contact.index.2=CONTACT3(jobKey,toKey) Contact.pseudoindex.0=inbox(toKey,hiddenFromReader=False) Contact.inbox.count=true Contact.inbox.find=false Contact.pseudoindex.1=sentInLastDay(fromKey,sentAt>getDate()-1) Contact.pseudoindex.2=sent(fromKey,hiddenFromSender=false) Contact.sent.count=true Contact.sent.find=false #Contact.pseudoindex.1=sentInLastDay(fromKey,sentAt>currentDate-1) #Contact.method.toAndHiddenFromReader=inbox # Contact=$CREATE $CREATOR readTable.2=Job readColumn.Job.0=jobKey INT PRIMARY KEY readColumn.Job.1=employerKey INT NOT NULL DEPENDENTS Employer readColumn.Job.2=jobTitle VARCHAR(30) NOT NULL readColumn.Job.3=timePosted DATETIME NULL \ $CREATE $DEFAULT=new Timestamp(new java.util.Date().getTime()),$READONLY Job.timePosted.default=new Timestamp(new java.util.Date().getTime()) readColumn.Job.4=jobDescription VARCHAR(255) NOT NULL $CREATE $MULTILINE.width=60,$MULTILINE.height=4,$TOOLTIP=What this job entails readColumn.Job.5=skillsNeeded VARCHAR(100) NOT NULL readColumn.Job.6=minWageOffered DOUBLE NULL #readColumn.Job.6=minWageOffered DOUBLE NULL readColumn.Job.7=maxWageOffered DOUBLE NULL readColumn.Job.8=minRateOffered DOUBLE NULL readColumn.Job.9=maxRateOffered DOUBLE NULL readColumn.Job.10=location VARCHAR(100) NULL $CREATE $TOOLTIP=Town County would be useful readColumn.Job.11=teleWorking BIT NOT NULL readColumn.Job.12=ir35Friendly BIT NOT NULL $CREATE $LABELNAME=IR35 Friendly readColumn.Job.13=jobStart DATE NULL readColumn.Job.14=hidden BIT NOT NULL $CREATE $NOTINHOLDER readColumn.Job.15=suspended BIT NOT NULL $CREATE $NOTINHOLDER readColumn.Job.16=emailReplyAddress VARCHAR(100) NULL readColumn.Job.17=industry CHAR(2) NULL Job.industry.type=Industry readColumn.Job.18=dateTimeStamp TIMESTAMP NOT NULL #Job.client.form.searchJobResults=location,jobTitle #Job.client.form.showJob=emailAddress,companyName,firstName,surname,permanent, contractor, teleWorker,ir35, euCitizenPermit, availableDate, minWage,minRate, currentLocation,soughtLocation, offeredSkills,title, citizenship Job=$CREATE $CREATOR readTable.6=SavedFile readColumn.SavedFile.0=savedFileKey INT PRIMARY KEY readColumn.SavedFile.1=clientName VARCHAR(30) NOT NULL $CREATE $INTERNALCOMMENT=Original filename from client readColumn.SavedFile.2=mimeType VARCHAR(30) NOT NULL $CREATE $INTERNALCOMMENT=The mime type from the client SavedFile.mimeType.bound=false readColumn.SavedFile.3=fileName VARCHAR(30) NOT NULL $CREATE $INTERNALCOMMENT=the filename of the file on disk readColumn.SavedFile.4=dateTimeStamp TIMESTAMP NOT NULL SavedFile=$CREATE $CREATOR readTable.7=JobSearch readColumn.JobSearch.0=jobSearchKey INT PRIMARY KEY readColumn.JobSearch.1=candidateKey INT NOT NULL ASSOCIATES Candidate readColumn.JobSearch.2=location VARCHAR(100) NULL readColumn.JobSearch.3=skillsNeeded VARCHAR(100) NULL readColumn.JobSearch.4=minWageOffered DOUBLE NULL $CREATE $LABELNAME=Min Wage readColumn.JobSearch.5=minRateOffered DOUBLE NULL $CREATE $LABELNAME=Min Rate readColumn.JobSearch.6=ir35Friendly BIT NULL $CREATE $LABELNAME=IR35 Friendly readColumn.JobSearch.7=teleWorking BIT NULL readColumn.JobSearch.8=industryType CHAR(2) NULL JobSearch.industryType.type=Industry readColumn.JobSearch.9=name VARCHAR(20) NOT NULL JobSearch=$CREATE $CREATOR readTable.8=CandidateSearch readColumn.CandidateSearch.0=candidateSearchKey INT PRIMARY KEY readColumn.CandidateSearch.1=employerKey INT NOT NULL ASSOCIATES Employer readColumn.CandidateSearch.2=permanent BIT NULL readColumn.CandidateSearch.3=contractor BIT NULL readColumn.CandidateSearch.4=ir35Friendly BIT NULL $CREATE $LABELNAME=IR35 Friendly readColumn.CandidateSearch.5=euCitizenPermit BIT NULL readColumn.CandidateSearch.6=minWageOffered DOUBLE NULL $CREATE $LABELNAME=Min Wage readColumn.CandidateSearch.7=minRateOffered DOUBLE NULL $CREATE $LABELNAME=Min Rate readColumn.CandidateSearch.8=soughtLocation VARCHAR(100) NULL readColumn.CandidateSearch.9=offeredSkills VARCHAR(100) NULL readColumn.CandidateSearch.10=industryType CHAR(2) NULL CandidateSearch.industryType.type=Industry readColumn.CandidateSearch.11=name VARCHAR(20) NOT NULL CandidateSearch=$CREATE $CREATOR readTable.9=Admin readColumn.Admin.0=adminKey INT PRIMARY KEY readColumn.Admin.1=emailAddress VARCHAR(100) NOT NULL readColumn.Admin.2=password VARCHAR(16) NOT NULL $CREATE $PASSWORD,$OPTIONALSET readColumn.Admin.3=passwordHint VARCHAR(50) NULL $CREATE $LABELNAME=Hint readColumn.Admin.4=firstName VARCHAR(20) NOT NULL readColumn.Admin.5=surname VARCHAR(30) NOT NULL readColumn.Admin.6=dateTimeStamp TIMESTAMP NOT NULL Admin.uniqueindex.0=ADMIN0(emailAddress) Admin=$CREATE $USERCREATOR Admin.password.invalidRule.0=%.length() < 6 {The % length is less than 6.} Admin.password.invalidRule.1=%.equals( admin.getEmailAddress() ) {The % cannost be the same as the Email Address.} Admin.password.invalidRule.2="password".equals( % ) {The % is too obvious.} #Job.client.form.searchJob=location, skillsNeeded,teleWorking,minWageOffered, minRateOffered,ir35Friendly #Job.client.form.searchJob.minWageOffered.labelname=Min Wage # ENUMERATED TYPES ########################################## Country=$CREATE $ENUMCREATOR Country.type.0=CANADA,"CA",Canada Country.type.1=FRANCE,"FR",France Country.type.2=GERMANY,"DE",Germany Country.type.3=GREAT_BRITAIN,"GB",Great Britain Country.type.4=ITALY,"IT",Italy Country.type.5=JAPAN,"JP",Japan Country.type.6=SPAIN,"SP",Spain Country.type.7=SWITZERLAND,"CH",Switzerland Country.type.8=USA,"US",United States Country.find.0=all,CANADA,FRANCE,GERMANY,GREAT_BRITAIN,ITALY,JAPAN,SPAIN,SWITZERLAND,USA Industry=$CREATE $ENUMCREATOR Industry.type.0=IT,"IT",IT/Computers Industry.type.1=ACCOUNTANCY,"AC",Accountancy Industry.type.2=MEDIA,"ME",Media Candidate.primaryName=surname Employer.primaryName=companyName Admin.primaryName="ADMIN "+surname Job.primaryName=jobTitle JobSearch.primaryName=name CandidateSearch.primaryName=name # BEAN #####################################################################################