db.py 7.5 KB
Newer Older
1
2
3
4
5
6
7
8
9
# -*- coding: utf-8 -*-

#########################################################################
## This scaffolding model makes your app work on Google App Engine too
## File is released under public domain and you can use without limitations
#########################################################################

## if SSL/HTTPS is properly configured and you want all HTTP requests to
## be redirected to HTTPS, uncomment the line below:
10
request.requires_https()
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101

if not request.env.web2py_runtime_gae:
    ## if NOT running on Google App Engine use SQLite or other DB
    db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all'])
else:
    ## connect to Google BigTable (optional 'google:datastore://namespace')
    db = DAL('google:datastore')
    ## store sessions and tickets there
    session.connect(request, response, db=db)
    ## or store session in Memcache, Redis, etc.
    ## from gluon.contrib.memdb import MEMDB
    ## from google.appengine.api.memcache import Client
    ## session.connect(request, response, db = MEMDB(Client()))

## by default give a view/generic.extension to all actions from localhost
## none otherwise. a pattern can be 'controller/function.extension'
response.generic_patterns = ['*'] if request.is_local else []
## (optional) optimize handling of static files
# response.optimize_css = 'concat,minify,inline'
# response.optimize_js = 'concat,minify,inline'

#########################################################################
## Here is sample code if you need for
## - email capabilities
## - authentication (registration, login, logout, ... )
## - authorization (role based authorization)
## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
## - old style crud actions
## (more options discussed in gluon/tools.py)
#########################################################################

from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
auth = Auth(db)
crud, service, plugins = Crud(db), Service(), PluginManager()

## create all tables needed by auth if not custom tables
auth.define_tables(username=False, signature=False)

## configure email
mail = auth.settings.mailer
mail.settings.server = 'logging' or 'smtp.gmail.com:587'
mail.settings.sender = 'you@gmail.com'
mail.settings.login = 'username:password'

## configure auth policy
auth.settings.registration_requires_verification = False
auth.settings.registration_requires_approval = False
auth.settings.reset_password_requires_verification = True

## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc.
## register with janrain.com, write your domain:api_key in private/janrain.key
from gluon.contrib.login_methods.rpx_account import use_janrain
use_janrain(auth, filename='private/janrain.key')

#########################################################################
## Define your tables below for example
##
## >>> db.define_table('mytable',Field('myfield','string'))
##
## Fields can be 'string','text','password','integer','double','boolean'
##       'date','time','datetime','blob','upload', 'reference TABLENAME'
## There is an implicit 'id integer autoincrement' field
## Consult manual for more options, validators, etc.
##
## More API examples for controllers:
##
## >>> db.mytable.insert(myfield='value')
## >>> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)
## >>> for row in rows: print row.id, row.myfield
#########################################################################


db.define_table('patient',
                Field('first_name','string'),
                Field('last_name','string'),
                Field('birth','date'),
                Field('info','text'))

'''
db.patient.first_name.requires = IS_NOT_EMPTY( error_message='input needed' )
db.patient.last_name.requires = IS_NOT_EMPTY( error_message='input needed' )
db.patient.birth.requires = IS_DATE(format=T('%Y-%m-%d'),
                   error_message='must be YYYY-MM-DD!')
'''



db.define_table('sequence_file',
                Field('patient_id', 'reference patient'),
                Field('sampling_date','date'),
                Field('info','text'),
Marc Duez's avatar
Marc Duez committed
102
                Field('filename','text'),
103
104
105
                Field('pcr','text'),
                Field('sequencer','text'),
                Field('producer','text'),
106
                Field('size_file','integer'),
107
                Field('data_file', 'upload', length=1000000000000, autodelete=True))
108
109
110
111
112
113
114
115
116
117
118
119
120
121




db.define_table('standard_file',
                Field('name', 'string'),
                Field('info','text'),
                Field('data_file', 'upload',autodelete=True, length=1000000000000))



db.define_table('config',
                Field('name', 'string'),
                Field('command', 'string'),
Marc Duez's avatar
Marc Duez committed
122
123
                Field('info','text'),
                Field('germline', 'string'))
124
125
126
127
128


db.define_table('data_file',
                Field('sequence_file_id', 'reference sequence_file'),
                Field('config_id', 'reference config'),
129
                Field('run_date','date'),
130
                Field('scheduler_task_id', 'integer'),
131
                Field('data_file', 'upload', length=1000000000000, autodelete=True))
132

133
134
135
136
137
db.define_table('fused_file',
                Field('patient_id', 'reference patient'),
                Field('config_id', 'reference config'),
                Field('fuse_date','date'),
                Field('status', 'string'),
138
                Field('fused_file', 'upload', length=1000000000000, autodelete=True))
139
140
141
142
143
144

db.define_table('analysis_file',
                Field('patient_id', 'reference patient'),
                Field('config_id', 'reference config'),
                Field('analyze_date','date'),
                Field('status', 'string'),
145
                Field('analysis_file', 'upload', length=1000000000000, autodelete=True))
146

147
148
149
150
151
152
153
154
155
156
157
158
159
160
161

if db(db.auth_user.id > 0).count() == 0:
    id_first_user=""
        
    ## création du premier user
    id_first_user=db.auth_user.insert(
        password = db.auth_user.password.validate('1234')[0],
        email = 'plop@plop.com',
        first_name = 'System',
        last_name = 'Administrator'
    )
            
    ## création des groupes de base
    id_admin_group=db.auth_group.insert(role='admin')
    id_sa_group=db.auth_group.insert(role='user_1')
Marc Duez's avatar
Marc Duez committed
162
    db.auth_group.insert(role="public")
163
164
165
            
    db.auth_membership.insert(user_id=id_first_user, group_id=id_admin_group)
    db.auth_membership.insert(user_id=id_first_user, group_id=id_sa_group)
166
    
root's avatar
root committed
167
168
169
170
171
172
173
174
175
176
177
178
179
180
    ##création des configs de base
    id_config_TRG = db.config.insert(
        name = 'TRG',
        command = '-c clones -z 20 -R 1 -r 100 ',
        info = 'default trg config',
        germline = 'TRG'
    )
    id_config_IGH = db.config.insert(
        name = 'IGH',
        command = '-c clones -z 20 -R 1 -r 100 ',
        info = 'default igh config',
        germline = 'IGH'
    )
    
181
    ## permission
Marc Duez's avatar
Marc Duez committed
182
    ## system admin have admin/read/create rights on all patients, groups and configs
183
    auth.add_permission(id_admin_group, 'admin', db.patient, 0)
184
    auth.add_permission(id_admin_group, 'admin', db.auth_group, 0)
Marc Duez's avatar
Marc Duez committed
185
186
187
188
189
190
191
192
    auth.add_permission(id_admin_group, 'admin', db.config, 0)
    auth.add_permission(id_admin_group, 'read', db.patient, 0)
    auth.add_permission(id_admin_group, 'read', db.auth_group, 0)
    auth.add_permission(id_admin_group, 'read', db.config, 0)
    auth.add_permission(id_admin_group, 'create', db.patient, 0)
    auth.add_permission(id_admin_group, 'create', db.auth_group, 0)
    auth.add_permission(id_admin_group, 'create', db.config, 0)
 
193
194
195
196


## after defining tables, uncomment below to enable auditing
auth.enable_record_versioning(db)