Step 1:
CREATE TABLE a (
a_id int PRIMARY KEY
);
Step 2:
CREATE TABLE b (
Munish Kapoor manishkpr
manishkpr
/ fastlane_beta.ruby
Created
November 21, 2019 03:08
— forked from monday8am/fastlane_beta.ruby
Fastlane Beta
This file contains hidden or 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
| desc "" | |
| lane :beta do |lane| | |
| # ensure you are in master branch | |
| ensure_git_branch | |
| # ensure that master branch is clean | |
| ensure_git_status_clean | |
| # check the semantic parameter entered |
manishkpr
/ postgres_index_foreign_keys.md
Last active
February 21, 2019 07:40
POSTGRESQL: INDEXES AND FOREIGN KEYS
manishkpr
/ osx-kong.sh
Created
June 12, 2018 01:54
— forked from sepehr/osx-kong.sh
OSX: Kong Installation
This file contains hidden or 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/bash | |
| # | |
| # The homebrew formula of kong has a lot of version incompatibilities. So | |
| # we install kong directly from Luarocks. | |
| # | |
| # Kong only works with Cassandra 2.1.x/2.2.x, the latest brew formula for | |
| # cassandra is 3.x. We need to tap homebrew/versions and install cassandra22 | |
| # instead. | |
| # |
manishkpr
/ server_certificates_to_pem.md
Created
April 23, 2018 05:42
— forked from stevenhaddox/server_certificates_to_pem.md
Convert .crt & .key files into .pem file for HTTParty
Two ways to do it, but only worked for me so I'll put it first and the second for reference:
$ openssl pkcs12 -export -in hostname.crt -inkey hsotname.key -out hostname.p12
$ openssl pkcs12 -in hostname.p12 -nodes -out hostname.pem
Other options for this method in comments below:
# Note, the -certfile root.crt appends all CA certs to the export, I've never needed these so it's optional for my personal steps
$ openssl pkcs12 -export -in hostname.crt -inkey hsotname.key -certfile root.crt -out hostname.p12
manishkpr
/ ruby_1.9.3.sh
Created
March 6, 2018 03:02
This file contains hidden or 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
| #!/usr/bin/env bash | |
| sudo apt-get -y update | |
| sudo apt-get -y install build-essential zlib1g-dev libssl-dev libxml2-dev libxslt-dev libreadline6-dev libyaml-dev | |
| # apt-get -y install libmysqlclient-dev # uncomment for mysql support | |
| cd /tmp | |
| wget http://ftp.ruby-lang.org/pub/ruby/1.9/ruby-1.9.3-p286.tar.gz | |
| tar -xvzf ruby-1.9.3-p286.tar.gz | |
| cd ruby-1.9.3-p286/ | |
| ./configure --prefix=/usr/local | |
| sudo make |
manishkpr
/ phalcon_aws_sdk.text
Created
August 10, 2017 08:32
Hang the Amazon AWS SDK in Phalcon PHP
This file contains hidden or 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
| AWS SDK uses a lot of third-party libraries and Framework, so the namespace to manually handle the words will be more trouble, I suggest using Composer to deal with these things, it uses spl_autoload to deal with, so the class will be used in the time to load, Fast and concise. | |
| Under the project put composer.json, the content is | |
| { | |
| "require": { | |
| "aws/aws-sdk-php": "dev-master" | |
| } | |
| } | |
| Download composer.phar placed under the project | |
| wget http://getcomposer.org/composer.phar |
manishkpr
/ BackPress.java
Last active
May 17, 2020 09:41
Android - handle back press in Fragment More Details Visit: http://manishkpr.webheavens.com
This file contains hidden or 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
| This article describes how our FragmentBack works under the hood. | |
| BaseFragment | |
| First step to create back-sensitive fragments is to define interface that we can call to notify particular fragments about back-press. It contains only one method onBackPressed() which returns a value that indicates if back-press event was consumed by the fragment. | |
| In this example we use base class, but you can define it via interface as well. | |
| public class BaseFragment extends Fragment { | |
| /** | |
| * Could handle back press. |
manishkpr
/ async_waterfall_example.js
Last active
May 26, 2017 03:17
— forked from dineshsprabu/async_waterfall_example.js
NodeJS Async WaterFall Example
This file contains hidden or 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
| var async = require('async'); | |
| async.waterfall( | |
| [ | |
| function(callback) { | |
| callback(null, 'Yes', 'it'); | |
| }, | |
| function(arg1, arg2, callback) { | |
| var caption = arg1 +' and '+ arg2; | |
| callback(null, caption); |
manishkpr
/ Foreground.java
Created
February 28, 2017 06:45
— forked from steveliles/Foreground.java
Class for detecting and eventing whether an Android app is currently foreground or background (requires API level 14+)
This file contains hidden or 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
| package com.sjl.util; | |
| import android.app.Activity; | |
| import android.app.Application; | |
| import android.content.Context; | |
| import android.os.Bundle; | |
| import android.os.Handler; | |
| import android.util.Log; | |
| import java.util.List; |
manishkpr
/ CustomSnackbar.java
Created
February 6, 2017 09:02
— forked from raphaelbussa/CustomSnackbar.java
Helper for inflate custom layout in google support design snackbar
This file contains hidden or 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
| /* | |
| * The MIT License (MIT) | |
| * | |
| * Copyright (c) 2016 Raphaël Bussa | |
| * | |
| * Permission is hereby granted, free of charge, to any person obtaining a copy | |
| * of this software and associated documentation files (the "Software"), to deal | |
| * in the Software without restriction, including without limitation the rights | |
| * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
| * copies of the Software, and to permit persons to whom the Software is |
NewerOlder