models.py 54 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
from django.conf import settings
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
7
from django.db import models
Guilhem Saurel's avatar
Guilhem Saurel committed
8
from django.db.models import Q
9
from django.db.utils import DataError
10
from django.template.loader import get_template
11
from django.utils import timezone
Guilhem Saurel's avatar
Guilhem Saurel committed
12
13
from django.utils.dateparse import parse_datetime
from django.utils.safestring import mark_safe
Guilhem Saurel's avatar
Guilhem Saurel committed
14

15
import git
Guilhem Saurel's avatar
Guilhem Saurel committed
16
import httpx
Guilhem Saurel's avatar
Guilhem Saurel committed
17
from autoslug import AutoSlugField
18
from autoslug.utils import slugify
Tom Pillot's avatar
Tom Pillot committed
19
20
from github import Github
from gitlab import Gitlab
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 = 'https://gepettoweb.laas.fr/doc'
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
31
32
33
RPKG_LICENSES = {
    'gnu-lgpl-v3': 'LGPL-3.0',
    'gnu-lgpl-v2': 'LGPL-2.0',
Guilhem Saurel's avatar
Guilhem Saurel committed
34
    'gnu-lgpl-v2.1': 'LGPL-2.1',
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
35
36
37
38
39
40
    '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
41
RPKG_FIELDS = ['PKGBASE', 'PKGVERSION', 'MASTER_SITES', 'MASTER_REPOSITORY', 'MAINTAINER', 'COMMENT', 'HOMEPAGE']
Guilhem Saurel's avatar
Guilhem Saurel committed
42
43
44
45
46
47
48
CMAKE_FIELDS = {
    'NAME': 'cmake_name',
    'DESCRIPTION': 'description',
    'URL': 'homepage',
    'VERSION': 'version',
    'SUFFIX': 'suffix'
}
Guilhem Saurel's avatar
Guilhem Saurel committed
49
TRAVIS_STATE = {'created': None, 'passed': True, 'started': None, 'failed': False, 'errored': False, 'canceled': False}
Guilhem Saurel's avatar
Guilhem Saurel committed
50
GITLAB_STATUS = {'failed': False, 'success': True, 'pending': None, 'skipped': None, 'canceled': None, 'running': None}
51
GEPETTO_SLUGS = ['gepetto', 'stack-of-tasks', 'humanoid-path-planner', 'loco-3d']
Guilhem Saurel's avatar
Guilhem Saurel committed
52

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
53
54

class Namespace(NamedModel):
55
    group = models.BooleanField(default=False)
56
    from_gepetto = models.BooleanField(default=False)
Tom Pillot's avatar
Tom Pillot committed
57
58
59
60
61
62
63
64
65
    slug_gitlab = models.CharField(max_length=200, default='')
    slug_github = models.CharField(max_length=200, default='')

    def save(self, *args, **kwargs):
        if self.slug_gitlab == '':
            self.slug_gitlab = self.slug
        if self.slug_github == '':
            self.slug_github = self.slug
        super(Namespace, self).save(*args, **kwargs)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
66
67


Guilhem Saurel's avatar
Guilhem Saurel committed
68
69
70
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
71
72
73
74
75
76
    url = models.URLField(max_length=200)

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


Guilhem Saurel's avatar
Guilhem Saurel committed
77
class Forge(Links, NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
78
79
80
81
82
    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
83
84
85
    def get_absolute_url(self):
        return self.url

Guilhem Saurel's avatar
Guilhem Saurel committed
86
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
87
        logger.debug(f'requesting api {self} {url}, page {page}')
88
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
89
            return httpx.get(self.api_url() + url, params={'page': page}, verify=self.verify, headers=self.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
90
        except httpx.HTTPError:
91
            logger.error(f'requesting api {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
Guilhem Saurel committed
92
            return httpx.get(self.api_url() + url, params={'page': page}, verify=self.verify, headers=self.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
93
94
95
96
97

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

Guilhem Saurel's avatar
Guilhem Saurel committed
98
    def api_list(self, url='', name=None, limit=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
99
100
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
101
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
102
103
104
105
106
            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
107
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
108
            page = api_next(self.source, req)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
109
            if limit is not None and page is not None and page > limit:
Guilhem Saurel's avatar
Guilhem Saurel committed
110
                break
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
111
112

    def headers(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
113
        return {
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
114
115
116
117
118
119
120
121
122
123
124
125
126
127
            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
128
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
129
130

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
131
132
133
134
        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
135
            SOURCES.travis: 'https://api.travis-ci.org',
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
136
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
137

138
139
    def get_namespaces_github(self):
        for namespace in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
140
            for data in self.api_list(f'/orgs/{namespace.slug}/members'):
Guilhem Saurel's avatar
Guilhem Saurel committed
141
142
143
144
145
                Namespace.objects.get_or_create(slug=data['login'].lower(),
                                                defaults={
                                                    'name': data['login'],
                                                    'group': False
                                                })
146

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
147
148
    def get_namespaces_gitlab(self):
        for data in self.api_list('/namespaces'):
149
            Namespace.objects.get_or_create(slug=slugify(data['path']),
Guilhem Saurel's avatar
Guilhem Saurel committed
150
151
152
153
                                            defaults={
                                                'name': data['name'],
                                                'group': data['kind'] == 'group'
                                            })
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
154
        for data in self.api_list('/users'):
155
            Namespace.objects.get_or_create(slug=slugify(data['username']), defaults={'name': data['name']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
156

Guilhem Saurel's avatar
Guilhem Saurel committed
157
158
159
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
160
161
162
    def get_namespaces_travis(self):
        pass

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
163
164
165
    def get_projects(self):
        getattr(self, f'get_namespaces_{self.get_source_display()}')()
        return getattr(self, f'get_projects_{self.get_source_display()}')()
166

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
167
    def get_projects_github(self):
168
        for org in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
169
            for data in self.api_list(f'/orgs/{org.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
170
                update_github(self, org, data)
171
        for user in Namespace.objects.filter(group=False):
Guilhem Saurel's avatar
Guilhem Saurel committed
172
            for data in self.api_list(f'/users/{user.slug}/repos'):
Guilhem Saurel's avatar
Guilhem Saurel committed
173
                if Project.objects.filter(name=valid_name(data['name'])).exists():
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
174
                    update_github(self, user, data)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
175
176

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
177
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
178
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
179

Guilhem Saurel's avatar
Guilhem Saurel committed
180
        for orphan in Project.objects.filter(main_namespace=None).exclude(name__endswith='release'):
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
181
            repo = orphan.repo_set.filter(forge__source=SOURCES.gitlab).first()
Guilhem Saurel's avatar
Guilhem Saurel committed
182
183
            if repo:
                update_gitlab(self, self.api_data(f'/projects/{repo.forked_from}'))
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
184
185
186
187

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
188
189
190
191
192
193
    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
194

Guilhem Saurel's avatar
Guilhem Saurel committed
195
class Project(Links, NamedModel, TimeStampedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
196
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
197
198
199
200
    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
201
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
202
    version = models.CharField(max_length=20, blank=True, null=True)
203
    updated = models.DateTimeField(blank=True, null=True)
204
205
    tests = models.BooleanField(default=True)
    docs = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
206
    cmake_name = models.CharField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
207
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
208
    suffix = models.CharField(max_length=50, default='', blank=True)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
209
    allow_format_failure = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
210
    has_python = models.BooleanField(default=True)
Tom Pillot's avatar
Tom Pillot committed
211
    accept_pr_to_master = models.BooleanField(default=False)
212
    ccache = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
213

214
215
216
217
    def save(self, *args, **kwargs):
        self.name = valid_name(self.name)
        super().save(*args, **kwargs)

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

Guilhem Saurel's avatar
Guilhem Saurel committed
221
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
222
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
223
224
225
226
227
        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'))

Tom Pillot's avatar
Tom Pillot committed
228
229
230
231
232
233
234
235
236
237
238
    def github(self):
        github_forge = Forge.objects.get(slug='github')
        gh = Github(github_forge.token)
        return gh.get_repo(f'{self.main_namespace.slug_github}/{self.slug}')

    def gitlab(self):
        gitlab_forge = Forge.objects.get(slug='gitlab')
        gl = Gitlab(gitlab_forge.url, private_token=gitlab_forge.token)
        gl_repo = gl.projects.get(f'{self.main_namespace.slug_gitlab}/{self.slug}')
        return gl_repo

239
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
240
        forge = self.main_forge if self.main_forge else get_default_forge(self)
Guilhem Saurel's avatar
Guilhem Saurel committed
241
242
243
244
245
246
247
248
        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
249
        if created:
250
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
251
252
        return repo

Guilhem Saurel's avatar
Guilhem Saurel committed
253
    def update_branches(self, main=True, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
254
255
256
        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
257
        for branch in branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
258
            logger.info(f'update branch {branch}')
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
259
260
            if branch.startswith('remotes/'):
                branch = branch[8:]
261
            if branch.count('/') < 2:
Guilhem Saurel's avatar
Guilhem Saurel committed
262
263
                if branch != 'master':
                    logger.error(f'wrong branch "{branch}" in {self.git_path()}')
264
                continue
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
265
            forge, namespace, name = branch.split('/', maxsplit=2)
266
            namespace, _ = Namespace.objects.get_or_create(slug=slugify(namespace), defaults={'name': namespace})
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
267
            forge = Forge.objects.get(slug=forge)
Guilhem Saurel's avatar
Guilhem Saurel committed
268
269
270
271
272
273
274
275
            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
276
277
            if created:
                repo.api_update()
278
279
280
            instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=repo)
            if bcreated:
                instance.update(pull=pull)
281

Guilhem Saurel's avatar
update    
Guilhem Saurel committed
282
283
284
    def checkout(self):
        self.main_branch().git().checkout()

Guilhem Saurel's avatar
Guilhem Saurel committed
285
    def main_branch(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
286
        return self.main_repo().main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
287

Guilhem Saurel's avatar
Guilhem Saurel committed
288
289
290
291
292
293
294
    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
295
            search = re.search(r'set\s*\(\s*project_%s\s+([^)]+)*\)' % key, content, re.I)
Guilhem Saurel's avatar
Guilhem Saurel committed
296
            if search:
297
                try:
298
                    old = getattr(self, value)
299
                    new = search.groups()[0].strip(''' \r\n\t'"''').replace('_', '-')
300
301
302
                    if old != new:
                        setattr(self, value, new)
                        self.save()
303
                except DataError:
304
                    setattr(self, value, old)
305
        for dependency in re.findall(r'ADD_[A-Z]+_DEPENDENCY\s*\(["\']?([^ "\')]+).*["\']?\)', content, re.I):
Guilhem Saurel's avatar
Guilhem Saurel committed
306
            project = Project.objects.filter(name=valid_name(dependency))
307
            if project.exists():
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
308
309
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.cmake:
310
311
                    dependency.cmake = True
                    dependency.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
312

313
    def ros(self):
314
315
        try:
            filename = self.git_path() / 'package.xml'
316
        except TypeError:
317
            return
318
319
320
321
322
        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
323
            project = Project.objects.filter(name=valid_name(dependency))
324
325
326
327
328
329
            if project.exists():
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.ros:
                    dependency.ros = True
                    dependency.save()

330
331
332
333
334
335
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
336
337
338
339
    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
340
    def update_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
341
342
        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
343

Guilhem Saurel's avatar
fix CI    
Guilhem Saurel committed
344
345
346
    def main_gitlab_repo(self):
        return self.repo_set.get(forge__source=SOURCES.gitlab, namespace=self.main_namespace)

Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
347
    def ci_jobs(self):
Guilhem Saurel's avatar
fix CI    
Guilhem Saurel committed
348
        self.main_gitlab_repo().get_jobs_gitlab()
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
349

350
    def update(self, only_main_branches=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
351
352
        if self.main_namespace is None:
            return
353
        self.update_branches(main=only_main_branches)
Guilhem Saurel's avatar
Guilhem Saurel committed
354
        self.update_tags()
Guilhem Saurel's avatar
Guilhem Saurel committed
355
        self.update_repo()
356
        tag = self.tag_set.filter(name__startswith='v').last()  # TODO: implement SQL ordering for semver
Guilhem Saurel's avatar
Guilhem Saurel committed
357
358
        if tag is not None:
            self.version = tag.name[1:]
359
        robotpkg = self.robotpkg_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
360
        branch = self.branch_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
361
362
363
        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
364
            if not robotpkg_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
365
                self.updated = branch.updated
Guilhem Saurel's avatar
Guilhem Saurel committed
366
            elif not branch_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
367
368
369
                self.updated = robotpkg.updated
            else:
                self.updated = max(branch.updated, robotpkg.updated)
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
370
        self.ci_jobs()
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
371
        self.checkout()
372
        self.cmake()
Guilhem Saurel's avatar
Guilhem Saurel committed
373
        self.ros()
374
375
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
376
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
377
378
379
380
381
        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
382

383
384
385
386
387
388
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

389
390
391
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
392
393
394
395
396
397
398
399
400
    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()

401
402
403
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
404
    def doc_coverage_image(self):
405
406
        images = Image.objects.filter(robotpkg__project=self, target__main=True)
        return images.order_by('-py3', '-debug').first()  # 18.04 / Python 3 / Debug is the preferred image
Guilhem Saurel's avatar
Guilhem Saurel committed
407

408
    def print_deps(self):
409
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
410
411

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

Guilhem Saurel's avatar
Guilhem Saurel committed
414
415
416
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
417
418
419
420
    def url_travis(self):
        return f'https://travis-ci.org/{self.main_namespace.slug}/{self.slug}'

    def url_gitlab(self):
Tom Pillot's avatar
Tom Pillot committed
421
422
423
424
425
426
427
428
429
430
431
432
        return f'https://gitlab.laas.fr/{self.main_namespace.slug_gitlab}/{self.slug}'

    def remote_url_gitlab(self):
        gitlab_forge = Forge.objects.get(source=SOURCES.gitlab)
        return self.url_gitlab().replace('://', f'://gitlab-ci-token:{gitlab_forge.token}@')

    def url_github(self):
        return f'https://github.com/{self.main_namespace.slug_github}/{self.slug}'

    def remote_url_github(self):
        github_forge = Forge.objects.get(source=SOURCES.github)
        return self.url_github().replace('://', f'://{settings.GITHUB_USER}:{github_forge.token}@')
Guilhem Saurel's avatar
Guilhem Saurel committed
433
434
435
436
437
438
439
440
441
442
443
444

    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
445
                          f'{self.url_gitlab()}/badges/master/coverage.svg?job=doc-coverage"', 'Coverage Report')
Guilhem Saurel's avatar
Guilhem Saurel committed
446
447

    def badges(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
448
449
        # travis = self.badge_travis() if self.public else mark_safe('')
        return self.badge_gitlab() + self.badge_coverage()
Guilhem Saurel's avatar
Guilhem Saurel committed
450

Guilhem Saurel's avatar
Guilhem Saurel committed
451
452
453
454
455
456
457
    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
458
        repo = self.repo_set.filter(forge__source=SOURCES.gitlab, namespace__group=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
459
460
        if repo.exists():
            link = repo.first().url + '/pipeline_schedules'
461
            return mark_safe(f'<a href="{link}">{self.cron()}</a>')
Guilhem Saurel's avatar
Guilhem Saurel committed
462

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
463

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
464
465
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
466
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
467
468
469
470
471
472
473
474
475
476
    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
477
    forked_from = models.PositiveIntegerField(blank=True, null=True)
478
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
479
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
480
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
481
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
482
483
484

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

    def api_url(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
487
        api_url = self.forge.api_url()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
488
        return {
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
489
490
491
            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
492
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
493

Guilhem Saurel's avatar
Guilhem Saurel committed
494
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
495
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
496
        try:
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
497
498
            return httpx.get(self.api_url() + url,
                             params={'page': page},
499
500
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
501
        except httpx.HTTPError:
502
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
503
504
            return httpx.get(self.api_url() + url,
                             params={'page': page},
505
506
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
507
508
509
510
511

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

Guilhem Saurel's avatar
Guilhem Saurel committed
512
    def api_list(self, url='', name=None, limit=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
513
514
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
515
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
516
517
518
519
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
520
521
522
523
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
524
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
525
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
526
            if limit is not None and page is not None and page > limit:
Guilhem Saurel's avatar
Guilhem Saurel committed
527
                break
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
528

Guilhem Saurel's avatar
Guilhem Saurel committed
529
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
530
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
531
        if data:
Guilhem Saurel's avatar
Guilhem Saurel committed
532
533
534
535
536
537
538
539
            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
540
541

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

Guilhem Saurel's avatar
Guilhem Saurel committed
544
    def api_update_github(self, data):
545
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
546

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
547
548
549
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
550
551
        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
552
553
        return self.clone_url

554
555
556
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
557
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
558
        git_repo = self.project.git()
559
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
560
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
561
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
562
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
563
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
564
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
565

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
566
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
567
568
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
569
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
570
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
571
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
572
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
573
574
575
576
577
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
578

Guilhem Saurel's avatar
Guilhem Saurel committed
579
580
581
    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
582
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
583
584
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
585
586

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
587
588
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
589

Guilhem Saurel's avatar
Guilhem Saurel committed
590
591
592
593
    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
594
        for pipeline in self.api_list('/pipelines'):
Guilhem Saurel's avatar
Guilhem Saurel committed
595
596
597
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
598
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
599
600
601
602
            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
603
604
605
606
607
608
609
            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
610
611
612
613
614
            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):
Guilhem Saurel's avatar
Guilhem Saurel committed
615
        for data in self.api_list('/jobs', limit=4):
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
616
            branch_name = f'{self.forge.slug}/{self.namespace.slug}/{data["ref"]}'
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
617
618
619
            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
620
621
622
623
624
625
626
            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
627
628
629
            if not created and ci_job.passed != GITLAB_STATUS[data['status']]:
                ci_job.passed = GITLAB_STATUS[data['status']]
                ci_job.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
            if self == self.project.main_repo():
                if data['name'] == 'format':
                    if self.project.allow_format_failure and GITLAB_STATUS[data['status']]:
                        self.project.allow_format_failure = False
                        self.project.save()
                        print(' format success', data['web_url'])
                elif 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:-(3 + len(target) + (5 if debug else 7) + (3 if py3 else 0))]  # shame.
                    images = Image.objects.filter(robotpkg__name=robotpkg, target__name=target, debug=debug, py3=py3)
                    if not images.exists():
                        continue
                    image = images.first()
                    if image.allow_failure and GITLAB_STATUS[data['status']]:
                        image.allow_failure = False
                        image.save()
                        print('  success', data['web_url'])
Guilhem Saurel's avatar
Guilhem Saurel committed
649
650
651
652

    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
653
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
654
                if build['branch'] is None or self.project.tag_set.filter(name=build['branch']['name']).exists():
Guilhem Saurel's avatar
Guilhem Saurel committed
655
656
657
658
                    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
659
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
660
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
Guilhem Saurel committed
661
662
663
664
665
666
667
                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
668
669

    def update(self, pull=True):
670
        ok = True
671
672
        if self.project.main_namespace is None:
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
673
674
        self.project.update_tags()
        if pull:
675
676
677
678
679
680
681
            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
682

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
683

684
685
686
687
688
689
690
691
692
693
694
695
696
697
class IssuePr(models.Model):
    title = models.CharField(max_length=200)
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
    number = models.PositiveSmallIntegerField()
    days_since_updated = models.PositiveSmallIntegerField(blank=True, null=True)
    url = models.URLField(max_length=200)
    is_issue = models.BooleanField(default=True)

    class Meta:
        unique_together = ('repo', 'number', 'is_issue')

    def update(self, skip_label):
        gh = self.repo.project.github()
        issue_pr = gh.get_issue(number=self.number) if self.is_issue else gh.get_pull(number=self.number)
Tom Pillot's avatar
Tom Pillot committed
698
        self.days_since_updated = (timezone.now() - timezone.make_aware(issue_pr.updated_at)).days
699
700
701
702
703
704
        if issue_pr.state == 'closed' or skip_label in [label.name for label in issue_pr.get_labels()]:
            self.delete()
        else:
            self.save()


Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
705
706
707
class Commit(NamedModel, TimeStampedModel):
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

Guilhem Saurel's avatar
Guilhem Saurel committed
708
709
710
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
711

Guilhem Saurel's avatar
Guilhem Saurel committed
712
713
714
715
716
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)
717
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
718
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
719
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
720
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
721
722

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
723
724
725
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
726
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
727
728

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
729
730
        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
731
732

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

736
737
738
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
739
            remote = self.repo.git()
740
741
742
743
744
            _, _, 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
745
746
747
748
749
750
751
        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
752
753
            try:
                main_branch = self.project.main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
754
755
                self.ahead = self.get_ahead(main_branch)
                self.behind = self.get_behind(main_branch)
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
756
            except Branch.DoesNotExist:
Guilhem Saurel's avatar
details    
Guilhem Saurel committed
757
                pass
Guilhem Saurel's avatar
Guilhem Saurel committed
758
759
760
            self.updated = self.git().commit.authored_datetime
        except (git.exc.GitCommandError, IndexError):
            self.deleted = True
Guilhem Saurel's avatar
Guilhem Saurel committed
761
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
762

Guilhem Saurel's avatar
Guilhem Saurel committed
763
764
765
766
767
768
769
    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>')

770
    def forge(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
771
        return self.repo.forge
772
773

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
776

Guilhem Saurel's avatar
Guilhem Saurel committed
777
class TargetQuerySet(models.QuerySet):
Guilhem Saurel's avatar
Guilhem Saurel committed
778
779
780
    def active(self):
        return self.filter(active=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
781
782
783
    def main(self):
        return self.get(main=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
784

Guilhem Saurel's avatar
Guilhem Saurel committed
785
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
786
    active = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
787
    main = models.BooleanField(default=False)
788
    py2_available = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
789

Guilhem Saurel's avatar
Guilhem Saurel committed
790
    objects = TargetQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
791
792
793


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
794
795
796
797
798
799
800
#     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
801

Guilhem Saurel's avatar
Guilhem Saurel committed
802
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
803
804
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
805
806


Guilhem Saurel's avatar
Guilhem Saurel committed
807
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
808
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
809
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
810

Guilhem Saurel's avatar
Guilhem Saurel committed
811
    pkgbase = models.CharField(max_length=50, default='')
812
    pkgversion = models.CharField(max_length=50, default='')
Guilhem Saurel's avatar
Guilhem Saurel committed
813
814
815
816
    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()
817
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
818
819

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
820
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
821
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
822
823
    updated = models.DateTimeField(blank=True, null=True)

Guilhem Saurel's avatar
same_py    
Guilhem Saurel committed
824
825
    same_py = models.BooleanField(default=True)

826
827
    extended_target = models.ManyToManyField(Target)

Guilhem Saurel's avatar
Guilhem Saurel committed
828
829
830
831
832
833
834
835
    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}'

836
    def update_images(self):
837
        py3s = [False, True] if self.name.startswith('py-') else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
838
        debugs = [False, True]
839
        for target in list(Target.objects.active()) + list(self.extended_target.all()):
840
841
            for py3 in py3s:
                for debug in debugs:
Guilhem Saurel's avatar
Guilhem Saurel committed
842
843
                    if target.py2_available or py3 or not self.name.startswith('py-'):
                        Image.objects.get_or_create(robotpkg=self, target=target, py3=py3, debug=debug)[0].update()
Guilhem Saurel's avatar
Guilhem Saurel committed
844

845
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
846
847
848
849
850
851
        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
852
853
854
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
855
856
857
858
859
860
861
862
        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

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
863
        license = check_output(['make', 'show-var', 'VARNAME=LICENSE'], cwd=cwd).decode().strip()
Guilhem Saurel's avatar
Guilhem Saurel committed
864
865
866
867
        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
flake8    
Guilhem Saurel committed
868
        self.public = not bool(check_output(['make', 'show-var', 'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
869
870
871
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

872
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
873
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
874

875
    def valid_images(self):
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
        def is_valid(_base_image, _image):
            """The image is valid if it has less than one different parameter from the base image."""
            if _image == self.project.doc_coverage_image():
                #  There is no need to keep this image because it is already tested by doc-coverage
                return False

            base_param = (_base_image.target.name, _base_image.py3, _base_image.debug)
            param = (_image.target.name, _image.py3, _image.debug)

            diff = 0  # Number of different parameters between the base image and the current image
            for i in range(len(base_param)):
                if base_param[i] != param[i]:
                    diff += 1
            return diff <= 1

        # 18.04 / Python 3 / Release is the preferred base image
        base_images = Image.objects.filter(robotpkg__project=self.project, target__main=True)
        base_image = base_images.order_by('-py3', 'debug').first()

895
896
        images = self.image_set.filter(Q(target__active=True) | Q(target__robotpkg=self),
                                       created__isnull=False).order_by('target__name')
897
        return (image for image in images if is_valid(base_image, image))
898

899
    def without_py(self):
Guilhem Saurel's avatar
same_py    
Guilhem Saurel committed
900
        if 'py-' in self.name and self.same_py:
901
902
            return Robotpkg.objects.filter(name=self.name.replace('py-', '')).first()

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
903

Guilhem Saurel's avatar
Guilhem Saurel committed
904
# class RobotpkgBuild(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
905
906
907
#     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
908
909


910
911
class Image(models.Model):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
912
    target = models.ForeignKey(Target, on_delete=models.CASCADE)
913
914
    created = models.DateTimeField(blank=True, null=True)
    image = models.CharField(max_length=12