Showing posts from June, 2015

Build React Native App (4) - Redux, Jest, and NativeBase

From this blog, typescript feature will be added. There are couple of ways to implement static type checking like; flow from facebook, PropTypes and Typescript.Typescript is well integrated with Visual Studio Code and supports better linter, error messages, and intellisense.Reference siteGithub Sample Ex4Currnet versionD:\GitRepo\reactnative>npm --version 6.3.0 D:\GitRepo\reactnative>react-native --version react-native-cli: 2.0.1 react-native: n/a - not inside a React Native project directory D:\GitRepo\reactnative>yarn --version 1.9.4 Creating React Native App$ react-native init ex4 If you want to specify the version, add "--version 0.57.3" at the end.Add NativeBase to React Native$ npm install native-base --save ... + native-base@2.8.1 added 71 packages from 42 contributors, removed 50 packages, updated 829 packages and audited 34989 packages in 138.542s found 0 vulnerabilities $ $ yarn yarn install v1.9.4 warning package-lock.json found. Your project contains l…
SQL Query to show new record from duplicate There are so many ways to implement this, but I am going to explain two methods for this topic. One is using with Partition and the another is using Group by
Using Partition SELECT * FROM  (     SELECT  itemcode, HID, CASE  FreeTextField_02  WHEN 'Block' THEN 'B'  WHEN 'Unblock' THEN 'A'   END as ItemStatus ,          ROW_NUMBER() OVER (PARTITION BY itemcode ORDER BY syscreated DESC) AS RowNo     FROM [Synergy].[dbo].[Absences]     WHERE TYPE=1017 and  syscreated >= CONVERT(DATE, Getdate()) ) x WHERE x.RowNo = 1
One of drawback of this implementation is that if you want to create this as view, there will be complaining due to "Order By" clause. 
Using Group By
SELECT  itemcode, HID, CASE  FreeTextField_02  WHEN 'Block' THEN 'B'  WHEN 'Unblock' THEN 'A'   END as ItemStatus FROM [Synergy].[dbo].[Absences]     WHERE HID in (select max(HID) from [Synergy].[dbo].[Absences] w…

Sample application for Active Directory SSO with Spring Security 4 and Waffle

IntroductionI've developed quotation program with Mybatis, Spring MVC, and SQL Server, but I had a request of integrating this module with Spring Security and Active Directory. I've researched about possible solutions and I've spent quite bit of time with Waffle and SAML. SAML is more ideal, but I found out that the entire implementation is too complicated and I decided to use Waffle for this purpose. One of drawback of Waffle is that the Tomcat server must be runned from Windows platform.
I tried to find out spring security example with Waffle, but it is hard to find out the sample from Internet. It took so many hours to create this simple example.
Tools Spring STS: 3.6.4 Spring Security : 4.0.1 Spring framework: 4.x.x Waffle: 1.7.4
Implementation Creating Spring MVC Project Create New Project -> Spring Project -> Spring MVC Updating POM To make easy of managing version, added two versions under "properties"
<properties> <java-version>1.6</java-version&g…