from model import db, User,AAA
from flask_jwt_extended import create_access_token,jwt_required
import hashlib
# a = User(username="abc",password="123")
# db.session.add(a)
# db.session.commit()

# b = User(username="董月坤",password="1234")
# c = User(username="仇亚恒",password="1234")
# db.session.add_all([a,b,c])
# db.session.commit()

# d = AAA(website="www.baidu.com")
# e = AAA(website="www.123")
# f = AAA(website="www.456")
# db.session.add_all([d,e,f])
# db.session.commit()

 
# u=User.query.get(1)    #一个
# print(u.username)

# u=User.query.all()      #全部
# for i in u:
#     print(i.username)

# username=my_json.get("username")
# user=User.query.filter_by(username="abc").first()
# print(user.username)

# user=User.query.filter(User.username=="abc").first()
# print(user.username)

# token = create_access_token(identity=user.username)
# print(token)

# md5=hashlib.md5("123".encode()).hexdigest()
# print(md5)

# User.query.filter(User.username=="abc").update({"password":"123"})
# db.session.commit()

# user = Student.query.filter(Student.name == "李依").delete()


get_website=AAA.query.all()

b=[]
for i in get_website:      #字典中key是唯一值 “id”相同 会覆盖掉只剩最后一项
    a=dict() 
    a["id"]=i.id
    a["website"]=i.website
    b.append(a)
print(b)
# print(b)
# b.append(a)
# print(b)   
# a=dict() 
# a[AAA.id]=AAA.website
# a[12]=2222