class Migration(migrations.Migration):
dependencies = [
('polls', '0006_auto_20210310_1448'),
]
operations = [
migrations.AlterField(
model_name='vote',
name='user',
field=models.PositiveBigIntegerField(validators=[
django.core.validators.MinValueValidator(1000000000000000000),
django.core.validators.MaxValueValidator(9000000000000000000)
]),
),
]
class Migration(migrations.Migration):
dependencies = [
('tasks', '0002_task_user'),
]
operations = [
migrations.AlterField(
model_name='task',
name='amount',
field=models.PositiveBigIntegerField(validators=[
django.core.validators.MaxValueValidator(281474976710656),
django.core.validators.MinValueValidator(1)
]),
),
]
class ProjectBudget(models.Model):
project = models.ForeignKey('rebs_project.Project',
on_delete=models.PROTECT,
verbose_name='프로젝트')
account_d1 = models.ForeignKey('rebs.ProjectAccountD1',
on_delete=models.PROTECT,
verbose_name='예산항목1')
account_d2 = models.ForeignKey('rebs.ProjectAccountD2',
on_delete=models.PROTECT,
verbose_name='예산항목2')
budget = models.PositiveBigIntegerField(verbose_name='예산금액')
class Meta:
ordering = ('account_d2', '-project')
verbose_name = '06. 프로젝트 예산'
verbose_name_plural = '06. 프로젝트 예산'
class Migration(migrations.Migration):
dependencies = [
("user", "0004_auto_20201108_0004"),
]
operations = [
migrations.AlterField(
model_name="user",
name="phone_number",
field=models.PositiveBigIntegerField(
validators=[django.core.validators.MinValueValidator(100)],
verbose_name="Phone Number",
),
),
]
class VoteChoice(models.Model):
quiz = models.ForeignKey(Vote, on_delete=models.CASCADE)
user = models.ForeignKey(User,
on_delete=models.CASCADE,
to_field="username")
choice = models.PositiveBigIntegerField(blank=False, null=False)
class Meta:
unique_together = (
'quiz',
'user',
'choice',
)
def __str__(self):
return f"{self.quiz}:{self.user}"
class Migration(migrations.Migration):
dependencies = [
('portfolios', '0004_contact'),
]
operations = [
migrations.CreateModel(
name='SkillSection',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('value', models.PositiveBigIntegerField(default=0)),
],
),
]
class Tasks(models.Model):
address = models.CharField(max_length=300, unique=False, null=True)
timestamp = models.DateTimeField()
http_status = models.IntegerField(default=200)
NOT_STARTED = 1
PENDING = 2
FINISHED = 3
STATUS_CHOICES = (
(NOT_STARTED, 'NOT_STARTED'),
(PENDING, 'PENDING'),
(FINISHED, 'FINISHED'),
)
task_status = models.PositiveBigIntegerField(choices=STATUS_CHOICES, default=NOT_STARTED)
class Purchase(models.Model):
product = models.ForeignKey(Product, on_delete=models.CASCADE)
price = models.PositiveIntegerField()
quantity = models.PositiveIntegerField()
total_price = models.PositiveBigIntegerField(blank = True)
salesman = models.ForeignKey(User, on_delete=models.CASCADE)
date = models.DateTimeField(default=timezone.now)
def save(self,*args,**kwargs):
self.total_price = self.price * self.quantity
super().save(*args,**kwargs)
def __str__(self):
return " solled {} - {} items for {} ".format(self.product.name,self.quantity
,self.total_price)
class Expense(models.Model):
id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
name = models.CharField(max_length=255)
value = models.PositiveBigIntegerField()
description = models.TextField(max_length=500, default='')
start_date = models.DateField(default=date.today)
end_date = models.DateField(null=True, blank=True)
budget = models.ForeignKey(to=Budget,
related_name='expenses',
on_delete=models.CASCADE)
aim = models.ForeignKey(to=Aim,
related_name='expenses',
on_delete=models.CASCADE,
null=True,
blank=True)
active = models.BooleanField(default=True)
class OrderItem(models.Model):
braintree_id = models.CharField(max_length=150, blank=True)
order = models.ForeignKey(Order,
related_name='items',
on_delete=models.CASCADE)
product = models.ForeignKey(Product,
related_name='order_items',
on_delete=models.CASCADE)
price = models.DecimalField(max_digits=10, decimal_places=2)
quantity = models.PositiveBigIntegerField(default=1)
def __str__(self):
return '{}'.format(self.id)
def get_cost(self):
return self.price * self.quantity
class Task(CreatedModified):
uuid = models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True)
user = models.ForeignKey('users.User', on_delete=models.CASCADE)
amount = models.PositiveBigIntegerField(validators=[
MaxValueValidator(MAX_POINT_VALUE),
MinValueValidator(MIN_POINT_VALUE),
])
completed_date = models.DateTimeField(null=True)
repository = models.CharField(max_length=250)
title = models.CharField(max_length=250)
def __str__(self):
return f'#{self.pk}: {self.title}'
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Movie',
fields=[
('id',
models.IntegerField(primary_key=True,
serialize=False,
unique=True)),
('title',
models.CharField(max_length=30,
unique=True,
verbose_name='Title')),
('price', models.IntegerField()),
('rating',
models.PositiveBigIntegerField(
default=1,
validators=[
django.core.validators.MinValueValidator(1),
django.core.validators.MaxValueValidator(10)
])),
('description', models.TextField(max_length=100, unique=True)),
],
options={
'verbose_name': 'Movie',
'verbose_name_plural': 'Movies',
},
),
migrations.CreateModel(
name='Ticket',
fields=[
('id',
models.IntegerField(primary_key=True,
serialize=False,
unique=True)),
('account_id', models.IntegerField()),
('movie_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='movies.movie')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Breed',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(
max_length=200,
validators=[
django.core.validators.MinLengthValidator(
2, 'Breed must be greater than 1 character')
])),
],
),
migrations.CreateModel(
name='Cat',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('nickname',
models.CharField(
max_length=200,
validators=[
django.core.validators.MinLengthValidator(
2, 'Breed must be greater than 1 character')
])),
('weight', models.PositiveBigIntegerField()),
('foods', models.CharField(max_length=200)),
('breed',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='cats.breed')),
],
),
]
class NullableFields(models.Model):
# Fields in db.backends.oracle.BulkInsertMapper
big_int_filed = models.BigIntegerField(null=True, default=1)
binary_field = models.BinaryField(null=True, default=b'data')
date_field = models.DateField(null=True, default=timezone.now)
datetime_field = models.DateTimeField(null=True, default=timezone.now)
decimal_field = models.DecimalField(null=True,
max_digits=2,
decimal_places=1,
default=Decimal('1.1'))
duration_field = models.DurationField(null=True,
default=datetime.timedelta(1))
float_field = models.FloatField(null=True, default=3.2)
integer_field = models.IntegerField(null=True, default=2)
null_boolean_field = models.BooleanField(null=True, default=False)
positive_big_integer_field = models.PositiveBigIntegerField(null=True,
default=2**63 -
1)
positive_integer_field = models.PositiveIntegerField(null=True, default=3)
positive_small_integer_field = models.PositiveSmallIntegerField(null=True,
default=4)
small_integer_field = models.SmallIntegerField(null=True, default=5)
time_field = models.TimeField(null=True, default=timezone.now)
auto_field = models.ForeignKey(NoFields,
on_delete=models.CASCADE,
null=True)
small_auto_field = models.ForeignKey(SmallAutoFieldModel,
on_delete=models.CASCADE,
null=True)
big_auto_field = models.ForeignKey(BigAutoFieldModel,
on_delete=models.CASCADE,
null=True)
# Fields not required in BulkInsertMapper
char_field = models.CharField(null=True, max_length=4, default='char')
email_field = models.EmailField(null=True, default='*****@*****.**')
file_field = models.FileField(null=True, default='file.txt')
file_path_field = models.FilePathField(path='/tmp',
null=True,
default='file.txt')
generic_ip_address_field = models.GenericIPAddressField(
null=True, default='127.0.0.1')
if Image:
image_field = models.ImageField(null=True, default='image.jpg')
slug_field = models.SlugField(null=True, default='slug')
text_field = models.TextField(null=True, default='text')
url_field = models.URLField(null=True, default='/')
uuid_field = models.UUIDField(null=True, default=uuid.uuid4)
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Order',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('first_name', models.CharField(max_length=50)),
('last_name', models.CharField(max_length=50)),
('email', models.EmailField(max_length=254)),
('address', models.CharField(max_length=250)),
('postal_code', models.CharField(max_length=2)),
('city', models.CharField(max_length=100)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('paid', models.BooleanField(default=False)),
],
options={
'ordering': ('-created', ),
},
),
migrations.CreateModel(
name='OrderItem',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('quantity', models.PositiveBigIntegerField(default=1)),
('order',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='order_items',
to='orders.order')),
],
),
]
class File(models.Model):
file_id = models.UUIDField(primary_key=True,
default=uuid.uuid4,
editable=False)
file_object = models.FileField(upload_to=randomize_path,
storage=CustomFileSystemStorage(),
max_length=500)
file_name = models.CharField(max_length=255,
null=True,
blank=True,
default=None)
file_hash = models.CharField(max_length=40, blank=True, null=True)
is_pii = models.BooleanField(default=False)
is_centcom = models.BooleanField(default=False)
rejection_reason = models.ForeignKey(Rejection,
on_delete=models.DO_NOTHING,
null=True,
blank=True)
rejection_text = models.TextField(default=None, blank=True, null=True)
org = models.CharField(max_length=50, default="")
NDCI = models.BooleanField(default=False)
file_count = models.PositiveIntegerField(default=1)
file_size = models.PositiveBigIntegerField(default=0)
date_oneeye = models.DateTimeField(null=True, blank=True)
user_oneeye = models.ForeignKey(settings.AUTH_USER_MODEL,
related_name='file_user_oneeye',
on_delete=models.DO_NOTHING,
null=True,
blank=True)
date_twoeye = models.DateTimeField(null=True, blank=True)
user_twoeye = models.ForeignKey(settings.AUTH_USER_MODEL,
related_name='file_user_twoeye',
on_delete=models.DO_NOTHING,
null=True,
blank=True)
pull = models.ForeignKey(Pull,
on_delete=models.DO_NOTHING,
default=None,
blank=True,
null=True)
scan_results = models.JSONField(null=True, blank=True)
class Meta:
ordering = [F('file_name').asc(nulls_last=True)]
def __str__(self):
return os.path.basename(self.file_object.name)
class TestingLab(models.Model):
tlabid = models.OneToOneField(UserDetails,
on_delete=models.CASCADE,
primary_key=True)
phone = models.PositiveBigIntegerField(validators=[
MaxValueValidator(9999999999),
MinValueValidator(1000000000)
],
null=True)
about = models.TextField(max_length=2000)
country = models.CharField(max_length=100)
state = models.CharField(max_length=100, default="delhi")
city = models.CharField(max_length=100)
area = models.CharField(max_length=200, blank=True)
zip = models.PositiveIntegerField(
validators=[MaxValueValidator(999999),
MinValueValidator(0)],
null=True,
blank=True)
year_established = models.PositiveIntegerField(
validators=[MinValueValidator(1700)], null=True, blank=True)
tlab_logo = models.ImageField(upload_to="testing_lab_logo/",
null=True,
blank=True)
lab_photo = models.ImageField(upload_to="testing_lab_photo/",
null=True,
blank=True)
certificate = models.FileField(upload_to="testing_lab_certificate/")
verified = models.CharField(max_length=10, default="No")
start_time = models.CharField(max_length=5, default="09:00")
end_time = models.CharField(max_length=5, default="18:00")
rating = models.CharField(default=0, max_length=10000)
no_of_raters = models.PositiveIntegerField(default=0)
nullable_strings = [about]
nullable_non_strings = [tlab_logo, zip, year_established]
def save(self, *args, **kwargs):
for i in self.nullable_non_strings:
if not i:
self.i = None
for i in self.nullable_strings:
if not i:
self.i = ""
super(TestingLab, self).save(*args, **kwargs)
def __str__(self):
return str(self.tlabid)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Category',
fields=[
('name', models.CharField(max_length=50, unique=True)),
('slug', models.SlugField(primary_key=True, serialize=False)),
('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='child', to='main.category')),
],
),
migrations.CreateModel(
name='Product',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=250)),
('description', models.TextField()),
('price', models.DecimalField(decimal_places=2, max_digits=10)),
('stock', models.PositiveBigIntegerField(default=1)),
('author_id', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
('category', models.ManyToManyField(to='main.Category')),
],
),
migrations.CreateModel(
name='ProductImage',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.ImageField(blank=True, null=True, upload_to='products')),
('product', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='images', to='main.product')),
],
),
migrations.CreateModel(
name='Comment',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('text', models.CharField(max_length=100)),
('author_id', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
('product', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='main.product')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Book',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('isbn', models.PositiveBigIntegerField()),
('title', models.CharField(max_length=250)),
('author',
models.CharField(choices=[('Alicja Sinicka', 'Sinicka'),
('Harlan Coben', 'Coben'),
('Remigiusz Mróz', 'Mroz'),
('Suzanne Collins', 'Collins'),
('Anna Wolf', 'Wolf')],
default='Harlan Coben',
max_length=50)),
('genre', models.CharField(max_length=50)),
],
),
migrations.CreateModel(
name='Opinion',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('mark',
models.IntegerField(choices=[(1, 1), (2, 2), (3, 3), (4,
4)])),
('comment', models.CharField(max_length=250)),
('isbn',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='books.book')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Room',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('address', models.CharField(max_length=150)),
('nearby', models.TextField(max_length=300)),
('type', models.IntegerField()),
('price', models.IntegerField()),
('area', models.IntegerField()),
('private_bathroom', models.BooleanField()),
('co_nonglanh', models.BooleanField()),
('kitchen', models.IntegerField()),
('air_conditional', models.BooleanField()),
('ban_cong', models.BooleanField()),
('service_charge', models.TextField(max_length=100)),
('other_ultily', models.TextField()),
('longevity',
models.PositiveBigIntegerField(validators=[
django.core.validators.MinValueValidator(7),
django.core.validators.MaxValueValidator(364)
])),
('is_active', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='RoomType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
),
]
class ASN(BGPBase):
number = models.PositiveBigIntegerField(
validators=[MinValueValidator(1),
MaxValueValidator(4294967295)])
group = models.ForeignKey(ASNGroup,
on_delete=models.PROTECT,
blank=True,
null=True)
tags = TaggableManager(through='extras.TaggedItem',
related_name='asn_tags')
clone_fields = ['description', 'status', 'tenant']
class Meta:
verbose_name = 'AS Number'
verbose_name_plural = 'AS Numbers'
constraints = [
models.UniqueConstraint(fields=['number', 'tenant'],
name='uniqie_number_tenant'),
models.UniqueConstraint(fields=['number'],
condition=models.Q(tenant=None),
name='uniqie_number'),
]
# unique_together = ['number', 'site', 'tenant']
def get_status_color(self):
return ASNStatusChoices.colors.get(self.status)
def get_absolute_url(self):
return reverse('plugins:netbox_bgp:asn', args=[self.pk])
def get_asdot(self):
if self.number > 65535:
return '{}.{}'.format(self.number // 65536, self.number % 65536)
else:
return str(self.number)
def __str__(self):
nb_settings = settings.PLUGINS_CONFIG.get('netbox_bgp', {})
asdot = nb_settings.get('asdot', False)
if asdot:
return self.get_asdot()
return str(self.number)
class BookLike(models.Model):
class Meta:
unique_together = ['user', 'book']
user = models.ForeignKey(User, on_delete=models.CASCADE)
book = models.ForeignKey(Book, on_delete=models.CASCADE, related_name='book_like')
rate = models.PositiveBigIntegerField(default=0)
def save(self, **kwargs):
try:
super().save(**kwargs)
except IntegrityError:
bl = BookLike.objects.get(user=self.user, book=self.book)
bl.rate =self.rate
bl.save()
else:
self.book.cached_rate = self.book.book_like.aggregate(Avg('rate'))['rate__avg']
self.book.save()
class Migration(migrations.Migration):
dependencies = [
('ctools', '0003_auto_20210902_0231'),
]
operations = [
migrations.CreateModel(
name='MobileLocation',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('num',
models.PositiveBigIntegerField(unique=True,
verbose_name='号段')),
('province', models.CharField(max_length=64,
verbose_name='省')),
('city', models.CharField(max_length=128, verbose_name='市')),
('isp',
models.CharField(blank=True,
max_length=64,
verbose_name='运营商')),
('area_code',
models.CharField(blank=True,
max_length=64,
verbose_name='区域编码')),
('city_code',
models.CharField(blank=True, max_length=64,
verbose_name='区号')),
('zip_code',
models.CharField(blank=True,
max_length=64,
verbose_name='邮政编码')),
('types',
models.CharField(blank=True, max_length=64,
verbose_name='类型')),
],
options={
'verbose_name': 'Mobile Location',
'verbose_name_plural': 'Mobile Locations',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('accounts', '0001_initial'),
]
operations = [
migrations.AlterField(
model_name='account',
name='balance',
field=models.PositiveBigIntegerField(
default=0,
validators=[
django.core.validators.MaxValueValidator(281474976710656)
]),
),
]
class AttributeGroup(models.Model):
class Meta:
verbose_name = _('Attributes group')
verbose_name_plural = _('Attributes groups')
name = models.CharField(max_length=200, verbose_name=_('name'))
def __str__(self):
return self.name
icecat_id = models.PositiveBigIntegerField(
default=None,
null=True,
blank=True,
db_index=True,
verbose_name=_('icecat id'),
)
class Article(models.Model):
title = models.CharField('标题', max_length=70)
digest = models.TextField('摘要', max_length=200, blank=True)
category = models.ForeignKey(Category, on_delete=models.DO_NOTHING, verbose_name='分类', blank=True, null=True)
tag = models.ManyToManyField(Tag, verbose_name='标签', blank=True)
body = MDTextField()
user = models.ForeignKey(User, on_delete=models.CASCADE, verbose_name='作者')
views = models.PositiveBigIntegerField('阅读量', default=0)
create_time = models.DateTimeField('发布时间', auto_now_add=True)
update_time = models.DateTimeField('更新时间', auto_now=True)
class Meta:
verbose_name = '文章'
verbose_name_plural = verbose_name
def __str__(self):
return self.title
class Medicine(models.Model):
objects = models.Manager()
name = models.CharField(max_length=20)
category = models.ForeignKey(MedCat, on_delete=models.CASCADE)
price = models.DecimalField(decimal_places=2, max_digits=5)
quantity = models.PositiveBigIntegerField()
thumbnail = models.BinaryField(null=True, editable=True, blank=True)
thumb_content_type = models.CharField(max_length=256,
default='image/png',
null=True,
blank=True,
help_text="MIMEType for thumbnail")
description = models.TextField()
owner = models.ForeignKey(settings.AUTH_USER_MODEL,
on_delete=models.CASCADE)
slug = models.SlugField(unique=True)
def __str__(self):
return self.name
class Meta:
ordering = ["-price"]
def save(self, *args, **kwargs):
slug = slugify(self.name + '-' + self.category.name)
while Medicine.objects.filter(slug=slug):
slug = "".join(random.sample(slug, len(slug)))
self.slug = slug
super(Medicine, self).save(*args, **kwargs)
@property
def as_json(self):
try:
owner = self.owner.sellerprofile.store_name
except ObjectDoesNotExist:
owner = 'Medstore'
return {
'id': self.id,
'name': self.name,
'category': self.category.name,
'price': self.price,
'quantity': self.quantity,
'description': self.description,
'owner': owner,
'slug': self.slug
}
class PartnerLog(models.Model):
create_at = models.DateTimeField("Дата создания")
partner_id = models.PositiveBigIntegerField("ID партнера")
class Meta:
db_table = 'partner_log'
verbose_name = 'Лог партнера'
verbose_name_plural = 'Логи партнеров'
def __str__(self):
return f"ID logs: {self.id} => дата создания: {self.create_at}"
def save(self, *args, **kwargs):
if not self.id:
self.created_at = timezone.now()
super(PartnerLog, self).save(*args, **kwargs)
return self
class Migration(migrations.Migration):
dependencies = [
('medicines', '0001_initial'),
]
operations = [
migrations.AlterModelOptions(
name='medcat',
options={'verbose_name': 'Medicine Category'},
),
migrations.AlterField(
model_name='medicine',
name='quantity',
field=models.PositiveBigIntegerField(),
),
]
class Migration(migrations.Migration):
dependencies = [
('source', '0003_auto_20200823_1927'),
]
operations = [
migrations.RemoveField(
model_name='gaiasource',
name='id',
),
migrations.AlterField(
model_name='gaiasource',
name='source_id',
field=models.PositiveBigIntegerField(help_text='1000225938242805248', primary_key=True, serialize=False),
),
]
