models.py 33.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
8
from django.template.loader import get_template
Guilhem Saurel's avatar
Guilhem Saurel committed
9
10
from django.utils.dateparse import parse_datetime
from django.utils.safestring import mark_safe
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
11

Guilhem Saurel's avatar
Guilhem Saurel committed
12
import git
Guilhem Saurel's avatar
Guilhem Saurel committed
13
import requests
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
14
from autoslug import AutoSlugField
Guilhem Saurel's avatar
Guilhem Saurel committed
15
from ndh.models import Links, NamedModel, TimeStampedModel
16
from ndh.utils import enum_to_choices, query_sum
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
17

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

20
21
logger = logging.getLogger('rainboard.models')

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
31
32

class Namespace(NamedModel):
33
    group = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
34
35


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

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


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

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

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

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

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

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

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
102
103
104
105
106
107
108
    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
109
110
111
    def get_namespaces_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
112
113
114
    def get_namespaces_travis(self):
        pass

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

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

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
129
        for data in self.api_list('/projects'):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
130
            update_gitlab(self, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
131
132

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

    def get_projects_redmine(self):
        pass  # TODO

Guilhem Saurel's avatar
Guilhem Saurel committed
139
140
141
142
143
144
    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
145

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

Guilhem Saurel's avatar
Guilhem Saurel committed
159
160
161
    def git_path(self):
        return settings.RAINBOARD_GITS / self.main_namespace.slug / self.slug

Guilhem Saurel's avatar
Guilhem Saurel committed
162
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
163
        path = self.git_path()
Guilhem Saurel's avatar
Guilhem Saurel committed
164
165
166
167
168
        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'))

169
    def main_repo(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
170
171
        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
172
173
174
                                                   defaults={'name': self.name, 'default_branch': 'master',
                                                             'repo_id': 0})
        if created:
175
            repo.api_update()
Guilhem Saurel's avatar
Guilhem Saurel committed
176
177
        return repo

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

Guilhem Saurel's avatar
Guilhem Saurel committed
201
    def main_branch(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
202
203
204
205
206
207
        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
208

Guilhem Saurel's avatar
Guilhem Saurel committed
209
210
211
212
213
214
215
216
217
218
219
220
    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:
                self.__dict__[value] = search.groups()[0].strip(''' \r\n\t'"''')
                self.save()

221
222
223
224
225
226
    def repos(self):
        return self.repo_set.count()

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

Guilhem Saurel's avatar
Guilhem Saurel committed
227
228
229
230
    def update_tags(self):
        for tag in self.git().tags:
            Tag.objects.get_or_create(name=str(tag), project=self)

231
    def update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
232
        self.update_tags()
233
        tag = self.tag_set.filter(name__startswith='v').last()  # TODO: implement SQL ordering for semver
Guilhem Saurel's avatar
Guilhem Saurel committed
234
235
        if tag is not None:
            self.version = tag.name[1:]
236
        robotpkg = self.robotpkg_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
237
        branch = self.branch_set.order_by('-updated').first()
Guilhem Saurel's avatar
Guilhem Saurel committed
238
        if (branch is not None and branch.updated is not None) or robotpkg is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
239
240
            if robotpkg is None:
                self.updated = branch.updated
241
            elif branch is None or branch.updated is None:
Guilhem Saurel's avatar
Guilhem Saurel committed
242
243
244
                self.updated = robotpkg.updated
            else:
                self.updated = max(branch.updated, robotpkg.updated)
245
246
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
247
    def commits_since(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
248
249
250
251
252
        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
253

254
255
256
257
258
259
    def open_issues(self):
        return query_sum(self.repo_set, 'open_issues')

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

260
261
262
    def gitlabciyml(self):
        return get_template('rainboard/gitlab-ci.yml').render({'project': self})

Guilhem Saurel's avatar
Guilhem Saurel committed
263
264
265
266
267
268
269
270
271
272
273
    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()

274
275
276
    def registry(self):
        return settings.PUBLIC_REGISTRY if self.public else settings.PRIVATE_REGISTRY

277

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
278
279
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
280
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
281
282
283
284
285
286
287
288
289
290
    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
291
    forked_from = models.PositiveIntegerField(blank=True, null=True)
292
    clone_url = models.URLField(max_length=200)
Guilhem Saurel's avatar
travis    
Guilhem Saurel committed
293
    travis_id = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
294
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
295
296
297

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

    def api_url(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
300
301
302
303
304
        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
305

Guilhem Saurel's avatar
Guilhem Saurel committed
306
    def api_req(self, url='', name=None, page=1):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
307
        logger.debug(f'requesting api {self.forge} {self.namespace} {self} {url}, page {page}')
308
309
310
311
312
313
314
        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
315
316
317
318
319
320

    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
321
322
        page = 1
        while page:
Guilhem Saurel's avatar
Guilhem Saurel committed
323
            req = self.api_req(url, name, page)
Guilhem Saurel's avatar
Guilhem Saurel committed
324
325
326
327
            if req.status_code != 200:
                return []  # TODO
            data = req.json()
            if name is not None:
Guilhem Saurel's avatar
Guilhem Saurel committed
328
329
330
331
                if name in data:
                    data = data[name]
                else:
                    return []  # TODO
Guilhem Saurel's avatar
Guilhem Saurel committed
332
            yield from data
Guilhem Saurel's avatar
Guilhem Saurel committed
333
            page = api_next(self.forge.source, req)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
334

Guilhem Saurel's avatar
Guilhem Saurel committed
335
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
336
        data = self.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
337
        if data:
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
338
            return getattr(self, f'api_update_{self.forge.get_source_display()}')(data)
Guilhem Saurel's avatar
Guilhem Saurel committed
339
340

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

Guilhem Saurel's avatar
Guilhem Saurel committed
343
    def api_update_github(self, data):
344
        update_github(self.forge, self.namespace, data)
Guilhem Saurel's avatar
Guilhem Saurel committed
345

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
346
347
348
349
350
    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

351
352
353
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
354
    def git(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
355
        git_repo = self.project.git()
356
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
357
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
358
            return git_repo.remote(remote)
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
359
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
360
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
Guilhem Saurel committed
361
            return git_repo.create_remote(remote, self.get_clone_url())
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
362

Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
363
    def fetch(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
364
365
        git_repo = self.git()
        logger.debug(f'fetching {self.forge} / {self.namespace} / {self.project}')
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
366
        try:
Guilhem Saurel's avatar
Guilhem Saurel committed
367
            git_repo.fetch()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
368
        except git.exc.GitCommandError:
Guilhem Saurel's avatar
Guilhem Saurel committed
369
            logger.warning(f'fetching {self.forge} / {self.namespace} / {self.project} - SECOND TRY')
370
371
372
373
374
            try:
                git_repo.fetch()
            except git.exc.GitCommandError:
                return False
        return True
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
375

Guilhem Saurel's avatar
Guilhem Saurel committed
376
377
378
    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
379
    def ahead(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
380
381
        main_branch = self.main_branch()
        return main_branch.ahead if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
382
383

    def behind(self):
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
384
385
        main_branch = self.main_branch()
        return main_branch.behind if main_branch is not None else 0
Guilhem Saurel's avatar
Guilhem Saurel committed
386

Guilhem Saurel's avatar
Guilhem Saurel committed
387
388
389
390
    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
391
        for pipeline in self.api_list('/pipelines'):
Guilhem Saurel's avatar
Guilhem Saurel committed
392
393
394
            pid, ref = pipeline['id'], pipeline['ref']
            if self.project.tag_set.filter(name=ref).exists():
                continue
Guilhem Saurel's avatar
Guilhem Saurel committed
395
            data = self.api_data(f'/pipelines/{pid}')
Guilhem Saurel's avatar
Guilhem Saurel committed
396
397
398
399
400
401
402
403
404
405
406
407
408
            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
409
            for build in travis.api_list(f'/repo/{self.travis_id}/builds', name='builds'):
Guilhem Saurel's avatar
Guilhem Saurel committed
410
411
412
413
414
                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
415
                    branch.update()
Guilhem Saurel's avatar
Guilhem Saurel committed
416
417
418
419
420
421
422
423
                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):
424
        ok = True
Guilhem Saurel's avatar
Guilhem Saurel committed
425
426
        self.project.update_tags()
        if pull:
427
428
429
430
431
432
433
            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
434

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
435
436
437
438

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

Guilhem Saurel's avatar
Guilhem Saurel committed
439
440
441
    class Meta:
        unique_together = ('project', 'name')

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
442

Guilhem Saurel's avatar
Guilhem Saurel committed
443
444
445
446
447
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)
448
    updated = models.DateTimeField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
449
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
450
    deleted = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
451
    keep_doc = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
452
453

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
454
455
456
457
458
459
        return self.name

    class Meta:
        unique_together = ('project', 'name')

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
460
461
        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
462
463

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

467
468
469
    def git(self):
        git_repo = self.project.git()
        if self.name not in git_repo.branches:
Guilhem Saurel's avatar
Guilhem Saurel committed
470
            remote = self.repo.git()
471
472
473
474
475
            _, _, 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
476
477
478
479
480
481
482
483
484
485
486
487
488
489
        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
490
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
491

Guilhem Saurel's avatar
Guilhem Saurel committed
492
493
494
495
496
497
498
    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>')

499
500
501
502
503
504
505
506
    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
507

Guilhem Saurel's avatar
Guilhem Saurel committed
508
class Target(NamedModel):
509
    python3 = models.CharField(max_length=3, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
510
511
512
513
514
515
516
517


# 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
518
519
520
521
    # TODO: travis vs gitlab-ci ?
    # TODO: deploy binary, doc, coverage, lint


Guilhem Saurel's avatar
Guilhem Saurel committed
522
523
524
# 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
525
526


Guilhem Saurel's avatar
Guilhem Saurel committed
527
class Robotpkg(NamedModel):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
528
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
529
    category = models.CharField(max_length=50)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
530

Guilhem Saurel's avatar
Guilhem Saurel committed
531
532
533
534
535
536
    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()
537
    homepage = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
538
539

    license = models.ForeignKey(License, on_delete=models.SET_NULL, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
540
    public = models.BooleanField(default=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
541
    description = models.TextField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
542
543
544
545
546
547
548
549
550
551
    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}'

552
    def update_images(self):
553
554
        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
555
        for target in Target.objects.all():
556
557
558
            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
559

560
    def update(self, pull=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
561
562
563
564
565
566
        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
567
568
569
        if not cwd.is_dir():
            logger.warning(f'deleted {self}: {self.delete()}')
            return
Guilhem Saurel's avatar
Guilhem Saurel committed
570
571
572
573
574
575
576
577
578
579
580
581
582
        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
583
        self.public = not bool(check_output(['make', 'show-var', f'VARNAME=RESTRICTED'], cwd=cwd).decode().strip())
Guilhem Saurel's avatar
Guilhem Saurel committed
584
585
586
        with (cwd / 'DESCR').open() as f:
            self.description = f.read().strip()

587
        self.update_images()
Guilhem Saurel's avatar
Guilhem Saurel committed
588
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
589

590
591
592
    def valid_images(self):
        return self.image_set.filter(created__isnull=False)

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
593

Guilhem Saurel's avatar
Guilhem Saurel committed
594
595
596
597
# 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
598
599


600
601
class Image(models.Model):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
Guilhem Saurel's avatar
Guilhem Saurel committed
602
    target = models.ForeignKey(Target, on_delete=models.CASCADE)
603
604
    created = models.DateTimeField(blank=True, null=True)
    image = models.CharField(max_length=12, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
605
    py3 = models.BooleanField(default=False)
606
    debug = models.BooleanField(default=False)
607
608

    class Meta:
609
        unique_together = ('robotpkg', 'target', 'py3', 'debug')
610
611

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
612
613
        py = '-py3' if self.py3 else ''
        return f'{self.robotpkg}{py}:{self.target}'
614
615

    def get_build_args(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
616
        ret = {'TARGET': self.target, 'ROBOTPKG': self.robotpkg,
Guilhem Saurel's avatar
Guilhem Saurel committed
617
               'REGISTRY': self.robotpkg.project.registry()}
Guilhem Saurel's avatar
Guilhem Saurel committed
618
        if not self.robotpkg.project.public:
Guilhem Saurel's avatar
Guilhem Saurel committed
619
620
621
            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
622
        return ret
623
624
625

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

628
629
630
    def get_image_url(self):
        project = self.robotpkg.project
        manifest = str(self).replace(':', '/manifests/')
631
        return f'https://{project.registry()}/v2/{project.main_namespace.slug}/{project}/{manifest}'
632

Guilhem Saurel's avatar
Guilhem Saurel committed
633
    def get_job_name(self):
634
635
        mode = 'debug' if self.debug else 'release'
        return f'robotpkg-{self}-{mode}'.replace(':', '-')
Guilhem Saurel's avatar
Guilhem Saurel committed
636

637
638
639
    def build(self):
        args = self.get_build_args()
        build_args = sum((['--build-arg', f'{key}={value}'] for key, value in args.items()), list())
640
641
642
643
644
645
646
        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()]
647

Guilhem Saurel's avatar
Guilhem Saurel committed
648
    def update(self, pull=False):
649
650
651
652
653
        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()
654
655


Guilhem Saurel's avatar
Guilhem Saurel committed
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
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
682
683
684
    def __str__(self):
        return f'{self.project} {self.name}'

Guilhem Saurel's avatar
Guilhem Saurel committed
685
686
687

class Contributor(models.Model):
    projects = models.ManyToManyField(Project)
Guilhem Saurel's avatar
Guilhem Saurel committed
688
    agreement_signed = models.BooleanField(default=False)
Guilhem Saurel's avatar
Guilhem Saurel committed
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719

    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):
        return ', '.join(str(project) for project in self.projects.all())


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
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734


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
735
    public = data['visibility'] not in ['private', 'internal']
Guilhem Saurel's avatar
Guilhem Saurel committed
736
    project, created = Project.objects.get_or_create(name=data['name'],
Guilhem Saurel's avatar
Guilhem Saurel committed
737
                                                     defaults={'main_forge': forge, 'public': public})
Guilhem Saurel's avatar
Guilhem Saurel committed
738
739
    namespace, _ = Namespace.objects.get_or_create(slug=data['namespace']['path'],
                                                   defaults={'name': data['namespace']['name']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
740
    repo, _ = Repo.objects.get_or_create(forge=forge, namespace=namespace, project=project,
741
742
743
744
745
746
747
748
749
750
                                         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
751
752
    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
753
754
755
756
757
    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()
758
    repo.save()
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
759
760
761
762
763
764
765


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,
766
767
                                         defaults={'repo_id': data['id'], 'name': data['name'],
                                                   'clone_url': data['clone_url']})
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
768
769
770
771
772
    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
773
    repo.description = data['description']
Guilhem Saurel's avatar
clean    
Guilhem Saurel committed
774
775
776
777
778
779
780
781

    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
782
783
784
785
        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
786
787
788
    repo.open_pr = len(list(repo.api_list('/pulls')))
    repo.save()
    project.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
789
790
791
792
793
794
795
796
797
798
799
800
801
802


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


Guilhem Saurel's avatar
Guilhem Saurel committed
805
806
807
808
809
810
811
812
813
814
815
816
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
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
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
846
        contributor = merge_contributors(cname.contributor, cmail.contributor)
Guilhem Saurel's avatar
Guilhem Saurel committed
847
    return contributor