def create_job(self, company):
job = Job()
self.populate_obj(job)
job.company_id = company.id
db.session.add(job)
db.session.commit()
return job
def job_edit():
job_id = request.args.get('job_id')
try:
job_id = int(job_id)
except TypeError:
pass
if job_id:
job = Job.query.get_or_404(job_id)
form = JobForm(obj=job)
if form.validate_on_submit():
form.populate_obj(job)
form.create_job(job)
flash('修改成功', 'success')
return redirect(url_for('company.job'))
else:
job = Job()
form = JobForm()
if form.validate_on_submit():
# 增加缺少的数据
job_id = Company.query.filter_by(user_id=current_user.id).id
job.id = job.job_id
job.state = 1
form.populate_obj(job)
form.create_job(job)
flash('创建成功', 'success')
return render_template('company/admin_job_edit.html', form=form)
def create_job(self, user): #创建新工作
job = Job()
self.populate_obj(job)
job.company_id = user.company.id
db.session.add(job)
db.session.commit()
return job
def create_job(self, company):
job = Job()
self.populate_obj(job)
job.company_id = company.id
db.session.add(job)
db.session.commit()
return job
def test_job(self,db,company):
assert Job.query.count() == 1
job = Job(name='soft engineer',requirement='10 years',wage='112233k')
job.company = Company.query.first()
db.session.add(job)
db.session.commit()
assert Job.query.count() == 2
def company(db):
company = Company(company_name='jobplus',
location='beijing',
description='this is jobplus')
job = Job(job_title='software_engineer',
requirements='python',
salary='100k')
job.company = company
db.session.add(company)
db.session.commit()
return company, job
def add_job(self):
job = Job()
self.populate_obj(job)
job.company = current_user.company
db.session.add(job)
db.session.commit()
flash("职位添加成功", 'success')
return job
def company(db):
company = Company(company.name='aliyeye',
website='aliyeye.com',
description='this is a good place')
job = Job(job.name='software_engineer',
requirement='python',
wage='1000k/month')
job.company = company
db.session.add(company)
db.session.commit()
return company, job
def create_job(self, id):
job = Job()
self.populate_obj(job)
job.company_id = id
db.session.add(job)
try:
db.session.commit()
flash('职位添加成功', 'success')
except:
db.session.rollback()
flash('职位信息创建失败', 'info')
return job
def test_job(self, db, company):
assert Job.query.count() == 1
job = Job(job_title='software engineer',
requirements='10 years',
salary='50k')
job.company = Company.query.first()
db.session.add(job)
db.session.commit()
assert Job.query.count() == 2
def job_tag_create(job_id):
tag_name = request.form.get('name', None)
if not tag_name:
flash('标签名不能为空', 'danger')
return redirect(request.referrer)
tag = Tag.query.filter_by(name=tag_name).first()
job = Job.query.get_or_404(job_id)
if not tag:
tag = Tag(name=tag_name)
Job.add_tag(job, tag)
flash('添加标签成功', 'success')
return redirect(url_for('tag.job_tag', job_id=job_id))
def fake_data(self):
for company in self.companies[:]:
print(company["name"])
# 创建企业用户
c = User(
username=company["name"],
email=fake.email(),
role=User.ROLE_COMPANY
)
c.password = "******"
db.session.add(c)
try:
db.session.commit()
except:
db.session.rollback()
continue
# 创建企业信息
d = Company(
name=company["name"],
email=c.email,
logo=company["logo"],
site=company["site"],
location=company["localtion"],
description = company["description"],
about = company["about"].strip("0/1000取消保存").strip("关于我们"),
tags=company["tags"]
)
d.user_id = c.id
db.session.add(d)
db.session.commit()
# 发布企业职位
job_list = self.get_job(company["id"])
for item in job_list:
job = Job(
name=item["name"],
salary_low=int(item["salary_low"].strip("k")) * 1000,
salary_high=int(item["salary_high"].strip("k")) * 1000,
location=item["location"],
tags=item["tags"],
experience_requirement=item["experience_requirement"],
degree_requirement=item["degree_requirement"],
description =item["raw_description"]
)
job.company_id = d.id
db.session.add(job)
db.session.commit()
def create_job(self):
job = Job()
company = Company.query.filter_by(user_id=current_user.id).first()
job.company_id = company.id
job.job_name = self.job_name.data
job.wage_area = self.wage_area.data
job.experience_required = self.experience_required.data
job.edu_required = self.edu_required.data
job.working_address = self.working_address.data
job.welfare = self.welfare.data
job.job_description = self.job_description.data
db.session.add(job)
db.session.commit()
return job
def addjob(self, company=None):
job = Job(name=self.name.data,
requirements=self.requirements.data,
salary_range=self.salary_range.data,
description=self.description.data,
edulevel=self.edulevel.data,
experlevel=self.experlevel.data,
tags=self.tags.data,
cities=self.cities.data)
if company:
job.company = company
db.session.add(job)
db.session.commit()
return job
def item_jobs():
with open("jobs.json", 'r', encoding="utf8") as f:
jobs = json.load(f)
print(jobs)
job_list = []
company_list = []
for job in jobs:
company = Company(name=job["company"],
address=job["address"],
net_site=job["net_site"],
logo=job["logo"],
introduce=faker.sentence(),
detail=job["desc"],
city=job["city"],
financing=job["financing"],
company_field=job["company_field"],
company_scale=job['company_scale'])
jobdata = Job(job_title=job['job_title'],
work_experience=job['work_experience'],
study_experience=job['study_experience'],
salary_range=job['xinshui'],
work_tags=job['work_tags'],
company_msg=company)
job_list.append(jobdata)
company_list.append(company)
return job_list, company_list
def create_user_and_company():
with open('scripts/data_company.json') as f1, \
open('scripts/data_job.json') as f2:
job_name_list = [i['name'] for i in json.load(f2)]
experience_list = ['不限', '1-3年', '3-5年', '5-10年']
degree_list = ['不限', '本科', '博士后']
for i in json.load(f1):
user = User(username=fake.name(), email=fake.email())
user.password = '******'
yield user
company = Company(
name = i['name'],
logo = i['logo'],
location = i['location'],
description = i['description'],
about = i['about'] if len(i['about']) > 9 else \
fake.sentence(nb_words=11),
tags = i['tags'],
user = user,
)
yield company
for i in range(randint(1, 5)):
job = Job(
name = job_name_list[randint(1, len(job_name_list))-1],
salary_low = randint(3, 8) * 1000,
salary_high = randint(9, 15) * 1000,
location = fake.address(),
is_fulltime = 1,
experience_requirement = experience_list[
randint(1, len(experience_list)) - 1],
degree_requirement = degree_list[
randint(1, len(degree_list)) - 1],
company = company
)
yield job
def iter_job():
num = User.query.filter_by(name='company').first().id
print(num)
yield Job(name='工程师',
wage='80万/年',
location='北京',
company=Company.query.filter_by(user_id=num).first(),
description='我们需要招的是工程师',
requirement='我们需要有10年的工作经验')
def addjob(self):
job = Job(name=self.name.data,
requirements=self.requirements.data,
salary_range=self.salary_range.data,
company=self.company.data,
tags=self.tags.data,
cities=self.cities.data)
db.session.add(job)
db.session.commit()
def iter_jobs():
company_user = User.query.filter_by(username='******').first()
for i in range(5):
yield Job(name=fake.job(),
low=randint(6000, 10000),
high=randint(10001, 20000),
tags=fake.color_name(),
experience=fake.text(max_nb_chars=30),
description=fake.text(max_nb_chars=100),
company=company_user)
def iter_jobs():
company_user = User.query.filter_by(username='******').first()
for i in range(30):
yield Job(name=fake.job(),
low=randint(6000, 10000),
high=randint(10001, 20000),
tags=fake.color_name() + ';' + fake.color_name(),
experience=str(randint(0, 50)) + '-' + str(randint(51, 100)),
description=fake.text(max_nb_chars=100),
company=company_user,
degree=choice(['不限', '大专', '本科', '硕士']))
def iter_job_data():
with open(os.path.join(os.path.dirname(__file__), 'job.json')) as f:
job_datas = json.load(f)
for job in job_datas:
yield Job(name=job['name'],
salary=job['salary'],
experience=job['experience'],
location=job['location'],
degree=job['degree'],
description=fake.text(),
job_url=job['img_url'])
def save(self, company):
job = Job(company=company,
name=self.name.data,
salary=self.salary.data,
addr=self.addr.data,
experience=self.experience.data,
desc=self.desc.data,
requires=self.requires.data)
db.session.add(job)
db.session.commit()
def iter_job_data():
with open('./scripts/getjob.json', 'r', encoding="utf-8") as f:
job_datas = json.load(f)
for job in job_datas:
if job.get('company_logo'):
yield Job(name=job['job_name'],
salary=job['job_salary'],
experience=job['job_experence'],
location=job['job_station'],
degree=job['job_degree'],
description=job['job_description'],
job_url='http:' + job.get('company_logo'))
else:
yield Job(name=job['job_name'],
salary=job['job_salary'],
experience=job['job_experence'],
location=job['job_station'],
degree=job['job_degree'],
description=job['job_description'],
job_url="http://img01.zhaopin.cn/2012/img/logo.png")
def iter_job():
for company in CompanyDetail.query:
for i in range(2):
yield Job(jobname=fake.job(),
salary_min=random.randint(2, 5) * 1000,
salary_max=random.randint(6, 10) * 1000,
exprience=random.randint(0, 5),
location=fake.city(),
job_tag=fake.word(),
job_description=fake.word(),
job_requirement=fake.sentence(),
company_id=company.id)
def create_job(self, company_id):
job = Job(name=self.name,
salary=self.salary,
location=self.location,
condition=self.condition,
experience=self.experience,
degree=self.degree,
description=self.description,
company_id=company_id)
db.session.add(job)
db.session.commit()
return job
def iter_jobs():
company = Company.query.filter_by(company_name='JD').first()
with open(os.path.join(os.path.dirname(__file__), '..', 'datas',
'jobs.json'),
encoding='utf-8-sig') as f:
jobs = json.load(f)
for job in jobs:
yield Job(title=job['name'],
company=company,
salary=job['salary'],
experience=job['experience'],
release_time=job['create_date'])
def iter_jobs():
company = Company.query.order_by(Company.id).first()
with open(
os.path.join(os.path.dirname(__file__), '..', 'datas',
'jobs.json')) as f:
jobs = json.load(f)
for job in jobs:
yield Job(title=job['title'],
salary=job['salary'],
location=job['location'],
experience=job['experience'],
company=company)
def iter_jobs():
companies = User.query.filter_by(role=User.ROLE_COMPANY).all()
with open(os.path.join(os.path.dirname(__file__), '..', 'datas', 'jobs.json'), encoding='utf-8') as f:
jobs = json.load(f)
for job in jobs:
company = random.choice(companies)
yield Job(
title=job['title'],
salary=job['salary'],
location=job['location'],
experience=job['experience'],
company=company
)
def fake_jobs():
companies = Company.query.all()
for i in range(len(companies)):
job = Job(name=faker_data[i]['job'],
salary=faker_data[i]['salary'],
work_year=faker_data[i]['work_year'],
degree=faker_data[i]['degree'],
company_id=companies[i].id)
db.session.add(job)
db.session.commit()
def iter_jobs():
company = User.query.filter_by(email='*****@*****.**').first()
with open(os.path.join(os.path.dirname(__file__), 'datas',
'job.json')) as f:
jobs = json.load(f)
for job in jobs:
yield Job(name=job['name'],
salary_low=job['salary_low'],
salary_high=job['salary_high'],
experience_requirement=job['experience_requirement'],
degree_requirement=job['degree_requirement'],
company=company)
def iter_jobs_msg():
with open(
os.path.join(os.path.dirname(__file__), '..', 'datas',
'jobsmsg.json')) as ff:
jobs = json.load(ff)
for job in jobs:
yield Job(name=job['name'],
degree_requirement=job['degree_requirement'],
experience_requirement=job['experience_requirement'],
salary=job['salary'],
address=job['address'],
tags=job['tags'],
company=User.query.filter_by(name=job['company']).first())
