from django.db import connection
# 获取游标对象
cursor = connection.cursor()

# 执行sql语句
cursor.execute('select * from op')

# 获取所有的数据
rows = cursor.fetchall()
# 遍历查询到的数据
book = []
for row in rows:
    book.append({'name':row[0], 'age':row[1]})

# 所引用的这条外键记录如果被删除，那么当前的数据如何进行处理

# forms.py
from django import forms
# 留言板的表单
class MessageBoardForm(forms.Form):
    title = forms.CharField(max_length=120 , min_length=2 , label='标题' , error_messages={"min_length":"标题最小长度至少为2！" , "max_length":"标题最大长度不能超过120个字符！"})
    content = forms.CharField(max_length=200)

# views.py
from django.shortcuts import render , HttpResponse
from .forms import MessageBoardForm
from django.views.decorators.http import require_http_methods

# 针对这个方法只需要get和post请求，可以使用一个装饰器
@require_http_methods(['GET','POST'])
def index(request):
    if request.method == 'GET':
        f = MessageBoardForm()
        context = {
            'form':f
        }
        return render(request, 'index.html' , context=context)
    elif request.method == 'POST':
        f = MessageBoardForm(request.POST)
        # 表示表单数据正确
        if f.is_valid():
            title = f.cleaned_data['title']
            content = f.cleaned_data['content']
            email = f.cleaned_data['email']
            return HttpResponse(f"{title} , {content} , {email}")
        else:
            return HttpResponse(f.errors)

# 自定义 表单验证器
class RegisterForm(forms.Form):
    phone = forms.CharField(validators=[validators.RegexValidator(r'1[345678]\d{9}' , message="手机号码格式错误！")])
    pwd1 = forms.CharField(max_length=120)
    pwd2 = forms.CharField(max_length=120)

    # 上面是通过正则的方式，如果涉及到查询数据库之类的：比如用户注册的手机号，需要判断是不是已经注册过，可以通过自定义验证逻辑来实现
    # 针对某一个字段进行验证的重写方式
    def clean_phone(self):
        phone = self.cleaned_data['phone']
        if phone == '17634774652':
            raise forms.ValidationError("该手机号已经注册!!!")
        else:
            return phone

    # 针对多个字段进行效验的重写方式
    def clean(self):
        new_data = super().clean()
        print(type(new_data) , new_data)
        pwd1 = new_data.get('pwd1')
        pwd2 = new_data.get('pwd2')
        if pwd1 != pwd2:
            raise forms.ValidationError("密码输入不一致！")

# 发送验证码的配置
EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend'
EMAIL_USE_TLS = True
EMAIL_HOST = 'smtp.qq.com'  # 这个地方目前是使用的qq进行发送
EMAIL_PORT = 587
EMAIL_HOST_USER = 'zhyoulove@qq.com'
EMAIL_HOST_PASSWORD = 'tylcwlidkpoviibb'
DEFAULT_FROM_EMAIL = 'zhyoulove@qq.com'

# 发送注册邮箱验证码
# xxx ?email=xxx
def send_email(request):
    email = request.GET.get('email')
    print(email)
    # 如果邮箱为空，表示需要传递邮箱这个参数
    if email is None:
        return JsonResponse({"code":400 , "message":"必须传递邮箱！"})
    # 表示获取到了需要发送的邮箱 先随机生成四位数字
    captcha = "".join(random.sample(string.digits , 6))
    print(captcha)
    # 进行发送
    send_mail("注册博客验证码" , message=f'您的注册验证码是：{captcha}' , recipient_list=[email] , from_email=None)

    return JsonResponse({"code":200 , "message":"邮箱验证码发送成功！"})