Skip to content

Latest commit

 

History

History
50 lines (39 loc) · 7.28 KB

SqlAndCurls.md

File metadata and controls

50 lines (39 loc) · 7.28 KB
Raw

Manual query and curl copypastas

Manual SQL Queries

CREATE TABLE log (
	log_id bigserial primary key,
	log_uri text NOT NULL,
	log_description text,
	log_timestamp timestamp default NULL
);
CREATE TABLE log (
	log_id bigserial primary key,
	log_uri text NOT NULL,
	log_description text,
	log_timestamp timestamp WITHOUT TIME ZONE NOT NULL DEFAULT NOW()
);

ALTER TABLE ONLY log ALTER COLUMN log_timestamp SET DEFAULT NOW();
my_timestamp TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),

INSERT INTO log (log_uri, log_description) VALUES($1, $2)
INSERT INTO log (log_uri, log_description) VALUES('data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAwAAAANCAYAAACdKY9CAAAKsGlDQ1BJQ0MgUHJvZmlsZQAASImVlgdUE9kax+9MeqMFQofQmyC9CoROAAXpYCMklFBCCIRmQ2VxBVcUERFQFnSRouBaAFkLIooKi4AF+wZZRNR1sYAFlR3gEd6+d9575/3P+eb+zjd3vvnunbnn/AEg32bx+UmwFADJvHRBoJcrPTwiko4TARxAAwKQA+YsdhrfJSDADyBaGP+uqbsAmh1vGc/W+vf7/1XSnJg0NgBQAMLRnDR2MsKnkWhn8wXpAKD4SF4rM50/yyUIywqQBhGum+W4eT43y9Hz3D83JzjQDeHfAcCTWSxBHACkCSRPz2DHIXXIyGqBKY/D5SHMQNiJHc/iIJyL8JLk5JRZPoawfvQ/1Yn7W81ocU0WK07M82uZE96dm8ZPYmX/n9vxv5WcJFx4hyYS5HiBdyAyyiB7VpeY4itmXvQK/wXmcubmz3G80DtkgdlpbpELzGG5+y6wMDHEZYFZgsVnuenM4AUWpASK6/OSVviJ68cwxRyT5hG0wLFcT+YC58QHhy1wBjd0xQKnJQb5Ls5xE+cFwkBxz7ECT/Eak9MWe2OzFt+VHh/svdhDuLgfToy7hzjPCxHP56e7imvykwIW+0/yEufTMoLEz6YjP9gCJ7B8AhbrBIj3B7gBLuCBGJAMWIAOvIE7AOkxWemzDbul8LMF3Lj4dLoLcmJi6Ewe22QJ3dzUzBqA2fM3/3nf3Zs7VxANv5jLSQSAcQ0A2GMxF4b8xw31ANBUFnPaX5BjUARAew9bKMiYz6FnLxhABJJAFigCNaAF9IExMAfWwAEwgAfwAf4gGESAtYAN4pG+BSATbABbQD4oBLvBPlAOqsBhUAeOg5OgFZwDl8BV0AP6wR3wEIjAKHgJJsAUmIYgCAdRICqkCKlDOpARZA7ZQk6QB+QHBUIRUBQUB/EgIbQB2gYVQsVQOVQN1UM/Q2ehS9B1aAC6Dw1D49Bb6DOMgsmwLKwK68JLYVvYBfaFg+E1cBycCufAefAuuAyugY/BLfAluAe+A4vgl/AkCqBIKBpKA2WMskW5ofxRkahYlAC1CVWAKkXVoJpQ7ahu1C2UCPUK9QmNRVPRdLQx2gHtjQ5Bs9Gp6E3onehydB26Bd2FvoUeRk+gv2EoGBWMEcYew8SEY+IwmZh8TCmmFnMGcwVzBzOKmcJisTSsHtYG642NwCZg12N3Yg9im7Ed2AHsCHYSh8Mp4oxwjjh/HAuXjsvHHcAdw13EDeJGcR/xJLw63hzviY/E8/Bb8aX4BvwF/CB+DD9NkCLoEOwJ/gQOIZtQRDhCaCfcJIwSponSRD2iIzGYmEDcQiwjNhGvEB8R35FIJE2SHWkliUvKJZWRTpCukYZJn8gyZEOyG3k1WUjeRT5K7iDfJ7+jUCi6FAYlkpJO2UWpp1ymPKF8lKBKmEgwJTgSmyUqJFokBiVeSxIkdSRdJNdK5kiWSp6SvCn5SoogpSvlJsWS2iRVIXVWakhqUpoqbSbtL50svVO6Qfq69HMZnIyujIcMRyZP5rDMZZkRKoqqRXWjsqnbqEeoV6ijslhZPVmmbIJsoexx2T7ZCTkZOUu5ULksuQq583IiGoqmS2PSkmhFtJO0u7TP8qryLvIx8jvkm+QH5T8oKCswFGIUChSaFe4ofFakK3ooJiruUWxVfKyEVjJUWqmUqXRI6YrSK2VZZQdltnKB8knlByqwiqFKoMp6lcMqvSqTqmqqXqp81QOql1VfqdHUGGoJaiVqF9TG1anqTupc9RL1i+ov6HJ0F3oSvYzeRZ/QUNHw1hBqVGv0aUxr6mmGaG7VbNZ8rEXUstWK1SrR6tSa0FbXXq69QbtR+4EOQcdWJ15nv063zgddPd0w3e26rbrP9RT0mHo5eo16j/Qp+s76qfo1+rcNsAa2BokGBw36DWFDK8N4wwrDm0awkbUR1+ig0cASzBK7JbwlNUuGjMnGLsYZxo3GwyY0Ez+TrSatJq+Xai+NXLpnaffSb6ZWpkmmR0wfmsmY+ZhtNWs3e2tuaM42rzC/bUGx8LTYbNFm8cbSyDLG8pDlPSuq1XKr7VadVl+tbawF1k3W4zbaNlE2lTZDtrK2AbY7ba/ZYexc7TbbnbP7ZG9tn25/0v5PB2OHRIcGh+fL9JbFLDuybMRR05HlWO0ocqI7RTn96CRy1nBmOdc4P2VoMTiMWsaYi4FLgssxl9eupq4C1zOuH9zs3Ta6dbij3L3cC9z7PGQ8QjzKPZ54anrGeTZ6TnhZea336vDGePt67/EeYqoy2cx65oSPjc9Gny5fsm+Qb7nvUz9DP4Ff+3J4uc/yvcsfrdBZwVvR6g/8mf57/R8H6AWkBvyyErsyYGXFymeBZoEbAruDqEHrghqCpoJdg4uCH4bohwhDOkMlQ1eH1od+CHMPKw4ThS8N3xjeE6EUwY1oi8RFhkbWRk6u8li1b9XoaqvV+avvrtFbk7Xm+lqltUlrz6+TXMdadyoKExUW1RD1heXPqmFNRjOjK6Mn2G7s/eyXHAanhDMe4xhTHDMW6xhbHPs8zjFub9x4vHN8afwrrhu3nPsmwTuhKuFDon/i0cSZpLCk5mR8clTyWZ4ML5HXlaKWkpUywDfi5/NFqfap+1InBL6C2jQobU1aW7osYnR6hfrC74TDGU4ZFRkfM0MzT2VJZ/GyerMNs3dkj+V45vy0Hr2evb5zg8aGLRuGN7psrN4EbYre1LlZa3Pe5tFcr9y6LcQtiVt+3Wq6tXjr+21h29rzVPNy80a+8/quMV8iX5A/tN1he9X36O+53/ftsNhxYMe3Ak7BjULTwtLCLzvZO2/8YPZD2Q8zu2J39RVZFx3ajd3N2313j/OeumLp4pzikb3L97aU0EsKSt7vW7fveqlladV+4n7hflGZX1nbAe0Duw98KY8vv1PhWtFcqVK5o/LDQc7BwUOMQ01VqlWFVZ9/5P54r9qruqVGt6b0MPZwxuFnR0KPdP9k+1N9rVJtYe3Xo7yjorrAuq56m/r6BpWGoka4Udg4fmz1sf7j7sfbmoybqptpzYUnwAnhiRc/R/1896Tvyc5TtqeaTuucrjxDPVPQArVkt0y0xreK2iLaBs76nO1sd2g/84vJL0fPaZyrOC93vugC8ULehZmLORcnO/gdry7FXRrpXNf58HL45dtdK7v6rvheuXbV8+rlbpfui9ccr527bn/97A3bG6091j0tvVa9Z361+vVMn3Vfy02bm239dv3tA8sGLgw6D1665X7r6m3m7Z47K+4M3A25e29o9ZDoHufe8/tJ9988yHgw/TD3EeZRwWOpx6VPVJ7U/GbwW7PIWnR+2H2492nQ04cj7JGXv6f9/mU07xnlWemY+lj9c/Pn58Y9x/tfrHox+pL/cvpV/h/Sf1S+1n99+k/Gn70T4ROjbwRvZt7ufKf47uh7y/edkwGTT6aSp6Y/FHxU/Fj3yfZT9+ewz2PTmV9wX8q+Gnxt/+b77dFM8swMnyVgzVkBFBJwbCwAb48CQIkAgIr4ZqLEvD+eEzTv6ecI/Cee99BzQpzL4Q7EiyDhg0RlLgA6SFCRWwEMAIIZALawEMc/lBZrYT5fi9SKWJPSmZl3iC/EGQDwdWhmZrp1ZuZrLdLsAwA6puZ9+aywiH8v1oChFr2um+dzwb/oLxpTBsthKWa6AAABm2lUWHRYTUw6Y29tLmFkb2JlLnhtcAAAAAAAPHg6eG1wbWV0YSB4bWxuczp4PSJhZG9iZTpuczptZXRhLyIgeDp4bXB0az0iWE1QIENvcmUgNS40LjAiPgogICA8cmRmOlJERiB4bWxuczpyZGY9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkvMDIvMjItcmRmLXN5bnRheC1ucyMiPgogICAgICA8cmRmOkRlc2NyaXB0aW9uIHJkZjphYm91dD0iIgogICAgICAgICAgICB4bWxuczpleGlmPSJodHRwOi8vbnMuYWRvYmUuY29tL2V4aWYvMS4wLyI+CiAgICAgICAgIDxleGlmOlBpeGVsWERpbWVuc2lvbj4xMjwvZXhpZjpQaXhlbFhEaW1lbnNpb24+CiAgICAgICAgIDxleGlmOlBpeGVsWURpbWVuc2lvbj4xMzwvZXhpZjpQaXhlbFlEaW1lbnNpb24+CiAgICAgIDwvcmRmOkRlc2NyaXB0aW9uPgogICA8L3JkZjpSREY+CjwveDp4bXBtZXRhPgraZlfDAAAA+UlEQVQoFWOUlJb5z0ACYCJBLVgpyRpY7JkYGQ7++8+gFNPCMCFah4GBhZuB+89bhttP/zKoKokx/Hx9iaEzsoThIIM2Q9vyRgamqlnZYKu42QQZuNm/MmxoncVwj0WYQVXgPkPXxP0M7KJaDPq6EIfzcvExMLHIazJYAG0Bg78fGA4cWsNw9uEfhj9v7jDs3HyE4RkDC4OWpTZEnoWBgYnhzx+GrxAuAwMzhPHrz1+g09iAnMcMH4BMZgZumAqgBqAufIAVTZKJ4QeaCB4u0DFo5gOtRwe/wQIQR7MAXcNIdEwz6TDM2NkP9AMpABgoJGj4yvDk3jMGAPH5Ptu8PKjBAAAAAElFTkSuQmCC
', 'A screenshot of a small m.');

INSERT INTO log (log_uri, log_description) VALUES('data:text/plain,Q1JFQVRFIFRBQkxFIGxvZyAoDQoJbG9nX2lkIGJpZ3NlcmlhbCBwcmltYXJ5IGtleSwNCglsb2dfdXJpIHRleHQgTk9UIE5VTEwsDQoJbG9nX2Rlc2NyaXB0aW9uIHRleHQsDQoJbG9nX3RpbWVzdGFtcCB0aW1lc3RhbXAgZGVmYXVsdCBOVUxMDQopOw==', 'log table creation sql code.');

INSERT INTO log (log_uri, log_description) VALUES('https://lh3.googleusercontent.com/sVXM2CipijwG7XxtBJR0DtaJEvA07riHuFEVBox4OUXUyGKnEft2YAvPAGS7aKGL0LJPEiGa48BwRIGGtUStB9GyvQ7LbP73pQYk9xGvWo8PcGP2UPkvp6cIq4NYcbirzfu7MzP6unagCL2X23bOziq9QD37xoPomTX5DBh_wC1LGEppEsAyPDshTGW0nbOTh01WnjUlEG0OkAr2rWiE9NVzHWK9l4d-XG8L6im_vmL15cNuzHuhZeUoq-auWy8R_QD5VX1c2aC3TpRN__FnaMEGQYqWykjxF2qVwaRawxFmE1t3QCh95pLupjVGdx7YS-4wB09qbetypjgaflWEF3b7wOVS2ykuLfibPXGSy2VGkBcl_smorpckLysMEhjO9jaT6DlWulPoe1-2OW3NqEMU90RUfQJQ7m4w7LUH2IfgCZHQH90PbBKVGyWWSnAKlornKKYs438bpqGtP-7Ty5weREpUwHNNkalhv10kN9_FFyq0RHlKKrfEVLZ00QpfkmSjq99jbcJXN_s3mG1dRYkZUba2nVyZBoxQDzKOKjRVSlaONo3UnA5W0gtT6NwHSACjj4p01PwSS4l2DBG4K5mtNC0XbFcjFMnskdv6gLDrLr77iiFV=w1006-h754-no', 'A modern Christmas tree with presents.');

INSERT INTO log (log_uri) VALUES('http://flyingegger.com/cartoon/flyingegger/images/flyingegger21.gif');

curl samples

curl -i -X POST -d "description=Task%20structure%20diagram.&uri=https%3A%2F%2Flh3.googleusercontent.com%2FnGMQIKnv7oxWgiKfboTroWQj7cLyf9eCqPkD_G4fJHvcFahy6m4ZAzR98xtVH97F834JK8uUZ-xIe9x51lQsuG20H9vpZAIaKZYK4M1uplnM_K6mRdlR4e0o2wTVPL7MvdA1NM52RzKxX3wmeEiB2foi_6wVANKhB5WETrPclMwk7jyzfpDzZVae5Ac45nbuuVJWfUz-l60X4B2o9yZ8jym2v60XHu86FWtbaUBPMw_AfxKGZ5c0XsKbXtdLIXUWH5cNK_sgv1cmJcXEkevV_N6i0MHTHZ_a72wzNp--mgxbcbWLEJMXxkHS6t8DdqoAwsRin28SVcAoPgv82dOZ908K8E9ps4n5_cAxjLgbx_cUkoSCSirU0NprBSwv-apxX-UBfO7YYOgIHiS377fgKtV1tORbxzPTAUVZxiBPzC0Rp0p9iDcPt05GVRqoDWngWtUf9oj38jIXKXsqqooDXKE_IASADLWYVSXPKhr9t55uLg1NxOB2a0uylVGHXHxdllopM6vpN_w2vLKH4co_MHs-QYjXvJxS3tedNhrcv9Roc8Z4uWbxvvtpOqRMP6yJyCMLpyN2KqVF76EZ77bT7rwZMzTMO6s2nP5fT37T6wUXoqCYnp5w%3Dw1006-h754-no" https://ulog.herokuapp.com/log

curl -i -X POST -d "uri=http://flyingegger.com/cartoon/flyingegger/images/flyingegger21.gif" https://ulog.herokuapp.com/log