ebirhusã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ / 2016å¹´4æœˆ14æ—¥ - ã¯ã¦ãªãƒ

æ°´æ—é¤¨ã®ã‚¿ã‚³ãŒè„±èµ°ã€è‡ªåŠ›ã§æµ·ã¸æˆ»ã‚‹ã€€ãƒ‹ãƒ¥ãƒ¼ã‚¸ãƒ¼ãƒ©ãƒ³ãƒ‰

ï¼ˆï¼£ï¼®ï¼®ï¼‰Â ãƒ‹ãƒ¥ãƒ¼ã‚¸ãƒ¼ãƒ©ãƒ³ãƒ‰ã®æ°´æ—é¤¨ã§é£¼è‚²ã•ã‚Œã¦ã„ãŸã‚¿ã‚³ãŒã€è‡ªåŠ›ã§æ°´æ§½ã‹ã‚‰è„±å‡ºã—ã¦æµ·ã¸æˆ»ã£ã¦ã—ã¾ã†å‡ºæ¥äº‹ãŒã“ã®ã»ã©ã‚ã£ãŸã€‚ å§¿ã‚’æ¶ˆã—ãŸã®ã¯ã‚ªã‚¹ã®ã‚¿ã‚³ã®ã€Œã‚¤ãƒ³ã‚ãƒ¼ã€ã€‚æ°´æ§½ä¸Šéƒ¨ã®éš™é–“ã‚’ããã£ã¦å¤–ã¸ã¯ã„å‡ºã—ã€åºŠã‚’ä¼ã£ã¦æµ·æ°´ã®æµã‚Œã‚‹é…ç®¡ã‚’é€šã‚Šã€ãƒ›ãƒ¼ã‚¯æ¹¾ã«è„±å‡ºã—ã¦è‡ªç”±ã®èº«ã«ãªã£ãŸã€‚ ãƒ‹ãƒ¥ãƒ¼ã‚¸ãƒ¼ãƒ©ãƒ³ãƒ‰å›½ç«‹æ°´æ—é¤¨ã®ãƒãƒ–ãƒ»ãƒ¤ãƒ¬ãƒ«é¤¨é•·ã¯ã€ã€Œã‚¿ã‚³ã¯ã¨ã¦ã‚‚é ãŒè‰¯ãå¥½å¥‡å¿ƒæ—ºç››ã§ã€é™ç•Œã«æŒ‘æˆ¦ã—ãŸãŒã‚‹ã€ã¨è§£èª¬ã™ã‚‹ã€‚ç‰¹ã«ã‚¤ãƒ³ã‚ãƒ¼ã¯ã€Œã¨ã¦ã‚‚äººãªã¤ã“ãã¦é ãŒè‰¯ã‹ã£ãŸã®ã§ã€æ°´æ§½ä¸Šéƒ¨ã®å¼±ç‚¹ã‚’è¦‹ä»˜ã‘ãŸã®ã¯æ˜Žã‚‰ã‹ã€ã ã¨ã„ã†ã€‚ ã‚¤ãƒ³ã‚ãƒ¼ã¯ãƒ‹ãƒ¥ãƒ¼ã‚¸ãƒ¼ãƒ©ãƒ³ãƒ‰ã«ç”Ÿæ¯ã™ã‚‹ãƒžãƒ€ã‚³ã§ã€åœ°å…ƒã®æ¼å¸«ãŒæ•ç²ã—ã¦æ°´æ—é¤¨ã«å¯„è´ˆã—ã¦ã„ãŸã€‚ã€Œæ°´æ—é¤¨ã«ã„ã‚‹é–“ã«å¤šãã‚’å¦ã‚“ã ã®ã ã‚ã†ã€‚ã¾ã•ã«å¥½å¥‡å¿ƒæ—ºç››ãªã‚¿ã‚³ã§ã€ç§ãŸã¡ãŒæ€ã£ã¦ã„ãŸã‚ˆã‚Šã‚„ã‚„è³¢ã‹ã£ãŸã€ã¨ãƒ¤ãƒ¬ãƒ«é¤¨é•·ã€‚ ä»Šã”ã‚ã¯è‡ªç„¶ã«æˆ»ã£ã¦æµ·ä¸ã‚’æ•£æ©ã—ã¦ã„ã‚‹ã¨æ€ã‚ã‚Œã€æ°´æ—é¤¨ã‚‚å¤§ãŒã‹ã‚Šãªæœç´¢ã¯è¡Œã‚ãªã„æ–¹é‡ã ã¨ã„ã†ã€‚ ã‚¿ã‚³ã¯ä½“

ebirhus 2016/04/14

neta

ãƒªãƒ³ã‚¯

MERGE - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle SQL å…¥é–€

SQL å…¥é–€ (DMLã®åŸºæœ¬å½¢å¼:MERGE) è¡Œã®æŒ¿å…¥ã¨æ›´æ–°ã‚’ ï¼‘ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§è¡Œãªã† ( MERGE = UPDATE + INSERT ) è¡Œã®æŒ¿å…¥ã¨æ›´æ–°ã‚’1ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§è¡Œãªã†ã€‚ä»–ã® DBMS ã§ã¯ REPLACE ã®å ´åˆã‚‚ã‚ã‚‹ã€‚ UPDATE ã¨ INSERT ã‚’ã‚‚ã˜ã£ã¦ã€UPSERT ã¨ã‚‚å‘¼ã°ã‚Œã‚‹ã€‚(ãƒ¢ãƒ‡ãƒ«ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ã‚‚ UPSERT ã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ãŒã‚ã‚‹) ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ãƒ³ãƒˆãƒªãƒ¼ï¼ˆã¾ãŸã¯æ›´æ–°ï¼‰ã™ã‚‹ äººäº‹ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰æœ€æ–°ã®ãƒžã‚¹ã‚¿ (USER_MASTER_IMPORT) ã‚’å–å¾—ã—ã¦ããŸã€‚(ã¨ä»®å®šã™ã‚‹) ã“ã‚Œã‚’ USER_MASTER ã«æœ€æ–°ã¨ã—ã¦åæ˜ ã•ã›ã‚‹ã€‚æ–°è¦ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ã¯ã€åå‰ã«'(æ–°äºº)'ã‚’ä»˜ä¸Žã™ã‚‹ã€‚ MERGE INTO USER_MASTER USING USER_MASTER_IMPORT ON ( USER_MASTER.USER_ID =

ebirhus 2016/04/14

SQL
Oracle

ãƒªãƒ³ã‚¯

ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒGoè¨€èªžã§ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ„ãƒ¼ãƒ«ã‚’æ›¸ãã“ã¨ã«ã¤ã„ã¦ - Hatena Developer Blog

ã‚¦ã‚§ãƒ–ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® id:y_uuki ã§ã™ã€‚ ã¯ã¦ãªã®æ±äº¬ã‚ªãƒ•ã‚£ã‚¹ã§å…ˆæœˆé–‹å‚¬ã•ã‚ŒãŸGo 1.6 Release Partyã§ã€ã€ŒWriting Tools in Go For Ops Engineersã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ç™ºè¡¨ã—ã¾ã—ãŸã€‚ ç™ºè¡¨ã§ã¯ã€æœ€è¿‘ä½œã£ãŸGoè£½ãƒ„ãƒ¼ãƒ«ã‚’ç´¹ä»‹ã—ã€ãªãœGoãŒã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦è‰¯ã„è¨€èªžã§ã‚ã‚‹ã¨æ„Ÿã˜ã¦ã„ã‚‹ã‹ã‚’è©±ã—ã¾ã—ãŸã€‚ æœ€è¿‘ä½œã£ãŸGoè¨€èªžã®ãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ mkr Grabeni Droot gokc ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒGoã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã®ãƒ¡ãƒªãƒƒãƒˆ 1. ã‚µãƒ¼ãƒã¸ã®é…å¸ƒãŒç°¡å˜ 2. ã‚µãƒ¼ãƒä¸Šã§é«˜é€Ÿé–‹ç™ºã§ãã‚‹ 3. æœ€çµ‚çš„ã«æˆæžœç‰©ã‚’ã¯ã‚„ãä½œã‚Œã‚‹ ãã®ä»– ç™ºè¡¨è³‡æ–™ ã‚ã¨ãŒã æœ€è¿‘ä½œã£ãŸGoè¨€èªžã®ãƒ„ãƒ¼ãƒ«ã®ç´¹ä»‹ ä»¥ä¸‹ã®4ã¤ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½œã‚Šã¾ã—ãŸã€‚ã„ãšã‚Œã‚‚ã¯ã¦ãªã§ã®productionåˆ©ç”¨ã‚’æƒ³å®šã—ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ mkr mkrã¯ã¯ã¦ãªã§é–‹ç™ºã—ã¦ã„ã‚‹

ebirhus 2016/04/14

Go

ãƒªãƒ³ã‚¯

é¶ç¹ å¤§ä¸¸æ±äº¬åº— (æ±äº¬/ç„¼ãé³¥)

ãƒªã‚¯ã‚¨ã‚¹ãƒˆäºˆç´„å¸Œæœ›æ¡ä»¶ã‚’ãŠåº—ã«ç”³ã—è¾¼ã¿ã€ãŠåº—ã‹ã‚‰ã®ç¢ºå®šã®é€£çµ¡ã‚’ã‚‚ã£ã¦ã€äºˆç´„ãŒæˆç«‹ã—ã¾ã™ã€‚ 1 äºˆç´„ã®ç”³ã—è¾¼ã¿ ã”å¸Œæœ›ã®æ¡ä»¶ã‚’å½“ã‚µã‚¤ãƒˆã‚ˆã‚Šã”å…¥åŠ›ãã ã•ã„ã€‚ 2 ãŠåº—ã‹ã‚‰ã®ãƒ¡ãƒ¼ãƒ« ã”äºˆç´„ãŒæ‰¿ã‚Œã‚‹ã‹ã€ãŠåº—ã‹ã‚‰ã®è¿”ä¿¡ãƒ¡ãƒ¼ãƒ«ãŒå±Šãã¾ã™ã€‚ 3 ãŠåº—ã¸æ¥åº— äºˆç´„ãŒç¢ºå®šã—ãŸå ´åˆã€ãã®ã¾ã¾ãŠåº—ã¸ãŠè¶Šã—ãã ã•ã„ã€‚

ebirhus 2016/04/14

ã‚°ãƒ«ãƒ¡

ãƒªãƒ³ã‚¯

Python Djangoå…¥é–€ (1) - Qiita

Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ã˜ã‚ã« ãªãœPythonã‚’é¸ã¶ã‹ ã‹ãªã‚Šç‹¬æ–ã¨åè¦‹ãŒå…¥ã£ã¦ã„ã¾ã™ãŒã€ ã‚·ãƒ³ãƒ—ãƒ«ãªè¨€èªžã‚»ãƒƒãƒˆ æŸè¨€èªžã®ã‚ˆã†ã«ã€å‘ªæ–‡ã®ã‚ˆã†ã«çŸãæ›¸ã‘ã‚‹ã“ã¨ãŒå‘½ã§ã¯ãªã„ã€‚ ãã‚Œã§ã„ã¦ã€æ›¸ãã‚³ãƒ¼ãƒ‰é‡ã¯å°‘ãªãã€ã™ã£ãã‚Šã—ã¦ã„ã‚‹ã€‚ æŸè¨€èªžã®ã‚ˆã†ã«ã€è¨˜å·ã‚’å¤šç”¨ã—ãªã„ã€‚ ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã‚‹é–“Shiftã‚ãƒ¼ã‚’æŠ¼ã—ã£ã±ãªã—ã«ãªã‚‰ãªã„ã€‚ å¦ç¿’ã‚³ã‚¹ãƒˆãŒä½Žã„ã€‚ è¨€èªžã‚»ãƒƒãƒˆã¨ã—ã¦ã®æ–‡æ³•ã¯ã€ã‚ã‚Šã¨å¹³æ˜“ã§ã€ç›´æ„Ÿã§ç†è§£ã§ãã‚‹ã€‚ é›£ã—ã„æ›¸ãæ–¹ã¯ã€å¾Œã‹ã‚‰è¦šãˆã‚Œã°ã‚ˆã„ã€‚ æ–‡æ³•æ›¸ã‚’èªã‚€ã®ã¯ã€å¾Œã‹ã‚‰ã§ã„ã„ã§ã—ã‚‡ã†ã€‚ã¾ãšã“ã®è¬›åº§ã‚’ã‚„ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ Djangoãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚„ã€å„ç¨®Python

ebirhus 2016/04/14

ãƒªãƒ³ã‚¯

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

2016å¹´4æœˆ14æ—¥ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5ä»¶)