Skip to main content

Posts

Bitbucket updating code from local system

Bitbucket updating code from local system 1)git add . 2)git commit -m "fixes" 3)ssh -T git@bitbucket.org 4)Add ssh key to bitbucket 5)git push --mirror git@bitbucket.org:bitbucket repository name Example :git@bitbucket.org:kotesh_rao/twitter_bootstrap_devise_rails4 6)Enter bitbucket password

Postgresql Basic Commands

Postgresql  Basic Commands 1)\l  -> List of all databases(***) 2)create database koti; -> Cresating new database 3)drop database koti; -> Drop the database 3)\c koti; -> Use database(***) 4)create table employee(id int primary key not null,name varchar(23),phone_no int);   -> Create table 5)\d -> List of all tables(***) 6)\d employee -> See the particular table(***) 7)insert into employee (id,name,phone_no) VALUES (1, 'koti', 23); 8)\q -> Quit the Postgresql

Anjular Js Examples

Anjular Js Examples : <!DOCTYPE html> <html> <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js"></script> <body> <!-- <span ng-app=""> <input type="text" ng-model="test"> {{test}} </span> --> <!-- <span ng-app=""> <input type="text" ng-model="koti"> <span ng-bind="koti"></span> </span> --> <!-- <div ng-app="" ng-init="location='bangalore'"> <p>Location is :<span ng-bind="location"></span></p> </div> <div ng-app=""> {{50-50}} </div> --> =========== <!-- <div ng-app="koti"  ng-controller="raogaru"> <p>name :<span><input type="text" ng-model="name" id="check"></span></p> <p>location :<span...

Mysql Store Procedures and cursors and triggers

Mysql Store Procedures and cursors and triggers ---------------start-------------------- to drop procedure ---------------------------------------- mysql> drop procedure myProc;     -> $$ Query OK, 0 rows affected (0.02 sec) ---------------end---------------------- ---------------start-------------------- cursor sample example1 ---------------------------------------- mysql> delimiter $$ mysql> CREATE PROCEDURE myProc() BEGIN     ->  DECLARE l_last_row INT DEFAULT 0;     ->  DECLARE l_dept_id  INT;     ->  DECLARE c_dept CURSOR FOR     -> select id from employees;     -> DECLARE continue handler for NOT FOUND SET l_last_row=1;     -> OPEN c_dept;     -> dept_cursor: LOOP     -> FETCH c_dept INTO l_dept_id;     -> IF (l_last_row=1) THEN     -> LEAVE dept_cursor...

Mongodb Basics

Mongodb Basics : 1)mongo 2)show dbs; 3)use sample_mongo_development; 4)show tables || show collections; > show tables; articles system.indexes 5)See the table records > db.articles.find(); { "_id" : ObjectId("552d065568657523e5000000"), "name" : "rdfgffdg", "content" : "dfgfdgdfgdfg" } { "_id" : ObjectId("552d07b968657523e5010000"), "name" : "xzgfxcgv", "content" : "xcvxvxvcx" } { "_id" : ObjectId("552d094768657523e5020000"), "name" : "fgdfg", "content" : "dfgdfg" } { "_id" : ObjectId("552f56766865751802000000"), "name" : "drdsf", "content" : "dsfsdf" } { "_id" : ObjectId("552f5a1b6865751802010000"), "name" : "dfvxc", "content" : "fdhgdfh" } { "_id" : ObjectId("552f5...