| 1 | db = DAL("sqlite://storage.sqlite") |
|---|
| 2 | |
|---|
| 3 | db.define_table('closures', |
|---|
| 4 | Field('closureid'), |
|---|
| 5 | Field('lognum'), |
|---|
| 6 | Field('route'), |
|---|
| 7 | Field('direction'), |
|---|
| 8 | Field('facility'), |
|---|
| 9 | Field('startdate',length=8, comment="Must be stored as YYYYMMDD"), |
|---|
| 10 | Field('enddate',length=8, comment="Must be stored as YYYYMMDD"), |
|---|
| 11 | Field('starttime',length=4, comment="Must be stored as HHMM"), |
|---|
| 12 | Field('endtime',length=4, comment="Must be stored as HHMM"), |
|---|
| 13 | Field('startcounty'), |
|---|
| 14 | Field('endcounty'), |
|---|
| 15 | Field('startlocation'), |
|---|
| 16 | Field('endlocation'), |
|---|
| 17 | Field('closuretype'), |
|---|
| 18 | Field('worktype'), |
|---|
| 19 | Field('estdelay'), |
|---|
| 20 | Field('tmpcozeep'), |
|---|
| 21 | Field('tmpdetour'), |
|---|
| 22 | Field('supervisor'), |
|---|
| 23 | Field('fieldrep'), |
|---|
| 24 | Field('meetingplace'), |
|---|
| 25 | Field('reason'), |
|---|
| 26 | Field('remarks'), |
|---|
| 27 | Field('s1097date'), |
|---|
| 28 | Field('s1097time'), |
|---|
| 29 | Field('s1097user'), |
|---|
| 30 | Field('s1097phone'), |
|---|
| 31 | Field('s1098date'), |
|---|
| 32 | Field('s1098time'), |
|---|
| 33 | Field('s1098user'), |
|---|
| 34 | Field('s1098phone'), |
|---|
| 35 | Field('s1022date'), |
|---|
| 36 | Field('s1022time'), |
|---|
| 37 | Field('s1022user'), |
|---|
| 38 | Field('s1022phone'), |
|---|
| 39 | format = '%(closureid)s %(lognum)s') |
|---|
| 40 | |
|---|
| 41 | db.closures.closureid.requires = IS_NOT_IN_DB(db, db.closures.closureid) |
|---|
| 42 | #db.closures.closureid.requires = IS_NOT_EMPTY() |
|---|
| 43 | db.closures.route.requires = IS_NOT_EMPTY() |
|---|
| 44 | db.closures.direction.requires = IS_NOT_EMPTY() |
|---|
| 45 | db.closures.facility.requires = IS_NOT_EMPTY() |
|---|
| 46 | db.closures.startcounty.requires = IS_NOT_EMPTY() |
|---|
| 47 | db.closures.startlocation.requires = IS_NOT_EMPTY() |
|---|
| 48 | db.closures.endlocation.requires = IS_NOT_EMPTY() |
|---|
| 49 | db.closures.closuretype.requires = IS_NOT_EMPTY() |
|---|
| 50 | db.closures.worktype.requires = IS_NOT_EMPTY() |
|---|
| 51 | db.closures.supervisor.requires = IS_NOT_EMPTY() |
|---|
| 52 | |
|---|
| 53 | db.define_table('supervisors', |
|---|
| 54 | Field('name'), |
|---|
| 55 | Field('radiocallnum')\ |
|---|
| 56 | ) |
|---|
| 57 | db.supervisors.truncate() # delete all records and reset the counter of the id. |
|---|
| 58 | db.supervisors.import_from_csv_file(open('supervisors.csv', 'r')) #import the file |
|---|
| 59 | |
|---|
| 60 | db.define_table('streets', |
|---|
| 61 | Field('route'), |
|---|
| 62 | Field('street') |
|---|
| 63 | ) |
|---|
| 64 | db.streets.truncate() |
|---|
| 65 | db.streets.import_from_csv_file(open('streets.csv', 'r')) #import the file |
|---|
