导入用户到Discuz论坛

import torndb

db_info1 = dict(
	host = "127.0.0.1:3306", 
	data = "data_test",
	user = "root",
	password = "password")

db_info2 = dict(
	host = "127.0.0.1:3306", 
	data = "dz_bbs",
	user = "root",
	password = "password.c0m")

db1 = torndb.Connection(
            host = db_info1.get('host'), 
            database = db_info1.get('data'),
            user = db_info1.get('user'),
            password = db_info1.get('password')
            )

db2 = torndb.Connection(
            host = db_info2.get('host'), 
            database = db_info2.get('data'),
            user = db_info2.get('user'),
            password = db_info2.get('password')
            )

sql = "select username, password from temp_users order by id;"
ret = db1.query(sql)

salt = '123645'

for item in ret:
	username = item.get('username')
	password = item.get('password')
	sql = "insert into pre_ucenter_members (username,password,salt) values('%s', md5(concat(md5('%s'),'%s')),'%s');" % (username, password, salt, salt)
	db2.execute(sql)