Skip to content

Instantly share code, notes, and snippets.

@mydreambei-ai
mydreambei-ai / sqlalchemy_dict_result.py
Created April 7, 2017 08:58
sqlalchemy get result as dict
from sqlalchemy import create_engine
from sqlalchemy import MetaData, Table, Column, Integer, String
engine = create_engine('sqlite:///:memory:', echo=True)
metadata = MetaData()
user = Table('user', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String(16), nullable=False))
@mydreambei-ai
mydreambei-ai / compile.sh
Created March 24, 2017 08:06
postgresql dynamic loading c functions
cc -fpic -c func.c -I`pg_config --includedir-server`
cc -shared -o func.so func.o
#mv func.so server dynamic lib directory
mv func.so `pg_config --pkglibdir`
cd `pg_config --pkglibdir`
chown root:root func.so
@mydreambei-ai
mydreambei-ai / compile.sh
Created March 24, 2017 08:06
postgresql dynamic loading c functions
cc -fpic -c func.c -I`pg_config --includedir-server`
cc -shared -o func.so func.o
#mv func.so server dynamic lib directory
mv func.so `pg_config --pkglibdir`
cd `pg_config --pkglibdir`
chown root:root func.so
@mydreambei-ai
mydreambei-ai / threadpool.py
Created March 20, 2017 09:09
python threading pool
import time
import threading
import pickle
import queue
class Worker(threading.Thread):
def __init__(self):
threading.Thread.__init__(self)
self._start = threading.Event()
self._lock = threading.Lock()
@mydreambei-ai
mydreambei-ai / systemd_onfailure.txt
Created March 3, 2017 08:20
systemd OnFailure send mail
#http://unix.stackexchange.com/questions/314329/mailx-not-sending-email-when-run-as-a-systemd-service
systemd send mail is odd, using mail must set flag -vv
# shadowsocks.service
[Unit]
Description=The Postgresql Server Restful API
OnFailure=failure-email@%n.service
[Service]
Type=simple
ExecStart=/usr/bin/sslocal -c /etc/shadowsocks.json
@mydreambei-ai
mydreambei-ai / csv2json.sh
Last active February 28, 2017 09:43
bash convert column file like /etc/passwd to json
#!/bin/bash
# ./csv2json.sh -s ":" -f /etc/passwd -F 1,7 -N user,shell|json_pp
usage() { echo "Usage: $0 [-s <field seprator>] [-f <file>] [-F <fields>] [-N <names>]" 1>&2; exit 1;}
while getopts ":s:f:F:N:" o;do
case "${o}" in
s)
SEP=${OPTARG}
@mydreambei-ai
mydreambei-ai / model.py
Last active December 2, 2022 18:07
sqlalchemy postgresql json data
from sqlalchemy import Column, String, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class City(Base):
__tablename__ = "citys"
@mydreambei-ai
mydreambei-ai / mock_class.py
Created December 8, 2016 09:35
modify class in running
class Lmy(object):
def sum(self, a, b, c=None):
if c is None:
return a + b
else:
return a + b + c
def do_data(self, data):
a, b = data
return self.sum(a, b)
[root@ip-11-0-0-239 centos]# firewall-cmd --zone=trusted --add-source=94.204.104.194/32
success
[root@ip-11-0-0-239 centos]# firewall-cmd --zone=trusted --add-source=94.206.104.194/32
success
[root@ip-11-0-0-239 centos]# firewall-cmd --zone=trusted
success
[root@ip-11-0-0-239 centos]# firewall-cmd --list-sources
You're performing an operation over default zone ('public'),
but your connections/interfaces are in zone 'trusted' (see --get-active-zones)
You most likely need to use --zone=trusted option.

NFS server setup

Install And Start Server
  1. yum -y install rpcbind zfs
  2. service rpcbind start
  3. service zfs start
Setup
  1. mkdir /home/nfs