目录
1、Python 执行shell脚本且添加变量
2、Python2 获取两日期之间的每一天
3、python中sys, getopt模块处理命令行参数
4、 pymysql的批量插入
1、Python 执行shell脚本且添加变量
import os
os.system('/home/bigdataservice/service/appkeymetedata/appkeyHbase.sh ' + day)
2、Python2 获取两日期之间的每一天
import datetime
def getEveryDay(begin_date,end_date):
date_list = []
begin_date = datetime.datetime.strptime(begin_date, "%Y-%m-%d")
end_date = datetime.datetime.strptime(end_date,"%Y-%m-%d")
while begin_date <= end_date:
date_str = begin_date.strftime("%Y-%m-%d")
date_list.append(date_str)
begin_date += datetime.timedelta(days=1)
return date_list
print getEveryDay('2016-01-01','2017-05-11')
3、python中sys, getopt模块处理命令行参数
如果想对python脚本传参数,python中对应的argc, argv(c语言的命令行参数)是什么呢?
需要模块:sys
参数个数:len(sys.argv)
脚本名: sys.argv[0]
参数1: sys.argv[1]
参数2: sys.argv[2]
文件名:paremters.py
#!/usr/bin/python
# -*- coding: UTF-8 -*-
import sys
print "脚本名:", sys.argv[0]
for i in range(1, len(sys.argv)):
print "参数", i, sys.argv[i]
[root@tagtic-slave01 yuhui]# python paremters.py 111 222 333
脚本名: paremters.py
参数 1 111
参数 2 222
参数 3 333
4、 pymysql的批量插入
# coding=utf-8
'''
pymysql的批量插入
DROP TABLE IF EXISTS `EMPLOYEE`;
CREATE TABLE `EMPLOYEE` (
`name` varchar(11) NOT NULL COMMENT 'name',
`age` int NOT NULL COMMENT 'age',
`sex` varchar(6) NOT NULL COMMENT 'sex'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
'''
import pymysql.cursors
conn = pymysql.connect(host='localhost',
port=3306,
user='root',
password='123456',
db='realtimedatawarehouse',
charset='utf8')
cursor = conn.cursor()
count = 0
posts = []
L = []
L.append(('xiaoming', 31, 'boy'))
L.append(('hong', 22, 'girl'))
L.append(('wang', 90, 'man'))
try:
sql = "INSERT INTO EMPLOYEE(name, age, sex) VALUES (%s,%s,%s)"
ret = cursor.executemany(sql, L)
conn.commit()
except Exception as e:
print("batch Exception:", e)
cursor.close()
conn.close()