write strokes.awk

2 files changed, 32 insertions, 3 deletions

diff --git a/data/english.awk b/data/english.awk
index 1828d2c..c5dc0aa 100644
--- a/data/english.awk
+++ b/data/english.awk
@@ -6,7 +6,7 @@ BEGIN {
 
     # Create english table
     print "CREATE TABLE IF NOT EXISTS \"english\" ( "   \
-        "\"word\" TEXT NOT NULL PRIMARY KEY,"                       \
+        "\"word\" TEXT NOT NULL PRIMARY KEY,"           \
         "\"freq\" FLOAT NOT NULL DEFAULT(0)"            \
         ");";
 
@@ -16,10 +16,10 @@ BEGIN {
 }
 
     # Insert data into english table
-    {   printf "INSERT INTO english (word, freq) VALUES (\"%s\", \"%f\");\n", $1, $2}
+    {   printf "INSERT INTO english (word, freq) VALUES (\"%s\", %f);\n", $1, $2}
 
     #quit sqlite3
 END {
     # Commit the transcation
     print "COMMIT;"
-}
\ No newline at end of file
+}
diff --git a/data/strokes.awk b/data/strokes.awk
new file mode 100644
index 0000000..5c61062
--- /dev/null
+++ b/data/strokes.awk
@@ -0,0 +1,29 @@
+#!/usr/bin/awk
+
+BEGIN {
+    # Begin a transaction
+    print "BEGIN TRANSACTION;"
+
+    # Create english table
+    print "CREATE TABLE IF NOT EXISTS \"strokes\" ( " \
+        "\"character\" TEXT NOT NULL,"                 \
+        "\"sequence\" INTEGER NOT NULL,"               \
+        "\"strokes\" TEXT NOT NULL,"                   \
+        "\"token\" INTEGER NOT NULL DEFAULT (0)"       \
+        ");";
+
+    # Create desc table
+    print "CREATE TABLE IF NOT EXISTS desc (name TEXT PRIMARY KEY, value TEXT);";
+    print "INSERT OR IGNORE INTO desc VALUES ('version', '1.2.0');";
+}
+
+    # Insert data into english table
+NF == 4 {
+        printf "INSERT INTO strokes (\"character\", \"sequence\", strokes, token) VALUES (\"%s\", %d, \"%s\", %d);\n", $1, $2, $3, $4;
+        }
+
+    #quit sqlite3
+END {
+    # Commit the transcation
+    print "COMMIT;"
+}