#!/usr/bin/env python3
-# Display Latin famous phrases in the terminal
+# Display Latin famous phrases in the terminal - python version
# Armaan Bhojwani 2020
import argparse
-import random
+from random import randint
+import sqlite3
import sys
-import csv
+import os.path
-def main(args=sys.argv[1:]):
- # Argument parsing
- parser = argparse.ArgumentParser(description="Latin famous phrases in the terminal.")
- parser.add_argument("-e", "--english", action='store_true', help="Print the English translation.")
- parser.add_argument("-i", "--id", action='store_true', help="Print the id of the phrase.")
- parser.add_argument("-l", "--latin", action='store_true', help="Print the Latin phrase (default)")
- parser.add_argument("-m", "--min", default=0, type=int, help="Set the minimum length of the Latin phrase")
- parser.add_argument("-M", "--max", default=10000000, type=int, help="Set the maximum length of Latin phrase")
- parser.add_argument("-n", "--notes", action='store_true', help="Print any notes on phrase")
- args = parser.parse_args()
+def parse_args():
+ parser = argparse.ArgumentParser(
+ description="Latin famous phrases in the terminal.")
+ parser.add_argument("-i", "--id",
+ action='store_true',
+ help="print the id of the phrase.")
+ parser.add_argument("-l", "--latin",
+ action='store_true',
+ help="print the Latin phrase (default)")
+ parser.add_argument("-e", "--english",
+ action='store_true',
+ help="print the English translation.")
+ parser.add_argument("-n", "--notes",
+ action='store_true',
+ help="print any notes on phrase.")
+ parser.add_argument("-m", "--min",
+ default=0,
+ type=int,
+ help="set the minimum length of the Latin phrase.")
+ parser.add_argument("-M", "--max",
+ default=10000000,
+ type=int,
+ help="set the maximum length of Latin phrase.")
+ parser.add_argument("-p", "--num",
+ action='store_true',
+ help="print number of possible phrases.")
+ parser.add_argument("-f", "--file",
+ help="set the location of the phrase database.")
+ parser.add_argument("-o", "--open",
+ type=int,
+ help="specify the id of a specific phrase to print.")
+ return parser.parse_args()
- right_length = []
+def output(args, row, numx):
+ if not (args.id
+ or args.latin
+ or args.english
+ or args.notes
+ or args.num):
+ print(row[1])
+ sys.exit(0)
+ else:
+ if args.id:
+ print(row[0])
+ if args.latin:
+ print(row[1])
+ if args.english:
+ print(row[2])
+ if args.notes:
+ print(row[3])
+ if args.num:
+ print(numx)
+ sys.exit(0)
- # Find phrases of the right size
- with open('/usr/share/phrases/phrases.csv') as f:
- reader = csv.reader(f)
- all_lines = list(reader)
- next(reader, None) # skip header
- for row in all_lines:
- try:
- if args.max >= int(row[4]) >= args.min: # generate a shortlist of phrases of the right length
- right_length.append(row[0])
- except:
- pass # skip malformed rows
+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!")
- try:
- chosen = int(right_length[random.randint(0, len(right_length) - 1)]) # choose a random id from the shortlist
- except:
- sys.exit("No phrase within the given parameters!")
-
- # Output as specified in flags
- if not (args.english or args.latin or args.notes):
- print(all_lines[chosen][1])
- else:
- if args.id:
- print(all_lines[chosen][1])
- if args.latin:
- print(all_lines[chosen][1])
- if args.english:
- print(all_lines[chosen][2])
- if args.notes:
- print(all_lines[chosen][3])
+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())
projects / phrases.git / blobdiff