Repository navigation
Expand file tree
/
Copy pathmodels.py
More file actions
66 lines (63 loc) · 2.87 KB
/
Copy pathmodels.py
File metadata and controls
66 lines (63 loc) · 2.87 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
"""
用户模块
"""
from django.db import models, transaction
class User(models.Model):
"""
用户信息表
"""
user_id = models.AutoField(primary_key=True, verbose_name='用户id')
user_guid = models.CharField(max_length=150, verbose_name='用户guid')
user_name = models.CharField(
max_length=100, blank=True, null=True, verbose_name='用户名')
real_name = models.CharField(
max_length=50, blank=True, null=True, verbose_name='真实姓名')
avatar = models.CharField(
max_length=250, blank=True, null=True, verbose_name='头像')
mobile = models.CharField(
max_length=50, blank=True, null=True, verbose_name='手机')
balance = models.DecimalField(
max_digits=8, decimal_places=2, blank=True, null=True, verbose_name='账户余额')
available_balance = models.DecimalField(
max_digits=8, decimal_places=2, blank=True, null=True, verbose_name='可用金额')
frozen_balance = models.DecimalField(
max_digits=8, decimal_places=2, blank=True, null=True, verbose_name='冻结金额')
all_balance = models.DecimalField(
max_digits=8, decimal_places=2, blank=True, null=True, verbose_name='累计金额')
wx_open_id = models.CharField(max_length=150, verbose_name='微信OpenID')
wx_union_id = models.CharField(
max_length=150, blank=True, null=True, verbose_name='微信UnionID')
create_date = models.FloatField(blank=True, null=True, verbose_name='创建时间')
last_login_date = models.FloatField(
blank=True, null=True, verbose_name='最后登录时间')
ip_address = models.CharField(
max_length=50, blank=True, null=True, verbose_name='IP地址')
gender = models.IntegerField(blank=True, null=True, verbose_name='性别')
province = models.CharField(
max_length=50, blank=True, null=True, verbose_name='省份')
city = models.CharField(
max_length=50, blank=True, null=True, verbose_name='城市')
session_key = models.CharField(
max_length=150, blank=True, null=True, verbose_name='会话秘钥')
is_notify = models.IntegerField(blank=True, null=True, verbose_name='是否开启打卡通知')
@classmethod
def update_user_balance(cls, user_id, amount):
# 手动让select for update和update语句发生在一个完整的事务里面
with transaction.atomic():
user = (
cls.objects
.select_for_update()
.get(user_id=user_id)
)
user.available_balance += amount
user.balance = user.available_balance + user.frozen_balance
if amount > 0:
user.all_balance += amount
user.save()
return user
class Meta:
managed = False
db_table = 'user'
ordering = ['-create_date']
verbose_name = '用户'
verbose_name_plural = '用户'