🌈据说,看我文章时 关注、点赞、收藏 的 帅哥美女们 心情都会不自觉的好起来。
前言:
🧡作者简介:大家好我是 user_from_future ,意思是 “ 来自未来的用户 ” ,寓意着未来的自己一定很棒~
✨个人主页:点我直达,在这里肯定能找到你想要的~
👍专栏介绍:个人记账分析系统 ,专门记录制作过程,每天进步一点点~
想看往期历史文章,可以浏览此博文: 历史文章目录
,后续所有文章发布都会同步更新此博文~
设计模型类
这里采用django
做web框架,好处就是数据库能自动创建,数据能自动写入,舒服!技术创造懒人 技术迎合需求。
微信账单模型
除了交易时间是日期类型,所以用 models.DateTimeField
类型,其他都用 models.CharField
类型:
# _*_ coding:utf-8 _*_
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
class Wechat(models.Model):
trading_time = models.DateTimeField(null=True, blank=True, verbose_name='交易时间')
transaction_type = models.CharField(null=True, blank=True, verbose_name='交易类型', max_length=8)
other_trade = models.CharField(null=True, blank=True, verbose_name='交易对方', max_length=255)
goods = models.CharField(null=True, blank=True, verbose_name='商品', max_length=255)
in_out = models.CharField(null=True, blank=True, verbose_name='收/支', max_length=4)
amount = models.CharField(null=True, blank=True, verbose_name='金额(元)', max_length=11)
payment_method = models.CharField(null=True, blank=True, verbose_name='支付方式', max_length=22)
current_status = models.CharField(null=True, blank=True, verbose_name='当前状态', max_length=10)
transaction_order_number = models.CharField(blank=True, verbose_name='交易单号', max_length=255, primary_key=True)
business_order_number = models.CharField(null=True, blank=True, verbose_name='商户单号', max_length=255)
remarks = models.CharField(null=True, blank=True, verbose_name='备注', max_length=255)
owner = models.ForeignKey(User, models.CASCADE)
class Meta:
verbose_name = '微信账单流水'
verbose_name_plural = verbose_name
db_table = 'wechat'
ordering = ('-transaction_order_number',)
支付宝账单模型
和微信账单模型一样,除了交易时间是日期类型,所以用 models.DateTimeField
类型,其他都用 models.CharField
类型:
# _*_ coding:utf-8 _*_
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
class Alipay(models.Model):
in_out = models.CharField(null=True, blank=True, verbose_name='收/支', max_length=4)
trade_user = models.CharField(null=True, blank=True, verbose_name='交易对方', max_length=255)
other_account = models.CharField(null=True, blank=True, verbose_name='对方账号', max_length=255)
product_description = models.CharField(null=True, blank=True, verbose_name='商品说明', max_length=255)
in_out_method = models.CharField(null=True, blank=True, verbose_name='收/付款方式', max_length=22)
amount = models.CharField(null=True, blank=True, verbose_name='金额', max_length=11)
trading_status = models.CharField(null=True, blank=True, verbose_name='交易状态', max_length=10)
transactions_classification = models.CharField(null=True, blank=True, verbose_name='交易分类', max_length=8)
transaction_order_number = models.CharField(blank=True, verbose_name='交易订单号', max_length=255, primary_key=True)
business_order_number = models.CharField(null=True, blank=True, verbose_name='商家订单号', max_length=255)
trading_time = models.DateTimeField(null=True, blank=True, verbose_name='交易时间')
owner = models.ForeignKey(User, models.CASCADE)
class Meta:
verbose_name = '支付宝账单流水'
verbose_name_plural = verbose_name
db_table = 'alipay'
ordering = ('-transaction_order_number',)
用户设置模型
# _*_ coding:utf-8 _*_
from django.db import models
from django.contrib.auth.models import User
# Create your models here.
class Setting(models.Model):
name = models.CharField(verbose_name='姓名', max_length=10)
sex = models.CharField(verbose_name='性别', max_length=2)
heads = models.ImageField(verbose_name='头像')
wx_rules = models.TextField(verbose_name='微信收支规则')
zfb_rules = models.TextField(verbose_name='支付宝收支规则')
last_ip = models.GenericIPAddressField(verbose_name='上次登录IP地址')
owner = models.ForeignKey(User, models.CASCADE)
class Meta:
verbose_name = '用户设置'
verbose_name_plural = verbose_name
db_table = 'setting'
ordering = ('-id',)
执行数据库牵引
python manage.py makemigrations
python manage.py migrate
在PyCharm中查看数据库信息
View > Tool Windows > Database
Data Source > SQLite
选择 db.sqlite3 文件,看到缺少驱动文件就下载,等待下载完成
测试成功点击 OK 即可连接数据库