def enter_pris(): from models import Priority, db high = Priority(name='High') med = Priority(name='Medium') low = Priority(name='Low') db.session.add(high) db.session.add(med) db.session.add(low) db.session.commit() # create_model() # enter_cats() # enter_pris()
def test_convert_fields(): with open('tests/db_sync_pipelines/roles_example_response.json') as f: example_response = json.loads(f.read()) converter = AirtableRoleConverter() first_role = example_response[0] result = converter.Convert(first_role) assert result.external_id == 'recapqTKNF97KJGBr' assert result.role_name == 'Team Lead' assert type(result.hero_image_urls) == list and type( result.hero_image_urls[0]) == dict assert result.hero_image_url == "https://dl.airtable.com/.attachments/1f6a1176be07c79fa1a7933e6c75e288/736de524/pexels-photo-3571094.jpeg" assert result.signup_url == 'https://airtable.com/shrPDKeg64PI5oYyt?prefill_All+Volunteer+Positions=Team%20Lead%20-%20Humanity%20TEXTS' assert result.details_url == None assert result.overview == 'The Team Lead for Texting will manage the Humanity Forward Texting...' assert result.benefits == '- Expert in managing Texting Campaigns\\n- How to build and retain...' assert result.priority == Priority('Top Priority') assert result.team == ['recFUK4YHha3DnrXM'] assert result.team_lead_ids == ['recLxQ0EAN3jacrCs'] assert result.num_openings == None assert result.min_time_commitment == 4 assert result.max_time_commitment == 6 assert result.responsibilities == '- Setup texting campaigns\\n- Manage the texting teams...' assert result.qualifications == '- Knowledge of the Spoke Texting platform\\n- Good language skills...' assert result.role_type == RoleType('Requires Application') assert result.airtable_last_modified == datetime(2020, 11, 20, 16, 42, 54, tzinfo=timezone.utc) assert result.updated_at is None # This won't be set until a db transaction is committed.
def create_priority(): """ Create property and return list of property objects :return object: """ session.add(Priority()) session.commit() return query(Priority).all()
def setUp(self): self.client = app.test_client() db.drop_all() db.create_all() c1 = Category( category_id=0, category_label="Technical Issue" ) p1 = Priority( priority_id=1, priority_label="Medium" ) s1 = Status( status_id=0, status_label="Submitted" ) ro1 = Role( role_id=0, role_label="user" ) ro2 = Role( role_id=1, role_label="assignee" ) ro3 = Role( role_id=2, role_label="admin" ) db.session.add_all([c1,p1,s1,ro1,ro2,ro3]) db.session.commit() User.query.delete() Issue.query.delete() user1 = User.register(**TEST_USER1) user2 = User.register(**TEST_USER2) user1.role = 2 db.session.add_all([user1,user2]) db.session.commit() issue1 = Issue(title="Test Issue 1", text="Issue 1 description", reporter=user1.id) issue2 = Issue(title="Test Issue 2", text="Issue 2 description", reporter=user2.id) db.session.add_all([issue1,issue2]) db.session.commit() comment1 = Comment(comment_text="This is a comment", comment_user=2, comment_issue=2) db.session.add(comment1) db.session.commit()
def add_update_Priority(): print 'TEST: Inside Priority Route.' error = None if request.method == 'POST': print 'TEST: Inside POST block for Add Priority.' priority_name = request.json['priority_name'] priority_status = request.json['priority_status'] output = [] checkPriority = Priority.query.filter_by(Priority_name = priority_name).first() if checkPriority and checkPriority.Priority_name: output.append(dict(Msg = 'Priority already present.')) elif priority_name and priority_status: new_priority = Priority(Priority_name = priority_name, Priority_status = priority_status) db.session.add(new_priority) db.session.commit() output.append(dict(Msg = 'Priority added successfully.')) status_code = 200 else: status_code = 400 output.append(dict(Msg = 'Priority not added, please try again.')) if request.method == 'PUT': print 'TEST: Inside PUT block for Update Priority.' priority_id = request.json['priority_id'] priority_name = request.json['priority_name'] priority_status = request.json['priority_status'] output = [] updateThisPriority = Priority.query.filter_by(Priority_id = priority_id).first() if updateThisPriority: updateThisPriority.Priority_name = priority_name updateThisPriority.Priority_status = priority_status db.session.commit() output.append(dict(Msg = 'Priority updated successfully.')) status_code = 200 else: status_code = 400 output.append(dict(Msg = 'Priority not present.')) return jsonify({'result' : output, 'status_code':status_code })
def setUp(self): self.priority = Priority('quickly')
def setUp(self): self.priotity = Priority('quickly') self.status = Status('in progress') self.task = Tasks('calculation', '01.01.2020', '07.01.2020', self.priotity, self.status)
def new_pri(): name_add = request.args.get('nm',None) db.session.add(Priority(name=name_add)) db.session.commit() return redirect('/')
from todoapp import app from models import db db.create_all() from models import Category work = Category(name=u'name') home = Category(name=u'home') db.session.add(work) db.session.add(home) db.session.commit() from models import Priority high = Priority(name=u'high', value=3) medium = Priority(name=u'medium', value=2) low = Priority(name=u'low', value=1) db.session.add(high) db.session.add(medium) db.session.add(low) db.session.commit()
from app import app from models import db, connect_db, User, Issue, Comment, Priority, Status, Category, Role # Drop db tables and create them anew db.drop_all() db.create_all() # Priority p1 = Priority(priority_id=0, priority_label="Low") p2 = Priority(priority_id=1, priority_label="Medium") p3 = Priority(priority_id=2, priority_label="High") p4 = Priority(priority_id=3, priority_label="Urgent") # Status s1 = Status(status_id=0, status_label="Submitted") s2 = Status(status_id=1, status_label="Assigned") s3 = Status(status_id=2, status_label="Resolved") # Category c1 = Category(category_id=0, category_label="Technical Issue") c2 = Category(category_id=1, category_label="Customer Complaint")
session.add(addDefault) addPersonal = Category(category_name="Personal") session.add(addPersonal) addShopping = Category(category_name="Shopping") session.add(addShopping) addWishlist = Category(category_name="Wishlist") session.add(addWishlist) addWork = Category(category_name="Work") session.add(addWork) """ Insert pre-defined priorities """ addHigh = Priority(priority_name="High") session.add(addHigh) addMedium = Priority(priority_name="Medium") session.add(addMedium) addLow = Priority(priority_name="Low") session.add(addLow) """ Insert pre-defined status """ addOngoing = Status(status_name="Ongoing") session.add(addOngoing) addCompleted = Status(status_name="Completed") session.add(addCompleted) """ Insert pre-defined activities """