Skip to content

Instantly share code, notes, and snippets.

@ficapy
ficapy / proxy_dns.go
Created December 19, 2017 03:44
对特定域名根据内网域名是否可以访问返回特定的ip
package main
import (
"log"
"net"
"os"
"os/signal"
"syscall"
"time"
@ficapy
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
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
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
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
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
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
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://'
@ficapy
ficapy / test_sqlalchemy.py
Created December 14, 2016 07:10
sqlalchemy+pytest
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# Author: Ficapy
# Create: '12/14/16'
import pytest
from sqlalchemy import create_engine, Column, BIGINT
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.exc import IntegrityError
@ficapy
ficapy / README.md
Last active December 12, 2016 06:47
celery+sqlalchemy architecture demo
  1. 启动celery

    celery -A base_celery worker --loglevel=info 
    
  2. 关闭celery(所有任务将丢失不会重启)

pkill -9 -f 'celery worker'