作者文章归档:陈海峰

[ fastapi使用sqlalchemy+mysql ]


sqlalchemy中使用mysql

一.依赖安装

第三方包

pip install sqlalchemy
pip intalll pymysql

二.在fastapi中使用

databases.py文件 1. engine创建连接 2. sessionlocal为获取连接 3. Base用来映射数据库表

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

SQLALCHE

< Read more >

[ go-zero消息中间件[消息队列,定时任务] ]


前置条件

安装中间价 1. kafka+zookeeper消息队列 2. Beanstalks(要求至少2个)+redis定时任务

消息队列api服务目录结构

:.
│  table.api
│  table.go
│
├─etc
│      table-api.yaml
│
└─internal
    ├─config
    │      config.go
    │
    ├─handler
    │      routes.go
    │      tablehandler.go
    │
    ├─logic
    │      tablelogic.go
    

< Read more >

[ ip代理池 ]


python的免费ip代理池

GIT-HUB地址

1. 拉取代码

2. 修改docker-compose.yml文件内容为(指定自己的redis)

version: "3"
services:
  proxypool:
    image: "germey/proxypool:master"
    container_name: proxypool
    ports:
      - "5555:5555"
    restart: always
    environment:
      PROXYPOOL_REDIS_HOS

< Read more >

[ go-zero权限管理 ]


权限管理

先创建一个表

1. tablemodel.go

package model

import "time"

// 保存所有表

type TablesModel struct {
    Id       int64
    Name     string    `xorm:"varchar(64) notnull 'name' comment('表名')"`
    Url      string    `xorm:"varvhar(64) notnull 'url' comment(

< Read more >

[ docker部署beanstalkd ]


beanstalkd消息队列部署

docker-compose.yml

version: '3'
services:
  beanstalkd-node1:
   image: schickling/beanstalkd
   container_name: beanstalkd-node1
   command: -b /data
   volumes:
     - ./data1:/data
   ports:
      - 11300:11300
  beanstalkd-node2:
   image: schickling/beanstalkd
   contai

< Read more >