今天遇到一个要破解的栅栏密码，先给大家介绍通用的脚本。 方法一(通用脚本)：#!/usr/bin/env python# -*- coding: gbk -*-# -*- coding: utf_ -*-e = raw_input(‘请输入要解密的字符串\n‘)elen = len(e)field=[]for i in range(,elen):if(elen%i==):field.append(i)for f in field:b = elen / fresult = {x:‘‘ for x in range(b)}for i in range(elen):a = i % b;result.update({a:result[a] + e[i]})d = ‘‘for i in range(...
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/45841221#!/usr/bin/env python# -*- coding:utf-8 -*-""" Purpose: 生成日汇总对账文件 Created: 2015/4/27 Modified:2015/5/1 @author: guoyJoe"""#导入模块import MySQLdbimport timeimport datetimeimport os#日期today = datetime.date.today()yestoday = today - datetime.timedelta(days=1)#对账日期checkAcc_date = yestoday.strftime(‘%Y%m%d‘)#对账...
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/45841117#!/usr/bin/env python# -*- coding:utf-8 -*-""" Purpose: 生成日明细账单数据 Created: 2015/4/21 Modified:2015/4/24 @author: guoyJoe"""#导入模块import MySQLdbimport timeimport datetimeimport os#日期today = datetime.date.today()yestoday = today - datetime.timedelta(days=1)#账单日期date_acct = yestoday.strftime(‘%Y%m%d‘)#SQL语句...
import pdb 2 pdb.set_trace() 3 a = "aaa" 4 b = "bbb" 5 c = "ccc" 6 final = a + b + c 7 print final 使用pdb调试python脚本标签：本文系统来源：http://www.cnblogs.com/kidsitcn/p/4746127.html
脚本功能： 1.自动创建备份目录 2.自动备份数据库的每个表,并压缩 3.备份结果，邮件通知联系人 4.脚本内容#!/usr/bin/env python # --*-- coding:UTF-8 --*-- # Create by JIANGLEI.YU on 2016/04/21 # 多表自动备份ok。发送邮件失败。 import MySQLdb import sys import os import datetime import smtplib from email.mime.text import MIMEText import sys# Define Mysql Environments Hostname=‘192.168.0.141‘ ...
#!/usr/bin/python # -*- coding:utf-8 -*- import sqlite3 import osclass SQLTest: ‘‘‘sqlite数据库接口‘‘‘ def __init__(self,path=‘‘,verbose=False): self.verbose = verbose self.path = path if os.path.isfile(path): self.conn = sqlite3.connect(path) if self.verbose: print(‘硬盘上面:[{}].format(path)‘) else: ...
http://blog.csdn.net/HorkyChen/article/details/23307921 http://blog.csdn.net/horkychen/article/details/9372039 http://blog.csdn.net/horkychen/article/details/7800048GDB 运行PYTHON 脚本+python 转换GDB调用栈到流程图标签：本文系统来源：http://www.cnblogs.com/zengkefu/p/5562315.html
#!/usr/bin/python# -*- coding: utf-8 -*-#!/usr/bin/env pythonimport MySQLdbimport sysimport xlsxwriterreload(sys)sys.setdefaultencoding(‘utf-8‘)#创建一个EXCEL文件workbook = xlsxwriter.Workbook(‘name.xlsx‘)#EXCEL的文件名#创建一个工作表对象worksheet_1 = workbook.add_worksheet(‘name_1‘)#sheet页面1的名字worksheet_2 = workbook.add_worksheet(‘name_2‘)#sheet页面2的名字#需要更多的sheet页面以此类推...
有些情况下，可能会统计在某个时间段内，MySQL修改了多少数据量？发生了多少事务？主要是哪些表格发生变动？变动的数量是怎么样的？ 但是却不需要行记录的修改内容，只需要了解 行数据的 变动情况。 这些情况部分可以通过监控来大致了解，但是也可以基于binlog来全盘分析，binlog的格式是row模式。 在写flashback的时候，顺带把这个也写了个脚步，使用python编写，都差不多原理，只是这个简单些，介于个人python弱的不行，...
设置计划任务每小时备份一次方便恢复单表：0 */1 * * * /root/python/mysqldump_table.py >/dev/null 2>&1 欢迎各位一起交流。MySQL 整库单表备份 for python脚本标签：read root purge isp ack data ant tran base 本文系统来源：http://www.cnblogs.com/hmysql/p/7239818.html
yum install mysql-serverservice mysqld start[root@LVS1 ~]# mysql -u rootmysql> SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘123456‘);mysql> show databases;mysql> use mysql;mysql> show databases;mysql>quityum install MySQL-python########################################################!/usr/bin/env python#encoding=utf-8import MySQLdbtry: conn=MySQLdb.connect(host=‘localhost‘,user...
f = open("xx.txt",‘w‘)2 for i in range(1,50001):3 str_i = str(i)4 realname = "lxs"+str_i5 phone = 13678101715 + i6 email = "lxs" + str_i +"@126.com"7 sql = ‘insert into table_a (realname,phone,email,sign,event_id) values ("‘+realname+‘",‘ +str(phone)+ ‘,"‘+email+‘",0,1);‘8 f.write(sql)9 f.write("\n") 10 print(‘50000 success!‘) 11 f.close() python脚本批量生成...
[root@LVS1 bin]# cd myweb[root@LVS1 myweb]# pwd/tmp/python/Django-1.5.1/django/bin/myweb/mywebvi view.pyfrom django.http import HttpResponseimport datetime,time,osdef hello(request): return HttpResponse(‘hello my name is xk‘)def current_time(request): now=datetime.datetime.now() html="It is now :%s"%now return HttpResponse(html)def cpu(request): status=os.popen...
#!/usr/bin/pythonimport os,sys,pymysqlmysqlbase = ‘/usr/local/mysql/bin/‘if len(sys.argv) == 1: print(‘format: python + Script_name + user + password + ip‘)elif sys.argv[1] == ‘-h‘: print(‘format: python + Script_name + user + password + ip‘)else: user = sys.argv[1] passw = sys.argv[2] ip = sys.argv[3] dbnam=os.popen(mysqlbase+‘mysql -h‘+ip+‘ -u‘+user+‘ -p‘+passw+...
charset="utf8", )# 使用cursor()方法获取操作游标cur = conn.cursor()# 使用execute方法执行SQL语句data = cur.execute("select id,phone,num,name from test.user_info;")# print datainfo = cur.fetchmany(data)cur.close()conn.commit()conn.close()def dd(info): s = "" for i in info: #print i[0] #print i[1] #print i[2] #print i[3].decode(utf-8) # 汉字需要 decode 成utf-8 s += %...