Python get_pos Examples

Example #1

File: create_position_name1.py Project: fengkaicnic/pyml

import os
import json
import sys
import re
import MySQLdb
import time
import pdb
import codecs
from jobs import utils
from jobs.majorposition import get_position
from jobs.utils import get_industry_position

reload(sys)
start = time.clock()
sys.setdefaultencoding("utf8")
postdct = get_position.get_pos()

try:

    conn = MySQLdb.connect(host="localhost", user="******", passwd="123456", db="jobs", use_unicode=True, charset="utf8")
    cur = conn.cursor()
    cur.execute("set character_set_client=utf8")
    cur.execute("set character_set_connection=utf8")
    cur.execute("set character_set_database=utf8")
    cur.execute("set character_set_results=utf8")
    cur.execute("set character_set_server=utf8")
    # sql = 'select userid from jobs_uinfotest'

    #     pdb.set_trace()
    position_dct = {}
    industryr = utils.read_rst("industryr.txt")

Example #2

File: position_indus.py Project: devilWwj/pyml

#encoding:utf8
import os
import json
import sys
import re
import MySQLdb
import time
import codecs
from jobs import utils
from jobs.majorposition import get_position
reload(sys)
start = time.clock()
sys.setdefaultencoding('utf8')
postdct = get_position.get_pos()

try:

    conn = MySQLdb.connect(host='localhost',
                           user='******',
                           passwd='123456',
                           db='jobs',
                           use_unicode=True,
                           charset='utf8')
    cur = conn.cursor()
    cur.execute('set character_set_client=utf8')
    cur.execute('set character_set_connection=utf8')
    cur.execute('set character_set_database=utf8')
    cur.execute('set character_set_results=utf8')
    cur.execute('set character_set_server=utf8')
    #sql = 'select userid from jobs_uinfotest'
    import pdb

Example #3

            position_dct[uline] = '1'
    return position_dct


def get_share_mar():
    major_dct = {}
    with codecs.open('sharemajor') as file:
        lines = file.readlines()
        for linet in lines:
            line = linet[:-2]
            uline = unicode(line)
            major_dct[uline] = '1'
    return major_dct


postpropertydct = get_position.get_pos()

try:

    conn = MySQLdb.connect(host='localhost',
                           user='******',
                           passwd='123456',
                           db='jobs',
                           use_unicode=True,
                           charset='utf8')
    cur = conn.cursor()
    cur.execute('set character_set_client=utf8')
    cur.execute('set character_set_connection=utf8')
    cur.execute('set character_set_database=utf8')
    cur.execute('set character_set_results=utf8')
    cur.execute('set character_set_server=utf8')

Example #4

File: generate_postrain.py Project: fengkaicnic/pyml

            line = linet[:-2]
            uline = unicode(line)
            position_dct[uline] = '1'
    return position_dct

def get_share_mar():
    major_dct = {}
    with codecs.open('sharemajor') as file:
        lines = file.readlines()
        for linet in lines:
            line = linet[:-2]
            uline = unicode(line)
            major_dct[uline] = '1'
    return major_dct

postpropertydct = get_position.get_pos()

try:
    
    conn = MySQLdb.connect(host='localhost', user='******', passwd='123456', db='jobs', use_unicode=True, charset='utf8')
    cur = conn.cursor()
    cur.execute('set character_set_client=utf8')
    cur.execute('set character_set_connection=utf8')
    cur.execute('set character_set_database=utf8')
    cur.execute('set character_set_results=utf8')
    cur.execute('set character_set_server=utf8')
    file = open('d:/jobs/dctree/position/train.csv', 'w+')
    sql = 'select userid, age, bstart_year, gender, shortmar from jobs_uinfo'
    cur.execute(sql)
    userdlst = cur.fetchall()
    sqlze = 'select wk.salary, wk.industry, wk.position_name from work_size as wk'