-
Notifications
You must be signed in to change notification settings - Fork 5
/
jobs_master.py
31 lines (24 loc) · 998 Bytes
/
jobs_master.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
# -*- coding: utf-8 -*-
"""Jobs Master ORM"""
from . import Base
import sqlalchemy as db
from sqlalchemy.orm import relationship
class JobMaster(Base):
__tablename__ = 'jobs_master'
uuid = db.Column(db.String, primary_key=True)
onet_soc_code = db.Column(db.String)
title = db.Column(db.String)
original_title = db.Column(db.String)
description = db.Column(db.String)
nlp_a = db.Column(db.String)
alternate_titles = relationship('JobAlternateTitle', backref='job', lazy='dynamic')
unusual_titles = relationship('JobUnusualTitle', backref='job', lazy='dynamic')
def __init__(self, uuid, onet_soc_code, title, original_title, description, nlp_a):
self.uuid = uuid
self.onet_soc_code = onet_soc_code
self.title = title
self.original_title = original_title
self.description = description
self.nlp_a = nlp_a
def __repr__(self):
return '<soc code {}/uuid {}>'.format(self.onet_soc_code, self.uuid)