Skip to content

Instantly share code, notes, and snippets.

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

Rungsikorn Rungsikavarnich zapkub

🦄
Doing FINE !
View GitHub Profile
@zapkub
zapkub / client.js
Created January 21, 2018 06:57
http stream with nodejs express
// on client request
const xhr = new XMLHttpRequest()
// request to api endpoint
xhr.open('post', '/documents.zip')
xhr.setRequestHeader('Content-Type', 'application/json;charset=UTF-8')
xhr.onprogress = () => {
// receive stream
console.log('PROGRESS:', xhr.responseText)
import * as React from 'react'
import { graphql } from 'react-apollo'
import gql from 'graphql-tag'
const USER_INFOMATION_QUERY = gql`
query {
user {
_id
email
export function graphql<
TProps extends TGraphQLVariables | {} = {},
TData = {},
TGraphQLVariables = {},
TChildProps = Partial<DataProps<TData, TGraphQLVariables>> &
Partial<MutateProps<TData, TGraphQLVariables>>
>(
document: DocumentNode,
operationOptions: OperationOption<TProps, TData, TGraphQLVariables, TChildProps> = {},
import { USER_INFOMATION_QUERY, USER_NOTIFICATION_QUERY, USER_INFOMATION_MUTATION } from './user.graphql'
import { graphql, compose } from 'react-apollo'
import UserInfomationComponent from './user.component'
// need to defined shape of
// prop types from enhanced component
type UserInfomationContainerPropTypes = {
userId: string
import { USER_INFOMATION_QUERY, USER_NOTIFICATION_QUERY, USER_INFOMATION_MUTATION } from './user.graphql'
import { graphql, compose } from 'react-apollo'
import UserInfomationComponent from './user.component'
// need to defined shape of
// prop types from enhanced component
type UserInfomationContainerPropTypes = {
userId: string
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 {
@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
@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 / 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 / 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) { }