class Lane(models.Model): library = models.ForeignKey(Library, on_delete=models.PROTECT) machine = models.ForeignKey(Machine, on_delete=models.PROTECT) flowcell = models.CharField(max_length=32) rundate = models.DateField() reads = models.IntegerField(null=True, blank=True) passedpf = models.IntegerField(null=True, blank=True) lanenum = models.IntegerField() flowlane = models.IntegerField() paired = models.BooleanField(default=False) readlength = models.IntegerField(null=True, blank=True) mapped = models.IntegerField(null=True, blank=True) facility = models.ForeignKey(Facility, on_delete=models.PROTECT) seqsamplepf = models.TextField(blank=True) seqsamplebad = models.TextField(blank=True) qualmeanpf = dbarray.FloatArrayField(null=True) qualstdevpf = dbarray.FloatArrayField(null=True) qualmean = dbarray.FloatArrayField(null=True) qualstdev = dbarray.FloatArrayField(null=True) summaryurl = models.CharField(max_length=1024, null=True, blank=True) genomicssampleid = models.CharField(max_length=32, null=True, blank=True) usersampleid = models.CharField(max_length=1024, null=True, blank=True) notes = models.TextField(null=True, blank=True) failed = models.BooleanField(default=False) runnumber = models.CharField(null=True, blank=True, max_length=255) status = models.ForeignKey(Status, on_delete=models.PROTECT) external_records = models.ManyToManyField(ExternalRecord, db_table='lane_external_record', related_name='lanes') objects = LaneManager() @property def total_passedpf(self): if self.paired and self.passedpf is not None: return self.passedpf * 2 else: return self.passedpf @property def total_reads(self): if self.paired and self.reads is not None: return self.reads * 2 else: return self.reads @property def name(self): return "%s%02d" % (self.facility, self.lanenum) @property def notes_formatted(self): if self.notes is None: return '' else: return "\n".join(self.notes.split(";")) @property def model_parent(self): return self.library @property def is_published(self): return any([x.is_public for x in self.external_records.all()]) @property def public_records(self): return [x for x in self.external_records.all() if x.is_public] def __unicode__(self): return "%s_%s%02d" % (self.library, self.facility, self.lanenum) class Meta: db_table = u'lane' unique_together = ('library', 'lanenum', 'facility') ordering = ['library']
class Migration(migrations.Migration): dependencies = [ ('registration', '0081_merge_20181231_1518'), ('registration', '0080_cart'), ] operations = [ migrations.CreateModel( name='Charity', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200)), ('url', models.CharField(blank=True, help_text='Charity link', max_length=500, verbose_name='URL')), ], options={ 'abstract': False, }, ), migrations.AlterModelOptions( name='order', options={ 'permissions': (('issue_refund', 'Can create refunds'), ) }, ), migrations.RemoveField( model_name='cart', name='ipAddress', ), migrations.AddField( model_name='badge', name='printCount', field=models.IntegerField(default=0), ), migrations.AddField( model_name='event', name='badgeTheme', field=models.CharField( default='apis', help_text='Name of badge theme to use for printing', max_length=200, verbose_name='Badge Theme'), ), migrations.AddField( model_name='event', name='codeOfConduct', field=models.CharField( blank=True, default='/code-of-conduct', help_text='Link to code of conduct agreement', max_length=500, verbose_name='Code of Conduct'), ), migrations.AddField( model_name='event', name='collectAddress', field=models.BooleanField( default=True, help_text= 'Disable to skip collecting a mailing address for each attendee.', verbose_name='Collect Address'), ), migrations.AddField( model_name='event', name='collectBillingAddress', field=models.BooleanField( default=True, help_text= "Disable to skip collecting a billing address for each order. Note that a billing address and buyer email is required to qualify for Square's Chargeback protection.", verbose_name='Collect Billing Address'), ), migrations.AddField( model_name='event', name='dealerEmail', field=models.CharField( blank=True, default=b'*****@*****.**', help_text= 'Email to display on error messages for dealer registration', max_length=200, verbose_name='Dealer Email'), ), migrations.AddField( model_name='event', name='registrationEmail', field=models.CharField( blank=True, default=b'*****@*****.**', help_text= 'Email to display on error messages for attendee registration', max_length=200, verbose_name='Registration Email'), ), migrations.AddField( model_name='event', name='staffEmail', field=models.CharField( blank=True, default=b'*****@*****.**', help_text= 'Email to display on error messages for staff registration', max_length=200, verbose_name='Staff Email'), ), migrations.AddField( model_name='order', name='apiData', field=models.TextField(blank=True), ), migrations.AlterField( model_name='attendee', name='address1', field=models.CharField(blank=True, max_length=200), ), migrations.AlterField( model_name='attendee', name='city', field=models.CharField(blank=True, max_length=200), ), migrations.AlterField( model_name='attendee', name='country', field=models.CharField(blank=True, max_length=200), ), migrations.AlterField( model_name='attendee', name='postalCode', field=models.CharField(blank=True, max_length=20), ), migrations.AlterField( model_name='attendee', name='state', field=models.CharField(blank=True, max_length=200), ), migrations.AlterField( model_name='badge', name='attendee', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Attendee'), ), migrations.AlterField( model_name='cart', name='form', field=models.CharField(choices=[('Attendee', 'Attendee'), ('Staff', 'Staff'), ('Dealer', 'Dealer'), ('Dealer Assistant', 'Dealer Assistant')], max_length=50), ), migrations.AlterField( model_name='cart', name='transferedDate', field=models.DateTimeField(null=True), ), migrations.AlterField( model_name='cashdrawer', name='action', field=models.CharField(choices=[('Open', 'Open'), ('Close', 'Close'), ('Transaction', 'Transaction'), ('Deposit', 'Deposit')], default='Open', max_length=20), ), migrations.AlterField( model_name='dealer', name='event', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Event'), ), migrations.AlterField( model_name='dealer', name='tableSize', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='registration.TableSize'), ), migrations.AlterField( model_name='dealerasst', name='attendee', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Attendee'), ), migrations.AlterField( model_name='dealerasst', name='event', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Event'), ), migrations.AlterField( model_name='event', name='allowOnlineMinorReg', field=models.BooleanField( default=False, help_text= 'Allow registration for anyone age 13 and older online. Otherwise, registration is restricted to those 18 or older.', verbose_name='Allow online minor registration'), ), migrations.AlterField( model_name='event', name='attendeeRegEnd', field=models.DateTimeField( verbose_name='Attendee Registration End'), ), migrations.AlterField( model_name='event', name='attendeeRegStart', field=models.DateTimeField( verbose_name='Attendee Registration Start'), ), migrations.AlterField( model_name='event', name='dealerDiscount', field=models.ForeignKey( blank=True, help_text='Apply a discount for any dealer registrations', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='dealerEvent', to='registration.Discount', verbose_name='Dealer Discount'), ), migrations.AlterField( model_name='event', name='dealerRegEnd', field=models.DateTimeField(verbose_name='Dealer Registration End'), ), migrations.AlterField( model_name='event', name='dealerRegStart', field=models.DateTimeField( help_text='Start date and time for dealer applications', verbose_name='Dealer Registration Start'), ), migrations.AlterField( model_name='event', name='default', field=models.BooleanField( default=False, help_text= 'The first default event will be used as the basis for all current event configuration', verbose_name='Default'), ), migrations.AlterField( model_name='event', name='eventEnd', field=models.DateField(verbose_name='Event End Date'), ), migrations.AlterField( model_name='event', name='eventStart', field=models.DateField(verbose_name='Event Start Date'), ), migrations.AlterField( model_name='event', name='newStaffDiscount', field=models.ForeignKey( blank=True, help_text='Apply a discount for new staff registrations', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='newStaffEvent', to='registration.Discount', verbose_name='New Staff Discount'), ), migrations.AlterField( model_name='event', name='onlineRegEnd', field=models.DateTimeField( verbose_name='On-site Registration End'), ), migrations.AlterField( model_name='event', name='onlineRegStart', field=models.DateTimeField( help_text='Start time for /registration/onsite form', verbose_name='On-site Registration Start'), ), migrations.AlterField( model_name='event', name='staffDiscount', field=models.ForeignKey( blank=True, help_text='Apply a discount for any staff registrations', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='staffEvent', to='registration.Discount', verbose_name='Staff Discount'), ), migrations.AlterField( model_name='event', name='staffRegEnd', field=models.DateTimeField(verbose_name='Staff Registration End'), ), migrations.AlterField( model_name='event', name='staffRegStart', field=models.DateTimeField( help_text='(Not currently enforced)', verbose_name='Staff Registration Start'), ), migrations.AlterField( model_name='orderitem', name='priceLevel', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='registration.PriceLevel'), ), migrations.AlterField( model_name='staff', name='attendee', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Attendee'), ), migrations.AlterField( model_name='staff', name='event', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Event'), ), migrations.AlterField( model_name='tablesize', name='event', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='registration.Event'), ), migrations.AddField( model_name='event', name='charity', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='registration.Charity'), ), ]
class Migration(migrations.Migration): dependencies = [] operations = [ migrations.CreateModel( name='Character', fields=[ ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)), ('Name', models.CharField(max_length=100, blank=True, null=True)), ('Job', models.CharField(max_length=100, blank=True, null=True)), ], ), migrations.CreateModel( name='Game', fields=[ ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)), ('Name', models.CharField(max_length=100, blank=True, null=True)), ('Year', models.DateField()), ('GamePage', models.URLField(blank=True, null=True)), ('VideoLink', models.URLField(blank=True, null=True)), ('Publisher', models.CharField(max_length=100, blank=True, null=True)), ], ), migrations.CreateModel( name='Movie', fields=[ ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)), ('Name', models.CharField(max_length=100, blank=True, null=True)), ('DirectorName', models.CharField(max_length=100, blank=True, null=True)), ('TrailerLink', models.URLField(blank=True, null=True)), ('Year', models.DateField()), ('ImdbPoint', models.CharField(max_length=10, blank=True, null=True)), ('isCartoon', models.BooleanField()), ('Charecters', models.ManyToManyField(to='starwars.Character')), ], ), ]
class PerformanceMetric(models.Model): id = models.AutoField(primary_key=True) name = models.CharField(max_length=100) description = models.TextField(null=True, blank=True)
class Restaurant(models.Model): category = models.ForeignKey(Category, on_delete=models.SET_DEFAULT, default=3) # Category 모델 참조, on_delete-참조 모델 삭제시 행동 -> default 값으로 설정 한다. restaurant_name = models.CharField(max_length = 100) restaurant_link = models.CharField(max_length = 500) restaurant_content = models.TextField() restaurant_keyword = models.CharField(max_length = 50)
class YuanDongOrder(models.Model): key = models.CharField(max_length=100, blank=True, verbose_name='用户编号') shop_name = models.CharField(max_length=100, default="上海一汽丰田元东") server_sa = models.CharField( max_length=100, blank=True, verbose_name='服务专员') order_id = models.CharField( max_length=100, blank=True, verbose_name='订单编号') input_time = models.CharField( max_length=100, blank=True, verbose_name='订单日期') nickname = models.CharField( max_length=100, blank=True, verbose_name='客户姓名') mobile = models.CharField(max_length=100, blank=True, verbose_name='客户手机号') plate_number = models.CharField( max_length=100, blank=True, verbose_name='车牌号') vin_number = models.CharField( max_length=100, blank=True, verbose_name='vin') money = models.CharField(max_length=30, blank=True, verbose_name='费用') repair_type = models.CharField( max_length=30, blank=True, verbose_name='维修类型') item = models.TextField(blank=True, verbose_name='维修项目') #material = models.TextField(blank=True, verbose_name='维修零件') #mileage = models.CharField(max_length=100, default='0', verbose_name='出厂公里') push = models.BooleanField(default=False, verbose_name='推送状态') error = models.BooleanField(default=False, verbose_name='推送结果') def __str__(self): return self.order_id class Meta: verbose_name = '维修工单' verbose_name_plural = '维修工单'
class Courses(models.Model): name = models.CharField(max_length=255) desc = models.TextField() created_at = models.DateTimeField(auto_now_add=True)
class Project(models.Model): client = models.ForeignKey(Profile, on_delete=models.CASCADE, related_name="client", null=True, blank=True) dev = models.ForeignKey(Profile, on_delete=models.CASCADE, related_name="dev") title = models.CharField(max_length=50)
class Page(models.Model): project = models.ForeignKey(Project, on_delete=models.CASCADE) title = models.CharField(max_length=50)
class Quest(models.Model): """ A django model representing a persistant quest bound to a user relation. """ relation = models.ForeignKey(Relation) title = models.CharField(max_length=60) description = models.TextField(blank=True) creation_date = models.DateTimeField(auto_now_add=True) activation_date = models.DateTimeField(blank=True, null=True) deadline = models.DateTimeField(blank=True, null=True) RATINGS = ( (1, '*'), (2, '**'), (3, '***'), (4, '****'), (5, '*****'), ) #: Used to rated the degree of challenge associated with the quest. rating = models.PositiveSmallIntegerField(default=1, max_length=1, choices=RATINGS) bomb = models.BooleanField() # used to flag obligatory quests STATUS = ( ('C', 'created'), ('A', 'accepted'), ('R', 'declined'), ('M', 'marked complete'), ('D', 'done'), ('F', 'failed'), ('X', 'deleted'), ) status = models.CharField(default='C', max_length=1, choices=STATUS) objects = QuestManager() # custom django quest manager def __unicode__(self): """Returns the unicode string representation of the quest.""" return self.title def get_absolute_url(self): """Returns the absolute url of the quest as a string.""" return reverse('quests:detail', args=[self.pk]) def is_active(self): """Returns True if this quest is active, False otherwise.""" return self.status in ('A') def set_active(self): """Activates the quest and updates its activation date.""" self.activation_date = timezone.now() self.status = 'A' def activate(self): """ Activates the quest, updates it's activation date and sets the deadline to 7 days after activation. """ self.status = 'A' self.activation_date = timezone.now() self.deadline = timezone.now()+timedelta(days=7) def is_overdue(self): """ Checks if the quest is overdue. True if overdue. False if not. """ today = timezone.now().date() deadline = self.deadline if deadline and today > deadline.date(): return True else: return False def fail(self): """ Fails the quest, updates the relation balance if it was a forced quest and informs owner and quester. """ deduction = 0 loss_message = "" if self.bomb: if self.relation.balance >= self.rating: self.relation.balance -= self.rating self.relation.save() deduction = self.rating loss_message = "You lost %s carrot%s." % (deduction, "s"[deduction==1:]) else: defuction = self.relation.balance self.status = 'F' self.save() # notify owner pm_write( sender=self.relation.quester, recipient=self.relation.owner, subject="Quest %s has failed. %s lost %s carrot%s." % ( self.title, self.relation.quester.title(), deduction, "s"[deduction==1:]), body="" ) # notify quester pm_write( sender=self.relation.owner, recipient=self.relation.quester, subject="Quest %s has failed. %s" % (self.title, loss_message), body="" ) def get_deadline_html(self): """Returns the color coded html representation of the quest deadline as a string.""" if not self.deadline: return "-" today = timezone.now().date() deadline = self.deadline.date() warning_days = 1 template = '<span id="deadline-%s">%s</span>' html = "" # render date in color depending on time left if today == deadline: # due html = template % ("due", deadline) elif today < deadline: # not yet due if (deadline - today).days <= warning_days: # soon due html = template % ("soon-due", deadline) else: # not due html = template % ("not-due", deadline) else: # over due html = template % ("over-due", deadline) return mark_safe(html) def get_rating_html(self): """ Returns the html representation of the quest rating as a string. The code displays 1-5 carrot images and a bomb image if the quest bomb flag is set. """ rating = self.rating img_html = '<img src=%simages/carrot.png>' % settings.STATIC_URL html = "" if rating <= 5: html = img_html * rating else: html = '%s x %s' % (img_html, rating) if self.bomb: html += " " + self.get_bomb_html() return mark_safe(html) def get_bomb_html(self): """ Returns the html representation of the quest bomb flag as a string. The code contains is an image path for the bomb or an empty string. """ bomb = self.bomb img_html = '<img src=%simages/bomb.png>' % settings.STATIC_URL html = "" if bomb: html = img_html return mark_safe(html) def get_description_html(self): """Returns the quest description as a string or a hyphen if not set.""" if self.description: return self.description else: return "-"
class Profile(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) full_name = models.CharField(max_length=50) email = models.EmailField(max_length=50, unique=True) user_type = models.CharField(max_length=10, choices=TYPES)
class Item(models.Model): name = models.CharField(max_length=50) desc = models.TextField() def __str__(self): return self.name
class Customer(models.Model): user = models.OneToOneField(User, on_delete=models.CASCADE) phone = models.CharField(max_length=12, blank=True) shipping_address = models.CharField(max_length=100, blank=True)
class Task(models.Model): title = models.CharField(max_length=256) desc = models.TextField(blank=True) def set_date_or_time(self, op_class, v, op_code): if v is None: return op = op_class() op.op_code = op_code op.task = self op.value = v op.save() def set_date(self, d, op_code): self.set_date_or_time(TaskDateOperation, d, op_code) def set_time(self, d, op_code): self.set_date_or_time(TaskTimeOperation, d, op_code) def get_operation_value(self, op_class, op_code): ops = op_class.objects.filter(task=self, op_code=op_code).order_by('created') if ops: return ops[0].value return None def get_date_operation_value(self, op_code): return self.get_operation_value(TaskDateOperation, op_code) def get_time_operation_value(self, op_code): return self.get_operation_value(TaskTimeOperation, op_code) @property def date_sp(self): return self.get_date_operation_value(TaskOperation.OP_SET_STR_PLAN) @property def date_ep(self): return self.get_date_operation_value(TaskOperation.OP_SET_END_PLAN) @property def date_sa(self): return self.get_date_operation_value(TaskOperation.OP_SET_STR_ACTU) @property def date_ea(self): return self.get_date_operation_value(TaskOperation.OP_SET_END_ACTU) @property def time_sp(self): return self.get_time_operation_value(TaskOperation.OP_SET_STR_PLAN) @property def time_ep(self): return self.get_time_operation_value(TaskOperation.OP_SET_END_PLAN) @property def time_sa(self): return self.get_time_operation_value(TaskOperation.OP_SET_STR_ACTU) @property def time_ea(self): return self.get_time_operation_value(TaskOperation.OP_SET_END_ACTU) def __unicode__(self): return self.title
class Patient(models.Model): name = models.CharField(max_length=100) medications = models.ManyToManyField(Medication, related_name='medications', blank=True)
class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name='Course', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50, verbose_name='\u8bfe\u7a0b\u540d')), ('desc', models.CharField(max_length=300, verbose_name='\u8bfe\u7a0b\u63cf\u8ff0')), ('detail', models.TextField(verbose_name='\u8bfe\u7a0b\u8be6\u60c5')), ('degree', models.CharField(choices=[('cj', '\u521d\u7ea7'), ('zj', '\u4e2d\u7ea7'), ('gj', '\u9ad8\u7ea7')], max_length=2)), ('learn_times', models.IntegerField( default=0, verbose_name='\u5b66\u4e60\u65f6\u957f(\u5206\u949f\u6570)' )), ('students', models.IntegerField(default=0, verbose_name='\u5b66\u4e60\u4eba\u6570')), ('fav_nums', models.IntegerField(default=0, verbose_name='\u6536\u85cf\u4eba\u6570')), ('image', models.ImageField(upload_to='courses/%Y/%m', verbose_name='\u5c01\u9762\u56fe')), ('click_nums', models.IntegerField(default=0, verbose_name='\u70b9\u51fb\u6570')), ('add_time', models.DateTimeField( default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')), ], options={ 'verbose_name': '\u8bfe\u7a0b', 'verbose_name_plural': '\u8bfe\u7a0b', }, ), migrations.CreateModel( name='CourseResource', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, verbose_name='\u540d\u79f0')), ('download', models.FileField(upload_to='course/resource/%Y/%m', verbose_name='\u8d44\u6e90\u6587\u4ef6')), ('add_time', models.DateTimeField( default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.Course', verbose_name='\u8bfe\u7a0b')), ], options={ 'verbose_name': '\u8bfe\u7a0b\u8d44\u6e90', 'verbose_name_plural': '\u8bfe\u7a0b\u8d44\u6e90', }, ), migrations.CreateModel( name='Lesson', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, verbose_name='\u7ae0\u8282\u540d')), ('add_time', models.DateTimeField( default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.Course', verbose_name='\u8bfe\u7a0b')), ], options={ 'verbose_name': '\u7ae0\u8282', 'verbose_name_plural': '\u7ae0\u8282', }, ), migrations.CreateModel( name='Video', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, verbose_name='\u89c6\u9891\u540d')), ('add_time', models.DateTimeField( default=datetime.datetime.now, verbose_name='\u6dfb\u52a0\u65f6\u95f4')), ('lesson', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.Lesson', verbose_name='\u7ae0\u8282')), ], options={ 'verbose_name': '\u89c6\u9891', 'verbose_name_plural': '\u89c6\u9891', }, ), ]
class Fornecedores(models.Model): name = models.CharField(max_length=50) products = models.ManyToManyField(Product) def __str__(self): return self.name + " " + self.products
class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='ProductsA', fields=[ ('code', models.BigIntegerField(primary_key=True, serialize=False)), ('url', models.CharField(max_length=250)), ('product_name', models.CharField(max_length=250)), ('nutrition_grade_fr', models.CharField(max_length=1)), ('main_category', models.CharField(max_length=250)), ('main_category_fr', models.CharField(max_length=250)), ('image_small_url', models.CharField(max_length=250)), ], options={ 'verbose_name': 'Produits A', 'db_table': 'products_A', 'managed': True, }, ), migrations.CreateModel( name='UserProducts', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('username', models.CharField(max_length=150)), ('code', models.BigIntegerField()), ('url', models.CharField(max_length=250)), ('product_name', models.CharField(max_length=250)), ('nutrition_grade_fr', models.CharField(max_length=1)), ('main_category', models.CharField(max_length=250)), ('main_category_fr', models.CharField(max_length=250)), ('image_small_url', models.CharField(max_length=250)), ], options={ 'verbose_name': 'Produits utilisateur', 'db_table': 'user_products', 'managed': True, }, ), ]
class Aleady(models.Model): key = models.CharField(max_length=100) value = models.CharField(max_length=100)
class User(AbstractUser): display_name = models.CharField(max_length=100, blank=True) about = models.TextField(blank=True)
class Post(models.Model): title = models.CharField(max_length=100) content = models.TextField() create_at = models.DateTimeField(auto_now_add=True) update_at = models.DateTimeField(auto_now=True)
class BackTest(models.Model): STATUS_CHOICES = (('DONE', 'DONE'), ('PROCESSING', 'PROCESSING'), ('ERROR', 'ERROR')) strategy = models.ForeignKey(Strategy) Profit = models.CharField(max_length=100, null=True) MaxDrawdown = models.CharField(max_length=100, null=True) Sharp = models.CharField(max_length=100, null=True) Profitfactor = models.CharField(max_length=100, null=True) Winrate = models.CharField(max_length=100, null=True) Std = models.CharField(max_length=100, null=True) Mean = models.CharField(max_length=100, null=True) Buynumber = models.CharField(max_length=100, null=True) Buyprofit = models.CharField(max_length=100, null=True) Sellnumber = models.CharField(max_length=100, null=True) Sellprofit = models.CharField(max_length=100, null=True) task = models.CharField(max_length=100, null=True) error_info = models.TextField(max_length=1000, null=True) status = models.CharField(choices=STATUS_CHOICES, max_length=50, default='PROCESSING')
class Category(models.Model): category_name = models.CharField(max_length = 100)
class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name='Car', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('year', models.CharField(max_length=100)), ('make', models.CharField(max_length=100)), ('model', models.CharField(max_length=100)), ('trim', models.CharField(max_length=100)), ], ), migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('username', models.CharField(max_length=80)), ('email', models.CharField(max_length=80)), ('password', models.CharField(max_length=80)), ], ), migrations.CreateModel( name='SellingFeatures', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('feat1', models.CharField(max_length=50)), ('feat2', models.CharField(max_length=50)), ('feat3', models.CharField(max_length=50)), ('feat4', models.CharField(max_length=50)), ('feat5', models.CharField(max_length=50)), ('feat6', models.CharField(max_length=50)), ('feat7', models.CharField(max_length=50)), ('feat8', models.CharField(max_length=50)), ('feat9', models.CharField(max_length=50)), ('feat10', models.CharField(max_length=50, null=True)), ('car', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='features', to='suresell.car')), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name='Book', fields=[ ('bo_id', models.PositiveIntegerField(primary_key=True, serialize=False, unique=True)), ('bo_name', models.CharField(max_length=30)), ('bo_price', models.DecimalField(decimal_places=2, max_digits=6)), ('bo_type', models.CharField(max_length=20)), ('bo_publisher', models.CharField(max_length=30)), ('bo_author', models.CharField(max_length=20)), ('bo_introduce', models.TextField()), ('bo_ptime', models.DateField(auto_now_add=True)), ('bo_operator', models.CharField(max_length=20)), ('bo_rukutime', models.DateField(auto_now_add=True)), ('bo_number', models.PositiveIntegerField()), ], options={ 'db_table': 't_book', }, ), migrations.CreateModel( name='Borrow', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('start_time', models.DateField(auto_now_add=True)), ('end_time', models.DateField(auto_now_add=True)), ('registrar', models.CharField(max_length=20)), ('book', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Book')), ], options={ 'db_table': 't_borrow', }, ), migrations.CreateModel( name='Clazz', fields=[ ('cla_id', models.PositiveIntegerField(primary_key=True, serialize=False)), ('cla_name', models.CharField(max_length=20, unique=True)), ], options={ 'db_table': 't_clazz', }, ), migrations.CreateModel( name='Course', fields=[ ('cou_id', models.PositiveIntegerField(primary_key=True, serialize=False, unique=True)), ('cou_name', models.CharField(max_length=20, unique=True)), ], options={ 'db_table': 't_course', }, ), migrations.CreateModel( name='Grade', fields=[ ('gr_id', models.PositiveIntegerField(primary_key=True, serialize=False, unique=True)), ('gr_name', models.CharField(max_length=20, unique=True)), ], options={ 'db_table': 't_grade', }, ), migrations.CreateModel( name='HeadTeacher', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('rkDATE', models.CharField(max_length=50)), ('clazz', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='login.Clazz')), ], options={ 'db_table': 't_headTeacher', }, ), migrations.CreateModel( name='Major', fields=[ ('ma_id', models.PositiveIntegerField(primary_key=True, serialize=False, unique=True)), ('ma_name', models.CharField(max_length=20, unique=True)), ], options={ 'db_table': 't_major', }, ), migrations.CreateModel( name='Stu', fields=[ ('st_id', models.PositiveIntegerField(primary_key=True, serialize=False, unique=True)), ('st_name', models.CharField(max_length=10)), ('st_gender', models.CharField(max_length=10)), ('st_age', models.PositiveIntegerField()), ('st_nation', models.CharField(max_length=10)), ('st_political', models.CharField(max_length=10)), ('st_birth', models.DateField()), ('st_SFZ', models.CharField(max_length=20)), ('st_phone', models.CharField(max_length=20)), ('st_addr', models.TextField()), ('st_clazz', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Clazz')), ], options={ 'db_table': 't_stu', }, ), migrations.CreateModel( name='StuCourse', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('sc_score', models.DecimalField(decimal_places=1, max_digits=4)), ('sc_type', models.CharField(max_length=20)), ('cls', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Clazz')), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Course')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Stu')), ], options={ 'db_table': 't_stuCourse', }, ), migrations.CreateModel( name='StuRegister', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('start_score', models.PositiveIntegerField()), ('start_time', models.DateField()), ('clazz', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Clazz')), ('student', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='login.Stu')), ], options={ 'db_table': 't_stuRegister', }, ), migrations.CreateModel( name='Teacher', fields=[ ('te_id', models.PositiveIntegerField(primary_key=True, serialize=False, unique=True)), ('te_name', models.CharField(max_length=10)), ('te_gender', models.CharField(max_length=10)), ('te_age', models.PositiveIntegerField()), ('te_nation', models.CharField(max_length=10)), ('te_marriage', models.CharField(max_length=10)), ('te_political', models.CharField(max_length=10)), ('te_birth', models.DateField()), ('te_SFZ', models.PositiveIntegerField()), ('te_education', models.CharField(max_length=20)), ('te_phone', models.PositiveIntegerField()), ('work_content', models.TextField()), ('te_grade', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Grade')), ('te_major', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Major')), ], options={ 'db_table': 't_teacher', }, ), migrations.CreateModel( name='TeacherCourse', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('rkDATE', models.CharField(max_length=50)), ('lizhiDATE', models.CharField(max_length=50)), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Course')), ('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='login.Teacher')), ], options={ 'db_table': 't_teacherCourse', }, ), migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('user_name', models.CharField(max_length=20, unique=True)), ('user_pwd', models.CharField(max_length=20)), ], options={ 'db_table': 't_user', }, ), migrations.AddField( model_name='headteacher', name='teacher', field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='login.Teacher'), ), migrations.AddField( model_name='clazz', name='cla_grade', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='login.Grade'), ), migrations.AddField( model_name='clazz', name='cla_major', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='login.Major'), ), migrations.AddField( model_name='borrow', name='student', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='login.Stu'), ), ]
class Migration(migrations.Migration): dependencies = [ ('fit', '0011_heart2'), ] operations = [ migrations.CreateModel( name='Heart3', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('image_id', models.DateField(blank=True, verbose_name='イメージid')), ('heart_image_url', models.URLField(blank=True, verbose_name='心拍画像URL')), ], ), migrations.CreateModel( name='Sleep', fields=[ ('dateOfSleep', models.DateField(primary_key=True, serialize=False, verbose_name='睡眠日')), ('deep', models.DecimalField(decimal_places=2, default=0.0, max_digits=6, verbose_name='deep')), ('light', models.DecimalField(decimal_places=2, default=0.0, max_digits=6, verbose_name='light')), ('rem', models.DecimalField(decimal_places=2, default=0.0, max_digits=6, verbose_name='rem')), ('wake', models.DecimalField(decimal_places=2, default=0.0, max_digits=6, verbose_name='wake')), ('sleep_time', models.DecimalField(decimal_places=2, default=0.0, max_digits=6, verbose_name='sleep_time')), ('image_url', models.URLField(blank=True, verbose_name='画像URL')), ('bedtime', models.CharField(blank=True, max_length=23, verbose_name='就寝時刻')), ], ), migrations.CreateModel( name='Work3', fields=[ ('work_date', models.DateField(primary_key=True, serialize=False, verbose_name='作業日')), ('start_time', models.DateTimeField(null=True, verbose_name='開始時刻')), ('end_time', models.DateTimeField(null=True, verbose_name='終了時刻')), ('workhr', models.CharField(blank=True, max_length=10, verbose_name='勤務時間')), ('comment', models.CharField(blank=True, max_length=255, verbose_name='コメント')), ], ), migrations.AddField( model_name='heart3', name='heart_date', field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='fit.Sleep'), ), ]
class ToolPhoto(models.Model): url = models.CharField(max_length=200) tool = models.ForeignKey(Tool, on_delete=models.CASCADE) def __str__(self): return f"Photo for tool_id: {self.tool_id} @{self.url}"
class Medication(models.Model): name = models.CharField(max_length=100, unique=True)
class Order(models.Model): class Meta: managed = False db_table = 'ps17_orders' id_order = models.PositiveIntegerField(primary_key=True,editable=False,db_column=None) reference = models.CharField(max_length=255, blank=True, null=True,editable=False,) id_order_state = models.PositiveIntegerField(blank=True, null=True,editable=False,) order_state = models.CharField(max_length=255, blank=True, null=True,editable=False,) shipping_number = models.CharField(max_length=255, blank=True, null=True,editable=False,) firstname_customer = models.CharField(max_length=255, blank=True, null=True,editable=False,) lastname_customer = models.CharField(max_length=255, blank=True, null=True,editable=False,) note = models.TextField(blank=True, null=True,editable=False,) firstname = models.CharField(max_length=255, blank=True, null=True,editable=False,) lastname = models.CharField(max_length=255, blank=True, editable=False,) email = models.CharField(max_length=255, blank=True, editable=False,) postcode = models.CharField(max_length=255, blank=True, editable=False,) address1 = models.CharField(max_length=255, blank=True, editable=False,) address2 = models.CharField(max_length=255, blank=True, editable=False,) city = models.CharField(max_length=255, blank=True, editable=False,) phone = models.CharField(max_length=255, blank=True, editable=False,) country = models.CharField(max_length=255, blank=True, editable=False,) currency_code = models.CharField(max_length=3, blank=True, editable=False,) total_paid = models.FloatField(blank=True, editable=False,) total_products_wt = models.FloatField(blank=True, editable=False,) total_shipping_tax_incl = models.FloatField(blank=True, editable=False,) date_add = models.DateTimeField(blank=True, editable=False,) date_upd = models.DateTimeField(blank=True, editable=False,) id_country = models.PositiveIntegerField(blank=True, editable=False,) carrier = models.CharField(max_length=255, blank=True, editable=False,) is_new = models.PositiveIntegerField(blank=True, editable=False,) @staticmethod def SQL(one=False): sql = """ SELECT id_order, reference, o.current_state as id_order_state ,(select name from ps17_order_state_lang where id_lang=1 and id_order_state=o.current_state) order_state ,o.shipping_number ,c.firstname as firstname_customer, c.lastname as lastname_customer, c.note ,a.firstname, a.lastname ,c.email, a.postcode, a.address1, a.address2, a.city, a.phone ,(select name from ps17_country_lang where id_lang=1 and id_country=a.id_country) country ,iso_code as currency_code ,total_paid ,total_products_wt ,total_shipping_tax_incl,o.date_add,o.date_upd ,o.id_customer,o.id_address_delivery,a.id_country ,ca.name as carrier ,IF((SELECT so.id_order FROM `ps17_orders` so WHERE so.id_customer = o.id_customer AND so.id_order < o.id_order LIMIT 1) > 0, 0, 1) as is_new FROM `ps17_orders` o JOIN ps17_customer c on o.id_customer=c.id_customer JOIN ps17_address a on id_address_delivery=a.id_address join ps17_carrier ca on ca.id_carrier=o.id_carrier join ps17_currency cu on cu.id_currency=o.id_currency WHERE o.current_state in (2,3,17,20,21,31,39,40) """ if one: sql += " AND o.id_order=%s " else: sql += " ORDER BY id_order DESC " return sql
class Library(models.Model): code = models.CharField(max_length=128, unique=True, validators=[validate_library_code]) genome = models.ForeignKey( Genome, on_delete=models.PROTECT, help_text="The genome against which the sequence" + " data from this library should be aligned.") sample = models.ForeignKey(Sample, on_delete=models.PROTECT) antibody = models.ForeignKey(Antibody, on_delete=models.PROTECT, null=True, blank=True) factor = models.ForeignKey(Factor, on_delete=models.PROTECT, null=True, blank=True) condition = models.ForeignKey(Condition, on_delete=models.PROTECT, null=True, blank=True) bad = models.BooleanField(default=False) release_worthy = models.BooleanField(default=False) projects = models.ManyToManyField(Project, db_table='library_project', related_name='libraries') libtype = models.ForeignKey(Libtype, on_delete=models.PROTECT) barcode = models.CharField(max_length=32, null=True, blank=True) linkerset = models.ForeignKey(Linkerset, on_delete=models.PROTECT, null=True, blank=True) chipsample = models.CharField(max_length=255, null=True, blank=True) paired = models.BooleanField(default=False) adapter = models.ForeignKey(Adapter, on_delete=models.PROTECT, null=True, blank=True, related_name='libraries') adapter2 = models.ForeignKey(Adapter, on_delete=models.PROTECT, null=True, blank=True, related_name='libraries2') platecode = models.CharField(max_length=32, null=True, blank=True) platecol = models.IntegerField(null=True, blank=True) platerow = models.CharField(max_length=1, choices=[('A', 'A'), ('B', 'B'), ('C', 'C'), ('D', 'D'), ('E', 'E'), ('F', 'F'), ('G', 'G'), ('H', 'H')], null=True, blank=True) comment = models.TextField(null=True, blank=True) external_records = models.ManyToManyField( ExternalRecord, db_table='library_external_record', related_name='libraries') objects = LibraryManager() @property def filename_tag(self): """ On-the-fly replacement for the old library description field, with the library code included for completeness. """ fac = self.factor.name if self.factor else 'unk' ant = self.antibody.name if self.antibody else 'unk' ind = self.sample.name if self.sample.name != self.code else '' sta = self.sample.source.strain.name if self.sample.source.strain else '' tis = self.sample.tissue.name if self.condition is not None: tis = "%s_%s" % (tis, self.condition) gen = self.genome.code # Here we pull out unnecessary duplication of the tissue name # which may have been introduced when generating a new sample name # (see osqpipe.pipeline.library). ind = string.replace(ind, tis, '') # Try to strip out not just trailing space, but some other characters we might use at a later date. ind = re.sub('[- _/;:.,]$', '', ind) return ("%s_%s_%s_%s_%s%s%s" % (self.code, fac, tis, ant, gen, sta, ind)) def __unicode__(self): return self.code class Meta: db_table = u'library' verbose_name_plural = 'libraries' ordering = ['code']