# Armaan Bhojwani 2020
import argparse
-import csv
-import random
+from random import randint
+import sqlite3
import sys
import os.path
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.")
+ 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.")
args = parser.parse_args()
- right_length = []
-
# 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"
- 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()
-
- # iterate through all the phrases
- if args.open:
- chosen = args.open
+ 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:
- 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
-
- 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!")
+ 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
- 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[0])
- 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)
+ 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(len(data))
+ sys.exit(0)
if __name__ == "__main__":
main()