python3 implements mysql export excel

I. Preparations Python Tool Library Installation xlwt and xlrd Installation under 1.1win7 1.1.1 Method 1: Download and Install 1. From http://pypi.python.org/pypi/xlwt Download xlwt-1.0.0.tar.gz; 2. From http://pypi.python.org/pypi/xlrd Download xlrd-0.9.4.tar.gz; 3. Unzip the package; 4. Run under win7. [plain] view plain copy cmd ...

Posted by SystemOverload on Thu, 02 Jul 2020 17:02:27 +0200

TF actually uses Vagrant to install Tungsten Fabric

This is an original article by Chen Gang, a Suning network architect. 01 prepare the tester The 16G laptop didn't run, so it simply put together a game studio level machine: dual E5-2860v3 CPU, 24 core 48 threads, 128G DDR4 ECC memory, NVME disk 512G. Open 5 VM S on it and pretend to be physical serve ...

Posted by prasanthmj on Fri, 19 Jun 2020 04:27:47 +0200

Image image and Container basic chapter

preface This is a basic article about image and container, although some of it is related to the article written in 18 years Enter the door of Docker and Kubernetes container world There are overlaps, but with my familiarity with containers in recent years, I would like to share some of my knowledge and serve as a technical foreshadowing for my ...

Posted by jchemie on Sat, 13 Jun 2020 09:16:31 +0200

Python crawler example: News total crawling

Python crawler example: News total crawling preface analysis Web page parsing Stock data source Proxy IP code implementation summary preface Some time ago, due to the needs of tasks, it was necessary to climb the number of news of Shanghai Stock Exchange 50 index component stocks on certain da ...

Posted by HavokDelta6 on Thu, 11 Jun 2020 07:10:42 +0200

Detailed explanation of the flash framework of python

Flask itself is equivalent to a kernel. Almost all other functions need to be extended, which needs to be implemented by third-party extensions. For example, you can use flask extensions to add ORM, form verification tools, file upload, authentication, etc. There is no default database for flask. You ...

Posted by Muggin on Thu, 11 Jun 2020 06:29:20 +0200

Asyncpy use documentation

1 create project Install the required environment python version needs > = 3.6 Installation command: pip install asyncpy After the installation is complete, you can start creating a crawler project. Create project command: asyncpy genspider demo Create a project called demo. After the creation is successful, open the project file. The projec ...

Posted by xnor82 on Thu, 11 Jun 2020 05:39:52 +0200

Python docx operation word, insert the picture at the specified location

python-docx operates on word and inserts the picture in the specified position. introduce Install Python docx Import package Connect the word document to be operated on Add text Add picture Add table run object location Table positioning Paragraph positioning (text positioning) Complete code ...

Posted by markjia on Wed, 10 Jun 2020 08:13:16 +0200

Operation and maintenance to build CTFd online shooting range

CentOS7.2 build ctfd shooting range platform reference resources First, there is a 2-core 4G memory 30G disk with no interface in CentOS 7.2 Then network bridging mode Configure the yum source of CentOS7 to be Alibaba's 1. Install git yum provides git yum -y install git 2. Install pip (with pi ...

Posted by svanderclock on Tue, 09 Jun 2020 08:32:52 +0200

Flash implements HTTP token authentication HTTP token auth

Token authentication In restful design, user authentication mode usually uses json web token instead of traditional HTTP Basic authentication (incoming account password) The token authentication mode is as follows: add token to the request header Implementation in Flask Flask extension flask httpauth provides the authentication ...

Posted by hchsk on Thu, 21 May 2020 16:58:01 +0200

B station video download batch splicing synthesis tool

Introduction Station B is very simple for downloading a single video. You can install plug-ins in the browser, which will not be covered here. This paper mainly introduces the batch download and resource integration of multi-P video. There are two ways: Execute py script Run exe tool preparation 1. Download B station client in windows store   ...

Posted by leeroy1 on Fri, 15 May 2020 07:51:47 +0200