models.py 38.5 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.functions import Length
9
from django.db.utils import DataError
10
from django.template.loader import get_template
Guilhem Saurel's avatar
Guilhem Saurel committed
11
12
from django.utils.dateparse import parse_datetime
from django.utils.safestring import mark_safe
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
13

Guilhem Saurel's avatar
Guilhem Saurel committed
14
import requests
15
16

import git
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
17
from autoslug import AutoSlugField
Guilhem Saurel's avatar
Guilhem Saurel committed
18
from ndh.models import Links, NamedModel, TimeStampedModel
19
from ndh.utils import enum_to_choices, query_sum
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
20

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
25
MAIN_BRANCHES = ['master', 'devel']
Guilhem Saurel's avatar
Guilhem Saurel committed
26
RPKG_URL = 'http://robotpkg.openrobots.org'
Guilhem Saurel's avatar
Guilhem Saurel committed
27
DOC_URL = 'http://projects.laas.fr/gepetto/doc'
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
28
29
30
31
32
33
34
35
36
RPKG_LICENSES = {
    'gnu-lgpl-v3': 'LGPL-3.0',
    'gnu-lgpl-v2': 'LGPL-2.0',
    'mit': 'MIT',
    'gnu-gpl-v3': 'GPL-3.0',
    '2-clause-bsd': 'BSD-2-Clause',
    'eclipse': 'EPL-1.0',
    'modified-bsd': 'BSD-3-Clause'
}
Guilhem Saurel's avatar
Guilhem Saurel committed
37
38
RPKG_FIELDS = ['PKGBASE', 'PKGVERSION', 'MASTER_SITES', 'MASTER_REPOSITORY', 'MAINTAINER', 'COMMENT', 'HOMEPAGE']
CMAKE_FIELDS = {'NAME': 'name', 'DESCRIPTION': 'description', 'URL': 'homepage', 'VERSION': 'version'}
Guilhem Saurel's avatar
Guilhem Saurel committed
39
TRAVIS_STATE = {'created': None, 'passed': True, 'started': None, 'failed': False, 'errored': False, 'canceled': False}
Guilhem Saurel's avatar
Guilhem Saurel committed
40
GITLAB_STATUS = {'failed': False, 'success': True, 'pending': None, 'skipped': None, 'canceled': None, 'running': None}
Guilhem Saurel's avatar
Guilhem Saurel committed
41

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
42
43

class Namespace(NamedModel):
44
    group = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
45
46


Guilhem Saurel's avatar
Guilhem Saurel committed
47
48
49
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
50
51
52
53
54
55
    url = models.URLField(max_length=200)

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


Guilhem Saurel's avatar
Guilhem Saurel committed
56
class Forge(Links, NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
57
58
59
60
61
    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
62
63
64
    def get_absolute_url(self):
        return self.url

Guilhem Saurel's avatar
Guilhem Saurel committed
65
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
66
        logger.debug(f'requesting api {self} {url}, page {page}')
67
68
69
70
71
        try:
            return requests.get(self.api_url() + url, {'page': page}, verify=self.verify, headers=self.headers())
        except requests.exceptions.ConnectionError:
            logger.error(f'requesting api {self} {url}, page {page} - SECOND TRY')
            return requests.get(self.api_url() + url, {'page': page}, verify=self.verify, headers=self.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
72
73
74
75
76
77

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

    def api_list(self, url='', name=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
78
79
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
80
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
81
82
83
84
85
            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
86
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
87
            page = api_next(self.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
88
89

    def headers(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
90
        return {
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
91
92
93
94
95
96
97
98
99
100
101
102
103
104
            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
105
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
106
107

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
108
109
110
111
        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
112
            SOURCES.travis: 'https://api.travis-ci.org',
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
113
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
114

115
116
    def get_namespaces_github(self):
        for namespace in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
117
            for data in self.api_list(f'/orgs/{namespace.slug}/members'):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
118
                Namespace.objects.get_or_create(slug=data['login'], defaults={'name': data['login'], 'group': False})
119

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
120
121
    def get_namespaces_gitlab(self):
        for data in self.api_list('/namespaces'):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
122
123
124
125
126
            Namespace.objects.get_or_create(
                slug=data['path'], defaults={
                    'name': data['name'],
                    'group': data['kind'] == 'group'
                })
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
127
128
129
        for data in self.api_list('/users'):
            Namespace.objects.get_or_create(slug=data['username'], defaults={'name': data['name']})

Guilhem Saurel's avatar
Guilhem Saurel committed
130
131
132
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
133
134
135
    def get_namespaces_travis(self):
        pass

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
136
137
138
    def get_projects(self):
        getattr(self, f'get_namespaces_{self.get_source_display()}')()
        return getattr(self, f'get_projects_{self.get_source_display()}')()
139

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
140
    def get_projects_github(self):
141
        for org in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
142
            for data in self.api_list(f'/orgs/{org.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
143
                update_github(self, org, data)
144
        for user in Namespace.objects.filter(group=False):
Guilhem Saurel's avatar
Guilhem Saurel committed
145
            for data in self.api_list(f'/users/{user.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
146
147
                if Project.objects.filter(name=data['name']).exists():
                    update_github(self, user, data)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
148
149

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
150
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
151
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
152
153

        for orphan in Project.objects.filter(main_namespace=None):
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
154
            repo = orphan.repo_set.filter(forge__source=SOURCES.gitlab).first()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
155
            update_gitlab(self, self.api_data(f'/projects/{repo.forked_from}'))
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
156
157
158
159

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
160
161
162
163
164
165
    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
166

Guilhem Saurel's avatar
Guilhem Saurel committed
167
class Project(Links, NamedModel, TimeStampedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
168
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
169
170
171
172
    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
173
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
174
    version = models.CharField(max_length=20, blank=True, null=True)
175
    updated = models.DateTimeField(blank=True, null=True)
176
177
    tests = models.BooleanField(default=True)
    docs = models.BooleanField(default=True)
178
    debug = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
179
    from_gepetto = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
180

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

Guilhem Saurel's avatar
Guilhem Saurel committed
184
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
185
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
186
187
188
189
190
        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'))

191
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
192
        forge = self.main_forge if self.main_forge else get_default_forge(self)
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
193
194
195
196
197
198
199
200
201
        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
202
        if created:
203
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
204
205
        return repo

Guilhem Saurel's avatar
Guilhem Saurel committed
206
    def update_branches(self, main=True, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
207
208
209
        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
210
        for branch in branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
211
            logger.info(f'update branch {branch}')
Guilhem Saurel's avatar
Guilhem Saurel committed
212
            if branch in MAIN_BRANCHES:
Guilhem Saurel's avatar
Guilhem Saurel committed
213
                instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=self.main_repo())
Guilhem Saurel's avatar
Guilhem Saurel committed
214
            else:
Guilhem Saurel's avatar
Guilhem Saurel committed
215
216
217
                if branch.startswith('remotes/'):
                    branch = branch[8:]
                forge, namespace, name = branch.split('/', maxsplit=2)
Guilhem Saurel's avatar
Guilhem Saurel committed
218
                namespace, _ = Namespace.objects.get_or_create(slug=namespace)
Guilhem Saurel's avatar
Guilhem Saurel committed
219
                forge = Forge.objects.get(slug=forge)
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
220
221
222
223
224
225
226
227
228
                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
Guilhem Saurel committed
229
230
                if created:
                    repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
231
232
                instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=repo)
            if bcreated:
Guilhem Saurel's avatar
Guilhem Saurel committed
233
                instance.update(pull=pull)
234

Guilhem Saurel's avatar
Guilhem Saurel committed
235
    def main_branch(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
236
237
238
239
240
241
        heads = self.git().heads
        if heads:
            for branch in MAIN_BRANCHES:
                if branch in heads:
                    return branch
            return heads[0]
Guilhem Saurel's avatar
Guilhem Saurel committed
242

Guilhem Saurel's avatar
Guilhem Saurel committed
243
244
245
246
247
248
249
250
251
    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():
            search = re.search(f'set\s*\(\s*project_{key}\s+([^)]+)*\)', content, re.I)
            if search:
252
                try:
253
254
255
256
257
                    old = getattr(self, value)
                    new = search.groups()[0].strip(''' \r\n\t'"''')
                    if old != new:
                        setattr(self, value, new)
                        self.save()
258
                except DataError:
259
                    setattr(self, value, old)
260
        for dependency in re.findall(r'ADD_[A-Z]+_DEPENDENCY\s*\(["\']?([^ "\')]+).*["\']?\)', content, re.I):
261
            project = Project.objects.filter(models.Q(slug=dependency) | models.Q(slug=dependency.replace('_', '-')))
262
            if project.exists():
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
263
264
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.cmake:
265
266
                    dependency.cmake = True
                    dependency.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
267

268
    def ros(self):
269
270
        try:
            filename = self.git_path() / 'package.xml'
271
        except TypeError:
272
            return
273
274
275
276
277
278
279
280
281
282
283
284
        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):
            project = Project.objects.filter(models.Q(slug=dependency) | models.Q(slug=dependency.replace('_', '-')))
            if project.exists():
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.ros:
                    dependency.ros = True
                    dependency.save()

285
286
287
288
289
290
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
291
292
293
294
    def update_tags(self):
        for tag in self.git().tags:
            Tag.objects.get_or_create(name=str(tag), project=self)

295
    def update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
296
        self.update_tags()
297
        tag = self.tag_set.filter(name__startswith='v').last()  # TODO: implement SQL ordering for semver
Guilhem Saurel's avatar
Guilhem Saurel committed
298
299
        if tag is not None:
            self.version = tag.name[1:]
300
        robotpkg = self.robotpkg_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
301
        branch = self.branch_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
302
        if (branch is not None and branch.updated is not None) or robotpkg is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
303
304
            if robotpkg is None:
                self.updated = branch.updated
305
            elif branch is None or branch.updated is None:
Guilhem Saurel's avatar
Guilhem Saurel committed
306
307
308
                self.updated = robotpkg.updated
            else:
                self.updated = max(branch.updated, robotpkg.updated)
309
        self.cmake()
Guilhem Saurel's avatar
Guilhem Saurel committed
310
        self.ros()
311
312
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
313
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
314
315
316
317
318
        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
319

320
321
322
323
324
325
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

326
327
328
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
329
330
331
332
333
334
335
336
337
338
339
    def contributors(self, update=False):
        if self.main_branch() is None:
            return []
        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()

340
341
342
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
343
344
345
346
    def doc_coverage_image(self):
        images = Image.objects.filter(robotpkg__project=self, py3=False, target__name='16.04')
        return images.order_by(Length('robotpkg__name').desc()).first()

347
    def print_deps(self):
348
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
349
350

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

Guilhem Saurel's avatar
Guilhem Saurel committed
353
354
355
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
    def url_travis(self):
        return f'https://travis-ci.org/{self.main_namespace.slug}/{self.slug}'

    def url_gitlab(self):
        return f'https://gepgitlab.laas.fr/{self.main_namespace.slug}/{self.slug}'

    def badge(self, link, img, alt):
        return mark_safe(f'<a href="{link}"><img src="{img}" alt="{alt}" /></a> ')

    def badge_travis(self):
        return self.badge(self.url_travis(), f'{self.url_travis()}.svg?branch=master', 'Building Status')

    def badge_gitlab(self):
        return self.badge(self.url_gitlab(), f'{self.url_gitlab()}/badges/master/pipeline.svg', 'Pipeline Status')

    def badge_coverage(self):
        return self.badge(f'{DOC_URL}/{self.main_namespace.slug}/{self.slug}/master/coverage',
Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
373
                          f'{self.url_gitlab()}/badges/master/coverage.svg?job=doc-coverage"', 'Coverage Report')
Guilhem Saurel's avatar
Guilhem Saurel committed
374
375
376
377

    def badges(self):
        return self.badge_travis() + self.badge_gitlab() + self.badge_coverage()

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
378

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
379
380
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
381
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
382
383
384
385
386
387
388
389
390
391
    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
392
    forked_from = models.PositiveIntegerField(blank=True, null=True)
393
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
394
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
395
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
396
397
398

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

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
401
402
403
404
405
        return {
            SOURCES.github: f'{self.forge.api_url()}/repos/{self.namespace.slug}/{self.slug}',
            SOURCES.redmine: f'{self.forge.api_url()}/projects/{self.repo_id}.json',
            SOURCES.gitlab: f'{self.forge.api_url()}/projects/{self.repo_id}',
        }[self.forge.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
406

Guilhem Saurel's avatar
Guilhem Saurel committed
407
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
408
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
409
        try:
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
410
411
            return requests.get(
                self.api_url() + url, {'page': page}, verify=self.forge.verify, headers=self.forge.headers())
412
413
        except requests.exceptions.ConnectionError:
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
414
415
            return requests.get(
                self.api_url() + url, {'page': page}, verify=self.forge.verify, headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
416
417
418
419
420
421

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

    def api_list(self, url='', name=None):
Guilhem Saurel's avatar
Guilhem Saurel committed
422
423
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
424
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
425
426
427
428
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
429
430
431
432
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
433
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
434
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
435

Guilhem Saurel's avatar
Guilhem Saurel committed
436
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
437
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
438
        if data:
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
439
            return getattr(self, f'api_update_{self.forge.get_source_display()}')(data)
Guilhem Saurel's avatar
Guilhem Saurel committed
440
441

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

Guilhem Saurel's avatar
Guilhem Saurel committed
444
    def api_update_github(self, data):
445
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
446

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
447
448
449
450
451
    def get_clone_url(self):
        if self.forge.source == SOURCES.gitlab:
            return self.clone_url.replace('://', f'://gitlab-ci-token:{self.forge.token}@')
        return self.clone_url

452
453
454
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
455
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
456
        git_repo = self.project.git()
457
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
458
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
459
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
460
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
461
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
462
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
463

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
464
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
465
466
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
467
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
468
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
469
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
470
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
471
472
473
474
475
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
476

Guilhem Saurel's avatar
Guilhem Saurel committed
477
478
479
    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
480
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
481
482
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
483
484

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
485
486
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
487

Guilhem Saurel's avatar
Guilhem Saurel committed
488
489
490
491
    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
492
        for pipeline in self.api_list('/pipelines'):
Guilhem Saurel's avatar
Guilhem Saurel committed
493
494
495
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
496
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
497
498
499
500
            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
yapf    
Guilhem Saurel committed
501
502
503
504
505
506
507
508
            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
Guilhem Saurel committed
509
510
511
512

    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
513
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
Guilhem Saurel's avatar
Guilhem Saurel committed
514
515
516
517
518
                if self.project.tag_set.filter(name=build['branch']['name']).exists():
                    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
519
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
520
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
521
522
523
524
525
526
527
528
                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
529
530

    def update(self, pull=True):
531
        ok = True
Guilhem Saurel's avatar
Guilhem Saurel committed
532
533
        self.project.update_tags()
        if pull:
534
535
536
537
538
539
540
            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
541

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
542
543
544
545

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

Guilhem Saurel's avatar
Guilhem Saurel committed
546
547
548
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
549

Guilhem Saurel's avatar
Guilhem Saurel committed
550
551
552
553
554
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)
555
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
556
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
557
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
558
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
559
560

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
561
562
563
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
564
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
565
566

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
567
568
        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
569
570

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

574
575
576
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
577
            remote = self.repo.git()
578
579
580
581
582
            _, _, 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
583
584
585
586
587
588
589
590
591
592
593
594
595
596
        if self.deleted:
            return
        try:
            if pull:
                self.repo.fetch()
                if self.repo != self.project.main_repo():
                    self.project.main_repo().fetch()
            main_branch = self.project.main_branch()
            if main_branch is not None:
                self.ahead = self.get_ahead(main_branch)
                self.behind = self.get_behind(main_branch)
            self.updated = self.git().commit.authored_datetime
        except (git.exc.GitCommandError, IndexError):
            self.deleted = True
Guilhem Saurel's avatar
Guilhem Saurel committed
597
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
598

Guilhem Saurel's avatar
Guilhem Saurel committed
599
600
601
602
603
604
605
    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>')

606
607
608
609
610
611
612
613
    def forge(self):
        if self.repo:
            return self.repo.forge

    def namespace(self):
        if self.repo:
            return self.repo.namespace

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
614

Guilhem Saurel's avatar
Guilhem Saurel committed
615
616
617
618
619
class ActiveQuerySet(models.QuerySet):
    def active(self):
        return self.filter(active=True)


Guilhem Saurel's avatar
Guilhem Saurel committed
620
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
621
622
623
    active = models.BooleanField(default=True)

    objects = ActiveQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
624
625
626


# class Test(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
627
628
629
630
631
632
633
#     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
634

Guilhem Saurel's avatar
Guilhem Saurel committed
635
# class SystemDependency(NamedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
636
637
#     project = models.ForeignKey(Project, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
638
639


Guilhem Saurel's avatar
Guilhem Saurel committed
640
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
641
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
642
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
643

Guilhem Saurel's avatar
Guilhem Saurel committed
644
645
646
647
648
649
    pkgbase = models.CharField(max_length=50, default='')
    pkgversion = models.CharField(max_length=20, default='')
    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()
650
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
651
652

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
653
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
654
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
655
656
657
658
659
660
661
662
663
664
    updated = models.DateTimeField(blank=True, null=True)

    def main_page(self):
        if self.category != 'wip':
            return f'{RPKG_URL}/robotpkg/{self.category}/{self.name}'

    def build_page(self):
        path = '-wip/wip' if self.category == 'wip' else f'/{self.category}'
        return f'{RPKG_URL}/rbulk/robotpkg{path}/{self.name}'

665
    def update_images(self):
666
667
        py3s = [False, True] if self.name.startswith('py-') else [False]
        debugs = [False, True] if self.project.debug else [False]
Guilhem Saurel's avatar
Guilhem Saurel committed
668
        for target in Target.objects.active():
669
670
671
            for py3 in py3s:
                for debug in debugs:
                    Image.objects.get_or_create(robotpkg=self, target=target, py3=py3, debug=debug)[0].update()
Guilhem Saurel's avatar
Guilhem Saurel committed
672

673
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
674
675
676
677
678
679
        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
680
681
682
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
683
684
685
686
687
688
689
690
691
692
693
694
695
        for field in RPKG_FIELDS:
            cmd = ['make', 'show-var', f'VARNAME={field}']
            self.__dict__[field.lower()] = check_output(cmd, cwd=cwd).decode().strip()

        repo_path = self.name if self.category == 'wip' else f'{self.category}/{self.name}'
        last_commit = next(repo.iter_commits(paths=repo_path, max_count=1))
        self.updated = last_commit.authored_datetime

        license = check_output(['make', 'show-var', f'VARNAME=LICENSE'], cwd=cwd).decode().strip()
        if license in RPKG_LICENSES:
            self.license = License.objects.get(spdx_id=RPKG_LICENSES[license])
        else:
            logger.warning(f'Unknown robotpkg license: {license}')
Guilhem Saurel's avatar
Guilhem Saurel committed
696
        self.public = not bool(check_output(['make', 'show-var', f'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
697
698
699
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

700
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
701
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
702

703
    def valid_images(self):
704
        return self.image_set.filter(created__isnull=False, target__active=True).order_by('target__name')
705

706
707
708
709
    def without_py(self):
        if 'py-' in self.name:
            return Robotpkg.objects.filter(name=self.name.replace('py-', '')).first()

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
710

Guilhem Saurel's avatar
Guilhem Saurel committed
711
# class RobotpkgBuild(TimeStampedModel):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
712
713
714
#     robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
#     target = models.ForeignKey(Target, on_delete=models.CASCADE)
#     passed = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
715
716


717
718
class Image(models.Model):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
719
    target = models.ForeignKey(Target, on_delete=models.CASCADE)
720
721
    created = models.DateTimeField(blank=True, null=True)
    image = models.CharField(max_length=12, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
722
    py3 = models.BooleanField(default=False)
723
    debug = models.BooleanField(default=False)
724
725

    class Meta:
726
        unique_together = ('robotpkg', 'target', 'py3', 'debug')
727
728

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
729
730
        py = '-py3' if self.py3 else ''
        return f'{self.robotpkg}{py}:{self.target}'
731
732

    def get_build_args(self):
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
733
        ret = {'TARGET': self.target, 'ROBOTPKG': self.robotpkg, 'REGISTRY': self.robotpkg.project.registry()}
Guilhem Saurel's avatar
Guilhem Saurel committed
734
        if not self.robotpkg.project.public:
Guilhem Saurel's avatar
Guilhem Saurel committed
735
736
737
            ret['IMAGE'] = 'robotpkg-jrl-py3' if self.py3 else 'robotpkg-jrl'
        elif self.py3:
            ret['IMAGE'] = 'robotpkg-py3'
Guilhem Saurel's avatar
Guilhem Saurel committed
738
        return ret
739
740
741

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

744
745
746
    def get_image_url(self):
        project = self.robotpkg.project
        manifest = str(self).replace(':', '/manifests/')
747
        return f'https://{project.registry()}/v2/{project.main_namespace.slug}/{project}/{manifest}'
748

Guilhem Saurel's avatar
Guilhem Saurel committed
749
    def get_job_name(self):
750
751
        mode = 'debug' if self.debug else 'release'
        return f'robotpkg-{self}-{mode}'.replace(':', '-')
Guilhem Saurel's avatar
Guilhem Saurel committed
752

753
754
755
    def build(self):
        args = self.get_build_args()
        build_args = sum((['--build-arg', f'{key}={value}'] for key, value in args.items()), list())
756
757
758
759
760
761
762
        return ['docker', 'build', '-t', self.get_image_name()] + build_args + ['.']

    def pull(self):
        return ['docker', 'pull', self.get_image_name()]

    def push(self):
        return ['docker', 'push', self.get_image_name()]
763

Guilhem Saurel's avatar
Guilhem Saurel committed
764
    def update(self, pull=False):
765
766
767
768
769
        r = requests.get(self.get_image_url())
        if r.status_code == 200:
            self.image = r.json()['fsLayers'][0]['blobSum'].split(':')[1][:12]
            self.created = parse_datetime(json.loads(r.json()['history'][0]['v1Compatibility'])['created'])
            self.save()
770
771


Guilhem Saurel's avatar
Guilhem Saurel committed
772
773
774
775
776
777
778
779
class CIBuild(models.Model):
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
    passed = models.NullBooleanField()
    build_id = models.PositiveIntegerField()
    started = models.DateTimeField()
    branch = models.ForeignKey(Branch, on_delete=models.CASCADE)

    class Meta:
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
780
        ordering = ('started', )
Guilhem Saurel's avatar
Guilhem Saurel committed
781
782
783
784
785
786
787
788
789
790
791
792
793
794

    def url(self):
        if self.repo.forge.source == SOURCES.github:
            return f'https://travis-ci.org/{self.repo.namespace.slug}/{self.repo.slug}/builds/{self.build_id}'
        if self.repo.forge.source == SOURCES.gitlab:
            return f'{self.repo.forge.url}/{self.repo.namespace.slug}/{self.repo.slug}/pipelines/{self.build_id}'


class Tag(models.Model):
    name = models.CharField(max_length=200)
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
    project = models.ForeignKey(Project, on_delete=models.CASCADE)

    class Meta:
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
795
        ordering = ('name', )
Guilhem Saurel's avatar
Guilhem Saurel committed
796
797
        unique_together = ('name', 'project')

Guilhem Saurel's avatar
Guilhem Saurel committed
798
799
800
    def __str__(self):
        return f'{self.project} {self.name}'

Guilhem Saurel's avatar
Guilhem Saurel committed
801

802
803
804
805
806
class GepettistQuerySet(models.QuerySet):
    def gepettist(self):
        return self.filter(projects__from_gepetto=True)


Guilhem Saurel's avatar
Guilhem Saurel committed
807
808
class Contributor(models.Model):
    projects = models.ManyToManyField(Project)
Guilhem Saurel's avatar
Guilhem Saurel committed
809
    agreement_signed = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
810

811
812
    objects = GepettistQuerySet.as_manager()

Guilhem Saurel's avatar
Guilhem Saurel committed
813
814
815
816
817
818
819
820
821
822
823
824
    def __str__(self):
        name = self.contributorname_set.first()
        mail = self.contributormail_set.first()
        return f'{name} <{mail}>'

    def names(self):
        return ', '.join(str(name) for name in self.contributorname_set.all())

    def mails(self):
        return ', '.join(str(mail) for mail in self.contributormail_set.filter(invalid=False))

    def contributed(self):
825
        return ', '.join(str(project) for project in self.projects.filter(from_gepetto=True))
Guilhem Saurel's avatar
Guilhem Saurel committed
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842


class ContributorName(models.Model):
    contributor = models.ForeignKey(Contributor, on_delete=models.CASCADE, blank=True, null=True)
    name = models.CharField(max_length=200, unique=True)

    def __str__(self):
        return self.name


class ContributorMail(models.Model):
    contributor = models.ForeignKey(Contributor, on_delete=models.CASCADE, blank=True, null=True)
    mail = models.EmailField(unique=True)
    invalid = models.BooleanField(default=False)

    def __str__(self):
        return self.mail
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
843
844


Guilhem Saurel's avatar
Guilhem Saurel committed
845
846
847
class Dependency(models.Model):
    project = models.ForeignKey(Project, on_delete=models.CASCADE, related_name='dependencies')
    library = models.ForeignKey(Project, on_delete=models.CASCADE, related_name='rdeps')
848
    robotpkg = models.BooleanField(default=False)  # TODO NYI
Guilhem Saurel's avatar
Guilhem Saurel committed
849
    cmake = models.BooleanField(default=False)
850
    ros = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
851
852
853
854
855
856

    class Meta:
        verbose_name_plural = 'dependencies'
        unique_together = ('project', 'library')

    def __str__(self):
857
        return f'{self.project} depends on {self.library}: {self.robotpkg:d} {self.cmake:d}'
Guilhem Saurel's avatar
Guilhem Saurel committed
858
859


Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
860
861
862
863
864
865
866
867
868
869
870
871
872
def get_default_forge(project):
    for forge in Forge.objects.order_by('source'):
        if project.repo_set.filter(forge=forge).exists():
            logger.info(f'default forge for {project} set to {forge}')
            project.main_forge = forge
            project.save()
            return forge
    else:
        logger.error(f'NO DEFAULT FORGE for {project}')


def update_gitlab(forge, data):
    logger.info(f'update {data["name"]} from {forge}')
Guilhem Saurel's avatar
Guilhem Saurel committed
873
    public = data['visibility'] not in ['private', 'internal']
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
    project, created = Project.objects.get_or_create(
        name=data['name'], defaults={
            'main_forge': forge,
            'public': public
        })
    namespace, _ = Namespace.objects.get_or_create(
        slug=data['namespace']['path'], defaults={'name': data['namespace']['name']})
    repo, _ = Repo.objects.get_or_create(
        forge=forge,
        namespace=namespace,
        project=project,
        defaults={
            'repo_id': data['id'],
            'name': data['name'],
            'url': data['web_url'],
            'default_branch': data['default_branch'],
            'clone_url': data['http_url_to_repo']
        })
892
893
894
895
896
897
898
    repo.name = data['name']
    repo.slug = data['path']
    repo.url = data['web_url']
    repo.repo_id = data['id']
    repo.clone_url = data['http_url_to_repo']
    repo.open_issues = data['open_issues_count']
    repo.default_branch = data['default_branch']
Guilhem Saurel's avatar
Guilhem Saurel committed
899
900
    repo.description = data['description']
    # TODO license (https://gitlab.com/gitlab-org/gitlab-ce/issues/28267), open_pr
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
901
902
903
904
905
    if 'forked_from_project' in data:
        repo.forked_from = data['forked_from_project']['id']
    elif created or project.main_namespace is None:
        project.main_namespace = namespace
        project.save()
906
    repo.save()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
907
908
909
910


def update_github(forge, namespace, data):
    logger.info(f'update {data["name"]} from {forge}')
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
    project, _ = Project.objects.get_or_create(
        name=data['name'], defaults={
            'homepage': data['homepage'],
            'main_namespace': namespace,
            'main_forge': forge
        })
    repo, _ = Repo.objects.get_or_create(
        forge=forge,
        namespace=namespace,
        project=project,
        defaults={
            'repo_id': data['id'],
            'name': data['name'],
            'clone_url': data['clone_url']
        })
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
926
927
928
929
930
    repo.homepage = data['homepage']
    repo.url = data['html_url']
    repo.repo_id = data['id']
    repo.default_branch = data['default_branch']
    repo.open_issues = data['open_issues']
Guilhem Saurel's avatar
Guilhem Saurel committed
931
    repo.description = data['description']
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
932
933
934
935

    repo_data = repo.api_data()
    if repo_data and 'license' in repo_data and repo_data['license']:
        if 'spdx_id' in repo_data['license'] and repo_data['license']['spdx_id']:
936
937
938
939
940
941
942
943
            if repo_data['license']['spdx_id'] != 'NOASSERTION':
                try:
                    license = License.objects.get(spdx_id=repo_data['license']['spdx_id'])
                except License.DoesNotExist:
                    raise ValueError('No License with spdx_id=' + repo_data['license']['spdx_id'])
                repo.license = license
                if not project.license:
                    project.license = license
944
945
        if 'source' in repo_data:
            repo.forked_from = repo_data['source']['id']
946
947
    if repo_data:
        repo.open_issues = repo_data['open_issues_count']
948
    repo.clone_url = data['clone_url']
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
949
950
951
    repo.open_pr = len(list(repo.api_list('/pulls')))
    repo.save()
    project.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
952
953
954
955
956
957
958


def update_travis(namespace, data):
    project = Project.objects.filter(name=data['name']).first()
    if project is None:
        return
    forge = Forge.objects.get(source=SOURCES.github)
Guilhem Saurel's avatar
yapf    
Guilhem Saurel committed
959
960
961
962
963
964
965
966
967
    repo, created = Repo.objects.get_or_create(
        forge=forge,
        namespace=namespace,
        project=project,
        defaults={
            'name': data['name'],
            'repo_id': 0,
            'travis_id': data['id']
        })
Guilhem Saurel's avatar
Guilhem Saurel committed
968
969
970
971
972
    if created:
        repo.api_update()
    else:
        repo.travis_id = data['id']
        repo.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
973
974


Guilhem Saurel's avatar
Guilhem Saurel committed
975
976
977
978
979
980
981
982
983
984
985
986
def merge_contributors(*contributors):
    logger.warning(f'merging {contributors}')
    ids = [contributor.id for contributor in contributors]
    main = min(ids)
    for model in (ContributorName, ContributorMail):
        for instance in model.objects.filter(contributor_id__in=ids):
            instance.contributor_id = main
            instance.save()
    Contributor.objects.filter(id__in=ids).exclude(id=main).delete()
    return Contributor.objects.get(id=main)


Guilhem Saurel's avatar
Guilhem Saurel committed
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
def get_contributor(name, mail):
    cname, name_created = ContributorName.objects.get_or_create(name=name)
    cmail, mail_created = ContributorMail.objects.get_or_create(mail=mail, defaults={'invalid': invalid_mail(mail)})
    if name_created or mail_created:
        if name_created and mail_created:
            contributor = Contributor.objects.create()
            cname.contributor = contributor
            cmail.contributor = contributor
            cname.save()
            cmail.save()
        if mail_created:
            contributor = cname.contributor
            cmail.contributor = contributor
            cmail.save()
        if name_created:
            contributor = cmail.contributor
            cname.contributor = cmail.contributor
            cname.save()
    elif cname.contributor == cmail.contributor or invalid_mail(mail):
        contributor = cname.contributor
    elif cname.contributor is None and cmail.contributor is not None:
        contributor = cmail.contributor
        cname.contributor = contributor
        cname.save()
    elif cmail.contributor is None:
        contributor = cname.contributor
        cmail.contributor = contributor
        cmail.save()
    else:
Guilhem Saurel's avatar
Guilhem Saurel committed
1016
        contributor = merge_contributors(cname.contributor, cmail.contributor)
Guilhem Saurel's avatar
Guilhem Saurel committed
1017
    return contributor