Basic details of MySQL (the essence of writing sql statements is English translation + mathematical logic!)
MySQL introduction
/*
MySQL database management system (file management system in essence)
Advantages over ordinary files: 1. Easy to manage data; 2. Suitable for complex multi-threaded operations
In MySQL: database database (essentially folder)
Create database: name of create database;
Display dat ...
Posted by adt2007 on Sun, 15 Mar 2020 03:56:00 -0700
Basic use of ElasticSearchLogstash
The second week, today we will talk about the use of Logstash.
First, we open ES, use postman to create a new index user, and use PUT mode in postman to send requests to localhost:9200/user. See the return information:
{
"acknowledged": true,
"shards_acknowledged": true,
"index": "user"
}
This indicates that the index was est ...
Posted by MisterWebz on Sun, 15 Mar 2020 02:19:24 -0700
docker deployment Django project (front and back end separation project)
First step
Switch yum source: https://blog.csdn.net/wangshuminjava/article/details/84380308
The second step
1. Install docker
https://www.runoob.com/docker/centos-docker-install.html
Modify the docker image source: https://blog.csdn.net/l848168/article/details/83378298
2. Install docker compos ...
Posted by realchamp on Sun, 15 Mar 2020 00:39:41 -0700
Python self study notes - Chapter 6 object oriented programming
3. Magic method
Python's objects naturally have some magical methods. They are always surrounded by double underscores. They are everything of object-oriented python. They are special methods that can add magic to your class. If your object implements (overloads) one of these methods, then this method will be called by Python in a special case. ...
Posted by suspect on Fri, 13 Mar 2020 03:08:30 -0700
@EnableAutoConfiguration loads custom META-INF without scanning
In this paper, a simple simulation of auto-configuration is performed to understand the process of auto-configuration.And we wrote a small example to test it.
Automatic assembly: The purpose is to load the required module components without the developer using @ComponentScan @EnableXXX.
SpringBoot use ...
Posted by danesc on Thu, 12 Mar 2020 17:48:43 -0700
express learning notes (generate project, route, route handler, use mysql, ejs template)
Generation project
Sir, a package.json
cnpm init
Node? Modules folder, which contains the modules provided by node.js
cnpm install
Install Express scaffolding
cnpm i express-generator
Install express
**cnpm install express --save**
Create an Express application named myapp, use ejs template engine ...
Posted by mrwutang on Wed, 11 Mar 2020 22:31:25 -0700
[python] context manager
What is context manager
In short, the purpose of the context manager is to specify the scope of use of the object. If it is out of the scope, take the corresponding "processing"; for example:
f = open('filename.txt')
data = f.read()
f.close()
Open a file, read the contents of the file, a ...
Posted by quimkaos on Wed, 11 Mar 2020 00:16:17 -0700
Truncate all tables in MySQL database with one command?
Is there a query (command) that truncates all tables in the database in one operation? I wonder if this can be done through a query.
#1 building
I found that even after NOCHECK CONSTRAINT ALL, TRUNCATE TABLE.. still has a foreign key constraint problem, so I used the DELETE FROM statement instead. This does mean that the identity seed wi ...
Posted by scottlowe on Tue, 10 Mar 2020 05:08:01 -0700
XCTF University Battle "Epidemic" Network Security Sharing Contest WEB_WP
Article Directory
XCTF University Battle "Epidemic" Network Security Sharing Competition
easy_trick_gzmtu
webtmp
hackme
fmkq
PHP-UAF
nweb
sqlcheckin
XCTF University Battle "Epidemic" Network Security Sharing Competition
easy_trick_gzmtu
First of all, it's really a good id ...
Posted by jorje on Mon, 09 Mar 2020 19:29:37 -0700
Using sqlalchemy ORM to create tables and insert data
https://blog.csdn.net/littlely_ll/article/details/82706874
1. in storage
import datetime
import pandas as pd
import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy.sql import text, func
from sqlalchemy.orm import sessionmaker,relationship
from sqlalchemy.ext.declarative import decla ...
Posted by kane007 on Mon, 09 Mar 2020 02:28:32 -0700