class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='MainUser',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('password',
models.CharField(max_length=128, verbose_name='password')),
('last_login',
models.DateTimeField(blank=True,
null=True,
verbose_name='last login')),
('is_superuser',
models.BooleanField(
default=False,
help_text=
'Designates that this user has all permissions without explicitly assigning them.',
verbose_name='superuser status')),
('email',
models.EmailField(max_length=254,
unique=True,
verbose_name='email address')),
('first_name',
models.CharField(blank=True,
max_length=30,
verbose_name='first name')),
('last_name',
models.CharField(blank=True,
max_length=30,
verbose_name='last name')),
('date_joined',
models.DateTimeField(auto_now_add=True,
verbose_name='date joined')),
('is_active',
models.BooleanField(default=True, verbose_name='active')),
('is_staff',
models.BooleanField(default=False, verbose_name='is_staff')),
('role',
models.SmallIntegerField(choices=[(1, 'super admin'),
(2, 'guest')],
default=2)),
('groups',
models.ManyToManyField(
blank=True,
help_text=
'The groups this user belongs to. A user will get all permissions granted to each of their groups.',
related_name='user_set',
related_query_name='user',
to='auth.Group',
verbose_name='groups')),
('user_permissions',
models.ManyToManyField(
blank=True,
help_text='Specific permissions for this user.',
related_name='user_set',
related_query_name='user',
to='auth.Permission',
verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
},
managers=[
('objects', auth_.managers.MainUserManager()),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('bio', models.TextField(blank=True, max_length=500)),
('location', models.CharField(blank=True, max_length=30)),
('birth_date', models.DateField(blank=True, null=True)),
('age', models.IntegerField(default=18, max_length=120)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'Profile',
'verbose_name_plural': 'Profiles',
},
),
]
class Model(models.Model):
content_type = models.IntegerField() # should be ForeignKey
object_id = models.PositiveIntegerField()
content_object = GenericForeignKey(
'content_type', 'object_id')
class Migration(migrations.Migration):
dependencies = [
('management', '0011_drop_meta_db_name'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('testplans', '0015_drop_meta_db_name'),
]
operations = [
migrations.AlterField(
model_name='testplan',
name='plan_id',
field=models.AutoField(primary_key=True, serialize=False),
),
migrations.CreateModel(
name='HistoricalTestPlan',
fields=[
('plan_id', models.IntegerField(blank=True, db_index=True)),
('name', models.CharField(db_index=True, max_length=255)),
('create_date',
models.DateTimeField(blank=True,
db_column='creation_date',
editable=False)),
('is_active',
models.BooleanField(db_column='isactive',
db_index=True,
default=True)),
('extra_link',
models.CharField(blank=True,
default=None,
max_length=1024,
null=True)),
('history_id',
models.AutoField(primary_key=True, serialize=False)),
('history_change_reason', models.TextField(null=True)),
('history_date', models.DateTimeField()),
('history_type',
models.CharField(choices=[('+', 'Created'), ('~', 'Changed'),
('-', 'Deleted')],
max_length=1)),
('author',
models.ForeignKey(blank=True,
db_constraint=False,
null=True,
on_delete=models.DO_NOTHING,
related_name='+',
to=settings.AUTH_USER_MODEL)),
('history_user',
models.ForeignKey(null=True,
on_delete=models.SET_NULL,
related_name='+',
to=settings.AUTH_USER_MODEL)),
('owner',
models.ForeignKey(blank=True,
db_constraint=False,
null=True,
on_delete=models.DO_NOTHING,
related_name='+',
to=settings.AUTH_USER_MODEL)),
('parent',
models.ForeignKey(blank=True,
db_constraint=False,
null=True,
on_delete=models.DO_NOTHING,
related_name='+',
to='testplans.TestPlan')),
('product',
models.ForeignKey(blank=True,
db_constraint=False,
null=True,
on_delete=models.DO_NOTHING,
related_name='+',
to='management.Product')),
('product_version',
models.ForeignKey(blank=True,
db_constraint=False,
null=True,
on_delete=models.DO_NOTHING,
related_name='+',
to='management.Version')),
('type',
models.ForeignKey(blank=True,
db_constraint=False,
null=True,
on_delete=models.DO_NOTHING,
related_name='+',
to='testplans.PlanType')),
],
options={
'verbose_name': 'historical test plan',
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('users', '0001_initial'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='TwitterUserConfig',
fields=[
('created',
django_extensions.db.fields.CreationDateTimeField(
auto_now_add=True, verbose_name='created')),
('modified',
django_extensions.db.fields.ModificationDateTimeField(
auto_now=True, verbose_name='modified')),
('uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
unique=True)),
('is_deleted', models.BooleanField(db_index=True,
default=False)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL,
verbose_name='User')),
('oauth_token',
models.CharField(max_length=200, verbose_name='Oauth Token')),
('oauth_token_secret',
models.CharField(max_length=200,
verbose_name='Oauth Token Secret')),
('access_token',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Access Token')),
('access_token_secret',
models.CharField(blank=True,
max_length=200,
null=True,
verbose_name='Access Token Secret')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Tweet',
fields=[
('created',
django_extensions.db.fields.CreationDateTimeField(
auto_now_add=True, verbose_name='created')),
('modified',
django_extensions.db.fields.ModificationDateTimeField(
auto_now=True, verbose_name='modified')),
('uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
unique=True)),
('is_deleted', models.BooleanField(db_index=True,
default=False)),
('id', models.AutoField(primary_key=True, serialize=False)),
('tweet_id', models.BigIntegerField()),
('text', models.CharField(max_length=400)),
('truncated', models.BooleanField(default=False)),
('lang',
models.CharField(blank=True,
default=None,
max_length=9,
null=True)),
('twitter_user_id', models.BigIntegerField()),
('twitter_user_screen_name', models.CharField(max_length=50)),
('twitter_user_name', models.CharField(max_length=150)),
('twitter_user_verified', models.BooleanField(default=False)),
('user_utc_offset',
models.IntegerField(blank=True, default=None, null=True)),
('user_time_zone',
models.CharField(blank=True,
default=None,
max_length=150,
null=True)),
('favorite_count',
models.PositiveIntegerField(blank=True, null=True)),
('retweet_count',
models.PositiveIntegerField(blank=True, null=True)),
('user_followers_count',
models.PositiveIntegerField(blank=True, null=True)),
('user_friends_count',
models.PositiveIntegerField(blank=True, null=True)),
('in_reply_to_status_id',
models.BigIntegerField(blank=True, default=None, null=True)),
('retweeted_status_id',
models.BigIntegerField(blank=True, default=None, null=True)),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='tweets',
to=settings.AUTH_USER_MODEL,
verbose_name='User')),
],
options={
'unique_together': {('user_id', 'tweet_id')},
},
),
migrations.CreateModel(
name='Link',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created',
django_extensions.db.fields.CreationDateTimeField(
auto_now_add=True, verbose_name='created')),
('modified',
django_extensions.db.fields.ModificationDateTimeField(
auto_now=True, verbose_name='modified')),
('uuid',
models.UUIDField(default=uuid.uuid4,
editable=False,
unique=True)),
('is_deleted', models.BooleanField(db_index=True,
default=False)),
('url', models.CharField(blank=True, max_length=400)),
('domain', models.CharField(blank=True, max_length=200)),
('tweet',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='links',
to='twitter.Tweet',
verbose_name='Tweet')),
],
options={
'abstract': False,
},
),
]
class User(models.Model):
id = models.IntegerField(primary_key=True)
user_name = models.CharField(max_length=20)
password = models.CharField(max_length=6)
postionId = models.IntegerField()
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name="Charge",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("amount", models.IntegerField()),
("amount_refunded", models.IntegerField()),
("balance_transaction", models.CharField(max_length=255)),
("captured", models.BooleanField(default=False)),
("created", models.DateTimeField()),
(
"currency",
models.CharField(choices=[("usd", "usd")],
default="usd",
max_length=3),
),
("dispute", models.BooleanField(default=False)),
("livemode", models.BooleanField(default=False)),
("paid", models.BooleanField(blank=True, null=True)),
(
"receipt_email",
models.CharField(blank=True, default="", max_length=800),
),
("refunded", models.BooleanField(default=False)),
(
"status",
models.CharField(
choices=[
("succeeded", "succeeded"),
("pending", "pending"),
("failed", "failed"),
],
default="pending",
max_length=9,
),
),
],
),
migrations.CreateModel(
name="Customer",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("livemode", models.BooleanField(default=False)),
(
"account_balance",
models.DecimalField(blank=True,
decimal_places=2,
max_digits=9,
null=True),
),
(
"currency",
models.CharField(choices=[("usd", "usd")],
default="usd",
max_length=3),
),
("delinquent", models.BooleanField(default=False)),
("default_source", models.TextField(blank=True, null=True)),
("metadata", django.contrib.postgres.fields.jsonb.JSONField()),
],
),
migrations.CreateModel(
name="Event",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("created", models.DateTimeField()),
("data", django.contrib.postgres.fields.jsonb.JSONField()),
("livemode", models.BooleanField(default=False)),
("request", models.CharField(max_length=255)),
("kind", models.CharField(max_length=64)),
("metadata", django.contrib.postgres.fields.jsonb.JSONField()),
],
),
migrations.CreateModel(
name="Invoice",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("attempt_count", models.IntegerField()),
("attempted", models.BooleanField(default=False)),
(
"currency",
models.CharField(choices=[("usd", "usd")],
default="usd",
max_length=3),
),
("description", models.TextField(blank=True)),
("ending_balance", models.IntegerField(null=True)),
("forgiven", models.BooleanField(default=False)),
(
"hosted_invoice_url",
models.CharField(blank=True, default="", max_length=799),
),
(
"invoice_pdf",
models.CharField(blank=True, default="", max_length=799),
),
("livemode", models.BooleanField(default=False)),
("paid", models.BooleanField(default=False)),
("period_end", models.DateTimeField()),
("period_start", models.DateTimeField()),
("receipt_number", models.CharField(max_length=64, null=True)),
("starting_balance", models.IntegerField()),
(
"statement_descriptor",
models.CharField(blank=True, default="", max_length=22),
),
(
"subscription_proration_date",
models.DateTimeField(blank=True, null=True),
),
("subtotal", models.IntegerField(blank=True, null=True)),
("tax", models.IntegerField(blank=True, null=True)),
(
"tax_percent",
models.DecimalField(decimal_places=2,
max_digits=5,
null=True),
),
("total", models.IntegerField()),
],
),
migrations.CreateModel(
name="Plan",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("active", models.BooleanField(default=False)),
(
"aggregate_usage",
models.CharField(
choices=[
("sum", "sum"),
("last_during_period", "last_during_period"),
("max", "max"),
("last_ever", "LAST_EVER"),
],
default="sum",
max_length=18,
null=True,
),
),
("amount", models.IntegerField()),
("created", models.DateTimeField(blank=True, null=True)),
(
"currency",
models.CharField(choices=[("usd", "usd")],
default="usd",
max_length=3),
),
(
"interval",
models.CharField(
choices=[
("day", "day"),
("week", "week"),
("month", "month"),
("year", "year"),
],
default="month",
max_length=5,
),
),
("livemode", models.BooleanField(default=False)),
("metadata", django.contrib.postgres.fields.jsonb.JSONField()),
("nickname", models.CharField(max_length=255)),
("trial_period_days", models.IntegerField(default=0,
null=True)),
(
"usage_type",
models.CharField(
choices=[("licensed", "licensed"),
("metered", "metered")],
max_length=8,
),
),
],
),
migrations.CreateModel(
name="Product",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("name", models.CharField(max_length=255)),
("metadata", django.contrib.postgres.fields.jsonb.JSONField()),
],
),
migrations.CreateModel(
name="Subscription",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("livemode", models.BooleanField(default=False)),
("metadata", django.contrib.postgres.fields.jsonb.JSONField()),
("cancel_at_period_end",
models.BooleanField(default=False, null=True)),
("current_period_start",
models.DateTimeField(blank=True, null=True)),
("current_period_end",
models.DateTimeField(blank=True, null=True)),
("canceled_at", models.DateTimeField(blank=True, null=True)),
("ended_at", models.DateTimeField(blank=True, null=True)),
(
"customer",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="subscriptions",
to="billing.Customer",
),
),
(
"plans",
models.ManyToManyField(related_name="subscriptions",
to="billing.Plan"),
),
],
),
migrations.CreateModel(
name="SubscriptionItem",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("livemode", models.BooleanField(default=False)),
("created", models.DateTimeField()),
(
"plan",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name="subscription_items",
to="billing.Plan",
),
),
(
"subscription",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="subscription_items",
to="billing.Subscription",
),
),
],
),
migrations.CreateModel(
name="UsageRecord",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("stripe_id", models.CharField(max_length=255, unique=True)),
("livemode", models.BooleanField(default=False)),
(
"action",
models.CharField(
choices=[("increment", "increment"), ("set", "set")],
default="increment",
max_length=9,
),
),
("quantity", models.IntegerField(default=0)),
("timestamp", models.DateTimeField()),
(
"subscription_item",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="usage_records",
to="billing.SubscriptionItem",
),
),
],
),
]
class Product(models.Model):
name = models.CharField(max_length=100)
code = models.IntegerField()
class ChatRoom(models.Model):
nickname = models.CharField(verbose_name='群名', max_length=50)
order = models.IntegerField(verbose_name='优先级', unique=True)
def __str__(self):
return self.nickname
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='CityDict',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20, verbose_name='城市')),
('desc', models.CharField(max_length=200, verbose_name='描述')),
('add_time',
models.DateTimeField(default=datetime.datetime.now)),
],
options={
'verbose_name': '城市',
'verbose_name_plural': '城市',
},
),
migrations.CreateModel(
name='CourseOrg',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='机构名称')),
('desc', models.CharField(max_length=200,
verbose_name='机构描述')),
('click_nums',
models.IntegerField(default=0, verbose_name='点击数')),
('fav_nums', models.IntegerField(default=0,
verbose_name='收藏数')),
('image',
models.ImageField(upload_to='org/%Y%m', verbose_name='封面图')),
('address',
models.CharField(max_length=150, verbose_name='机构地址')),
('add_time',
models.DateTimeField(default=datetime.datetime.now)),
('city',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='organization.CityDict',
verbose_name='所在城市')),
],
options={
'verbose_name': '课程机构',
'verbose_name_plural': '课程机构',
},
),
migrations.CreateModel(
name='Teacher',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='教师名')),
('work_years',
models.IntegerField(default=0, verbose_name='工作年限')),
('work_company',
models.CharField(max_length=50, verbose_name='就职公司')),
('work_positon',
models.CharField(max_length=50, verbose_name='公司职位')),
('points', models.CharField(max_length=50,
verbose_name='教学特点')),
('click_nums',
models.IntegerField(default=0, verbose_name='点击数')),
('fav_nums', models.IntegerField(default=0,
verbose_name='收藏数')),
('add_time',
models.DateTimeField(default=datetime.datetime.now)),
('org',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='organization.CourseOrg',
verbose_name='所属机构')),
],
options={
'verbose_name': '教师',
'verbose_name_plural': '教师',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='a_table',
fields=[
('a_id', models.IntegerField(primary_key=True,
serialize=False)),
('a_name', models.CharField(max_length=50)),
('description', models.CharField(max_length=2000)),
],
),
migrations.CreateModel(
name='s_table',
fields=[
('s_name',
models.CharField(max_length=50,
primary_key=True,
serialize=False)),
('dex_id', models.IntegerField(default=0)),
('gen', models.IntegerField(default=0)),
('gender_rate', models.IntegerField(default=0)),
('capture_rate', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='t_table',
fields=[
('t_name',
models.CharField(default='',
max_length=10,
primary_key=True,
serialize=False)),
('t_id', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='t_relation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('Normal', models.FloatField(default=0)),
('Fire', models.FloatField(default=0)),
('Water', models.FloatField(default=0)),
('Grass', models.FloatField(default=0)),
('Flying', models.FloatField(default=0)),
('Fighting', models.FloatField(default=0)),
('Poison', models.FloatField(default=0)),
('Electric', models.FloatField(default=0)),
('Ground', models.FloatField(default=0)),
('Rock', models.FloatField(default=0)),
('Psychic', models.FloatField(default=0)),
('Ice', models.FloatField(default=0)),
('Bug', models.FloatField(default=0)),
('Ghost', models.FloatField(default=0)),
('Steel', models.FloatField(default=0)),
('Dragon', models.FloatField(default=0)),
('Dark', models.FloatField(default=0)),
('Fairy', models.FloatField(default=0)),
('t',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='pokewiki.t_table')),
],
),
migrations.CreateModel(
name='f_table',
fields=[
('f_name',
models.CharField(max_length=50,
primary_key=True,
serialize=False)),
('height', models.FloatField(default=0)),
('weight', models.FloatField(default=0)),
('hp', models.IntegerField(default=0)),
('atk', models.IntegerField(default=0)),
('df', models.IntegerField(default=0)),
('spatk', models.IntegerField(default=0)),
('spdf', models.IntegerField(default=0)),
('spd', models.IntegerField(default=0)),
('type1', models.CharField(default='', max_length=10)),
('type2', models.CharField(default='', max_length=10)),
('s_name',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='pokewiki.s_table')),
],
),
migrations.CreateModel(
name='a_relation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('a',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='pokewiki.a_table')),
('f_name',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='pokewiki.f_table')),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='HistoricalPlayer',
fields=[
('id',
models.IntegerField(auto_created=True,
blank=True,
db_index=True,
verbose_name='ID')),
('fullname', models.CharField(max_length=128)),
('rawname', models.CharField(max_length=128)),
('classname', models.CharField(max_length=128)),
('racename', models.CharField(max_length=128)),
('realmrank', models.CharField(max_length=128)),
('guildname', models.CharField(max_length=128)),
('raw_data', models.CharField(max_length=512)),
('history_id',
models.AutoField(primary_key=True, serialize=False)),
('history_date', models.DateTimeField()),
('history_type',
models.CharField(choices=[('+', 'Created'), ('~', 'Changed'),
('-', 'Deleted')],
max_length=1)),
('history_user',
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='+',
to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ('-history_date', '-history_id'),
'get_latest_by': 'history_date',
'verbose_name': 'historical player',
},
),
migrations.CreateModel(
name='Player',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('fullname', models.CharField(max_length=128)),
('rawname', models.CharField(max_length=128)),
('classname', models.CharField(max_length=128)),
('racename', models.CharField(max_length=128)),
('realmrank', models.CharField(max_length=128)),
('guildname', models.CharField(max_length=128)),
('raw_data', models.CharField(max_length=512)),
],
),
]
class TaskTaken(models.Model):
STATUS_TAKEN = 0
STATUS_CANCELLED = 1
STATUS_BLACKLISTED = 2
STATUS_SCORED = 3
STATUS_DELETED = 4
user = models.ForeignKey(User, db_index=True, null=False, blank=False)
task = models.ForeignKey(Task, db_index=True, null=False, blank=False)
issue = models.ForeignKey('issues.Issue',
db_index=True,
null=True,
blank=False)
TASK_TAKEN_STATUSES = ((STATUS_TAKEN, u'Task taken'), (STATUS_CANCELLED,
u'Task cancelled'),
(STATUS_BLACKLISTED, u'Task blacklisted'),
(STATUS_SCORED, u'Task scored'),
(STATUS_DELETED, u'TaskTaken deleted'))
status = models.IntegerField(max_length=1,
choices=TASK_TAKEN_STATUSES,
db_index=True,
null=False,
blank=False,
default=0)
EDIT = 'EDIT'
QUEUE = 'QUEUE'
OK = 'OK'
STATUS_CHECK_CHOICES = (
(EDIT, u'Дорешивание'),
(QUEUE, u'Ожидает проверки'),
(OK, u'Задача зачтена и/или больше не принимается'),
)
status_check = models.CharField(db_index=True,
max_length=5,
choices=STATUS_CHECK_CHOICES,
default=EDIT)
taken_time = models.DateTimeField(blank=True, null=True)
blacklisted_till = models.DateTimeField(blank=True, null=True)
added_time = models.DateTimeField(auto_now_add=True, default=timezone.now)
update_time = models.DateTimeField(auto_now=True, default=timezone.now)
@property
def score(self):
self.update_status()
if not self.issue:
return 0
return self.issue.mark
def update_status(self):
if self.issue and abs(
self.issue.mark
) > sys.float_info.epsilon and self.status != self.STATUS_SCORED:
self.scored()
if not self.issue.get_byname('responsible_name'):
group = self.task.course.get_user_group(self.user)
if group:
default_teacher = self.task.course.get_default_teacher(group)
if default_teacher:
self.issue.set_byname('responsible_name',
default_teacher,
author=None)
def take(self):
self.status = self.STATUS_TAKEN
if self.taken_time is None:
self.taken_time = timezone.now()
self.save()
def cancel(self):
dt_from_taken_delta = timezone.now() - self.taken_time
if (dt_from_taken_delta.days
) <= settings.PYTHONTASK_MAX_DAYS_TO_FULL_CANCEL:
self.taken_time = None
self.status = self.STATUS_CANCELLED
self.save()
def blacklist(self):
self.status = self.STATUS_BLACKLISTED
self.blacklisted_till = timezone.now() + timedelta(
days=settings.PYTHONTASK_DAYS_DROP_FROM_BLACKLIST)
self.save()
def scored(self):
self.status = self.STATUS_SCORED
self.save()
def mark_deleted(self):
self.status = self.STATUS_DELETED
self.taken_time = None
self.blacklisted_till = None
self.save()
class Meta:
unique_together = (("user", "task"), )
def __unicode__(self):
return unicode(self.task) + " (" + unicode(self.user) + ")"
class Task(models.Model):
title = models.CharField(max_length=191,
db_index=True,
null=True,
blank=True)
short_title = models.CharField(max_length=15,
db_index=True,
null=True,
blank=True)
course = models.ForeignKey(Course, db_index=True, null=False, blank=False)
group = models.ForeignKey(Group,
db_index=False,
null=True,
blank=True,
default=None)
groups = models.ManyToManyField(Group,
null=False,
blank=False,
related_name='groups_set')
weight = models.IntegerField(db_index=True,
null=False,
blank=False,
default=0)
is_hidden = models.BooleanField(db_index=True,
null=False,
blank=False,
default=False)
parent_task = models.ForeignKey('self',
db_index=True,
null=True,
blank=True,
related_name='children')
task_text = models.TextField(null=True, blank=True, default=None)
score_max = models.IntegerField(db_index=True,
null=False,
blank=False,
default=0)
max_students = models.IntegerField(null=False, blank=False, default=0)
contest_integrated = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
rb_integrated = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
TYPE_FULL = 'All'
TYPE_SIMPLE = 'Only mark'
TYPE_SEMINAR = 'Seminar'
TYPE_MATERIAL = 'Material'
TYPE_IPYNB = 'Jupyter Notebook'
TASK_TYPE_CHOICES = ((TYPE_FULL, _('s_obsuzhdeniem')),
(TYPE_SIMPLE, _('tolko_ocenka')), (TYPE_MATERIAL,
_('material')),
(TYPE_SEMINAR, _('seminar')), (TYPE_IPYNB,
_('jupyter notebook')))
type = models.CharField(db_index=False,
max_length=128,
choices=TASK_TYPE_CHOICES,
default=TYPE_FULL)
added_time = models.DateTimeField(auto_now_add=True, default=timezone.now)
update_time = models.DateTimeField(auto_now=True, default=timezone.now)
deadline_time = models.DateTimeField(auto_now=False,
blank=True,
null=True,
default=None)
updated_by = models.ForeignKey(User, db_index=False, null=True, blank=True)
contest_id = models.IntegerField(db_index=True,
null=False,
blank=False,
default=0)
problem_id = models.CharField(max_length=128,
db_index=True,
null=True,
blank=True)
send_to_users = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
sended_notify = models.BooleanField(db_index=True,
null=False,
blank=False,
default=True)
one_file_upload = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
accepted_after_contest_ok = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
score_after_deadline = models.BooleanField(db_index=False,
null=False,
blank=False,
default=True)
nb_assignment_name = models.CharField(max_length=255,
null=True,
blank=True)
def __unicode__(self):
return unicode(self.title)
def get_title(self, lang=settings.LANGUAGE_CODE):
return escape(get_lang_text(self.title, lang))
def get_description(self, lang=settings.LANGUAGE_CODE):
return get_lang_text(self.task_text, lang)
def is_text_json(self):
return check_json(self.task_text)
@property
def max_students_on_task(self):
return self.max_students or self.course.max_students_per_task or settings.PYTHONTASK_MAX_USERS_PER_TASK
def user_can_take_task(self, user):
for task_taken in TaskTaken.objects.filter(task=self):
task_taken.update_status()
if user.is_anonymous():
return (False, 'Необходимо залогиниться')
if self.is_hidden:
return (False, 'Задача скрыта')
if not self.course.groups.filter(students=user).count():
return (False, u'Необходимо числиться в одной из групп курса')
if Task.objects.filter(parent_task=self).count() > 0:
return (False, u'')
if TaskTaken.objects.filter(task=self).filter(user=user).filter(
Q(
Q(status=TaskTaken.STATUS_TAKEN)
| Q(status=TaskTaken.STATUS_SCORED))).count() != 0:
return (False, u'')
if self.parent_task is not None:
tasks = Task.objects.filter(parent_task=self.parent_task)
if TaskTaken.objects.filter(user=user).filter(task__in=tasks) \
.exclude(status=TaskTaken.STATUS_CANCELLED) \
.exclude(status=TaskTaken.STATUS_DELETED) \
.count() > 0:
return (False, u'Вы уже взяли другую подзадачу из этой задачи')
max_not_scored_tasks = self.course.max_not_scored_tasks or \
settings.PYTHONTASK_MAX_TASKS_WITHOUT_SCORE_PER_STUDENT
if max_not_scored_tasks:
if TaskTaken.objects.filter(user=user) \
.filter(task__course=self.course) \
.filter(status=TaskTaken.STATUS_TAKEN).count() >= max_not_scored_tasks:
return (False, u'У вас слишком много неоцененных задач')
max_incomplete_tasks = self.course.max_incomplete_tasks or settings.PYTHONTASK_MAX_INCOMPLETE_TASKS
if max_incomplete_tasks:
all_scored = TaskTaken.objects.filter(user=user).filter(task__course=self.course) \
.filter(Q(Q(status=TaskTaken.STATUS_TAKEN) | Q(
status=TaskTaken.STATUS_SCORED)))
if sum(t.score != t.task.score_max
for t in all_scored) + 1 > max_incomplete_tasks:
return (False,
u'У вас слишком много не до конца доделанных задач')
max_students = self.max_students_on_task or settings.PYTHONTASK_MAX_USERS_PER_TASK
if max_students:
if TaskTaken.objects.filter(task=self).filter(
Q(
Q(status=TaskTaken.STATUS_TAKEN)
| Q(status=TaskTaken.STATUS_SCORED))).count(
) >= max_students:
return (False,
u'Задача не может быть взята более чем %d студентами' %
max_students)
try:
task_taken = TaskTaken.objects.filter(task=self).filter(
user=user).get(status=TaskTaken.STATUS_BLACKLISTED)
blacklist_expired_date = task_taken.blacklisted_till
if blacklist_expired_date:
return (False, u'Вы сможете взять эту задачу с %s' %
blacklist_expired_date.strftime("%d.%m.%Y"))
except TaskTaken.DoesNotExist:
pass
return (True, u'')
def user_can_cancel_task(self, user):
if user.is_anonymous() or self.is_hidden:
return False
if TaskTaken.objects.filter(task=self).filter(user=user).filter(
status=TaskTaken.STATUS_TAKEN).count() != 0:
return True
return False
def user_can_score_task(self, user):
if user.is_anonymous():
return False
return self.course.user_is_teacher(user)
def user_can_pass_task(self, user):
if user.is_anonymous():
return False
if not self.course.is_python_task:
if self.user_can_take_task(user):
return True
try:
task_taken = self.get_task_takens().get(user=user)
return (task_taken.status == TaskTaken.STATUS_TAKEN
or task_taken.status == TaskTaken.STATUS_SCORED)
except TaskTaken.DoesNotExist:
return False
return False
def has_parent(self):
return self.parent_task is not None
def has_subtasks(self):
return Task.objects.filter(parent_task=self).count() > 0
def get_subtasks(self):
return Task.objects.filter(parent_task=self)
def get_task_takens(self):
return TaskTaken.objects.filter(task=self).filter(
Q(
Q(status=TaskTaken.STATUS_TAKEN)
| Q(status=TaskTaken.STATUS_SCORED)))
def add_user_properties(self, user):
self.can_take = self.user_can_take_task(user)
self.can_cancel = self.user_can_cancel_task(user)
self.can_score = self.user_can_score_task(user)
self.can_pass = self.user_can_pass_task(user)
self.is_shown = not self.is_hidden or self.course.user_is_teacher(user)
def has_issue_access(self):
return self.type not in [
self.TYPE_SIMPLE, self.TYPE_MATERIAL, self.TYPE_SEMINAR
]
def set_position_in_new_group(self, groups=None):
if not groups:
groups = self.course.groups.all()
else:
for task_related in TaskGroupRelations.objects.filter(
task=self).exclude(group__in=groups):
task_related.deleted = True
task_related.save()
for group in list(groups):
task_related, created = TaskGroupRelations.objects.get_or_create(
task=self, group=group)
if created:
max_position = TaskGroupRelations.objects.filter(group=group).exclude(id=task_related.id) \
.aggregate(Max('position'))['position__max']
task_related.position = max_position + 1 if max_position is not None else 0
else:
task_related.deleted = False
task_related.save()
def get_url_in_course(self):
return reverse('courses.views.seminar_page',
kwargs={
'course_id': self.course_id,
'task_id': self.id
})
class TaskLog(models.Model):
title = models.CharField(max_length=191,
db_index=True,
null=True,
blank=True)
course = models.ForeignKey(Course, db_index=False, null=False, blank=False)
group = models.ForeignKey(Group,
db_index=False,
null=True,
blank=True,
default=None)
groups = models.ManyToManyField(Group,
null=False,
blank=False,
related_name='groups_log_set')
weight = models.IntegerField(db_index=False,
null=False,
blank=False,
default=0)
parent_task = models.ForeignKey('self',
db_index=True,
null=True,
blank=True,
related_name='parent_task_set')
task_text = models.TextField(null=True, blank=True, default=None)
score_max = models.IntegerField(db_index=False,
null=False,
blank=False,
default=0)
contest_integrated = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
rb_integrated = models.BooleanField(db_index=False,
null=False,
blank=False,
default=False)
TYPE_FULL = 'All'
TYPE_SIMPLE = 'Only mark'
TASK_TYPE_CHOICES = (
(TYPE_FULL, _(u's_obsuzhdeniem')),
(TYPE_SIMPLE, _(u'tolko_ocenka')),
)
type = models.CharField(db_index=False,
max_length=128,
choices=TASK_TYPE_CHOICES,
default=TYPE_FULL)
added_time = models.DateTimeField(auto_now_add=True, default=timezone.now)
update_time = models.DateTimeField(auto_now=True, default=timezone.now)
deadline_time = models.DateTimeField(auto_now=False,
null=True,
default=None)
updated_by = models.ForeignKey(User, db_index=False, null=True, blank=True)
contest_id = models.IntegerField(db_index=True,
null=False,
blank=False,
default=0)
problem_id = models.CharField(max_length=128,
db_index=True,
null=True,
blank=True)
def __unicode__(self):
return unicode(self.title)
class Migration(migrations.Migration):
initial = True
dependencies = [
('RequestOfQuotation', '0001_initial'),
('app', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Quotation',
fields=[
('quotation_id',
models.CharField(max_length=10,
primary_key=True,
serialize=False)),
('time_created', models.DateTimeField()),
('description',
models.TextField(blank=True, default=None, null=True)),
('total_price',
models.DecimalField(decimal_places=2,
default=Decimal('0.00'),
max_digits=10)),
('person_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='app.Person')),
('request_of_quotation_id',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='RequestOfQuotation.RequestOfQuotation')),
('vendor_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='app.Vendor')),
],
),
migrations.CreateModel(
name='QuotationItem',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('quantity', models.IntegerField()),
('unit_price',
models.DecimalField(decimal_places=2, max_digits=10)),
('total_price',
models.DecimalField(decimal_places=2, max_digits=10)),
('ref_id',
models.CharField(blank=True,
default=None,
max_length=20,
null=True)),
('item_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='app.Item')),
('quotation_id',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='Quotation.Quotation')),
],
),
migrations.AlterUniqueTogether(
name='quotationitem',
unique_together=set([('quotation_id', 'item_id')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('rbac', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=32, verbose_name='部门')),
],
),
migrations.CreateModel(
name='Host',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('hostname', models.CharField(max_length=32,
verbose_name='主机名')),
('ip', models.GenericIPAddressField(verbose_name='IP')),
('depart',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='app01.Department',
verbose_name='归属部门')),
],
),
migrations.CreateModel(
name='UserInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=32, verbose_name='用户名')),
('password', models.CharField(max_length=64,
verbose_name='密码')),
('email', models.CharField(max_length=32, verbose_name='邮箱')),
('phone', models.CharField(max_length=32,
verbose_name='联系方式')),
('level',
models.IntegerField(choices=[(1, 'T1'), (2, 'T2'), (3, 'T3')],
verbose_name='级别')),
('depart',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='app01.Department',
verbose_name='部门')),
('roles',
models.ManyToManyField(blank=True,
to='rbac.Role',
verbose_name='拥有的所有角色')),
],
options={
'abstract': False,
},
),
]
class CustomUser(AbstractUser):
some_field = models.IntegerField(default=0)
class Entry(models.Model):
value = models.FloatField()
year = models.IntegerField()
month = models.IntegerField()
timeSeries = models.ForeignKey('TimeSerie',on_delete=models.CASCADE)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Author',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('profile_picture', models.ImageField(upload_to='avatar')),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Post',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('blog_title', models.CharField(max_length=100)),
('job_title',
models.CharField(choices=[
('Associate Engineer', 'Associate Engineer'),
('Senior Engineer', 'Senior Engineer'),
('Team Leader', 'Team Leader'),
('Project Architect', 'Project Architect'),
('Project Scrum Master', 'Project Scrum Master'),
('Project Delivery Manager', 'Project Delivery Manager')
],
max_length=100)),
('job_description', models.TextField(max_length=3000)),
('skills', models.TextField(max_length=3000)),
('thumbnail', models.ImageField(upload_to='thumbnail')),
('featured', models.BooleanField()),
('experience',
models.CharField(choices=[('Fresher', 'Fresher'),
('Experienced', 'Experienced')],
max_length=100)),
('employment_type',
models.CharField(choices=[('Full-time', 'Full-time'),
('Part-time', 'Part-time')],
max_length=100)),
('vacancy', models.IntegerField(default=0)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('job_status',
models.CharField(choices=[('Active', 'Active'),
('Expired', 'Expired')],
max_length=100)),
('author',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='posts.Author')),
('next_post',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='next',
to='posts.Post')),
('previous_post',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='previous',
to='posts.Post')),
],
),
migrations.CreateModel(
name='PostView',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('post',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='posts.Post')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
]
class SurBingUser(AbstractUser):
cart = models.ForeignKey('surBing.Cart', on_delete=models.PROTECT,
related_name='cart', blank=True, null=True)
age = models.IntegerField(blank=True, null=True)
gender = models.CharField(max_length=1, blank=True, null=True)
point = models.IntegerField(blank=True, null=True)
class DB(models.Model):
title = models.CharField(max_length=200)
content = models.TextField()
view_count = models.IntegerField(default=0)
created_at = models.DateTimeField(auto_now_add=True)
updated_at = models.DateTimeField(auto_now=True)
class Migration(migrations.Migration):
dependencies = [
('lite', '0027_auto_20180326_0931'),
]
operations = [
migrations.CreateModel(
name='Gallery',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('name',
models.CharField(
default=b'',
max_length=100,
null=True,
verbose_name='\u5c0f\u7a0b\u5e8f\u663e\u793a\u540d\u79f0',
blank=True)),
('name_admin',
models.CharField(
default=b'',
max_length=100,
null=True,
verbose_name='\u540e\u53f0\u663e\u793a\u540d\u79f0',
blank=True)),
('is_top',
models.IntegerField(default=1,
verbose_name='\u662f\u5426\u6307\u5b9a',
choices=[(0, '\u4e0d\u7f6e\u9876'),
(1, '\u7f6e\u9876')])),
('is_show',
models.IntegerField(default=1,
verbose_name='\u662f\u5426\u663e\u793a',
choices=[(0, '\u9690\u85cf'),
(1, '\u663e\u793a')])),
('is_alive',
models.IntegerField(default=1,
verbose_name='\u662f\u5426\u6709\u6548',
choices=[(0, '\u5931\u6548'),
(1, '\u6fc0\u6d3b')])),
('serial',
models.IntegerField(default=0, verbose_name='\u6392\u5e8f')),
('issue_time',
models.DateTimeField(
default=django.utils.timezone.now,
verbose_name='\u53d1\u5e03\u65f6\u95f4')),
('create_time',
models.DateTimeField(
default=django.utils.timezone.now,
verbose_name='\u521b\u5efa\u65f6\u95f4')),
('url',
models.CharField(max_length=1000,
null=True,
verbose_name='\u4e91\u5730\u5740',
blank=True)),
('style',
models.IntegerField(default=1,
verbose_name='\u7c7b\u522b',
choices=[(1, '\u97f3\u9891'),
(2, '\u89c6\u9891')])),
('local_path',
models.ImageField(default=b'',
upload_to=b'static/img/',
null=True,
verbose_name='\u56fe\u6807',
blank=True)),
('app',
models.ForeignKey(
default=1,
verbose_name='\u6240\u5c5e\u5c0f\u7a0b\u5e8f',
to='lite.App')),
('user',
models.ForeignKey(verbose_name='\u6240\u5c5e\u7528\u6237',
blank=True,
to='lite.User',
null=True)),
],
options={
'verbose_name': '\u80cc\u666f',
'verbose_name_plural': '\u80cc\u666f',
},
),
migrations.CreateModel(
name='Stage',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('name',
models.CharField(
default=b'',
max_length=100,
null=True,
verbose_name='\u5c0f\u7a0b\u5e8f\u663e\u793a\u540d\u79f0',
blank=True)),
('name_admin',
models.CharField(
default=b'',
max_length=100,
null=True,
verbose_name='\u540e\u53f0\u663e\u793a\u540d\u79f0',
blank=True)),
('is_top',
models.IntegerField(default=1,
verbose_name='\u662f\u5426\u6307\u5b9a',
choices=[(0, '\u4e0d\u7f6e\u9876'),
(1, '\u7f6e\u9876')])),
('is_show',
models.IntegerField(default=1,
verbose_name='\u662f\u5426\u663e\u793a',
choices=[(0, '\u9690\u85cf'),
(1, '\u663e\u793a')])),
('is_alive',
models.IntegerField(default=1,
verbose_name='\u662f\u5426\u6709\u6548',
choices=[(0, '\u5931\u6548'),
(1, '\u6fc0\u6d3b')])),
('serial',
models.IntegerField(default=0, verbose_name='\u6392\u5e8f')),
('issue_time',
models.DateTimeField(
default=django.utils.timezone.now,
verbose_name='\u53d1\u5e03\u65f6\u95f4')),
('create_time',
models.DateTimeField(
default=django.utils.timezone.now,
verbose_name='\u521b\u5efa\u65f6\u95f4')),
('config',
models.TextField(null=True,
verbose_name='\u914d\u7f6e',
blank=True)),
('app',
models.ForeignKey(
default=1,
verbose_name='\u6240\u5c5e\u5c0f\u7a0b\u5e8f',
to='lite.App')),
('background',
models.ForeignKey(verbose_name='\u80cc\u666f\u56fe\u7247',
blank=True,
to='pvp.Gallery',
null=True)),
],
options={
'verbose_name': '\u821e\u53f0',
'verbose_name_plural': '\u821e\u53f0',
},
),
]
class DepartmentPostion(models.Model):
id = models.IntegerField(primary_key=True)
department = models.CharField(max_length=20)
position = models.CharField(max_length=20)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name="Game",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=100)),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="Match",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("round", models.IntegerField()),
("seed", models.IntegerField()),
("completed", models.BooleanField(default=False)),
("bye", models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name="Team",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=100)),
],
options={
"abstract": False,
},
),
migrations.CreateModel(
name="TeamTourney",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("seed", models.IntegerField()),
("eliminated", models.BooleanField(default=False)),
(
"team",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="tourney.Team"),
),
],
),
migrations.CreateModel(
name="Tourney",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("name", models.CharField(max_length=100)),
("current_round", models.IntegerField(default=0)),
(
"status",
models.CharField(
choices=[("S", "Setup"), ("R", "Running"),
("F", "Finished")],
default="S",
max_length=5,
),
),
(
"admin",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
(
"game",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="tourney.Game"),
),
(
"teams",
models.ManyToManyField(through="tourney.TeamTourney",
to="tourney.Team"),
),
],
options={
"abstract": False,
},
),
migrations.AddField(
model_name="teamtourney",
name="tourney",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="tourney.Tourney"),
),
migrations.CreateModel(
name="Set",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
("team1_score", models.IntegerField()),
("team2_score", models.IntegerField()),
(
"match",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="tourney.Match"),
),
],
options={
"abstract": False,
},
),
migrations.AddField(
model_name="match",
name="team1",
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="team1",
to="tourney.TeamTourney",
),
),
migrations.AddField(
model_name="match",
name="team2",
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="team2",
to="tourney.TeamTourney",
),
),
migrations.AddField(
model_name="match",
name="tourney",
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="tourney.Tourney"),
),
migrations.AddField(
model_name="match",
name="winner",
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="winner",
to="tourney.TeamTourney",
),
),
migrations.AlterUniqueTogether(
name="teamtourney",
unique_together={("team", "tourney")},
),
migrations.AlterUniqueTogether(
name="match",
unique_together={("round", "tourney", "team1", "team2")},
),
migrations.CreateModel(
name="Competitor",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("created_at", models.DateTimeField(auto_now_add=True)),
("updated_at", models.DateTimeField(auto_now=True)),
(
"team",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to="tourney.Team"),
),
(
"user",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL,
),
),
],
options={
"unique_together": {("user", "team")},
},
),
]
class WebDjanjoHqPerson(models.Model):
id = models.IntegerField(primary_key=True)
class Meta:
managed = True
db_table = 'web_djanjo.hq_person'
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Comment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('author_name', models.CharField(max_length=12)),
('timestamp',
models.DateTimeField(default=django.utils.timezone.now)),
('ups', models.IntegerField(default=0)),
('downs', models.IntegerField(default=0)),
('score', models.IntegerField(default=0)),
('raw_comment', models.TextField(blank=True)),
('html_comment', models.TextField(blank=True)),
('lft',
models.PositiveIntegerField(db_index=True, editable=False)),
('rght',
models.PositiveIntegerField(db_index=True, editable=False)),
('tree_id',
models.PositiveIntegerField(db_index=True, editable=False)),
('level',
models.PositiveIntegerField(db_index=True, editable=False)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Submission',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('author_name', models.CharField(max_length=12)),
('title', models.CharField(max_length=250)),
('url', models.URLField(blank=True, null=True)),
('text', models.TextField(blank=True, max_length=5000)),
('text_html', models.TextField(blank=True)),
('ups', models.IntegerField(default=0)),
('downs', models.IntegerField(default=0)),
('score', models.IntegerField(default=0)),
('timestamp',
models.DateTimeField(default=django.utils.timezone.now)),
('comment_count', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='Subreddit',
fields=[
('admin_name', models.CharField(max_length=12)),
('title', models.CharField(max_length=60)),
('description', models.TextField(max_length=1000)),
('timestamp',
models.DateTimeField(default=django.utils.timezone.now)),
('name_id',
models.CharField(max_length=30,
primary_key=True,
serialize=False)),
('http_link', models.TextField()),
('sub_count', models.PositiveIntegerField(default=0)),
],
),
migrations.CreateModel(
name='Vote',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('vote_object_id', models.PositiveIntegerField()),
('value', models.IntegerField(default=0)),
('submission',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='reddit.Submission')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('sortament', '0020_auto_20181029_1643'),
]
operations = [
migrations.RemoveField(
model_name='gost_sortamenta',
name='Gost_naz',
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='nomer_dvutavra',
field=models.IntegerField(verbose_name='Номер'),
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='radius_vnutrennego_zakrugleniya_R',
field=models.FloatField(verbose_name='Радиус внут'),
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='radius_zakrugleniya_polki_r',
field=models.FloatField(verbose_name='Радиус зак полки'),
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='shirina_pilki_b',
field=models.IntegerField(verbose_name='Ширина'),
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='srednyaya_tolsina_polki_t',
field=models.FloatField(verbose_name='Сред толщ'),
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='tolshina_stenki_s',
field=models.FloatField(verbose_name='Толщина'),
),
migrations.AlterField(
model_name='dvutavr_gost_8239_89',
name='vysota_h',
field=models.IntegerField(verbose_name='Высота'),
),
migrations.AlterField(
model_name='gost_sortamenta',
name='GOST',
field=models.CharField(max_length=250, verbose_name='Название ГОСТа'),
),
migrations.AlterField(
model_name='gost_sortamenta',
name='img_gost',
field=models.ImageField(upload_to='sortament/', verbose_name='Изображение'),
),
migrations.AlterField(
model_name='gost_sortamenta',
name='type',
field=models.CharField(choices=[('Труба', 'Труба'), ('Двутавр', 'Двутавр')], max_length=250, verbose_name='Тип проката'),
),
]
class Estrategia(models.Model):
Estrategia_id = models.IntegerField(default=0)
Hay_estrategia_asignaturas = models.BooleanField(default=False)
Hay_estrategia_posgrado = models.BooleanField(default=False)
Descripcion = models.TextField(default="", blank=True, null=True)
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Node',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(blank=True, max_length=30)),
('email', models.EmailField(default=None, max_length=254, null=True)),
('address', models.CharField(max_length=255)),
('code', models.IntegerField()),
('oauth', django.contrib.postgres.fields.jsonb.JSONField(blank=True, null=True)),
('active', models.BooleanField(default=True)),
('co_owners', models.ManyToManyField(related_name='owners', to=settings.AUTH_USER_MODEL)),
('managers', models.ManyToManyField(limit_choices_to={'is_manager': True}, related_name='managers', to=settings.AUTH_USER_MODEL)),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='owner', to=settings.AUTH_USER_MODEL)),
('workers', models.ManyToManyField(related_name='workers', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Partner',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('street_address', models.CharField(max_length=255)),
('email', models.EmailField(blank=True, max_length=254)),
('active', models.BooleanField(default=True)),
('other_names', django.contrib.postgres.fields.ArrayField(base_field=models.CharField(max_length=50), blank=True, null=True, size=None)),
('of_node', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='business_logic.Node')),
],
),
migrations.CreateModel(
name='Order',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('html', models.TextField(blank=True)),
('result', models.CharField(blank=True, max_length=20)),
('source', models.CharField(blank=True, max_length=30)),
('customer_phone', models.CharField(max_length=30)),
('order_number', models.CharField(max_length=200, unique=True)),
('name', models.CharField(max_length=200)),
('address', models.CharField(max_length=300)),
('deliver_by', models.CharField(max_length=200)),
('entry_date', models.DateTimeField(auto_now_add=True)),
('total_price', models.DecimalField(decimal_places=2, max_digits=6)),
('tip', models.DecimalField(decimal_places=2, max_digits=6)),
('delivery_fee', models.DecimalField(decimal_places=2, max_digits=6)),
('note', models.CharField(blank=True, max_length=300)),
('in_progress', models.BooleanField(default=False)),
('complete', models.BooleanField(default=False)),
('completed_time', models.DateTimeField(blank=True, null=True)),
('assigned_to', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='assigned_user', to=settings.AUTH_USER_MODEL)),
('store', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='store', to='business_logic.Partner')),
],
),
]
class Books_purchsed (models.Model):
trans_id = models.IntegerField(verbose_name="Transaction ID")
