PageRenderTime 52ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 0ms

/models/db.py

https://code.google.com/p/web2conf/
Python | 259 lines | 211 code | 31 blank | 17 comment | 27 complexity | 1e56bd79b76ee5ad3efbaba7c21039db MD5 | raw file
    

  1. from gluon.tools import *
    2. 

  2. import uuid, datetime, re, os, time, stat
    3. 

  3. now=datetime.datetime.now()
    4. 

  4. 

  5. migrate = True
    6. 

  6. fake_migrate = False
    7. 

  7. 

  8. if SUSPEND_SERVICE:
    9. 

  9.     raise HTTP(503, "<html><body><h3>Service is unavailable</h3></body></html>")
    10. 

  10. 

  11. if is_gae:
    12. 

  12.     db=GQLDB()
    13. 

  13.     session.connect(request,response,db=db)
    14. 

  14. else:
    15. 

  15.     db=DAL(DBURI)
    16. 

  16. 

  17. PAST=datetime.datetime.today()-datetime.timedelta(minutes=1)
    18. 

  18. 

  19. #### cleanup sessions
    20. 

  20. ##ps=os.path.join(request.folder,'sessions')
    21. 

  21. ##try: [os.unlink(os.path.join(ps,f)) for f in os.listdir(ps) if os.stat(os.path.join(ps,f))[stat.ST_MTIME]<time.time()-3600]
    22. 

  22. ##except: pass
    23. 

  23. #### end cleanup sessions
    24. 

  24. 

  25. def wysiwyg(field,value):
    26. 

  26.     return DIV(field.name,TEXTAREA(_name=field.name, _cols="60", value=value, _id="wysiwyg"))
    27. 

  27. 

  28. 

  29. ######################################
    30. 

  30. ### PERSON
    31. 

  31. ######################################
    32. 

  32. 

  33. db.define_table('auth_user',
    34. 

  34.     ##Field('username', length=512, default='', label=T('Username')),
    35. 

  35.     db.Field('first_name',length=128,label=T('First Name')),
    36. 

  36.     db.Field('last_name',length=128,label=T('Last Name')),
    37. 

  37.     db.Field('email',length=128),
    38. 

  38.     db.Field('password','password',default='',label=T('Password'),readable=False),
    39. 

  39.     db.Field('level','text',label=T('Level'),requires=IS_IN_SET(('principiante','intermedio','avanzado'))),
    40. 

  40.     db.Field('tutorials','list:string',label=T('Tutorials'),readable=False,writable=False),
    41. 

  41.     #db.Field('dni','integer'),
    42. 

  42.     db.Field('certificate','boolean',default=False,label=T('I want a certificate of attendance'),readable=False,writable=False),
    43. 

  43.     db.Field('address',length=255,label=T('Mailing Address'),default=''),
    44. 

  44.     db.Field('city',label=T('City'),default=''),
    45. 

  45.     db.Field('state',label=T('State'),default='Buenos Aires'),
    46. 

  46.     db.Field('country',label=T('Country'),default='Argentina'),
    47. 

  47.     db.Field('zip_code',label=T('Zip/Postal Code'),default=''),    
    48. 

  48.     db.Field('phone_number',label=T('Phone Number')),
    49. 

  49.     db.Field('include_in_delegate_listing','boolean',default=True,label=T('Include in Delegates List')),
    50. 

  50.     db.Field('sponsors','boolean',default=True,label=T('Contacto con Auspiciantes'),readable=True,writable=True),
    51. 

  51.     db.Field('personal_home_page',length=128,label=T('Personal Home Page'),default=''),
    52. 

  52.     db.Field('company_name',label=T('Company Name'),default=''),
    53. 

  53.     db.Field('company_home_page',length=128,label=T('Company Home Page'),default=''),
    54. 

  54.     db.Field('t_shirt_size',label=T('T-shirt Size')),
    55. 

  55.     db.Field('attendee_type',label=T('Registration Type'),default=ATTENDEE_TYPES[0][0],readable=False,writable=False),
    56. 

  56.     db.Field('discount_coupon',length=64,label=T('Discount Coupon'), readable=False,writable=False),
    57. 

  57.     db.Field('donation','double',default=0.0,label=T('Donation to PSF'),readable=False,writable=False),
    58. 

  58.     db.Field('amount_billed','double',default=0.0,readable=False,writable=False),
    59. 

  59.     db.Field('amount_added','double',default=0.0,readable=False,writable=False),
    60. 

  60.     db.Field('amount_subtracted','double',default=0.0,readable=False,writable=False),
    61. 

  61.     db.Field('amount_paid','double',default=0.0,readable=False,writable=False),
    62. 

  62.     db.Field('amount_due','double',default=0.0,readable=False,writable=False),
    63. 

  63.     db.Field('resume','text',label=T('Resume (Bio)'),readable=True,writable=True),
    64. 

  64.     db.Field('photo','upload',label=T('Photo'),readable=True,writable=True),
    65. 

  65.     db.Field('cv','upload',label=T('CV'),readable=True,writable=True),
    66. 

  66.     db.Field('speaker','boolean',default=False,readable=False,writable=False),
    67. 

  67.     db.Field('session_chair','boolean',default=False,readable=False,writable=False),
    68. 

  68.     db.Field('manager','boolean',default=False,readable=False,writable=False),
    69. 

  69.     db.Field('reviewer','boolean',default=True,readable=False,writable=False),
    70. 

  70.     db.Field('latitude','double',default=0.0,readable=False,writable=False),
    71. 

  71.     db.Field('longitude','double',default=0.0,readable=False,writable=False),
    72. 

  72.     db.Field('confirmed','boolean',default=False,writable=False,readable=False),
    73. 

  73.     db.Field('registration_key',length=64,default='',readable=False,writable=False),
    74. 

  74.     db.Field('created_by_ip',readable=False,writable=False,default=request.client),
    75. 

  75.     db.Field('created_on','datetime',readable=False,writable=False,default=request.now),
    76. 

  76.     ##db.Field('cena_viernes','boolean', comment="-con cargo-"),
    77. 

  77.     ##db.Field('cena_sabado','boolean', comment="sin cargo para los disertantes + organizadores"),
    78. 

  78.     ##db.Field('cena_obs','string', comment="indique si quiere invitar a la cena a familiares o amigos (cant. de reservas) -con cargo-"),
    79. 

  79.     format="%(last_name)s, %(first_name)s (%(id)s)",
    80. 

  80.     migrate=migrate, fake_migrate=fake_migrate)
    81. 

  81. 

  82. 

  83. # web2py planet model
    84. 

  84. 

  85. db.define_table("feed",
    86. 

  86.     Field("name", label=T("name")),
    87. 

  87.     Field("author", label=T("author")),
    88. 

  88.     Field("email", requires=IS_EMAIL(), label=T("email")),
    89. 

  89.     Field("url", requires=IS_URL(), comment=T("RSS/Atom feed")),
    90. 

  90.     Field("link", requires=IS_URL(), comment=T("Blog href"), label=T("link")),
    91. 

  91.     Field("general", "boolean", comment=T("Many categories (needs filters)"), label=T("general")),
    92. 

  92.     migrate=migrate, fake_migrate=fake_migrate)
    93. 

  93. 

  94. PLANET_FEEDS_MAX = 4
    95. 

  95. 

  96. # end of web2py planet model
    97. 

  97. 

  98. 

  99. ##db.auth_user.username.comment=T('(required)')
    100. 

  100. db.auth_user.first_name.comment=T('(required)')
    101. 

  101. db.auth_user.last_name.comment=T('(required)')
    102. 

  102. db.auth_user.email.comment=T('(required)')
    103. 

  103. db.auth_user.password.comment=not JANRAIN and T('(required)') or T('(optional)')
    104. 

  104. db.auth_user.resume.widget=lambda field,value: SQLFORM.widgets.text.widget(field,value,_cols="10",_rows="8")
    105. 

  105. db.auth_user.photo.comment=T('Your picture (for authors)')
    106. 

  106. #db.auth_user.dni.comment=T('(required if you need a certificate)')
    107. 

  107. #db.auth_user.certificate.comment=XML(A(str(T('El Costo de Certificado es $x.-')) + '[2]',_href='#footnote2'))
    108. 

  108. db.auth_user.t_shirt_size.requires=IS_IN_SET(T_SHIRT_SIZES,T_SHIRT_SIZES_LABELS)
    109. 

  109. db.auth_user.t_shirt_size.comment='Si desea remera, seleccione tama?o (con costo a definir)'
    110. 

  110. 

  111. db.auth_user.level.comment="Conocimiento de Python, para organizaci?n"
    112. 

  112. 

  113. db.auth_user.zip_code.comment=T('(also used for attendee mapping)')
    114. 

  114. 

  115. db.auth_user.company_name.comment=T('corporation, university, user group, etc.')
    116. 

  116. 

  117. db.auth_user.sponsors.comment=XML(A(str(T('Desmarcar si no desea que los Auspiciantes de la conferencia tengan acceso a sus datos de contacto')) + '[1]',_href='#footnote1'))
    118. 

  118. #db.auth_user.include_in_delegate_listing.comment=T('If checked, your Name, Company and Location will be displayed publicly')
    119. 

  119. db.auth_user.include_in_delegate_listing.comment=XML(A(str(T('If checked, your Name, Company and Location will be displayed publicly')) + '[1]',_href='#footnote1'))
    120. 

  120. db.auth_user.resume.comment=T('Short Biography and references (for authors)')
    121. 

  121. 

  122. db.auth_user.cv.comment=T('If you want you can upload your CV to be available to our Sponsors in further laboral searchs:')
    123. 

  123. 

  124. ##db.auth_user.username.requires=[IS_LENGTH(512),IS_NOT_EMPTY(), IS_NOT_IN_DB(db,'auth_user.username')]
    125. 

  125. db.auth_user.first_name.requires=[IS_LENGTH(128),IS_NOT_EMPTY()]
    126. 

  126. db.auth_user.last_name.requires=[IS_LENGTH(128),IS_NOT_EMPTY()]
    127. 

  127. 

  128. auth=Auth(globals(),db)                      # authentication/authorization
    129. 

  129. 

  130. db.auth_user.password.requires=[CRYPT()]
    131. 

  131. if not JANRAIN:
    132. 

  132.     db.auth_user.password.requires.append(IS_NOT_EMPTY())
    133. 

  133. 

  134. auth.settings.table_user=db.auth_user
    135. 

  135. auth.define_tables(username=False)
    136. 

  136. auth.settings.controller='user'
    137. 

  137. auth.settings.login_url=URL(r=request,c='user',f='login')
    138. 

  138. auth.settings.on_failed_authorization=URL(r=request,c='user',f='login')
    139. 

  139. auth.settings.logout_next=URL(r=request,c='default',f='index')
    140. 

  140. auth.settings.register_next=URL(r=request,c='default',f='index')
    141. 

  141. auth.settings.verify_email_next=URL(r=request,c='default',f='index')
    142. 

  142. auth.settings.profile_next=URL(r=request,c='user',f='profile')
    143. 

  143. auth.settings.retrieve_password_next=URL(r=request,c='user',f='login')
    144. 

  144. auth.settings.change_password_next=URL(r=request,c='default',f='index')
    145. 

  145. auth.settings.logged_url=URL(r=request,c='user',f='profile')
    146. 

  146. auth.settings.create_user_groups = False
    147. 

  147. auth.settings.actions_disabled = ['register', 'change_password','request_reset_password']
    148. 

  148. auth.settings.reset_password_requires_verification = True
    149. 

  149. 

  150. if EMAIL_SERVER:
    151. 

  151.     mail=Mail()                                  # mailer
    152. 

  152.     mail.settings.server=EMAIL_SERVER
    153. 

  153.     mail.settings.sender=EMAIL_SENDER
    154. 

  154.     mail.settings.login=EMAIL_AUTH
    155. 

  155.     auth.settings.mailer=mail                    # for user email verification
    156. 

  156.     auth.settings.registration_requires_verification = EMAIL_VERIFICATION
    157. 

  157.     auth.messages.verify_email_subject = EMAIL_VERIFY_SUBJECT
    158. 

  158.     auth.messages.verify_email = EMAIL_VERIFY_BODY
    159. 

  159.     
    160. 

  160. if RECAPTCHA_PUBLIC_KEY:
    161. 

  161.     auth.setting.captcha=Recaptcha(request,RECAPTCHA_PUBLIC_KEY,RECAPTCHA_PRIVATE_KEY)
    162. 

  162. auth.define_tables()
    163. 

  163. 

  164. db.auth_membership.user_id.represent=lambda v: "%(last_name)s, %(first_name)s (%(id)s)" % db.auth_user[v]
    165. 

  165. 

  166. def require_address(person=None):
    167. 

  167.     try:
    168. 

  168.         if (request.vars.donation_to_PSF \
    169. 

  169.            and float(request.vars.donation_to_PSF)!=0.0)\
    170. 

  170.            or (person and person.donation_to_PSF):
    171. 

  171.             db.auth_user.address1.requires.append(IS_NOT_EMPTY())
    172. 

  172.             db.auth_user.city.requires.append(IS_NOT_EMPTY())
    173. 

  173.             db.auth_user.state.requires.append(IS_NOT_EMPTY())
    174. 

  174.             db.auth_user.zip_code.requires.append(IS_NOT_EMPTY())
    175. 

  175.     except: pass
    176. 

  176. require_address()
    177. 

  177. 

  178. db.auth_user.email.requires=[IS_LENGTH(128),IS_EMAIL(),IS_NOT_IN_DB(db,'auth_user.email')]
    179. 

  179. db.auth_user.personal_home_page.requires=[IS_LENGTH(128),IS_NULL_OR(IS_URL())]
    180. 

  180. db.auth_user.company_home_page.requires=[IS_LENGTH(128),IS_NULL_OR(IS_URL())]
    181. 

  181. db.auth_user.country.requires=IS_IN_SET(COUNTRIES)
    182. 

  182. db.auth_user.created_by_ip.requires=\
    183. 

  183.     IS_NOT_IN_DB(db(db.auth_user.created_on>PAST),'auth_user.created_by_ip')
    184. 

  184. db.auth_user.registration_key.default=str(uuid.uuid4())
    185. 

  185. 

  186. db.auth_user.reviewer.writable=db.auth_user.reviewer.readable=auth.has_membership('manager')
    187. 

  187. db.auth_user.speaker.writable=db.auth_user.speaker.readable=auth.has_membership('manager')
    188. 

  188. 

  189. # Enable tutorial selection after proposal deadline
    190. 

  190. db.auth_user.tutorials.writable = db.auth_user.tutorials.readable = TODAY_DATE>PROPOSALS_DEADLINE_DATE
    191. 

  191. db.auth_user.tutorials.label = "Charlas Preferidas"
    192. 

  192. 

  193. # Enable simplified registration (no password asked)
    194. 

  194. if SIMPLIFIED_REGISTRATION and TODAY_DATE>REVIEW_DEADLINE_DATE and request.controller=='user' and request.function=='register':
    195. 

  195.     db.auth_user.password.readable = False
    196. 

  196.     db.auth_user.password.writable = False
    197. 

  197.     ##db.auth_user.confirmed.default = False
    198. 

  198. else:
    199. 

  199.     db.auth_user.confirmed.default = False
    200. 

  200.     ##db.auth_user.confirmed.readable = True
    201. 

  201.     ##db.auth_user.confirmed.writable = True
    202. 

  202.     
    203. 

  203. db.auth_user.confirmed.label = T("Confirm attendance")
    204. 

  204. 

  205. # conference options
    206. 

  206. db.define_table("option",
    207. 

  207.     Field("name", "string", unique=True),
    208. 

  208.     Field("value", "text", comment=T("Value or record reference")),
    209. 

  209.     Field("valuetype", requires=IS_EMPTY_OR(IS_IN_SET({"integer":T("integer"),
    210. 

  210.         "double":T("double"), "string":T("string"), "text": T("text"),
    211. 

  211.         "boolean":T("boolean"), "date": T("date"), "datetime": T("datetime"),
    212. 

  212.         "reference": T("reference")}))),
    213. 

  213.     Field("tablename", requires=IS_EMPTY_OR(IS_IN_SET(db.tables)), default=None),
    214. 

  214.     Field("description", "text"), 
    215. 

  215.     format=lambda row: row.name,
    216. 

  216.     migrate=migrate, fake_migrate=fake_migrate
    217. 

  217.     )
    218. 

  218. 

  219. 

  220. def get_option(name, default=None):
    221. 

  221.     cdata = cache.ram(name, lambda: retrieve_option(name, default=default), 12*60*60)
    222. 

  222.     return cdata
    223. 

  223. 

  224. def retrieve_option(name, default=None):
    225. 

  225.     option = db(db.option.name==name).select().first()
    226. 

  226.     if option is not None:
    227. 

  227.         if option.valuetype == "reference":
    228. 

  228.             try:
    229. 

  229.                 obj = db[option.tablename][int(option.value)]
    230. 

  230.             except (ValueError, TypeError, AttributeError):
    231. 

  231.                 obj = default
    232. 

  232.         else:
    233. 

  233.             try:
    234. 

  234.                 if option.valuetype == "integer":
    235. 

  235.                     obj = int(option.value)
    236. 

  236.                 elif option.valuetype == "double":
    237. 

  237.                     obj = float(option.value)
    238. 

  238.                 elif option.valuetype == "boolean":
    239. 

  239.                     if option.value in ("", "False", None, False):
    240. 

  240.                         obj = False
    241. 

  241.                     else:
    242. 

  242.                         obj = True
    243. 

  243.                 elif option.valuetype == "date":
    244. 

  244.                     ymd = [int(v) for v in option.value.split("-")]
    245. 

  245.                     obj = datetime.date(ymd[0], ymd[1], ymd[2])
    246. 

  246.                 elif option.valuetype == "datetime":
    247. 

  247.                     split_data = option.value.split(" ")
    248. 

  248.                     ymd = [int(v) for v in split_data[0].split("-")]
    249. 

  249.                     hms = [int(v) for v in split_data[1].split(":")]
    250. 

  250.                     obj = datetime.datetime(ymd[0], ymd[1], ymd[2],
    251. 

  251.                     hms[0], hms[1], hms[2])
    252. 

  252.                 else:
    253. 

  253.                     # string, text, other types
    254. 

  254.                     obj = option.value
    255. 

  255.             except  (ValueError, TypeError, AttributeError):
    256. 

  256.                 obj = option.value            
    257. 

  257.     else:
    258. 

  258.         obj = default
    259. 

  259.     return obj
    260. 

  260.