| ICollection 사용 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | 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); } |
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); } |
virtual 사용시 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | 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); } |
| { // 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": [ { "type": "chrome", "request": "launch", "name": "Launch Chrome against localhost", "url": "http://localhost:3000", "webRoot": "${workspaceFolder}/src" } ] } |
| ssh -N -L 9221:localhost:9229 [remoteIP] |
- node를 inspection 모드로 변경 & 웹 서버 실행
| node --inspect & yarn start |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | { // 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" } ] } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 | # 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 |
| upstream myserver { # 기본 round robin server localhost:3001; server localhost:3002; } server { listen 8080; listen [::]:8080; location / { proxy_pass http://myserver; } } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | apt install build-essential apt install net-tools apt install openssh-server systemctl enable ssh systemctl restart ssh apt install curl apt install tmux apt install mc apt install git apt install zsh sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)" chsh -s /usr/bin/zsh # logout 필요 zsh # 일단 한번 실행 git clone https://github.com/zsh-users/zsh-autosuggestions.git $ZSH_CUSTOM/plugins/zsh-autosuggestions git clone https://github.com/zsh-users/zsh-syntax-highlighting.git $ZSH_CUSTOM/plugins/zsh-syntax-highlighting vi .zshrc d2coding 설치 apt install neovim curl -sLf https://spacevim.org/install.sh | bash vi vi init.vim vi init.toml curl -fLo ~/.vim/autoload/plug.vim --create-dirs https://raw.githubusercontent.com/junegunn/vim-plug/master/plug.vim vi # 실행후 :PlugInstall cd ./vim/bundle/vimproc.vim make apt install nodejs apt install npm npm install jshint |
.zshrc 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | # Set name of the theme to load --- if set to "random", it will # load a random theme each time oh-my-zsh is loaded, in which case, # to know which specific one was loaded, run: echo $RANDOM_THEME # See https://github.com/ohmyzsh/ohmyzsh/wiki/Themes ZSH_THEME="agnoster" # Uncomment the following line if you want to change the command execution time # stamp shown in the history command output. # You can set one of the optional three formats: # "mm/dd/yyyy"|"dd.mm.yyyy"|"yyyy-mm-dd" # or set a custom format using the strftime function format specifications, # see 'man strftime' for details. # HIST_STAMPS="mm/dd/yyyy" export HISTSIZE=10000 export SAVEHIST=10000 setopt EXTENDED_HISTORY # Which plugins would you like to load? # Standard plugins can be found in $ZSH/plugins/ # Custom plugins may be added to $ZSH_CUSTOM/plugins/ # Example format: plugins=(rails git textmate ruby lighthouse) # Add wisely, as too many plugins slow down shell startup. plugins=( git zsh-syntax-highlighting zsh-autosuggestions tmux colored-man-pages colorize svn ) |
./.SpaceVim/init.vim 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | "============================================================================= " init.vim --- Entry file for neovim " Copyright (c) 2016-2020 Wang Shidong & Contributors " Author: Wang Shidong < wsdjeg@outlook.com > " URL: https://spacevim.org " License: GPLv3 "============================================================================= call plug#begin("~/.vim/plugged") Plug 'vim-airline/vim-airline' " vim status bar Plug 'airblade/vim-gitgutter' " Show git status in vim Plug 'iamcco/markdown-preview.nvim' call plug#end() execute 'source' fnamemodify(expand('<sfile>'), ':h').'/main.vim' filetype plugin on set vb set nu set nuw=5 " 줄 번호 표시 너비 set backspace=eol,start,indent " 편집 기능 설정 set sol set sm " 검색 기능 설정 set hlsearch set ignorecase set showmatch " indent 설정 set cindent set autoindent set smartindent set tabstop=4 set shiftwidth=4 set softtabstop=4 set noet " 탭 -> 공백 변환기능 no " Turn off swap set noswapfile set nobackup set nowb set whichwrap+=<,>,h,l,[,] |
./.SpaceVim.d/init.toml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | #============================================================================= # basic.toml --- basic configuration example for SpaceVim # Copyright (c) 2016-2020 Wang Shidong & Contributors # Author: Wang Shidong < wsdjeg at 163.com > # URL: https://spacevim.org # License: GPLv3 #============================================================================= # All SpaceVim option below [option] section [options] # set spacevim theme. by default colorscheme layer is not loaded, # if you want to use more colorscheme, please load the colorscheme # layer colorscheme = "onedark" colorscheme_bg = "dark" # Disable guicolors in basic mode, many terminal do not support 24bit # true colors enable_guicolors = false # Disable statusline separator, if you want to use other value, please # install nerd fonts statusline_separator = "nil" statusline_iseparator = "bar" buffer_index_type = 4 windows_index_type = 3 enable_tabline_filetype_icon = false enable_statusline_mode = false statusline_unicode_symbols = false # Enable vim compatible mode, avoid changing origin vim key bindings vimcompatible = true # Enable autocomplete layer [[layers]] name = 'autocomplete' auto_completion_return_key_behavior = "complete" auto_completion_tab_key_behavior = "cycle" [[layers]] name = 'shell' default_position = 'top' default_height = 30 |
- 구입목록에 있는 프로그램들 전부 설치 및 업데이트
- Microsoft Remote Desktop
- Microsoft OneNote
- OneDrive
- Notability
- CheetSheet
- GoodNote 5
- VsCode
- Valentina Studio
- Friendly Streaming Browser
- Facebook Messenger
- Skype
- Amphetamine
- SnailGit
- SnailSVN
- HazeOver
- Slack
- deepClock
- 한컴오피스 한글 2014 VP 뷰어
- 무비스트
- 카카오톡
- 네이트온
- Band
- Telegram
- 각 홈페이지 가서 설치해야 하는 프로그램
- Command Line tools
- Brew Install
- composer
- git
- go
- htop
- midnight-commander
- neovim
- nmap
- node
- php-code-sniffer
- php-cd-fixer
- python3
- sdl2
- subversion
- tmux
- zsh
- zsh-completions
- tickeys
- casks font-hack-nerd-font
- casks iterms
- casks meld
| 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 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 ; |
| |
