Ejemplo n.º 1
0
def emailResourceApproval(email, title):
    """
    Email resource owner on approval.  Using template: resource_approval
        
    @type   email: string
    @param  email: Email address to send to
    ...
    
    @rtype: Boolean
    @returns: Whether emailer was successful or not.
    
    """
    
    # Create values for template.
    emailAccount = Config.get('email')
    subject = "Your resource has been approved"
    template_values = {
        'link': Config.get('default_host'),
        'title': title,
        'config': Config.get_all()
    }
    
    # Render email body.
    body = Emailer.render('email/resource_approval', template_values, suffix = 'txt')

    # Send email.
    try:
        return Emailer.send(email, subject, body, from_name = emailAccount['from_name'],
            from_address = emailAccount['from_email'])  
    except Exception, e:
        log.info("*** couldn't send resource approval email")
        log.error(e)
        return False
Ejemplo n.º 2
0
    def populateUserData(self):
        sql = """
select u.user_key
      ,u.email
      ,u.password
      ,u.salt
      ,u.phone
      ,u.first_name
      ,u.last_name
      ,u.image_id
      ,u.location_id
      ,l.name as location_name
      ,u.description
      ,u.affiliation
      ,u.group_membership_bitmask
      ,u.email_notification
      ,coalesce(u.last_account_page_access_datetime, u.created_datetime) as last_account_page_access_datetime
      ,pl.title
      ,pl.organization
from user u
left join location l on l.location_id = u.location_id
left join project_leader pl on pl.user_id = u.user_id
where u.user_id = $id and u.is_active = 1"""

        try:
            data = list(self.db.query(sql, {'id':self.id}))[0]

            if len(data) > 0:
                return data
            else:
                return None
        except Exception, e:
            log.info("*** couldn't get user info user id %s" % self.id)
            log.error(e)
            return None
Ejemplo n.º 3
0
    def getNumNewMessages(self):
        """

        """
        num = 0

        try:
            # Select the number of times that someone invited this user to a
            # project based on this user's idea.  TODO: is my interpretation
            # correct?  Why is it selecting when this user is the invitee?

            # Select the number of times that this user submitted a message

            sql = """select
                        (select count(inv.project_invite_id) from project_invite inv
                          inner join idea i on i.idea_id = inv.invitee_idea_id and i.user_id = $userId
                          where inv.created_datetime > $last) +
                        (select count(pm.project_message_id) from project_message pm
                          inner join project__user pu on pu.project_id = pm.project_id  and pu.user_id = $userId
                          where pm.is_active = 1 and pm.created_datetime > $last) as total"""
            data = list(self.db.query(sql, {'userId':self.id, 'last':self.data.last_account_page_access_datetime}))

            num = data[0].total
        except Exception, e:
            log.info("*** couldn't get number of new msgs for user id %s" % self.id)
            log.error(e)
Ejemplo n.º 4
0
def emailAccountDeactivation(email):
    """
    Email deleted users.  Using template: account_deactivation
        
    @type   email: string
    @param  email: Email address to send to
    ...
    
    @rtype: Boolean
    @returns: Whether emailer was successful or not.
    
    """
    
    # Create values for template.
    emailAccount = Config.get('email')
    subject = "Your account has been deactivated"
    link = "%stou" % Config.get('default_host')
    template_values = {
        'link': link,
        'config': Config.get_all()
    }
    
    # Render email body.
    body = Emailer.render('email/account_deactivation', template_values, suffix = 'txt')

    # Send email.
    try:
        return Emailer.send(email, subject, body, from_name = emailAccount['from_name'],
            from_address = emailAccount['from_email'])
    except Exception, e:
        log.info("*** couldn't send account deactivation email")
        log.error(e)
        return False
Ejemplo n.º 5
0
 def saveFile(self, filename, data, mirror=True, **kwargs):
     """
     Save the data into a file.  Return True is file successfully saved,
     otherwise False.
     
     Attributes:
     filename -- The id from the database record that corresponds to the file
     data -- The data (string of bytes) contained in the file
     
     """
     localpath = self.getLocalPath(filename)
     localsaved = self.saveTemporaryLocalFile(localpath, data)
     if not localsaved:
         return False
     
     isS3mirror = self.getConfigVar('media')['isS3mirror']
     s3path = self.getS3Path(filename)
     log.info("*** config = %s, mirror = %s" % (isS3mirror, mirror))
     if (isS3mirror and mirror):
         try:
             result = S3Uploader.upload(localpath, s3path)
             log.info(result)
         except Exception, e:
             tb = traceback.format_exc()
             log.error(tb)
             return False
Ejemplo n.º 6
0
def getProjectCounts(db):
    data = []
    
    try:
        sql = """select p.title,
                  (select count(pu.user_id) from project__user pu 
                      inner join user u on u.user_id = pu.user_id and u.is_active = 1
                      where pu.project_id = p.project_id) as num_users,
                  (select count(pi.idea_id) from project__idea pi  
                      inner join idea i on i.idea_id = pi.idea_id and i.is_active = 1
                      where pi.project_id = p.project_id) as num_ideas,
                  (select count(pr.project_resource_id) from project__project_resource pr 
                      inner join project_resource r on r.project_resource_id = pr.project_resource_id and r.is_active = 1
                      where pr.project_id = p.project_id) as num_resources,
                  (select count(pe.user_id) from project_endorsement pe 
                      inner join user u on u.user_id = pe.user_id and u.is_active = 1
                      where pe.project_id = p.project_id) as num_endorsements,
                  coalesce(p.keywords, '') as keywords
                from project p
                where p.is_active = 1
                order by p.title"""
        data = list(db.query(sql))
    except Exception, e:
        log.info("*** couldn't get project counts")
        log.error(e)
Ejemplo n.º 7
0
def confirm_pid(run_folder):
    """
    TBD
    """
    import sys, os, signal, __main__

    name = prefix(".", os.path.basename(__main__.__file__))
    log.info("Attempting to launch daemon %s..." % name)
    pid = str(os.getpid())
    pidfile = "%s%s.pid" % (run_folder, name)
    if os.path.isfile(pidfile):
        old_pid = open(pidfile).read()
        log.warning("--> pidfile already exists for %s, attempting to kill process..." % old_pid)
        try:
            result = os.kill(int(old_pid), signal.SIGKILL)
        except OSError, e:
            if e.args[0] == 3:
                log.warning("--> no process with pid %s" % old_pid)
            else:
                log.error(e)
                exit()
        else:
            log.info("--> killed process %s" % old_pid)

        try:
            os.unlink(pidfile)
        except OSError, e:
            log.error("--> could not remove pidfile, %s" % pidfile)
            exit()
Ejemplo n.º 8
0
    def temp_image(self, image):
        web.header("Content-Type", "image/png")

        web.header("Cache-Control", "no-cache")
        log.info("200: image/png (temporary)")

        return image
Ejemplo n.º 9
0
def send(phone, message):
    
    log.info("Sending sms...")    
    
    message = clean(message)
    
    settings = Config.get('twilio')
    account = twilio.Account(settings['sid'], settings['token'])
    callback = Config.base_url()
    if not callback:
        callback = Config.get('default_host')
    
    data = {    'From': settings['phone'],
                'To': phone,
                'Body': message,
                'StatusCallback': "%stwilio/status" % callback
                }
    log.debug(data)
    try:
        response = account.request('/%s/Accounts/%s/SMS/Messages.json' % (settings['api'], settings['sid']), 'POST', data)
        log.info("--> %s" % response)        
        response = json.loads(response)        
        smsid = response['TwilioResponse']['SMSMessage']['Sid']
        status = "passed"
    except Exception, e:
        log.error(e)
        smsid = None
        status = "blocked"        
Ejemplo n.º 10
0
def emailProjectEndorsement(email, title, leaderName):
    """
    Email project admins about endorsements.  Using template: project_endorsement
        
    @type   email: string
    @param  email: Email address to send to
    ...
    
    @rtype: Boolean
    @returns: Whether emailer was successful or not.
    
    """
    
    # Create values for template.
    emailAccount = Config.get('email')
    subject = "%s liked your project!" % leaderName
    template_values = {
        'title': title,
        'leader_name': leaderName,
        'config': Config.get_all()
    }
    
    # Render email body.
    body = Emailer.render('email/project_endorsement', template_values, suffix = 'txt')
         
    # Send email.
    try:
        return Emailer.send(email, subject, body, from_name = emailAccount['from_name'],
            from_address = emailAccount['from_email'])
    except Exception, e:
        log.info("*** couldn't send endorsement email")
        log.error(e)
        return False
Ejemplo n.º 11
0
def emailUnauthenticatedUser(email, authGuid):
    """
    Send unauthenticated user a link to authenticate.  Using 
    template: auth_user
        
    @type   email: string
    @param  email: Email address to send to
    
    @rtype: *
    @returns: Emailer send response.
    
    """
    
    # Create values for template.
    emailAccount = Config.get('email')
    subject = "Please authenticate your account"
    link = "%sjoin/auth/%s" % (Config.get('default_host'), authGuid)
    template_values = {
        'link': link,
        'config': Config.get_all()
    }
    
    # Render email body.
    body = Emailer.render('email/auth_user', template_values, suffix = 'txt')
            
    # Send email.            
    try:
        return Emailer.send(email, subject, body, from_name = emailAccount['from_name'],
            from_address = emailAccount['from_email'])  
    except Exception, e:
        log.info("*** couldn't send authenticate user email")
        log.error(e)
        return False
Ejemplo n.º 12
0
def html(html):
    print("Content-Type: text/html\n")
    doc = "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" /></head><body>"
    doc += html
    doc += "</body></html>"
    log.info("200: text/html")                
    print(doc)
Ejemplo n.º 13
0
def emailTempPassword(email, password):
    """
    Email temporary password.  Using template: forgot_password
        
    @type   email: string
    @param  email: Email address to send to
    ...
    
    @rtype: Boolean
    @returns: Whether emailer was successful or not.
    
    """
    
    # Create values for template.
    emailAccount = Config.get('email')
    subject = "Your password has been reset"
    link = "%slogin" % Config.get('default_host')
    link = "%stou" % Config.get('default_host')
    template_values = {
        'password': password,
        'link': link,
        'config': Config.get_all()
    }
    
    # Render email body.
    body = Emailer.render('email/forgot_password', template_values, suffix = 'txt')

    # Send email.
    try:
        return Emailer.send(email, subject, body, from_name = emailAccount['from_name'],
            from_address = emailAccount['from_email'])
    except Exception, e:
        log.info("*** couldn't send forgot password email")
        log.error(e)
        return False
Ejemplo n.º 14
0
 def add(cls, db, data, app, max_size=None, grayscale=False, mirror=True, thumb_max_size=None):
     log.info("ImageServer.add")
     try:
         id = db.insert("images", app=app)
     except Exception, e:
         log.error(e)
         return None
Ejemplo n.º 15
0
def getUnreviewedProjectResources(db, limit = 10, offset = 0):
    data = []
    
    try:
        sql = """select pr.project_resource_id, 
                        pr.title, pr.description, 
                        pr.image_id, 
                        pr.location_id, 
                        pr.url,
                        pr.twitter_url,
                        pr.facebook_url,
                        pr.physical_address,
                        pr.contact_name,
                        pr.contact_email,
                        replace(pr.keywords, ' ', ',') as keywords,
                        l.name as location_name
                    from project_resource pr 
                    left join location l on l.location_id = pr.location_id
                    where pr.is_active = 1 and pr.is_hidden = 1 
                    limit $limit offset $offset"""
                    
        data = list(db.query(sql, {'limit':limit, 'offset':offset}))
    except Exception, e:
        log.info("*** couldn't get unreviewed resources")
        log.error(e)
Ejemplo n.º 16
0
 def render(cls, template_name, template_values=None, suffix="html"):
     if template_values is None: template_values = {}        
     template_values['template_name'] = template_name
     log.info("TEMPLATE %s: %s" % (template_name, template_values))        
     renderer = render_jinja(os.path.dirname(__file__) + '/../templates/')      
     renderer._lookup.filters.update(custom_filters.filters)
     return (renderer[template_name + "." + suffix](template_values)).encode('utf-8')
Ejemplo n.º 17
0
 def GET(self, id=None):
     log.info("Monitor")
     tasks = Tasks()
     info = {    'tasks': tasks.queue.stats() if tasks.queue is not None else [],
                 'cache': self.cache.get_stats()
                 }
     return self.json(info)
Ejemplo n.º 18
0
 def populateResourceData(self):
     sql = """select pr.project_resource_id, 
                     pr.title, 
                     pr.description, 
                     pr.url, 
                     pr.contact_name, 
                     pr.contact_email, 
                     pr.image_id, 
                     pr.location_id, 
                     pr.is_official,
                     o.user_id as owner_user_id,
                     o.first_name as owner_first_name,
                     o.last_name as owner_last_name,
                     o.email as owner_email
             from project_resource pr 
             left join user o on o.user_id = pr.contact_user_id
             where pr.project_resource_id = $id;"""
     
     try:
         data = list(self.db.query(sql, {'id':self.id}))
         
         if len(data) > 0:
             return data[0]
         else:
             return None
     except Exception, e:
         log.info("*** couldn't get project resource info")
         log.error(e)
         return None 
Ejemplo n.º 19
0
def getLocationsWithScoring(db):
    data = []
    
    log.info("*** hit locations")

    try:
        # TODO
        # this is temporary until actual scoring is determined
        sql = """
select l.location_id,
    l.name,
    l.lat,
    l.lon,
    count(distinct p.project_id) as num_projects,
    count(distinct i.idea_id) as num_ideas,
    count(distinct r.project_resource_id) as num_project_resources
from location l 
	left join project p on p.location_id = l.location_id and p.is_active=1
    left join project__user pu on p.project_id=pu.project_id and pu.is_project_admin = 1 and p.is_active=1
	left join idea i on l.location_id = i.location_id and i.is_active=1
	left join project_resource r on l.location_id = r.location_id and r.is_active=1 and r.is_hidden=0
where l.location_id > 0
group by l.location_id+l.lat+l.lon
order by l.location_id""";

        data = list(db.query(sql))
    except Exception, e:
        log.info("*** couldn't get locations")
        log.error(e)
Ejemplo n.º 20
0
def stopSMS(db, phone):
    try:
        db.insert('sms_stopped_phone', phone = phone)
        return True
    except Exception, e:
        log.info("*** couldn't stop messages to phone number %s.  Number may already be in database." % phone)
        log.error(e)
        return False
Ejemplo n.º 21
0
def approveProjectResource(db, projectResourceId, isOfficial = False):
    try:
        db.update('project_resource', where = "project_resource_id = $projectResourceId", is_hidden = 0, is_official = isOfficial, vars = {'projectResourceId':projectResourceId})
        return True
    except Exception, e:
        log.info("*** couldn't approve project resource %s" % projectResourceId)
        log.error(e)
        return False
Ejemplo n.º 22
0
def updateProjectResourceLocation(db, projectResourceId, locationId):
    try:
        db.update('project_resource', where = "project_resource_id = $id", location_id = locationId, vars = {'id':projectResourceId})
        return True
    except Exception, e:
        log.info("*** couldn't update project location")
        log.error(e)
        return False
Ejemplo n.º 23
0
    def xml(self, data):

        web.header("Content-Type", "application/xml")
        output = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n"
        output += data                                          ## should make this use a real library
        log.info("200: application/xml")

        return output
Ejemplo n.º 24
0
 def remove(cls, db, app, id):
     log.info("ImageServer.remove %s %s" % (app, id))
     path = ImageServer.path(app, id)
     try:
         db.query("DELETE FROM images WHERE id=$id", {"id": id})
         os.remove(path)
     except Exception, e:
         log.error(e)
Ejemplo n.º 25
0
def updateProjectResourceImage(db, projectResourceId, imageId):
    try:
        db.update('project_resource', where = "project_resource_id = $id", image_id = imageId, vars = {'id':projectResourceId})
        return True
    except Exception, e:
        log.info("*** couldn't update project image")
        log.error(e)
        return False
Ejemplo n.º 26
0
    def html(self, html):
        web.header("Content-Type", "text/html")
        doc = "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" /></head><body>"
        doc += html
        doc += "</body></html>"
        log.info("200: text/html")

        return doc
Ejemplo n.º 27
0
    def html(self, html):
        web.header("Content-Type", "text/html")
        doc = "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" /></head><body>"
        doc += html
        doc += "</body></html>"
        log.info("200: text/html")

        return doc
Ejemplo n.º 28
0
def setUserOncallStatus(db, userId, status):
    try:
        db.update('user', where = "user_id = $userId", is_oncall = status, vars = {'userId':userId})
        return True
    except Exception, e:
        log.info("*** problem setting oncall status to %s for user id %s" % (status, userId))
        log.error(e)
        return False
Ejemplo n.º 29
0
def findIdeasByPhone(db, phone):
    try:
        sql = "select idea_id from idea where phone = $phone"
        return list(db.query(sql, {'phone':phone}))
    except Exception, e:
        log.info("*** problem getting ideas by phone")
        log.error(e)    
        return None
Ejemplo n.º 30
0
    def xml(self, data):

        web.header("Content-Type", "application/xml")
        output = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n"
        output += data  ## should make this use a real library
        log.info("200: application/xml")

        return output
Ejemplo n.º 31
0
 def db_connect(cls):
     settings = Config.get('database')
     cls._db = web.database(dbn=settings['dbn'],
                            user=settings['user'],
                            pw=settings['password'],
                            db=settings['db'],
                            host=settings['host'])
     log.info("Connected to db: %s" % cls._db)
Ejemplo n.º 32
0
def send_email_via_smtp(addresses, subject, text, html=None, attachment=None, from_name=None, from_address=None, **kwargs):
    """
    Send email via SMTP
    """
    server = webapi.config.get('smtp_server')
    port = webapi.config.get('smtp_port', 0)
    username = webapi.config.get('smtp_username')
    password = webapi.config.get('smtp_password')
    debug_level = webapi.config.get('smtp_debuglevel', None)
    starttls = webapi.config.get('smtp_starttls', False)

    import smtplib
    smtpserver = smtplib.SMTP(server, port)

    if debug_level:
        smtpserver.set_debuglevel(debug_level)

    if starttls:
        smtpserver.ehlo()
        smtpserver.starttls()
        smtpserver.ehlo()

    if username and password:
        smtpserver.login(username, password)
    
    if html and text:
        message = MIMEMultipart('alternative')
        message.attach(MIMEText(html, 'html'))
        message.attach(MIMEText(text, 'plain'))
    elif html:
        message = MIMEText(html, 'html')
    else:
        message = MIMEText(text, 'plain')

    if attachment:
        tmpmessage = message
        message = MIMEMultipart()
        message.attach(tmpmessage)
        message.attach(MIMEText("\n\n", 'plain')) # helps to space the attachment from the body of the message
        log.info("--> adding attachment")
        part = MIMEBase('application', 'octet-stream')
        part.set_payload(open(attachment, 'rb').read())
        Encoders.encode_base64(part)
        part.add_header('Content-Disposition', 'attachment; filename="%s"' % os.path.basename(attachment))
        message.attach(part)

    sender = from_name + "<" + from_address + ">"
    cc = listify(kwargs.get('cc', []))
    bcc = listify(kwargs.get('bcc', []))

    message['Subject'] = subject
    message['From'] = sender
    message['To'] = ", ".join(addresses)
    message['Cc']     = ','.join(cc)
    message['Bcc']    = ','.join(bcc)

    smtpserver.sendmail(sender, addresses, message.as_string())
    smtpserver.quit()
Ejemplo n.º 33
0
def send_email_via_smtp(addresses, subject, text, html=None, attachment=None, from_name=None, from_address=None, **kwargs):
    """
    Send email via SMTP
    """
    server = webapi.config.get('smtp_server')
    port = webapi.config.get('smtp_port', 0)
    username = webapi.config.get('smtp_username')
    password = webapi.config.get('smtp_password')
    debug_level = webapi.config.get('smtp_debuglevel', None)
    starttls = webapi.config.get('smtp_starttls', False)

    import smtplib
    smtpserver = smtplib.SMTP(server, port)

    if debug_level:
        smtpserver.set_debuglevel(debug_level)

    if starttls:
        smtpserver.ehlo()
        smtpserver.starttls()
        smtpserver.ehlo()

    if username and password:
        smtpserver.login(username, password)
    
    if html and text:
        message = MIMEMultipart('alternative')
        message.attach(MIMEText(html, 'html'))
        message.attach(MIMEText(text, 'plain'))
    elif html:
        message = MIMEText(html, 'html')
    else:
        message = MIMEText(text, 'plain')

    if attachment:
        tmpmessage = message
        message = MIMEMultipart()
        message.attach(tmpmessage)
        message.attach(MIMEText("\n\n", 'plain')) # helps to space the attachment from the body of the message
        log.info("--> adding attachment")
        part = MIMEBase('application', 'octet-stream')
        part.set_payload(open(attachment, 'rb').read())
        Encoders.encode_base64(part)
        part.add_header('Content-Disposition', 'attachment; filename="%s"' % os.path.basename(attachment))
        message.attach(part)

    sender = from_name + "<" + from_address + ">"
    cc = listify(kwargs.get('cc', []))
    bcc = listify(kwargs.get('bcc', []))

    message['Subject'] = subject
    message['From'] = sender
    message['To'] = ", ".join(addresses)
    message['Cc']     = ','.join(cc)
    message['Bcc']    = ','.join(bcc)

    smtpserver.sendmail(sender, addresses, message.as_string())
    smtpserver.quit()
Ejemplo n.º 34
0
def deleteIdea(db, ideaId):
    try:
        sql = """delete from idea where idea.idea_id = $id"""
        db.query(sql, {'id':ideaId})
        return True;
    except Exception, e:
        log.info("*** problem deleting id with id %s" % str(ideaId))
        log.error(e)
        return False
Ejemplo n.º 35
0
def sendSMSConfirmation(db, phone):
    log.info("*** sending confirmation to %s" % phone)
    
    if (not isPhoneStopped(db, phone)):
        message = "Thanks for adding your idea to changeby.us Visit %smobile to browse and join projects related to your idea." % Config.get('default_host')
        
        return helpers.sms.send(phone, message)
    else:
        return False
Ejemplo n.º 36
0
def addIdeaToProject(db, ideaId, projectId):
    try:
        db.insert('project__idea', idea_id = ideaId, project_id = projectId)
                    
        return True
    except Exception, e:
        log.info("*** problem adding idea to project")
        log.error(e)    
        return False
Ejemplo n.º 37
0
def setIdeaIsActive(db, ideaId, b):
    try:
        sql = "update idea set is_active = $b where idea_id = $ideaId"
        db.query(sql, {'ideaId':ideaId, 'b':b})
        return True
    except Exception, e:
        log.info("*** problem setting idea is_active = %s for idea_id = %s" % (b, ideaId))
        log.error(e)    
        return False
Ejemplo n.º 38
0
def flagIdea(db, ideaId):
    try:
        sql = "update idea set num_flags = num_flags + 1 where idea_id = $ideaId"
        db.query(sql, {'ideaId':ideaId})
        return True
    except Exception, e:
        log.info("*** problem flagging idea")
        log.error(e)    
        return False
Ejemplo n.º 39
0
    def updateImage(self, locationId):
        try:
            sql = "update user set location_id = $location_id where user_id = $id"
            self.db.query(sql, {'id': self.id, 'location_id': locationId})

            return True
        except Exception, e:
            log.info("*** problem updating user image")
            log.error(e)
            return False
Ejemplo n.º 40
0
def getLocations(db):
    data = []

    try:
        sql = """select l.location_id, l.name, l.lat, l.lon from location l where l.location_id > 0
                order by l.location_id"""
        data = list(db.query(sql))
    except Exception, e:
        log.info("*** couldn't get locations")
        log.error(e)
Ejemplo n.º 41
0
    def setMessagePreferences(self, pref):
        try:
            sql = "update user set email_notification = $pref where user_id = $id"
            self.db.query(sql, {'id': self.id, 'pref': pref})

            return True
        except Exception, e:
            log.info("*** problem updating user message preferences")
            log.error(e)
            return False
Ejemplo n.º 42
0
def updateProjectResourceLocation(db, projectResourceId, locationId):
    try:
        db.update('project_resource',
                  where="project_resource_id = $id",
                  location_id=locationId,
                  vars={'id': projectResourceId})
        return True
    except Exception, e:
        log.info("*** couldn't update project location")
        log.error(e)
        return False
Ejemplo n.º 43
0
 def updateDescription(self, description):
     try:
         self.db.update('user',
                        where='user_id = $userId',
                        description=description,
                        vars={'userId': self.id})
         return True
     except Exception, e:
         log.info("*** problem updating user description")
         log.error(e)
         return False
Ejemplo n.º 44
0
def updateProjectResourceImage(db, projectResourceId, imageId):
    try:
        db.update('project_resource',
                  where="project_resource_id = $id",
                  image_id=imageId,
                  vars={'id': projectResourceId})
        return True
    except Exception, e:
        log.info("*** couldn't update project image")
        log.error(e)
        return False
Ejemplo n.º 45
0
def getNumKeywords(db):
    num = 0

    try:
        sql = "select count(*) as count from keyword"
        data = list(db.query(sql))

        num = data[0].count
    except Exception, e:
        log.info("*** couldn't get keyword count")
        log.error(e)
Ejemplo n.º 46
0
def setUserOncallStatus(db, userId, status):
    try:
        db.update('user',
                  where="user_id = $userId",
                  is_oncall=status,
                  vars={'userId': userId})
        return True
    except Exception, e:
        log.info("*** problem setting oncall status to %s for user id %s" %
                 (status, userId))
        log.error(e)
        return False
Ejemplo n.º 47
0
def enable_aws_ses():
    """
    Enable AWS SES support for the web.py email handling.  This
    uses config values found in config.yaml.
    """
    try:
        ses_config = Config.get('email').get('aws_ses')
        web.webapi.config.email_engine = 'aws'
        web.webapi.config.aws_access_key_id = ses_config.get('access_key_id')
        web.webapi.config.aws_secret_access_key = ses_config.get('secret_access_key')
    except Exception, e:
        log.info("ERROR: Exception when loading SES: %s" % e)
Ejemplo n.º 48
0
    def updateAccountPageVisit(self):
        try:
            sql = "update user set last_account_page_access_datetime = now() where user_id = $userId"
            self.db.query(sql, {'userId': self.id})

            return True
        except Exception, e:
            log.info(
                "*** problem updating last_account_page_access_datetime for user id %s"
                % self.id)
            log.error(e)
            return False
Ejemplo n.º 49
0
    def getUserResources(self):
        data = []

        try:
            sql = """select r.project_resource_id, r.title, r.description, r.location_id, l.name as location_name,
                            r.image_id, r.url, r.contact_email, r.physical_address, replace(r.keywords, ' ', ',') as keywords
                    from project_resource r
                    inner join location l on l.location_id = r.location_id
                    where r.is_active = 1 and r.is_hidden = 0 and r.contact_user_id = $id"""
            data = list(self.db.query(sql, {'id': self.id}))
        except Exception, e:
            log.info("*** couldn't get user resources")
            log.error(e)
Ejemplo n.º 50
0
def approveProjectResource(db, projectResourceId, isOfficial=False):
    try:
        db.update('project_resource',
                  where="project_resource_id = $projectResourceId",
                  is_hidden=0,
                  is_official=isOfficial,
                  vars={'projectResourceId': projectResourceId})
        return True
    except Exception, e:
        log.info("*** couldn't approve project resource %s" %
                 projectResourceId)
        log.error(e)
        return False
Ejemplo n.º 51
0
def assignUserToGroup(db, userId, userGroupId):
    try:
        db.update('user',
                  where="user_id = $id",
                  group_membership_bitmask=util.setBit(1, int(userGroupId)),
                  vars={'id': userId})

        return True
    except Exception, e:
        log.info("*** couldn't assign user id %s to group id %s" %
                 (userId, userGroupId))
        log.error(e)
        return False
Ejemplo n.º 52
0
 def add(cls,
         db,
         data,
         app,
         max_size=None,
         grayscale=False,
         mirror=True,
         thumb_max_size=None):
     log.info("ImageServer.add")
     try:
         id = db.insert('images', app=app)
     except Exception, e:
         log.error(e)
         return None
Ejemplo n.º 53
0
def addInvitedIdeaToProject(db, projectId, userId):
    try:
        sql = """insert into project__idea (project_id, idea_id)
                  select $projectId, inv.invitee_idea_id from project_invite inv
                    inner join idea i on i.idea_id = inv.invitee_idea_id and i.user_id = $userId
                    where project_id = $projectId
                    limit 1"""    
        db.query(sql, {'projectId':projectId, 'userId':userId})
        
        return True
    except Exception, e:
        log.info("*** couldn't add invited idea(s) from user id %s to project %s" % (userId, projectId))
        log.error(e)
        return False
Ejemplo n.º 54
0
    def require_login(self, url="/", admin=False):
        if not self.user:
            log.info("--> not logged in")
            self.redirect(url)
            return False
        # gam-specific admin
        #if admin and self.user['admin'] != 1:
        if (admin and not self.user.isAdmin):
            log.info("--> not an admin")

            self.redirect(url)

            return False
        return True
Ejemplo n.º 55
0
    def isProjectAdmin(self, projectId):
        sql = "select is_project_admin from project__user where user_id = $userId and project_id = $projectId and is_project_admin = 1 limit 1"

        try:
            data = self.db.query(sql, {
                'userId': self.id,
                'projectId': projectId
            })

            return (len(data) > 0)
        except Exception, e:
            log.info("*** couldn't get user project admin status")
            log.error(e)
            return False
Ejemplo n.º 56
0
def getAdminUsers(db, limit=10, offset=0):
    betterData = []

    try:
        sql = """select distinct
                    u.user_id
                    ,u.email
                    ,u.first_name
                    ,u.last_name
                    ,u.affiliation
                    ,u.group_membership_bitmask
                    ,u.is_oncall
                from user u
                where u.is_active = 1
                   and u.group_membership_bitmask > 1
                order by u.last_name
                limit $limit offset $offset"""
        data = list(db.query(sql, {'limit': limit, 'offset': offset}))

        for item in data:
            betterData.append({
                'user_id':
                item.user_id,
                'email':
                item.email,
                'first_name':
                item.first_name,
                'last_name':
                item.last_name,
                'affiliation':
                item.affiliation,
                'group_membership_bitmask':
                item.group_membership_bitmask,
                'full_display_name':
                mProject.userNameDisplay(
                    item.first_name, item.last_name, item.affiliation,
                    mProject.isFullLastName(item.group_membership_bitmask)),
                'is_admin':
                isAdminBitmask(item.group_membership_bitmask),
                'is_moderator':
                isModeratorBitmask(item.group_membership_bitmask),
                'is_leader':
                isLeaderBitmask(item.group_membership_bitmask),
                'is_oncall':
                item.is_oncall
            })
    except Exception, e:
        log.info("*** couldn't get admin users")
        log.error(e)
Ejemplo n.º 57
0
    def execute(self):
        """
        Execute task.
        
        """
        try:
            if callable(self.func):
                self.func(self.args)
            else:
                log.info("--> (not callable)")

            return True
        except Exception, e:
            log.error("Task: %s" % e)
            return False
Ejemplo n.º 58
0
    def add(self, tube=None, func=None, data=None, timeout=120):
        """
        Add a task to queue and use specific tube if provided.
        
        """
        if self.queue is None:
            log.warning(
                "Attempted to add task, but task queue is not running.")
            return

        if tube is not None:
            self.queue.use(tube)

        log.info("Tasks.add tube[%s] func[%s]" % (self.queue.using(), func))
        self.queue.put(pickle.dumps(Task(func, data)), ttr=timeout)
Ejemplo n.º 59
0
def updateProjectResourceTextData(db, projectResourceId, field, text):
    isHidden = (censor.badwords(db, text) > 0)

    try:
        sql = "update project_resource set %s = $text, is_hidden = $isHidden where project_resource_id = $id" % field
        db.query(sql, {
            'id': projectResourceId,
            'text': text,
            'isHidden': isHidden
        })
        return True
    except Exception, e:
        log.info("*** couldn't update project %s" % field)
        log.error(e)
        return False