models.py 47.8 KB
Newer Older
1
import json
2
import logging
Guilhem Saurel's avatar
Guilhem Saurel committed
3
import re
4
import time
Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
5
from subprocess import check_output
6

Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
7
8
import git
import requests
Guilhem Saurel's avatar
Guilhem Saurel committed
9
from django.conf import settings
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
10
from django.core.mail import mail_admins
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
11
from django.db import models
Guilhem Saurel's avatar
Guilhem Saurel committed
12
from django.db.models import Q
Guilhem Saurel's avatar
Guilhem Saurel committed
13
from django.db.models.functions import Length
14
from django.db.utils import DataError
15
from django.template.loader import get_template
16
from django.utils import timezone
Guilhem Saurel's avatar
Guilhem Saurel committed
17
18
from django.utils.dateparse import parse_datetime
from django.utils.safestring import mark_safe
Guilhem Saurel's avatar
Guilhem Saurel committed
19
20

from autoslug import AutoSlugField
Guilhem Saurel's avatar
Guilhem Saurel committed
21
from ndh.models import Links, NamedModel, TimeStampedModel
Guilhem Saurel's avatar
Guilhem Saurel committed
22
from ndh.utils import enum_to_choices, query_sum
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
23

Guilhem Saurel's avatar
Guilhem Saurel committed
24
from .utils import SOURCES, api_next, invalid_mail, slugify_with_dots, valid_name
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
25

26
27
logger = logging.getLogger('rainboard.models')

Guilhem Saurel's avatar
Guilhem Saurel committed
28
MAIN_BRANCHES = ['master', 'devel']
Guilhem Saurel's avatar
Guilhem Saurel committed
29
RPKG_URL = 'http://robotpkg.openrobots.org'
Guilhem Saurel's avatar
Guilhem Saurel committed
30
DOC_URL = 'http://projects.laas.fr/gepetto/doc'
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
31
32
33
34
35
36
37
38
39
RPKG_LICENSES = {
    'gnu-lgpl-v3': 'LGPL-3.0',
    'gnu-lgpl-v2': 'LGPL-2.0',
    'mit': 'MIT',
    'gnu-gpl-v3': 'GPL-3.0',
    '2-clause-bsd': 'BSD-2-Clause',
    'eclipse': 'EPL-1.0',
    'modified-bsd': 'BSD-3-Clause'
}
Guilhem Saurel's avatar
Guilhem Saurel committed
40
RPKG_FIELDS = ['PKGBASE', 'PKGVERSION', 'MASTER_SITES', 'MASTER_REPOSITORY', 'MAINTAINER', 'COMMENT', 'HOMEPAGE']
Guilhem Saurel's avatar
Guilhem Saurel committed
41
42
43
44
45
46
47
CMAKE_FIELDS = {
    'NAME': 'cmake_name',
    'DESCRIPTION': 'description',
    'URL': 'homepage',
    'VERSION': 'version',
    'SUFFIX': 'suffix'
}
Guilhem Saurel's avatar
Guilhem Saurel committed
48
TRAVIS_STATE = {'created': None, 'passed': True, 'started': None, 'failed': False, 'errored': False, 'canceled': False}
Guilhem Saurel's avatar
Guilhem Saurel committed
49
GITLAB_STATUS = {'failed': False, 'success': True, 'pending': None, 'skipped': None, 'canceled': None, 'running': None}
Guilhem Saurel's avatar
Guilhem Saurel committed
50

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
51
52

class Namespace(NamedModel):
53
    group = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
54
55


Guilhem Saurel's avatar
Guilhem Saurel committed
56
57
58
class License(models.Model):
    name = models.CharField(max_length=200)
    spdx_id = models.CharField(max_length=50, unique=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
59
60
61
62
63
64
    url = models.URLField(max_length=200)

    def __str__(self):
        return self.spdx_id or self.name


Guilhem Saurel's avatar
Guilhem Saurel committed
65
class Forge(Links, NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
66
67
68
69
70
    source = models.PositiveSmallIntegerField(choices=enum_to_choices(SOURCES))
    url = models.URLField(max_length=200)
    token = models.CharField(max_length=50, blank=True, null=True)
    verify = models.BooleanField(default=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
71
72
73
    def get_absolute_url(self):
        return self.url

Guilhem Saurel's avatar
Guilhem Saurel committed
74
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
75
        logger.debug(f'requesting api {self} {url}, page {page}')
76
77
78
79
80
        try:
            return requests.get(self.api_url() + url, {'page': page}, verify=self.verify, headers=self.headers())
        except requests.exceptions.ConnectionError:
            logger.error(f'requesting api {self} {url}, page {page} - SECOND TRY')
            return requests.get(self.api_url() + url, {'page': page}, verify=self.verify, headers=self.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
81
82
83
84
85
86

    def api_data(self, url=''):
        req = self.api_req(url)
        return req.json() if req.status_code == 200 else []  # TODO

    def api_list(self, url='', name=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
87
88
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
89
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
90
91
92
93
94
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
                data = data[name]
Guilhem Saurel's avatar
Guilhem Saurel committed
95
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
96
            page = api_next(self.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
97
98

    def headers(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
99
        return {
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
100
101
102
103
104
105
106
107
108
109
110
111
112
113
            SOURCES.github: {
                'Authorization': f'token {self.token}',
                'Accept': 'application/vnd.github.drax-preview+json'
            },
            SOURCES.gitlab: {
                'Private-Token': self.token
            },
            SOURCES.redmine: {
                'X-Redmine-API-Key': self.token
            },
            SOURCES.travis: {
                'Authorization': f'token {self.token}',
                'TRAVIS-API-Version': '3'
            },
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
114
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
115
116

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
117
118
119
120
        return {
            SOURCES.github: 'https://api.github.com',
            SOURCES.gitlab: f'{self.url}/api/v4',
            SOURCES.redmine: self.url,
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
121
            SOURCES.travis: 'https://api.travis-ci.org',
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
122
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
123

124
125
    def get_namespaces_github(self):
        for namespace in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
126
            for data in self.api_list(f'/orgs/{namespace.slug}/members'):
Guilhem Saurel's avatar
Guilhem Saurel committed
127
128
129
130
131
                Namespace.objects.get_or_create(slug=data['login'].lower(),
                                                defaults={
                                                    'name': data['login'],
                                                    'group': False
                                                })
132

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
133
134
    def get_namespaces_gitlab(self):
        for data in self.api_list('/namespaces'):
Guilhem Saurel's avatar
Guilhem Saurel committed
135
136
137
138
139
            Namespace.objects.get_or_create(slug=data['path'],
                                            defaults={
                                                'name': data['name'],
                                                'group': data['kind'] == 'group'
                                            })
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
140
141
142
        for data in self.api_list('/users'):
            Namespace.objects.get_or_create(slug=data['username'], defaults={'name': data['name']})

Guilhem Saurel's avatar
Guilhem Saurel committed
143
144
145
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
146
147
148
    def get_namespaces_travis(self):
        pass

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
149
150
151
    def get_projects(self):
        getattr(self, f'get_namespaces_{self.get_source_display()}')()
        return getattr(self, f'get_projects_{self.get_source_display()}')()
152

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
153
    def get_projects_github(self):
154
        for org in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
155
            for data in self.api_list(f'/orgs/{org.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
156
                update_github(self, org, data)
157
        for user in Namespace.objects.filter(group=False):
Guilhem Saurel's avatar
Guilhem Saurel committed
158
            for data in self.api_list(f'/users/{user.slug}/repos'):
Guilhem Saurel's avatar
Guilhem Saurel committed
159
                if Project.objects.filter(name=valid_name(data['name'])).exists():
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
160
                    update_github(self, user, data)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
161
162

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
163
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
164
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
165
166

        for orphan in Project.objects.filter(main_namespace=None):
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
167
            repo = orphan.repo_set.filter(forge__source=SOURCES.gitlab).first()
Guilhem Saurel's avatar
Guilhem Saurel committed
168
169
            if repo:
                update_gitlab(self, self.api_data(f'/projects/{repo.forked_from}'))
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
170
171
172
173

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
174
175
176
177
178
179
    def get_projects_travis(self):
        for namespace in Namespace.objects.all():
            for repository in self.api_list(f'/owner/{namespace.slug}/repos', 'repositories'):
                if repository['active']:
                    update_travis(namespace, repository)

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
180

Guilhem Saurel's avatar
Guilhem Saurel committed
181
class Project(Links, NamedModel, TimeStampedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
182
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
183
184
185
186
    main_namespace = models.ForeignKey(Namespace, on_delete=models.SET_NULL, null=True, blank=True)
    main_forge = models.ForeignKey(Forge, on_delete=models.SET_NULL, null=True, blank=True)
    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
187
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
188
    version = models.CharField(max_length=20, blank=True, null=True)
189
    updated = models.DateTimeField(blank=True, null=True)
190
191
    tests = models.BooleanField(default=True)
    docs = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
192
    from_gepetto = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
193
    cmake_name = models.CharField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
194
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
195
    suffix = models.CharField(max_length=50, default='', blank=True)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
196
    allow_format_failure = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
197

198
199
200
201
    def save(self, *args, **kwargs):
        self.name = valid_name(self.name)
        super().save(*args, **kwargs)

Guilhem Saurel's avatar
Guilhem Saurel committed
202
    def git_path(self):
203
        return settings.RAINBOARD_GITS / self.main_namespace.slug / self.slug.strip()  # workaround SafeText TypeError
Guilhem Saurel's avatar
Guilhem Saurel committed
204

Guilhem Saurel's avatar
Guilhem Saurel committed
205
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
206
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
207
208
209
210
211
        if not path.exists():
            logger.info(f'Creating repo for {self.main_namespace.slug}/{self.slug}')
            return git.Repo.init(path)
        return git.Repo(str(path / '.git'))

212
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
213
        forge = self.main_forge if self.main_forge else get_default_forge(self)
Guilhem Saurel's avatar
Guilhem Saurel committed
214
215
216
217
218
219
220
221
        repo, created = Repo.objects.get_or_create(forge=forge,
                                                   namespace=self.main_namespace,
                                                   project=self,
                                                   defaults={
                                                       'name': self.name,
                                                       'default_branch': 'master',
                                                       'repo_id': 0
                                                   })
Guilhem Saurel's avatar
Guilhem Saurel committed
222
        if created:
223
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
224
225
        return repo

Guilhem Saurel's avatar
Guilhem Saurel committed
226
    def update_branches(self, main=True, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
227
228
229
        branches = [b[2:] for b in self.git().git.branch('-a', '--no-color').split('\n')]
        if main:
            branches = [b for b in branches if b.endswith('master') or b.endswith('devel')]
Guilhem Saurel's avatar
Guilhem Saurel committed
230
        for branch in branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
231
            logger.info(f'update branch {branch}')
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
232
233
            if branch.startswith('remotes/'):
                branch = branch[8:]
234
235
236
            if branch.count('/') < 2:
                logger.error(f'wrong branch "{branch}" in {self.git_path()}')
                continue
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
237
238
239
            forge, namespace, name = branch.split('/', maxsplit=2)
            namespace, _ = Namespace.objects.get_or_create(slug=namespace)
            forge = Forge.objects.get(slug=forge)
Guilhem Saurel's avatar
Guilhem Saurel committed
240
241
242
243
244
245
246
247
            repo, created = Repo.objects.get_or_create(forge=forge,
                                                       namespace=namespace,
                                                       project=self,
                                                       defaults={
                                                           'name': self.name,
                                                           'default_branch': 'master',
                                                           'repo_id': 0
                                                       })
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
248
249
            if created:
                repo.api_update()
250
251
252
            instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=repo)
            if bcreated:
                instance.update(pull=pull)
253

Guilhem Saurel's avatar
update    
Guilhem Saurel committed
254
255
256
    def checkout(self):
        self.main_branch().git().checkout()

Guilhem Saurel's avatar
Guilhem Saurel committed
257
    def main_branch(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
258
        return self.main_repo().main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
259

Guilhem Saurel's avatar
Guilhem Saurel committed
260
261
262
263
264
265
266
    def cmake(self):
        filename = self.git_path() / 'CMakeLists.txt'
        if not filename.exists():
            return
        with filename.open() as f:
            content = f.read()
        for key, value in CMAKE_FIELDS.items():
Guilhem Saurel's avatar
Guilhem Saurel committed
267
            search = re.search(r'set\s*\(\s*project_%s\s+([^)]+)*\)' % key, content, re.I)
Guilhem Saurel's avatar
Guilhem Saurel committed
268
            if search:
269
                try:
270
                    old = getattr(self, value)
271
                    new = search.groups()[0].strip(''' \r\n\t'"''').replace('_', '-')
272
273
274
                    if old != new:
                        setattr(self, value, new)
                        self.save()
275
                except DataError:
276
                    setattr(self, value, old)
277
        for dependency in re.findall(r'ADD_[A-Z]+_DEPENDENCY\s*\(["\']?([^ "\')]+).*["\']?\)', content, re.I):
Guilhem Saurel's avatar
Guilhem Saurel committed
278
            project = Project.objects.filter(name=valid_name(dependency))
279
            if project.exists():
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
280
281
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.cmake:
282
283
                    dependency.cmake = True
                    dependency.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
284

285
    def ros(self):
286
287
        try:
            filename = self.git_path() / 'package.xml'
288
        except TypeError:
289
            return
290
291
292
293
294
        if not filename.exists():
            return
        with filename.open() as f:
            content = f.read()
        for dependency in re.findall(r'<run_depend>(\w+).*</run_depend>', content, re.I):
Guilhem Saurel's avatar
Guilhem Saurel committed
295
            project = Project.objects.filter(name=valid_name(dependency))
296
297
298
299
300
301
            if project.exists():
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.ros:
                    dependency.ros = True
                    dependency.save()

302
303
304
305
306
307
    def repos(self):
        return self.repo_set.count()

    def rpkgs(self):
        return self.robotpkg_set.count()

Guilhem Saurel's avatar
Guilhem Saurel committed
308
309
310
311
    def update_tags(self):
        for tag in self.git().tags:
            Tag.objects.get_or_create(name=str(tag), project=self)

Guilhem Saurel's avatar
Guilhem Saurel committed
312
    def update_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
313
314
        branch = str(self.main_branch()).split('/', maxsplit=2)[2]
        self.git().head.commit = self.git().remotes[self.main_repo().git_remote()].refs[branch].commit
Guilhem Saurel's avatar
Guilhem Saurel committed
315

Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
316
317
318
319
    def ci_jobs(self):
        if self.main_forge.source == SOURCES.gitlab:
            self.main_repo().get_jobs_gitlab()

320
    def update(self, only_main_branches=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
321
322
        if self.main_namespace is None:
            return
323
        self.update_branches(main=only_main_branches)
Guilhem Saurel's avatar
Guilhem Saurel committed
324
        self.update_tags()
Guilhem Saurel's avatar
Guilhem Saurel committed
325
        self.update_repo()
326
        tag = self.tag_set.filter(name__startswith='v').last()  # TODO: implement SQL ordering for semver
Guilhem Saurel's avatar
Guilhem Saurel committed
327
328
        if tag is not None:
            self.version = tag.name[1:]
329
        robotpkg = self.robotpkg_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
330
        branch = self.branch_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
331
332
333
        branch_updated = branch is not None and branch.updated is not None
        robotpkg_updated = robotpkg is not None and robotpkg.updated is not None
        if branch_updated or robotpkg_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
334
            if not robotpkg_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
335
                self.updated = branch.updated
Guilhem Saurel's avatar
Guilhem Saurel committed
336
            elif not branch_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
337
338
339
                self.updated = robotpkg.updated
            else:
                self.updated = max(branch.updated, robotpkg.updated)
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
340
        self.ci_jobs()
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
341
        self.checkout()
342
        self.cmake()
Guilhem Saurel's avatar
Guilhem Saurel committed
343
        self.ros()
344
345
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
346
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
347
348
349
350
351
        try:
            commits = self.git().git.rev_list(f'v{self.version}..{self.main_branch()}')
            return len(commits.split('\n')) if commits else 0
        except git.exc.GitCommandError:
            pass
Guilhem Saurel's avatar
Guilhem Saurel committed
352

353
354
355
356
357
358
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

    def open_pr(self):
        return query_sum(self.repo_set, 'open_pr')

359
360
361
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
362
363
364
365
366
367
368
369
370
    def contributors(self, update=False):
        if update:
            for guy in self.git().git.shortlog('-nse').split('\n'):
                name, mail = guy[7:-1].split(' <')
                contributor = get_contributor(name, mail)
                contributor.projects.add(self)
                contributor.save()
        return self.contributor_set.all()

371
372
373
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
374
375
376
377
    def doc_coverage_image(self):
        images = Image.objects.filter(robotpkg__project=self, py3=False, target__name='16.04')
        return images.order_by(Length('robotpkg__name').desc()).first()

378
    def print_deps(self):
379
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
380
381

    def print_rdeps(self):
382
        return mark_safe(', '.join(d.project.get_link() for d in self.rdeps.all()))
383

Guilhem Saurel's avatar
Guilhem Saurel committed
384
385
386
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
    def url_travis(self):
        return f'https://travis-ci.org/{self.main_namespace.slug}/{self.slug}'

    def url_gitlab(self):
        return f'https://gepgitlab.laas.fr/{self.main_namespace.slug}/{self.slug}'

    def badge(self, link, img, alt):
        return mark_safe(f'<a href="{link}"><img src="{img}" alt="{alt}" /></a> ')

    def badge_travis(self):
        return self.badge(self.url_travis(), f'{self.url_travis()}.svg?branch=master', 'Building Status')

    def badge_gitlab(self):
        return self.badge(self.url_gitlab(), f'{self.url_gitlab()}/badges/master/pipeline.svg', 'Pipeline Status')

    def badge_coverage(self):
        return self.badge(f'{DOC_URL}/{self.main_namespace.slug}/{self.slug}/master/coverage',
Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
404
                          f'{self.url_gitlab()}/badges/master/coverage.svg?job=doc-coverage"', 'Coverage Report')
Guilhem Saurel's avatar
Guilhem Saurel committed
405
406

    def badges(self):
Guilhem Saurel's avatar
safe ""    
Guilhem Saurel committed
407
        travis = self.badge_travis() if self.public else mark_safe('')
408
        return travis + self.badge_gitlab() + self.badge_coverage()
Guilhem Saurel's avatar
Guilhem Saurel committed
409

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
410

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
411
412
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
413
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
414
415
416
417
418
419
420
421
422
423
    forge = models.ForeignKey(Forge, on_delete=models.CASCADE)
    namespace = models.ForeignKey(Namespace, on_delete=models.CASCADE)
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
    homepage = models.URLField(max_length=200, blank=True, null=True)
    url = models.URLField(max_length=200, blank=True, null=True)
    default_branch = models.CharField(max_length=50)
    open_issues = models.PositiveSmallIntegerField(blank=True, null=True)
    open_pr = models.PositiveSmallIntegerField(blank=True, null=True)
    repo_id = models.PositiveIntegerField()
Guilhem Saurel's avatar
Guilhem Saurel committed
424
    forked_from = models.PositiveIntegerField(blank=True, null=True)
425
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
426
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
427
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
428
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
429
430
431

    def __str__(self):
        return self.name
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
432
433

    def api_url(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
434
        api_url = self.forge.api_url()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
435
        return {
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
436
437
438
            SOURCES.github: f'{api_url}/repos/{self.namespace.slug}/{self.slug}',
            SOURCES.redmine: f'{api_url}/projects/{self.repo_id}.json',
            SOURCES.gitlab: f'{api_url}/projects/{self.repo_id}',
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
439
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
440

Guilhem Saurel's avatar
Guilhem Saurel committed
441
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
442
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
443
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
444
445
446
            return requests.get(self.api_url() + url, {'page': page},
                                verify=self.forge.verify,
                                headers=self.forge.headers())
447
448
        except requests.exceptions.ConnectionError:
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
Guilhem Saurel committed
449
450
451
            return requests.get(self.api_url() + url, {'page': page},
                                verify=self.forge.verify,
                                headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
452
453
454
455
456
457

    def api_data(self, url=''):
        req = self.api_req(url)
        return req.json() if req.status_code == 200 else []  # TODO

    def api_list(self, url='', name=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
458
459
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
460
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
461
462
463
464
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
465
466
467
468
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
469
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
470
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
471

Guilhem Saurel's avatar
Guilhem Saurel committed
472
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
473
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
474
        if data:
Guilhem Saurel's avatar
Guilhem Saurel committed
475
476
477
478
479
480
481
482
            if data['archived']:
                if self.project.main_repo() == self:
                    self.project.archived = True
                    self.project.save()
                self.archived = True
                self.save()
            else:
                return getattr(self, f'api_update_{self.forge.get_source_display()}')(data)
Guilhem Saurel's avatar
Guilhem Saurel committed
483
484

    def api_update_gitlab(self, data):
485
        update_gitlab(self.forge, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
486

Guilhem Saurel's avatar
Guilhem Saurel committed
487
    def api_update_github(self, data):
488
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
489

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
490
491
492
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
493
494
        if self.forge.source == SOURCES.github:
            return self.clone_url.replace('://', f'://{settings.GITHUB_USER}:{self.forge.token}@')
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
495
496
        return self.clone_url

497
498
499
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
500
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
501
        git_repo = self.project.git()
502
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
503
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
504
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
505
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
506
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
507
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
508

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
509
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
510
511
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
512
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
513
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
514
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
515
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
516
517
518
519
520
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
521

Guilhem Saurel's avatar
Guilhem Saurel committed
522
523
524
    def main_branch(self):
        return self.project.branch_set.get(name=f'{self.git_remote()}/{self.default_branch}')

Guilhem Saurel's avatar
Guilhem Saurel committed
525
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
526
527
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
528
529

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
530
531
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
532

Guilhem Saurel's avatar
Guilhem Saurel committed
533
534
535
536
    def get_builds(self):
        return getattr(self, f'get_builds_{self.forge.get_source_display()}')()

    def get_builds_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
537
        for pipeline in self.api_list('/pipelines'):
Guilhem Saurel's avatar
Guilhem Saurel committed
538
539
540
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
541
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
542
543
544
545
            branch_name = f'{self.forge.slug}/{self.namespace.slug}/{ref}'
            branch, created = Branch.objects.get_or_create(name=branch_name, project=self.project, repo=self)
            if created:
                branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
546
547
548
549
550
551
552
            ci_build, created = CIBuild.objects.get_or_create(repo=self,
                                                              build_id=pid,
                                                              defaults={
                                                                  'passed': GITLAB_STATUS[pipeline['status']],
                                                                  'started': parse_datetime(data['created_at']),
                                                                  'branch': branch,
                                                              })
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
553
554
555
556
557
558
            if not created and ci_build.passed != GITLAB_STATUS[pipeline['status']]:
                ci_build.passed = GITLAB_STATUS[pipeline['status']]
                ci_build.save()

    def get_jobs_gitlab(self):
        for data in self.api_list('/jobs'):
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
559
            branch_name = f'{self.forge.slug}/{self.namespace.slug}/{data["ref"]}'
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
560
561
562
            branch, created = Branch.objects.get_or_create(name=branch_name, project=self.project, repo=self)
            if created:
                branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
563
564
565
566
567
568
569
            ci_job, created = CIJob.objects.get_or_create(repo=self,
                                                          job_id=data['id'],
                                                          defaults={
                                                              'passed': GITLAB_STATUS[data['status']],
                                                              'started': parse_datetime(data['created_at']),
                                                              'branch': branch,
                                                          })
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
570
571
572
573
574
575
576
577
            if not created and ci_job.passed != GITLAB_STATUS[data['status']]:
                ci_job.passed = GITLAB_STATUS[data['status']]
                ci_job.save()
            if self == self.project.main_repo() and data['name'].startswith('robotpkg-'):
                py3 = '-py3' in data['name']
                debug = '-debug' in data['name']
                target = next(target for target in Target.objects.all() if target.name in data['name']).name
                robotpkg = data['name'][9:-(2 + len(target) + (5 if debug else 7) + (3 if py3 else 0))]  # shame.
Guilhem Saurel's avatar
Guilhem Saurel committed
578
579
580
581
                images = Image.objects.filter(robotpkg__name=robotpkg, target__name=target, debug=debug, py3=py3)
                if not images.exists():
                    continue
                image = images.first()
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
582
583
                if image.allow_failure and GITLAB_STATUS[data['status']]:
                    mail_admins('Success !', 'allow_failure est devenu inutile sur ' + data['web_url'])
584
                    time.sleep(1)
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
585
586
                    image.allow_failure = False
                    image.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
587
588
589
590

    def get_builds_github(self):
        if self.travis_id is not None:
            travis = Forge.objects.get(source=SOURCES.travis)
Guilhem Saurel's avatar
Guilhem Saurel committed
591
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
Guilhem Saurel's avatar
Guilhem Saurel committed
592
593
594
595
596
                if self.project.tag_set.filter(name=build['branch']['name']).exists():
                    continue
                branch_name = f'{self.forge.slug}/{self.namespace.slug}/{build["branch"]["name"]}'
                branch, created = Branch.objects.get_or_create(name=branch_name, project=self.project, repo=self)
                if created:
Guilhem Saurel's avatar
Guilhem Saurel committed
597
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
598
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
Guilhem Saurel committed
599
600
601
602
603
604
605
                CIBuild.objects.get_or_create(repo=self,
                                              build_id=build['id'],
                                              defaults={
                                                  'passed': TRAVIS_STATE[build['state']],
                                                  'started': parse_datetime(started),
                                                  'branch': branch,
                                              })
Guilhem Saurel's avatar
Guilhem Saurel committed
606
607

    def update(self, pull=True):
608
        ok = True
609
610
        if self.project.main_namespace is None:
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
611
612
        self.project.update_tags()
        if pull:
613
614
615
616
617
618
619
            ok = self.fetch()
        if ok:
            self.api_update()
            self.get_builds()
        else:
            logger.error(f'fetching {self.forge} / {self.namespace} / {self.project} - NOT FOUND - DELETING')
            logger.error(str(self.delete()))
Guilhem Saurel's avatar
Guilhem Saurel committed
620

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
621
622
623
624

class Commit(NamedModel, TimeStampedModel):
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

Guilhem Saurel's avatar
Guilhem Saurel committed
625
626
627
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
628

Guilhem Saurel's avatar
Guilhem Saurel committed
629
630
631
632
633
class Branch(TimeStampedModel):
    name = models.CharField(max_length=200)
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
    ahead = models.PositiveSmallIntegerField(blank=True, null=True)
    behind = models.PositiveSmallIntegerField(blank=True, null=True)
634
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
635
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
636
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
637
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
638
639

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
640
641
642
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
643
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
644
645

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
646
647
        commits = self.project.git().git.rev_list(f'{branch}..{self}')
        return len(commits.split('\n')) if commits else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
648
649

    def get_behind(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
650
651
        commits = self.project.git().git.rev_list(f'{self}..{branch}')
        return len(commits.split('\n')) if commits else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
652

653
654
655
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
656
            remote = self.repo.git()
657
658
659
660
661
            _, _, branch = self.name.split('/', maxsplit=2)
            git_repo.create_head(self.name, remote.refs[branch]).set_tracking_branch(remote.refs[branch])
        return git_repo.branches[self.name]

    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
662
663
664
665
666
667
668
        if self.deleted:
            return
        try:
            if pull:
                self.repo.fetch()
                if self.repo != self.project.main_repo():
                    self.project.main_repo().fetch()
Guilhem Saurel's avatar
details    
Guilhem Saurel committed
669
670
            try:
                main_branch = self.project.main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
671
672
                self.ahead = self.get_ahead(main_branch)
                self.behind = self.get_behind(main_branch)
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
673
            except Branch.DoesNotExist:
Guilhem Saurel's avatar
details    
Guilhem Saurel committed
674
                pass
Guilhem Saurel's avatar
Guilhem Saurel committed
675
676
677
            self.updated = self.git().commit.authored_datetime
        except (git.exc.GitCommandError, IndexError):
            self.deleted = True
Guilhem Saurel's avatar
Guilhem Saurel committed
678
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
679

Guilhem Saurel's avatar
Guilhem Saurel committed
680
681
682
683
684
685
686
    def ci(self):
        build = self.cibuild_set.last()
        if build is None:
            return ''
        status = {True: '✓', False: '✗', None: '?'}[build.passed]
        return mark_safe(f'<a href="{build.url()}">{status}</a>')

687
    def forge(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
688
        return self.repo.forge
689
690

    def namespace(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
691
        return self.repo.namespace
692

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
693

Guilhem Saurel's avatar
Guilhem Saurel committed
694
695
696
697
698
class ActiveQuerySet(models.QuerySet):
    def active(self):
        return self.filter(active=True)


Guilhem Saurel's avatar
Guilhem Saurel committed
699
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
700
701
702
    active = models.BooleanField(default=True)

    objects = ActiveQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
703
704
705


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
706
707
708
709
710
711
712
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     branch = models.ForeignKey(Branch, on_delete=models.CASCADE)
#     commit = models.ForeignKey(Commit, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
#     passed = models.BooleanField(default=False)
#     TODO: travis vs gitlab-ci ?
#     TODO: deploy binary, doc, coverage, lint
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
713

Guilhem Saurel's avatar
Guilhem Saurel committed
714
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
715
716
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
717
718


Guilhem Saurel's avatar
Guilhem Saurel committed
719
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
720
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
721
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
722

Guilhem Saurel's avatar
Guilhem Saurel committed
723
    pkgbase = models.CharField(max_length=50, default='')
724
    pkgversion = models.CharField(max_length=50, default='')
Guilhem Saurel's avatar
Guilhem Saurel committed
725
726
727
728
    master_sites = models.CharField(max_length=200, default='')
    master_repository = models.CharField(max_length=200, default='')
    maintainer = models.CharField(max_length=200, default='')
    comment = models.TextField()
729
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
730
731

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
732
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
733
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
734
735
736
737
738
739
740
741
742
743
    updated = models.DateTimeField(blank=True, null=True)

    def main_page(self):
        if self.category != 'wip':
            return f'{RPKG_URL}/robotpkg/{self.category}/{self.name}'

    def build_page(self):
        path = '-wip/wip' if self.category == 'wip' else f'/{self.category}'
        return f'{RPKG_URL}/rbulk/robotpkg{path}/{self.name}'

744
    def update_images(self):
745
        py3s = [False, True] if self.name.startswith('py-') else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
746
        debugs = [False, True]
Guilhem Saurel's avatar
Guilhem Saurel committed
747
        for target in Target.objects.active():
748
749
750
            for py3 in py3s:
                for debug in debugs:
                    Image.objects.get_or_create(robotpkg=self, target=target, py3=py3, debug=debug)[0].update()
Guilhem Saurel's avatar
Guilhem Saurel committed
751

752
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
753
754
755
756
757
758
        path = settings.RAINBOARD_RPKG
        repo = git.Repo(str(path / 'wip' / '.git' if self.category == 'wip' else path / '.git'))
        if pull:
            repo.remotes.origin.pull()

        cwd = path / self.category / self.name
Guilhem Saurel's avatar
Guilhem Saurel committed
759
760
761
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
762
763
764
765
766
767
768
769
770
771
772
773
774
        for field in RPKG_FIELDS:
            cmd = ['make', 'show-var', f'VARNAME={field}']
            self.__dict__[field.lower()] = check_output(cmd, cwd=cwd).decode().strip()

        repo_path = self.name if self.category == 'wip' else f'{self.category}/{self.name}'
        last_commit = next(repo.iter_commits(paths=repo_path, max_count=1))
        self.updated = last_commit.authored_datetime

        license = check_output(['make', 'show-var', f'VARNAME=LICENSE'], cwd=cwd).decode().strip()
        if license in RPKG_LICENSES:
            self.license = License.objects.get(spdx_id=RPKG_LICENSES[license])
        else:
            logger.warning(f'Unknown robotpkg license: {license}')
Guilhem Saurel's avatar
Guilhem Saurel committed
775
        self.public = not bool(check_output(['make', 'show-var', f'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
776
777
778
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

779
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
780
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
781

782
    def valid_images(self):
783
        return self.image_set.filter(created__isnull=False, target__active=True).order_by('target__name')
784

785
786
787
788
    def without_py(self):
        if 'py-' in self.name:
            return Robotpkg.objects.filter(name=self.name.replace('py-', '')).first()

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
789

Guilhem Saurel's avatar
Guilhem Saurel committed
790
# class RobotpkgBuild(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
791
792
793
#     robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
#     passed = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
794
795


796
797
class Image(models.Model):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
798
    target = models.ForeignKey(Target, on_delete=models.CASCADE)
799
800
    created = models.DateTimeField(blank=True, null=True)
    image = models.CharField(max_length=12, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
801
    py3 = models.BooleanField(default=False)
802
    debug = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
803
    allow_failure = models.BooleanField(default=False)
804
805

    class Meta:
806
        unique_together = ('robotpkg', 'target', 'py3', 'debug')
807
808

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
809
810
        py = '-py3' if self.py3 else ''
        return f'{self.robotpkg}{py}:{self.target}'
811
812

    def get_build_args(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
813
814
815
        ret = {
            'TARGET': self.target,
            'ROBOTPKG': self.robotpkg,
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
816
            'CATEGORY': self.robotpkg.category,
Guilhem Saurel's avatar
Guilhem Saurel committed
817
818
            'REGISTRY': self.robotpkg.project.registry(),
        }
Guilhem Saurel's avatar
Guilhem Saurel committed
819
        if not self.robotpkg.project.public:
Guilhem Saurel's avatar
Guilhem Saurel committed
820
821
822
            ret['IMAGE'] = 'robotpkg-jrl-py3' if self.py3 else 'robotpkg-jrl'
        elif self.py3:
            ret['IMAGE'] = 'robotpkg-py3'
Guilhem Saurel's avatar
Guilhem Saurel committed
823
        return ret
824
825
826

    def get_image_name(self):
        project = self.robotpkg.project
827
        return f'{project.registry()}/{project.main_namespace.slug}/{project.slug}/{self}'.lower()
828

829
830
831
    def get_image_url(self):
        project = self.robotpkg.project
        manifest = str(self).replace(':', '/manifests/')
832
        return f'https://{project.registry()}/v2/{project.main_namespace.slug}/{project.slug}/{manifest}'
833

Guilhem Saurel's avatar
Guilhem Saurel committed
834
    def get_job_name(self):
835
836
        mode = 'debug' if self.debug else 'release'
        return f'robotpkg-{self}-{mode}'.replace(':', '-')
Guilhem Saurel's avatar
Guilhem Saurel committed
837

838
839
840
    def build(self):
        args = self.get_build_args()
        build_args = sum((['--build-arg', f'{key}={value}'] for key, value in args.items()), list())
841
842
843
844
845
846
847
        return ['docker', 'build', '-t', self.get_image_name()] + build_args + ['.']

    def pull(self):
        return ['docker', 'pull', self.get_image_name()]

    def push(self):
        return ['docker', 'push', self.get_image_name()]
848

Guilhem Saurel's avatar
Guilhem Saurel committed
849
    def update(self, pull=False):
850
851
852
        headers = {}
        if not self.robotpkg.project.public:
            image_name = self.get_image_name().split('/', maxsplit=1)[1].split(':')[0]
Guilhem Saurel's avatar
Guilhem Saurel committed
853
854
855
856
857
858
859
            token = requests.get(f'{self.robotpkg.project.main_forge.url}/jwt/auth', {
                'client_id': 'docker',
                'offline_token': True,
                'service': 'container_registry',
                'scope': f'repository:{image_name}:push,pull'
            },
                                 auth=('gsaurel', self.robotpkg.project.main_forge.token)).json()['token']
860
861
            headers['Authorization'] = f'Bearer {token}'
        r = requests.get(self.get_image_url(), headers=headers)
862
863
864
865
        if r.status_code == 200:
            self.image = r.json()['fsLayers'][0]['blobSum'].split(':')[1][:12]
            self.created = parse_datetime(json.loads(r.json()['history'][0]['v1Compatibility'])['created'])
            self.save()
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
866
        if not self.allow_failure and self.created and (timezone.now() - self.created).days > 7:
867
868
            self.allow_failure = True
            self.save()
869
870


Guilhem Saurel's avatar
Guilhem Saurel committed
871
872
873
874
875
876
877
878
class CIBuild(models.Model):
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
    passed = models.NullBooleanField()
    build_id = models.PositiveIntegerField()
    started = models.DateTimeField()
    branch = models.ForeignKey(Branch, on_delete=models.CASCADE)

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
879
        ordering = ('-started', )
Guilhem Saurel's avatar
Guilhem Saurel committed
880
881
882
883
884
885
886
887

    def url(self):
        if self.repo.forge.source == SOURCES.github:
            return f'https://travis-ci.org/{self.repo.namespace.slug}/{self.repo.slug}/builds/{self.build_id}'
        if self.repo.forge.source == SOURCES.gitlab:
            return f'{self.repo.forge.url}/{self.repo.namespace.slug}/{self.repo.slug}/pipelines/{self.build_id}'


Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
888
889
890
891
892
893
894
895
896
897
898
class CIJob(models.Model):
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
    passed = models.NullBooleanField()
    job_id = models.PositiveIntegerField()
    started = models.DateTimeField()
    branch = models.ForeignKey(Branch, on_delete=models.CASCADE)

    class Meta:
        ordering = ('-started', )


Guilhem Saurel's avatar
Guilhem Saurel committed
899
900
901
902
903
904
class Tag(models.Model):
    name = models.CharField(max_length=200)
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

    class Meta:
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
905
        ordering = ('name', )
Guilhem Saurel's avatar
Guilhem Saurel committed
906
907
        unique_together = ('name', 'project')

Guilhem Saurel's avatar
Guilhem Saurel committed
908
909
910
    def __str__(self):
        return f'{self.project} {self.name}'

Guilhem Saurel's avatar
Guilhem Saurel committed
911

912
913
class GepettistQuerySet(models.QuerySet):
    def gepettist(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
914
        return self.filter(projects__from_gepetto=True, projects__archived=False)
915
916


Guilhem Saurel's avatar
Guilhem Saurel committed
917
918
class Contributor(models.Model):
    projects = models.ManyToManyField(Project)
Guilhem Saurel's avatar
Guilhem Saurel committed
919
    agreement_signed = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
920

921
922
    objects = GepettistQuerySet.as_manager()

Guilhem Saurel's avatar
Guilhem Saurel committed
923
924
925
926
927
928
929
930
931
932
933
934
    def __str__(self):
        name = self.contributorname_set.first()
        mail = self.contributormail_set.first()
        return f'{name} <{mail}>'

    def names(self):
        return ', '.join(str(name) for name in self.contributorname_set.all())

    def mails(self):
        return ', '.join(str(mail) for mail in self.contributormail_set.filter(invalid=False))

    def contributed(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
935
        return ', '.join(str(project) for project in self.projects.filter(from_gepetto=True, archived=False))
Guilhem Saurel's avatar
Guilhem Saurel committed
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952


class ContributorName(models.Model):
    contributor = models.ForeignKey(Contributor, on_delete=models.CASCADE, blank=True, null=True)
    name = models.CharField