Support import from MySQL #4

New issue

Closed

opened 2020-01-04 17:02:30 +01:00 by hansegucker · 35 comments

hansegucker commented 2020-01-04 17:02:30 +01:00 (Migrated from edugit.org)

Copy link

Import to Chronos data model via MySQL and add new database fields to Chronos models.

• Teachers
• Classes
• Subjects
• Rooms
• Absence reasons
• Supervision areas
• Supervisions
• Lessons
• Substitutions
• Substitutions without lesson
• Absences
• Events
• Holidays
• Exams / Calendar [optional, include later]
• Atomic transactions
• Status bar
• Celery task

This is the only goal of the SchoolApps merge in this app, so after it is closed, the merge must be finished and the project clean.

Import to Chronos data model via MySQL and add new database fields to Chronos models. * [x] Teachers * [x] Classes * [x] Subjects * [x] Rooms * [x] Absence reasons * [x] Supervision areas * [x] Supervisions * [x] Lessons * [x] Substitutions * [x] Substitutions without lesson * [x] Absences * [x] Events * [x] Holidays * [x] Exams / Calendar [optional, include later] * [x] Atomic transactions * [x] Status bar * [x] Celery task This is the only goal of the SchoolApps merge in this app, so after it is closed, the merge must be finished and the project clean.

nik commented 2020-01-16 15:48:54 +01:00 (Migrated from edugit.org)

Copy link

changed title from {-Merge-Todos-} to {+Support import from MySQL+}

changed title from **{-Merge-Todos-}** to **{+Support import from MySQL+}**

nik commented 2020-01-16 15:48:54 +01:00 (Migrated from edugit.org)

Copy link

changed the description

changed the description

nik commented 2020-01-16 15:49:02 +01:00 (Migrated from edugit.org)

Copy link

assigned to @nik and unassigned @hansegucker

assigned to @nik and unassigned @hansegucker

nik commented 2020-01-16 16:05:54 +01:00 (Migrated from edugit.org)

Copy link

mentioned in issue AlekSIS-App-Chronos#58

mentioned in issue AlekSIS-App-Chronos#58

nik commented 2020-01-16 22:31:05 +01:00 (Migrated from edugit.org)

Copy link

changed milestone to %"2.0a1"

changed milestone to %"2.0a1"

debdolph commented 2020-01-19 22:02:48 +01:00 (Migrated from edugit.org)

Copy link

mentioned in merge request !90

mentioned in merge request !90

nik commented 2020-01-25 11:39:22 +01:00 (Migrated from edugit.org)

Copy link

changed milestone to %"2.0a2"

changed milestone to %"2.0a2"

nik commented 2020-02-06 15:25:07 +01:00 (Migrated from edugit.org)

Copy link

unassigned @nik

unassigned @nik

debdolph commented 2020-03-29 18:59:43 +02:00 (Migrated from edugit.org)

Copy link

assigned to @hansegucker

assigned to @hansegucker

hansegucker commented 2020-04-10 14:52:29 +02:00 (Migrated from edugit.org)

Copy link

changed the description

changed the description

hansegucker commented 2020-04-10 14:52:31 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Teachers as completed

marked the checklist item **Teachers** as completed

hansegucker commented 2020-04-10 14:52:32 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Classes as completed

marked the checklist item **Classes** as completed

hansegucker commented 2020-04-10 14:52:33 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Rooms as completed

marked the checklist item **Rooms** as completed

hansegucker commented 2020-04-10 14:52:34 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Subjects as completed

marked the checklist item **Subjects** as completed

hansegucker commented 2020-04-10 14:52:36 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Supervision areas as completed

marked the checklist item **Supervision areas** as completed

hansegucker commented 2020-04-10 14:52:36 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Supervisions as completed

marked the checklist item **Supervisions** as completed

hansegucker commented 2020-04-10 14:52:38 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Lessons as completed

marked the checklist item **Lessons** as completed

hansegucker commented 2020-04-10 14:52:39 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Substitutions as completed

marked the checklist item **Substitutions** as completed

hansegucker commented 2020-04-13 15:54:06 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Absence reasons as completed

marked the checklist item **Absence reasons** as completed

hansegucker commented 2020-04-13 17:59:03 +02:00 (Migrated from edugit.org)

Copy link

changed the description

changed the description

hansegucker commented 2020-04-13 18:05:30 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Absences as completed

marked the checklist item **Absences** as completed

hansegucker commented 2020-04-13 18:05:49 +02:00 (Migrated from edugit.org)

Copy link

changed the description

changed the description

hansegucker commented 2020-04-13 18:06:52 +02:00 (Migrated from edugit.org)

Copy link

changed due date to April 17, 2020

changed due date to April 17, 2020

hansegucker commented 2020-04-15 15:35:39 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Events as completed

marked the checklist item **Events** as completed

hansegucker commented 2020-04-15 15:36:11 +02:00 (Migrated from edugit.org)

Copy link

changed the description

changed the description

hansegucker commented 2020-04-15 15:36:51 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Events as completed

marked the checklist item **Events** as completed

hansegucker commented 2020-04-15 21:07:03 +02:00 (Migrated from edugit.org)

Copy link

mentioned in issue #5

mentioned in issue #5

hansegucker commented 2020-04-15 21:07:11 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Exams / Calendar [optional, include later] as completed

marked the checklist item **Exams / Calendar [optional, include later]** as completed

hansegucker commented 2020-04-15 22:11:40 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Holidays as completed

marked the checklist item **Holidays** as completed

hansegucker commented 2020-04-16 14:58:33 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Status bar as completed

marked the checklist item **Status bar** as completed

hansegucker commented 2020-04-16 16:09:40 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Celery task as completed

marked the checklist item **Celery task** as completed

hansegucker commented 2020-04-18 15:26:41 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Atomic transactions as completed

marked the checklist item **Atomic transactions** as completed

hansegucker commented 2020-04-20 18:24:57 +02:00 (Migrated from edugit.org)

Copy link

marked the checklist item Substitutions without lesson as completed

marked the checklist item **Substitutions without lesson** as completed

nik commented 2020-04-20 21:52:00 +02:00 (Migrated from edugit.org)

Copy link

closed via merge request !90

closed via merge request !90

nik commented 2020-04-20 21:52:00 +02:00 (Migrated from edugit.org)

Copy link

mentioned in commit 2fca14451d

mentioned in commit 2fca14451d5c02493d75baa2307457216204eadd

Sign in to join this conversation.

No Branch/Tag specified

Branches Tags

master

aleksolotl-checks

check/update-pyproject-toml

check/update-merge-request-template

check/update-builddeps-package-json

check/update-eslint-rc-js

check/update-tox-ini

74-update-for-current-changes-in-lesrooster

77-adapt-to-places

70-fix-until-date-of-previous-term-if-importing-new-term

stable-3.0

release-3.0

release-2.3.2

63-class-absences-lessons-with-multiple-classes-are-marked-as-cancelled-even-if-only-one-of-the

weblate

58-support-student-group-field-of-lesson

59-support-overlapping-periods

test-hhg

feature/vuejs

allow-30

54-importing-lessons-fails-due-to-wrong-reg-ex

i10n-ru-ua

49-import-should-respect-school_id

do-release-2.2

41-create-match-failures-as-data-checks

default-current

release-2.1.3

release-2.1.2

release-2.1.1

2.1.1

40-allow-selecting-plan-version-and-default-to-newest-version

fix-intersphinx

docs-refs

add-docs

fix/readme-syntax

35-disambiguate-long-group-names

update/tox-makemessages

release/2.0

25-fields-must-be-unique-per-site

update/changelog-2.0b0

trigger-dist-pipeline

fix-ci-config

19-update-supervisions-on-import

update-lockfile-core

update-tox2

update-tox

9-fix-update_or_create-calls

feature/use-entrypoints

update-lock-file

fix-docker-build

update-poetry-lockfile

core-158-documentation-needed-for-first-release

6-import-school-terms-and-validity-ranges

add-constance-settings-for-untis-db

3.0.1

3.0

3.0b0

2.3.2

2.3.1

2.3

2.2.1.dev0

2.2

2.2a0

2.1.4.dev0

2.1.3

2.1.2

2.1

2.1.dev2

2.1.dev1

2.1.dev0

2.0

2.0rc3

2.0rc2

2.0rc1

2.0b0

2.0a2

1.0a3

1.0a2

1.0a1

1.0a0

Labels

Clear labels   

Security

  

TeX

Needs LaTeX template

  

auto-update

  

board

done

  

board

ready

  

board

todo

  

check

delete-eslint-rc-js

  

check

update-builddeps-package-json

  

check

update-eslint-rc-js

  

check

update-gitignore

  

check

update-merge-request-template

  

check

update-prettier-ignore

  

check

update-pyproject-toml

  

check

update-renovate-json

  

check

update-tox-ini

  

part

backend

Backend (view code, models, logic, etc.)

  

part

ci

  

part

docs

Issue or addition to the documentation

  

part

frontend

Frontend (templates, etc.)

  

part

i18n

Translation or internationalisation issue

  

part

mysql

  

part

non-technical

Non-technical (policy, maintenance, etc.) issue or discussion

  

part

packaging

Issue concerning the packaging of AlekSIS and components

  

part

xml

  

prio

1

Priority High

  

prio

2

Priority Medium

  

prio

3

Priority Low

  

release-mr-5.x

  

size

large

  

size

medium

  

size

small

  

source

customer

Requested by a customer or affiliated user

  

source

customer::fsmw

  

source

customer::fss

  

source

customer::teckids

  

source

downstream

Issue or merge request from other projects using AlekSIS or parts of it

  

type

breaking

  

type

bug

Bug

  

type

feature

New feature

  

type

refactoring

  

workflow

blocked

Issue is blocked by another issue

  

workflow

confirmed

The bug is reproducible and will be fixed

  

workflow

current-todo

  

workflow

discussing

Needs to be discussed before implementation

  

workflow

new-app

Requires new AlekSIS app, which has to be created

  

workflow

wontfix

The bug is not reproducible or the feature was decided against

No labels

Security

TeX

auto-update

board

done

board

ready

board

todo

check

delete-eslint-rc-js

check

update-builddeps-package-json

check

update-eslint-rc-js

check

update-gitignore

check

update-merge-request-template

check

update-prettier-ignore

check

update-pyproject-toml

check

update-renovate-json

check

update-tox-ini

part

backend

part

ci

part

docs

part

frontend

part

i18n

part

mysql

part

non-technical

part

packaging

part

xml

prio

1

prio

2

prio

3

release-mr-5.x

size

large

size

medium

size

small

source

customer

source

customer::fsmw

source

customer::fss

source

customer::teckids

source

downstream

type

breaking

type

bug

type

feature

type

refactoring

workflow

blocked

workflow

confirmed

workflow

current-todo

workflow

discussing

workflow

new-app

workflow

wontfix

Milestone

Clear milestone

No items

No milestone

Projects

Clear projects

No items

No project

Assignees

Clear assignees

No assignees

1 participant

Notifications

Subscribe

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

aleksis/AlekSIS-App-Untis#4

No description provided.