models.py 55.3 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
Guilhem Saurel's avatar
   
Guilhem Saurel committed
9
from django.db.utils import DataError, IntegrityError
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
Guilhem Saurel's avatar
   
Guilhem Saurel committed
153
154
155
156
157
158
159
160
161
162
163
164
            try:
                Namespace.objects.get_or_create(slug=slugify(data['path']),
                                                defaults={
                                                    'name': data['name'],
                                                    'group': data['kind'] == 'group'
                                                })
            except IntegrityError:
                Namespace.objects.get_or_create(slug=slugify(data['path']),
                                                defaults={
                                                    'name': data['name'] + ' 2',
                                                    'group': data['kind'] == 'group'
                                                })
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
165
        for data in self.api_list('/users'):
Guilhem Saurel's avatar
Guilhem Saurel committed
166
167
            if data['name'] == 'dockering':
                continue
168
            Namespace.objects.get_or_create(slug=slugify(data['username']), defaults={'name': data['name']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
169

Guilhem Saurel's avatar
Guilhem Saurel committed
170
171
172
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
173
174
175
    def get_namespaces_travis(self):
        pass

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
176
177
178
    def get_projects(self):
        getattr(self, f'get_namespaces_{self.get_source_display()}')()
        return getattr(self, f'get_projects_{self.get_source_display()}')()
179

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
180
    def get_projects_github(self):
181
        for org in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
182
            for data in self.api_list(f'/orgs/{org.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
183
                update_github(self, org, data)
184
        for user in Namespace.objects.filter(group=False):
Guilhem Saurel's avatar
Guilhem Saurel committed
185
            for data in self.api_list(f'/users/{user.slug}/repos'):
Guilhem Saurel's avatar
Guilhem Saurel committed
186
                if Project.objects.filter(name=valid_name(data['name'])).exists():
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
187
                    update_github(self, user, data)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
188
189

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
190
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
191
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
192

Guilhem Saurel's avatar
Guilhem Saurel committed
193
        for orphan in Project.objects.filter(main_namespace=None).exclude(name__endswith='release'):
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
194
            repo = orphan.repo_set.filter(forge__source=SOURCES.gitlab).first()
Guilhem Saurel's avatar
Guilhem Saurel committed
195
196
            if repo:
                update_gitlab(self, self.api_data(f'/projects/{repo.forked_from}'))
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
197
198
199
200

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
201
202
203
204
205
206
    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
207

Guilhem Saurel's avatar
Guilhem Saurel committed
208
class Project(Links, NamedModel, TimeStampedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
209
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
210
211
212
213
    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
214
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
215
    version = models.CharField(max_length=20, blank=True, null=True)
216
    updated = models.DateTimeField(blank=True, null=True)
217
218
    tests = models.BooleanField(default=True)
    docs = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
219
    cmake_name = models.CharField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
220
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
221
    suffix = models.CharField(max_length=50, default='', blank=True)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
222
    allow_format_failure = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
223
    has_python = models.BooleanField(default=True)
Tom Pillot's avatar
Tom Pillot committed
224
    accept_pr_to_master = models.BooleanField(default=False)
225
    ccache = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
226

227
228
229
230
    def save(self, *args, **kwargs):
        self.name = valid_name(self.name)
        super().save(*args, **kwargs)

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

Guilhem Saurel's avatar
Guilhem Saurel committed
234
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
235
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
236
237
238
239
240
        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
241
242
243
244
245
246
247
248
249
250
251
    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

252
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
253
        forge = self.main_forge if self.main_forge else get_default_forge(self)
Guilhem Saurel's avatar
Guilhem Saurel committed
254
255
256
257
258
259
260
261
        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
262
        if created:
263
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
264
265
        return repo

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

Guilhem Saurel's avatar
update    
Guilhem Saurel committed
295
296
297
    def checkout(self):
        self.main_branch().git().checkout()

Guilhem Saurel's avatar
Guilhem Saurel committed
298
    def main_branch(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
299
        return self.main_repo().main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
300

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

326
    def ros(self):
327
328
        try:
            filename = self.git_path() / 'package.xml'
329
        except TypeError:
330
            return
331
332
333
334
335
        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
336
            project = Project.objects.filter(name=valid_name(dependency))
337
338
339
340
341
342
            if project.exists():
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.ros:
                    dependency.ros = True
                    dependency.save()

343
344
345
346
347
348
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
349
350
351
352
    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
353
    def update_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
354
355
        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
356

Guilhem Saurel's avatar
fix CI    
Guilhem Saurel committed
357
358
359
    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
360
    def ci_jobs(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
361
362
363
        r = self.main_gitlab_repo()
        r.get_jobs_gitlab()
        r.get_builds_gitlab()
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
364

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

Guilhem Saurel's avatar
Guilhem Saurel committed
391
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
392
393
394
395
396
        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
397

398
399
400
401
402
403
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

404
405
406
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
407
408
409
410
411
412
413
414
415
    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()

416
417
418
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
419
    def doc_coverage_image(self):
420
421
        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
422

423
    def print_deps(self):
424
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
425
426

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

Guilhem Saurel's avatar
Guilhem Saurel committed
429
430
431
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
432
433
434
435
    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
436
437
438
439
440
441
442
443
444
445
446
447
        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
448
449
450
451
452
453
454
455
456
457
458
459

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
466
467
468
469
470
471
472
    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
473
        repo = self.repo_set.filter(forge__source=SOURCES.gitlab, namespace__group=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
474
475
        if repo.exists():
            link = repo.first().url + '/pipeline_schedules'
476
            return mark_safe(f'<a href="{link}">{self.cron()}</a>')
Guilhem Saurel's avatar
Guilhem Saurel committed
477

Guilhem Saurel's avatar
Guilhem Saurel committed
478
479
480
481
482
483
484
485
486
487
488
489
490
    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
491

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
492
493
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
494
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
495
496
497
498
499
500
501
502
503
504
    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
505
    forked_from = models.PositiveIntegerField(blank=True, null=True)
506
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
507
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
508
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
509
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
510
511
512

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

    def api_url(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
515
        api_url = self.forge.api_url()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
516
        return {
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
517
518
519
            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
520
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
521

Guilhem Saurel's avatar
Guilhem Saurel committed
522
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
523
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
524
        try:
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
525
526
            return httpx.get(self.api_url() + url,
                             params={'page': page},
527
528
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
529
        except httpx.HTTPError:
530
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
531
532
            return httpx.get(self.api_url() + url,
                             params={'page': page},
533
534
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
535
536
537
538
539

    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
540
    def api_list(self, url='', name=None, limit=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
541
542
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
543
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
544
545
546
547
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
548
549
550
551
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
552
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
553
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
554
            if limit is not None and page is not None and page > limit:
Guilhem Saurel's avatar
Guilhem Saurel committed
555
                break
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
556

Guilhem Saurel's avatar
Guilhem Saurel committed
557
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
558
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
559
        if data:
Guilhem Saurel's avatar
Guilhem Saurel committed
560
561
562
563
564
565
566
567
            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
568
569

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

Guilhem Saurel's avatar
Guilhem Saurel committed
572
    def api_update_github(self, data):
573
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
574

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
575
576
577
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
578
579
        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
580
581
        return self.clone_url

582
583
584
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
585
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
586
        git_repo = self.project.git()
587
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
588
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
589
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
590
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
591
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
592
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
593

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
594
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
595
596
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
597
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
598
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
599
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
600
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
601
602
603
604
605
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
606

Guilhem Saurel's avatar
Guilhem Saurel committed
607
608
609
    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
610
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
611
612
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
613
614

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
615
616
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
617

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

    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
681
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
682
                if build['branch'] is None or self.project.tag_set.filter(name=build['branch']['name']).exists():
Guilhem Saurel's avatar
Guilhem Saurel committed
683
684
685
686
                    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
687
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
688
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
Guilhem Saurel committed
689
690
691
692
693
694
695
                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
696
697

    def update(self, pull=True):
698
        ok = True
699
700
        if self.project.main_namespace is None:
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
701
702
        self.project.update_tags()
        if pull:
703
704
705
706
707
708
709
            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
710

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
711

712
713
714
715
716
717
718
719
720
721
722
723
724
725
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
726
        self.days_since_updated = (timezone.now() - timezone.make_aware(issue_pr.updated_at)).days
727
728
729
730
731
732
        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
733
734
735
class Commit(NamedModel, TimeStampedModel):
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

Guilhem Saurel's avatar
Guilhem Saurel committed
736
737
738
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
739

Guilhem Saurel's avatar
Guilhem Saurel committed
740
741
742
743
744
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)
745
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
746
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
747
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
748
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
749
750

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
751
752
753
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
754
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
755
756

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
757
758
        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
759
760

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
791
792
793
794
795
796
797
    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>')

798
    def forge(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
799
        return self.repo.forge
800
801

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
804

Guilhem Saurel's avatar
Guilhem Saurel committed
805
class TargetQuerySet(models.QuerySet):
Guilhem Saurel's avatar
Guilhem Saurel committed
806
807
808
    def active(self):
        return self.filter(active=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
809
810
811
    def main(self):
        return self.get(main=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
812

Guilhem Saurel's avatar
Guilhem Saurel committed
813
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
814
    active = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
815
    main = models.BooleanField(default=False)
816
    py2_available = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
817
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
818

Guilhem Saurel's avatar
Guilhem Saurel committed
819
    objects = TargetQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
820
821
822


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
823
824
825
826
827
828
829
#     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
830

Guilhem Saurel's avatar
Guilhem Saurel committed
831
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
832
833
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
834
835


Guilhem Saurel's avatar
Guilhem Saurel committed
836
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
837
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
838
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
839

Guilhem Saurel's avatar
Guilhem Saurel committed
840
    pkgbase = models.CharField(max_length=50, default='')
841
    pkgversion = models.CharField(max_length=50, default='')
Guilhem Saurel's avatar
Guilhem Saurel committed
842
843
844
845
    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()
846
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
847
848

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
849
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
850
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
851
852
    updated = models.DateTimeField(blank=True, null=True)

Guilhem Saurel's avatar
same_py    
Guilhem Saurel committed
853
854
    same_py = models.BooleanField(default=True)

855
856
    extended_target = models.ManyToManyField(Target)

Guilhem Saurel's avatar
Guilhem Saurel committed
857
858
859
860
861
862
863
864
    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}'

865
    def update_images(self):
866
        py3s = [False, True] if self.name.startswith('py-') else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
867
        debugs = [False, True]
868
        for target in list(Target.objects.active()) + list(self.extended_target.all()):
869
870
            for py3 in py3s:
                for debug in debugs:
Guilhem Saurel's avatar
Guilhem Saurel committed
871
872
                    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
873

874
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
875
876
877
878
879
880
        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
881
882
883
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
884
885
886
887
888
889
890
891
        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
892
        license = check_output(['make', 'show-var', 'VARNAME=LICENSE'], cwd=cwd).decode().strip()
Guilhem Saurel's avatar
Guilhem Saurel committed
893
894
895
896
        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
897
        self.public = not bool(check_output(['make', 'show-var', 'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
898
899
900
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

901
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
902
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
903

904
    def valid_images(self):
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
        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()

924
925
        images = self.image_set.filter(Q(target__active=True) | Q(target__robotpkg=self),
                                       created__isnull=False).order_by('target__name')
926
        return (image for image in images if is_valid(base_image, image))
927

928
    def without_py(self):