Web and Mobile Apps Codeware

Python MySQL Database Connection using ODBC

2017-03-07T12:23:00.001-08:00

I'm posting a sample python to Sql Server connection code. Here i will be using Python 2.7.

1. pip install pyodbc

2. Install the MySQL ODBC Connector from here.

3. Setup ODBC connection details in Control Panel --> Admin Tools --> System DSN

4. Code :

from os import getenv

import pyodbc

conn = pyodbc.connect(r'Driver={MySQL ODBC 5.3 ANSI Driver};Server=127.0.0.1;Database=test;Trusted_Connection=yes;')

cur = conn.cursor()

string = "CREATE TABLE IF NOT EXISTS TestTable(empname varchar(15), sal double)"

cur.execute(string)

sqlStatement = "INSERT INTO TestTable(empname,sal) VALUES (?, ?)"

cur.execute(sqlStatement, ('chandan', '1000'))

conn.commit()

4.Run python code.py in CMD

Python MSSQL Database Connection using ODBC

2017-03-06T19:39:00.001-08:00

I'm posting a sample python to Sql Server connection code. Here i will be using Python 2.7.

1. pip install pyodbc

2. Code :

from os import getenv

import pyodbc

conn = pyodbc.connect(

r'DRIVER={ODBC Driver 11 for SQL Server};'

r'SERVER=TEST;'

r'DATABASE=SampleDB;'

r'UID=sa;'

r'PWD=***'

)

cursor = conn.cursor()

cursor.execute("""

IF OBJECT_ID('persons', 'U') IS NOT NULL

DROP TABLE persons

CREATE TABLE persons (

id INT NOT NULL,

name VARCHAR(100),

salesrep VARCHAR(100),

PRIMARY KEY(id)

)

""")

cursor.executemany(

"INSERT INTO persons VALUES (?, ?, ?)",

[(1, 'John Smith', 'John Doe'),

(2, 'Jane Doe', 'Joe Dog'),

(3, 'Mike h', 'Sarah H')])

# you must call commit() to persist your data if you don't set autocommit to True

conn.commit()

cursor.execute('SELECT * FROM persons WHERE salesrep=?', 'John Doe')

row = cursor.fetchone()

while row:

print("ID=%d, Name=%s" % (row[0], row[1]))

row = cursor.fetchone()

conn.close()

3.Run python code.py in CMD

MongoDB Query to find record using greater $gt or less than $lt operators and then sort

2016-01-13T10:42:00.002-08:00

MongoDB Query to find record using greater $gt or less than $lt operators and then sort

Query
db.grades.find({"score":{$gt:65}},{"score":1,student_id:2,}).sort({"score:1})

grades is the collection.

sample interface for inserting data into mongodb using node.js

2015-09-22T07:49:00.000-07:00

1. Below is the npm module(mongodb) link which i used to create a basic interface for inserting
documents into mongodb collections using node.js

https://www.npmjs.com/package/mongodb

2. I have been using RoboMongo GUI for viewing into MongoDB Database.

Steps:

1. install node.js and mongodb
2. create a new folder and access it thru terminal/Cmd
3. Now type npm init, it will ask you certain things and will create a package.json based on your input values.
4. mention the required dependencies for mongodb in package.json file.
5. Create a new file called index.js , and paste this below code

6. final step to run the node.js interface from the terminal type --> node index.js

package.json

{

"name": "mongoapp",

"version": "1.0.0",

"description": "new mongo",

"main": "index.js",

"scripts": {

"test": "echo \"Error: no test specified\" && exit 1"

"keywords": [

"mongo"

"author": "chandan",

"license": "ISC",

"dependencies": {

"mongodb": "~2.0"

}

index.js

var MongoClient = require('mongodb').MongoClient

, assert = require('assert');

// Connection URL

var url = 'mongodb://localhost:27017/mydb';

// Use connect method to connect to the Server

MongoClient.connect(url, function(err, db) {

assert.equal(null, err);

console.log("Connected correctly to server");

insertDocuments(db,logStuff);

});

function logStuff(result)

{

console.log(result);

}

var insertDocuments = function(db, callback) {

// Get the documents collection

var collection = db.collection('documents');

// Insert some documents

collection.insert([

{a : 1}, {a : 2}, {a : 3}

], function(err, result) {

assert.equal(err, null);

assert.equal(3, result.result.n);

assert.equal(3, result.ops.length);

console.log("Inserted 3 documents into the document collection");

callback(result);

});

}

Executing JAR file using Batch Command(.bat)

2015-08-15T02:22:00.001-07:00

Below is the script to run a JAR file using a .bat command, copy and paste it into the notepad and then save as batch_file_name.bat

@echo OFF
cd C:\upload
java -jar compareRun.jar
pause

line 2 is the folder path for jar file, please change as per your requirements.
line 3 is the actual execution of the jar file
line 4 would avoid closing of console, so you can view the output.

Excel data to Sqlite3 Database table using Java

2015-08-14T22:26:00.000-07:00

Below is the code for inserting data from excel sheet to sqlite3 database using Java code.

1.Open new eclipse Java Project and reference to the latest Java jdbc-sqlite jar file from below url
https://bitbucket.org/xerial/sqlite-jdbc/downloads

2. Also reference to the Apache POI - the Java API for Microsoft Documents, which we require for reading through the excel file
http://www.apache.org/dyn/closer.cgi/poi/release/bin/poi-bin-3.12-20150511.tar.gz

3. Below is the code for the same

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.*;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Row;
import org.sqlite.core.DB;

public class run {
public static void main(String args[]) {
try {

Class.forName("org.sqlite.JDBC");
Connection con = DriverManager.getConnection("jdbc:sqlite:test.db");
PreparedStatement pstm = null; Statement stmt = null;
con.setAutoCommit(false);

pstm = (PreparedStatement) con.prepareStatement("DROP TABLE IF
EXISTS table_name"); pstm.execute();

stmt = con.createStatement();
String sql = "CREATE TABLE table_name " + "(ID INTEGER PRIMARY KEY
AUTOINCREMENT," + " NAME TEXT)";
stmt.executeUpdate(sql);
stmt.close();

FileInputStream input = new FileInputStream("C:\\Emp.xls");
POIFSFileSystem fs = new POIFSFileSystem(input);
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);
Row row;
for (int i = 1; i <= sheet.getLastRowNum(); i++) {
row = sheet.getRow(i);
String col2 = row.getCell(1).getStringCellValue();
String sqlcommand = "INSERT INTO table_name(NAME) Values('" + col2 + "')";
pstm = (PreparedStatement) con.prepareStatement(sqlcommand);
pstm.execute();
System.out.println("Import rows " + i);
}
con.commit();
pstm.close();

con.close();
input.close();
System.out.println("Success import excel to sqlite Database");
} catch (ClassNotFoundException e) {
System.out.println(e);
} catch (SQLException ex) {
System.out.println(ex);
} catch (IOException ioe) {
System.out.println(ioe);
}
}
}

Basic setup of PHP slim framework for creating REST API

2015-07-06T21:35:00.000-07:00

# php-slim-basic-setup

1. Im using Netbeans for my PHP Development

2. This project is a basic setup of PHP slim framework for creating REST Api.

   Github : https://github.com/chandan2588/php-slim-basic-setup

3. Download & Copy project in your system and host it under apache

4. To test this use cURL or you can use this google chrome extension 
Check out "Postman - REST Client": https://chrome.google.com/webstore/detail/postman-rest-client/fdmmgilgnpjigdojojpjoooidkmcomcm

5. Url Examples :
   http://localhost/Location/vendor/slim/slim/index.php/
   http://localhost/Location/vendor/slim/slim/index.php/post
   http://localhost/Location/vendor/slim/slim/index.php/getdata/16
   
   My Project Folder Structure :
   
   Location (Root Folder)
   |__Vendor
      |__slim
         |__slim---> Index.php
            |__Slim (slim lib files)

Installing Brackets On Ubuntu Linux

2015-05-03T11:28:00.001-07:00

Please follow this link for installing Brackets Web Code Editor on Ubuntu Linux

http://ubuntualive.blogspot.in/2014/06/how-to-install-brackets-041-on-ubuntu.html

Ubuntu Linux Commands to Install Node, NPM and Packages

2015-05-03T07:56:00.000-07:00

1. Installing Node js and NPM on Ubuntu Linux, Follow below link

https://www.youtube.com/watch?v=tbgBN2y5_wI

Check node and npm version in terminal :
node -v
npm -v

2. Then in terminal use this below command to install node packages

eg: sudo npm install -g bower express grunt

c#.net with Mongodb tutorial

2015-03-29T04:14:00.001-07:00

Follow this below link :

http://www.codeproject.com/Articles/273145/Using-MongoDB-with-the-Official-Csharp-Driver

About MongoDB :

It's a Document Oriented Database. The data structure stored here is in similar to JSON. It is also classified as one of the popular NoSQL Database.

Excellent post on how to install and get started with mongodb Database

2015-03-24T21:54:00.002-07:00

http://stackoverflow.com/questions/2404742/how-to-install-mongodb-on-windows

Pushing code to GIT || How to add files into Github repository ?

2015-03-20T13:49:00.001-07:00

1. First create a repository at github.com

2. Then install git on your system
http://git-scm.com/downloads

3. after installing open command prompt as Admin

4. then navigate to ur project folder in cmd
e:\myproject>

5. now we will type the git commands

git init
git add *
git commit -m "first commit"
git remote add origin https://github.com/<repository-URL>
git push origin master --force OR git push origin master OR git push -u origin master

Eg.: e:\myproject> git init

6. Now you should be able to see your files in your github,com repository.

[Resolved] Error: [ngRepeat:dupes] Duplicates in a repeater are not allowed. Use 'track by' expression to specify unique keys. Repeater: playlist in playlists, Duplicate key: string:", Duplicate value: "

2015-03-19T12:54:00.001-07:00

Hi today while writing angularjs code using angular directive 'ngRepeat' i came across this below error, to resolve this follow below blog link :

error:

Error: [ngRepeat:dupes] Duplicates in a repeater are not allowed. Use 'track by' expression to specify unique keys. Repeater: playlist in playlists, Duplicate key: string:", Duplicate value: "

solution :

http://www.anujgakhar.com/2013/06/15/duplicates-in-a-repeater-are-not-allowed-in-angularjs/

Allow CORS in ASP.Net MVC

2015-03-19T11:13:00.000-07:00

http://stackoverflow.com/a/6290385

Command to list all the globally installed npm pacakages with version

2015-03-11T21:58:00.000-07:00

hi, to list all the globally installed npm packages type this below command

npm list -g --depth=0

Uploading a File (Or Files) With ASP.NET MVC

2015-01-18T01:05:00.001-08:00

Uploading a File (Or Files) With ASP.NET MVC -

AngularJS Dependency Injection - Demystified · Anand Mani Sankar

2015-01-16T12:02:00.001-08:00

AngularJS Dependency Injection - Demystified · Anand Mani Sankar

Learning Dependency Injection with Examples

2015-01-16T11:33:00.000-08:00

1. Definition

Simple Example Dependency Injection

2. Types of Dependency Injection

Types of DI

[Resolved- AngularJS Routing] Uncaught Error : [$injector:Modulerr]

2015-01-01T09:13:00.001-08:00

hi recently while using angularjs routing i came up with this below issue.

to resolve this go to your angularjs code and change this below code

var homeMainApp = angular.module('homeMainA', []);

to

var homeMainApp = angular.module('homeMainA', ['ngRoute']);

hope that resolves your issue as well.thanks

[Resolved] The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'

2014-12-23T21:49:00.000-08:00

hi i was accessing a SharePoint portal when i got this below error

The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'

lets see how to resolve this :

now run cmd as admin and go to this below path and type aspnet_regiis -i

path : C:\Windows\Microsoft.NET\Framework64\v2.0.50727

Next type aspnet_regiis -ga "NT AUTHORITY\NETWORK SERVICE"

Now you should be able to browse your websites.
Thanks.

Calling a json rest api from angularJS || using AngularJS XMLHttpRequest to call service

2014-12-23T12:57:00.001-08:00

hi lets see how to call a http rest api from angularjs

1. create the rest api which returns JSON data

2. Host the Http rest api ( in my case im hosting it on localhost )

3. Now we will see how to call this http api from angularjs

Code:

<!DOCTYPE html>

<html>
<head>

<script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.26/angular.min.js"></script>

</head>

<body>
<div ng-app="" ng-controller="EmpData">

<div ng-repeat="x in Emp">
<h1> {{ 'Employee ID:' + x.EID }} </h1>
<p>{{ 'Name: ' + x.EName}}</p>
<p>{{ 'Salary: ' + x.ESalary}}</p>
</div>

</div>

<script>

function EmpData($scope, $http) {
$http.get("http://localhost/api/Home").
success(function (data) {
$scope.Emp = data;

});
}
</script>

</body>
</html>

4. Output

[Resolved] WEBAPI ERROR using Json: The 'ObjectContent`1' type failed to serialize the response body for content type 'application/xml; charset=utf-8'.

2014-12-23T12:15:00.003-08:00

hi lets see how to resolve below error occurred while accessing web api for Json datatype :

The 'ObjectContent`1' type failed to serialize the response body for content type 'application/xml; charset=utf-8'.

Solution:

go to global.asax file and in Application_Start() event add this below line.

GlobalConfiguration.Configuration.Formatters.JsonFormatter.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;
GlobalConfiguration.Configuration.Formatters.Remove(GlobalConfiguration.Configuration.Formatters.XmlFormatter);

After this u shud b able to run the webapi

Output:

Tutorial for Selecting nth last element using jquery || using nth-last-child in jquery

2014-12-05T10:22:00.002-08:00

hi let see how to select a nth last element like the <div>, <p>, <h1> etc. using jquery.

Now in below example just to check if we have selected the correct element we will change its color

example for selecting a 2nd last <h1> element which is inside a <div>

<!DOCTYPE html>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<title></title>
<script src=”//ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js”></script>
<script type=”text/javascript”>
$(document).ready(function () {
$(“button”).click(function () {

$(“h1:nth-last-child(2)”).css(“background-color”, “yellow”);

});
});
</script>

</head>
<body>
<div>
<h1>im 1st h1</h1>
<h1>im 2nd h1</h1>
<h1>im 3rd h1</h1>
<h1>im 4th h1</h1>
<h1>im 5th h1</h1>
</div>
<button>Change color of 4th element ( as it is 2nd last )</button>
</body>
</html>

output:

AngularJS alert message box using $window

2014-12-05T10:20:00.001-08:00

hi in this post i will show how to show an alert box in angularJS using $window element

Code :

<!DOCTYPE html>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<title></title>
<script src=”//ajax.googleapis.com/ajax/libs/angularjs/1.2.26/angular.min.js”></script>
<script type=”text/javascript”>
function homeController($scope, $window)
{
$scope.showalert = function ()
{
$window.alert($scope.name);
}
}
</script>
</head>
<body>
<div ng-app=”” ng-controller=”homeController”>
<input type=”text” ng-model=”name” />
<button type=”submit” ng-click=”showalert()”>Submit</button>
</div>

</body>
</html>

output:

Exception Handling in asp.net mvc using global.asax application_error() Method

2014-12-05T10:19:00.002-08:00

hi now lets see how to catch exception in asp.net mvc using global.asax application_error() Method.

1. set Custom Error to Off in the web.config file

2. go to global.asax file and add this below code.

protected void Application_Error(object sender, EventArgs e)
{
Exception exception = Server.GetLastError();
Response.Clear();

HttpException httpException = exception as HttpException;

if (httpException != null)
{
string action;

switch (httpException.GetHttpCode())
{
case 404:
// page not found
action = “HttpError404″; // create action method named HttpError404 in controller and also add the appropriate view
break;
case 500:
// server error
action = “HttpError500″; // create action method named HttpError500 in controller and also add the appropriate view
break;
default:
action = “HttpOtherErrors”; // create action method named HttpOtherErrors in controller and also add the appropriate view
break;
}

// clear error on server
Server.ClearError();

Response.Redirect(String.Format(“~/ErrorHandle/{0}/?message={1}”, action, exception.Message)); // ErrorHandle is the controller Name
}
else
{
Response.Redirect(String.Format(“~/ErrorHandle/{0}/?message={1}”, “HttpOtherErrors”, exception.Message));
}
}

3. in controller catch the exception message and show it in the view

public ActionResult HttpOtherErrors(string message)
{
ViewBag.ExceptionMessg = message;
return View();
}