matt212
/ postgresql-simple-example
Last active
July 11, 2017 14:50
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| DIR="/cygdrive/C/elasticsearch-jdbc-2.3.4.1/" | |
| bin=${DIR}/../bin | |
| lib=${DIR}/../lib | |
| echo '{ | |
| "type" : "jdbc", | |
| "jdbc" : { |
matt212
/ rename primary script.sql
Last active
May 22, 2017 13:17
after mysql migration to postgres restarting primary key sequences and most importantly retaining older data for referential integrity aspect !
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --create new column to create sequences | |
| alter table modnames add id serial; | |
| ---update new column serial column with existing value | |
| UPDATE modnames m | |
| SET id = m0.modnameid | |
| FROM modnames m0 | |
| where m.modnameid=m0.modnameid | |
| ---now tricky part is to tell new serial to start from max(existingid) for referential integrity | |
| --scenarios | |
| ---to figure out your serial sequence |
matt212
/ angular-selector.js
Created
January 16, 2017 12:34
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*! | |
| * Angular Material Design | |
| * https://github.com/angular/material | |
| * @license MIT | |
| * v1.1.1 | |
| */ | |
| (function( window, angular, undefined ){ | |
| "use strict"; | |
| (function(){ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function isAuth(req, res, next) { | |
| var token = req.body.token || req.param('token') || req.headers['x-access-token']; | |
| //check whether request has token ! | |
| if (token != undefined) { | |
| // decode token | |
| if (token) { | |
| // verifies secret and checks exp |
NewerOlder