django中一个model如下
class Log_history(models.Model):
log_name = models.CharField(max_length=32,verbose_name='登录用户')
log_ip = models.GenericIPAddressField(null=True,verbose_name='登录IP')
log_time = models.DateTimeField(verbose_name='登录时间')
log_status = models.CharField(max_length=32,verbose_name='登录结果')
def __str__(self):
return self.log_name + self.log_time + self.log_result
class meta:
verbose_name = '登录记录'
verbose_name_plural = '登录记录'
查询
obj = Log_history.objects.all() #所有
obj = Log_history.objects.filter(log_name="test") #带条件的过滤
obj = Log_history.objects.filter(log_name__icontains="test") #模糊匹配
obj = Log_history.objects.values("id", "log_name", "log_ip", "log_time", "log_status").order_by('-log_time')#取部分列
obj = Log_history.objects.filter(log_name=req_name).values("id", "log_name", "log_ip", "log_time",
"log_status").order_by('-log_time') #带条件的取部分列
obj = Log_history.objects.get(log_name="test") #只能返回单个，否则报错
修改
Log_history.objects.filter(id=“1”).update(log_status =“1”)
增加
obj = Log_history.objects.create(log_name="test", log_ip="1.1.1.1", log_time="***", log_status="登陆失败") obj = Log_history.objects.get_or_create(log_name="test", log_ip="1.1.1.1", log_time="***", log_status="登陆失败")
删除
Log_history.objects.filter(id=“1”).delete()
