Add, delete, modify, query, and operate on Mysql and djangomysql Databases

Add, delete, modify, query, and operate on Mysql and djangomysql Databases

The following describes how to add, delete, modify, and query django:

1. view. py

#-*-Coding: UTF-8 -*-
From _ future _ import unicode_literals
From django. http import HttpResponse

From polls. models import Test
From django. shortcuts import render

# Create your views here.
# Solve garbled characters
Import sys
Reload (sys)
Sys. setdefaultencoding ('utf-8 ')
# Database Operations
Def testdb (request ):
Test1 = Test (name = 'wen Hongyu 2 ')
Test1.save ()
Return HttpResponse ("<p> data added successfully! </P> ")

# Querying databases
Def selectDB (request ):

# Obtain all data rows through all () of the model manager objects, which is equivalent to SELECT * FROM
List = Test. objects. all ()
Returnvalue = []
For v in list:
Returnvalue. append (v. name)
Print v. name

Print "++ getting a single object ++"
# Getting a single object
Response1 = Test. objects. filter (id = 1)
Print response1
For v1 in response1:
Returnvalue2 = "id:", v1.id, "Name:", v1.name
Print returnvalue2

Print "++ LIMIT that the returned data is equivalent to OFFSET 0 LIMIT 2 in SQL; ++"
Response2 = Test. objects. order_by ('name') [0: 2]
Returnvalue3 = {}
For v2 in response2:
Returnvalue3 [v2.id] = v2.name

Print returnvalue3.items ()
Print "++ output result:"
Return HttpResponse (returnvalue3.items ())

# You can use save () or update () to modify data ():
Def updateDB (request ):
# Modify the name field of id = 1 and save it, which is equivalent to UPDATE in SQL
Test1 = Test. objects. get (id = 1)
Test1.name = 'Google'
Test1.save ()

# Another Method
# Test. objects. filter (id = 1). update (name = 'Google ')
# Modifying all columns
# Test. objects. all (). update (name = 'Google ')

Return HttpResponse ("data updated successfully ")

Def deleteDB (request ):
# Delete data with id = 1
Test1 = Test. objects. get (id = 3)
Test1.delete ()
Return HttpResponse ("data deleted successfully ")

2. urls. py

"""pythondjango URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
    https://docs.djangoproject.com/en/1.11/topics/http/urls/
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  url(r'^$', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  url(r'^$', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.conf.urls import url, include
    2. Add a URL to urlpatterns:  url(r'^blog/', include('blog.urls'))
"""
from django.conf.urls import url
from django.contrib import admin
from BlogDjango import views
from polls import views as pollsviews, search, search2

urlpatterns = [
    url(r'^admin/', admin.site.urls),
    url(r'^hello/+\d', views.hello),
    url(r'^base/', views.base),
    url(r'^testdb$', pollsviews.testdb),
    url(r'^querydb$', pollsviews.selectDB),
    url(r'^updateDB$', pollsviews.updateDB),
    url(r'^deleteDB$', pollsviews.deleteDB),
]

3、models.py

# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models

# Create your models here.

class Test(models.Model):

    name = models.CharField(max_length=20)