Programmer Group

Use django to connect to SQL Server, and pyodbc to connect to multiple databases. pyodbc, the SQL that runs the query, is very simple: import pyodbc connection = pyodbc.connect('DRIVER={SQL Server Native Client 10.0};SERVER=127.0.0.1;DATABASE=DB_name;UID=User_Name;PWD=PassWord') curs = connection.execute('select * from table') #curs.fetchone( ...

This chapter will build a containerized Django project locally to experience how Docker works. preparation in advance development environment Although there is a Windows-based version of Docker, all aspects of compatibility are not well done (installation is more troublesome), so it is recommended that readers install their own Linux or Mac sys ...

I. Essence of Web Framework All Web applications are essentially a socket server, and the user's browser is a socket client. II. Web Framework Function socket sends and receives messages - wsgiref (test), uwsgi (online) Returns different strings according to different paths Return dynamic pages (string substitution) - jin ...

Performance optimization principle: When we want to return a page to client browser, we need to query data in database and render the data and basic page template to form a page to return to the client. But if every user visits the home page once, it will undoubtedly bring great performance problems to database query when the amount of visits ...

Installation of Django 1. Using Pipenv to create an isolated environment First, install Pipenv by command pip install pipenv. Then create a folder as the root directory of the blog project we are going to develop. For example, I create a new directory named blog under my personal working directory C: Users Zerobit SpaceLocal Workspace G_Courses ...

The premise of using qqq login is to create website application on QQ interconnected official website and obtain APP ID and APP KEY of website application in QQ interconnection. 1. Routing # qq Sign in path('loginQq/',qq.loginQq,name='loginQq/'), path('returns/',qq.returns,name='returns/'), 2. The front page writes the link ...

Project source download: https://github.com/Cherish-sun/NEWS/tree/master Implementation of web API for News Tags and advertisements 1. serializers.py additions # serializers to serialize News Tags class TagSerializer(serializers.ModelSerializer): # id = serializers.Field() name = serialize ...

Aliyun Server Open Port 8001,9001 Create a virtual environment virtualenv -p python3 web2 Make Virtual Environment Effective source web2/bin/activate Installing django and uwsgi in virtual environment pip install django pip install uwsgi Create a django project django-admin.py startproject myweb2 Modify the settins.py ...

Catalog: bbs homepage construction Using admin background management to input data bbs homepage construction First add the home url # Add in urls.py url(r'^home/', views.home), bootstrap components used in front-end pages https://v3.bootcss.com/components/#navbar https://v3.bootcss.com/com ...

We customize a main.py as the startup file main.py #!/usr/bin/env python # -*- coding:utf8 -*- from scrapy.cmdline import execute #Import and execute scrapy command method import sys import os sys.path.append(os.path.join(os.getcwd())) #Add a new path to the Python interpreter, and add the directory of the main.py file to the Python interpr ...