Programming9s: 2015

Monday, November 9, 2015

Test RestFull service post method using Rest Assured Framework+Test Case Example

1)This is the my hatchstation_registration.json file

{
"actionName": "SUBMIT",
"cookie": {
"data": [],
"refererServiceId": "563081ed59f1a83e1aa3a432"
},
"formData": [
{
"cardId": "56307db259f1a83e1aa3a42e",
"fieldData": [
{
"fieldName": "mobileNumber",
"fieldValue": "9010163733"
}
]
},
{
"cardId": "56307e0559f1a83e1aa3a42f",
"fieldData": [
{
"fieldName": "firstName",
"fieldValue": "satya"
}
]
},
{
"cardId": "56307e5d59f1a83e1aa3a430",
"fieldData": [
{
"fieldName": "emailAddress",
"fieldValue": "satya@gmail.com"
}
]
},
{
"cardId": "56307ea559f1a83e1aa3a431",
"fieldData": [
{
"fieldName": "summaryCard",
"fieldValue": ""
}
]
}
],
"deckId": "",
"serviceId": "56307c85fd63ddcbfb47a1fa"

}

2).Using Rest Assured Framework we can easily test the rest full service

@Produces(MediaType.APPLICATION_JSON)
@Test
public void testSubmitActionRequest() {

String jsonString = "";
try{
String APIUrl = "http://localhost:9090/api/service/cardaction/submit";
InputStream inputStream = new FileInputStream("G:/Business JSON Strctures/hatchstation/hatchstation_registration.json");
InputStreamReader inputStreamReader = new InputStreamReader(inputStream);
BufferedReader br = new BufferedReader(inputStreamReader);
String line;
while ((line = br.readLine()) != null) {
jsonString += line + "\n";
}

RequestSpecBuilder builder = new RequestSpecBuilder();
builder.setBody(jsonString);
builder.setContentType("application/json; charset=UTF-8");
builder.addHeader("x-username", "99999999999");
RequestSpecification requestSpec = builder.build();
Response response = given().authentication().preemptive().basic("","").spec(requestSpec).when().post(APIUrl);
JSONObject JSONResponseBody = new JSONObject(response.body().asString());
System.out.println("JSONResponseBody "+JSONResponseBody.toString());

}
catch(Exception e){
e.printStackTrace();
}
}

3) Sample response from url is like the following json

{
  "cookie" : {
    "customerId" : "5640dc3e974f5393a83131bd",
    "refererServiceId" : "563a0b52e0705e93005c7a6b"
  },
  "serverDirectives" : {
    "clearCache" : true,
    "redirectCardId" : "563a0b63e0705e93005c7a6c"
  },
  "statusCode" : 0,
  "statusMessage" : "SUCCESS"
}

Monday, September 21, 2015

Introduction to Nosql databases

Hi guys,

In this post i am going to explain introduction to nosql(not only sql) database and why it is came into market.

In olden days there was a less of processing of data analatics maintained by any computers and mobile devices.But now-a-days everything like a unstructured data. To maintain unstructured data in sql related databases gets more burden as well as server maintenance cost becomes very hard so the nosql databases will be helpfull in mobile platforms as well as prodcut based platfroms.

The list of Nosql databases are:MongoDB,couchDB,cassandra,.....etc

NosqlDB MongoDB:

Mongodb is a open source NOSQL database was created to store Unstructured data(like product and content development)

The best Real world examples in Product and Content management: metLife ,Expedia,flipcart, eBay ,Shuterlfly and AADHAR web portal

MongoDB is a document database that provides high performance, high availability, and easy scalability.

In future nosql databases are will get popular in the market because the reason is to maintain the bigdata(strctured and unstructured data).

Wednesday, July 8, 2015

Mongodb proedures

Procedure1

var myCursor = db.card.find();
while (myCursor.hasNext()) {
var doc = myCursor.next();
print("deckId id:"+doc.deckId);
print(doc.uiTemplate.widget[0].formFieldName);
print(doc.uiTemplate.widget[0].fieldDesc);
print(tojson(doc._id));
print('========================');
}

Procedure2

var myCursor = db.deck.find({"serviceId":"559b975234772ab9ada732f5"});
while (myCursor.hasNext()) {
var doc = myCursor.next();
print("dataId id:"+doc.childrenPartialInfo[0].dataId);
var childrens = doc.childrenPartialInfo;
for(var i = 0; i < childrens.length; i++) {
var cardId = childrens[i].dataId;
print(cardId);
var cardCursor = db.card.find({"_id":ObjectId(cardId)});
var cardDoc = cardCursor.next();
print(cardId +" --- "+cardDoc.uiTemplate.widget[0].formFieldName);
print(cardId +" --- "+cardDoc.uiTemplate.widget[0].formFieldName+","+cardDoc.uiTemplate.widget[0].fieldLabel+","+cardDoc.uiTemplate.widget[0].fieldDesc+","+cardDoc.uiTemplate.widget[0].hint);
}
print(tojson(doc._id));
print('========================');
}

Saturday, July 4, 2015

Python Core syllabus

This is the python core syllabus.

Introduction

History
Features
Setting up path
Working with Python
Basic Syntax
Variable and Data Types
Operator

Looping

For Break
While
Nested loops

Control Statements

Break
Continue
Pass

String Manipulation

Accessing Strings
Basic Operations
String slices
Function and Methods

Lists

Introduction
Accessing list
Operations
Working with lists
Function and Methods

Tuple

Introduction
Accessing tuples
Operations
Working
Functions and Methods
Dictionaries

Introduction

Accessing values in dictionaries
Working with dictionaries
Properties
Functions

Functions

Defining a function
Calling a function
Types of functions
Function Arguments
Anonymous functions
Global and local variables

Modules

Importing module
Math module
Random module
Packages
Composition

Input-Output

Printing on screen
Reading data from keyboard
Opening and closing file
Reading and writing files
Functions

Exception Handling

Exception
Exception Handling
Except clause
Try ? finally clause
User Defined Exceptions

Advanced Python

Friday, July 3, 2015

Satyanarayana : Unknown Lifecycle Phase Error in Maven Build

Satyanarayana : Unknown Lifecycle Phase Error in Maven Build: Problem [ERROR] Unknown lifecycle phase "test1" . You must specify a valid lifecycle phase or a goal in the format &l...

Python Dictionary data type example

#creating dictionary
dict = {'Name' : 'hooper','Sal' : 122,'id':222,'Address':'hyd'};
print dict
#accessing dict elements
print "first element is dict['Name']:", dict['Name'];
#updating dict elements
print "ofter updation dice elements are"
dict['Name']='satya';
dict['comany']='heeperlabs';
print dict
# iteration dictionary elements
for items in dict.items():
print items
# deleting single element from dictionary
del dict['Sal'];
print dict
# deleting all element from dictionary
dict.clear();
print dict
# deleting entire dictionary
del dict
print dict

Thursday, July 2, 2015

designing page with iframes with html and css

html code
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" type="text/css" href="Style.css">
<style>
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: underline;
}
#nav {
line-height:30px;
background-color:#eeeeee;
height:500px;
width:100px;
float:left;
padding:5px;
text-align:center;
padding:15px;
border:1px solid black ;
width:100px;
border-top:0px;
border-left:0px;
border-right:thick 1px balck;
}
</style>
</head>
<body>
<iframe name="iframe_a" align="center" style="border:none" SCROLLING="yes" ></iframe>
<div class="menu-wrap">
<nav class="menu">
<ul class="clearfix">
<li>
<a href="./About*">About <span class="arrow">▼</span></a>
<ul class="sub-menu">
<li><a href="./About*" target="iframe_a">introduction</a></li>
<li><a href="./About*" target="iframe_a">Informatio</a></li>
<li><a href="./About*" target="iframe_a">AboutUs</a></li>
</ul>
</li>
<li>
<a href="./Services*" target="iframe_a">Services <span class="arrow">▼</span></a>
<ul class="sub-menu">
<li><a href="./Services*" target="iframe_a">Business</a></li>
<li><a href="./Services*" target="iframe_a">Hooper App</a></li>
<li><a href="./Services*" target="iframe_a">Chat App</a></li>
</ul>
</li>
<li>
<a href="./Clients*" target="iframe_a">Clients <span class="arrow">▼</span></a>
<ul class="sub-menu">
<li><a href="./Clients*" target="iframe_a">Google</a></li>
<li><a href="./Clients*" target="iframe_a">Facebook</a></li>
<li><a href="./Clients*" target="iframe_a">Tcs</a></li>
</ul>
</li>
<li>
<a href="./ContactUs*" target="iframe_a">ContactUs <span class="arrow">▼</span></a>
<ul class="sub-menu">
<li><a href="./ContactUs*" target="iframe_a">MainBranch</a></li>
<li><a href="./ContactUs*" target="iframe_a">SubBranch</a></li>
</ul>
</li>
</ul>
</nav>
</div>
<div id="nav">
<a href="./Login.jsp" target="iframe_a">Login</a><br>
<a href="./registation.html" target="iframe_a" >Sign up</a>
<br>
</div>
</body>
</html>
css code
iframe {
height: 350px;
width: 500px;
position:absolute;
top: 60%;
margin-top: -175px;
left: 20%;
margin-left: 80px;
FRAMEBORDER="0";
SCROLLING="no";
}
.clearfix:after {
display:blue;
clear:both;
}
/*----- Menu Outline -----*/
.menu-wrap {
width:80%;
box-shadow:0px 1px 3px rgba(0,0,0,0.2);
background:blue;
}
.menu {
margin:0px auto;
background-color:#eeeeee;
color:black;
text-align:right;
padding:25px;
border:1px solid black ;
width:1150px;
border-top:0px;
border-left:0px;
border-right:0px;
}
.menu li {
margin:0px;
list-style:none;
font-family:'Ek Mukta';
}
.menu a {
transition:all linear 0.15s;
color:blue;
}
.menu li:hover > a, .menu .current-item > a {
text-decoration:none;
color:blue;
}
.menu .arrow {
font-size:11px;
line-height:0%;
}
/*----- Top Level -----*/
.menu > ul > li {
float:left;
display:inline-blue;
position:relative;
font-size:19px;
}
.menu > ul > li > a {
padding:10px 35px;
display:inline-blue;
text-shadow:0px 1px 0px rgba(0,0,0,0.4);
}
.menu > ul > li:hover > a, .menu > ul > .current-item > a {
background:#eeeeee;
}
/*----- Bottom Level -----*/
.menu li:hover .sub-menu {
z-index:1;
opacity:1;
}
.sub-menu {
width:100%;
padding:5px 0px;
position:absolute;
top:100%;
left:0px;
z-index:-1;
opacity:0;
transition:opacity linear 0.15s;
box-shadow:0px 2px 3px rgba(0,0,0,0.2);
background:#eeeeee;
}
.sub-menu li {
display:block;
font-size:16px;
}
.sub-menu li a {
padding:10px 30px;
display:block;
}
.sub-menu li a:hover, .sub-menu .current-item a {
background:#eeeeee;
}

Wednesday, July 1, 2015

User registration form with CAPTCHA using django-simple-captcha using python

sample web registration in python

import web
# Init our application, this is just about the most basic setup
render = web.template.render('/var/www/templates/')
urls = ('/', 'Index')
app = web.application(urls, globals())
class Index:
# Create a basic form shared by the class methods
def __init__(self):
self.registerForm = web.form.Form(
# We're adding some fields and a submit button
# Each field has a validator, which verifies its correctness
# In this case we check if the field is not null
# Other attributes are available: description, id, HTML class name, etc
# See http://webpy.org/form for reference
web.form.Textbox('username', web.form.notnull, description='User name'),
web.form.Password('password', web.form.notnull, description='Password'),
web.form.Password('repeat_password', web.form.notnull,
description='Repeat password'),
web.form.Button('Register'),
# Whole forms can have validators, too
# Here, we check if password fields have the same content
validators = [web.form.Validator("Passwords didn't match.", lambda i:
i.password == i.repeat_password)]
)
# GET method is used when there is no form data sent to the server
def GET(self):
form = self.registerForm()
return render.form(content=form)
# POST method carries form data
def POST(self):
# Notice how flawlessly web.py form works, receiving all the data for us
form = self.registerForm()
if(not form.validates()):
return render.form(content=form)
else:
return "Form successfuly sent! Username: %s, password: %s" % \
(form.d.username, form.d.password)
application = app.wsgifunc()
if __name__=="__main__":
app.run()
user.py
# Django settings for app project.
# Import the os.path module for doing manipulation with file paths.
import os.path
DEBUG = True
TEMPLATE_DEBUG = DEBUG
ADMINS = (
# ('Your Name', 'your_email@example.com'),
)
MANAGERS = ADMINS
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3', # # Using sqlite3
'NAME': '/var/www/mydb', # Absolute path to the database file
# The following settings are not used with sqlite3:
'USER': '',
'PASSWORD': '',
'HOST': '', # Empty for localhost through domain sockets or '127.0.0.1' for localhost through TCP.
'PORT': '', # Set to empty string for default.
}
}
# Hosts/domain names that are valid for this site; required if DEBUG is False
# See https://docs.djangoproject.com/en/1.5/ref/settings/#allowed-hosts
ALLOWED_HOSTS = []
# Local time zone for this installation. Choices can be found here:
# http://en.wikipedia.org/wiki/List_of_tz_zones_by_name
# although not all choices may be available on all operating systems.
# In a Windows environment this must be set to your system time zone.
TIME_ZONE = 'America/Los_Angeles'
# Language code for this installation. All choices can be found here:
# http://www.i18nguy.com/unicode/language-identifiers.html
LANGUAGE_CODE = 'en-us'
SITE_ID = 1
# If you set this to False, Django will make some optimizations so as not
# to load the internationalization machinery.
USE_I18N = True
# If you set this to False, Django will not format dates, numbers and
# calendars according to the current locale.
USE_L10N = True
# If you set this to False, Django will not use timezone-aware datetimes.
USE_TZ = True
# Absolute filesystem path to the directory that will hold user-uploaded files.
# Example: "/var/www/example.com/media/"
MEDIA_ROOT = ''
# URL that handles the media served from MEDIA_ROOT. Make sure to use a
# trailing slash.
# Examples: "http://example.com/media/", "http://media.example.com/"
MEDIA_URL = ''
# Absolute path to the directory static files should be collected to.
# Don't put anything in this directory yourself; store your static files
# in apps' "static/" subdirectories and in STATICFILES_DIRS.
# Example: "/var/www/example.com/static/"
STATIC_ROOT = '/var/www/app/static/'
# URL prefix for static files.
# Example: "http://example.com/static/", "http://static.example.com/"
STATIC_URL = '/static/'
# Additional locations of static files
STATICFILES_DIRS = (
# Put strings here, like "/home/html/static" or "C:/www/django/static".
# Always use forward slashes, even on Windows.
# Don't forget to use absolute paths, not relative paths.
)
# List of finder classes that know how to find static files in
# various locations.
STATICFILES_FINDERS = (
'django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder',
# 'django.contrib.staticfiles.finders.DefaultStorageFinder',
)
# Make this unique, and don't share it with anybody.
SECRET_KEY = 'vw7__ve*_3j^edw+@9k9(24_efqjnul-k=84yis*ew$xstr&*!'
# List of callables that know how to import templates from various sources.
TEMPLATE_LOADERS = (
'django.template.loaders.filesystem.Loader',
'django.template.loaders.app_directories.Loader',
# 'django.template.loaders.eggs.Loader',
)
MIDDLEWARE_CLASSES = (
'django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
# Uncomment the next line for simple clickjacking protection:
# 'django.middleware.clickjacking.XFrameOptionsMiddleware',
)
ROOT_URLCONF = 'app.urls'
# Python dotted path to the WSGI application used by Django's runserver.
WSGI_APPLICATION = 'app.wsgi.application'
TEMPLATE_DIRS = (
# Include the "templates" directory in the current directory.
os.path.join(os.path.dirname(__file__), "templates"),
# Put strings here, like "/home/html/django_templates" or "C:/www/django/templates".
# Always use forward slashes, even on Windows.
# Don't forget to use absolute paths, not relative paths.
)
INSTALLED_APPS = (
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles',
'captcha', # Include the django-simple-captcha application
'registration', # Include the registration
# Uncomment the next line to enable the admin:
# 'django.contrib.admin',
# Uncomment the next line to enable admin documentation:
# 'django.contrib.admindocs',
)
# A sample logging configuration. The only tangible logging
# performed by this configuration is to send an email to
# the site admins on every HTTP 500 error when DEBUG=False.
# See http://docs.djangoproject.com/en/dev/topics/logging for
# more details on how to customize your logging configuration.
LOGGING = {
'version': 1,
'disable_existing_loggers': False,
'filters': {
'require_debug_false': {
'()': 'django.utils.log.RequireDebugFalse'
}
},
'handlers': {
'mail_admins': {
'level': 'ERROR',
'filters': ['require_debug_false'],
'class': 'django.utils.log.AdminEmailHandler'
}
},
'loggers': {
'django.request': {
'handlers': ['mail_admins'],
'level': 'ERROR',
'propagate': True,
},
}
}

Pythan hello rest full service in pycharm IDE

echo_service:


import tornado.ioloop
import pyrestful.rest

from pyrestful import mediatypes
from pyrestful.rest import get
class EchoService(pyrestful.rest.RestHandler):
      @get(_path="/echo/{name}", _produces=mediatypes.APPLICATION_JSON)
      def sayHello(self, name):
           return {"Hello":name}

if __name__ == "__main__":

           print "Start the echo service"           app = pyrestful.rest.RestService([EchoService])
           app.listen(8080)
           tornado.ioloop.IOLoop.instance().start()
           print "\nStop the echo service"

new_service

__author__ = 'LENOVO'from datetime import date
import tornado.escape
import tornado.ioloop
import tornado.web

class VersionHandler(tornado.web.RequestHandler):
    def get(self):
        response = { 'version': '3.5.1',
                     'last_build':  date.today().isoformat() }
        self.write(response)

class GetGameByIdHandler(tornado.web.RequestHandler):
    def get(self, id):
        response = { 'id': int(id),
                     'name': 'satya',
                     'release_date': date.today().isoformat() }
        self.write(response)

application = tornado.web.Application([
    (r"/getgamebyid/([0-9]+)", GetGameByIdHandler),
    (r"/version", VersionHandler)
])

class GetNamebySal(tornado.web.RequestHandler):
    def get(self, sal):
        response = { 'id': int(sal),
                     'name': 'satya',
                     'release_date': date.today().isoformat() }
        self.write(response)

application = tornado.web.Application([
    (r"/getnamebysal/([0-9]+)", GetNamebySal),
    (r"/version", VersionHandler)
])

if __name__ == "__main__":
    print "starting service"    application.listen(8080)
    tornado.ioloop.IOLoop.instance().start()

Wednesday, June 24, 2015

mongodb find queries

Mongodb Find queries

db.card.find();======it will display all documents
db.card.findOne();=====it will disply first document
db.card.find({title:"Chicken monchow soup"});=specific document with all fields

db.user_profile.find({"mobileNo":9988776655,"countryCode":"91"})==one document

db.user_profile.find({"mobileNo":9988776655,"countryCode":"91","mobileNo":8112300662,"countryCode":"91"})===two documnets

db.user_profile.find({mobileNo:{$in:[9988776655,8112300662]}})===specific document based on matching values

db.user_profile.find(
{$or:[
{"mobileNo": 9988776655, "countryCode":"91"},
{"mobileNo": 8112300662,"countryCode":"1"} ,===========based on country code
]})

List of Regular Expressions Symbols

Character Classes

Character classes are used to define the content of the pattern. E.g. what should the pattern look for?
. Dot, any character (may or may not match line terminators, read on)

\d A digit: [0-9]
\D A non-digit: [^0-9]
\s A whitespace character: [ \t\n\x0B\f\r]
\S A non-whitespace character: [^\s]
\w A word character: [a-zA-Z_0-9]
\W A non-word character: [^\w]

However; notice that in Java, you will need to “double escape” these backslashes.
String pattern = "\\d \\D \\W \\w \\S \\s";

Quantifiers

Quantifiers can be used to specify the number or length that part of a pattern should match or repeat. A quantifier will bind to the expression group to its immediate left.

* Match 0 or more times
+ Match 1 or more times
? Match 1 or 0 times
{n} Match exactly n times
{n,} Match at least n times
{n,m} Match at least n but not more than m times

Meta-characters

Meta-characters are used to group, divide, and perform special operations in patterns.

\ Escape the next meta-character (it becomes a normal/literal character)
^ Match the beginning of the line
. Match any character (except newline)
$ Match the end of the line (or before newline at the end)
| Alternation (‘or’ statement)
() Grouping
[] Custom character class

Monday, June 22, 2015

Reading properties from property util classes

Ex:

application.properties

template_card_image_path=D:/smilesurance-plain.png
hooper_code=234
service_id=01
business_code=SMILIN
images_path=D:/Smiline/cards/
corporate_name=Hackett Group
card_validity=Valid till:

PropertyUtils .java

package com.hps.platform.utils;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.hps.platform.utility.service.MessageService;

public class PropertyUtils {

private static final Logger LOGGER = LoggerFactory.getLogger(MessageService.class);
private static PropertyUtils propertyUtilsInstance;
private static Properties properties;

static{
propertyUtilsInstance = new PropertyUtils();
}

private PropertyUtils() {
if (properties == null) {
try {
properties = loadProperties();
} catch (IOException e) {
LOGGER.error("Threw a BadException, full stack trace follows:",e);
e.printStackTrace();
}
}
}

private Properties loadProperties() throws IOException {
Properties properties = new Properties();
InputStream inputStream = getClass().getClassLoader().getResourceAsStream("application.properties");
if (inputStream == null) {
throw new FileNotFoundException("not loaded!");
}
properties.load(inputStream);
return properties;
}

public static Properties getProperties() {
return properties;
}

}

we can read the properties in the following way

public static String image_template_path PropertyUtils.getProperties().getProperty("template_card_image_path");
public static String corporateName = PropertyUtils.getProperties().getProperty("corporate_name");
public static String saved_image_path =PropertyUtils.getProperties().getProperty("images_path");

Saturday, June 20, 2015

Retrieving multiple records using spring jdbc+mysql

(type1 without passing any parameters to query and getting all rows)

String SELECT_NAME_CARDID_EXPIRY=""select *from user_enrollment_data";

DAO
public List<FailedRecords> getAllRecords();

DaoImpl

public List<FailedRecords> getAllRecords() {

return mysqlJdbcTemplate.query

(SELECT_NAME_CARDID_EXPIRY,

new NullRecordRowMapper());

}

NullRecordRowMapper

public class NullRecordRowMapper implements RowMapper<FailedRecords> {

@Override

public FailedRecords mapRow(ResultSet resultSet, int line)

throws SQLException {

NullRecordsExtractor userExtractor = new NullRecordsExtractor();

return userExtractor.extractData(resultSet);

}

NullRecordsExtractor

Here FailedRecords pojo it contains database fileds

public class NullRecordsExtractor implements ResultSetExtractor<FailedRecords>{

public FailedRecords extractData(ResultSet resultSet) throws SQLException,

DataAccessException {

FailedRecords failedRecords = new FailedRecords();

failedRecords.setId(resultSet.getString(1));

failedRecords.setBusinessCode(resultSet.getString(2));

failedRecords.setCsvData(resultSet.getString(3));

failedRecords.setCardId(resultSet.getString(4));

failedRecords.setCardExpiry(resultSet.getString(5));

failedRecords.setMailStatus(resultSet.getString(6));

failedRecords.setSmsStatus(resultSet.getString(7));

failedRecords.setMobileNo(resultSet.getString(8));

failedRecords.setCreatedDate(resultSet.getDate(9));

/*String firstName=csvData.split(",")[1];

String lastName=csvData.split(",")[2];

System.out.println(firstName+" "+lastName);*/

return failedRecords;

}

type2(passing single paramter and getting single row)

String SELECT_TOTAL_FAMILY=" public final String SELECT_TOTAL_FAMILY="select *from user_enrollment_data where mail_status is null and mobile_no=?";

DAO

public List<FailedRecords> getFamilyMembers(String mobileNo);

DaoImpl

public List<FailedRecords> getFamilyMembers(String mobileNo) {

return mysqlJdbcTemplate.query

(SELECT_TOTAL_FAMILY,

new Object[] { mobileNo },

new NullRecordRowMapper());

}

same NullRecordRowMapper and NullRecordsExtractor

Tuesday, June 16, 2015

Jasper reports example with java beans without database

Use jasper reports library

<pre name="code" class="java">

DataBean.java

public class DataBean {
private String name;
private String occupation;
private String place;
private String country;
//setters and getters
}

DataBeanMaker.java

package com.report.javabean;
import java.util.ArrayList;
public class DataBeanMaker {

public ArrayList<DataBean> getDataBeanList() {

ArrayList<DataBean> dataBeanList = new ArrayList<DataBean>();

dataBeanList.add(produce("umar farooq", "Manager", "karnool", "india"));
dataBeanList.add(produce("mohan", "SSE", "vizag", "india"));
dataBeanList.add(produce("Srikanth tirumala", "CEO", "hyderabad", "India"));
dataBeanList.add(produce("ruby", "Co-Founder", "karnool", "India"));
dataBeanList.add(produce("subbu", "SSE" , "nelure", "india"));
dataBeanList.add(produce("mustak", "SE" , "karnool", "india"));
dataBeanList.add(produce("satya", "SE", "nalgonda", "india"));
dataBeanList.add(produce("kiran", "SSE" , "east", "india"));
dataBeanList.add(produce("sujatha", "HR" , "hyderabad", "india"));

return dataBeanList;
}

private DataBean produce(String name, String occupation, String place, String country) {

DataBean dataBean = new DataBean();
dataBean.setName(name);
dataBean.setOccupation(occupation);
dataBean.setPlace(place);
dataBean.setCountry(country);

return dataBean;
}

}

Repoter.java

package com.report.javabean;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
public class Reporter {

@SuppressWarnings("unchecked")
public static void main(String[] args) throws Exception {
InputStream inputStream = new FileInputStream ("reports/test_jasper.xml");

DataBeanMaker dataBeanMaker = new DataBeanMaker();
ArrayList<DataBean> dataBeanList = dataBeanMaker.getDataBeanList();

JRBeanCollectionDataSource beanColDataSource = new JRBeanCollectionDataSource(dataBeanList);

Map parameters = new HashMap();

JasperDesign jasperDesign = JRXmlLoader.load(inputStream);
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, beanColDataSource);
JasperExportManager.exportReportToPdfFile(jasperPrint, "D:/demo.pdf");
}
}

test_jasper.xml

<?xml version="1.0" encoding="UTF-8"?>


<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="scriptlet" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="30" rightMargin="30" topMargin="30" bottomMargin="30" whenResourceMissingType="Empty" uuid="4a933c9b-78d7-426f-8fd8-e27159b11caa">
<property name="com.jasperassistant.designer.Grid" value="false"/>
<property name="com.jasperassistant.designer.SnapToGrid" value="false"/>
<property name="com.jasperassistant.designer.GridWidth" value="12"/>
<property name="com.jasperassistant.designer.GridHeight" value="12"/>
<queryString>
<![CDATA[]]>
</queryString>
<field name="country" class="java.lang.String">
<fieldDescription><![CDATA[country]]></fieldDescription>
</field>
<field name="occupation" class="java.lang.String">
<fieldDescription><![CDATA[occupation]]></fieldDescription>
</field>
<field name="name" class="java.lang.String">
<fieldDescription><![CDATA[name]]></fieldDescription>
</field>
<field name="place" class="java.lang.String">
<fieldDescription><![CDATA[place]]></fieldDescription>
</field>
<group name="dummy">
<groupExpression><![CDATA["dummy"]]></groupExpression>
<groupHeader>
<band height="23">
<staticText>
<reportElement mode="Opaque" x="0" y="5" width="535" height="15" backcolor="#70A9A9" uuid="d6b37903-6581-4be2-acd8-a34e03d4a65f"/>
<box>
<bottomPen lineWidth="5.0" lineColor="#CCCCCC"/>
</box>
<text><![CDATA[]]></text>
</staticText>
<staticText>
<reportElement x="136" y="5" width="150" height="15" uuid="bc77d454-a4ad-4acd-a45c-7781a1cc9db3"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Occupation]]></text>
</staticText>
<staticText>
<reportElement x="286" y="5" width="128" height="15" uuid="9a0b1647-7c70-46d2-9904-b6c8ec2516bc"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<text><![CDATA[Place]]></text>
</staticText>
<staticText>
<reportElement x="414" y="5" width="121" height="15" uuid="1d3dc13e-6844-4551-87c4-a84942396de6"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Country]]></text>
</staticText>
<staticText>
<reportElement x="0" y="5" width="136" height="15" uuid="35ea54b3-46ba-4a00-b209-0f0caae22199"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[Name]]></text>
</staticText>
</band>
</groupHeader>
</group>
<detail>
<band height="16">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="535" height="14" backcolor="#E5ECF9" uuid="2b45dbc9-215c-453e-b263-22419173a2a6"/>
<box>
<bottomPen lineWidth="0.25" lineColor="#CCCCCC"/>
</box>
<text><![CDATA[]]></text>
</staticText>
<textField>
<reportElement x="136" y="0" width="150" height="15" uuid="2321034b-fef7-4c07-9605-0a40e48a0080"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{occupation}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="286" y="0" width="128" height="15" uuid="472e0b06-bb32-458f-8073-a637449a060f"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{place}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="414" y="0" width="121" height="15" uuid="6de7ba67-0d5c-48bb-9817-6390fc7a9e13"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="9"/>
</textElement>
<textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="0" width="136" height="15" uuid="d592ad48-a319-4939-860f-733d28e312a2"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
</textField>
</band>
</detail>

</jasperReport>

</pre>

Simple Jasper report example with jdbc

main class

package net.sf.dynamicreports.examples;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import net.sf.dynamicreports.jasper.builder.JasperReportBuilder;
import net.sf.dynamicreports.report.builder.DynamicReports;
import net.sf.dynamicreports.report.builder.column.Columns;
import net.sf.dynamicreports.report.builder.component.Components;
import net.sf.dynamicreports.report.builder.datatype.DataTypes;
import net.sf.dynamicreports.report.constant.HorizontalAlignment;
import net.sf.dynamicreports.report.exception.DRException;

/**
* SQL
*

CREATE TABLE `customers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(50) DEFAULT NULL,
`last_name` varchar(50) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

INSERT INTO `test`.`customers` (`first_name`, `last_name`, `date`) VALUES ('Ricardo', 'Mariaca', CURRENT_DATE);
INSERT INTO `test`.`customers` (`first_name`, `last_name`, `date`) VALUES ('YONG', 'MOOK KIM', CURRENT_DATE);

*/
public class SimpleReportExample {

public static void main(String[] args) {
Connection connection = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
} catch (SQLException e) {
e.printStackTrace();
return;
} catch (ClassNotFoundException e) {
e.printStackTrace();
return;
}

JasperReportBuilder report = DynamicReports.report();//a new report
report
.columns(
Columns.column("Customer Id", "id", DataTypes.integerType())
.setHorizontalAlignment(HorizontalAlignment.LEFT),
Columns.column("First Name", "first_name", DataTypes.stringType()),
Columns.column("Last Name", "last_name", DataTypes.stringType()),
Columns.column("Date", "date", DataTypes.dateType())
.setHorizontalAlignment(HorizontalAlignment.LEFT)
)
.title(//title of the report
Components.text("SimpleReportExample")
.setHorizontalAlignment(HorizontalAlignment.CENTER))
.pageFooter(Components.pageXofY())//show page number on the page footer
.setDataSource("SELECT id, first_name, last_name, date FROM customers", connection);

try {
report.show();//show the report
report.toPdf(new FileOutputStream("D:/Text.pdf"));//export the report to a pdf file
} catch (DRException e) {
e.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
}
}
}

Sunday, June 14, 2015

Running console application(main program) using Maven(pom.xml)

The following pom.xml is suitable to run main programs in java using maven

pom.xml

<build>
<plugins>
<plugin>
<artifactId>maven-plugin-plugin</artifactId>
<version>2.3</version>
<configuration>
<goalPrefix>clean</goalPrefix>
<goalPrefix>install</goalPrefix>
<goalPrefix>run</goalPrefix>
</configuration>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>exec-maven-plugin</artifactId>
<version>1.2.1</version>
<executions>
<execution>
<phase>test</phase>
<goals>
<goal>java</goal>
</goals>
</execution>
</executions>
<configuration>
<mainClass>com.email.TestApp</mainClass>
</configuration>
</plugin>

</plugins>
</build>

Unknown Lifecycle Phase Error in Maven Build

Problem

[ERROR] Unknown lifecycle phase "test1". You must specify a valid lifecycle phase or a goal

in the format <plugin-prefix>:<goal> or <plugin-group-id>:<plugin-artifact-id>[:<plugin-

version>]:<goal>. Available lifecycle phases are: validate, initialize, generate-sources,

process-sources, generate-resources, process-resources, compile, process-classes, generate-

test-sources, process-test-sources, generate-test-resources, process-test-resources, test-

compile, process-test-classes, test, prepare-package, package, pre-integration-test,

integration-test, post-integration-test, verify, install, deploy, pre-clean, clean, post-clean,

pre-site, site, post-site, site-deploy. -> [Help 1]

If you look at the above error “Unknown lifecycle phase”, your build could not detect the pre-defined lifecycle phase used by Maven. Maven has the following phases:

validate – validate the project is correct and all necessary information is available
compile – compile the source code of the project
test – test the compiled source code using a suitable unit testing framework. These tests should not require the code be packaged or deployed
package – take the compiled code and package it in its distributable format, such as a JAR.
integration-test – process and deploy the package if necessary into an environment where integration tests can be run
verify – run any checks to verify the package is valid and meets quality criteria
install – install the package into the local repository, for use as a dependency in other projects locally
deploy – done in an integration or release environment, copies the final package to the remote repository for sharing with other developers and projects
Solution is: package

Programming9s