[B! dbi] hide-Kã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hide-K id:hide-K

dbiã«é–¢ã™ã‚‹hide-Kã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ç¬¬36å›žã€€SQL::Abstractï¼šç°¡å˜ãªSQLã¯ã‚ˆã‚Šç°¡å˜ã« | gihyo.jp
DBIã®æ³£ãæ‰€ ã„ã‚ã‚†ã‚‹LAMPãªã„ã—ãã‚Œã«ä¼¼ãŸç’°å¢ƒã§ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã°ã‹ã‚Šæ›¸ã„ã¦ã„ã‚‹æ–¹ã«ã¯ã‚ã¾ã‚Šå®Ÿæ„ŸãŒãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚ã¡ã‚‰ã®ç¾å ´ã§ã¯Oracleã‚’ã€ã“ã¡ã‚‰ã®ç¾å ´ã§ã¯Microsoft SQL Serverã‚’ã€ã¯ãŸã¾ãŸåˆ¥ã®ç¾å ´ã§ã¯çµ„ã¿è¾¼ã¿ã®SQLiteã‚’ã€ã¨ã„ã£ãŸå—è¨—ç³»ã®ä»•äº‹ã‚’ã—ã¦ã„ã‚‹äººã«ã¨ã£ã¦ã€SQLã®æ–¹è¨€å•é¡Œã¯é¿ã‘ã¦ã¯é€šã‚Œãªã„ã‚‚ã®ã®ã²ã¨ã¤ã§ã™ã€‚ å…¸åž‹çš„ãªã¨ã“ã‚ã§ã¯ã€ãŸã¨ãˆã°SELECTã§å–å¾—ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ä»¶æ•°ã‚’åˆ¶é™ã—ãŸã„å ´åˆã€PostgreSQLãªã©ã§ã¯ã€ŒLIMIT ... OFFSET ...ã€ã®ã‚ˆã†ã«æ›¸ãã¾ã™ãŒã€Oracleã§ã¯ROWNUMã‚’ä½¿ã„ã¾ã™ã—ã€MS SQL serverãªã‚‰SET ROWCOUNTã‚„TOPã‚’ä½¿ã„ã¾ã™ã€‚ã¾ãŸã€ã„ã¾ã§ã“ãPostgreSQLã¨ã®äº’æ›æ€§ã‚’ç¢ºä¿ã™ã‚‹ãŸã‚ã€ŒLIMIT ... OFFSET ...ã€ã¨æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹MySQLã«ã—ãŸã¨ã“ã‚ã§ã€
hide-K 2010/09/28
perl

dbi
ãƒªãƒ³ã‚¯
ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (4) - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
ã•ã¦ã¨ã€ãƒ¢ãƒã‚²ãƒ¼ã‚ªãƒ¼ãƒ—ãƒ³ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãŒå…ˆæ—¥ã‚„ã£ã¨å§‹ã¾ã‚Šã¾ã—ãŸï¼¾ï¼¾ ã¿ãªã•ã‚“æ˜¯éžéŠã‚“ã§ä¸‹ã•ã„ã§ã™ã€‚ d:id:ZIGOROu:20091125:1259163476 ã®ã•ã‚‰ã«ç¶šç·¨ã§ã™ã€‚ ShowErrorStatement ã§ã‚¨ãƒ©ãƒ¼æ™‚ã«ç™ºè¡Œã•ã‚Œã¦ã„ãŸã‚¯ã‚¨ãƒªã‚’è¡¨ç¤ºã™ã‚‹ #!/usr/bin/perl use Carp; use DBI; my $dbh; eval { $dbh = DBI->connect("dbi:mysql:db=test;host=localhost", "root", "", +{ RaiseError => 1, AutoCommit => 0, ShowErrorStatement => 1, PrintWarn => 0, PrintError => 0, }) or croak($DBI::errstr); $dbh->selectall_arrayref
hide-K 2010/01/30
dbi
ãƒªãƒ³ã‚¯
myfinder's blog: DBIx::Encodingã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ›¸ã„ãŸ
YAPCãŠã¤ã‹ã‚Œã•ã¾ã§ã—ãŸã€‚YAPCä¸ã€ä»Šã¾ã•ã«èª²é¡Œã«ãªã£ã¦ã„ã‚‹DBå‘¨ã‚Šã®å•é¡Œã‚’è§£æ¶ˆã™ã¹ãDBIx::Encodingã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’æ›¸ãã¾ã—ãŸã€‚ã“ã®DBIx::Encodingã¯DBIã®ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã§ã€executeã¨fetchã®éš›ã«æŒ‡å®šã—ãŸæ–‡å—ã‚³ãƒ¼ãƒ‰ã§encode/decodeã—ã¦ãã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ãã‚‚ãã‚‚DBã®æ–‡å—ã‚³ãƒ¼ãƒ‰è¨å®šãŒUTF8ãªã‚‰ä½™ã‚Šæ‚©ã‚€ã“ã¨ã‚‚ãªã„ã®ã§ã™ãŒã€ä¸–ã®ä¸ã„ã‚ã„ã‚ã¨äº‹æƒ…ãŒã‚ã£ã¦DBå´ã‚’å¤‰æ›´ã§ããªã„äº‹ã‚‚å¤šã„ã§ã—ã‚‡ã†ã€‚ãã‚“ãªã¨ãã«ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã¨ã€DBIå´ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’encodeã—ã¦insert/updateã—ã¦ãã‚Œã€selectã—ãŸã¨ãã«ã¯utf8 flagã‚’æœ‰åŠ¹ã«ã—ãŸæ–‡å—åˆ—ã‚’è¿”ã—ã¦ãã‚Œã¾ã™ã€‚ä½¿ã„æ–¹ã¯SYNOPSISã«ã‚‚ã‚ã‚Šã¾ã™ãŒã€ä¸‹è¨˜ã®é€šã‚Šmy @dsn = ( 'dbi:mysql:host=localhost;database=mysql;
hide-K 2009/09/18
dbi

encode
ãƒªãƒ³ã‚¯
ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (2) - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
ã•ã¦ã€ã¾ã•ã‹ç¶šç·¨æ›¸ãã¨æ€ã‚ãªã‹ã£ãŸã‘ã©ã€d:id:ZIGOROu:20090731:1249050735 ã®ç¶šãã§ã™ã€‚ è¿½è¨˜ (2009-08-15T00:30:56+09:00) ã¡ãªã¿ã«ã€ä¸‹è¨˜ã§ç´¹ä»‹ã—ã¦ã‚‹æ–¹æ³•ã¯ä¸€èˆ¬çš„ã«ã¯ DBI ã®è³‡ç”£ãŒãŸãã•ã‚“åˆã£ã¦ãƒ¢ã‚´ãƒ¢ã‚´ãªçŠ¶æ³ã‚’ã©ã†ã™ã‚‹ã‹â€¦ã¿ãŸã„ãªçŠ¶æ³ã®äººå‘ã‘ã§ã™ã€‚ ä¸€èˆ¬çš„ã«ã¯å®œã—ããªã„ã§ã™ã€ã¨è¨€ã†ã“ã¨ã‚’è¸ã¾ãˆã¦ã©ã†ãžã€‚ DBI ã®æ‹¡å¼µã‚’ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã‚’ç”¨ã„ã¦è¡Œã† Subclassing the DBI ã«ã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ã‚ã‚‹ã‚“ã§ã™ãŒã€DBI ã¯ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ç‚ºã®ç’°å¢ƒãŒæ•´ã£ã¦ã„ã¾ã™ã€‚ è«–ã‚ˆã‚Šè¨¼æ‹ ã€å®Ÿéš›ã®ä¾‹ã§ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use DBI; use YAML; { package DBIx::Hideki; use base qw(DBI); package DBIx::Hide
hide-K 2009/08/15
dbi

dbix-hideki

ky
ãƒªãƒ³ã‚¯
ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (1) - Yet Another Hackadelic
ã¡ã‚‡ã£ã¨å‰ã¾ã§ DBI ã§éžåŒæœŸã‚¢ã‚¯ã‚»ã‚¹ãªã‚¨ãƒ³ãƒˆãƒªãŒå„æ‰€ã§ä¸ŠãŒã£ã¦ã„ã¾ã—ãŸãŒçš†ã•ã‚“å¦‚ä½•ãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã•ã¦ã¨ã€ã€ã€æ´å²çš„ãªçµŒç·¯ã¨ã‹æ´å²çš„ãªçµŒç·¯ã¨ã‹ã§ç”Ÿ DBI ç›¸å½“ã‚’ä½¿ã£ã¦ã‚‹æ–¹ã‚‚ãã‚Œãªã‚Šã«ã„ã‚‹ã§ã—ã‚‡ã†ã€‚å¥¥ã•ã‚“ã€å¤§äº‹ãªäº‹ãªã‚“ã§äºŒåº¦è¨€ã„ã¾ã—ãŸã‚ˆï¼ DBI ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã£ã¦ã¾ããã‚“ãªä½¿ã„ã‚„ã™ã„ç‰©ã˜ã‚ƒãªã„ã‚“ã§ã™ãŒã€å·¥å¤«æ¬¡ç¬¬ã§å‡ºæ¥ã‚‹äº‹ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã¡ãªã¿ã«ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€MySQL Documentation - Example Databases ã® world ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ fetchall_arrayref ã§ãƒ‡ãƒ¼ã‚¿æ•´å½¢ ã¾ãšä»¥ä¸‹ã®ã‚ˆã†ã«ä½¿ã£ã¦ã¿ã¾ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use Data::Dump qw(dump); use DBI; use Perl6::Say; my $dbh =
hide-K 2009/08/01
perl

dbi
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
hide-K 2009/05/28
dbi
ãƒªãƒ³ã‚¯
DBI Recipes
DBI recipes by Giuseppe Maxia Version 0.02 26-Aug-2003 DBI Recipes Synopsis Description Caveat Checking for an existing table Inserting records Creating an insertion query Inserting scalars Inserting a list of lists Inserting a list of hashes About fetching records Creating an array from a column Using map and selectall_arrayref() Using selectcol_arrayref() using selectall_arrayref and an array sl
hide-K 2008/04/25
dbi
ãƒªãƒ³ã‚¯
1