def post(self):
form = ColumnCreateForm()
if not form.validate_on_submit():
return form.errors, 422
column = Column(form.name.data, form.description.data)
column.tasks = []
db.session.add(column)
db.session.commit()
return ColumnSerializer(column).data, 201
def post(self):
form = ColumnCreateForm()
if not form.validate_on_submit():
return form.errors, 422
column = Column(form.name.data, form.description.data)
column.tasks = []
db.session.add(column)
db.session.commit()
return ColumnSerializer(column).data, 201
def setColumn():
name = request.values.get('name', type=str)
introduction = request.values.get('introduction', type=str)
currentTime = getCurrentDateTime()
phone = current_user.get_id()
picture = savePhotoRequestFile('picture', 'photos/avatar')
columnType = request.values.get('columnType', type=int)
father_id = request.values.get('father_id', type=int)
column = Column(name=name,
introduction=introduction,
time=currentTime,
phone=phone,
picture=picture,
type=columnType,
father_id=father_id)
db.session.add(column)
db.session.commit()
return json.dumps(
sendData(
True, {
"id": column.id,
"name": column.name,
"introduction": column.introduction,
"time": str(column.time),
"phone": column.phone,
"picture": column.picture,
"type": column.type
}, "OK"))
def load_columns(file_name):
'''
Load columns from CSV file
:param file_Name: The name of the CSV file to load column metadata from
'''
LOGGER.info("Loading column metadata...")
with open(file_name, 'rt') as csvfile:
reader = csv.DictReader(csvfile, delimiter=',')
for row in reader:
LOGGER.info("Loading table %s column %s", row['table'],
row['name'])
t = Table.query.filter_by(name=row['table']).first()
record = Column(
**{
'name': row['name'],
'description': row['description'],
'type': row['type'],
'length': row['length'],
'format': row['format'],
'table': t
})
db.session.add(record)
db.session.commit()
def test_add_column(self):
"""添加专题"""
test_column = Column(column='test',
timestamp='2018-08-18',
url_name='test-column',
body='This is a test column.')
db.session.add(test_column)
db.session.commit()
column = Column.query.filter_by(column='test').first()
self.assertIsNotNone(column)
def post(self):
user_id = session['user']['sub']
new_column = Column(name=request.json['name'],
user_id=user_id,
locations=",".join(request.json['locations']),
user_query=request.json['user_query'],
order=request.json['order'])
db.session.add(new_column)
db.session.commit()
return column_schema.dump(new_column)
def add_n_corpora(self, n_corpus: int, **kwargs):
if not self.AUTO_LOG_IN:
raise Exception("This function only works with autologin")
user = User.query.filter(
User.email == self.app.config['ADMIN_EMAIL']).first()
for n in range(n_corpus):
corpus = Corpus(name="a" * n,
control_lists_id=1,
columns=[
Column(heading="Lemma"),
Column(heading="POS"),
Column(heading="Morph"),
Column(heading="Similar"),
])
new_cu = CorpusUser(corpus=corpus, user=user, is_owner=True)
db.session.add(corpus)
db.session.add(new_cu)
db.session.flush()
db.session.commit()
from app.models import Corpus, WordToken, AllowedLemma, AllowedPOS, AllowedMorph, Column
from app.models import ControlLists, ControlListsUser
Floovant = Corpus(
name="Floovant",
id=2,
control_lists_id=2
)
FloovantColumns = [
Column(heading="Lemma", corpus_id=2),
Column(heading="POS", corpus_id=2),
Column(heading="Morph", corpus_id=2),
Column(heading="Similar", corpus_id=2),
]
FCL = ControlLists(id=2, name="Floovant")
FloovantTokens = [
WordToken(corpus=Floovant.id, form="SOIGNORS", lemma="seignor", left_context="", right_context="or escoutez que",
label_uniform="seignor", morph="NOMB.=p|GENRE=m|CAS=n"),
WordToken(corpus=Floovant.id, form="or", lemma="or4", left_context="SOIGNORS", right_context="escoutez que Dés",
label_uniform="or4", morph="DEGRE=-"),
WordToken(corpus=Floovant.id, form="escoutez", lemma="escouter", left_context="SOIGNORS or",
right_context="que Dés vos", label_uniform="escouter", morph="MODE=imp|PERS.=2|NOMB.=p"),
WordToken(corpus=Floovant.id, form="que", lemma="que4", left_context="SOIGNORS or escoutez",
right_context="Dés vos soit", label_uniform="que4", morph="_"),
WordToken(corpus=Floovant.id, form="Dés", lemma="dieu", left_context="or escoutez que",
right_context="vos soit amis", label_uniform="dieu", morph="NOMB.=s|GENRE=m|CAS=n"),
WordToken(corpus=Floovant.id, form="vos", lemma="vos1", left_context="escoutez que Dés",
right_context="soit amis III", label_uniform="vos1", morph="PERS.=2|NOMB.=p|GENRE=m|CAS=r"),
WordToken(corpus=Floovant.id, form="soit", lemma="estre1", left_context="que Dés vos",
right_context="amis III vers", label_uniform="estre1", morph="MODE=sub|TEMPS=pst|PERS.=3|NOMB.=s"),
l1 = Link.query.filter_by(id=2).first() print(l1.text) t.links.append(l1) l2 = Link.query.filter_by(id=4).first() t.links.append(l2) db.session.commit() # Create Table and Columns l = Location(name='PROD_DB', description='/data/prod/risk_mart'); t = Table(name='ACCOUNT_HISTORY', location=l) c1 = Column(name='DATE_KEY', type='NUM', length='8', format='DATE9.', table=t) c2 = Column(name='ACCOUNT_ID', type='NUM', length='8', format='21.', table=t) c3 = Column(name='APPLICATION_ID', type='NUM', length='8', format='3.', table=t) c4 = Column(name='BALANCE_AMT', type='NUM', length='8', format='20.', table=t) db.session.add(l) db.session.add(t) db.session.add(c1) db.session.add(c2) db.session.add(c3) db.session.add(c4) # Create Business Rule t = Term.query.filter_by(id=1).first() r = Rule(identifier='BR_001', name='New Customer Rule', description='This is a new customer rule', notes='Detailed description of the rule. Typically written in structured English or pseudo code. Consider using a flowchart or UML activity diagram to depict procedural logic.')
def seed_db(db: Session):
seed_data = [
Team(team_name='Marketing'),
Team(team_name='Engineering'),
Project(team_id=1, project_name='Advertisement'),
Project(team_id=1, project_name='SEO'),
Project(team_id=2, project_name='API v2'),
Column(column_pos=0, project_id=1, column_name='Preproduction'),
Column(column_pos=1, project_id=1, column_name='Processing'),
Column(column_pos=2, project_id=1, column_name='Postproduction'),
Column(column_pos=3, project_id=1, column_name='Final'),
Column(column_pos=0, project_id=2, column_name='To do'),
Column(column_pos=0, project_id=3, column_name='Pre-process'),
Column(column_pos=1, project_id=3, column_name='Post-process'),
Task(column_id=1, column_idx=0, task_description='Research'),
Task(column_id=1, column_idx=1, task_description='Due diligence'),
Task(column_id=2, column_idx=0, task_description='A+B Testing'),
Task(column_id=2, column_idx=1, task_description='Sampling'),
Task(column_id=2, column_idx=2, task_description='Filming'),
Task(column_id=3, column_idx=0, task_description='Casting'),
Task(column_id=4, column_idx=0, task_description='Budget'),
Task(column_id=4, column_idx=1, task_description='Design campaign'),
Task(column_id=4,
column_idx=2,
task_description='Hire production crew'),
Task(column_id=5, column_idx=0, task_description='Use Google'),
Task(column_id=6, column_idx=0, task_description='Write application'),
Task(column_id=6, column_idx=1, task_description='Profit'),
Task(column_id=7, column_idx=0,
task_description='Gather requirements'),
Task(column_id=7, column_idx=1, task_description='Design specs'),
Task(column_id=7, column_idx=2, task_description='Hire engineers'),
User(first_name='Bob',
last_name='Smith',
email='*****@*****.**',
hashed_password='******',
team_id=1),
User(first_name='Sally',
last_name='McBeth',
email='*****@*****.**',
hashed_password='******',
team_id=1),
User(first_name='John',
last_name='Applebaum',
email='*****@*****.**',
hashed_password='******',
team_id=1),
User(first_name='Bill',
last_name='McSorley',
email='*****@*****.**',
hashed_password='******',
team_id=2)
]
try:
db.add_all(seed_data)
db.commit()
logger.info('database seed complete.')
except (IntegrityError, OperationalError) as e: # if data already exists
logger.warning(e.orig)
logger.info('data already exists. skipping seed.')