Programming « 어느용

현재 내가 설치한 vscode 확장들

그때 그때 사용하지 않는 것을 Disable 해서 쓴다.

Auto Rename Tag Bootstrap 4, Font awesome4, Font Awesome5 Free & Pro snippets Bootstrap 5 Snippets C/C++ C# C# Extensions CSS Peek Debugger for Chrome DotENV ES7 React/Redux/GraphQL/React-Native snippets Font Awesome Auto-complete & Preview Git History GitLens Git supercharged Go Highlight Matching Tag Html (C#) HTML […]

EF 내에 ForeignKey 구성에 따른 스키마 생성

ICollection 사용

public					ICollection<Student>		m_listLandSiteDataText		{ get; set; }

protected override void Up(MigrationBuilder migrationBuilder)
{
	migrationBuilder.AddColumn<int>(
		name: "CourseId",
		table: "Students",
		nullable: true);

	migrationBuilder.CreateIndex(
		name: "IX_Students_CourseId",
		table: "Students",
		column: "CourseId");

	migrationBuilder.AddForeignKey(
		name: "FK_Students_Courses_CourseId",
		table: "Students",
		column: "CourseId",
		principalTable: "Courses",
		principalColumn: "CourseId",
		onDelete: ReferentialAction.Restrict);
}

public ICollection<Student> m_listLandSiteDataText { get; set; }

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.AddColumn<int>(

table: "Students",

nullable: true);

migrationBuilder.CreateIndex(

table: "Students",

column: "CourseId");

migrationBuilder.AddForeignKey(

table: "Students",

column: "CourseId",

principalTable: "Courses",

principalColumn: "CourseId",

onDelete: ReferentialAction.Restrict);

}

Index와 ForeignKey 없이 생성

[ForeignKey("Course")]
public					int							CourseId					{ get; set; }

[ForeignKey("CourseId")]
public					int							CourseId					{ get; set; }

protected override void Up(MigrationBuilder migrationBuilder)
{
	migrationBuilder.AddColumn<int>(
		name: "CourseId",
		table: "Students",
		nullable: false,
		defaultValue: 0);
}

[ForeignKey("Course")]

public int CourseId { get; set; }

[ForeignKey("CourseId")]

public int CourseId { get; set; }

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.AddColumn<int>(

table: "Students",

nullable: false,

defaultValue: 0);

}

virtual 사용시

public					int							CourseId					{ get; set; }
[ForeignKey("CourseId")]
public	virtual			Course						m_mvLandSiteDataImage		{ get; set; }

protected override void Up(MigrationBuilder migrationBuilder)
{
	migrationBuilder.AddColumn<int>(
		name: "CourseId",
		table: "Students",
		nullable: false,
		defaultValue: 0);

	migrationBuilder.CreateIndex(
		name: "IX_Students_CourseId",
		table: "Students",
		column: "CourseId");

	migrationBuilder.AddForeignKey(
		name: "FK_Students_Courses_CourseId",
		table: "Students",
		column: "CourseId",
		principalTable: "Courses",
		principalColumn: "CourseId",
		onDelete: ReferentialAction.Cascade);
}

public int CourseId { get; set; }

[ForeignKey("CourseId")]

public virtual Course m_mvLandSiteDataImage { get; set; }

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.AddColumn<int>(

table: "Students",

nullable: false,

defaultValue: 0);

migrationBuilder.CreateIndex(

table: "Students",

column: "CourseId");

migrationBuilder.AddForeignKey(

table: "Students",

column: "CourseId",

principalTable: "Courses",

principalColumn: "CourseId",

onDelete: ReferentialAction.Cascade);

}

golang VSCode에 Debugging 환경 구축

vscode에 launch.json

{
	// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.
	// 기존 특성에 대한 설명을 보려면 가리킵니다.
	// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.
	"version": "0.2.0",
	"configurations": [
		{
			"name": "Launch Package geth",
			"type": "go",
			"request": "launch",
			"mode": "debug",
			"program": "${workspaceFolder}/cmd/geth/"    // main.go 가 있는 폴더 path
		}
	]
}

{

// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.

// 기존 특성에 대한 설명을 보려면 가리킵니다.

// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.

"version": "0.2.0",

"configurations": [

{

"name": "Launch Package geth",

"type": "go",

"request": "launch",

"mode": "debug",

"program": "${workspaceFolder}/cmd/geth/" // main.go 가 있는 폴더 path

}

]

}

NodeJs VSCode 에 Debugging 환경 구축

node를 실행

yarn start

1	yarn start

vscode에 launch.json

{
	// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.
	// 기존 특성에 대한 설명을 보려면 가리킵니다.
	// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.
	"version": "0.2.0",
	"configurations": [
		{
			"type": "chrome",
			"request": "launch",
			"name": "Launch Chrome against localhost",
			"url": "http://localhost:3000",
			"webRoot": "${workspaceFolder}/src"
		}
	]
}

{

// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.

// 기존 특성에 대한 설명을 보려면 가리킵니다.

// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.

"version": "0.2.0",

"configurations": [

{

"type": "chrome",

"request": "launch",

"name": "Launch Chrome against localhost",

"url": "http://localhost:3000",

"webRoot": "${workspaceFolder}/src"

}

]

}

NodeJs VSCode 에 Remote Debugging 환경 구축

터널링 구축

ssh -N -L 9221:localhost:9229 [remoteIP]

1	ssh -N -L 9221:localhost:9229 [remoteIP]

node를 inspection 모드로 변경 & 웹 서버 실행

node --inspect &
yarn start

1 2	node --inspect & yarn start

vscode에 launch.json

{
	// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.
	// 기존 특성에 대한 설명을 보려면 가리킵니다.
	// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.
	"version": "0.2.0",
	"configurations": [
		{
			"address": "localhost",
			"localRoot": "${workspaceFolder}",
			"name": "Attach to Remote",
			"port": 9229,
			"remoteRoot": "...",
			"request": "attach",
			"skipFiles": [
				"<node_internals>/**"
			],
			"type": "pwa-node"
		}
	]
}

{

// IntelliSense를 사용하여 가능한 특성에 대해 알아보세요.

// 기존 특성에 대한 설명을 보려면 가리킵니다.

// 자세한 내용을 보려면 https://go.microsoft.com/fwlink/?linkid=830387을(를) 방문하세요.

"version": "0.2.0",

"configurations": [

{

"address": "localhost",

"localRoot": "${workspaceFolder}",

"name": "Attach to Remote",

"port": 9229,

"remoteRoot": "...",

"request": "attach",

"skipFiles": [

"<node_internals>/**"

"type": "pwa-node"

}

]

}

Ubuntu 20.04 에 Bitcoin Core 설치

# Install Dependencies
# -----------------------------------------------------------------------------------------------------------
# Build requirements:
sudo apt install git build-essential libtool autotools-dev autoconf automake pkg-config bsdmainutils python3 libssl-dev libssl-dev

# Install required dependencies
sudo apt install libevent-dev libboost-system-dev libboost-filesystem-dev libboost-test-dev libboost-thread-dev

# Install the BerkeleyDB from Ubuntu repositories:
sudo apt install libdb-dev libdb++-dev libsqlite3-dev

# Optional: upnpc
sudo apt install libminiupnpc-dev

# Optional ZMQ:
sudo apt install libzmq3-dev

# For GUI:
sudo apt install libqt5gui5 libqt5core5a libqt5dbus5 qttools5-dev qttools5-dev-tools libprotobuf-dev protobuf-compiler

# For QR Code support
sudo apt install libqrencode-dev

# Install Bitcoin
# -----------------------------------------------------------------------------------------------------------
git clone https://github.com/bitcoin/bitcoin.git

# Move into project directory
cd bitcoin

# Config
# -----------------------------------------------------------------------------------------------------------
# Generate config script
./autogen.sh

# If debugging symbols not required, amend compile flags:
./configure --with-incompatible-bdb CXXFLAGS="-O2"

# ...lot's of checking...

# Make
# -----------------------------------------------------------------------------------------------------------
make

# Install - sudo is required to install binaries in /usr/local/bin
sudo make install

# Install Dependencies

# -----------------------------------------------------------------------------------------------------------

# Build requirements:

sudo apt install git build-essential libtool autotools-dev autoconf automake pkg-config bsdmainutils python3 libssl-dev libssl-dev

# Install required dependencies

sudo apt install libevent-dev libboost-system-dev libboost-filesystem-dev libboost-test-dev libboost-thread-dev

# Install the BerkeleyDB from Ubuntu repositories:

sudo apt install libdb-dev libdb++-dev libsqlite3-dev

# Optional: upnpc

sudo apt install libminiupnpc-dev

# Optional ZMQ:

sudo apt install libzmq3-dev

# For GUI:

sudo apt install libqt5gui5 libqt5core5a libqt5dbus5 qttools5-dev qttools5-dev-tools libprotobuf-dev protobuf-compiler

# For QR Code support

sudo apt install libqrencode-dev

# Install Bitcoin

# -----------------------------------------------------------------------------------------------------------

git clone https://github.com/bitcoin/bitcoin.git

# Move into project directory

cd bitcoin

# Config

# -----------------------------------------------------------------------------------------------------------

# Generate config script

./autogen.sh

# If debugging symbols not required, amend compile flags:

./configure --with-incompatible-bdb CXXFLAGS="-O2"

# ...lot's of checking...

# Make

# -----------------------------------------------------------------------------------------------------------

make

# Install - sudo is required to install binaries in /usr/local/bin

sudo make install

MSSQL History

SELECT
	db_name(st.dbid) DBName
	, object_schema_name(objectid, st.dbid) SchemaName
	, object_name(objectid, st.dbid) SPName
	, qs.total_elapsed_time
	, creation_time
	, last_execution_time
	, text
FROM
	sys.dm_exec_query_stats qs
CROSS APPLY
	sys.dm_exec_sql_text(qs.plan_handle)st
JOIN
	sys.dm_exec_cached_plans cp
ON
	qs.plan_handle = cp.plan_handle

SELECT

db_name(st.dbid) DBName

, object_schema_name(objectid, st.dbid) SchemaName

, object_name(objectid, st.dbid) SPName

, qs.total_elapsed_time

, creation_time

, last_execution_time

, text

FROM

sys.dm_exec_query_stats qs

CROSS APPLY

sys.dm_exec_sql_text(qs.plan_handle)st

JOIN

sys.dm_exec_cached_plans cp

qs.plan_handle = cp.plan_handle

통계용 쿼리 샘플

select year as '년', month as '월', count(*) as count
from (
	select
		YEAR(us.fd_dtcreate) as 'year',
		MONTH(us.fd_dtcreate)  as 'month'
	from tb_ykfile as us
	where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01'
) tb
group by year, month
order by year, month
;

select year as '년', month as '월', count(*) as count

from (

select

YEAR(us.fd_dtcreate) as 'year',

MONTH(us.fd_dtcreate) as 'month'

from tb_ykfile as us

where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01'

) tb

group by year, month

order by year, month

;

SELECT    CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt
          ,Isnull(b.count, 0)                            AS count
FROM      master..spt_values a 
LEFT JOIN 
          ( 
                   SELECT   count(*)                    AS count, 
                            CONVERT(CHAR(10), b1.fd_dtcreate,120) AS fd_dtcreate
                   FROM     tb_ykfile b1 WITH(nolock) 
                   GROUP BY CONVERT(CHAR(10), b1.fd_dtcreate, 120)
		 ) b 
ON        CONVERT(CHAR(10), Dateadd(d, a.number,'2020-08-01 00:00:00'), 120) = b.fd_dtcreate 
WHERE TYPE = 'P' AND CONVERT(CHAR(10), DATEADD(D, NUMBER, '2020-08-01'), 120) <= '2022-01-01'
order by dt
;

SELECT CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt

,Isnull(b.count, 0) AS count

FROM master..spt_values a

LEFT JOIN

(

SELECT count(*) AS count,

CONVERT(CHAR(10), b1.fd_dtcreate,120) AS fd_dtcreate

FROM tb_ykfile b1 WITH(nolock)

GROUP BY CONVERT(CHAR(10), b1.fd_dtcreate, 120)

) b

ON CONVERT(CHAR(10), Dateadd(d, a.number,'2020-08-01 00:00:00'), 120) = b.fd_dtcreate

WHERE TYPE = 'P' AND CONVERT(CHAR(10), DATEADD(D, NUMBER, '2020-08-01'), 120) <= '2022-01-01'

order by dt

;

MSSQL Paging

          SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *
          FROM [tb_Service] AS [t]
          WHERE 1=1
          ORDER BY [fd_nIdService] DESC
          OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

SELECT row_number() OVER(ORDER BY fd_nIdService DESC) AS PagedNumber, *

FROM [tb_Service] AS [t]

WHERE 1=1

ORDER BY [fd_nIdService] DESC

OFFSET ((2 - 1) * 10) ROWS FETCH NEXT 10 ROWS ONLY

Web에서 Proxy를 쓰는 사용자 Real IP 구하기

<?php 
 function getRealIpAddr(){ 
    if(!empty($_SERVER['HTTP_CLIENT_IP']) && getenv('HTTP_CLIENT_IP')){ 
        return $_SERVER['HTTP_CLIENT_IP']; 
    }
    elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR']) && getenv('HTTP_X_FORWARDED_FOR')){ 
        return $_SERVER['HTTP_X_FORWARDED_FOR']; 
    }
    elseif(!empty($_SERVER['REMOTE_HOST']) && getenv('REMOTE_HOST')){ 
        return $_SERVER['REMOTE_HOST']; 
    }
    elseif(!empty($_SERVER['REMOTE_ADDR']) && getenv('REMOTE_ADDR')){ 
        return $_SERVER['REMOTE_ADDR']; 
    } 
    return false; 
 }


 if($ip = getRealIpAddr()){
     echo $ip;
 }
 ?>

<?php

function getRealIpAddr(){

if(!empty($_SERVER['HTTP_CLIENT_IP']) && getenv('HTTP_CLIENT_IP')){

return $_SERVER['HTTP_CLIENT_IP'];

}

elseif(!empty($_SERVER['HTTP_X_FORWARDED_FOR']) && getenv('HTTP_X_FORWARDED_FOR')){

return $_SERVER['HTTP_X_FORWARDED_FOR'];

}

elseif(!empty($_SERVER['REMOTE_HOST']) && getenv('REMOTE_HOST')){

return $_SERVER['REMOTE_HOST'];

}

elseif(!empty($_SERVER['REMOTE_ADDR']) && getenv('REMOTE_ADDR')){

return $_SERVER['REMOTE_ADDR'];

}

return false;

}

if($ip = getRealIpAddr()){

echo $ip;

}

어느용

참고자료

보관함

현재 내가 설치한 vscode 확장들

EF 내에 ForeignKey 구성에 따른 스키마 생성

golang VSCode에 Debugging 환경 구축

NodeJs VSCode 에 Debugging 환경 구축

NodeJs VSCode 에 Remote Debugging 환경 구축

Ubuntu 20.04 에 Bitcoin Core 설치

MSSQL History

통계용 쿼리 샘플

MSSQL Paging

Web에서 Proxy를 쓰는 사용자 Real IP 구하기

메타

최신 글

참고자료

보관함

메타

최신 글

태그