def test_user_status():
attendance = Attendance(account_id=1)
attendance.status = 'registered'
a = Activity()
a.attendances = [attendance]
assert a.user_status(1) == 'Attendu'
assert a.user_status(2) == 'Statut inconnu'
assert a.is_participant(1)
assert not a.is_participant(2)
def record_attendances_view(context, request):
"""
Record attendances for the given context (workshop)
Special Note : Since we need a special layout in the form (with tabs and
lines with the username as header, we can't render it with deform. We
use peppercorn's parser and we build an appropriate form in the template
"""
schema = AttendanceSchema().bind(request=request)
if 'submit' in request.params:
controls = request.params.items()
values = peppercorn.parse(controls)
try:
appstruct = schema.deserialize(values)
except colander.Invalid as e:
log.error(u"Error while validating workshop attendance")
log.error(e)
else:
for datas in appstruct['attendances']:
account_id = datas['account_id']
timeslot_id = datas['timeslot_id']
obj = Attendance.get((account_id, timeslot_id))
obj.status = datas['status']
request.dbsession.merge(obj)
request.session.flash(u"L'émargement a bien été enregistré")
url = request.route_path(
'workshop',
id=context.id,
_query=dict(action="edit"),
)
return HTTPFound(url)
def record_attendances_view(context, request):
"""
Record attendances for the given context (workshop)
Special Note : Since we need a special layout in the form (with tabs and
lines with the username as header, we can't render it with deform. We
use peppercorn's parser and we build an appropriate form in the template
"""
schema = AttendanceSchema().bind(request=request)
if 'submit' in request.params:
controls = request.params.items()
values = peppercorn.parse(controls)
try:
appstruct = schema.deserialize(values)
except colander.Invalid as e:
log.error(u"Error while validating workshop attendance")
log.error(e)
else:
for datas in appstruct['attendances']:
account_id = datas['account_id']
timeslot_id = datas['timeslot_id']
obj = Attendance.get((account_id, timeslot_id))
obj.status = datas['status']
request.dbsession.merge(obj)
request.session.flash(u"L'émargement a bien été enregistré")
url = request.route_path(
'workshop',
id=context.id,
_query=dict(action="edit"),
)
return HTTPFound(url)
def record_attendance(self, appstruct):
"""
Record the attendances status in both cancelled and closed activity
"""
for datas in appstruct.pop('attendances', []):
account_id = datas['account_id']
event_id = datas['event_id']
obj = Attendance.get((account_id, event_id))
if obj is not None:
obj.status = datas['status']
self.dbsession.merge(obj)
def record_attendance(self, appstruct):
"""
Record the attendances status in both cancelled and closed activity
"""
for datas in appstruct.pop('attendances', []):
account_id = datas['account_id']
event_id = datas['event_id']
obj = Attendance.get((account_id, event_id))
if obj is not None:
obj.status = datas['status']
self.dbsession.merge(obj)
def upgrade():
from autonomie.models.activity import Attendance, Activity
from autonomie.models import DBSESSION
from alembic.context import get_bind
session = DBSESSION()
# Migrating attendance relationship
query = "select event.id, event.status, rel.account_id, rel.activity_id from activity_participant rel inner join activity on rel.activity_id=activity.id LEFT JOIN event on event.id=activity.id"
conn = get_bind()
result = conn.execute(query)
handled = []
for event_id, status, user_id, activity_id in result:
if status == 'planned':
user_status = 'registered'
elif status == 'excused':
user_status = 'excused'
status = 'cancelled'
elif status == 'closed':
user_status = 'attended'
elif status == 'absent':
user_status = 'absent'
status = 'cancelled'
# create attendance for each participant
if (user_id, activity_id) not in handled:
a = Attendance()
a.status = user_status
a.account_id = user_id
a.event_id = activity_id
session.add(a)
session.flush()
# Update the event's status regarding the new norm
query = "update event set status='{0}' where id='{1}';".format(
status, event_id,)
op.execute(query)
handled.append((user_id, activity_id,))
# Migrating activity to add duration and use datetimes
op.add_column('activity', sa.Column('duration', sa.Integer, default=0))
op.alter_column(
'event',
'date',
new_column_name='datetime',
type_=sa.DateTime()
)
query = "select id, conseiller_id from activity;"
result = conn.execute(query)
values = []
for activity_id, conseiller_id in result:
values.append("(%s, %s)" % (activity_id, conseiller_id))
if values != []:
query = "insert into activity_conseiller (`activity_id`, `account_id`) \
VALUES {0}".format(','.join(values))
op.execute(query)
op.execute("alter table activity drop foreign key `activity_ibfk_2`;")
op.drop_column('activity', 'conseiller_id')
op.drop_table('activity_participant')
def upgrade():
from autonomie.models.activity import Attendance, Activity
from autonomie.models import DBSESSION
from alembic.context import get_bind
session = DBSESSION()
# Migrating attendance relationship
query = "select event.id, event.status, rel.account_id, rel.activity_id from activity_participant rel inner join activity on rel.activity_id=activity.id LEFT JOIN event on event.id=activity.id"
conn = get_bind()
result = conn.execute(query)
handled = []
for event_id, status, user_id, activity_id in result:
if status == 'planned':
user_status = 'registered'
elif status == 'excused':
user_status = 'excused'
status = 'cancelled'
elif status == 'closed':
user_status = 'attended'
elif status == 'absent':
user_status = 'absent'
status = 'cancelled'
# create attendance for each participant
if (user_id, activity_id) not in handled:
a = Attendance()
a.status = user_status
a.account_id = user_id
a.event_id = activity_id
session.add(a)
session.flush()
# Update the event's status regarding the new norm
query = "update event set status='{0}' where id='{1}';".format(
status,
event_id,
)
op.execute(query)
handled.append((
user_id,
activity_id,
))
# Migrating activity to add duration and use datetimes
op.add_column('activity', sa.Column('duration', sa.Integer, default=0))
op.alter_column('event',
'date',
new_column_name='datetime',
type_=sa.DateTime())
query = "select id, conseiller_id from activity;"
result = conn.execute(query)
values = []
for activity_id, conseiller_id in result:
values.append("(%s, %s)" % (activity_id, conseiller_id))
if values != []:
query = "insert into activity_conseiller (`activity_id`, `account_id`) \
VALUES {0}".format(','.join(values))
op.execute(query)
op.execute("alter table activity drop foreign key `activity_ibfk_2`;")
op.drop_column('activity', 'conseiller_id')
op.drop_table('activity_participant')
