models.py 15.8 KB
Newer Older
1
import logging
Guilhem Saurel's avatar
Guilhem Saurel committed
2
import re
3

4
from django.core.exceptions import ObjectDoesNotExist
Guilhem Saurel's avatar
Guilhem Saurel committed
5
from django.conf import settings
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
6
from django.db import models
Guilhem Saurel's avatar
Guilhem Saurel committed
7
from django.urls import reverse
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
8

Guilhem Saurel's avatar
Guilhem Saurel committed
9
import requests
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
10
from autoslug import AutoSlugField
Guilhem Saurel's avatar
Guilhem Saurel committed
11
from ndh.models import Links, NamedModel, TimeStampedModel
Guilhem Saurel's avatar
Guilhem Saurel committed
12
from ndh.utils import enum_to_choices
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
13
import git
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
14

Guilhem Saurel's avatar
Guilhem Saurel committed
15
from .utils import SOURCES, TARGETS, slugify_with_dots
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
16

17
18
logger = logging.getLogger('rainboard.models')

Guilhem Saurel's avatar
Guilhem Saurel committed
19
MAIN_BRANCHES = ['master', 'devel']
Guilhem Saurel's avatar
Guilhem Saurel committed
20
CMAKE_FIELDS = {'name': 'name', 'description': 'description', 'url': 'homepage', 'version': 'version'}
Guilhem Saurel's avatar
Guilhem Saurel committed
21

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
22

Guilhem Saurel's avatar
Guilhem Saurel committed
23
class Article(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
24
    authors = models.ManyToManyField(settings.AUTH_USER_MODEL)
Guilhem Saurel's avatar
Guilhem Saurel committed
25
26
27
28
29
    year = models.PositiveSmallIntegerField()
    url = models.URLField(max_length=200)
    pdf = models.URLField(max_length=200)


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


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

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


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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
52
    def api_data(self, url=''):
53
54
55
        logger.info(f'requesting api {self}{url}')
        req = requests.get(self.api_url() + url, verify=self.verify, headers=self.headers())
        return req.json() if req.status_code == 200 else []
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79

    def headers(self):
        if self.source == SOURCES.github:
            return {'Authorization': f'token {self.token}', 'Accept': 'application/vnd.github.drax-preview+json'}
        if self.source == SOURCES.gitlab:
            return {'Private-Token': self.token}
        if self.source == SOURCES.redmine:
            return {'X-Redmine-API-Key': self.token}

    def api_url(self):
        if self.source == SOURCES.github:
            return 'https://api.github.com'
        if self.source == SOURCES.gitlab:
            return f'{self.url}/api/v4'
        return self.url

    def get_projects(self):  # TODO auto
        if self.source == SOURCES.github:
            return self.get_projects_github()
        if self.source == SOURCES.gitlab:
            return self.get_projects_gitlab()
        if self.source == SOURCES.redmine:
            return self.get_projects_redmine()

80
81
82
83
84
85
    def get_namespaces_github(self):
        for namespace in Namespace.objects.filter(group=True):
            for data in self.api_data(f'/orgs/{namespace.slug}/members'):
                Namespace.objects.get_or_create(slug=data['login'],
                                                defaults={'name': data['login'], 'group': False})

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
86
    def get_projects_github(self):
87
88
89
90
91
92
93
94
95
96
97
98
99
        def update_github(namespace, data):
            project, _ = Project.objects.get_or_create(name=data['name'],
                                                       defaults={'homepage': data['homepage'],
                                                                 'main_namespace': namespace})
            repo, _ = Repo.objects.get_or_create(forge=self, namespace=namespace, project=project,
                                                 defaults={'repo_id': data['id'], 'name': data['name']})
            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']

            repo_data = repo.api_data()
Guilhem Saurel's avatar
Guilhem Saurel committed
100
101
102
103
104
105
            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
106
107
108
109
110
111
112
113
114
115
116
            repo.open_pr = len(repo.api_data('/pulls'))
            repo.save()
            project.save()

        self.get_namespaces_github()
        for org in Namespace.objects.filter(group=True):
            for data in self.api_data(f'/orgs/{org.slug}/repos'):
                update_github(org, data)
        for user in Namespace.objects.filter(group=False):
            for data in self.api_data(f'/users/{user.slug}/repos'):
                if not Project.objects.filter(name=data['name']).exists():
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
117
                    continue
118
119
120
121
122
123
                update_github(user, data)

    def get_namespaces_gitlab(self):
        for data in self.api_data('/namespaces'):
            Namespace.objects.get_or_create(slug=data['path'],
                                            defaults={'name': data['name'], 'group': data['kind'] == 'group'})
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
124
125

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
126
        def update_gitlab(data):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
127
128
129
130
131
            project, created = Project.objects.get_or_create(name=data['name'])
            namespace, _ = Namespace.objects.get_or_create(name=data['namespace']['name'])
            repo, _ = Repo.objects.get_or_create(forge=self, namespace=namespace, project=project,
                                                 defaults={'repo_id': data['id'], 'name': data['name'],
                                                           'url': data['web_url']})
Guilhem Saurel's avatar
Guilhem Saurel committed
132
133
134
135
136
137
138
            if 'forked_from_project' in data:
                repo.forked_from = data['forked_from_project']['id']
                repo.save()
            elif created or project.main_namespace is None:
                project.main_namespace = namespace
                project.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
139
140
        self.get_namespaces_gitlab()

141
        for data in self.api_data('/projects'):
Guilhem Saurel's avatar
Guilhem Saurel committed
142
143
144
            update_gitlab(data)

        for orphan in Project.objects.filter(main_namespace=None):
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
145
            repo = orphan.repo_set.filter(forge__source=SOURCES.gitlab).first()
Guilhem Saurel's avatar
Guilhem Saurel committed
146
            update_gitlab(self.api_data(f'/projects/{repo.forked_from}'))
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
147
148
149
150
151

    def get_projects_redmine(self):
        pass  # TODO


Guilhem Saurel's avatar
Guilhem Saurel committed
152
153
154
155
156
157
158
class Project(Links, NamedModel, TimeStampedModel):
    private = models.BooleanField(default=False)
    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)
    articles = models.ManyToManyField(Article)
Guilhem Saurel's avatar
Guilhem Saurel committed
159
160
    description = models.TextField()
    version = models.CharField(max_length=20, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
161
162
163
164
165
    # TODO: release github ↔ robotpkg

    def get_absolute_url(self):
        return reverse('rainboard:project', kwargs={'slug': self.slug})

Guilhem Saurel's avatar
Guilhem Saurel committed
166
167
168
    def git_path(self):
        return settings.RAINBOARD_GITS / self.main_namespace.slug / self.slug

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

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

    def update_branches(self, main=True):
Guilhem Saurel's avatar
Guilhem Saurel committed
185
186
187
        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
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
        for branch in branches:
            if branch in MAIN_BRANCHES:
                instance, created = Branch.objects.get_or_create(name=branch, project=self)
                if created:
                    instance.update_ab()
            else:
                name = '/'.join(branch.split('/')[1:])
                forge, namespace = name.split('/')[:2]
                repo, created = Repo.objects.get_or_create(forge__slug=forge, namespace__slug=namespace, project=self,
                                                   defaults={'name': self.name, 'default_branch': 'master',
                                                             'repo_id': 0})
                if created:
                    repo.api_update()
                instance, created = Branch.objects.get_or_create(name=name, project=self)
                if created:
                    instance.update_ab()
204

Guilhem Saurel's avatar
Guilhem Saurel committed
205
206
207
    def main_branch(self):
        return 'devel' if 'devel' in self.git().heads else 'master'

Guilhem Saurel's avatar
Guilhem Saurel committed
208
209
210
211
212
213
214
215
216
217
218
219
    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()

Guilhem Saurel's avatar
Guilhem Saurel committed
220

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
221
222
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
223
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
224
225
226
227
228
229
230
231
232
233
    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
234
    forked_from = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
235
    clone_url = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
236
237
238
239
240
241
242
    # TODO gitlab:
    # description = models.TextField()
    # created_at = models.DateTimeField()
    # last_activity_at = models.DateTimeField()

    def __str__(self):
        return self.name
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
243
244
245
246
247
248

    def api_url(self):
        if self.forge.source == SOURCES.github:
            return f'{self.forge.api_url()}/repos/{self.namespace.slug}/{self.slug}'
        if self.forge.source == SOURCES.redmine:
            return f'{self.forge.api_url()}/projects/{self.repo_id}.json'
Guilhem Saurel's avatar
Guilhem Saurel committed
249
250
        if self.forge.source == SOURCES.gitlab:
            return f'{self.forge.api_url()}/projects/{self.repo_id}'
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
251
252

    def api_data(self, url=''):
Guilhem Saurel's avatar
Guilhem Saurel committed
253
254
255
        logger.info(f'requesting api {self.forge} {self.namespace} {self} {url}')
        req = requests.get(self.api_url() + url, verify=self.forge.verify, headers=self.forge.headers())
        return req.json() if req.status_code == 200 else []
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
256

Guilhem Saurel's avatar
Guilhem Saurel committed
257
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
258
259
260
261
262
263
        data = self.api_data()
        if data:
            if self.forge.source == SOURCES.gitlab:
                return self.api_update_gitlab(data)
            if self.forge.source == SOURCES.github:
                return self.api_update_github(data)
Guilhem Saurel's avatar
Guilhem Saurel committed
264
265
266
267
268
269
270
271
272
273

    def api_update_gitlab(self, data):
        # TODO Missing: license, homepage, open_pr
        self.name = data['name']
        self.slug = data['path']
        self.url = data['web_url']
        self.open_issues = data['open_issues_count']
        self.default_branch = data['default_branch']
        if 'forked_from_project' in data:
            self.forked_from = data['forked_from_project']['id']
Guilhem Saurel's avatar
Guilhem Saurel committed
274
        self.clone_url = data['http_url_to_repo']
Guilhem Saurel's avatar
Guilhem Saurel committed
275
276
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
277
278
279
280
281
282
283
284
285
286
287
288
    def api_update_github(self, data):
        # TODO Missing: open_pr
        self.name = data['name']
        if data['license'] is not None:
            self.license = License.objects.filter(spdx_id=data['license']['spdx_id']).first()
        self.homepage = data['homepage']
        self.url = data['url']
        self.default_branch = data['default_branch']
        self.open_issues = data['open_issues_count']
        self.repo_id = data['id']
        if 'source' in data:
            self.forked_from = data['source']['id']
Guilhem Saurel's avatar
Guilhem Saurel committed
289
290
        self.clone_url = data['clone_url']
        self.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
291

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
292
293
294
295
296
    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

297
298
299
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
300
301
    def git(self):
        git = self.project.git()
302
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
303
304
305
        try:
            return git.remote(remote)
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
306
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
307
308
            return git.create_remote(remote, self.get_clone_url())

Guilhem Saurel's avatar
Guilhem Saurel committed
309
310
311
312
313
314
315
316
317
318
319
320
321
    def main_branch(self):
        return self.project.branch_set.get(name=f'{self.git_remote()}/{self.default_branch}')

    def diff(self):
        branch = self.main_branch()
        if branch.ahead and branch.behind:
            return f'+{branch.ahead} / -{branch.behind}'
        if branch.ahead:
            return f'+{branch.ahead}'
        if branch.behind:
            return f'-{branch.behind}'
        return ''

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
322
323
324
325
326

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


Guilhem Saurel's avatar
Guilhem Saurel committed
327
328
329
330
331
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)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
332
333

    def __str__(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
334
335
336
337
338
339
        return self.name

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

    def get_ahead(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
340
        return len(self.project.git().git.rev_list(f'{branch}..{self}').split('\n'))
Guilhem Saurel's avatar
Guilhem Saurel committed
341
342

    def get_behind(self, branch='master'):
Guilhem Saurel's avatar
Guilhem Saurel committed
343
        return len(self.project.git().git.rev_list(f'{self}..{branch}').split('\n'))
Guilhem Saurel's avatar
Guilhem Saurel committed
344
345
346
347
348
349

    def update_ab(self):
        self.project.main_repo().git().fetch()
        if self.name not in MAIN_BRANCHES:
            forge, namespace = self.name.split('/')[:2]
            Repo.objects.get(forge__slug=forge, namespace__slug=namespace, project=self.project).git().fetch()
Guilhem Saurel's avatar
Guilhem Saurel committed
350
        main_branch = self.project.main_branch()
Guilhem Saurel's avatar
Guilhem Saurel committed
351
352
353
        self.ahead = self.get_ahead(main_branch)
        self.behind = self.get_behind(main_branch)
        self.save()
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390


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.PositiveSmallIntegerField(choices=enum_to_choices(TARGETS))
    passed = models.BooleanField(default=False)
    # TODO: travis vs gitlab-ci ?
    # TODO: deploy binary, doc, coverage, lint


class SystemDependency(NamedModel):
    project = models.ForeignKey(Project, on_delete=models.CASCADE)
    target = models.PositiveSmallIntegerField(choices=enum_to_choices(TARGETS))


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


class Robotpkg(NamedModel):
    project = models.OneToOneField(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)


class RobotpkgBuild(TimeStampedModel):
    robotpkg = models.ForeignKey(Robotpkg, on_delete=models.CASCADE)
    target = models.PositiveSmallIntegerField(choices=enum_to_choices(TARGETS))
    passed = models.BooleanField(default=False)


# TODO: later
# class Dockerfile(NamedModel, TimeStampedModel):
    # project = models.ForeignKey(Project, on_delete=models.CASCADE)
    # target = models.PositiveSmallIntegerField(choices=enum_to_choices(TARGETS))