python3 ftp模块_Python3连接MySQL数据库,python的FTP模块

mysql的库倒是不少的，其中比较著名就是mysqldb(Django项目都使用它；我也在开发测试系统时也使用过)，见：http://sourceforge.net/projects/mysql-python/

不过，目前mysqldb并不支持python3.x，网上找了一些方法，后来我还是偶然发现mysql官方已经提供了mysql连接器，而且已经有支持python3.x的版本了。mysql Connector/python, a self-contained python driver for communicating with mysql servers. 这个用起来还是感觉比较顺手的。

关于mysql Connector/python的各种介绍、安装、API等文档，还是参考官网吧：http://dev.mysql.com/doc/connector-python/en/index.html(注意：安装程序将关于mysql Connnector的python2的源文件复制到了python3库的位置(运行时会报语法错误)，我就直接手动复制了其中python3/目录下的文件过去就解决。)

另外，python3.x连接mysql的其他方案有：oursql, Pymysql, myconnpy 等，参考如下链接：

http://packages.python.org/oursql/

https://github.com/petehunt/Pymysql/

https://launchpad.net/myconnpy

下面只是贴一个试用 mysql Connector/python 的python脚本吧(包括创建表、插入数据、从文件读取并插入数据、查询数据等)：

#!/usr/bin/python3

# a sample to use mysql-connector for python3

# see details from http://dev.mysql.com/doc/connector-python/en/index.html

import mysql.connector

import sys, os

user = 'root'

pwd = '123456'

host = '127.0.0.1'

db = 'test'

data_file = 'mysql-test.dat'

create_table_sql = "CREATE TABLE IF NOT EXISTS mytable (

id int(10) AUTO_INCREMENT PRIMARY KEY,

name varchar(20), age int(4) )

CHARACTER SET utf8"

insert_sql = "INSERT INTO mytable(name, age) VALUES ('Jay', 22 ), ('杰', 26)"

select_sql = "SELECT id, name, age FROM mytable"

cnx = mysql.connector.connect(user=user, password=pwd, host=host, database=db)

cursor = cnx.cursor()

try:

cursor.execute(create_table_sql)

except mysql.connector.Error as err:

print("create table 'mytable' failed.")

print("Error: {}".format(err.msg))

sys.exit()

try:

cursor.execute(insert_sql)

except mysql.connector.Error as err:

print("insert table 'mytable' failed.")

print("Error: {}".format(err.msg))

sys.exit()

if os.path.exists(data_file):

myfile = open(data_file)

lines = myfile.readlines()

myfile.close()

for line in lines:

myset = line.split()

sql = "INSERT INTO mytable (name, age) VALUES ('{}', {})".format(myset[0], myset[1])

try:

cursor.execute(sql)

except mysql.connector.Error as err:

print("insert table 'mytable' from file 'mysql-test.dat' -- failed.")

print("Error: {}".format(err.msg))

sys.exit()

try:

cursor.execute(select_sql)

for (id, name, age) in cursor:

print("ID:{} Name:{} Age:{}".format(id, name, age))

except mysql.connector.Error as err:

print("query table 'mytable' failed.")

print("Error: {}".format(err.msg))

sys.exit()

cnx.commit()

cursor.close()

cnx.close()

另外，最后再贴一个使用mysqldb的python2.x代码示例吧：

#!/usr/bin/python2.7

# coding=utf-8

import MySQLdb

import sys

host = 'localhost'

user = 'root'

pwd = '123456' # to be modified.

db = 'test'

if __name__ == '__main__':

conn = MySQLdb.connect(host, user, pwd, db, charset='utf8');

try:

conn.ping()

except:

print 'failed to connect MySQL.'

sql = 'select * from mytable where id = 2'

cur = conn.cursor()

cur.execute(sql)

row = cur.fetchone()

# print type(row)

for i in row:

print i

cur.close()

conn.close()

sys.exit()

from ftplib import FTP

import socket #用来设置超时时间

FTP.connect(服务器地址,端口,超时时间) # 连接服务器

FTP.login(用户名,用户密码) # 用户登录

FTP.pwd(路径) # 读取操作路径

FTP.cwd(路径) # 设置要操作FTP文件夹路径

FTP.nlst()# 获得目录下文件

FTP.retrbinary(文件名, 回调函数) # 下载FTP上的文件

FTP.delete(文件名) # 删除FTP文件

FTP.storbinary(文件名, 文件对象 [,块大小]) # 上传FTP文件

FTP.quit() # 退出FTP服务器

FTP.set_pasv(boolean) # 是否设置为被动模式

FTP.rename(old, new) # 重命名

FTP.delete(path) # 删除文件

FTP.mkd(directory) # 创建目录

一个上传代码：

import socket

from ftplib import FTP

ftp_server='xx.xx.xx.xx'

ftp_user='xxxxx'

ftp_password='xxxxx'

ftp_backup_dir='backup'

newday = date.today() #获取今天的日期

oldday = date.today()-timedelta(5) #获得5天前的日期

newfile = '/home/backup/' + 'backup_data_' + str(newday.year) + '.' + str(newday.month) + '.' + str(newday.day) + '.zip' #本次备份文件名(绝对路径)

oldfile = '/home/backup/' + 'backup_data_' + str(oldday.year) + '.' + str(oldday.month) + '.' + str(oldday.day) + '.zip' #5天前备份的文件名(绝对路径)

def upload():

socket.setdefaulttimeout(60) #超时FTP时间设置为60秒

ftp = FTP(ftp_server)

print("login ftp...")

try:

ftp.login(ftp_user, ftp_password)

print(ftp.getwelcome()) #获得欢迎信息

try:

if ftp_backup_dir in ftp.nlst():

print("found backup folder in ftp server, upload processing.")

else:

print("don't found backup folder in ftp server, try to build it.")

ftp.mkd(ftp_backup_dir)

except:

print("the folder" + ftp_backup_dir + "doesn't exits and can't be create!")

sys.exit()

except:

print("ftp login failed.exit.")

sys.exit()

ftp.cwd(ftp_backup_dir) #设置FTP路径

print("upload data...")

try:

ftp.storbinary('STOR ' + os.path.basename(newfile), open(newfile,'rb'), 1024) #上传备份文件

except:

print("upload failed. check your permission.")

print("delte old file...")

try:

ftp.delete(os.path.basename(oldfile)) #删除5天前的备份文件

except:

print("the old file in ftp doesn't exists, jumped.")

print("ftp upload successful.exit...")

ftp.quit()

if __name__== '__main__':

upload()