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

Guilhem Saurel's avatar
Guilhem Saurel committed
6
7
8
9
import git
import httpx
from autoslug import AutoSlugField
from autoslug.utils import slugify
Guilhem Saurel's avatar
Guilhem Saurel committed
10
from django.conf import settings
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
11
from django.db import models
Guilhem Saurel's avatar
Guilhem Saurel committed
12
from django.db.models import Q
Guilhem Saurel's avatar
   
Guilhem Saurel committed
13
from django.db.utils import DataError, IntegrityError
14
from django.template.loader import get_template
15
from django.utils import timezone
Guilhem Saurel's avatar
Guilhem Saurel committed
16
17
from django.utils.dateparse import parse_datetime
from django.utils.safestring import mark_safe
Tom Pillot's avatar
Tom Pillot committed
18
19
from github import Github
from gitlab import Gitlab
Guilhem Saurel's avatar
Guilhem Saurel committed
20
from ndh.models import Links, NamedModel, TimeStampedModel
Guilhem Saurel's avatar
Guilhem Saurel committed
21
from ndh.utils import query_sum
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
22

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

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
52
53
BAD_ONES = Q(main_namespace__from_gepetto=False) | Q(robotpkg__isnull=True) | Q(archived=True)

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
54
55

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


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

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


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

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

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

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

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

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

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
148
149
    def get_namespaces_gitlab(self):
        for data in self.api_list('/namespaces'):
Guilhem Saurel's avatar
Guilhem Saurel committed
150
151
            if data['name'] == 'dockering':
                continue
Guilhem Saurel's avatar
   
Guilhem Saurel committed
152
153
154
155
156
157
158
159
160
161
162
163
            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
164
        for data in self.api_list('/users'):
Guilhem Saurel's avatar
Guilhem Saurel committed
165
166
            if data['name'] == 'dockering':
                continue
167
            Namespace.objects.get_or_create(slug=slugify(data['username']), defaults={'name': data['name']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
168

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

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

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

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

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

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

    def get_projects_redmine(self):
        pass  # TODO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

364
    def update(self, only_main_branches=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
365
366
        if self.main_namespace is None:
            return
367
        self.update_branches(main=only_main_branches)
Guilhem Saurel's avatar
Guilhem Saurel committed
368
        self.update_tags()
Guilhem Saurel's avatar
Guilhem Saurel committed
369
        self.update_repo()
370
371
        tags = self.tag_set.filter(name__startswith='v')  # TODO: implement SQL ordering for semver
        if tags.exists():
Guilhem Saurel's avatar
Guilhem Saurel committed
372
373
374
375
376
377
378
379
380
            releases = []
            for tag in tags:
                try:
                    release = tuple(int(v) for v in tag.name[1:].split('.'))
                    releases.append(release)
                except ValueError:
                    pass
            if releases:
                self.version = '%i.%i.%i' % sorted(releases)[-1]
381
        robotpkg = self.robotpkg_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
382
        branch = self.branch_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
383
384
385
        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
386
            if not robotpkg_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
387
                self.updated = branch.updated
Guilhem Saurel's avatar
Guilhem Saurel committed
388
            elif not branch_updated:
Guilhem Saurel's avatar
Guilhem Saurel committed
389
390
391
                self.updated = robotpkg.updated
            else:
                self.updated = max(branch.updated, robotpkg.updated)
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
392
        self.ci_jobs()
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
393
        self.checkout()
394
        self.cmake()
Guilhem Saurel's avatar
Guilhem Saurel committed
395
        self.ros()
396
397
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
398
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
399
400
401
402
403
        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
404

405
406
407
408
409
410
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

411
412
413
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
414
415
416
417
418
419
420
421
422
    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()

423
424
425
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
426
    def doc_coverage_image(self):
427
428
        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
429

430
    def print_deps(self):
431
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
432
433

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

Guilhem Saurel's avatar
Guilhem Saurel committed
436
437
438
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
439
440
441
442
    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
443
444
445
446
447
448
449
450
451
452
453
454
        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
455
456
457
458
459
460
461
462
463
464
465
466

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
473
474
475
476
477
478
479
    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
480
        repo = self.repo_set.filter(forge__source=SOURCES.gitlab, namespace__group=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
481
482
        if repo.exists():
            link = repo.first().url + '/pipeline_schedules'
483
            return mark_safe(f'<a href="{link}">{self.cron()}</a>')
Guilhem Saurel's avatar
Guilhem Saurel committed
484

Guilhem Saurel's avatar
Guilhem Saurel committed
485
486
487
488
489
490
491
492
493
494
495
496
    def pipeline_result(self, branch):
        repo = self.main_gitlab_repo()
        build = repo.cibuild_set.filter(branch__name__endswith=branch).first()
        return None if build is None else build.passed

    def master_result(self):
        master = self.pipeline_result('master')
        return self.pipeline_result('main') if master is None else master

    def devel_result(self):
        return self.pipeline_result('devel')

Guilhem Saurel's avatar
Guilhem Saurel committed
497
498
499
500
501
502
503
504
505
506
507
508
509
    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
510

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
511
512
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
513
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
514
515
516
517
518
519
520
521
522
523
    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
524
    forked_from = models.PositiveIntegerField(blank=True, null=True)
525
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
526
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
527
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
528
    archived = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
529
530
531

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

    def api_url(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
534
        api_url = self.forge.api_url()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
535
        return {
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
536
537
538
            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
539
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
540

Guilhem Saurel's avatar
Guilhem Saurel committed
541
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
542
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
543
        try:
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
544
545
            return httpx.get(self.api_url() + url,
                             params={'page': page},
546
547
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
548
        except httpx.HTTPError:
549
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
style    
Guilhem Saurel committed
550
551
            return httpx.get(self.api_url() + url,
                             params={'page': page},
552
553
                             verify=self.forge.verify,
                             headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
554
555
556
557
558

    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
559
    def api_list(self, url='', name=None, limit=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
560
561
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
562
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
563
564
565
566
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
567
568
569
570
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
571
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
572
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
573
            if limit is not None and page is not None and page > limit:
Guilhem Saurel's avatar
Guilhem Saurel committed
574
                break
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
575

Guilhem Saurel's avatar
Guilhem Saurel committed
576
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
577
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
578
        if data:
Guilhem Saurel's avatar
Guilhem Saurel committed
579
580
581
582
583
584
585
586
            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
587
588

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

Guilhem Saurel's avatar
Guilhem Saurel committed
591
    def api_update_github(self, data):
592
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
593

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
594
595
596
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
597
598
        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
599
600
        return self.clone_url

601
602
603
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
604
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
605
        git_repo = self.project.git()
606
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
607
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
608
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
609
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
610
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
611
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
612

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
613
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
614
615
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
616
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
617
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
618
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
619
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
620
621
622
623
624
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
625

Guilhem Saurel's avatar
Guilhem Saurel committed
626
627
628
    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
629
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
630
631
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
632
633

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
634
635
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
636

Guilhem Saurel's avatar
Guilhem Saurel committed
637
638
639
640
    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
641
        for pipeline in self.api_list('/pipelines', limit=2):
Guilhem Saurel's avatar
Guilhem Saurel committed
642
643
644
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
645
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
646
647
648
649
            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
650
651
652
653
654
655
656
            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
657
658
659
660
661
            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
662
        for data in self.api_list('/jobs', limit=4):
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
663
            branch_name = f'{self.forge.slug}/{self.namespace.slug}/{data["ref"]}'
Guilhem Saurel's avatar
cijob    
Guilhem Saurel committed
664
665
666
            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
667
668
669
670
671
672
673
            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
674
675
676
            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
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
            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
696
697
698
699

    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
700
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
701
                if build['branch'] is None or self.project.tag_set.filter(name=build['branch']['name']).exists():
Guilhem Saurel's avatar
Guilhem Saurel committed
702
703
704
705
                    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
706
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
707
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
Guilhem Saurel committed
708
709
710
711
712
713
714
                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
715
716

    def update(self, pull=True):
717
        ok = True
718
719
        if self.project.main_namespace is None:
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
720
721
        self.project.update_tags()
        if pull:
722
723
724
725
726
727
728
            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
729

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
730

731
732
733
734
735
736
737
738
739
740
741
742
743
744
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
745
        self.days_since_updated = (timezone.now() - timezone.make_aware(issue_pr.updated_at)).days
746
747
748
749
750
751
        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
752
753
754
class Commit(NamedModel, TimeStampedModel):
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
758

Guilhem Saurel's avatar
Guilhem Saurel committed
759
760
761
762
763
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)
764
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
765
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
766
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
767
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
768
769

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
770
771
772
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
773
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
774
775

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
776
777
        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
778
779

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

783
784
785
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
786
            remote = self.repo.git()
787
788
789
790
791
            _, _, 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
792
793
794
795
796
797
798
        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
799
800
            try:
                main_branch = self.project.main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
801
802
                self.ahead = self.get_ahead(main_branch)
                self.behind = self.get_behind(main_branch)
Guilhem Saurel's avatar
typo    
Guilhem Saurel committed
803
            except Branch.DoesNotExist:
Guilhem Saurel's avatar
details    
Guilhem Saurel committed
804
                pass
Guilhem Saurel's avatar
Guilhem Saurel committed
805
806
807
            self.updated = self.git().commit.authored_datetime
        except (git.exc.GitCommandError, IndexError):
            self.deleted = True
Guilhem Saurel's avatar
Guilhem Saurel committed
808
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
809

Guilhem Saurel's avatar
Guilhem Saurel committed
810
811
812
813
814
815
816
    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>')

817
    def forge(self):
Guilhem Saurel's avatar
update    
Guilhem Saurel committed
818
        return self.repo.forge
819
820

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
823

Guilhem Saurel's avatar
Guilhem Saurel committed
824
class TargetQuerySet(models.QuerySet):
Guilhem Saurel's avatar
Guilhem Saurel committed
825
826
827
    def active(self):
        return self.filter(active=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
828
829
830
    def main(self):
        return self.get(main=True)

Guilhem Saurel's avatar
Guilhem Saurel committed
831

Guilhem Saurel's avatar
Guilhem Saurel committed
832
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
833
    active = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
834
    main = models.BooleanField(default=False)
835
    py2_available = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
836
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
837

Guilhem Saurel's avatar
Guilhem Saurel committed
838
    objects = TargetQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
839
840
841


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
842
843
844
845
846
847
848
#     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
849

Guilhem Saurel's avatar
Guilhem Saurel committed
850
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
851
852
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
853
854


Guilhem Saurel's avatar
Guilhem Saurel committed
855
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
856
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
857
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
858

Guilhem Saurel's avatar
Guilhem Saurel committed
859
    pkgbase = models.CharField(max_length=50, default='')
860
    pkgversion = models.CharField(max_length=50, default='')
Guilhem Saurel's avatar
Guilhem Saurel committed
861
862
863
864
    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()
865
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
866
867

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
868
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
869
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
870
871
    updated = models.DateTimeField(blank=True, null=True)

Guilhem Saurel's avatar
same_py    
Guilhem Saurel committed
872
873
    same_py = models.BooleanField(default=True)

874
875
    extended_target = models.ManyToManyField(Target)

Guilhem Saurel's avatar
Guilhem Saurel committed
876
877
878
879
880
881
882
883
    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}'

884
    def update_images(self):
885
        py3s = [False, True] if self.name.startswith('py-') else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
886
        debugs = [False, True]
887
        for target in list(Target.objects.active()) + list(self.extended_target.all()):
888
889
            for py3 in py3s:
                for debug in debugs:
Guilhem Saurel's avatar
Guilhem Saurel committed
890
891
                    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
892

893
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
894
895
896
897
898
899
        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
900
901
902
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
903
904
905
906
907
908
909
910
        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
911
        license = check_output(['make', 'show-var', 'VARNAME=LICENSE'], cwd=cwd).decode().strip()
Guilhem Saurel's avatar
Guilhem Saurel committed
912
913
914
915
        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
916
        self.public = not bool(check_output(['make', 'show-var', 'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
917
918
919
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

920
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
921
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
922

923
    def valid_images(self):
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
        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()

943
944
        images = self.image_set.filter(Q(target__active=True) | Q(target__robotpkg=self),
                                       created__isnull=False).order_by('target__name')