Source Code for Module wsatools.DbConnect.DbConstants

  1  #------------------------------------------------------------------------------ 
  2  #$Id: DbConstants.py 5292 2008-11-21 16:38:11Z RossCollins $ 
  3  #  Created from WSA_InitiateArchive.sql, 20 Nov 2008 16:09:52 GMT 
  4  """ 
  5     Database constants. DO NOT EDIT THIS FILE! All constants are defined in the 
  6     WSA_InitiateArchive.sql script, alter them there, then run: 
  7     src/parsing/initarch_parse.py on that file, and check result into CVS. 
  8   
  9     @author: N.C. Hambly & E. Sutorius 
 10     @org:    WFAU, IfA, University of Edinburgh 
 11   
 12     @newfield contributors: Contributors, Contributors (Alphabetical Order) 
 13     @contributors: R.S. Collins 
 14  """ 
 15  #------------------------------------------------------------------------------ 
 16   
 17 -def intDefault(): 
 18      return -99999999 
 19   
 20 -def realDefault(): 
 21      return -0.9999995e9 
 22   
 23 -def floatDefault(): 
 24      return -0.9999995e9 
 25   
 26 -def smallIntDefault(): 
 27      return -9999 
 28   
 29 -def tinyIntDefault(): 
 30      return 0 
 31   
 32 -def dateTimeDefault(): 
 33      return '31-Dec-9999' 
 34   
 35 -def charDefault(): 
 36      return 'NONE' 
 37   
 38 -def commissioningProgrammeID(): 
 39      return 1 
 40   
 41 -def nonSurveyProgrammeOffset(): 
 42      return 10000 
 43   
 44 -def nonSurveyProprietaryPeriod(): 
 45      return 12 
 46   
 47 -def ukidssSurveyID(): 
 48      return 1 
 49   
 50 -def ukidssLasProgrammeID(): 
 51      return 101 
 52   
 53 -def ukidssGpsProgrammeID(): 
 54      return 102 
 55   
 56 -def ukidssGcsProgrammeID(): 
 57      return 103 
 58   
 59 -def ukidssDxsProgrammeID(): 
 60      return 104 
 61   
 62 -def ukidssUdsProgrammeID(): 
 63      return 105 
 64   
 65 -def ptsProgrammeID(): 
 66      return 106 
 67   
 68 -def calibrationProgrammeID(): 
 69      return 200 
 70   
 71 -def neighbourJoinCriterion(): 
 72      return 2.777777777778e-3 
 73   
 74 -def multiframeUIDAttributeName(): 
 75      return 'multiframeID' 
 76   
 77 -def shallowFrameSetTolerance(): 
 78      return 0.016667 
 79   
 80 -def adjacentFrameTolerance(): 
 81      return 0.35 
 82   
 83 -def worldSurveyID(): 
 84      return 2 
 85   
 86 -def sdssSourceTableName(): 
 87      return 'PhotoObj' 
 88   
 89 -def twomassSourceTableName(): 
 90      return 'twomass_psc' 
 91   
 92 -def twomassExtSourceTableName(): 
 93      return 'twomass_xsc' 
 94   
 95 -def usnobSourceTableName(): 
 96      return 'usnob_psc' 
 97   
 98 -def rosatBrightSourceTableName(): 
 99      return 'rosat_bsc' 
100   
101 -def rosatFaintSourceTableName(): 
102      return 'rosat_fsc' 
103   
104 -def firstSourceTableName(): 
105      return 'firstSource' 
106   
107 -def irasSourceTableName(): 
108      return 'iras_psc' 
109   
110 -def ssaSourceTableName(): 
111      return 'Source' 
112   
113 -def glimpseHRCSourceTableName(): 
114      return 'glimpse_hrc_inter' 
115   
116 -def glimpseMCASourceTableName(): 
117      return 'glimpse_mca_inter' 
118   
119 -def glimpse1HRCSourceTableName(): 
120      return 'glimpse1_hrc' 
121   
122 -def glimpse1MCASourceTableName(): 
123      return 'glimpse1_mca' 
124   
125 -def glimpse2HRCSourceTableName(): 
126      return 'glimpse2_hrc' 
127   
128 -def glimpse2MCASourceTableName(): 
129      return 'glimpse2_mca' 
130   
131 -def mgcDetectionTableName(): 
132      return 'mgcDetection' 
133   
134 -def nvssSourceTableName(): 
135      return 'nvssSource' 
136   
137 -def loadServerRwUsername(): 
138      return 'ldservrw' 
139   
140 -def loadServerRoUsername(): 
141      return 'ldservro' 
142   
143 -def loadServerDbsOwner(): 
144      return 'dbo' 
145   
146 -def loadServerWfcamDatabase(): 
147      return 'WSA' 
148   
149 -def programmeTable(): 
150      return 'ProgrammeTable' 
151   
152 -def externalProgrammeTable(): 
153      return 'ExternalSurveyTable' 
154   
155 -def archiveCurationHistoryTableName(): 
156      return 'ArchiveCurationHistory' 
157   
158 -def curationEventUIDAttributeName(): 
159      return 'cuEventID' 
160   
161 -def programmeCurationHistoryTableName(): 
162      return 'ProgrammeCurationHistory' 
163   
164 -def newlyIngestedFlagAttributeName(): 
165      return 'newlyIngested' 
166   
167 -def releaseTableName(): 
168      return 'Release' 
169   
170 -def yes(): 
171      return 1 
172   
173 -def no(): 
174      return 0 
175