models.py 12.6 KB
Newer Older
1
2
import logging

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

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

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

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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
18

Guilhem Saurel's avatar
Guilhem Saurel committed
19
class Article(NamedModel):
Guilhem Saurel's avatar
Guilhem Saurel committed
20
    authors = models.ManyToManyField(settings.AUTH_USER_MODEL)
Guilhem Saurel's avatar
Guilhem Saurel committed
21
22
23
24
25
    year = models.PositiveSmallIntegerField()
    url = models.URLField(max_length=200)
    pdf = models.URLField(max_length=200)


Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
26
class Namespace(NamedModel):
27
    group = models.BooleanField(default=False)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
28
29


Guilhem Saurel's avatar
Guilhem Saurel committed
30
31
32
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
33
34
35
36
37
38
    url = models.URLField(max_length=200)

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


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

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
48
    def api_data(self, url=''):
49
50
51
        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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75

    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()

76
77
78
79
80
81
    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
82
    def get_projects_github(self):
83
84
85
86
87
88
89
90
91
92
93
94
95
        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
96
97
98
99
100
101
            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
102
103
104
105
106
107
108
109
110
111
112
            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
113
                    continue
114
115
116
117
118
119
                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
120
121

    def get_projects_gitlab(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
122
        def update_gitlab(data):
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
123
124
125
126
127
            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
128
129
130
131
132
133
134
            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
135
136
        self.get_namespaces_gitlab()

137
        for data in self.api_data('/projects'):
Guilhem Saurel's avatar
Guilhem Saurel committed
138
139
140
            update_gitlab(data)

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

    def get_projects_redmine(self):
        pass  # TODO


Guilhem Saurel's avatar
Guilhem Saurel committed
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
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)
    # TODO: release github ↔ robotpkg

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

    def git(self):
        path = settings.RAINBOARD_GITS / self.main_namespace.slug / self.slug
        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'))

167
168
169
170
171
172
173
174
175
    def main_repo(self):
        try:
            return self.repo_set.get(forge=self.main_forge, namespace=self.main_namespace)
        except ObjectDoesNotExist:
            repo = Repo.objects.create(name=self.name, forge=self.main_forge, namespace=self.main_namespace,
                                       project=self, default_branch='master', repo_id=0)
            repo.api_update()
            return repo

Guilhem Saurel's avatar
Guilhem Saurel committed
176

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
177
178
class Repo(TimeStampedModel):
    name = models.CharField(max_length=200)
Guilhem Saurel's avatar
Guilhem Saurel committed
179
    slug = AutoSlugField(populate_from='name', slugify=slugify_with_dots)
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
180
181
182
183
184
185
186
187
188
189
    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
190
    forked_from = models.PositiveIntegerField(blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
191
    clone_url = models.URLField(max_length=200, blank=True, null=True)
Guilhem Saurel's avatar
Guilhem Saurel committed
192
193
194
195
196
197
198
    # 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
199
200
201
202
203
204

    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
205
206
        if self.forge.source == SOURCES.gitlab:
            return f'{self.forge.api_url()}/projects/{self.repo_id}'
Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
207
208

    def api_data(self, url=''):
Guilhem Saurel's avatar
Guilhem Saurel committed
209
210
211
        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
212

Guilhem Saurel's avatar
Guilhem Saurel committed
213
    def api_update(self):
Guilhem Saurel's avatar
Guilhem Saurel committed
214
215
216
217
218
219
        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
220
221
222
223
224
225
226
227
228
229

    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
230
        self.clone_url = data['http_url_to_repo']
Guilhem Saurel's avatar
Guilhem Saurel committed
231
232
        self.save()

Guilhem Saurel's avatar
Guilhem Saurel committed
233
234
235
236
237
238
239
240
241
242
243
244
    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
245
246
        self.clone_url = data['clone_url']
        self.save()
Guilhem Saurel's avatar
Guilhem Saurel committed
247

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
248
249
250
251
252
    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

253
254
255
    def git_remote(self):
        return f'{self.forge.slug}/{self.namespace.slug}'

Guilhem Saurel's avatar
git    
Guilhem Saurel committed
256
257
    def git(self):
        git = self.project.git()
258
        remote = self.git_remote()
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
259
260
261
        try:
            return git.remote(remote)
        except ValueError:
Guilhem Saurel's avatar
Guilhem Saurel committed
262
            logger.info(f'Creating remote {remote}')
Guilhem Saurel's avatar
git    
Guilhem Saurel committed
263
264
            return git.create_remote(remote, self.get_clone_url())

Guilhem Saurel's avatar
initial  
Guilhem Saurel committed
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312

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


class Branch(NamedModel, TimeStampedModel):
    repo = models.ForeignKey(Repo, on_delete=models.CASCADE)
    commit = models.ForeignKey(Commit, on_delete=models.CASCADE)

    def __str__(self):
        return f'{self.repo}/{self.name}'


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))