Skip to content

Instantly share code, notes, and snippets.

View zapkub's full-sized avatar
🦄
Doing FINE !

Rungsikorn Rungsikavanich zapkub

🦄
Doing FINE !
View GitHub Profile
@zapkub
zapkub / todo-state.ts
Created November 15, 2018 04:44
Todo state
type TodoItem = {
title: string
completed: boolean
}
type TodoState = {
// ชนิดของ filter ที่ toggle อยู่
filter: "All" | "Active" | "Completed",
// Todo ทั้งหมด
@zapkub
zapkub / function-component-hook.jsx
Created November 14, 2018 15:52
put hook into function component
// NOW ( currently on alpha 14 nov 2018 ) THIS COMPONENT CAN HAVE STATE
const MyInputComponent ({ }) => {
const [value, setValue] = React.useState("put some default value here")
const onChange = (e) => setValue(e.value.target)
return (
<input value={value} onChange={onChange} />
)
}
@zapkub
zapkub / function-component-problem.jsx
Created November 14, 2018 15:47
function component state before hook
// THIS COMPONENT CANNOT HAVE STATE
const MyInputComponent ({ value, onChange }) => {
return (
<input value={value} onChange={onChange} />
)
}
@zapkub
zapkub / ssh-check-password-and-add-public-key.sh
Created November 5, 2018 13:31
Run command shell on remote server and check if password exists then add public key
## BK1 deployment script with SSH
if [ -z "$SSH_DEPLOYMENT_SERVER" ]
then
echo ERROR: please provide SSH_DEPLOYMENT_SERVER variable to deploy instance to server
exit 1
else
echo Deploy BK1 API server instance to $SSH_DEPLOYMENT_SERVER
fi
import gql from "graphql-tag"
import { ASTNode } from "graphql"
export function extractTypeFromSchema(
expectTypeName: string[],
schema?: ASTNode,
result: string[] = []
): string[] {
/**
* Implementation...
@zapkub
zapkub / pp.ts
Last active September 28, 2018 01:47
// OOP ?
class TheProblemSolver {
solve(problem: Problem){ }
}
const problemSolver = new TheProblemSolver()
problemSolver.solve(p)
// OR just pure functional if it pure
function solveProblem(problem: Problem) { }
@zapkub
zapkub / error
Created September 9, 2018 08:08
Started executing query at Line 1
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'PlantSeason_ID', table 'sam2.dbo.tb_opr_PlantSeason'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Total execution time: 00:00:00.007
@zapkub
zapkub / recreate-plant-table-with-zero-id.sql
Created September 8, 2018 06:22
แก้ ตาราง plant ให้เริ่ม id ด้วย 0 ได้
DROP TABLE tb_opr_plant;
CREATE TABLE [dbo].[tb_opr_Plant](
[Plant_ID] [int] IDENTITY(0,1) NOT NULL,
[Quota_ID] [int] NULL,
[Zone_ID] [int] NULL,
[Plant_No] [nvarchar](20) NULL,
[Plant_Name] [nvarchar](100) NULL,
[Plant_Moo] [int] NULL,
[Plant_Province] [nvarchar](150) NULL,
@zapkub
zapkub / fetchcontrolno.sql
Created September 7, 2018 15:56
// SQL เลข Control Number ล่าสุด
SELECT SUBSTRING(MAX(dbo.tb_opr_Control.Control_No), CHARINDEX('-', MAX(dbo.tb_opr_Control.Control_No)) + 1, 4) AS User_EmpCode, RIGHT(MAX(dbo.tb_opr_Control.Control_No), 4) AS MaxRunning,
dbo.tb_opr_Control.Control_Creator, dbo.tb_auth_User.User_ID
FROM dbo.tb_opr_Control LEFT OUTER JOIN
dbo.tb_auth_User ON dbo.tb_opr_Control.Control_Creator = dbo.tb_auth_User.User_Username
GROUP BY dbo.tb_opr_Control.Control_Creator, dbo.tb_auth_User.User_ID
export const REVIEW_HIGHLIGHT_QUERY = gql`
${BookHighlighReview.fragments.review}
query($bookId: MongoID!) {
reviews: bookReviewConnection(
filter: { bookId: $bookId }
first: 3
sort: CREATED_AT_DESC
) {
count
edges {