models.py 37.8 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 git
Guilhem Saurel's avatar
Guilhem Saurel committed
15
import requests
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
16
from autoslug import AutoSlugField
Guilhem Saurel's avatar
Guilhem Saurel committed
17
from ndh.models import Links, NamedModel, TimeStampedModel
18
from ndh.utils import enum_to_choices, query_sum
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
19

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

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

Guilhem Saurel's avatar
Guilhem Saurel committed
24
MAIN_BRANCHES = ['master', 'devel']
Guilhem Saurel's avatar
Guilhem Saurel committed
25
RPKG_URL = 'http://robotpkg.openrobots.org'
Guilhem Saurel's avatar
Guilhem Saurel committed
26
DOC_URL = 'http://projects.laas.fr/gepetto/doc'
Guilhem Saurel's avatar
Guilhem Saurel committed
27
RPKG_LICENSES = {'gnu-lgpl-v3': 'LGPL-3.0', 'gnu-lgpl-v2': 'LGPL-2.0', 'mit': 'MIT', 'gnu-gpl-v3': 'GPL-3.0',
28
                 '2-clause-bsd': 'BSD-2-Clause', 'eclipse': 'EPL-1.0', 'modified-bsd': 'BSD-3-Clause'}
Guilhem Saurel's avatar
Guilhem Saurel committed
29
30
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
31
TRAVIS_STATE = {'created': None, 'passed': True, 'started': None, 'failed': False, 'errored': False, 'canceled': False}
Guilhem Saurel's avatar
Guilhem Saurel committed
32
GITLAB_STATUS = {'failed': False, 'success': True, 'pending': None, 'skipped': None, 'canceled': None, 'running': None}
Guilhem Saurel's avatar
Guilhem Saurel committed
33

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
34
35

class Namespace(NamedModel):
36
    group = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
37
38


Guilhem Saurel's avatar
Guilhem Saurel committed
39
40
41
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
42
43
44
45
46
47
    url = models.URLField(max_length=200)

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


Guilhem Saurel's avatar
Guilhem Saurel committed
48
class Forge(Links, NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
49
50
51
52
53
    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
54
55
56
    def get_absolute_url(self):
        return self.url

Guilhem Saurel's avatar
Guilhem Saurel committed
57
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
58
        logger.debug(f'requesting api {self} {url}, page {page}')
59
60
61
62
63
        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
64
65
66
67
68
69

    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
70
71
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
72
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
73
74
75
76
77
            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
78
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
79
            page = api_next(self.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
80
81

    def headers(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
82
83
84
85
86
        return {
            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},
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
87
88
            SOURCES.travis: {'Authorization': f'token {self.token}',
                             'TRAVIS-API-Version': '3'},
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
89
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
90
91

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
92
93
94
95
        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
96
            SOURCES.travis: 'https://api.travis-ci.org',
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
97
        }[self.source]
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
98

99
100
    def get_namespaces_github(self):
        for namespace in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
101
            for data in self.api_list(f'/orgs/{namespace.slug}/members'):
102
103
104
                Namespace.objects.get_or_create(slug=data['login'],
                                                defaults={'name': data['login'], 'group': False})

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
105
106
107
108
109
110
111
    def get_namespaces_gitlab(self):
        for data in self.api_list('/namespaces'):
            Namespace.objects.get_or_create(slug=data['path'],
                                            defaults={'name': data['name'], 'group': data['kind'] == 'group'})
        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
112
113
114
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
115
116
117
    def get_namespaces_travis(self):
        pass

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
118
119
120
    def get_projects(self):
        getattr(self, f'get_namespaces_{self.get_source_display()}')()
        return getattr(self, f'get_projects_{self.get_source_display()}')()
121

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
122
    def get_projects_github(self):
123
        for org in Namespace.objects.filter(group=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
124
            for data in self.api_list(f'/orgs/{org.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
125
                update_github(self, org, data)
126
        for user in Namespace.objects.filter(group=False):
Guilhem Saurel's avatar
Guilhem Saurel committed
127
            for data in self.api_list(f'/users/{user.slug}/repos'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
128
129
                if Project.objects.filter(name=data['name']).exists():
                    update_github(self, user, data)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
130
131

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
132
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
133
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
134
135

        for orphan in Project.objects.filter(main_namespace=None):
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
136
            repo = orphan.repo_set.filter(forge__source=SOURCES.gitlab).first()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
137
            update_gitlab(self, self.api_data(f'/projects/{repo.forked_from}'))
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
138
139
140
141

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
142
143
144
145
146
147
    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
148

Guilhem Saurel's avatar
Guilhem Saurel committed
149
class Project(Links, NamedModel, TimeStampedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
150
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
151
152
153
154
    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
155
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
156
    version = models.CharField(max_length=20, blank=True, null=True)
157
    updated = models.DateTimeField(blank=True, null=True)
158
159
    tests = models.BooleanField(default=True)
    docs = models.BooleanField(default=True)
160
    debug = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
161
    from_gepetto = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
162

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

Guilhem Saurel's avatar
Guilhem Saurel committed
166
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
167
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
168
169
170
171
172
        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'))

173
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
174
175
        forge = self.main_forge if self.main_forge else get_default_forge(self)
        repo, created = Repo.objects.get_or_create(forge=forge, namespace=self.main_namespace, project=self,
Guilhem Saurel's avatar
Guilhem Saurel committed
176
177
178
                                                   defaults={'name': self.name, 'default_branch': 'master',
                                                             'repo_id': 0})
        if created:
179
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
180
181
        return repo

Guilhem Saurel's avatar
Guilhem Saurel committed
182
    def update_branches(self, main=True, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
183
184
185
        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
186
        for branch in branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
187
            logger.info(f'update branch {branch}')
Guilhem Saurel's avatar
Guilhem Saurel committed
188
            if branch in MAIN_BRANCHES:
Guilhem Saurel's avatar
Guilhem Saurel committed
189
                instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=self.main_repo())
Guilhem Saurel's avatar
Guilhem Saurel committed
190
            else:
Guilhem Saurel's avatar
Guilhem Saurel committed
191
192
193
                if branch.startswith('remotes/'):
                    branch = branch[8:]
                forge, namespace, name = branch.split('/', maxsplit=2)
Guilhem Saurel's avatar
Guilhem Saurel committed
194
                namespace, _ = Namespace.objects.get_or_create(slug=namespace)
Guilhem Saurel's avatar
Guilhem Saurel committed
195
196
                forge = Forge.objects.get(slug=forge)
                repo, created = Repo.objects.get_or_create(forge=forge, namespace=namespace, project=self,
Guilhem Saurel's avatar
Guilhem Saurel committed
197
198
                                                           defaults={'name': self.name, 'default_branch': 'master',
                                                                     'repo_id': 0})
Guilhem Saurel's avatar
Guilhem Saurel committed
199
200
                if created:
                    repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
201
202
                instance, bcreated = Branch.objects.get_or_create(name=branch, project=self, repo=repo)
            if bcreated:
Guilhem Saurel's avatar
Guilhem Saurel committed
203
                instance.update(pull=pull)
204

Guilhem Saurel's avatar
Guilhem Saurel committed
205
    def main_branch(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
206
207
208
209
210
211
        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
212

Guilhem Saurel's avatar
Guilhem Saurel committed
213
214
215
216
217
218
219
220
221
    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:
222
                try:
223
                    old = self.__dict__[value]
224
225
226
                    self.__dict__[value] = search.groups()[0].strip(''' \r\n\t'"''')
                    self.save()
                except DataError:
227
                    self.__dict__[value] = old
228
        for dependency in re.findall(r'ADD_[A-Z]+_DEPENDENCY\s*\(["\']?([^ "\')]+).*["\']?\)', content, re.I):
229
            project = Project.objects.filter(models.Q(slug=dependency) | models.Q(slug=dependency.replace('_', '-')))
230
            if project.exists():
Guilhem Saurel's avatar
oops    
Guilhem Saurel committed
231
232
                dependency, _ = Dependency.objects.get_or_create(project=self, library=project.first())
                if not dependency.cmake:
233
234
                    dependency.cmake = True
                    dependency.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
235

236
    def ros(self):
237
238
        try:
            filename = self.git_path() / 'package.xml'
239
        except TypeError:
240
            return
241
242
243
244
245
246
247
248
249
250
251
252
        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()

253
254
255
256
257
258
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
259
260
261
262
    def update_tags(self):
        for tag in self.git().tags:
            Tag.objects.get_or_create(name=str(tag), project=self)

263
    def update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
264
        self.update_tags()
265
        tag = self.tag_set.filter(name__startswith='v').last()  # TODO: implement SQL ordering for semver
Guilhem Saurel's avatar
Guilhem Saurel committed
266
267
        if tag is not None:
            self.version = tag.name[1:]
268
        robotpkg = self.robotpkg_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
269
        branch = self.branch_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
270
        if (branch is not None and branch.updated is not None) or robotpkg is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
271
272
            if robotpkg is None:
                self.updated = branch.updated
273
            elif branch is None or branch.updated is None:
Guilhem Saurel's avatar
Guilhem Saurel committed
274
275
276
                self.updated = robotpkg.updated
            else:
                self.updated = max(branch.updated, robotpkg.updated)
277
        self.cmake()
Guilhem Saurel's avatar
Guilhem Saurel committed
278
        self.ros()
279
280
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
281
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
282
283
284
285
286
        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
287

288
289
290
291
292
293
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

294
295
296
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
297
298
299
300
301
302
303
304
305
306
307
    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()

308
309
310
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

Guilhem Saurel's avatar
Guilhem Saurel committed
311
312
313
314
    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()

315
    def print_deps(self):
316
        return mark_safe(', '.join(d.library.get_link() for d in self.dependencies.all()))
317
318

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

Guilhem Saurel's avatar
Guilhem Saurel committed
321
322
323
    def ordered_robotpkg(self):
        return self.robotpkg_set.order_by('name')

Guilhem Saurel's avatar
Guilhem Saurel committed
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
    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
341
                          f'{self.url_gitlab()}/badges/master/coverage.svg?job=doc-coverage"', 'Coverage Report')
Guilhem Saurel's avatar
Guilhem Saurel committed
342
343
344
345

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

Guilhem Saurel's avatar
flake8    
Guilhem Saurel committed
346

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
347
348
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
349
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
350
351
352
353
354
355
356
357
358
359
    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
360
    forked_from = models.PositiveIntegerField(blank=True, null=True)
361
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
362
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
363
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
364
365
366

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

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
369
370
371
372
373
        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
374

Guilhem Saurel's avatar
Guilhem Saurel committed
375
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
376
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
377
378
379
380
381
382
383
        try:
            return requests.get(self.api_url() + url, {'page': page}, verify=self.forge.verify,
                                headers=self.forge.headers())
        except requests.exceptions.ConnectionError:
            logger.error(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page} - SECOND TRY')
            return requests.get(self.api_url() + url, {'page': page}, verify=self.forge.verify,
                                headers=self.forge.headers())
Guilhem Saurel's avatar
Guilhem Saurel committed
384
385
386
387
388
389

    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
390
391
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
392
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
393
394
395
396
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
397
398
399
400
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
401
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
402
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
403

Guilhem Saurel's avatar
Guilhem Saurel committed
404
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
405
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
406
        if data:
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
407
            return getattr(self, f'api_update_{self.forge.get_source_display()}')(data)
Guilhem Saurel's avatar
Guilhem Saurel committed
408
409

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

Guilhem Saurel's avatar
Guilhem Saurel committed
412
    def api_update_github(self, data):
413
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
414

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
415
416
417
418
419
    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

420
421
422
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
423
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
424
        git_repo = self.project.git()
425
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
426
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
427
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
428
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
429
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
430
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
431

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
432
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
433
434
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
435
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
436
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
437
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
438
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
439
440
441
442
443
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
444

Guilhem Saurel's avatar
Guilhem Saurel committed
445
446
447
    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
448
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
449
450
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
451
452

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
453
454
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
455

Guilhem Saurel's avatar
Guilhem Saurel committed
456
457
458
459
    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
460
        for pipeline in self.api_list('/pipelines'):
Guilhem Saurel's avatar
Guilhem Saurel committed
461
462
463
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
464
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
465
466
467
468
469
470
471
472
473
474
475
476
477
            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()
            CIBuild.objects.get_or_create(repo=self, build_id=pid, defaults={
                'passed': GITLAB_STATUS[pipeline['status']],
                'started': parse_datetime(data['created_at']),
                'branch': branch,
            })

    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
478
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
Guilhem Saurel's avatar
Guilhem Saurel committed
479
480
481
482
483
                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
484
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
485
486
487
488
489
490
491
492
                started = build['started_at'] if build['started_at'] is not None else build['finished_at']
                CIBuild.objects.get_or_create(repo=self, build_id=build['id'], defaults={
                    'passed': TRAVIS_STATE[build['state']],
                    'started': parse_datetime(started),
                    'branch': branch,
                })

    def update(self, pull=True):
493
        ok = True
Guilhem Saurel's avatar
Guilhem Saurel committed
494
495
        self.project.update_tags()
        if pull:
496
497
498
499
500
501
502
            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
503

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
504
505
506
507

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

Guilhem Saurel's avatar
Guilhem Saurel committed
508
509
510
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
511

Guilhem Saurel's avatar
Guilhem Saurel committed
512
513
514
515
516
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)
517
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
518
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
519
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
520
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
521
522

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
523
524
525
        return self.name

    class Meta:
Guilhem Saurel's avatar
Guilhem Saurel committed
526
        unique_together = ('project', 'name', 'repo')
Guilhem Saurel's avatar
Guilhem Saurel committed
527
528

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
529
530
        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
531
532

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

536
537
538
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
539
            remote = self.repo.git()
540
541
542
543
544
            _, _, 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
545
546
547
548
549
550
551
552
553
554
555
556
557
558
        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
559
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
560

Guilhem Saurel's avatar
Guilhem Saurel committed
561
562
563
564
565
566
567
    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>')

568
569
570
571
572
573
574
575
    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
576

Guilhem Saurel's avatar
Guilhem Saurel committed
577
578
579
580
581
class ActiveQuerySet(models.QuerySet):
    def active(self):
        return self.filter(active=True)


Guilhem Saurel's avatar
Guilhem Saurel committed
582
class Target(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
583
584
585
    active = models.BooleanField(default=True)

    objects = ActiveQuerySet.as_manager()
Guilhem Saurel's avatar
Guilhem Saurel committed
586
587
588
589
590
591
592
593


# class Test(TimeStampedModel):
    # 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)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
594
595
596
597
    # TODO: travis vs gitlab-ci ?
    # TODO: deploy binary, doc, coverage, lint


Guilhem Saurel's avatar
Guilhem Saurel committed
598
599
600
# class SystemDependency(NamedModel):
    # project = models.ForeignKey(Project, on_delete=models.CASCADE)
    # target = models.ForeignKey(Target, on_delete=models.CASCADE)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
601
602


Guilhem Saurel's avatar
Guilhem Saurel committed
603
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
604
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
605
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
606

Guilhem Saurel's avatar
Guilhem Saurel committed
607
608
609
610
611
612
    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()
613
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
614
615

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
616
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
617
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
618
619
620
621
622
623
624
625
626
627
    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}'

628
    def update_images(self):
629
630
        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
631
        for target in Target.objects.active():
632
633
634
            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
635

636
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
637
638
639
640
641
642
        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
643
644
645
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
646
647
648
649
650
651
652
653
654
655
656
657
658
        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
659
        self.public = not bool(check_output(['make', 'show-var', f'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
660
661
662
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

663
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
664
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
665

666
    def valid_images(self):
667
        return self.image_set.filter(created__isnull=False, target__active=True).order_by('target__name')
668

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
669

Guilhem Saurel's avatar
Guilhem Saurel committed
670
671
672
673
# class RobotpkgBuild(TimeStampedModel):
    # 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
674
675


676
677
class Image(models.Model):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
678
    target = models.ForeignKey(Target, on_delete=models.CASCADE)
679
680
    created = models.DateTimeField(blank=True, null=True)
    image = models.CharField(max_length=12, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
681
    py3 = models.BooleanField(default=False)
682
    debug = models.BooleanField(default=False)
683
684

    class Meta:
685
        unique_together = ('robotpkg', 'target', 'py3', 'debug')
686
687

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
688
689
        py = '-py3' if self.py3 else ''
        return f'{self.robotpkg}{py}:{self.target}'
690
691

    def get_build_args(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
692
        ret = {'TARGET': self.target, 'ROBOTPKG': self.robotpkg,
Guilhem Saurel's avatar
Guilhem Saurel committed
693
               'REGISTRY': self.robotpkg.project.registry()}
Guilhem Saurel's avatar
Guilhem Saurel committed
694
        if not self.robotpkg.project.public:
Guilhem Saurel's avatar
Guilhem Saurel committed
695
696
697
            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
698
        return ret
699
700
701

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

704
705
706
    def get_image_url(self):
        project = self.robotpkg.project
        manifest = str(self).replace(':', '/manifests/')
707
        return f'https://{project.registry()}/v2/{project.main_namespace.slug}/{project}/{manifest}'
708

Guilhem Saurel's avatar
Guilhem Saurel committed
709
    def get_job_name(self):
710
711
        mode = 'debug' if self.debug else 'release'
        return f'robotpkg-{self}-{mode}'.replace(':', '-')
Guilhem Saurel's avatar
Guilhem Saurel committed
712

713
714
715
    def build(self):
        args = self.get_build_args()
        build_args = sum((['--build-arg', f'{key}={value}'] for key, value in args.items()), list())
716
717
718
719
720
721
722
        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()]
723

Guilhem Saurel's avatar
Guilhem Saurel committed
724
    def update(self, pull=False):
725
726
727
728
729
        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()
730
731


Guilhem Saurel's avatar
Guilhem Saurel committed
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
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:
        ordering = ('started',)

    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:
        ordering = ('name',)
        unique_together = ('name', 'project')

Guilhem Saurel's avatar
Guilhem Saurel committed
758
759
760
    def __str__(self):
        return f'{self.project} {self.name}'

Guilhem Saurel's avatar
Guilhem Saurel committed
761

762
763
764
765
766
class GepettistQuerySet(models.QuerySet):
    def gepettist(self):
        return self.filter(projects__from_gepetto=True)


Guilhem Saurel's avatar
Guilhem Saurel committed
767
768
class Contributor(models.Model):
    projects = models.ManyToManyField(Project)
Guilhem Saurel's avatar
Guilhem Saurel committed
769
    agreement_signed = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
770

771
772
    objects = GepettistQuerySet.as_manager()

Guilhem Saurel's avatar
Guilhem Saurel committed
773
774
775
776
777
778
779
780
781
782
783
784
    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):
785
        return ', '.join(str(project) for project in self.projects.filter(from_gepetto=True))
Guilhem Saurel's avatar
Guilhem Saurel committed
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802


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
803
804


Guilhem Saurel's avatar
Guilhem Saurel committed
805
806
807
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')
808
    robotpkg = models.BooleanField(default=False)  # TODO NYI
Guilhem Saurel's avatar
Guilhem Saurel committed
809
    cmake = models.BooleanField(default=False)
810
    ros = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
811
812
813
814
815
816

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

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


Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
820
821
822
823
824
825
826
827
828
829
830
831
832
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
833
    public = data['visibility'] not in ['private', 'internal']
Guilhem Saurel's avatar
Guilhem Saurel committed
834
    project, created = Project.objects.get_or_create(name=data['name'],
Guilhem Saurel's avatar
Guilhem Saurel committed
835
                                                     defaults={'main_forge': forge, 'public': public})
Guilhem Saurel's avatar
Guilhem Saurel committed
836
837
    namespace, _ = Namespace.objects.get_or_create(slug=data['namespace']['path'],
                                                   defaults={'name': data['namespace']['name']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
838
    repo, _ = Repo.objects.get_or_create(forge=forge, namespace=namespace, project=project,
839
840
841
842
843
844
845
846
847
848
                                         defaults={'repo_id': data['id'], 'name': data['name'], 'url': data['web_url'],
                                                   'default_branch': data['default_branch'],
                                                   'clone_url': data['http_url_to_repo']})
    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
849
850
    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
851
852
853
854
855
    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()
856
    repo.save()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
857
858
859
860
861
862
863


def update_github(forge, namespace, data):
    logger.info(f'update {data["name"]} from {forge}')
    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,
864
865
                                         defaults={'repo_id': data['id'], 'name': data['name'],
                                                   'clone_url': data['clone_url']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
866
867
868
869
870
    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
871
    repo.description = data['description']
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
872
873
874
875
876
877
878
879

    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']:
            license = License.objects.get(spdx_id=repo_data['license']['spdx_id'])
            repo.license = license
            if not project.license:
                project.license = license
880
881
882
883
        if 'source' in repo_data:
            repo.forked_from = repo_data['source']['id']
    repo.open_issues = repo_data['open_issues_count']
    repo.clone_url = data['clone_url']
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
884
885
886
    repo.open_pr = len(list(repo.api_list('/pulls')))
    repo.save()
    project.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
887
888
889
890
891
892
893
894
895
896
897
898
899
900


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)
    repo, created = Repo.objects.get_or_create(forge=forge, namespace=namespace, project=project,
                                               defaults={'name': data['name'], 'repo_id': 0, 'travis_id': data['id']})
    if created:
        repo.api_update()
    else:
        repo.travis_id = data['id']
        repo.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
901
902


Guilhem Saurel's avatar
Guilhem Saurel committed
903
904
905
906
907
908
909
910
911
912
913
914
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
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
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
944
        contributor = merge_contributors(cname.contributor, cmail.contributor)
Guilhem Saurel's avatar
Guilhem Saurel committed
945
    return contributor