import sys
import os.path
-def main(args=sys.argv[1:]):
- # Argument parsing
+def parse_args():
parser = argparse.ArgumentParser(
description="Latin famous phrases in the terminal.")
parser.add_argument("-i", "--id",
parser.add_argument("-o", "--open",
type=int,
help="specify the id of a specific phrase to print.")
- args = parser.parse_args()
+ return parser.parse_args()
- # find phrase file
- if args.file:
- phrase_file = args.file
- if os.path.isfile("phrases.db"):
- phrase_file = "phrases.db"
- elif os.path.isfile("/usr/local/share/phrases/phrases.db"):
- phrase_file = "/usr/local/share/phrases/phrases.db"
- else:
- sys.exit("cannot find the phrase database!")
-
- conn = sqlite3.connect(phrase_file)
- c = conn.cursor()
- c.execute("SELECT * FROM phrases WHERE length <= (?) AND length >= (?)",
- (args.max, args.min))
- data = c.fetchall()
- rown = randint(0, len(data))
- row = list(data[rown])
-
- # Output as specified in flags
+def output(args, row, numx):
if not (args.id
or args.latin
or args.english
if args.notes:
print(row[3])
if args.num:
- print(len(data))
+ print(numx)
sys.exit(0)
+def find_file(args):
+ if args.file:
+ return args.file
+ if os.path.isfile("phrases.db"):
+ return "phrases.db"
+ elif os.path.isfile("/usr/local/share/phrases/phrases.db"):
+ return "/usr/local/share/phrases/phrases.db"
+ else:
+ sys.exit("cannot find the phrase database!")
+
+def main(args):
+ c = sqlite3.connect(find_file(args)).cursor()
+ c.execute("SELECT * FROM phrases WHERE length <= (?) AND length >= (?)",
+ (args.max, args.min))
+ data = c.fetchall()
+ output(args, list(data[randint(0, len(data))]), len(data))
+
if __name__ == "__main__":
- main()
+ main(parse_args())