slight change of gears

2 files changed, 21 insertions, 1 deletions

diff --git a/src/catalogue.lil b/src/catalogue.lil
index 52d1e60..da542bb 100644
--- a/src/catalogue.lil
+++ b/src/catalogue.lil
@@ -55,7 +55,8 @@ show[newtable]
 # my own ID and use that instead...a well known ID?
 
 on entry d t do
-	t:insert entry_type:(d.entry_type) title:(d.title) into t
+	date_fmt_string:"date +%Y-%m-%d | tr -d '\n'"
+	t:insert entry_type:(d.entry_type) title:(d.title) created_date:(shell[date_fmt_string].out) into t
 end
 
 # where d is a table representing a new row to be added to t, an existing table
@@ -66,3 +67,11 @@ row:table row
 test:entry[row catalogue]
 
 show[test] # NOTE, keep in mind that this generates a totally new table
+
+
+do search q t do
+	t:select name where ("Alice" = name) from people
+end
+
+# HOLD UP! I've over complicated things; I'm going to shift gears, make this projects
+# only focused on link logging, not a general purpose DB.
\ No newline at end of file
diff --git a/src/tmp.lil b/src/tmp.lil
index 25481ac..06f5a7f 100644
--- a/src/tmp.lil
+++ b/src/tmp.lil
@@ -46,3 +46,14 @@ end
 breakfast: insert food:("Eggs","Pancakes","Grapefruit") quantity:(3,4,1) tasty:(1,1,0) into 0 # NOTE, 0 here could also be the name of the variable, so, in this example, breakfast
 
 show[breakfast]
+
+needle:   "apple"
+haystack: ("frog","apple","chicken","toadstool","apple","rice","fish")
+
+filter:count needle take haystack
+spread_conforming:sum needle = haystack
+print[filter]
+print[spread_conforming]
+
+
+