def deleteDb(pid):
de = session.query(Passwd).get(pid)
if de:
session.delete(de)
session.commit()
print(lang('db_del_succ_left') + str(pid) + lang('db_del_succ_right'))
else:
print(lang('db_del_fail'))
def returnPassword(passwd, name):
clipboard.copy(passwd)
print(
lang('getpw_show_left') + '\t\033[31m' + passwd + '\033[0m\n' +
lang('getpw_show_right'))
if name:
print(lang('getpw_save'))
exit()
def deleteDb(pid):
conn = sqlite3.connect(DB_PATH)
c = conn.cursor()
checkDB(c)
c.execute('DELETE from passwd where id=' + str(pid))
conn.commit()
o = conn.total_changes
if o == 0:
print(lang('db_del_fail'))
if o == 1:
print(lang('db_del_succ_left') + str(pid) + lang('db_del_succ_right'))
conn.close()
def selectDb(pid, name):
res = session.query(Passwd)
x = PrettyTable(['id', 'name', 'password', 'time'])
x.align['name'] = 'l'
x.padding_width = 1
if pid:
res = res.filter_by(id=pid)
elif name:
res = res.filter(Passwd.name.like('%' + name + '%'))
res = res.all()
if not res:
print(lang('db_no_emp'))
exit()
for i in res:
x.add_row(obj2list(i))
print(x)
def selectDb(pid, name):
conn = sqlite3.connect(DB_PATH)
c = conn.cursor()
checkDB(c)
select = "SELECT * from passwd "
if name:
select += ('where name LIKE \'%' + name + '%\'')
if pid:
select += ('where id = \'' + str(pid) + '\'')
select += 'ORDER BY id DESC'
res = list(c.execute(select))
if len(res) == 0:
print(lang('db_no_emp'))
else:
x = PrettyTable(['id', 'name', 'password', 'time'])
x.align['name'] = 'l'
x.padding_width = 1
for row in res:
x.add_row(list(row))
print(x)
conn.close()
# 输出结果
def returnPassword(passwd, name):
clipboard.copy(passwd)
print(
lang('getpw_show_left') + '\t\033[31m' + passwd + '\033[0m\n' +
lang('getpw_show_right'))
if name:
print(lang('getpw_save'))
exit()
# 主函数
if __name__ == "__main__":
# 设置命令行参数
parser = argparse.ArgumentParser()
parser.description = lang('getpw_desc')
parser.add_argument("-v",
"--version",
action='version',
version='%(prog)s 1.0')
parser.add_argument('length', type=int, help=lang('getpw_leng'), nargs='?')
parser.add_argument('-n', '--name', help=lang('getpw_leng'))
group = parser.add_mutually_exclusive_group()
group.add_argument("-s",
"--simple",
help=lang('getpw_simp'),
action="store_true")
group.add_argument("-c",
"--commonly",
help=lang('getpw_comm'),
#!/usr/bin/env python3
# -*- coding: UTF-8 -*-
##########################################################################
# Name: seepw.py #
# Author: FungLeo #
# Date: 2017-12-20 #
# Purpose: used to manage the password saved in the database #
# Copy: for study, prohibition of commercial use #
##########################################################################
import db
import argparse
from pwlang import lang
if __name__ == '__main__':
parser = argparse.ArgumentParser()
parser.description = lang('seepw_desc')
parser.add_argument("-v",
"--version",
action='version',
version='%(prog)s 1.0')
group = parser.add_mutually_exclusive_group()
group.add_argument("-i", "--id", help=lang('seepw_id'))
group.add_argument("-n", "--name", help=lang('seepw_name'))
group.add_argument("-d", "--delete", help=lang('seepw_dele'))
args = parser.parse_args()
name = args.name if args.name else False
pId = args.id if args.id else False
dId = args.delete
if dId:
if dId.isdigit():