[B! random] wlbhiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

wlbhiro id:wlbhiro

randomã«é–¢ã™ã‚‹wlbhiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

PostgreSQLã§ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã™ã‚‹ | Let's POSTGRES
ç¬ åŽŸ è¾°ä» æœ¬è¨˜äº‹ã¯2013å¹´ã®PostgreSQL Advent Calendar ã® 12/25 ã®è¨˜äº‹ã§ã™(åœ°å‘³ãªãƒˆãƒ”ãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã„ã™ã„ã¾ã›ã‚“)ã€‚PostgreSQLã§ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ä½œæˆã«å½¹ç«‹ã¤æ©Ÿèƒ½ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« PostgreSQLã‚’å¯¾è±¡ã¨ã—ãŸã®æ€§èƒ½æ¤œè¨¼ã‚„æ©Ÿèƒ½æ¤œè¨¼ã‚’è¡Œã†éš›ã«ã€é–‹ç™ºç’°å¢ƒã‚„è©¦é¨“ç’°å¢ƒã§ã‚¹ã‚ãƒ¼ãƒž(ãƒ†ãƒ¼ãƒ–ãƒ«ã‚„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹)ã‚’ä½œæˆã—ã€ãƒ€ãƒŸãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŠ•å…¥ã—ã¦SQLã®ãƒã‚§ãƒƒã‚¯ã‚’è¡Œã†ã“ã¨ãŒå¤šã€…ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚å˜ç´”ãªæ©Ÿèƒ½ã®æ£å¸¸è©¦é¨“ã§ã‚ã‚Œã°å°‘é‡ã®ãƒ‡ãƒ¼ã‚¿æŠ•å…¥ã§äº‹è¶³ã‚Šã‚‹ã¨æ€ã„ã¾ã™ãŒã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹æ¤œç´¢å‡¦ç†ã‚„ãƒãƒƒãƒå‡¦ç†ã‚’è©¦ã™éš›ã¯ã€ãã‚Œãªã‚Šã®é‡ã®è©¦é¨“ãƒ‡ãƒ¼ã‚¿ã‚’ç”Ÿæˆã—ã€DBã«æŠ•å…¥ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ é€šå¸¸ã€è©¦é¨“ãƒ‡ãƒ¼ã‚¿ã¯ã€ä¾‹ãˆã°å°‚ç”¨ã®ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ã‚’ä½œã‚‹ã€å®Ÿéš›ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒžã‚¹ã‚ãƒ³ã‚°ã—ãŸã‚‚ã®ã‚’ä½¿ã†ã€ã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿(éƒµä¾¿ç•ªå·ã®ãƒ‡ãƒ¼ã‚¿ãªã©)ã‚’åˆ©ç”¨ã™ã‚‹ã€ã¨ã„ã£ãŸã“ã¨ãŒå¤šã„ã¨æ€
wlbhiro 2018/06/07
PostgreSQL

Sample

Dummy

test

random

Database

md5
ãƒªãƒ³ã‚¯
Linuxã‚³ãƒ³ã‚½ãƒ¼ãƒ«ä¸Šã§ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ©ãƒ³ãƒ€ãƒ ã«è¡Œã‚’æŠ½å‡ºã™ã‚‹ | ä¿ºçš„å‚™å¿˜éŒ² ã€œãªã‚“ã‹ã„ã‚ã„ã‚ã€œ
Linuxã‚³ãƒ³ã‚½ãƒ¼ãƒ«ä¸Šã§ã€æŒ‡å®šã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ©ãƒ³ãƒ€ãƒ ã«è¡Œã‚’å–å¾—ã•ã›ãŸã„æ™‚ãŒã‚ã‚‹ã€‚ ãã‚“ãªã¨ãã¯ã€shufã‚³ãƒžãƒ³ãƒ‰ã‚’ç”¨ã„ã‚Œã°è‰¯ã„ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§ã€æŒ‡å®šã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ©ãƒ³ãƒ€ãƒ ã«ã€Œ-n Nã€ã§æŒ‡å®šã—ãŸNè¡Œã‚’æŠ½å‡ºã™ã‚‹ã€‚ shuf -n N ãƒ•ã‚¡ã‚¤ãƒ«PATH [root@BS-PUB-CENT7-01 ~]# shuf -n 1 /tmp/test1.csv 9,iii,3,12 [root@BS-PUB-CENT7-01 ~]# shuf -n 1 /tmp/test1.csv id,name,prefecture,value [root@BS-PUB-CENT7-01 ~]# shuf -n 1 /tmp/test1.csv 6,fff,1,444 [root@BS-PUB-CENT7-01 ~]# [root@BS-PUB-CENT7-01 ~]# shuf -n
wlbhiro 2017/08/28
Linux

shuf

random
ãƒªãƒ³ã‚¯
Sampling HBase table keyspace
wlbhiro 2017/06/05
HBase

random
ãƒªãƒ³ã‚¯
ãƒ©ãƒ³ãƒ€ãƒ æ–‡å—åˆ—ã‚’ãŸãã•ã‚“ç”Ÿæˆã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
wlbhiro 2016/05/06
Linux

random

ãƒ©ãƒ³ãƒ€ãƒ æ–‡å—åˆ—
ãƒªãƒ³ã‚¯
ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒ©ãƒ³ãƒ€ãƒ ãªæ•°å—ã‚’å¾—ã‚‹æ–¹æ³• - World Wide Walker
ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒ©ãƒ³ãƒ€ãƒ ãªæ•°å—ã‚’å¾—ã‚‹æ–¹æ³• Posted by yoosee on Debian at 2006-11-17 23:42 JST1 bash, zsh ã§ $RANDOM ã‚’ä½¿ã†æ•…ã‚ã£ã¦ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ä¸ã§ 0 ã€œ n ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ•°å—ã‚’ä½¿ã†å¿…è¦ãŒã‚ã£ãŸã®ã ãŒã€ã„ã„æ–¹æ³•ãŒæ€ã„ä»˜ã‹ãš IRC ã§èžã„ã¦ã¿ãŸã€‚ã€Œpid ã‚’ä½¿ã†ã€ã€Œepoch time ã‚’ä½¿ã†ã€ã€Œ dd if=/dev/urandom ã™ã‚‹ã€ã¨è¨€ã†æ–¹æ³•ã‚‚æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸãŒã€ãã‚‚ãã‚‚ bash ã‚„ zsh ãªã‚‰ã° $RANDOM ã¨è¨€ã†å¤‰æ•°ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã‚‰ã—ã„ã€‚RANDOM Â ã“ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãŒå‚ç…§ã•ã‚Œã‚‹åº¦ã«ã€ 0 ã‹ã‚‰ 32767 ã¾ã§ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ•´æ•°ãŒç”Ÿæˆã•ã‚Œã¾ã™ã€‚ ã¨è¨€ã†ã‚ã‘ã§ã€ä¾‹ãˆã° 0ã€œ99ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ•°å—ã‚’å¾—ãŸã„ãªã‚‰num=`expr $RANDOM % 100`ã§ã‚ˆã•ãã†ã€‚ ã¡ãªã¿ã«ãã®æ™‚ã« topl
wlbhiro 2016/02/19
Linux

random
ãƒªãƒ³ã‚¯
ã€commons-lang3ã€‘ RandomStringUtils ã®ã‚ˆãåˆ©ç”¨ã™ã‚‹ï¼ˆã—ãã†ï¼‰ãƒ¡ã‚½ãƒƒãƒ‰ - Qiita
import org.apache.commons.lang3.RandomStringUtils; public class Main { public static void main(String[] args) { // 10æ–‡å—ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ–‡å—åˆ—ç”Ÿæˆ System.out.println(RandomStringUtils.random(10)); // ã‚¢ã‚¹ã‚ãƒ¼æ–‡å—ã§ 10æ–‡å—ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ–‡å—åˆ—ç”Ÿæˆ System.out.println(RandomStringUtils.randomAscii(10)); // è‹±å—ã§ 10æ–‡å—ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ–‡å—åˆ—ç”Ÿæˆ System.out.println(RandomStringUtils.randomAlphabetic(10)); // è‹±æ•°å—ã§ 10æ–‡å—ã®ãƒ©ãƒ³ãƒ€ãƒ ãªæ–‡å—åˆ—ç”Ÿæˆ System.out.println(RandomStrin
wlbhiro 2015/02/09
Java

random
ãƒªãƒ³ã‚¯
Java ã§ã€ãƒ©ãƒ³ãƒ€ãƒ ãªæ–‡å—åˆ—ã‚’ç”Ÿæˆã™ã‚‹æ–¹æ³• - è‡ªåˆ†ã®ä»•äº‹ã‚’æ†Žã‚€ã«ã¯äººç”Ÿã¯ä½™ã‚Šã«ã‚‚çŸã„
ã¡ã‚‡ã£ã¨å¦ã‚“ã ã®ã§æ•´ç†ã€‚ ã¾ãšJavaã«ã¯ãƒ©ãƒ³ãƒ€ãƒ ã‚’æä¾›ã™ã‚‹ã‚¯ãƒ©ã‚¹ã¨ã—ã¦ java.util.Random java.security.SecureRandom ã®2ã¤ãŒã‚ã£ã¦Randomã‚¯ãƒ©ã‚¹ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªå¼·åº¦ã—ã‹æŒã£ã¦ã„ãªã„ã€‚ Random ã‚¯ãƒ©ã‚¹ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã¯ã€ä¸€é€£ã®æ“¬ä¼¼ä¹±æ•°ã‚’ç”Ÿæˆã—ã¾ã™ã€‚ã‚¯ãƒ©ã‚¹ã§ã¯ 48 ãƒ“ãƒƒãƒˆã®ã‚·ãƒ¼ãƒ‰ã‚’ä½¿ã„ã€ã“ã®ã‚·ãƒ¼ãƒ‰ã¯ç·šå½¢åˆåŒæ³•ã§å¤‰æ›´ã•ã‚Œã¾ã™ã€‚ http://sdc.sun.co.jp/java/docs/j2se/1.4/ja/docs/ja/api/java/util/Random.html ã—ã‹ã‚‚åˆæœŸåŒ–ãŒã‚ã¾ã‚Šã‚ˆããªãã¦åˆå›žã®ä¹±æ•°ãŒã¨ã¦ã‚‚åã‚‹ã€‚ Random r = new java.util.Random(); double x, min = 1, max = 0; for (int i = 0; i < 1024; i++) { r.setSeed(
wlbhiro 2015/02/06
ãƒ©ãƒ³ãƒ€ãƒ æ–‡å—åˆ—ç”Ÿæˆä¸€è¦§

Java

random
ãƒªãƒ³ã‚¯
1