Skip to content

Instantly share code, notes, and snippets.

View pavankjadda's full-sized avatar
😀
Follow me on Twitter @pavankjadda

Pavan Kumar Jadda pavankjadda

😀
Follow me on Twitter @pavankjadda
View GitHub Profile
@pavankjadda
pavankjadda / Remove line break or new line from column in SQL Server.md
Last active July 9, 2021 18:02
Remove line break or new line from column in SQL Server

Use the followng query to replace line break or new lines from column in SQL Server.

Replace <TABLE_NAME> and <COLUMN_NAME> place holders with actual values

update <TABLE_NAME> set <COLUMN_NAME>=Replace(Replace(<COLUMN_NAME>,CHAR(10),''),CHAR(13),'');

@pavankjadda
pavankjadda / Authorization Guards with React Router Routes.md
Created August 6, 2021 17:01
Authorization Guards with React Router Routes
import {Route, Switch} from "react-router-dom";
import Home from "../components/home/Home";
import NotFound from "../components/core/404/NotFound";
import React from "react";
import Login from "../components/core/login/Login";
import Logout from "../components/core/logout/Logout";
import UnAuthorized from "../components/core/unauthorized/UnAuthorized";
import {AdminGuardedRoute} from "./AdminGuardedRoute";
import ManageAdGroup from "../components/admin/groups/ManageAdGroup";
@pavankjadda
pavankjadda / ReadOnlyAccessGuardedRoute.md
Created August 13, 2021 15:31
ReadOnly Access Guarded Route
import * as React from 'react';
import {Redirect, Route,} from 'react-router-dom';
import ReactIf from "../components/shared/ReactIf";
import useAuthService from "../hooks/useAuthService";

export function ReadOnlyAccessGuardedRoute(props: { component: any; path: string; isAuthorized: boolean, exact: boolean }): JSX.Element {
    const {component: Component, isAuthorized, ...rest} = props;
    const {isUserLoggedIn} = useAuthService();
    return (
@pavankjadda
pavankjadda / SysAdminGuardedRoute.md
Created August 13, 2021 15:41
Sys Admin Guarded Route
import * as React from 'react';
import {Redirect, Route,} from 'react-router-dom';
import ReactIf from "../components/shared/ReactIf";
import useAuthService from "../hooks/useAuthService";

export function AdminGuardedRoute(props: { component: any; path: string; isAuthorized: boolean, exact: boolean }): JSX.Element {
    const {component: Component, isAuthorized, ...rest} = props;
    const {isUserLoggedIn} = useAuthService();
@pavankjadda
pavankjadda / Test Npm package locally.md
Last active October 20, 2021 16:33
Test Npm package locally.md

Testing NPM packages locallly may not work always. Here are the steps that can be fixed

  1. Go to library directory and execute the following command to link the library to global NPM modules
$ npm link 
$ npm link
  1. Now go to project directory and use the linked package (twice)
$ npm link <package_name>
$ npm link 
@pavankjadda
pavankjadda / Spring Boot Repository layer unit Test.md
Created December 22, 2021 22:43
Spring Boot Repository layer unit Test.md
@ExtendWith(SpringExtension.class)
@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
@ContextConfiguration(classes = {MyApplication.class})
@ImportAutoConfiguration(RefreshAutoConfiguration.class)
@ActiveProfiles(value = "local")
class EmployeeRepositoryTest
{
	@Autowired
@pavankjadda
pavankjadda / Spring Boot Service layer unit Test.md
Created December 22, 2021 23:01
Spring Boot Service layer unit Test.md
@ExtendWith(SpringExtension.class)
@SpringBootTest(webEnvironment = RANDOM_PORT)
@ActiveProfiles(value = "local")
@AutoConfigureMockMvc
@TestInstance(TestInstance.Lifecycle.PER_CLASS)
class EmployeeServiceTest
{
	@Mock
	EmployeeRepository employeeRepository;
@pavankjadda
pavankjadda / Spring Boot Controller layer unit Test.md
Last active December 22, 2021 23:28
Spring Boot Controller layer unit Test
@SpringBootTest(webEnvironment = RANDOM_PORT)
@ContextConfiguration(classes = {PresApplication.class})
@WithUserDetails(value = "demo_user", userDetailsServiceBeanName = "customDbUserDetailsService")
@AutoConfigureMockMvc
@ActiveProfiles(value = "local")
class PersonControllerTest
{
	@Autowired
	private MockMvc mockMvc;
@pavankjadda
pavankjadda / Spring Boot Integration Test.md
Last active December 22, 2021 23:35
Spring Boot Integration Test

@ExtendWith(SpringExtension.class)
@SpringBootTest(webEnvironment = RANDOM_PORT)
@ActiveProfiles(value = "local")
@AutoConfigureMockMvc
@WithUserDetails(value = "jaddap2", userDetailsServiceBeanName = "customDbUserDetailsService")
@TestInstance(TestInstance.Lifecycle.PER_CLASS)
class PersonIntegrationTest
{
@pavankjadda
pavankjadda / Angular Multi Stage Dockerfile.md
Last active May 19, 2022 22:21
Angular Multi Stage Dockerfile
###### Install dependencies only when needed ######
FROM node:16-alpine AS builder
ARG CONFIGURATION='dev'

# Make /app as working directory
WORKDIR /app

# Copy package.json file
COPY package.json .