def testdb1(request):
# 添加值为runoob的数据
v = 'runoob'
test1 = Test(name=v)
test1.save()
s = '添加数据 %s 成功' % v
return HttpResponse("<p> %s </p>" % s)
def addUser(request):
ret = {}
ret["desc"] = "success"
name = request.GET.get("name")
if not name:
ret["desc"] = "没有传入用户名"
return HttpResponse(json.dumps(ret))
pwd = request.GET.get("pwd")
if not name:
ret["desc"] = "没有传入密码"
return HttpResponse(json.dumps(ret))
#检查是否重复
obj = Test.objects.filter(name=name, pwd=pwd)
if obj:
ret["desc"] = "用户名和密码已存在"
return HttpResponse(json.dumps(ret))
t1 = Test(name=name, pwd=pwd)
t1.save()
ret["desc"] = "success"
ret["name"] = name
ret["pwd"] = pwd
return HttpResponse(json.dumps(ret))
def testdb(request):
test1 = Test(name='runoob') #name='runoob'
test2 = Customer(market_cost_price='99')
test2.save()
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def test_add(self):
# Test.objects.create(name='test', age=10, tel='13300000000')
test = Test(name='test', age=10, tel='13300000000')
test.save()
# self.assertEqual(test.tel, '13300000000')
person = Test.objects.get(name='test')
self.assertEqual(person.tel, '13300000000')
print("add")
def _testdb(request: HttpRequest):
print(request.COOKIES)
if request.method == "POST" and request.POST.get('poet'):
k = request.POST['poet']
test1 = Test(name=k)
test1.save()
return redirect('/testdb_insert')
else:
return render(request, 'insert.html')
def dbadd(request):
newName = ""
checkNameF = ""
newName = str(2)
test = Test(name=newName, id=1)
test.save()
checkName = Test.objects.filter(id=2)
for i in checkName:
checkNameF += i.name
return HttpResponse("add successfully" + checkNameF + " " + "\n")
def insertdb(request):
if 'name' in request.GET:
test1 = Test()
test1.name = request.GET['name']
test1.save()
message = '数据添加成功'
else:
message = '数据添加失败'
return HttpResponse("<p>" + message + "</p>")
def insertdb(request):
'''
Insert
'''
names = ['bzh', 'ty', 'bzm', 'bjw', 'lxm', 'tc']
ages = [28, 27, 25, 59, 54, 20]
for name, age in zip(names, ages):
test = Test(name=name, age=age)
test.save()
return HttpResponse("<p>添加数据success!</p>")
def login(request):
if request.method == 'GET':
return render(request, 'login.html')
else:
if (request.POST['name'] != "" and request.POST['age'] != ""):
new_person = Test(name=request.POST.get('name'),
age=request.POST.get('age'))
new_person.save()
return JsonResponse({'msg': "success"})
else:
return JsonResponse({'msg': "false"})
def index(request):
context = {}
if request.POST:
data = request.POST['data']
test = Test(name=json.dumps(data), id=2)
test.save()
return json_response('保存成功！')
else:
data = Test.objects.get(id=2).name
context['data'] = data
return render(request, 'index.html', context)
def search_post_do(request):
dict1 = {}
if request.POST :
dict1['post_name'] = request.POST['name_html']
dict1['post_age'] = request.POST['age_html']
dict1['post_address'] = request.POST['address_html']
dict1['post_date'] = request.POST['date_html']
if dict1['post_name'] :
db = Test(name=dict1['post_name'],age=dict1['post_age'],address=dict1['post_address'],data=dict1['post_date'])
db.save()
return render(request,'post.html',dict1)
def addtest_post(request):
ctx = {}
if request.POST:
ctx['rlt'] = request.POST['name']
ctx['rlt2'] = request.POST['password']
# 数据库操作
test1 = Test(name=ctx['rlt'], password=ctx['rlt2'])
test1.save()
ctx['rlt3'] = 'chengg'
#return render(request, "TestModel/addtest.html", ctx)
return render(request, "addtest.html", ctx)
def save_data(self):
"""保存数据"""
test1 = Test(
rank=self.rank,
name=self.name,
star=self.star,
num=self.evaluation,
text=self.description,
date=self.date,
address=self.address,
)
test1.save()
def testdb(request):
test1 = Test(name="Hua")
test1.save()
list = Test.objects.all()
print(list)
one = Test.objects.get(id=1)
one.name = "祝化林"
one.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
test1 = Test(
rank="1",
name="肖申克的救赎",
star="9.7",
num="1783755人评价",
text="希望让人自由。",
date="1994",
address="美国",
)
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
# 初始化
response = ""
response1 = ""
# 通过objects这个模型管理器的all()获得所有数据行，相当于SQL中的SELECT * FROM
#list = Test.objects.all().order_by("id")
# filter相当于SQL中的WHERE，可设置条件过滤结果
#response2 = Test.objects.filter(id=1)
# 获取单个对象
#response3 = Test.objects.get(id=1)
# 限制返回的数据 相当于 SQL 中的 OFFSET 0 LIMIT 2;
#Test.objects.order_by('name')[0:2]
# 数据排序
#Test.objects.order_by("id")
# 上面的方法可以连锁使用
#Test.objects.filter(name="runoob").order_by("id")
# 修改其中一个id=1的name字段，再save，相当于SQL中的UPDATE
#test1 = Test.objects.get(id=1)
#test1.name = 'Google'
#test1.save()
# 另外一种方式
# Test.objects.filter(id=1).update(name='Google')
# 修改所有的列
# Test.objects.all().update(name='Google')
# 删除id=1的数据
#test1 = Test.objects.get(id=1)
#test1.delete()
# 另外一种方式
# Test.objects.filter(id=1).delete()
# 删除所有数据
# Test.objects.all().delete()
# 输出所有数据
#for var in list:
# response1 += var.name + " "
#response = response1
#return HttpResponse("<p>" + response + "</p>")
#增加一条数据
test1 = Test(name='runoob', age="22")
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
# 数据库插入
val = random.sample('zyxwvutsrqponmlkjihgfedcba', 5)
print(val)
var = ''
for l in val:
var += l
print(var)
test1 = Test(name=var)
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
test1 = Test(name='test1')
test1.save()
test2 = Test(name='test2')
test2.save()
# return HttpResponse("<p>数据添加成功！</p>")
response = ""
response1 = ""
# list = Test.objects.all()
list = Test.objects.order_by("name")
for var in list:
response1 += var.name + " "
response = response1
return HttpResponse("<p>" + response + "<p>")
def testdb(request, name):
conn = Test(name=name)
conn.save()
test1 = Test.objects.get(id=3)
test1.name = 'Google'
test1.save()
Test.objects.filter(name='alice').update(name='lucy')
Test.objects.filter(name='lucy').delete()
# test1 = Test.objects.get(id=1)
# test1.delete()
# return HttpResponse('add username successfully')
list = Test.objects.all().order_by('name')
list = Test.objects.filter(id=3).order_by('name')
print(type(list))
res = ''
for i in list:
res += '<p>' + i.name + '</p>'
return HttpResponse('<p>' + res + '</p>')
def test_db(request):
test1 = Test(name='w3cschool.cn')
response = ""
test1.save()
# 通过objects模型管理器的all()获得所有数据行类似select * from
list = Test.objects.all()
print(list)
# filter相当于where,设置过滤条件
response2 = Test.objects.filter(id=1)
# 获取单个对象
response3 = Test.objects.get(id=1)
# 限制返回数据 相当于offset 0 limit 2
response4 = Test.objects.order_by('name')[0:2]
# 数据排序
response5 = Test.objects.order_by('id')
# 多条件
response6 = Test.objects.filter(name='w3cschool.cn1').order_by('id')
# 修改数据
test = Test.objects.get(id=1)
test.name = 'w3c教程'
test.save()
# 另一种修改数据
Test.objects.filter(id=2).update(name='w3c教程Update')
# 修改所有列
# Test.objects.all().update(name='w3c教程update_all')
# 删除数据
test2 = Test.objects.get(id=3)
test2.delete()
# Test.objects.filter(id=1).delete()
# 删除所有数据
# Test.objects.all().delete()
# 输出所有数据
for var in response5:
response = response + var.name + "\n"
print(response5)
return HttpResponse("<p>" + response + "</p>")
def testdb(request):
test1=Test(name='runoob')
test1.save()
test2=Test(name='Lucky')
test2.save()
test3=Test(name='lucy')
test3.save()
response=""
response1=""
list=Test.objects.all()
response2=Test.objects.filter(id=1) # filter can be seen as WHERE
response3=Test.objects.get(id=1) # get single object
Test.objects.order_by('name')[0:2]
Test.objects.order_by("id")
Test.objects.filter(name="runoob").order_by("id")
for var in list:
response1 += var.name + " "
response = response1
return HttpResponse("<p>" + response + "</p>")
def testdb(request):
test1 = Test(name='w3cschool.cc')
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
test1 = Test(name='Django.cc')
test1.save()
return HttpResponse("<h3>Insert Completed</h3>")
def testdb(reqeust):
test1 = Test(name="linder")
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
test1 = Test(name='runoob')
test1.save()
context = {}
context['hello'] = '数据添加成功！!'
return render(request, 'hello.html', context)
def testdb_insert(request):
test1 = Test(name="w3cschool.cn")
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def add(request):
test1 = Test(name='wushuag')
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdbAdd(request):
data = 'runoob-' + time.strftime("%H:%M:%S", time.localtime())
test1 = Test(name=data[0:20])
test1.save()
return HttpResponse("<p>Suceeded: added the data: {0}</p>".format(data))
def insert(request):
test1=Test(name='Rocky')
test1.save()
return HttpResponse('Data insert successful')
def add(request):
test1 = Test(name='testdb')
test1.save()
return HttpResponse('Success to add data.')
def testdb(request):
test1 = Test(name='knight.ren')
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
# 操作码
integer1 = input('请输入一个操作码[1,4]:')
donumber = int(integer1)
integer2 = input('请输入一个id:')
id_num = int(integer2)
if donumber == 1:
'''<1> 添加数据：'''
test0 = Test.objects.filter(id=id_num)
if bool(test0):
return HttpResponse("<p>数据已经存在！</p>")
else:
test1 = Test(name='runoob', id=id_num)
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
elif donumber == 2:
'''<2> 获取数据: '''
# 初始化
response = " "
response1 = ""
# 通过objects这个模型管理器的all()获得所有数据行，相当于SQL中的SELECT*FROM
list = Test.objects.all()
# 判断是否是空数据
if Test.objects.count() < 1: # 判断数据库中的个数
return HttpResponse("<p>获取数据库中没有数据！</p>")
# filter相当于SQL中的WHERE，可设置条件过滤结果
response2 = Test.objects.filter(id=id_num)
if bool(response2):
# 获取单个对象
response3 = Test.objects.get(id=id_num)
response = response3.name
# 限制返回的数据 相当于 SQL 中的 OFFSET 0 LIMIT 2
Test.objects.order_by('name')[0:2]
# 数据排序
Test.objects.order_by("id")
return HttpResponse("<p>获取数据名字：" + response + "</p>")
else:
# 上面4步的方法可以连锁使用，上面4不可合成
Test.objects.filter(name="runoob").order_by("id")
# 输出所有数据
for var in list:
response1 += " " + var.name + "_" + str(var.id) + "<br>"
# len(l)
response = response1
return HttpResponse("<p>" + "<b>数据库中不存在id=" + integer2 +
"的数据</b><br>" + "数据库中存在的数据：<br> 名字_id<br>" +
response + "</p>")
elif donumber == 3:
''' <3> 更新数据库 '''
# 修改数据可以使用 save() 或 update():
# 判断数据库中是否存在id=1的数据
test0 = Test.objects.filter(id=id_num)
if bool(test0):
# 修改其中一个id-1的name字段，再save，相当于SQL中的UPDATE
test1 = Test.objects.get(id=id_num)
test1.name = 'xiaominger'
test1.save()
# 另一种方式
#Test.objects.filter(id=id_num).uodate(name='xiaominger')
# 修改所有的列
#Test。objects.all().update(name='xiaominger')
return HttpResponse("<p>修改成功！</p>")
else:
return HttpResponse("<p>不存在有且只有一个id=1的数据！</p>")
elif donumber == 4:
''' <4>删除数据 '''
# 删除数据库中的对象只需要调用该对象的delete()方法即可：
# 判断数据库中是否存在id=1的数据
test0 = Test.objects.filter(id=id_num)
if bool(test0):
# 删除id=1的的数据
test1 = Test.objects.get(id=id_num)
test1.delete()
# 另一种方式
#Test.objects.filter(id=1).delete()
return HttpResponse("<p>删除成功！</p>")
else:
# 删除所有数据
#Test.objects.all().delete()
return HttpResponse("<p>不存在有且只有一个id=1的数据！</p>")
else:
return HttpResponse(
"<p>请输入正确的执行码：<br>1:添加数据<br>2:获取数据<br>3:更改数据<br>4:删除数据</p>")
def dbinsert(request):
test1 = Test(name='sqy')
test1.save()
return HttpResponse("<p>插入成功!<a href='../dbquery'>查询</a></p>");
def testdb(request):
test1 = Test(name='runoob')
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
def testdb(request):
test1 = Test(name='w3cschool.cn')
test1.save()
return HttpResponse("<p>数据添加成功！</p>")
