Programming « 어느용

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;

}

media query Size

부트스트랩의 그리드 class
 .col-xl- (초대형 장치)
 .col-lg- (대형 장치 - 화면 너비가 1200 px 미만)
 .col-md- (중간 크기 장치 - 화면 너비가 992px 미만)
 .col-sm- (소형 장치 - 화면 너비가 768px 미만)
 .col- (소형 장치 - 화면 너비가 576px 미만)
 .col (기본값 - 자동으로 반응)

부트스트랩의 그리드 class

.col-xl- (초대형 장치)

.col-lg- (대형 장치 - 화면 너비가 1200 px 미만)

.col-md- (중간 크기 장치 - 화면 너비가 992px 미만)

.col-sm- (소형 장치 - 화면 너비가 768px 미만)

.col- (소형 장치 - 화면 너비가 576px 미만)

.col (기본값 - 자동으로 반응)

기본 - 데스크탑

@media (min-width: 1281px)
- 랩탑, 데스크탑

@media (min-width: 1025px)
- 태블릿, 아이패드 (세로)

@media (min-width: 768px)
- 태블릿, 아이패드 (가로)

@media (min-width: 481px)
- 저해상도 태블릿, 모바일 (가로)

@media (min-width: 320px) 
- 대부분의 스마트폰 모바일 기기 (세로)

기본 - 데스크탑

@media (min-width: 1281px)

- 랩탑, 데스크탑

@media (min-width: 1025px)

- 태블릿, 아이패드 (세로)

@media (min-width: 768px)

- 태블릿, 아이패드 (가로)

@media (min-width: 481px)

- 저해상도 태블릿, 모바일 (가로)

@media (min-width: 320px)

- 대부분의 스마트폰 모바일 기기 (세로)

/* Smartphones (portrait and landscape) ----------- */
@media only screen and (min-device-width : 320px) and (max-device-width : 480px) {
/* Styles */
}

/* Smartphones (landscape) ----------- */
@media only screen and (min-width : 321px) {
/* Styles */
}

/* Smartphones (portrait) ----------- */
@media only screen and (max-width : 320px) {
/* Styles */
}

/* iPads (portrait and landscape) ----------- */
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) {
/* Styles */
}

/* iPads (landscape) ----------- */
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) {
/* Styles */
}

/* iPads (portrait) ----------- */
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) {
/* Styles */
}
/**********
iPad 3
**********/
@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}
/* Desktops and laptops ----------- */
@media only screen  and (min-width : 1224px) {
/* Styles */
}

/* Large screens ----------- */
@media only screen  and (min-width : 1824px) {
/* Styles */
}

/* iPhone 4 ----------- */
@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {
/* Styles */
}

/* iPhone 5 ----------- */
@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* iPhone 6, 7, 8 ----------- */
@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* iPhone 6+, 7+, 8+ ----------- */
@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* iPhone X ----------- */
@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

/* iPhone XS Max, XR ----------- */
@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

/* Samsung Galaxy S3 ----------- */
@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){
/* Styles */
}

/* Samsung Galaxy S4 ----------- */
@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

/* Samsung Galaxy S5 ----------- */
@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){
/* Styles */
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

/* Smartphones (portrait and landscape) ----------- */

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) {

/* Styles */

}

/* Smartphones (landscape) ----------- */

@media only screen and (min-width : 321px) {

/* Styles */

}

/* Smartphones (portrait) ----------- */

@media only screen and (max-width : 320px) {

/* Styles */

}

/* iPads (portrait and landscape) ----------- */

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) {

/* Styles */

}

/* iPads (landscape) ----------- */

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) {

/* Styles */

}

/* iPads (portrait) ----------- */

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) {

/* Styles */

}

/**********

iPad 3

**********/

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

@media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

/* Desktops and laptops ----------- */

@media only screen and (min-width : 1224px) {

/* Styles */

}

/* Large screens ----------- */

@media only screen and (min-width : 1824px) {

/* Styles */

}

/* iPhone 4 ----------- */

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : landscape) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

@media only screen and (min-device-width : 320px) and (max-device-width : 480px) and (orientation : portrait) and (-webkit-min-device-pixel-ratio : 2) {

/* Styles */

}

/* iPhone 5 ----------- */

@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 320px) and (max-device-height: 568px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* iPhone 6, 7, 8 ----------- */

@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 375px) and (max-device-height: 667px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* iPhone 6+, 7+, 8+ ----------- */

@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 414px) and (max-device-height: 736px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* iPhone X ----------- */

@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 375px) and (max-device-height: 812px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

/* iPhone XS Max, XR ----------- */

@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 414px) and (max-device-height: 896px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

/* Samsung Galaxy S3 ----------- */

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 2){

/* Styles */

}

/* Samsung Galaxy S4 ----------- */

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 320px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

/* Samsung Galaxy S5 ----------- */

@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : landscape) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

@media only screen and (min-device-width: 360px) and (max-device-height: 640px) and (orientation : portrait) and (-webkit-device-pixel-ratio: 3){

/* Styles */

}

어느용

참고자료

보관함

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 구하기

media query Size

메타

최신 글

참고자료

보관함

메타

최신 글

태그