# 在与 settings.py 同级目录下的 __init__.py 中引入模块和进行配置
import pymysql
pymysql.install_as_MySQLdb()

from django.http import HttpResponse

from TestModel.models import Test


# 数据库操作
def insdb(request):
    test1 = Test(name='moonwhite')
    test1.save()
    return HttpResponse("<p>数据添加成功！</p>")

path('insdb/', testdb.insdb),

def seldb(request):
    # 通过objects这个模型管理器的all()获得所有数据行，相当于SQL中的SELECT * FROM
    list = Test.objects.all()
    str = ""
    for var in list:
        str += var.name + " "
    return HttpResponse("<p>" + str +"</p>")

def seldb1(request):
    # filter相当于SQL中的WHERE，可设置条件过滤结果
    qs = Test.objects.filter(id=1)
    str=""
    for var in qs:
        str += var.name + " "
    return HttpResponse("<p>" + str +"</p>")

def seldb2(request):
    # 获取单个对象
    test2 = Test.objects.get(id=2)

    return HttpResponse("<p>" + test2.name +"</p>")

def seldb3(request):
    # 限制返回的数据 相当于 SQL 中的 OFFSET 0 LIMIT 2;
    # Test.objects.order_by('name')[0:2]
    # # 数据排序
    # qs = Test.objects.order_by("id")

    # 上面的方法可以连锁使用
    qs = Test.objects.order_by("id")[0:4]

    str = ""
    for var in qs:
        str += var.name + " <br>"


    return HttpResponse("<p>" + str +"</p>")

def upddb(request):
    # 修改其中一个ID=2的记录的name字段，再save，相当于SQL： update table set name='newvalue' where id = 2
    test1 = Test.objects.get(id = 2)
    test1.name = 'moonwhite02'
    test1.save()
    # 另外一种方式
    # Test.objects.filter(id=1).update(name='Google')

    # 修改所有的列
    # Test.objects.all().update(name='Google')
    return HttpResponse('<p>' + "update success " + '</p>')

def deldb(request):
    # 删除id=1的数据
    test1 = Test.objects.get(id=1)
    test1.delete()

    # 另外一种方式
    # Test.objects.filter(id=1).delete()

    # 删除所有数据
    # Test.objects.all().delete()

    return HttpResponse("<p>删除成功</p>")

import pymysql
pymysql.version_info = (1, 4, 13, "final", 0)
pymysql.install_as_MySQLdb()

from django.http import HttpResponse

def hello(request):
    return HttpResponse("Hello Django!")

from django.contrib import admin
from django.urls import path
from django.conf.urls import url

from . import views

urlpatterns = [
    path('admin/', admin.site.urls),
    url('^$', views.hello),
    url('hello/', views.hello),
]

from django.shortcuts import render

def about(request):
    context = {}
    context['about'] = 'Hello Django in the about page!'
    return render(request, 'about.html', context)

urlpatterns = [
    ...
    path('about/', views.about),
]

# views.py
def paramtest1(request):
    text = "您输入的URL - id是：{}".format(request.GET.get('id'))
    return HttpResponse(text)

#urls.py
    path('paramtest1', views.paramtest1),

# views.py
def paramtest(request,req_id='123'):
    text = "您输入的id是：%s" % req_id
    return HttpResponse(text)

# urls.py
    path('paramtest/<req_id>', views.paramtest),

urlpatterns = [
    path('articles/<int:year>/', views.year_archive),
    path('articles/<int:year>/<int:month>/', views.month_archive),
    path('articles/<int:year>/<int:month>/<int:pk>/', views.article_detail),
]

from django.contrib import admin
from django.urls import path, include
from django.conf.urls import url

urlpatterns = [
    path('app01/', include('app01.urls')),
]

from django.urls import path

from . import views

urlpatterns = [
    path('', views.book),
    path('list/', views.book_list),
    path('add_book/', views.add_book),
]

# urls.py
urlpatterns = [
    path('login/', views.login, name='login'),
]

# 使用的地方，比如原来使用
from django.shortcuts import redirect
redirect('/login/')
# 修改为
from django.shortcuts import redirect, reverse
redirect(reverse('login'))

# urls.py
app_name = 'front' # 定义app的命名空间为front

urlpatterns = [
    path('login/', views.login, name='login'),
]

# 使用的地方
from django.shortcuts import redirect, reverse
redirect(reverse('front:login'))

path('cms/', include('cms.urls')),
path('cms1/', include('cms.urls')),
path('cms2/', include('cms.urls')),

# urls.py
    path('cms/', include('cms.urls', namespace='cms')),
    path('cms1/', include('cms.urls', namespace='cms1')),
    path('cms2/', include('cms.urls', namespace='cms2')),

# views.py
from django.shortcuts import render, redirect, reverse
def index(request):
    username = request.GET.get('username')
    if username:
        return HttpResponse("后台主页")
    else:
        # 取得实例命名空间
        current_namespace = request.resolver_match.namespace
        # 在做反转的时候，就可以根据实例命名空间来指定具体的url
        login_url = reverse('{}:login'.format(current_namespace))
        return redirect(login_url)

# urls.py
urlpatterns = [
    re_path(r'^$', views.article),
    re_path(r"^list/(?P<year>\d{4})/$", views.article_list),
]

# views.py
def article(request):
    return HttpResponse("文章主页")

def article_list(request, year):
    return HttpResponse("{} 年文章列表".format(year))

# urls.py
    path('detail/<article_id>', views.article_detail, name='detail'),
    path('login/', views.login, name='login'),
    path('index/', views.index, name='index'),


# views.py
def index(request):
    username = request.GET.get('username')
    if username:
        return HttpResponse("文章首页")
    else:
        # kwarg : keyword arguments.
        detail_url = reverse('detail', kwargs={"article_id": 1}) # /detail/1
        return  redirect(detail_url)