Esempio n. 1
0
def getMatchResumeQuery(keywords, experience, location, max_salary, last_time):
    keywords = [
        format.exactFormat(x) for x in keywords.replace(',', ' ').split()
    ]

    q = 'fulltext:(%s)' % fixQuery(' AND '.join(keywords))
    if experience: q += ' AND experience:[%s TO *]' % format.Int(experience)

    location = location.lower()
    if not (location == 'any'):
        if location in regions:
            q += ' AND pref_location:(anywhere OR %s OR %s)' % (
                location, fixQuery(' OR '.join(regions[location])))
        else:
            q += ' AND pref_location:(anywhere OR ' + fixQuery(location) + ')'

    if max_salary > 0:
        q += ' AND min_salary:[%s TO %s]' % (format.Int(0),
                                             format.Int(max_salary))

    q += ' AND indexed_on:[' + format.Date(last_time) + ' TO *]'

    return q
Esempio n. 2
0
def getMatchResumeQuery(keywords, experience, location, max_salary, last_time):
    keywords = [format.exactFormat(x) for x in keywords.replace(',', ' ').split() ]

    q = 'fulltext:(%s)' % fixQuery(' AND '.join(keywords))
    if experience:  q += ' AND experience:[%s TO *]' % format.Int(experience)

    location = location.lower()
    if not (location == 'any'):
        if location in regions:
            q += ' AND pref_location:(anywhere OR %s OR %s)' % (location, fixQuery(' OR '.join(regions[location])))
        else:
            q += ' AND pref_location:(anywhere OR ' + fixQuery(location) + ')'

    if max_salary > 0:
        q += ' AND min_salary:[%s TO %s]' % (format.Int(0), format.Int(max_salary))

    q += ' AND indexed_on:[' + format.Date(last_time) + ' TO *]'
    
    return q
Esempio n. 3
0
def feedResumes(limit_time):
    s = SearchClient()

    #deleted users have to be moved from index
    stmt = "SELECT user_id FROM website_indexdelta WHERE index_type = 'D' AND marked_at < %(limit_time)s;"
    cursor.execute(stmt, {'limit_time': limit_time})
    results = cursor.fetchall()
    deletions = []
    for row in results:
        print 'deleting.. ', str(row[0])
        deletions.append(IndexUpdateEntry('delete', str(row[0])))

    s.updateIndexes(deletions, CLUSTER_ID)

    #indexing the updated users
    stmt = """SELECT U.id, A.account_type, A.username, U.key, (CASE A.account_type WHEN 'FU' THEN U.email WHEN 'PU' THEN U.proxy_email END) As email,
            name, telephone, industry, experience, curr_employer, curr_designation, tags, summary, min_salary, pref_employment,
            pref_designation, pref_location, text_filepath, rating
            FROM website_user U INNER JOIN website_account A ON U.account_id = A.id
            WHERE U.id IN (SELECT user_id FROM website_indexdelta WHERE index_type = 'U' AND marked_at < %(limit_time)s)
            AND A.account_state = 'A' AND U.is_job_hunting = 'yes' ORDER BY U.id;"""
    cursor.execute(stmt, {'limit_time': limit_time})
    results = cursor.fetchall()

    update_list = []
    for (user_id, account_type, username, key, email, name, telephone, industry, experience, curr_employer, curr_designation, \
        tags, summary, min_salary, pref_employment, pref_designation, pref_location, text_filepath, rating) in results:

        if account_type == 'PU' or (account_type == 'FU' and text_filepath
                                    and os.path.exists(text_filepath)):

            meta = {}
            meta['id'] = str(user_id)
            meta['account_type'] = dataplus.decode(account_type)
            meta['username'] = dataplus.decode(username)
            meta['name'] = dataplus.decode(name)
            meta['key'] = dataplus.decode(key)
            meta['email'] = dataplus.decode(email)
            meta['telephone'] = dataplus.decode(telephone)
            meta['industry'] = dataplus.decode(industry)
            meta['experience'] = format.Int(experience)
            meta['curr_employer'] = dataplus.decode(curr_employer)
            meta['curr_designation'] = dataplus.decode(curr_designation)
            meta['tags'] = dataplus.decode(tags)
            meta['summary'] = dataplus.decode(summary)
            meta['min_salary'] = format.Int(min_salary)
            meta['pref_employment'] = dataplus.decode(pref_employment)
            meta['pref_designation'] = dataplus.decode(pref_designation)
            meta['pref_location'] = dataplus.decode(pref_location)
            meta['rating'] = format.Int(rating)
            meta['indexed_on'] = format.Date(limit_time)

            if account_type == 'FU':
                meta['fulltext'] = format.exactFormat(
                    meta['tags'] + dataplus.decode(open(text_filepath).read()))
            elif account_type == 'PU':
                meta['fulltext'] = format.exactFormat(meta['tags'] + '\n' +
                                                      meta['summary'])

            update_list.append(IndexUpdateEntry('update', str(user_id), meta))
            print user_id, dataplus.decode(meta['tags'])

    print 'finished creating meta data'
    #we are updating the Resume Store (store-name:resume)
    s.updateIndexes(update_list, CLUSTER_ID)
    print "updated indexes successfully"
Esempio n. 4
0
def feedResumes(limit_time):
    s = SearchClient()
    
    #deleted users have to be moved from index
    stmt = "SELECT user_id FROM website_indexdelta WHERE index_type = 'D' AND marked_at < %(limit_time)s;"
    cursor.execute(stmt, {'limit_time':limit_time})
    results = cursor.fetchall()
    deletions = []
    for row in results:
        print 'deleting.. ', str(row[0])
        deletions.append(IndexUpdateEntry('delete', str(row[0])))
        
    s.updateIndexes(deletions, CLUSTER_ID)

    #indexing the updated users
    stmt = """SELECT U.id, A.account_type, A.username, U.key, (CASE A.account_type WHEN 'FU' THEN U.email WHEN 'PU' THEN U.proxy_email END) As email,
            name, telephone, industry, experience, curr_employer, curr_designation, tags, summary, min_salary, pref_employment,
            pref_designation, pref_location, text_filepath, rating
            FROM website_user U INNER JOIN website_account A ON U.account_id = A.id
            WHERE U.id IN (SELECT user_id FROM website_indexdelta WHERE index_type = 'U' AND marked_at < %(limit_time)s)
            AND A.account_state = 'A' AND U.is_job_hunting = 'yes' ORDER BY U.id;"""
    cursor.execute(stmt, {'limit_time':limit_time})
    results = cursor.fetchall()

    update_list = []
    for (user_id, account_type, username, key, email, name, telephone, industry, experience, curr_employer, curr_designation, \
        tags, summary, min_salary, pref_employment, pref_designation, pref_location, text_filepath, rating) in results:
        
        if account_type == 'PU' or (account_type == 'FU' and text_filepath and os.path.exists(text_filepath)):
            
            meta = {}
            meta['id'] = str(user_id)
            meta['account_type'] = dataplus.decode(account_type)
            meta['username'] = dataplus.decode(username)
            meta['name'] = dataplus.decode(name)
            meta['key'] = dataplus.decode(key)
            meta['email'] = dataplus.decode(email)
            meta['telephone'] = dataplus.decode(telephone)
            meta['industry'] = dataplus.decode(industry)
            meta['experience'] = format.Int(experience)
            meta['curr_employer'] = dataplus.decode(curr_employer)
            meta['curr_designation'] = dataplus.decode(curr_designation)
            meta['tags'] = dataplus.decode(tags)
            meta['summary'] = dataplus.decode(summary)
            meta['min_salary'] = format.Int(min_salary)
            meta['pref_employment'] = dataplus.decode(pref_employment)
            meta['pref_designation'] = dataplus.decode(pref_designation)
            meta['pref_location'] = dataplus.decode(pref_location)
            meta['rating'] = format.Int(rating)
            meta['indexed_on'] = format.Date(limit_time)

            if account_type == 'FU':
                meta['fulltext'] = format.exactFormat(meta['tags'] + dataplus.decode(open(text_filepath).read()))
            elif account_type == 'PU':
                meta['fulltext'] = format.exactFormat(meta['tags'] + '\n' + meta['summary'])
                
            update_list.append(IndexUpdateEntry('update', str(user_id), meta))
            print user_id, dataplus.decode(meta['tags'])

    print 'finished creating meta data'
    #we are updating the Resume Store (store-name:resume)
    s.updateIndexes(update_list, CLUSTER_ID)
    print "updated indexes successfully"