intial switch to sqlite

[phrases.git] / phrases.py

diff --git a/phrases.py b/phrases.py
index a8348816373f0fc2bd97f4ca5b490268be6c02ab..46db7829c2abe8dabf482c6387545846978f69c4 100755 (executable)
--- a/phrases.py
+++ b/phrases.py
@@ -3,8 +3,8 @@
 # Armaan Bhojwani 2020
 
 import argparse
-import csv
-import random
+from random import randint
+import sqlite3
 import sys
 import os.path
 
@@ -34,71 +34,52 @@ def main(args=sys.argv[1:]):
                         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()