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()
