[%userpod%@podv1 ~]$ cd
[%userpod%@podv1 ~]$ source .bashrc
[%userpod%@podv1 ~]$ cd /data/www/%userpod%/django_projects/pod/pod_project/
[%userpod%@podv1 /data/www/%userpod%/django_projects/pod/pod_project]$ workon django_pod
# On lance le shell Python
(django_pod) [%userpod%@podv1 /data/www/%userpod%/django_projects/pod/pod_project]$ python manage.py shell

from pods.models import Channel
from pods.models import Theme
from pods.models import Type
from pods.models import User
from pods.models import Discipline
from pods.models import Pod
from pods.models import json
from core.models import UserProfile
from django.contrib.auth.models import User
from django.contrib.flatpages.models import FlatPage

from pods.models import ChapterPods
from pods.models import ContributorPods

from django.core import serializers
jsonserializer = serializers.get_serializer("json")
json_serializer = jsonserializer()

with open("Channel.json", "w") as out:
    json_serializer.serialize(Channel.objects.all(), indent=2, stream=out)

with open("Theme.json", "w") as out:
    json_serializer.serialize(Theme.objects.all(), indent=2, stream=out)

with open("Type.json", "w") as out:
    json_serializer.serialize(Type.objects.all(), indent=2, stream=out)

owners = set(Channel.objects.all().values_list("owners", flat=True))

users = set(Channel.objects.all().values_list("users", flat=True))

list_user = owners.union(users)

#with open("User.json", "w") as out:
#    json_serializer.serialize(User.objects.filter(id__in=list_user), indent=2,
#        stream=out)

with open("User.json", "w") as out:
    json_serializer.serialize(User.objects.all(), indent=2,
        stream=out)

with open("Discipline.json", "w") as out:
    json_serializer.serialize(Discipline.objects.all(), indent=2,
        stream=out)

with open("FlatPage.json", "w") as out:
    json_serializer.serialize(FlatPage.objects.all(), indent=2,
        stream=out)

with open("UserProfile.json", "w") as out:
    json_serializer.serialize(UserProfile.objects.all(), indent=2,
        stream=out, fields=(
            'user','auth_type', 'affiliation', 'commentaire', 'image'))

podowner = set(Pod.objects.all().values_list("owner", flat=True))

#with open("User.json", "w") as out:
#    json_serializer.serialize(User.objects.filter(id__in=podowner), indent=2, stream=out)

video_fields = ('video', 'allow_downloading', 'is_360', 'title', 'slug',
    'owner', 'date_added', 'date_evt', 'cursus', 'main_lang', 'description',
    'duration', 'type', 'discipline', 'channel', 'theme', 'is_draft',
    'is_restricted', 'password')

with open("Pod.json", "w") as out:
    json_serializer.serialize(
        Pod.objects.all().order_by("id"), stream=out, indent=2,
        fields=video_fields)

import json

list_tag = {}
for p in Pod.objects.all():
    list_tag["%s" %p.id] = []
    for t in p.tags.all():
        list_tag["%s" %p.id].append(t.name)
with open("tags.json", "w") as out:
    out.write(json.dumps(list_tag, indent=2))

with open("Chapter.json", "w") as out:
    json_serializer.serialize(ChapterPods.objects.all().order_by('video'),
        indent=2, stream=out)

with open("Contributor.json", "w") as out:
    json_serializer.serialize(ContributorPods.objects.all().order_by('video'),
        indent=2, stream=out)

list_doc = {}
for p in Pod.objects.all():
    list_doc["%s" %p.id] = []
    for d in p.docpods_set.all():
        list_doc["%s" %p.id].append(d.document.file.name)
with open("docpods.json", "w") as out:
    out.write(json.dumps(list_doc, indent=2))

list_track = {}
for p in Pod.objects.all():
    if p.trackpods_set.all().count()> 0:
        list_track["%s" %p.id] = []
        for d in p.trackpods_set.all():
            if d.src :
                data = {}
                data['kind'] = d.kind
                data['lang'] = d.lang
                data['src'] = d.src.file.name
                list_track["%s" %p.id].append(data)
with open("trackpods.json", "w") as out:
    out.write(json.dumps(list_track, indent=2))
 
list_enrich = {}
for p in Pod.objects.all().order_by('id'):
    if p.enrichpods_set.all().count()> 0:
        list_enrich["%s" %p.id] = []
        for d in p.enrichpods_set.all():
            data = {}
            data['title'] = d.title
            data['stop_video'] = d.stop_video
            data['start'] = d.start
            data['end'] = d.end
            data['type'] = d.type
            data['image'] = d.image.file.name if d.image else ""
            data['richtext'] = d.richtext
            data['weblink'] = d.weblink
            data['document'] = d.document.file.name if d.document else ""
            data['embed'] = d.embed
            list_enrich["%s" %p.id].append(data)

with open("enrichpods.json", "w") as out:
    out.write(json.dumps(list_enrich, indent=2))

[%userpod%@podv2 ~]$ pip3 install requests
[%userpod%@podv2 ~]$ pip3 install wget

[%userpod%@podv2 ~]$ cd
[%userpod%@podv2 ~]$ source .bashrc
[%userpod%@podv2 ~]$ cd /data/www/%userpod%/django_projects/podv2
[%userpod%@podv2 /data/www/%userpod%/django_projects/podv2]$ workon django_pod
# On créé les tables et données nécessaires
(django_pod) [%userpod%@podv2 /data/www/%userpod%/django_projects/podv2]$ sh create_data_base.sh

-- Mise à jour du site et création des 2 groupes (si besoin est) qui existaient déjà en v1 (positionner la bonne valeur selon l'environnement)
UPDATE `django_site` SET `domain` = 'pod.univ.fr', `name` = 'pod.univ.fr' WHERE `django_site`.`id` = 1;
INSERT INTO `auth_group` (`id`, `name`) VALUES ('1', 'Manager'), ('2', 'Can delete file');

for dossier in $(ls -d videos/*)
do
    for fichier in $(ls -F $dossier| grep -v '/$')
    do
        if test -f $dossier/$fichier; then
            chmod a+r $dossier/$fichier
        fi
    done
done

[%userpod%@podv2 ~]$ cd
[%userpod%@podv2 ~]$ source .bashrc
[%userpod%@podv2 ~]$ cd /data/www/%userpod%/django_projects/podv2/
[%userpod%@podv2 /data/www/%userpod%/django_projects/podv2]$ workon django_pod
# Shell Python
(django_pod) [%userpod%@podv2 /data/www/%userpod%/django_projects/podv2]$ python manage.py shell

from django.core.management import call_command
from pod.video.models import Video
Video.objects.all().count()
list_videos = Video.objects.all().order_by('id')
for vid in list_videos[1:3000]:
    call_command('download_video_source_file',vid.id)

from django.core.management import call_command
from pod.video.models import Video
call_command('download_video_source_file', 2184)

from django.core.management import call_command
from pod.video.models import Video
Video.objects.all().count()
list_videos = Video.objects.filter(id=2189).order_by('id')
for vid in list_videos[1:10]:
    call_command('download_video_source_file',vid.id)