Category Archives: 미분류

IP 국가 리스트 편하기 검색하기


USE [ipv]
GO

/****** Object:  Table [dbo].[ipv4_KR]    Script Date: 2020-05-18 오후 5:12:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ipv4_KR](
	[IDX] [int] NOT NULL,
	[Standard_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Standard_Date]  DEFAULT (''),
	[Cuntry_Code] [varchar](10) NOT NULL CONSTRAINT [DF_ipv4_KR_Cuntry_Code]  DEFAULT (''),
	[Start_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP_Number]  DEFAULT ((0)),
	[End_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP_Number]  DEFAULT ((0)),
	[Start_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP]  DEFAULT (''),
	[End_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP]  DEFAULT (''),
	[PREFIX] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_PREFIX]  DEFAULT (''),
	[Regi_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Regi_Date]  DEFAULT (''),
 CONSTRAINT [PK_ipv4_KR] PRIMARY KEY CLUSTERED 
(
	[IDX] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [ipv]

/****** Object: Table [dbo].[ipv4_KR] Script Date: 2020-05-18 오후 5:12:30 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

CREATE TABLE [dbo].[ipv4_KR](

[IDX] [int] NOT NULL,

[Standard_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Standard_Date] DEFAULT (''),

[Cuntry_Code] [varchar](10) NOT NULL CONSTRAINT [DF_ipv4_KR_Cuntry_Code] DEFAULT (''),

[Start_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP_Number] DEFAULT ((0)),

[End_IP_Number] [float] NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP_Number] DEFAULT ((0)),

[Start_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Start_IP] DEFAULT (''),

[End_IP] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_End_IP] DEFAULT (''),

[PREFIX] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_PREFIX] DEFAULT (''),

[Regi_Date] [varchar](20) NOT NULL CONSTRAINT [DF_ipv4_KR_Regi_Date] DEFAULT (''),

CONSTRAINT [PK_ipv4_KR] PRIMARY KEY CLUSTERED

(

[IDX] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

SET ANSI_PADDING OFF


-----------------------------------------------------------------------------------------------------------  
--  Split 유형의 함수  
--  문자열에서 구분자(@iSeparator)로 몇번째 단어 가져오기  
--  예: SELECT 데이터베이스명.소유자명.fn_GetIdxDataLikeSplit('가-나-다',2,'-') --> '나'  
-----------------------------------------------------------------------------------------------------------  
-----------------------------------------------------------------------------------------------------------  
-- 프로시저 생성  
-----------------------------------------------------------------------------------------------------------  
Alter  FUNCTION  [dbo].[fn_GetIdxDataLikeSplit]   
    (  
        @iText          VARCHAR(200),  
        @idx                INT,  
        @iSeparator     VARCHAR(10) = '.'  
    )  
RETURNS  VARCHAR(200)   
AS  
BEGIN  
    DECLARE @wData          VARCHAR(200)  
    DECLARE @wText          VARCHAR(200)  
    DECLARE @wSeparator VARCHAR(10)  
    DECLARE @wNum           INT  
  
    SET @wData          = ''  
    SET @wNum           = 1;  
    SET @wSeparator = LTRIM(RTRIM(@iSeparator));  
    SET @wText          = LTRIM(RTRIM(@iText)) + @wSeparator;   
  
    IF CHARINDEX(@wSeparator, @iText) > 0  
    BEGIN  
        WHILE    @idx >= @wNum  
        BEGIN  
            IF CHARINDEX(@wSeparator, @wText) > 0  
            BEGIN  
                   -- 문자열의 인덱스 위치의 요소를 반환  
                   SET @wData   = SUBSTRING(@wText, 1, CHARINDEX(@wSeparator, @wText) - 1);  
                   SET @wData   = LTRIM(RTRIM(@wData));  
  
                -- 반환된 문자는 버린후 좌우공백 제거     
                    SET @wText  = LTRIM(RTRIM(RIGHT(@wText, LEN(@wText) - (LEN(@wData) + LEN(@iSeparator)))))  
            END   
            ELSE  
            BEGIN  
                    SET @wData  = ''  
            END  
            SET @wNum = @wNum + 1  
        END  
    END  
    ELSE  
    BEGIN  
        SET @wData  = @iText  
    END  
      -- HEO ADd
    if Len(@wData) =1
	    begin Set @wData =  '00' + @wData   end  
	else if(Len(@wData) =2)
	    begin Set @wData =  '0' + @wData   end  
	  
    RETURN(@wData)  
      
END

-----------------------------------------------------------------------------------------------------------

-- Split 유형의 함수

-- 문자열에서 구분자(@iSeparator)로 몇번째 단어 가져오기

-- 예: SELECT 데이터베이스명.소유자명.fn_GetIdxDataLikeSplit('가-나-다',2,'-') --> '나'

-----------------------------------------------------------------------------------------------------------

-- 프로시저 생성

-----------------------------------------------------------------------------------------------------------

Alter FUNCTION [dbo].[fn_GetIdxDataLikeSplit]

(

@iText VARCHAR(200),

@idx INT,

@iSeparator VARCHAR(10) = '.'

)

RETURNS VARCHAR(200)

BEGIN

DECLARE @wData VARCHAR(200)

DECLARE @wText VARCHAR(200)

DECLARE @wSeparator VARCHAR(10)

DECLARE @wNum INT

SET @wData = ''

SET @wNum = 1;

SET @wSeparator = LTRIM(RTRIM(@iSeparator));

SET @wText = LTRIM(RTRIM(@iText)) + @wSeparator;

IF CHARINDEX(@wSeparator, @iText) > 0

BEGIN

WHILE @idx >= @wNum

BEGIN

IF CHARINDEX(@wSeparator, @wText) > 0

BEGIN

-- 문자열의 인덱스 위치의 요소를 반환

SET @wData = SUBSTRING(@wText, 1, CHARINDEX(@wSeparator, @wText) - 1);

SET @wData = LTRIM(RTRIM(@wData));

-- 반환된 문자는 버린후 좌우공백 제거

SET @wText = LTRIM(RTRIM(RIGHT(@wText, LEN(@wText) - (LEN(@wData) + LEN(@iSeparator)))))

END

ELSE

BEGIN

SET @wData = ''

END

SET @wNum = @wNum + 1

END

ELSE

BEGIN

SET @wData = @iText

END

-- HEO ADd

if Len(@wData) =1

begin Set @wData = '00' + @wData end

else if(Len(@wData) =2)

begin Set @wData = '0' + @wData end

RETURN(@wData)

END


Declare @IDX int
Declare @Start_IP varchar(20), @End_IP varchar(20)

Declare @Start_IP_01 varchar(3),@Start_IP_02 varchar(3),@Start_IP_03 varchar(3),@Start_IP_04 varchar(3)
Declare @End_IP_01 varchar(3),@End_IP_02 varchar(3),@End_IP_03 varchar(3),@End_IP_04 varchar(3)
 
Declare con_cursor cursor for SELECT IDX, Start_IP, End_IP  FROM [IBE_Basic_Code].[dbo].[ipv4_KR] 
	open con_cursor --커스를 연다.
	fetch next from con_cursor into @IDX, @Start_IP, @End_IP
	while (@@fetch_status <>-1)
		begin
		if (@@fetch_status = -2)
		continue
			begin

			   Set @Start_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,1,'.')
			   Set @Start_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,2,'.')
			   Set @Start_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,3,'.')
			   Set @Start_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,4,'.')
			   
			   Set @End_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,1,'.')
			   Set @End_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,2,'.')
			   Set @End_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,3,'.')
			   Set @End_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,4,'.')


			   update [IBE_Basic_Code].[dbo].[ipv4_KR] set Start_IP_Number = CONVERT(numeric, @Start_IP_01 +  @Start_IP_02 + @Start_IP_03 + @Start_IP_04)
														  ,End_IP_Number = CONVERT(numeric, @End_IP_01 +  @End_IP_02 + @End_IP_03 + @End_IP_04)
			   where IDX = @IDX



			   
			end
		fetch next from con_cursor into @IDX, @Start_IP, @End_IP
		end
	close con_cursor
Deallocate con_cursor

Declare @IDX int

Declare @Start_IP varchar(20), @End_IP varchar(20)

Declare @Start_IP_01 varchar(3),@Start_IP_02 varchar(3),@Start_IP_03 varchar(3),@Start_IP_04 varchar(3)

Declare @End_IP_01 varchar(3),@End_IP_02 varchar(3),@End_IP_03 varchar(3),@End_IP_04 varchar(3)

Declare con_cursor cursor for SELECT IDX, Start_IP, End_IP FROM [IBE_Basic_Code].[dbo].[ipv4_KR]

open con_cursor --커스를 연다.

fetch next from con_cursor into @IDX, @Start_IP, @End_IP

while (@@fetch_status <>-1)

begin

if (@@fetch_status = -2)

continue

begin

Set @Start_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,1,'.')

Set @Start_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,2,'.')

Set @Start_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,3,'.')

Set @Start_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@Start_IP,4,'.')

Set @End_IP_01 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,1,'.')

Set @End_IP_02 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,2,'.')

Set @End_IP_03 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,3,'.')

Set @End_IP_04 = [dbo].[fn_GetIdxDataLikeSplit](@End_IP,4,'.')

update [IBE_Basic_Code].[dbo].[ipv4_KR] set Start_IP_Number = CONVERT(numeric, @Start_IP_01 + @Start_IP_02 + @Start_IP_03 + @Start_IP_04)

,End_IP_Number = CONVERT(numeric, @End_IP_01 + @End_IP_02 + @End_IP_03 + @End_IP_04)

where IDX = @IDX

end

fetch next from con_cursor into @IDX, @Start_IP, @End_IP

end

close con_cursor

Deallocate con_cursor

[tp_cheapest_flights_shortcodes origin=SEL destination=LAX title=”항공권” paginate=true subid=”” currency=”KRW”]

[regular] Seg start

https://regex101.com/r/i88gXH/2/


NEUTRAL*         02JAN-WE-0001  ICNNRT(SELTYO)** ** *WLP 
ICN ALTERNATE GMP/NRT ALTERNATE HND
1  #H15906 Y4 B4 H4 M4 N. Q. V. O. ICNNRT 0700 0925      737 0E
        G. R.
    H15906 OPERATED BY T WAY AIR 
2  $7C1100 Y4 B4 K. N. Q. M. T. W. ICNNRT 0725 0950      737 0E
        O. R. X. S. L. H. E- J- F- V- G. Z. D- C- A. I- P- U.
3  #H19764 Y4 B4 H. M. Q. V. X. O. ICNNRT 0725 0950      737 0E
        G. R. U. T.
    H19764 OPERATED BY JEJU AIR CO LTD 
4*S#KE5741 Y7 B7 M7 S. H. E. K. L. ICNNRT 0730 1000      738 0E
        U. Q.
    KE5741 OPERATED BY JIN AIR 
>

NEUTRAL* 02JAN-WE-0001 ICNNRT(SELTYO)** ** *WLP

ICN ALTERNATE GMP/NRT ALTERNATE HND

1 #H15906 Y4 B4 H4 M4 N. Q. V. O. ICNNRT 0700 0925 737 0E

G. R.

H15906 OPERATED BY T WAY AIR

2 $7C1100 Y4 B4 K. N. Q. M. T. W. ICNNRT 0725 0950 737 0E

O. R. X. S. L. H. E- J- F- V- G. Z. D- C- A. I- P- U.

3 #H19764 Y4 B4 H. M. Q. V. X. O. ICNNRT 0725 0950 737 0E

G. R. U. T.

H19764 OPERATED BY JEJU AIR CO LTD

4*S#KE5741 Y7 B7 M7 S. H. E. K. L. ICNNRT 0730 1000 738 0E

U. Q.

KE5741 OPERATED BY JIN AIR


/^[1-9]\s{0,2}?(\*S|[#$])/mg

/^[1-9]\s{0,2}?(\*S|[#$])/mg


Match 1
Full match	94-98	`1  #`
Group 1.	97-98	`#`
Match 2
Full match	206-210	`2  $`
Group 1.	209-210	`$`
Match 3
Full match	332-336	`3  #`
Group 1.	335-336	`#`
Match 4
Full match	456-459	`4*S`
Group 1.	457-459	`*S`

Match 1

Full match 94-98 `1 #`

Group 1. 97-98 `#`

Match 2

Full match 206-210 `2 $`

Group 1. 209-210 `$`

Match 3

Full match 332-336 `3 #`

Group 1. 335-336 `#`

Match 4

Full match 456-459 `4*S`

Group 1. 457-459 `*S`

SeatCount https://regex101.com/r/i88gXH/3


[A-Z]([0-9]{1}|[.-])\s{1}

[A-Z]([0-9]{1}|[.-])\s{1}

참고 : https://regex101.com/r/z2cD9W/1 https://regex101.com/r/zMulAd/1

snake.py


import pygame, random, sys
from pygame.locals import *

def collide(x1, x2, y1, y2, w1, w2, h1, h2):
    if x1+w1>x2 and x1<x2+w2 and y1+h1>y2 and y1<y2+h2:return True
	else:return False
	
def die(screen, score):
	f=pygame.font.SysFont('Arial', 30);
	t=f.render('Your score was: '+str(score), True, (0, 0, 0));
	screen.blit(t, (10, 270));pygame.display.update();
	pygame.time.wait(2000);sys.exit(0)
xs = [290, 290, 290, 290, 290];ys = [290, 270, 250, 230, 210];
dirs = 0;
score = 0;
applepos = (random.randint(0, 590), random.randint(0, 590));
pygame.init();
s=pygame.display.set_mode((600, 600));
pygame.display.set_caption('Snake');
appleimage = pygame.Surface((10, 10));
appleimage.fill((0, 255, 0));
img = pygame.Surface((20, 20));
img.fill((255, 0, 0));f = pygame.font.SysFont('Arial', 20);clock = pygame.time.Clock()

while True:
	clock.tick(10)
	for e in pygame.event.get():
		if e.type == QUIT:
			sys.exit(0)
		elif e.type == KEYDOWN:
			if e.key == K_UP and dirs != 0:dirs = 2
			elif e.key == K_DOWN and dirs != 2:dirs = 0
			elif e.key == K_LEFT and dirs != 1:dirs = 3
			elif e.key == K_RIGHT and dirs != 3:dirs = 1
	i = len(xs)-1
	while i >= 2:
		if collide(xs[0], xs[i], ys[0], ys[i], 20, 20, 20, 20):die(s, score)
		i-= 1
	if collide(xs[0], applepos[0], ys[0], applepos[1], 20, 10, 20, 10):score+=1;xs.append(700);ys.append(700);applepos=(random.randint(0,590),random.randint(0,590))
	if xs[0] < 0 or xs[0] > 580 or ys[0] < 0 or ys[0] > 580: die(s, score)
	i = len(xs)-1
	while i >= 1:
		xs[i] = xs[i-1];ys[i] = ys[i-1];i -= 1
	if dirs==0:ys[0] += 20
	elif dirs==1:xs[0] += 20
	elif dirs==2:ys[0] -= 20
	elif dirs==3:xs[0] -= 20	
	s.fill((255, 255, 255))	
	for i in range(0, len(xs)):
		s.blit(img, (xs[i], ys[i]))
		s.blit(appleimage, applepos);
		t=f.render(str(score), True, (0, 0, 0));
		s.blit(t, (10, 10));
		pygame.display.update()

import pygame, random, sys

from pygame.locals import *

def collide(x1, x2, y1, y2, w1, w2, h1, h2):

if x1+w1>x2 and x1<x2+w2 and y1+h1>y2 and y1<y2+h2:return True

else:return False

def die(screen, score):

f=pygame.font.SysFont('Arial', 30);

t=f.render('Your score was: '+str(score), True, (0, 0, 0));

screen.blit(t, (10, 270));pygame.display.update();

pygame.time.wait(2000);sys.exit(0)

xs = [290, 290, 290, 290, 290];ys = [290, 270, 250, 230, 210];

dirs = 0;

score = 0;

applepos = (random.randint(0, 590), random.randint(0, 590));

pygame.init();

s=pygame.display.set_mode((600, 600));

pygame.display.set_caption('Snake');

appleimage = pygame.Surface((10, 10));

appleimage.fill((0, 255, 0));

img = pygame.Surface((20, 20));

img.fill((255, 0, 0));f = pygame.font.SysFont('Arial', 20);clock = pygame.time.Clock()

while True:

clock.tick(10)

for e in pygame.event.get():

if e.type == QUIT:

sys.exit(0)

elif e.type == KEYDOWN:

if e.key == K_UP and dirs != 0:dirs = 2

elif e.key == K_DOWN and dirs != 2:dirs = 0

elif e.key == K_LEFT and dirs != 1:dirs = 3

elif e.key == K_RIGHT and dirs != 3:dirs = 1

i = len(xs)-1

while i >= 2:

if collide(xs[0], xs[i], ys[0], ys[i], 20, 20, 20, 20):die(s, score)

i-= 1

if collide(xs[0], applepos[0], ys[0], applepos[1], 20, 10, 20, 10):score+=1;xs.append(700);ys.append(700);applepos=(random.randint(0,590),random.randint(0,590))

if xs[0] < 0 or xs[0] > 580 or ys[0] < 0 or ys[0] > 580: die(s, score)

i = len(xs)-1

while i >= 1:

xs[i] = xs[i-1];ys[i] = ys[i-1];i -= 1

if dirs==0:ys[0] += 20

elif dirs==1:xs[0] += 20

elif dirs==2:ys[0] -= 20

elif dirs==3:xs[0] -= 20

s.fill((255, 255, 255))

for i in range(0, len(xs)):

s.blit(img, (xs[i], ys[i]))

s.blit(appleimage, applepos);

t=f.render(str(score), True, (0, 0, 0));

s.blit(t, (10, 10));

pygame.display.update()

문명의 하루 아침에 이루어 지지 않은 것 처럼 윈도우즈도 역사가 존재 한다. 윈도우즈의 역사를 이해 하면 윈도우즈?API를 공부하는데 도움이 될 것이다. 윈도우즈는 마이크로소프트(Microsoft)사에서 83년 11월 개발을 시작하여 2년후 85년 11월에 첫 버전을 발표하였다. 윈도주의 이전에 시장을 장악하던 IBM의 MS-DOS에 비해 그래픽 기반 운영체제(GUI)로 휠씬 사용하기가 쉬웠다.

Category Archives: 미분류

IP 국가 리스트 편하기 검색하기

[regular] Seg start

사이트

snake.py

Site.master 소스

윈도우의 역사