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

Image
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 site Github Sample Ex4 Currnet version D:\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. You...
1 comment

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] where TYPE=1017 and 
syscreated >= CONVERT(DATE, Getdate()) group by itemcode)

Personally, I like this approach and this can be used any sql product. Using MAX function, get the latest modified identifiers and show records from the filtered data.

Comments

Post a Comment

Popular posts from this blog

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

Image
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 site Github Sample Ex4 Currnet version D:\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. You...
Read more

Replacing text in PDF file using iTextSharp

ReplacingTextUsingITextSharp title: Replacing text in PDF file using iTextSharp tags: - PDF - Replace Text - iTextSharp date: Nov 11, 2016 Overview I’ve trying to replace text in PDF file and this is most simple way to replace text in PDF files. Before approaching this, I’ve tried to replace text using command toolkit with pdftk, qpdf to decrypt, and sfk181 to replace string with new, but this approach faced couple of issues; 1. font, 2. text area size. After long investigation, this may be easy way to replace text. Put white colored rectangle on top of string and stamp text on the location like erase text using whitner and write on top of it. Tools Visual Studio 2013 C# iTextSharp Code using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using iTextSharp.text.pdf; using iTextSharp.text.pdf.parser; using iTextSharp.text; using System.IO; namespace EMTechnicalDieline { class Program ...
Read more

Using GIT(Bitbucket), Visual Studio Code

Concept of Git Git has two repositories; local and remote. Two different commands type to commit the changes; 1. commit/add: load/save changes to the local repository. 2. push/pull/clone: load/save changes from/to remote repository. How to setup remote git server , bitbucket , with Visual Studio Code To use git, I downloaded it from [git-scm](“ https://git-scm.com/downloads “) and installed with bash mode to keep the comparability for different platform. Set up remote repository * Create project from bitbucket. In this case, I created “blogmarkdown”. Remember the URL for the git repository. To find out the repository, just add “.git” at the end of the URL from bitbucket. For me, it will be “ https://alexjoh@bitbucket.org/alexjoh/blogmarkdown.git ” Link the remote with local folder * Create local folder. In my case, I created d:\gitrepo Initialize git local repo. Change the folder to the gitrepo and run git init If there are existing files from a remote git re...
Read more