Sudarsan Gopal sudarsang

sudarsang / gist:f2eb5b0f794ee73d396c

Last active August 29, 2015 14:22

test

	/**
	* Name: BACSOS-76-ENABLE_AUDIT.SQL
	* Author: Sudarsan Gopal
	* Date: 29/05/2015
	* Platform: SQL Server
	* Maximo Version: 7.5
	* This script will update the DB Config to enable Auditing to the selected fields as per the requirement.
	**/

	UPDATE MAXATTRIBUTECFG SET EAUDITENABLED=1, CHANGED='Y' WHERE OBJECTNAME='ASSET' AND ATTRIBUTENAME IN ('CHANGEBY','CHANGEDATE','CHILDREN','CLASSSTRUCTUREID','CONTRACTOR','DESCRIPTION','GLACCOUNT','INSTALLDATE','MOVEDATE','MOVEDBY','MOVEMEMO','SERIALNUM','STATUS','STATUSDATE','WARRANTYEXPDATE');

sudarsang / with.sql

Last active December 30, 2015 08:09

	WITH R1 AS
	(SELECT * FROM A JOIN B ON A.X = B.Y WHERE A.Z = 'abcd'
	) ,

	R2 AS
	(SELECT * FROM C WHERE D.X = 'pqrs' AND D.Y IN (SELECT Y FROM R1)
	) ,

	R3 AS
	(SELECT * FROM E JOIN R2 ON E.X = R2.Y WHERE E.Z = 'pqrs' AND R2.P ='bla bla'

sudarsang / pom.xml

Created September 14, 2013 02:19

	<plugin>
	<groupId>org.mortbay.jetty</groupId>
	<artifactId>jetty-maven-plugin</artifactId>
	<version>${jetty.maven.plugin.version}</version>
	<configuration>
	<scanIntervalSeconds>5</scanIntervalSeconds>
	<webAppConfig>
	<contextPath>/customerMgr</contextPath>
	</webAppConfig>
	</configuration>

sudarsang / messages_en.properties

Created September 14, 2013 01:46

	label.firstname=First Name
	label.lastname=Last Name
	label.email=Email
	label.telephone=Telephone
	label.addcustomer=Add Customer

	#Validation Error Messages
	Size=the {0} field must be between {2} and {1} characters long
	Size.customer.firstname=FirstName must be between {2} and {1} characters
	Size.customer.lastname=LastName must be between {2} and {1} characters

sudarsang / log4j.xml

Created September 14, 2013 01:23

	<?xml version="1.0" encoding="UTF-8" ?>
	<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">

	<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
	<appender name="console" class="org.apache.log4j.ConsoleAppender">
	<param name="Threshold" value="INFO"/>
	<param name="Target" value="System.out"/>
	<layout class="org.apache.log4j.PatternLayout">
	<param name="ConversionPattern" value="%d{HH:mm:ss,SSS}- %m%n"/>
	</layout>

sudarsang / create_cutomer.sql

Last active December 23, 2015 00:59

	CREATE TABLE CUSTOMER
	( ID INT PRIMARY KEY AUTO_INCREMENT,
	FIRSTNAME VARCHAR(50),
	LASTNAME VARCHAR(50),
	EMAIL VARCHAR(30),
	TELEPHONE VARCHAR(20)
	);