一灾搏、將Oracle中的某張表導(dǎo)出到csv文件
import cx_Oracle
import pandas as pd
conn = cx_Oracle.connect('username', 'password', '127.0.0.1:1521/TESTDB')
sql = 'SELECT * FROM student'
df = pd.read_sql(sql, conn)
df.to_csv('student.csv')
print(df.head())
二缴淋、獲得自身進(jìn)程號(hào)并殺掉自身進(jìn)程
import os
import time
# 獲得當(dāng)前進(jìn)程號(hào)
pid = os.getpid()
print('pid:', pid)
for i in range(100):
print(i)
time.sleep(0.5)
if i == 11:
# 結(jié)束當(dāng)前進(jìn)程
os.system('kill -9 {}'.format(pid))
