Exemple #1
0
    def test_badwords(self):
        db = Mock()
        db.query = Mock(return_value=[{
            'kill_words': 'asshole other dirty words',
            'warn_words': 'jerk kinda bad stuff',
        }])

        self.assertEqual(censor.badwords(db, "asshole"), 2)
        self.assertEqual(censor.badwords(db, "jerk"), 1)
        self.assertEqual(censor.badwords(db, "unicorn"), 0)
 def test_badwords(self):
     db = Mock()
     db.query = Mock(return_value=[{
         'kill_words' : 'asshole other dirty words',
         'warn_words' : 'jerk kinda bad stuff',
     }])
     
     self.assertEqual(censor.badwords(db, "asshole"), 2)
     self.assertEqual(censor.badwords(db, "jerk"), 1)
     self.assertEqual(censor.badwords(db, "unicorn"), 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
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
Exemple #5
0
def createIdea(db, description, locationId, submissionType, userId=None, email=None, phone=None):
    try:
        # censor behavior
        numFlags = censor.badwords(db, description)
        isActive = 0 if numFlags == 2 else 1
        
        ideaId = db.insert('idea', description = description,
                                    location_id = locationId,
                                    submission_type = submissionType,
                                    user_id = userId,
                                    email = email,
                                    phone = phone,
                                    is_active = isActive,
                                    num_flags = numFlags)
    except Exception, e:
        log.info("*** problem creating idea")
        log.error(e)    
        return None