# Armaan Bhojwani 2020
import argparse
-import csv
-import random
-import sys
-import os.path
+from random import randint
+import sqlite3
+from sys import exit
+from os import 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",
help="print the English translation.")
parser.add_argument("-n", "--notes",
action='store_true',
- help="print any notes on phrase")
+ help="print any notes on phrase.")
+ parser.add_argument("-v", "--version",
+ action='store_true',
+ help="print version.")
parser.add_argument("-m", "--min",
default=0,
type=int,
- help="set the minimum length of the Latin phrase")
+ 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")
+ help="set the maximum length of Latin phrase.")
parser.add_argument("-p", "--num",
action='store_true',
- help="print number of possibilities within constraints")
+ help="print number of possible phrases.")
parser.add_argument("-f", "--file",
- help="set the location of the phrase file")
- args = parser.parse_args()
+ help="set the location of the phrase database.")
+ return parser.parse_args()
- right_length = []
+def output():
+ data = c.fetchall()
+ row = list(data[randint(0, len(data) - 1)])
- # find phrase file
- if args.file:
- phrase_file = args.file
- if os.path.isfile("phrases.csv"):
- phrase_file = "phrases.csv"
- elif os.path.isfile("/usr/local/share/phrases/phrases.csv"):
- phrase_file = "/usr/local/share/phrases/phrases.csv"
+ if not (args.id
+ or args.latin
+ or args.english
+ or args.notes
+ or args.num
+ or args.version):
+ print(row[1])
+ exit(0)
else:
- sys.exit("cannot fine phrase database!")
-
- # convert csv file into list
- with open(phrase_file) as f:
- reader = csv.reader(f)
- next(reader, None) # skip header
- all_lines = list(reader)
- f.close()
+ if args.version:
+ print(version)
+ 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(len(data))
+ exit(0)
- # iterate through all the phrases
- for row in all_lines:
- try: # generate a shortlist of phrases of the right length
- if args.max >= int(row[4]) >= args.min:
- right_length.append(row[0])
- except: # skip malformed rows without exiting
- pass
+def find_file():
+ if args.file:
+ return args.file
+ if path.isfile("phrases.db"):
+ return "phrases.db"
+ elif path.isfile("/usr/local/share/phrases/phrases.db"):
+ return "/usr/local/share/phrases/phrases.db"
+ else:
+ exit("cannot find the phrase database!")
- try: # choose a random id from the shortlist
- chosen = int(right_length[random.randint(0, len(right_length) - 1)])
- except:
- sys.exit("no phrase within the given parameters!")
+def get_rand():
+ c.execute("SELECT * FROM phrases WHERE length <= (?) AND length >= (?)",
+ (args.max, args.min))
- # Output as specified in flags
- for row in all_lines:
- if int(row[0]) == chosen:
- 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[1])
- if args.latin:
- print(row[1])
- if args.english:
- print(row[2])
- if args.notes:
- print(row[3])
- if args.num:
- print(len(right_length))
- sys.exit(0)
+def main():
+ get_rand()
+ output()
if __name__ == "__main__":
+ version = "phrases 1.0.1"
+ args = parse_args()
+ c = sqlite3.connect(find_file()).cursor()
main()