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

Guilhem Saurel's avatar
Guilhem Saurel committed
6
7
import git
import requests
8
from autoslug import AutoSlugField
Guilhem Saurel's avatar
Guilhem Saurel committed
9
from django.conf import settings
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
10
from django.db import models
Guilhem Saurel's avatar
Guilhem Saurel committed
11
from django.db.models import Q
Guilhem Saurel's avatar
Guilhem Saurel committed
12
from django.db.models.functions import Length
13
from django.db.utils import DataError
14
from django.template.loader import get_template
15
from django.utils import timezone
Guilhem Saurel's avatar
Guilhem Saurel committed
16
17
from django.utils.dateparse import parse_datetime
from django.utils.safestring import mark_safe
Guilhem Saurel's avatar
Guilhem Saurel committed
18
from ndh.models import Links, NamedModel, TimeStampedModel
Guilhem Saurel's avatar
Guilhem Saurel committed
19
from ndh.utils import enum_to_choices, query_sum
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
20

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

23
24
logger = logging.getLogger('rainboard.models')

Guilhem Saurel's avatar
Guilhem Saurel committed
25
MAIN_BRANCHES = ['master', 'devel']
Guilhem Saurel's avatar
Guilhem Saurel committed
26
RPKG_URL = 'http://robotpkg.openrobots.org'
Guilhem Saurel's avatar
Guilhem Saurel committed
27
DOC_URL = 'http://projects.laas.fr/gepetto/doc'
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
28
29
30
31
32
33
34
35
36
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
37
RPKG_FIELDS = ['PKGBASE', 'PKGVERSION', 'MASTER_SITES', 'MASTER_REPOSITORY', 'MAINTAINER', 'COMMENT', 'HOMEPAGE']
Guilhem Saurel's avatar
Guilhem Saurel committed
38
39
40
41
42
43
44
CMAKE_FIELDS = {
    'NAME': 'cmake_name',
    'DESCRIPTION': 'description',
    'URL': 'homepage',
    'VERSION': 'version',
    'SUFFIX': 'suffix'
}
Guilhem Saurel's avatar
Guilhem Saurel committed
45
TRAVIS_STATE = {'created': None, 'passed': True, 'started': None, 'failed': False, 'errored': False, 'canceled': False}
Guilhem Saurel's avatar
Guilhem Saurel committed
46
GITLAB_STATUS = {'failed': False, 'success': True, 'pending': None, 'skipped': None, 'canceled': None, 'running': None}
Guilhem Saurel's avatar
Guilhem Saurel committed
47

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
48
49

class Namespace(NamedModel):
50
    group = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
51
52


Guilhem Saurel's avatar
Guilhem Saurel committed
53
54
55
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
56
57
58
59
60
61
    url = models.URLField(max_length=200)

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


Guilhem Saurel's avatar
Guilhem Saurel committed
62
class Forge(Links, NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
63
64
65
66
67
    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
68
69
70
    def get_absolute_url(self):
        return self.url

Guilhem Saurel's avatar
Guilhem Saurel committed
71
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
72
        logger.debug(f'requesting api {self} {url}, page {page}')
73
74
75
76
77
        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
78
79
80
81
82
83

    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
84
85
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
86
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
87
88
89
90
91
            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
92
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
93
            page = api_next(self.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
94
95

    def headers(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
96
        return {
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
97
98
99
100
101
102
103
104
105
106
107
108
109
110
            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
111
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
112
113

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
114
115
116
117
        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
118
            SOURCES.travis: 'https://api.travis-ci.org',
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
119
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
120

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

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
130
131
    def get_namespaces_gitlab(self):
        for data in self.api_list('/namespaces'):
Guilhem Saurel's avatar
Guilhem Saurel committed
132
133
134
135
136
            Namespace.objects.get_or_create(slug=data['path'],
                                            defaults={
                                                'name': data['name'],
                                                'group': data['kind'] == 'group'
                                            })
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
137
138
139
        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
140
141
142
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
143
144
145
    def get_namespaces_travis(self):
        pass

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

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

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
160
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
161
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
162
163

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

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
171
172
173
174
175
176
    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
177

Guilhem Saurel's avatar
Guilhem Saurel committed
178
class Project(Links, NamedModel, TimeStampedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
179
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
180
181
182
183
    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
184
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
185
    version = models.CharField(max_length=20, blank=True, null=True)
186
    updated = models.DateTimeField(blank=True, null=True)
187
188
    tests = models.BooleanField(default=True)
    docs = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
189
    from_gepetto = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
190
    cmake_name = models.CharField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
191
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
192
    suffix = models.CharField(max_length=50, default='', blank=True)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
193
    allow_format_failure = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
194
    has_python = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
195

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
203
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
204
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
205
206
207
208
209
        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'))

210
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
211
        forge = self.main_forge if self.main_forge else get_default_forge(self)
Guilhem Saurel's avatar
Guilhem Saurel committed
212
213
214
215
216
217
218
219
        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
220
        if created:
221
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
222
223
        return repo

Guilhem Saurel's avatar
Guilhem Saurel committed
224
    def update_branches(self, main=True, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
225
226
227
        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
228
        for branch in branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
229
            logger.info(f'update branch {branch}')
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
230
231
            if branch.startswith('remotes/'):
                branch = branch[8:]
232
233
234
            if branch.count('/') < 2:
                logger.error(f'wrong branch "{branch}" in {self.git_path()}')
                continue
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
235
236
237
            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
238
239
240
241
242
243
244
245
            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
246
247
            if created:
                repo.api_update()
248
249
250
            instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=repo)
            if bcreated:
                instance.update(pull=pull)
251

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
258
259
260
261
262
263
264
    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
265
            search = re.search(r'set\s*\(\s*project_%s\s+([^)]+)*\)' % key, content, re.I)
Guilhem Saurel's avatar
Guilhem Saurel committed
266
            if search:
267
                try:
268
                    old = getattr(self, value)
269
                    new = search.groups()[0].strip(''' \r\n\t'"''').replace('_', '-')
270
271
272
                    if old != new:
                        setattr(self, value, new)
                        self.save()
273
                except DataError:
274
                    setattr(self, value, old)
275
        for dependency in re.findall(r'ADD_[A-Z]+_DEPENDENCY\s*\(["\']?([^ "\')]+).*["\']?\)', content, re.I):
Guilhem Saurel's avatar
Guilhem Saurel committed
276
            project = Project.objects.filter(name=valid_name(dependency))
277
            if project.exists():
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
278
279
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.cmake:
280
281
                    dependency.cmake = True
                    dependency.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
282

283
    def ros(self):
284
285
        try:
            filename = self.git_path() / 'package.xml'
286
        except TypeError:
287
            return
288
289
290
291
292
        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
293
            project = Project.objects.filter(name=valid_name(dependency))
294
295
296
297
298
299
            if project.exists():
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.ros:
                    dependency.ros = True
                    dependency.save()

300
301
302
303
304
305
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
306
307
308
309
    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
310
    def update_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
311
312
        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
313

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
344
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
345
346
347
348
349
        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
350

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

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
360
361
362
363
364
365
366
367
368
    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()

369
370
371
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
372
373
374
375
    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()

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

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
    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
402
                          f'{self.url_gitlab()}/badges/master/coverage.svg?job=doc-coverage"', 'Coverage Report')
Guilhem Saurel's avatar
Guilhem Saurel committed
403
404

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

Guilhem Saurel's avatar
Guilhem Saurel committed
408
409
410
411
412
413
414
    def cron(self):
        """ generate a cron-style interval description to run CI monthly on master """
        hour, day = (self.pk // 30) % 24, self.pk % 30 + 1
        return f'0 {hour} {day} * *'

    def pipeline_schedules(self):
        """ provides a link to gitlab's CI schedules page showing then cron rule to use with this project """
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
415
        repo = self.repo_set.filter(forge__source=SOURCES.gitlab, namespace__group=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
416
417
        if repo.exists():
            link = repo.first().url + '/pipeline_schedules'
418
            return mark_safe(f'<a href="{link}">{self.cron()}</a>')
Guilhem Saurel's avatar
Guilhem Saurel committed
419

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
420

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
421
422
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
423
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
424
425
426
427
428
429
430
431
432
433
    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
434
    forked_from = models.PositiveIntegerField(blank=True, null=True)
435
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
436
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
437
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
438
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
439
440
441

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

    def api_url(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
444
        api_url = self.forge.api_url()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
445
        return {
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
446
447
448
            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
449
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
450

Guilhem Saurel's avatar
Guilhem Saurel committed
451
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
452
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
453
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
454
455
456
            return requests.get(self.api_url() + url, {'page': page},
                                verify=self.forge.verify,
                                headers=self.forge.headers())
457
458
        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
459
460
461
            return requests.get(self.api_url() + url, {'page': page},
                                verify=self.forge.verify,
                                headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
462
463
464
465
466
467

    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
468
469
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
470
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
471
472
473
474
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
475
476
477
478
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
479
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
480
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
481

Guilhem Saurel's avatar
Guilhem Saurel committed
482
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
483
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
484
        if data:
Guilhem Saurel's avatar
Guilhem Saurel committed
485
486
487
488
489
490
491
492
            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
493
494

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

Guilhem Saurel's avatar
Guilhem Saurel committed
497
    def api_update_github(self, data):
498
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
499

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
500
501
502
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
503
504
        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
505
506
        return self.clone_url

507
508
509
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
510
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
511
        git_repo = self.project.git()
512
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
513
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
514
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
515
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
516
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
517
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
518

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
519
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
520
521
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
522
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
523
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
524
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
525
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
526
527
528
529
530
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
531

Guilhem Saurel's avatar
Guilhem Saurel committed
532
533
534
    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
535
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
536
537
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
538
539

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
540
541
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
542

Guilhem Saurel's avatar
Guilhem Saurel committed
543
544
545
546
    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
547
        for pipeline in self.api_list('/pipelines'):
Guilhem Saurel's avatar
Guilhem Saurel committed
548
549
550
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
551
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
552
553
554
555
            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
556
557
558
559
560
561
562
            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
563
564
565
566
567
568
            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
569
            branch_name = f'{self.forge.slug}/{self.namespace.slug}/{data["ref"]}'
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
570
571
572
            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
573
574
575
576
577
578
579
            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
580
581
582
583
584
585
586
587
            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
588
589
590
591
                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
592
593
594
                if image.allow_failure and GITLAB_STATUS[data['status']]:
                    image.allow_failure = False
                    image.save()
595
                    print('  success', data['web_url'])
Guilhem Saurel's avatar
Guilhem Saurel committed
596
597
598
599

    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
600
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
601
                if build['branch'] is None or self.project.tag_set.filter(name=build['branch']['name']).exists():
Guilhem Saurel's avatar
Guilhem Saurel committed
602
603
604
605
                    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
606
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
607
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
Guilhem Saurel committed
608
609
610
611
612
613
614
                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
615
616

    def update(self, pull=True):
617
        ok = True
618
619
        if self.project.main_namespace is None:
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
620
621
        self.project.update_tags()
        if pull:
622
623
624
625
626
627
628
            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
629

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
630
631
632
633

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

Guilhem Saurel's avatar
Guilhem Saurel committed
634
635
636
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
637

Guilhem Saurel's avatar
Guilhem Saurel committed
638
639
640
641
642
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)
643
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
644
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
645
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
646
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
647
648

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
649
650
651
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
652
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
653
654

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
655
656
        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
657
658

    def get_behind(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
659
660
        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
661

662
663
664
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
665
            remote = self.repo.git()
666
667
668
669
670
            _, _, 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
671
672
673
674
675
676
677
        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
678
679
            try:
                main_branch = self.project.main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
680
681
                self.ahead = self.get_ahead(main_branch)
                self.behind = self.get_behind(main_branch)
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
682
            except Branch.DoesNotExist:
Guilhem Saurel's avatar
details    
Guilhem Saurel committed
683
                pass
Guilhem Saurel's avatar
Guilhem Saurel committed
684
685
686
            self.updated = self.git().commit.authored_datetime
        except (git.exc.GitCommandError, IndexError):
            self.deleted = True
Guilhem Saurel's avatar
Guilhem Saurel committed
687
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
688

Guilhem Saurel's avatar
Guilhem Saurel committed
689
690
691
692
693
694
695
    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>')

696
    def forge(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
697
        return self.repo.forge
698
699

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
702

Guilhem Saurel's avatar
Guilhem Saurel committed
703
704
705
706
707
class ActiveQuerySet(models.QuerySet):
    def active(self):
        return self.filter(active=True)


Guilhem Saurel's avatar
Guilhem Saurel committed
708
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
709
710
711
    active = models.BooleanField(default=True)

    objects = ActiveQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
712
713
714


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
715
716
717
718
719
720
721
#     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
722

Guilhem Saurel's avatar
Guilhem Saurel committed
723
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
724
725
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
726
727


Guilhem Saurel's avatar
Guilhem Saurel committed
728
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
729
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
730
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
731

Guilhem Saurel's avatar
Guilhem Saurel committed
732
    pkgbase = models.CharField(max_length=50, default='')
733
    pkgversion = models.CharField(max_length=50, default='')
Guilhem Saurel's avatar
Guilhem Saurel committed
734
735
736
737
    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()
738
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
739
740

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
741
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
742
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
743
744
745
746
747
748
749
750
751
752
    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}'

753
    def update_images(self):
754
        py3s = [False, True] if self.name.startswith('py-') else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
755
        debugs = [False, True]
Guilhem Saurel's avatar
Guilhem Saurel committed
756
        for target in Target.objects.active():
757
758
759
            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
760

761
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
762
763
764
765
766
767
        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
768
769
770
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
771
772
773
774
775
776
777
778
779
780
781
782
783
        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
784
        self.public = not bool(check_output(['make', 'show-var', f'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
785
786
787
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

788
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
789
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
790

791
    def valid_images(self):
792
        return self.image_set.filter(created__isnull=False, target__active=True).order_by('target__name')
793

794
795
796
797
    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
798

Guilhem Saurel's avatar
Guilhem Saurel committed
799
# class RobotpkgBuild(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
800
801
802
#     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
803
804


805
806
class Image(models.Model):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
807
    target = models.ForeignKey(Target, on_delete=models.CASCADE)
808
809
    created = models.DateTimeField(blank=True, null=True)
    image = models.CharField(max_length=12, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
810
    py3 = models.BooleanField(default=False)
811
    debug = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
812
    allow_failure = models.BooleanField(default=False)
813
814

    class Meta:
815
        unique_together = ('robotpkg', 'target', 'py3', 'debug')
816
817

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
818
819
        py = '-py3' if self.py3 else ''
        return f'{self.robotpkg}{py}:{self.target}'
820
821

    def get_build_args(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
822
823
824
        ret = {
            'TARGET': self.target,
            'ROBOTPKG': self.robotpkg,
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
825
            'CATEGORY': self.robotpkg.category,
Guilhem Saurel's avatar
Guilhem Saurel committed
826
827
            'REGISTRY': self.robotpkg.project.registry(),
        }
Guilhem Saurel's avatar
Guilhem Saurel committed
828
        if not self.robotpkg.project.public:
Guilhem Saurel's avatar
Guilhem Saurel committed
829
830
831
            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
832
        return ret
833
834
835

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

838
839
840
    def get_image_url(self):
        project = self.robotpkg.project
        manifest = str(self).replace(':', '/manifests/')
841
        return f'https://{project.registry()}/v2/{project.main_namespace.slug}/{project.slug}/{manifest}'
842

Guilhem Saurel's avatar
Guilhem Saurel committed
843
    def get_job_name(self):
844
845
        mode = 'debug' if self.debug else 'release'
        return f'robotpkg-{self}-{mode}'.replace(':', '-')
Guilhem Saurel's avatar
Guilhem Saurel committed
846

847
848
849
    def build(self):
        args = self.get_build_args()
        build_args = sum((['--build-arg', f'{key}={value}'] for key, value in args.items()), list())
850
851
852
853
854
855
856
        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()]
857

Guilhem Saurel's avatar
Guilhem Saurel committed
858
    def update(self, pull=False):
859
860
861
        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
862
863
864
865
866
867
868
            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']
869
870
            headers['Authorization'] = f'Bearer {token}'
        r = requests.get(self.get_image_url(), headers=headers)
871
872
873
874
        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
875
        if not self.allow_failure and self.created and (timezone.now() - self.created).days > 7:
876
877
            self.allow_failure = True
            self.save()
878
879


Guilhem Saurel's avatar
Guilhem Saurel committed
880
881
882
883
884
885
886
887
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
888
        ordering = ('-started', )
Guilhem Saurel's avatar
Guilhem Saurel committed
889
890
891
892
893
894
895
896

    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
897
898
899
900
901
902
903
904
905
906
907
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
908
909
910
911
912
913
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
914
        ordering = ('name', )
Guilhem Saurel's avatar
Guilhem Saurel committed
915
916
        unique_together = ('name', 'project')

Guilhem Saurel's avatar
Guilhem Saurel committed
917
918
919
    def __str__(self):
        return f'{self.project} {self.name}'

Guilhem Saurel's avatar
Guilhem Saurel committed
920

921
922
class GepettistQuerySet(models.QuerySet):
    def gepettist(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
923
        return self.filter(projects__from_gepetto=True, projects__archived=False)
924
925


Guilhem Saurel's avatar
Guilhem Saurel committed
926
927
class Contributor(models.Model):
    projects = models.ManyToManyField(Project)
Guilhem Saurel's avatar
Guilhem Saurel committed
928
    agreement_signed = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
929

930
931
    objects = GepettistQuerySet.as_manager()

Guilhem Saurel's avatar
Guilhem Saurel committed
932
933
934
935
936
937
938
939
940
941
942
943
    def __str__(self):
        name = self.