wcommon 1.3.6.2

常用工具类方法集合

This is my common Python tool classes.

/data/apps/public/conf.ini content like:

[mysql]
host=example.com
port=3306
user=username
passwd=password
database=test
charset=utf8mb4

Find the localhost internal network ip:

from wcommon import *
ip = getLocalIp()
hostname = getLocalHostname()

Decode unusual json string:

from wcommon import *
line = """
{
    name:'java',
    system:'linux'
}
"""
result = dejson(line)
# output result
{"name":"java","system":"linux"}

Operate mysql data:

mysql = Mysql(configuraion_file="/data/apps/public/conf.ini", section="mysql")

# query
rows = mysql.query("select * from example_table where status = %s order by id desc limit %s",(1,10))
for row in rows:
    print(row)

# bulk_insert
mysql.bulk_insert("test.person",["name","age"],[["mahuateng",40],["liyanhong",39]])

# bulk_insert
mysql.bulk_insert2("test.person",[{"name":"ma2","age":40},{"name":"liyanhong2","age":39},{"name":"ren"}] )

Feature

1.3.5

Mysql insert语句执行的时候，忽略值为None的字段。