models.py
e71eed71e8dbissn4frontend

models.py
View Options

			from django.db import models
			from django.contrib.auth.models import User

			from datetime import date
			from django.utils.translation import gettext as _

			from django.core.validators import MaxValueValidator #max int value for issn

			# test model with essential tables


			class Country(models.Model):
			name = models.CharField(max_length = 120, null=False, default='unknown')

			def __str__(self):
			return f"{self.name}"

			class Language(models.Model):
			name = models.CharField(max_length = 120, null=False)

			def __str__(self):
			return f"{self.name}"

			class Issn(models.Model):
			serial = models.PositiveIntegerField(validators=[MaxValueValidator(99999999)], null=False)

			def __str__(self):
			return f"{self.serial}"


			class Journal(models.Model):
			title = models.CharField(max_length=60, null=False) # search journal with name
			issn = models.ForeignKey("Issn", on_delete=models.CASCADE) # search journal for ISSN
			website = models.URLField(max_length=120)
			languages = models.ManyToManyField(Language)
			country = models.ForeignKey("Country", on_delete=models.CASCADE)
			oa_status = models.PositiveSmallIntegerField(null=False) #??????
			starting_year = models.DateField(_("Date"), default=date.today) # add today for testing purpose
			doaj_status = models.CharField(max_length=60)
			qoam_status = models.CharField(max_length=60)
			lockss_portico = models.CharField(max_length=120)

			def __str__(self):
			return f"{self.title} from {self.website}"


			class Conditions(models.Model):
			journals = models.ManyToManyField(Journal)