def fetch(token, task_id=None):
session = Session()
try:
obj = Fetch(token)
print(obj.result)
t = session.query(Project).filter_by(token=token).first()
print(t)
datas = obj.result
if not t:
logging.info("Create new project")
tpl = session.query(Template).filter_by(codemodule=datas["module_code"], slug=datas["slug"]).first()
if not tpl:
logging.info("Create new Template")
tpl = Template(codemodule=datas["module_code"], slug=datas["slug"])
# repository_name, call*, school, ...
session.add(tpl)
t = Project(template=tpl)
session.add(t)
t.token = datas["token"]
t.scolaryear = datas["scolaryear"]
t.module_title = datas["module_title"]
t.module_code = datas["module_code"]
t.instance_code = datas["instance_code"]
t.location = datas["location"]
t.title = datas["title"]
t.deadline = datetime.strptime(datas["deadline"], "%Y-%m-%d %H:%M:%S")
t.promo = datas["promo"]
t.groups = json.dumps(datas["groups"])
t.last_update = datetime.now()
resp = []
for user in datas["resp"]:
u = session.query(User).filter_by(login=user["login"]).first()
if not u:
u = User(firstname=user["firstname"], lastname=user["lastname"],
login=user["login"], old_login=user["old_login"])
session.add(u)
resp.append(u)
t.resp = resp
template_resp = []
for user in datas["template_resp"]:
u = session.query(User).filter_by(login=user["login"]).first()
if not u:
u = User(firstname=user["firstname"], lastname=user["lastname"],
login=user["login"], old_login=user["old_login"])
session.add(u)
template_resp.append(u)
t.template_resp = template_resp
assistants = []
for user in datas["assistants"]:
u = session.query(User).filter_by(login=user["login"]).first()
if not u:
u = User(firstname=user["firstname"], lastname=user["lastname"],
login=user["login"], old_login=user["old_login"])
session.add(u)
assistants.append(u)
t.assistants = assistants
t.students = []
for user in datas["students"]:
u = session.query(User).filter_by(login=user["login"]).first()
if not u:
u = User(firstname=user["firstname"], lastname=user["lastname"],
login=user["login"], old_login=user["old_login"])
session.add(u)
t.students.append(Project_Student(user=u, project=t))
session.add(t)
need_new = True
for task in t.tasks:
if task.type == "auto":
need_new = False
if task.type == "auto" and task.status != "ongoing" and task.id != task_id and task_id != 0:
task.launch_date = t.deadline
task.status = "todo"
session.add(task)
if need_new:
session.add(Task(type="auto", launch_date=t.deadline, project=t))
session.commit()
return t.serialize
except IntegrityError as e:
session.rollback()
except Exception as e:
session.rollback()
logging.error(str(e))
finally:
session.close()
return False
