michael-lu-cn · April 28, 2014 14:19 · Apr 21, 2013 · Apr 21, 2013 · Apr 21, 2013 · Apr 21, 2013
diff --git a/plv8x b/plv8x
@@ -107,4 +107,7 @@ curl -i -X PUT -H "Content-Type: text/csv" --data-binary test.csv http://127.0.0
 
 PLAN
 --> https://species.wikimedia.org/w/index.php?title=Special:WhatLinksHere/Aves&limit=500
-then go to each page and pull out ea order & family page for detailed information and shove all that into json
+then go to each page and pull out ea order & family page for detailed information and shove all that into json
+
+
+# http://demos.kendoui.com/
diff --git a/plv8x b/plv8x
@@ -99,4 +99,12 @@ curl -i -X PUT -H "Content-Type: application/json" --data-binary @test.json http
 curl -i -X PUT -H "Content-Type: text/csv" --data-binary test.csv http://127.0.0.1:3000/collections/test2
 
  curl 'http://en.wikipedia.org/w/api.php?action=query&titles=List_of_birds&prop=revisions&rvprop=content&format=json' | sed -e 's/\(.\)\*\+/\1\
-/g' | sed -e 's/\[\[/\{\"/' | sed -e 's/\[\[//g' | sed -e 's/\]\]:/\":/' |sed -e 's/\]\]//g' | sed -e 's/\(\: \)/\1 \"/' | sed -e 's/\\n/\"\},^M/'  | sed -e 's/,^M\\n\.\*//' | grep ':' | grep '"' | awk 'NR>3{print $0}' > /tmp/junk
+/g' | sed -e 's/\[\[/\{\"/' | sed -e 's/\[\[//g' | sed -e 's/\]\]:/\":/' |sed -e 's/\]\]//g' | sed -e 's/\(\: \)/\1 \"/' | sed -e 's/\\n/\"\},^M/'  | sed -e 's/,^M\\n\.\*//' | grep ':' | grep '"' | awk 'NR>3{print $0}' > /tmp/junk
+
+^^ very horrible
+
+# wikispecies
+
+PLAN
+--> https://species.wikimedia.org/w/index.php?title=Special:WhatLinksHere/Aves&limit=500
+then go to each page and pull out ea order & family page for detailed information and shove all that into json
diff --git a/plv8x b/plv8x
@@ -97,3 +97,6 @@ EOF
 # curl for creating these
 curl -i -X PUT -H "Content-Type: application/json" --data-binary @test.json http://127.0.0.1:3000/collections/test1
 curl -i -X PUT -H "Content-Type: text/csv" --data-binary test.csv http://127.0.0.1:3000/collections/test2
+
+ curl 'http://en.wikipedia.org/w/api.php?action=query&titles=List_of_birds&prop=revisions&rvprop=content&format=json' | sed -e 's/\(.\)\*\+/\1\
+/g' | sed -e 's/\[\[/\{\"/' | sed -e 's/\[\[//g' | sed -e 's/\]\]:/\":/' |sed -e 's/\]\]//g' | sed -e 's/\(\: \)/\1 \"/' | sed -e 's/\\n/\"\},^M/'  | sed -e 's/,^M\\n\.\*//' | grep ':' | grep '"' | awk 'NR>3{print $0}' > /tmp/junk
diff --git a/plv8x b/plv8x
@@ -79,3 +79,21 @@ selena=# \q
 # POST MIDDLEWARE middlewares
 # API 
 https://support.mongolab.com/entries/20433053-REST-API-for-MongoDB
+
+
+# JSON insert
+cat << 'EOF' > test.json
+[ { "x" : 1 }, { "x" : 2 }, { "x" : 3 } ]
+EOF
+
+# csv insert
+cat << 'EOF' > test.csv
+x
+1
+2
+3
+EOF
+
+# curl for creating these
+curl -i -X PUT -H "Content-Type: application/json" --data-binary @test.json http://127.0.0.1:3000/collections/test1
+curl -i -X PUT -H "Content-Type: text/csv" --data-binary test.csv http://127.0.0.1:3000/collections/test2
diff --git a/plv8x b/plv8x
@@ -75,3 +75,7 @@ selena=# select fw('askhxoashdxoiahsdx');
 (1 row)
 
 selena=# \q
+
+# POST MIDDLEWARE middlewares
+# API 
+https://support.mongolab.com/entries/20433053-REST-API-for-MongoDB
diff --git a/plv8x b/plv8x
@@ -50,3 +50,28 @@ sudo npm i -g plv8x
 sudo npm i -g uax11
 
 
+selena@wuzetian:pgrest #1104 21:57 ♥: lsc -pe 'require \uax11 .toFullwidth \hello-selena'
+
+# Installing the module into the declared database
+selena@wuzetian:pgrest #1104 21:57 😱: plv8x -i uax11
+selena@wuzetian:pgrest #1105 21:57 ♥: plv8x -l
+pgrest: 80769 bytes
+uax11: 137984 bytes
+plv8x: 716954 bytes
+selena@wuzetian:pgrest #1106 21:57 ♥: plv8x -f 'text fw(text)=uax11:toFullwidth'
+ok text fw(text)
+selena@wuzetian:pgrest #1107 21:58 ♥: psql selena 
+psql (9.2.4)
+Type "help" for help.
+
+selena=# select fw("askhxoashdxoiahsdx");
+ERROR:  column "askhxoashdxoiahsdx" does not exist
+LINE 1: select fw("askhxoashdxoiahsdx");
+                  ^
+selena=# select fw('askhxoashdxoiahsdx');
+                  fw                  
+--------------------------------------
+ ａｓｋｈｘｏａｓｈｄｘｏｉａｈｓｄｘ
+(1 row)
+
+selena=# \q
diff --git a/plv8x b/plv8x
@@ -32,6 +32,10 @@ sudo add-apt-repository ppa:chris-lea/node.js
 sudo apt-get update
 sudo apt-get install nodejs
 
+# Don't know why it is needed, but works on Ubuntu
+# Jesse says: I SEE THIS ON EVERY INSTALL :D
+export NODE_PATH=/usr/lib/node_modules
+
 # 
 sudo npm i -g LiveScript
 sudo npm install [email protected] -g
@@ -44,3 +48,5 @@ sudo npm i -g plv8x
 
 # and other stuff in here
 sudo npm i -g uax11
+
+
diff --git a/plv8x b/plv8x
@@ -39,3 +39,8 @@ sudo npm install [email protected] -g
 # Install plv8x
 
 sudo npm i -g plv8x
+
+# now we are in audrey's slides
+
+# and other stuff in here
+sudo npm i -g uax11
diff --git a/gistfile1.txt → plv8x b/gistfile1.txt → plv8x
@@ -18,6 +18,24 @@ cd plv8-1.3.0
 make
 sudo make install
 
+# Make sure npm is installed
+sudo apt-get install npm
+
 # create extension
 
 psql -c "create extension plv8"
+
+
+# NODE https://github.com/brianc/node-postgres/issues/335#issuecomment-16707881
+sudo apt-get remove nodejs
+sudo add-apt-repository ppa:chris-lea/node.js
+sudo apt-get update
+sudo apt-get install nodejs
+
+# 
+sudo npm i -g LiveScript
+sudo npm install [email protected] -g
+
+# Install plv8x
+
+sudo npm i -g plv8x
diff --git a/gistfile1.txt b/gistfile1.txt
@@ -0,0 +1,23 @@
+# http://nonantolando.blogspot.tw/2012/10/using-json-on-ubuntu-1204-server-with.html
+
+sudo apt-get install libv8-3.7.12.22 libv8-dev
+
+# Install d8
+# http://askubuntu.com/questions/141252/is-there-a-package-for-an-executable-version-of-v8
+
+svn checkout http://v8.googlecode.com/svn/trunk/ ./v8
+cd v8
+make dependencies
+make native
+sudo ln -s `pwd`/out/native/d8 /usr/local/bin/d8
+
+# Install plv8
+wget https://plv8js.googlecode.com/files/plv8-1.3.0.zip
+unzip plv8-1.3.0.zip
+cd plv8-1.3.0
+make
+sudo make install
+
+# create extension
+
+psql -c "create extension plv8"