Skip to content

Instantly share code, notes, and snippets.

@prakashanantha
prakashanantha / findguid.sql
Created November 10, 2015 10:40
find a guid in the entire db
CREATE PROCEDURE dbo.FindGUID @searchValue uniqueidentifier AS
/*
Search all tables in the database for a guid
Revision History
6/9/2009: Initally created
6/10/2009: Build or clause of multiple columns on one table
*/
@prakashanantha
prakashanantha / gist:b963e72b32c1a8aec3e7
Created November 5, 2014 19:43
Current Datetime in current timezone
to_zone = tz.gettz("Asia/Calcutta")
current_time = datetime.datetime.now().replace(tzinfo=to_zone)
@prakashanantha
prakashanantha / GenerateClassFromDataTable
Created October 16, 2014 22:16
Generate Class from DataTable
string s = string.Empty;
foreach (DataTable item in set.Tables)
{
s += Environment.NewLine;
s += "public class " + item.TableName + Environment.NewLine + "{" + Environment.NewLine;
foreach (DataColumn item1 in item.Columns)
{
s += "public " +item1.DataType.ToString() + " " + item1.ColumnName + " {get; set;}" + Environment.NewLine;
@prakashanantha
prakashanantha / pipinstall
Created October 16, 2014 17:45
Install pip package on server
sudo /opt/doctorc/env/bin/pip install xlrd==0.9.3
@prakashanantha
prakashanantha / install-psycopg2
Created October 15, 2014 22:51
Installing psycopg2 on a mac
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew install postgresql
sudo pip install psycopg2
@prakashanantha
prakashanantha / css_resources.md
Created March 30, 2014 09:35 — forked from jookyboi/css_resources.md
CSS libraries and guides to bring some order to the chaos.

Libraries

  • 960 Grid System - An effort to streamline web development workflow by providing commonly used dimensions, based on a width of 960 pixels. There are two variants: 12 and 16 columns, which can be used separately or in tandem.
  • Compass - Open source CSS Authoring Framework.
  • Bootstrap - Sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development.
  • Font Awesome - The iconic font designed for Bootstrap.
  • Zurb Foundation - Framework for writing responsive web sites.
  • SASS - CSS extension language which allows variables, mixins and rules nesting.
  • Skeleton - Boilerplate for responsive, mobile-friendly development.

Guides

@prakashanantha
prakashanantha / javascript_resources.md
Created March 30, 2014 09:35 — forked from jookyboi/javascript_resources.md
Here are a set of libraries, plugins and guides which may be useful to your Javascript coding.

Libraries

  • jQuery - The de-facto library for the modern age. It makes things like HTML document traversal and manipulation, event handling, animation, and Ajax much simpler with an easy-to-use API that works across a multitude of browsers.
  • Backbone - Backbone.js gives structure to web applications by providing models with key-value binding and custom events, collections with a rich API of enumerable functions, views with declarative event handling, and connects it all to your existing API over a RESTful JSON interface.
  • AngularJS - Conventions based MVC framework for HTML5 apps.
  • Underscore - Underscore is a utility-belt library for JavaScript that provides a lot of the functional programming support that you would expect in Prototype.js (or Ruby), but without extending any of the built-in JavaScript objects.
  • lawnchair - Key/value store adapter for indexdb, localStorage
@prakashanantha
prakashanantha / 0_reuse_code.js
Created March 30, 2014 09:35
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console