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 """