models.py 54.6 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
Guilhem Saurel committed
53
54
BAD_ONES = Q(main_namespace__from_gepetto=False) | Q(robotpkg__isnull=True) | Q(archived=True)

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
55
56

class Namespace(NamedModel):
57
    group = models.BooleanField(default=False)
58
    from_gepetto = models.BooleanField(default=False)
Tom Pillot's avatar
Tom Pillot committed
59
60
61
62
63
64
65
66
67
    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
68
69


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

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


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

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

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

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

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

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
161
162
163
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
164
165
166
    def get_namespaces_travis(self):
        pass

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
167
168
169
    def get_projects(self):
        getattr(self, f'get_namespaces_{self.get_source_display()}')()
        return getattr(self, f'get_projects_{self.get_source_display()}')()
170

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

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
181
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
182
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
183

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

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
192
193
194
195
196
197
    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
198

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

218
219
220
221
    def save(self, *args, **kwargs):
        self.name = valid_name(self.name)
        super().save(*args, **kwargs)

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

Guilhem Saurel's avatar
Guilhem Saurel committed
225
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
226
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
227
228
229
230
231
        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
232
233
234
235
236
237
238
239
240
241
242
    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

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

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

Guilhem Saurel's avatar
update    
Guilhem Saurel committed
286
287
288
    def checkout(self):
        self.main_branch().git().checkout()

Guilhem Saurel's avatar
Guilhem Saurel committed
289
    def main_branch(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
290
        return self.main_repo().main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
291

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

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

334
335
336
337
338
339
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
340
341
342
343
    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
344
    def update_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
345
346
        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
347

Guilhem Saurel's avatar
fix CI    
Guilhem Saurel committed
348
349
350
    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
351
    def ci_jobs(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
352
353
354
        r = self.main_gitlab_repo()
        r.get_jobs_gitlab()
        r.get_builds_gitlab()
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
355

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

Guilhem Saurel's avatar
Guilhem Saurel committed
382
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
383
384
385
386
387
        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
388

389
390
391
392
393
394
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

395
396
397
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
398
399
400
401
402
403
404
405
406
    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()

407
408
409
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
410
    def doc_coverage_image(self):
411
412
        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
413

414
    def print_deps(self):
415
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
416
417

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

Guilhem Saurel's avatar
Guilhem Saurel committed
420
421
422
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
423
424
425
426
    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
427
428
429
430
431
432
433
434
435
436
437
438
        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
439
440
441
442
443
444
445
446
447
448
449
450

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

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
469
470
471
472
473
474
475
476
477
478
479
480
481
    def pipeline_results(self):
        """ Show state and link to latest master & devel gitlab pipelines """
        repo = self.main_gitlab_repo()
        ret = []
        for branch in ['master', 'main', 'devel']:
            build = repo.cibuild_set.filter(branch__name__endswith=branch).first()
            if build is not None:
                link = repo.url + f'/-/pipelines/{build.build_id}'
                sym = '✓' if build.passed else '✘'
                ret.append(f'<a href="{link}">{branch}: {sym}</a>')

        return mark_safe('<br>'.join(ret))

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
482

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
483
484
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
485
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
486
487
488
489
490
491
492
493
494
495
    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
496
    forked_from = models.PositiveIntegerField(blank=True, null=True)
497
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
498
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
499
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
500
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
501
502
503

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

    def api_url(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
506
        api_url = self.forge.api_url()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
507
        return {
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
508
509
510
            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
511
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
512

Guilhem Saurel's avatar
Guilhem Saurel committed
513
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
514
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
515
        try:
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
516
517
            return httpx.get(self.api_url() + url,
                             params={'page': page},
518
519
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
520
        except httpx.HTTPError:
521
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
522
523
            return httpx.get(self.api_url() + url,
                             params={'page': page},
524
525
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
526
527
528
529
530

    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
531
    def api_list(self, url='', name=None, limit=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
532
533
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
534
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
535
536
537
538
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
539
540
541
542
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
543
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
544
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
545
            if limit is not None and page is not None and page > limit:
Guilhem Saurel's avatar
Guilhem Saurel committed
546
                break
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
547

Guilhem Saurel's avatar
Guilhem Saurel committed
548
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
549
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
550
        if data:
Guilhem Saurel's avatar
Guilhem Saurel committed
551
552
553
554
555
556
557
558
            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
559
560

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

Guilhem Saurel's avatar
Guilhem Saurel committed
563
    def api_update_github(self, data):
564
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
565

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
566
567
568
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
569
570
        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
571
572
        return self.clone_url

573
574
575
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
576
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
577
        git_repo = self.project.git()
578
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
579
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
580
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
581
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
582
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
583
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
584

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
585
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
586
587
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
588
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
589
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
590
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
591
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
592
593
594
595
596
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
597

Guilhem Saurel's avatar
Guilhem Saurel committed
598
599
600
    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
601
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
602
603
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
604
605

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
606
607
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
608

Guilhem Saurel's avatar
Guilhem Saurel committed
609
610
611
612
    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
613
        for pipeline in self.api_list('/pipelines', limit=2):
Guilhem Saurel's avatar
Guilhem Saurel committed
614
615
616
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
617
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
618
619
620
621
            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
622
623
624
625
626
627
628
            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
629
630
631
632
633
            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
634
        for data in self.api_list('/jobs', limit=4):
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
635
            branch_name = f'{self.forge.slug}/{self.namespace.slug}/{data["ref"]}'
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
636
637
638
            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
639
640
641
642
643
644
645
            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
646
647
648
            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
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
            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
668
669
670
671

    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
672
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
673
                if build['branch'] is None or self.project.tag_set.filter(name=build['branch']['name']).exists():
Guilhem Saurel's avatar
Guilhem Saurel committed
674
675
676
677
                    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
678
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
679
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
Guilhem Saurel committed
680
681
682
683
684
685
686
                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
687
688

    def update(self, pull=True):
689
        ok = True
690
691
        if self.project.main_namespace is None:
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
692
693
        self.project.update_tags()
        if pull:
694
695
696
697
698
699
700
            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
701

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
702

703
704
705
706
707
708
709
710
711
712
713
714
715
716
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
717
        self.days_since_updated = (timezone.now() - timezone.make_aware(issue_pr.updated_at)).days
718
719
720
721
722
723
        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
724
725
726
class Commit(NamedModel, TimeStampedModel):
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
730

Guilhem Saurel's avatar
Guilhem Saurel committed
731
732
733
734
735
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)
736
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
737
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
738
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
739
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
740
741

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
742
743
744
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
745
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
746
747

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
748
749
        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
750
751

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

755
756
757
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
758
            remote = self.repo.git()
759
760
761
762
763
            _, _, 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
764
765
766
767
768
769
770
        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
771
772
            try:
                main_branch = self.project.main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
773
774
                self.ahead = self.get_ahead(main_branch)
                self.behind = self.get_behind(main_branch)
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
775
            except Branch.DoesNotExist:
Guilhem Saurel's avatar
details    
Guilhem Saurel committed
776
                pass
Guilhem Saurel's avatar
Guilhem Saurel committed
777
778
779
            self.updated = self.git().commit.authored_datetime
        except (git.exc.GitCommandError, IndexError):
            self.deleted = True
Guilhem Saurel's avatar
Guilhem Saurel committed
780
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
781

Guilhem Saurel's avatar
Guilhem Saurel committed
782
783
784
785
786
787
788
    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>')

789
    def forge(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
790
        return self.repo.forge
791
792

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
795

Guilhem Saurel's avatar
Guilhem Saurel committed
796
class TargetQuerySet(models.QuerySet):
Guilhem Saurel's avatar
Guilhem Saurel committed
797
798
799
    def active(self):
        return self.filter(active=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
800
801
802
    def main(self):
        return self.get(main=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
803

Guilhem Saurel's avatar
Guilhem Saurel committed
804
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
805
    active = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
806
    main = models.BooleanField(default=False)
807
    py2_available = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
808

Guilhem Saurel's avatar
Guilhem Saurel committed
809
    objects = TargetQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
810
811
812


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
813
814
815
816
817
818
819
#     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
820

Guilhem Saurel's avatar
Guilhem Saurel committed
821
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
822
823
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
824
825


Guilhem Saurel's avatar
Guilhem Saurel committed
826
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
827
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
828
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
829

Guilhem Saurel's avatar
Guilhem Saurel committed
830
    pkgbase = models.CharField(max_length=50, default='')
831
    pkgversion = models.CharField(max_length=50, default='')
Guilhem Saurel's avatar
Guilhem Saurel committed
832
833
834
835
    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()
836
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
837
838

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
839
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
840
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
841
842
    updated = models.DateTimeField(blank=True, null=True)

Guilhem Saurel's avatar
same_py    
Guilhem Saurel committed
843
844
    same_py = models.BooleanField(default=True)

845
846
    extended_target = models.ManyToManyField(Target)

Guilhem Saurel's avatar
Guilhem Saurel committed
847
848
849
850
851
852
853
854
    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}'

855
    def update_images(self):
856
        py3s = [False, True] if self.name.startswith('py-') else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
857
        debugs = [False, True]
858
        for target in list(Target.objects.active()) + list(self.extended_target.all()):
859
860
            for py3 in py3s:
                for debug in debugs:
Guilhem Saurel's avatar
Guilhem Saurel committed
861
862
                    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
863

864
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
865
866
867
868
869
870
        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
871
872
873
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
874
875
876
877
878
879
880
881
        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
882
        license = check_output(['make', 'show-var', 'VARNAME=LICENSE'], cwd=cwd).decode().strip()
Guilhem Saurel's avatar
Guilhem Saurel committed
883
884
885
886
        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
887
        self.public = not bool(check_output(['make', 'show-var', 'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
888
889
890
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

891
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
892
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
893

894
    def valid_images(self):
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
        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()

914
915
        images = self.image_set.filter(Q(target__active=True) | Q(target__robotpkg=self),
                                       created__isnull=False).order_by('target__name')
916
        return (image for image in images if is_valid(base_image, image))
917

918
    def without_py(self):
Guilhem Saurel's avatar
same_py    
Guilhem Saurel committed
919
        if 'py-' in self.name and self.same_py:
920
921
            return Robotpkg.objects.filter(name=self.name.replace('py-', '')).first()

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
922