ficapy ficapy

40 followers · 24 following

GuangZhou
https://www.zoulei.net

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

ficapy / single_vs_batch_update.py

Created December 27, 2017 10:59

Postgresql 批量更新对比单条更新

	#!/usr/bin/env python
	# -- coding: utf-8 --
	# Author: ficapy

	import random
	import csv
	import time
	from functools import wraps
	from io import StringIO
	from contextlib import closing, contextmanager

ficapy / gitlab_ci_navigate.go

Created December 24, 2017 10:01

	package main

	import (
	"encoding/gob"
	"encoding/json"
	"fmt"
	"os"
	"strings"
	"sync"

ficapy / proxy_dns.go

Created December 19, 2017 03:44

对特定域名根据内网域名是否可以访问返回特定的ip

	package main

	import (
	"log"
	"net"
	"os"
	"os/signal"
	"syscall"
	"time"

ficapy / paramiko_with_tty.py

Created December 12, 2017 08:28

paramiko_with_tty demo

	#!/usr/bin/env python
	# -- coding: utf-8 --
	# Author: ficapy
	# Create: '12/12/2017'

	import os
	import threading
	from paramiko import SSHConfig, SSHClient, AutoAddPolicy

	HOSTNAME = 'aliyun'

ficapy / .env

Created October 10, 2017 08:44

sentry docker-compse

	POSTGRES_USER=sentry
	POSTGRES_PASSWORD=sentry
	POSTGRES_DBNAME=sentry

	SENTRY_SECRET_KEY=CHANGEME
	SENTRY_REDIS_HOST=redis
	SENTRY_POSTGRES_HOST=postgres
	SENTRY_DB_USER=sentry
	SENTRY_DB_PASSWORD=sentry

ficapy / bearychat_websocket.py

Created September 7, 2017 10:34

使用websocket和bearychat进行长连接。当服务器接收到消息后执行动作返回消息

	import re
	import json
	from urllib.parse import urlencode
	from config import BEARYCHAT_TOKEN
	from tornado.ioloop import IOLoop, PeriodicCallback
	from tornado.httpclient import AsyncHTTPClient
	from tornado import gen
	from tornado.websocket import websocket_connect

ficapy / tornado_db.py

Created August 1, 2017 03:37

tornado 数据库操作

	#!/usr/bin/env python
	# -- coding: utf-8 --
	# Author: ficapy
	import threading
	import functools
	import tornado.ioloop
	import tornado.web
	from sqlalchemy import Column, create_engine
	from sqlalchemy.dialects.mysql import INTEGER, BIT, VARCHAR
	from sqlalchemy.ext.declarative import declarative_base

ficapy / optimistic_lock.py

Created June 15, 2017 08:58

乐观锁和悲观锁以及事物隔离级别

	# !/usr/bin/env python
	# -- coding: utf-8 --
	# Author: ficapy

	import time
	import threading
	from threading import Thread
	from sqlalchemy import create_engine, Column, Integer
	from sqlalchemy.orm import sessionmaker
	from sqlalchemy.ext.declarative import declarative_base

ficapy / sqlalchemy_test.py

Created June 2, 2017 12:51

namedtuple搭配sqlalchemy进行测试

	#!/usr/bin/env python
	# -- coding: utf-8 --
	# Author: ficapy
	# Create: '5/25/17'

	import inspect
	from datetime import datetime
	from sqlalchemy import inspection
	from collections import namedtuple
	from sqlalchemy import create_engine, Column, Integer, String, DateTime

ficapy / sqlalchemy_dict.py

Last active March 8, 2019 06:15

让sqlalchemy返回的结果为字典

	#!/usr/bin/env python
	# -- coding: utf-8 --
	# Author: ficapy

	from sqlalchemy import create_engine, Column, BIGINT
	from sqlalchemy.orm import sessionmaker
	from sqlalchemy.ext.declarative import declarative_base

	sqlalchemy_db = 'sqlite://'