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.')