def addPublisher(request): new_publisher = Publisher() if request.method == 'POST': form = PublisherForm(request.POST) if form.is_valid(): name = form.cleaned_data['name'] address = form.cleaned_data['address'] city = form.cleaned_data['city'] state_province = form.cleaned_data['state_province'] country = form.cleaned_data['country'] website = form.cleaned_data['website'] phone = form.cleaned_data['phone'] new_publisher.name = name new_publisher.address = address new_publisher.city = city new_publisher.state_province = state_province new_publisher.country = country new_publisher.website = website new_publisher.phone = phone new_publisher.save() #return HttpResponse("Publisher Added") #return render(request, 'auth_users.html') return redirect('/books/home/') else: form = PublisherForm() return render(request, 'publisher.html', {'form': form})
def crudops(request): #Creating an entry publisher = Publisher(name='Apress', address='2855 Telegraph Avenue', city='Berkeley', state_province='CA', country='U.S.A.', website='http://www.apress.com/') publisher.save() #Read ALL entries objects = Publisher.objects.all() res = 'Printing all Publisher entries in the DB : <br>' for elt in objects: res += elt.name + "<br>" # #Read a specific entry: # sorex = Publisher.objects.get(name = "Apress1") # res += 'Printing One entry <br>' # res += sorex.name #Delete an entry #res += '<br> Deleting an entry <br>' # sorex.delete() #Update publisher = Publisher(name='Apress1', address='2855 Telegraph Avenue', city='Berkeley', state_province='CA', country='U.S.A.', website='http://www.apress.com/') publisher.save() res += 'Updating entry<br>' publisher = Publisher.objects.get(name='Apress1') publisher.name = 'thierry' publisher.save() Publisher.objects.filter(id=27).update(name='Apress Publishing') Publisher.objects.all().update(country='USA') return HttpResponse(res)
def dbtest(req): ##插入记录 p1 = Publisher(name='Apress', address='2855 Telegraph Avenue', city='Berkeley', state_province='CA', country='U.S.A.', website='http://www.apress.com/') p1.save() ##插入记录 print p1.id p1.name = 'Apress Publishing' p1.save() ##更新记录 p2 = Publisher.objects.create(name="O'Reilly", address='10 Fawcett St.', city='Cambridge', state_province='MA', country='U.S.A.', website='http://www.oreilly.com/') ##查询记录与过滤 publisher_list = Publisher.objects.all() print publisher_list publisher_list = Publisher.objects.filter(name='Apress') print publisher_list publisher_list = Publisher.objects.filter(country="U.S.A.", state_province="CA") Publisher.objects.filter(name__contains="press") ##icontains(大小写无关的LIKE),startswith和endswith, 还有range(SQLBETWEEN查询) publisher = Publisher.objects.get( name="Apress") ##如果结果是多个对象,会导致抛出异常,没有返回结果也会抛出异常 Publisher.objects.order_by("name") ##排序 Publisher.objects.filter(country="U.S.A.").order_by("-name") Publisher.objects.order_by('name')[0] ##限制数据,等同于limit ##更新 p = Publisher.objects.get(name='Apress') p.name = 'Apress Publishing' p.save() Publisher.objects.filter(id=52).update(name='Apress Publishing') Publisher.objects.all().update(country='USA') ##删除 p = Publisher.objects.get(name="O'Reilly") p.delete() Publisher.objects.filter(country='USA').delete() Publisher.objects.all().delete()
def dbtest(req): ##插入记录 p1 = Publisher(name='Apress', address='2855 Telegraph Avenue', city='Berkeley', state_province='CA', country='U.S.A.', website='http://www.apress.com/') p1.save() ##插入记录 print p1.id p1.name = 'Apress Publishing' p1.save() ##更新记录 p2 = Publisher.objects.create(name="O'Reilly", address='10 Fawcett St.', city='Cambridge', state_province='MA', country='U.S.A.', website='http://www.oreilly.com/') ##查询记录与过滤 publisher_list = Publisher.objects.all() print publisher_list publisher_list = Publisher.objects.filter(name='Apress') print publisher_list publisher_list = Publisher.objects.filter(country="U.S.A.", state_province="CA") Publisher.objects.filter(name__contains="press") ##icontains(大小写无关的LIKE),startswith和endswith, 还有range(SQLBETWEEN查询) publisher = Publisher.objects.get(name="Apress") ##如果结果是多个对象,会导致抛出异常,没有返回结果也会抛出异常 Publisher.objects.order_by("name") ##排序 Publisher.objects.filter(country="U.S.A.").order_by("-name") Publisher.objects.order_by('name')[0] ##限制数据,等同于limit ##更新 p = Publisher.objects.get(name='Apress') p.name = 'Apress Publishing' p.save() Publisher.objects.filter(id=52).update(name='Apress Publishing') Publisher.objects.all().update(country='USA') ##删除 p = Publisher.objects.get(name="O'Reilly") p.delete() Publisher.objects.filter(country='USA').delete() Publisher.objects.all().delete()
#测试模型的 from books.models import Publisher if __name__ == '__main__': p1 = Publisher(name='Apress', address="2855 Telegraph Ave", city="Berkeley", state_province="CA", country="USA", website='http://www.apress.com/') p1.save() p2=Publisher.objects.create(name="O'Reilly", address='10 Fawcett St.', city="Cambridge", state_province="MA", country="USA", website="http://www.oreilly.com") publisher_list=Publisher.objects.all() print publisher_list p1.name='Apress Publishing' p1.save() print p1.name publisher_list=Publisher.objects.filter(country="USA").order_by("-name") print publisher_list print Publisher.objects.order_by('name')[0] print Publisher.objects.all().count() print Publisher.objects.all().delete() print Publisher.objects.all()