ASJAzoauth/model/models.py

from django.db import models


# Create your models here.


class UserModel(models.Model):
    userID = models.CharField(blank=True, max_length=32, primary_key=True, unique=True, verbose_name='用户ID')
    region_code = models.CharField(default='US', max_length=8, verbose_name='用户地区')  # US, EU
    code = models.CharField(max_length=32, unique=True, default='', verbose_name='授权码')
    user_authorization_code = models.CharField(max_length=32, default='', verbose_name='用户授权码')
    access_token = models.CharField(max_length=64, unique=False, default='', verbose_name='访问令牌')
    refresh_token = models.CharField(max_length=64, unique=False, default='', verbose_name='刷新令牌')
    uid_rtsp = models.ManyToManyField(to='UidRtspModel', blank=True, verbose_name=u'用户关联uid_rtsp表',
                                      db_table='user_uid_rtsp')
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '用户表'
        db_table = 'user'

    def __str__(self):
        return self.userID


class UserCountModel(models.Model):
    id = models.AutoField(primary_key=True)
    skill_name = models.CharField(max_length=32, default='', verbose_name=u'skill名称')
    year_month = models.CharField(max_length=32, default='', verbose_name=u'统计时间/每月')
    amount = models.IntegerField(default=0, verbose_name=u'用户数量')

    class Meta:
        ordering = ('-id',)
        verbose_name = '用户数量统计表'
        db_table = 'user_count'

    def __str__(self):
        return self.userID


class UidRtspModel(models.Model):
    id = models.AutoField(primary_key=True)
    user_id = models.CharField(default='', max_length=32, verbose_name='关联用户表的userID')
    nick = models.CharField(max_length=32, verbose_name=u'设备昵称', default='')
    uid = models.CharField(max_length=20, verbose_name=u'设备UID', default='', unique=True)
    serial_number = models.CharField(default='', max_length=20, verbose_name='序列号')
    password = models.CharField(max_length=32, verbose_name=u'设备密码', default='')
    rtsp_url = models.CharField(max_length=128, verbose_name='rtsp流地址', default='')
    region = models.CharField(max_length=8, verbose_name='区域', default='CN')
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)

    class Meta:
        ordering = ('-addTime',)
        verbose_name = 'uid信息表'
        db_table = 'uid_rtsp'

    def __str__(self):
        return self.id


class SwitchModel(models.Model):
    id = models.AutoField(primary_key=True)
    nick = models.CharField(max_length=32, verbose_name=u'设备昵称', default='')
    serial_number = models.CharField(max_length=20, verbose_name=u'设备序列号', default='')
    userID = models.CharField(blank=True, max_length=32, verbose_name=u'用户ID')
    region = models.CharField(max_length=8, verbose_name='区域', default='EN')
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)

    class Meta:
        ordering = ('-addTime',)
        verbose_name = '智能插座表'
        db_table = 'switch_info'

    def __str__(self):
        return self.id


class AlexaAuthModel(models.Model):
    id = models.AutoField(primary_key=True)
    skill_name = models.CharField(max_length=32, default='', verbose_name=u'skill名称')
    userID = models.CharField(blank=True, max_length=32, verbose_name=u'用户ID', default='', unique=False)
    access_token = models.CharField(max_length=150, unique=False, default='', verbose_name='访问令牌')
    refresh_token = models.CharField(max_length=150, unique=False, default='', verbose_name='刷新令牌')
    token = models.CharField(max_length=150, unique=False, default='', verbose_name='区分用户token')
    expiresTime = models.IntegerField(verbose_name='过期时间', default=0)
    addTime = models.IntegerField(verbose_name='添加时间', default=0)
    updTime = models.IntegerField(verbose_name='更新时间', default=0)
    alexa_region = models.CharField(max_length=8, verbose_name='alexa区域', default='')

    class Meta:
        ordering = ('-addTime',)
        verbose_name = 'alexa授权表'
        db_table = 'alexa_auth'

    def __str__(self):
        return self.id


class iotdeviceInfoModel(models.Model):
    id = models.AutoField(primary_key=True)
    serial_number = models.CharField(default='', max_length=20, db_index=True, verbose_name='序列号')
    uid = models.CharField(default='', max_length=32, db_index=True, verbose_name='uid')
    certificate_id = models.CharField(default='', max_length=128, verbose_name='证书id')
    certificate_pem = models.TextField(default='', verbose_name='证书')
    public_key = models.TextField(default='', verbose_name='公钥')
    private_key = models.TextField(default='', verbose_name='私钥')
    thing_name = models.CharField(default='', max_length=64, db_index=True, verbose_name='物品名')
    thing_groups = models.CharField(default='', max_length=64, verbose_name='物品组')
    endpoint = models.CharField(default='', max_length=100, db_index=True, verbose_name='终端节点')
    token_iot_number = models.CharField(default='', db_index=True, max_length=50, verbose_name='签名令牌')
    add_time = models.DateTimeField(auto_now_add=True, verbose_name='添加时间')
    update_time = models.DateTimeField(auto_now=True, verbose_name='更新时间')

    class Meta:
        db_table = 'iot_deviceInfo'
        verbose_name = 'iot设备信息表'