Newer Older
1278 lines | 33.943kb
update pod
Yuki Kimoto authored on 2011-01-28
1
=encoding utf8
2

            
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
3
=head1 NAME
4

            
update pod
Yuki Kimoto authored on 2011-01-28
5
DBIx::Custom::Guide - DBIx::Custom Guide
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
6

            
pod fix
Yuki Kimoto authored on 2011-01-21
7
=head1 GUIDE
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
8

            
update pod
Yuki Kimoto authored on 2011-01-28
9
B<This guide is now writing.>
update pod
Yuki Kimoto authored on 2011-01-26
10

            
update pod
Yuki Kimoto authored on 2011-01-28
11
L<DBIx::Custom> is the class to make easy to execute SQL.
12
This is L<DBI> wrapper class like L<DBIx::Class> or L<DBIx::Simple>.
13
You can do thing more easy than L<DBIx::Class>, more flexible
14
than L<DBIx::Simple>.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
15

            
update pod
Yuki Kimoto authored on 2011-01-28
16
L<DBIx::Custom> is B<not< O/R mapper, O/R mapper is usefule, but
17
you must learn many things. Created SQL is sometimes inefficient,
18
and in many cases you create raw SQL because
19
O/R mapper can't make complex SQL
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
20

            
update pod
Yuki Kimoto authored on 2011-01-28
21
L<DBIx::Custom> is opposit of O/R mapper.
22
The main purpose is that we respect SQL
23
and make easy difficult works if you use only L<DBI>.
24
If you already learn SQL, it is easy to use L<DBIx::Custom>.
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
25

            
update pod
Yuki Kimoto authored on 2011-01-28
26
I explain L<DBIx::Custom> a little in this section.
27
In L<DBIx::Custom>, you embbed tag in SQL.
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
28

            
update pod
Yuki Kimoto authored on 2011-01-28
29
    select * from book where {= title} and {=author};
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
30

            
update pod
Yuki Kimoto authored on 2011-01-28
31
The part arround {} is tag.
32
This SQL is converted to the one which contains place holder.
33

            
34
    select * from book where title = ? and author = ?;
35

            
36
Maybe you ask me that this conversion is meaningful.
37
On the top of this, usuful features is implemented.
38
See the following descriptions.
39

            
40
=over 4
41

            
42
=item 1. Specify place holder binding value as hash refernce
43

            
44
If you use L<DBI>, you must specify place holder binding value
45
as array.
46

            
47
    $sth->execute(@bind);
48

            
49
If you use L<DBIx::Custom>, you specify it as hash reference.
50
    
51
    my $param = {title => 'Perl', author => 'Ken'};
52
    $dbi->execute($sql, $param);
53

            
54
=item 2. Filtering
55

            
56
L<DBIx::Custom> provides filtering system.
57
For example, You think that about date value you want to 
58
manipulate it as date object like L<Time::Piece> in Perl,
59
and want to convert it to database DATE format.
60
and want to do reverse.
61

            
62
You can use filtering system.
63

            
64
At first, register filter.
65

            
66
    $dbi->register_filter(
67
        tp_to_date => sub {
68
            ...
69
        },
70
        date_to_tp => sub {
71
            ...
72
        }
73
    );
74

            
75
next, apply this filter to each column.
76

            
77
    $dbi->apply_filter('book',
78
        'issue_date' => {out => 'tp_to_date', in => 'date_to_tp'}
79
    );
80

            
81
C<out> is perl-to-database way. C<in> is perl-from-database way.
82

            
83
This filter is automatically enabled in many method.
84

            
85
    $dbi->insert(table => 'book', param => {issue_date => $tp});
86

            
87

            
88
=item 3. Selective search condition
89

            
90
It is difficult to create selective where clause in L<DBI>.
91
For example, If C<title> and C<author> is specified, we create 
92
the following SQL.
93

            
94
    select * from book where title = ? and author = ?;
95

            
96
If only C<title> is specified, the following one
97

            
98
    select * from book where title = ?;
99

            
100
If only C<author> is specified, the following one,
101

            
102
    select * from book where author = ?;
103

            
104
This is hard work. Generally we use modules like L<SQL::Abstract>.
105
L<DBIx::Custom> prepare the way to make it easy.
106

            
107
    # Where object
108
    my $where = $dbi->where;
109
    
110
    # Search condition
111
    $where->clause(
112
        ['and', '{= title}', {'= author'}]
113
    );
114
    
115
    # Setting to automatically select needed column
116
    $where->param({title => 'Perl'});
117

            
118
    # Embbed where clause to SQL
119
    my $sql = "select * from book $where";
120

            
121
You can create where clause which has selected search condition.
122
You can write nesting of where clause and C<or> condition
123

            
update pod
Yuki Kimoto authored on 2011-01-30
124
=item 4. Methods for insert, update, delete, select
update pod
Yuki Kimoto authored on 2011-01-28
125

            
update pod
Yuki Kimoto authored on 2011-01-30
126
L<DBIx::Custom> provides methods for insert, update, delete, select
127
There are C<insert()>, C<update()>, C<delete()>,C<select()>.
update pod
Yuki Kimoto authored on 2011-01-28
128

            
129
    my $param = {title => 'Perl', author => 'Ken'};
130
    $dbi->insert(table => 'book', param => $param);
131

            
update pod
Yuki Kimoto authored on 2011-01-30
132
=item 5. Register method for table.
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
133

            
update pod
Yuki Kimoto authored on 2011-01-30
134
You can register method for table.
update pod
Yuki Kimoto authored on 2011-01-28
135

            
update pod
Yuki Kimoto authored on 2011-01-30
136
    $dbi->table('book')->method(
update pod
Yuki Kimoto authored on 2011-01-28
137
        list => sub {
138
            ...
139
        },
update pod
Yuki Kimoto authored on 2011-01-30
140
        something => sub {
141
            ...
update pod
Yuki Kimoto authored on 2011-01-28
142
        }
143
    );
144

            
update pod
Yuki Kimoto authored on 2011-01-30
145
use the mehtod.
update pod
Yuki Kimoto authored on 2011-01-28
146

            
147
    $dbi->table('book')->list;
148

            
update pod
Yuki Kimoto authored on 2011-01-30
149
Many O/R mapper must create class for table,
150
but L<DBIx::Custom> make it easy.
update pod
Yuki Kimoto authored on 2011-01-28
151

            
152
=back
153

            
update pod
Yuki Kimoto authored on 2011-01-30
154
L<DBIx::Custom> is very useful.
155
See the following if you are interested in it.
update pod
Yuki Kimoto authored on 2011-01-28
156

            
update pod
Yuki Kimoto authored on 2011-01-30
157
=head2 1. Connect to database
update pod
Yuki Kimoto authored on 2011-01-28
158

            
update pod
Yuki Kimoto authored on 2011-01-30
159
Load L<DBIx::Custom>.
update pod
Yuki Kimoto authored on 2011-01-28
160

            
161
    use DBIx::Custom;
162

            
update pod
Yuki Kimoto authored on 2011-01-30
163
use C<connect()> to connect to database.
164
Return value is L<DBIx::Custom> object.
update pod
Yuki Kimoto authored on 2011-01-28
165

            
166
    my $dbi = DBIx::Custom->connect(
update pod
Yuki Kimoto authored on 2011-01-30
167
        data_source => "dbi:mysql:database=bookstore",
update pod
Yuki Kimoto authored on 2011-01-28
168
        user => 'ken',
169
        password => '!LFKD%$&',
170
        dbi_options => {mysql_enable_utf8 => 1}
171
    );
172

            
update pod
Yuki Kimoto authored on 2011-01-30
173
C<data_source> must be one corresponding to the database system.
174
The following ones are data source example.
update pod
Yuki Kimoto authored on 2011-01-28
175

            
176
B<MySQL>
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
177

            
178
    "dbi:mysql:database=$database"
179
    "dbi:mysql:database=$database;host=$hostname;port=$port"
180

            
update pod
Yuki Kimoto authored on 2011-01-28
181
B<SQLite>
182

            
183
    "dbi:SQLite:dbname=$database"
184
    "dbi:SQLite:dbname=:memory:"
185

            
186
B<PostgreSQL>
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
187

            
188
    "dbi:Pg:dbname=$dbname"
189

            
update pod
Yuki Kimoto authored on 2011-01-28
190
B<Oracle>
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
191

            
192
    "dbi:Oracle:$dbname"
193
    "dbi:Oracle:host=$host;sid=$sid"
194

            
update pod
Yuki Kimoto authored on 2011-01-28
195
B<ODBC(Microsoft Access)>
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
196

            
197
    "dbi:ODBC:driver=Microsoft Access Driver (*.mdb);dbq=hoge.mdb"
198

            
update pod
Yuki Kimoto authored on 2011-01-28
199
B<ODBC(SQL Server)>
deprecated DBIx::Custom::MyS...
root authored on 2010-11-26
200

            
201
   "dbi:ODBC:driver={SQL Server};Server=(local);database=test;Trusted_Connection=yes;AutoTranslate=No;"
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
202

            
update pod
Yuki Kimoto authored on 2011-01-30
203
If authentication is needed, you can specify C<user> and C<password>
204

            
205
L<DBIx::Custom> is wrapper class of L<DBI>.
206
You can use all methods of L<DBI> from L<DBIx::Custom> object.
207

            
208
    $dbi->do(...);
209
    $dbi->begin_work;
update pod
Yuki Kimoto authored on 2011-01-28
210

            
update pod
Yuki Kimoto authored on 2011-01-30
211
use C<dhb()> to get database handle of L<DBI>
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
212

            
update pod
Yuki Kimoto authored on 2011-01-28
213
    my $dbh = $dbi->dbh;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
214

            
update pod
Yuki Kimoto authored on 2011-01-30
215
By default, the following ones is set to database handle attributes.
216

            
217
    RaiseError  ->  1
218
    PrintError  ->  0
219
    AutoCommit  ->  1
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
220

            
update pod
Yuki Kimoto authored on 2011-01-30
221
If fatal error occuer, program terminate.
222
If SQL is executed, commit is executed automatically.
update pod
Yuki Kimoto authored on 2011-01-28
223

            
update pod
Yuki Kimoto authored on 2011-01-31
224
=head2 2. Methods for insert, update, delete, or insert
update pod
Yuki Kimoto authored on 2011-01-28
225

            
update pod
Yuki Kimoto authored on 2011-01-31
226
There are following methods.
update pod
Yuki Kimoto authored on 2011-01-28
227

            
update pod
Yuki Kimoto authored on 2011-01-31
228
=head3 C<insert()>
update pod
Yuki Kimoto authored on 2011-01-28
229

            
update pod
Yuki Kimoto authored on 2011-01-31
230
use C<insert()> to insert row into database
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
231

            
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
232
    $dbi->insert(table  => 'book',
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
233
                 param  => {title => 'Perl', author => 'Ken'});
234

            
update pod
Yuki Kimoto authored on 2011-01-31
235
C<table> is table name, C<param> is insert data.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
236

            
update pod
Yuki Kimoto authored on 2011-01-31
237
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
238

            
update pod
Yuki Kimoto authored on 2011-01-28
239
    insert into (title, author) values (?, ?);
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
240

            
update pod
Yuki Kimoto authored on 2011-01-31
241
=head3 C<update()>
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
242

            
update pod
Yuki Kimoto authored on 2011-01-31
243
use C<update()> to update row in database.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
244

            
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
245
    $dbi->update(table  => 'book', 
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
246
                 param  => {title => 'Perl', author => 'Ken'}, 
247
                 where  => {id => 5});
248

            
update pod
Yuki Kimoto authored on 2011-01-31
249
C<table> is table name, C<param> is update data, C<where> is condition.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
250

            
update pod
Yuki Kimoto authored on 2011-01-31
251
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
252

            
update pod
Yuki Kimoto authored on 2011-01-28
253
    update book set title = ?, author = ?;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
254

            
update pod
Yuki Kimoto authored on 2011-01-31
255
You can't execute C<update()> without C<where> for safety.
256
use C<update_all()> if you want to update all rows.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
257

            
update pod
Yuki Kimoto authored on 2011-01-28
258
    $dbi->update_all(table  => 'book', 
259
                     param  => {title => 'Perl', author => 'Ken'});
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
260

            
update pod
Yuki Kimoto authored on 2011-01-31
261
=head3 C<delete()>
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
262

            
update pod
Yuki Kimoto authored on 2011-01-31
263
use C<delete()> to delete rows from database.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
264

            
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
265
    $dbi->delete(table  => 'book',
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
266
                 where  => {author => 'Ken'});
267

            
update pod
Yuki Kimoto authored on 2011-01-31
268
C<table> is table name, C<where> is condition.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
269

            
update pod
Yuki Kimoto authored on 2011-01-31
270
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
271

            
update pod
Yuki Kimoto authored on 2011-01-28
272
    delete from book where id = ?;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
273

            
update pod
Yuki Kimoto authored on 2011-01-31
274
You can't execute C<delete()> without C<where> for safety.
275
use C<delete_all()> if you want to delete all rows.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
276

            
update pod
Yuki Kimoto authored on 2011-01-28
277
    $dbi->delete_all(table  => 'book');
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
278

            
update pod
Yuki Kimoto authored on 2011-01-31
279
=head3 C<select()>
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
280

            
update pod
Yuki Kimoto authored on 2011-01-31
281
use C<select()> to select rows from database
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
282

            
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
283
    my $result = $dbi->select(table => 'book');
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
284

            
update pod
Yuki Kimoto authored on 2011-01-31
285
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
286

            
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
287
    select * from book;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
288

            
update pod
Yuki Kimoto authored on 2011-01-31
289
Return value is L<DBIx::Custom::Result> object.
290
use C<fetch()> to fetch row.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
291

            
292
    while (my $row = $result->fetch) {
293
        my $title  = $row->[0];
294
        my $author = $row->[1];
295
    }
296

            
update pod
Yuki Kimoto authored on 2011-01-31
297
See L<3. Fetch row/"3. Fetch row"> about L<DBIx::Custom::Result>.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
298

            
update pod
Yuki Kimoto authored on 2011-01-31
299
Continue more examples.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
300

            
301
    my $result = $dbi->select(
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
302
        table  => 'book',
update pod
Yuki Kimoto authored on 2011-01-28
303
        column => ['author',  'title'],
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
304
        where  => {author => 'Ken'}
305
    );
306

            
update pod
Yuki Kimoto authored on 2011-01-31
307
C<column> is column names, C<where> is condition.
308

            
309
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
310

            
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
311
    select author, title from book where author = ?;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
312

            
update pod
Yuki Kimoto authored on 2011-01-31
313
Next example.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
314

            
315
    my $result = $dbi->select(
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
316
        table    => ['book', 'rental'],
update pod
Yuki Kimoto authored on 2011-01-31
317
        where    => {'book.name' => 'Perl'},
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
318
        relation => {'book.id' => 'rental.book_id'}
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
319
    );
320

            
update pod
Yuki Kimoto authored on 2011-01-31
321
C<relation> is relation of tables. This is inner join.
322

            
323
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
324

            
update pod
Yuki Kimoto authored on 2011-01-28
325
    select * from book, rental where book.name = ? and book.id = rental.book_id;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
326

            
update pod
Yuki Kimoto authored on 2011-01-31
327
Next example.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
328

            
329
    my $result = $dbi->select(
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
330
        table  => 'book',
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
331
        where  => {author => 'Ken'},
update pod
Yuki Kimoto authored on 2011-01-28
332
        append => 'for update',
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
333
    );
334

            
update pod
Yuki Kimoto authored on 2011-01-31
335
C<append> is string appending to end of SQL.
336

            
337
Following SQL is executed.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
338

            
update pod
Yuki Kimoto authored on 2011-01-28
339
    select * book where author = ? for update;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
340

            
update pod
Yuki Kimoto authored on 2011-01-31
341
C<appned> is also used at C<insert()>, C<update()>, C<update_all()>
342
C<delete()>, C<delete_all()>, and C<select()>.
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
343

            
update pod
Yuki Kimoto authored on 2011-01-31
344
=head3 C<execute()> SQL
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
345

            
update pod
Yuki Kimoto authored on 2011-01-31
346
use C<execute()> to execute SQL
update pod
Yuki Kimoto authored on 2011-01-28
347

            
348
    $dbi->execute("select * from book;");
349

            
update pod
Yuki Kimoto authored on 2011-01-31
350
Process tag and execute SQL.
update pod
Yuki Kimoto authored on 2011-01-28
351

            
352
    $dbi->execute(
353
        "select * from book {= title} and {= author};"
354
        param => {title => 'Perl', author => 'Ken'}
355
    );
356

            
update pod
Yuki Kimoto authored on 2011-01-31
357
Following SQL is executed.
update pod
Yuki Kimoto authored on 2011-01-28
358

            
359
    select * from book title = ? and author = ?;
360

            
update pod
Yuki Kimoto authored on 2011-01-31
361
Values of title and author is embbdeded into placeholder.
update pod
Yuki Kimoto authored on 2011-01-28
362

            
update pod
Yuki Kimoto authored on 2011-01-31
363
See L<5. Tag/"5. Tag"> about tag.
update pod
Yuki Kimoto authored on 2011-01-28
364

            
update pod
Yuki Kimoto authored on 2011-01-31
365
You don't have to wirte last semicolon in C<execute()>. 
update pod
Yuki Kimoto authored on 2011-01-28
366

            
367
    $dbi->execute('select * from book');
368

            
369
=head2 3. �s�̃t�F�b�`
370

            
371
C<select()>���\�b�h�̖߂�l��L<DBIx::Custom::Result>�I�u�W�F�N�g�ł��B
372
L<DBIx::Custom::Result>�ɂ͍s��t�F�b�`���邽�߂̂��܂��܂ȃ��\�b�h��
373
�p�ӂ���Ă��܂��B
374

            
375
=head3 1�s�ƒt�F�b�`(�z��) C<fetch()>
376

            
377
��s�t�F�b�`���Ĕz��̃��t�@�����X�Ɋi�[����ɂ�C<fetch()>��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
378

            
379
    while (my $row = $result->fetch) {
update pod
Yuki Kimoto authored on 2011-01-28
380
        my $title  = $row->[0];
381
        my $author = $row->[1];
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
382
    }
383

            
update pod
Yuki Kimoto authored on 2011-01-28
384
while���[�v��g��āA���ׂĂ̍s��擾���邱�Ƃ��ł��܂��B
385

            
386
=head3 �ŏ��̍s�����t�F�b�`(�z��) C<fetch_first()>
387

            
388
��s�����t�F�b�`���Ĕz��̃��t�@�����X�Ɋi�[����ɂ�C<fetch_first()>
389
��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
390

            
391
    my $row = $result->fetch_first;
392

            
update pod
Yuki Kimoto authored on 2011-01-28
393
��s�̃t�F�b�`���I������͂���ȏ�t�F�b�`�ł��Ȃ��Ȃ�܂��B
394
���I�ɂ�1�s�̃t�F�b�`���I�������
395
�X�e�[�g�����g�n���h����C<finish()>����s����܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
396

            
update pod
Yuki Kimoto authored on 2011-01-28
397
=head3 �����s��Ƀt�F�b�`(�z��) C<fetch_multi()>
398

            
399
�����s��t�F�b�`���Ĕz��̃��t�@�����X��v�f�Ɏ���
400
�z��̃��t�@�����X�Ɋi�[����ɂ�C<fetch_multi()>��g�p���܂��B
401

            
402
    while (my $rows = $result->fetch_multi(2)) {
403
        my $title0   = $rows->[0][0];
404
        my $author0  = $rows->[0][1];
405
        
406
        my $title1   = $rows->[1][0];
407
        my $author1  = $rows->[1][1];
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
408
    }
update pod
Yuki Kimoto authored on 2011-01-28
409

            
410
��ɂ͎��o�������s����w�肵�܂��B
411

            
412
�w�肵���s��i�[�������̂悤�ȃf�[�^��擾�ł��܂��B
413

            
414
    [
415
        ['Perl', 'Ken'],
416
        ['Ruby', 'Mark']
417
    ]
418

            
419
=head3 ���ׂĂ̍s��t�F�b�`(�z��) C<fetch_all>
420

            
421
���ׂĂ̍s��t�F�b�`���Ĕz��̃��t�@�����X��v�f�Ɏ���
422
�z��̃��t�@�����X�Ɋi�[����ɂ�C<fetch_all()>��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
423

            
424
    my $rows = $result->fetch_all;
425

            
update pod
Yuki Kimoto authored on 2011-01-28
426
���ׂĂ̍s��i�[�������̂悤�ȃf�[�^��擾�ł��܂��B
427

            
428
    [
429
        ['Perl', 'Ken'],
430
        ['Ruby', 'Mark']
431
    ]
432

            
433
=head3 1�s�ƒt�F�b�`(�n�b�V��) C<fetch_hash()>
434

            
435
��s�t�F�b�`���ăn�b�V���̃��t�@�����X�Ɋi�[����ɂ�C<fetch_hash()>��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
436

            
437
    while (my $row = $result->fetch_hash) {
438
        my $title  = $row->{title};
439
        my $author = $row->{author};
440
    }
441

            
update pod
Yuki Kimoto authored on 2011-01-28
442
=head3 �ŏ��̍s�����t�F�b�`(�n�b�V��) C<fetch_hash_first()>
443

            
444
��s�����t�F�b�`���ăn�b�V���̃��t�@�����X�Ɋi�[����ɂ�
445
C<fetch_hash_first()>��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
446

            
447
    my $row = $result->fetch_hash_first;
update pod
Yuki Kimoto authored on 2011-01-28
448

            
449
��s�̃t�F�b�`���I������͂���ȏ�t�F�b�`�ł��Ȃ��Ȃ�܂��B
450
���I�ɂ�1�s�̃t�F�b�`���I�������
451
�X�e�[�g�����g�n���h����C<finish()>����s����܂��B
452

            
453
=head3 �����s��Ƀt�F�b�`(�n�b�V��) C<fetch_hash_multi()>
454

            
455
�����s��t�F�b�`���ăn�b�V���̃��t�@�����X��v�f�Ɏ���
456
�z��̃��t�@�����X�Ɋi�[����ɂ�C<fetch_hash_multi()>
457
��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
458

            
459
    while (my $rows = $result->fetch_hash_multi(5)) {
update pod
Yuki Kimoto authored on 2011-01-28
460
        my $title0   = $rows->[0]{title};
461
        my $author0  = $rows->[0]{author};
462
        my $title1  = $rows->[1]{title};
463
        my $author1 = $rows->[1]{author};
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
464
    }
update pod
Yuki Kimoto authored on 2011-01-28
465

            
466
��ɂ͎��o�������s����w�肵�܂��B
467

            
468
�w�肵���s��i�[�������̂悤�ȃf�[�^��擾�ł��܂��B
469

            
470
    [
471
        {title => 'Perl', author => 'Ken'},
472
        {title => 'Ruby', author => 'Mark'}
473
    ]
474

            
475
=head3 ���ׂĂ̍s��t�F�b�`(�n�b�V��) C<fetch_hash_all()>
476

            
477
���ׂĂ̍s��t�F�b�`���ăn�b�V���̃��t�@�����X��v�f�Ɏ���
478
�z��̃��t�@�����X�Ɋi�[����ɂ�C<fetch_hash_all()>
479
��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
480

            
481
    my $rows = $result->fetch_hash_all;
482

            
update pod
Yuki Kimoto authored on 2011-01-28
483
���ׂĂ̍s��i�[�������̂悤�ȃf�[�^��擾�ł��܂��B
484

            
485
    [
486
        {title => 'Perl', author => 'Ken'},
487
        {title => 'Ruby', author => 'Mark'}
488
    ]
489

            
490
=head3 �X�e�[�g�����g�n���h�� C<sth()>
491

            
492
�X�e�[�g�����g�n���h���ɒ��ڃA�N�Z�X�������ꍇ��
493
<sth>�Ŏ擾���邱�Ƃ��ł��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
494

            
495
    my $sth = $result->sth;
496

            
update pod
Yuki Kimoto authored on 2011-01-28
497
�t�F�b�`�̃p�t�H�[�}���X���p���𖞂����Ȃ��Ƃ��ɂ́A
498
�X�e�[�g�����g�n���h������
499
���p�ł��鑬�x�̑������\�b�h�𗘗p���邱�Ƃ��ł��܂��B
500

            
501
=head2 4. �t�B���^�����O
502

            
503
�f�[�^�x�[�X�Ƀf�[�^��o�^����Ƃ���f�[�^�x�[�X����f�[�^��擾����
504
�Ƃ��Ɏ����I�ɒl�̕ϊ���s�������ꍇ�������Ǝv���܂��B
505
���Ƃ��΁A��t��\�������̏ꍇ�́A
506
�f�[�^�x�[�X�ɓo�^����ꍇ��L<Time::Piece>�I�u�W�F�N�g����
507
�f�[�^�x�[�X�̓�t�̃t�H�[�}�b�g�ɁA
508
�f�[�^�x�[�X����f�[�^��擾����Ƃ��́A���̋t��s����ƕ֗��ł��B
509

            
510
=head3 �t�B���^�̓o�^ C<register_filter()>
511

            
512
�t�B���^��o�^����ɂ�C<register_filter()>��g�p���܂��B
513

            
514
    $dbi->register_filter(
515
        # Time::Piece object to DATE format
516
        tp_to_date => sub {
517
            my $date = shift;
518

            
519
            return '0000-00-00' unless $tp;
520
            return $tp->strftime('%Y-%m-%d');
521
        },
522
        
523
        # DATE to Time::Piece object
524
        date_to_tp => sub {
525
            my $date = shift;
526

            
527
            return if $date eq '0000-00-00';
528
            return Time::Piece->strptime($date, '%Y-%m-%d');
529
        },
530
    );
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
531

            
update pod
Yuki Kimoto authored on 2011-01-28
532
�o�^�����t�B���^��C<apply_filter()>�Ȃǂŗ��p���邱�Ƃ��ł��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
533

            
update pod
Yuki Kimoto authored on 2011-01-28
534
=head3 �t�B���^�̓K�p C<apply_filter()>
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
535

            
update pod
Yuki Kimoto authored on 2011-01-28
536
�쐬�����t�B���^��K�p����ɂ́AC<apply_filter()>��g�p���܂��B
537

            
538
    $dbi->apply_filter('book',
539
        issue_date => {out => 'tp_to_date', in => 'date_to_tp'},
540
        first_issue_date => {out => 'tp_to_date', in => 'date_to_tp'}
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
541
    );
542

            
update pod
Yuki Kimoto authored on 2011-01-28
543
����̓e�[�u�����ł��B����ȍ~�́A�񖼂ƃt�B���^���[���̃y�A��L�q���܂��B
544
�t�B���^���[����out�ɂ́A�f�[�^�x�[�X�Ƀf�[�^�𑗐M����Ƃ��ɓK�p����t�B���^��A
545
�t�B���^���[����in�ɂ́A�f�[�^�x�[�X����f�[�^��擾����Ƃ��ɓK�p����t�B���^��
546
�L�q���܂��Bout���f�[�^�x�[�X�ɑ��M������Ain���f�[�^�x�[�X������o�����ł��B
547
�t�B���^�ɂ́AC<register_filter>�œo�^�����t�B���^���̑��ɁA�R�[�h���t�@�����X��
548
�w�肷�邱�Ƃ�ł��܂��B
549

            
550
    issue_date => {out => sub { ... }, in => sub { ... }}
551

            
552
�K�p���ꂽ�t�B���^��C<insert()>�AC<update()>�AC<update_all()>�AC<delete()>�A
553
C<delete_all()>�AC<select()>�ŗL��ɂȂ�܂��B
554

            
555
    my $tp = Time::Piece->strptime('2010/10/14', '%Y/%m/%d');
556
    my $result = $dbi->select(table => 'book', where => {issu_date => $tp});
557

            
558
�f�[�^�x�[�X�Ƀf�[�^�����M�����Ƃ��ɁAL<Time::Piece>�I�u�W�F�N�g��
559
�f�[�^�x�[�X�̓�t�̃t�H�[�}�b�g�u2010-10-14�v�ɕϊ�����܂��B
560

            
561
�܂��t�Ƀf�[�^��t�F�b�`����Ƃ��ɂ́A�f�[�^�x�[�X�̓�t�̃t�H�[�}�b�g��
562
�^�C���s�[�X�I�u�W�F�N�g�ɕϊ�����܂��B
563

            
564
    my $row = $resutl->fetch_hash_first;
565
    my $tp = $row->{issue_date};
566

            
567
���̂悤�Ȏ����I�Ɏ�s�����t�B���^��o�^�ł��邱�Ƃ�L<DBIx::Custom>��
568
����̂ЂƂ‚ł��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
569

            
update pod
Yuki Kimoto authored on 2011-01-28
570
C<apply_filter()>�œK�p���ꂽ�t�B���^�̓e�[�u�������܂ޗ񖼂ɑ΂��Ă�L��ł��B
571

            
572
    $dbi->select(
573
        table => 'book',
574
        where => {'book.title' => 'Perl', 'book.author' => 'Ken'}
575
    );
576

            
577
�e�[�u�����ʂ���K�v������Ƃ��ɕ֗��ȋ@�\�ł��B
578

            
579
=head3 �•ʂ̃t�B���^�̓K�p C<filter>
580

            
581
C<apply_filter()>��g��čŏ��ɂ��ׂẴe�[�u���̗�ɂ‚���
582
�t�B���^���`���邱�Ƃ�ł��܂����A
583
�•ʂɃt�B���^��K�p���邱�Ƃ�ł��܂��B
584
�•ʂ̃t�B���^��C<apply_filter()>�œK�p�����t�B���^��㏑���܂��B
585
�•ʂ̃t�B���^��SQL��as��g��āA��̕ʖ���쐬����K�v������ꍇ�Ɋ��􂵂܂��B
586

            
587
�f�[�^�x�[�X�ɑ��M����ꍇ�ɁA�•ʂ̃t�B���^��K�p����ɂ́A�e���\�b�h��
588
C<filter>�I�v�V������g�p���܂��B�•ʂ̃t�B���^�́AC<insert()>�AC<update()>�A
589
C<update_all()>�AC<delete()>�AC<delete_all()>�AC<select()>�AC<execute()>
590
�Ŏg�p���邱�Ƃ��ł��܂��B
591

            
592
C<insert()>�̗����܂��B
593

            
594
    $dbi->insert(
595
        table => 'book',
596
        param => {issue_date => $tp, first_issue_date => $tp},
597
        filter => {issue_date => 'tp_to_date', first_issue_date => 'tp_to_date'}
598
    );
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
599

            
update pod
Yuki Kimoto authored on 2011-01-28
600
C<execute()>�̗����܂��B
601

            
602
my $sql = <<"EOS";
603
select YEAR(issue_date) as issue_year
604
from book
605
where YEAR(issue_date) = {? issue_year}
606
EOS
607
   
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
608
    my $result = $dbi->execute(
update pod
Yuki Kimoto authored on 2011-01-28
609
        $sql,
610
        param => {issue_year => '2010'},
611
        filter => {issue_year => 'tp_to_year'}
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
612
    );
613

            
update pod
Yuki Kimoto authored on 2011-01-28
614
�����C<filter>��g���ǂ������ł��Bissue_date�̕ϊ��ɂ‚��Ă�C<apply_filter()>
615
�œo�^���Ă���̂ł����A�V�����쐬������ł���issue_year�ɂ‚��ẮA
616
���̕ϊ���o�^����Ă��܂���B�ł��̂ŁA�•ʂɃt�B���^��ݒ肵�Ă��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
617

            
update pod
Yuki Kimoto authored on 2011-01-28
618
�܂����΂ɍs��t�F�b�`����Ƃ��ɂ�•ʂ̃t�B���^��K�p���邱�Ƃ��ł��܂��B
619
�t�B���^��K�p����ɂ́A
620
C<DBIx::Custom::Result>�N���X��C<filter>���\�b�h��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
621

            
update pod
Yuki Kimoto authored on 2011-01-28
622
    $result->filter(issue_year => 'year_to_tp');
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
623

            
update pod
Yuki Kimoto authored on 2011-01-28
624
�p�ɂɗ��p����̂ł���΁A�•ʂɓo�^�������C<apply_filter()>�œo�^
625
���Ă������ق����֗��ł��傤�BC<apply_filter()>�͑��݂��Ȃ���ɑ΂��Ă�
626
�t�B���^��K�p�ł��邩��ł��B
627

            
628
    $dbi->apply_filter('book',
629
        'issue_year' => {out => 'tp_to_year', in => 'year_to_tp'}
630
    );
631

            
632
=head3 �ŏI�o�͂̂��߂̃t�B���^�����O C<end_filter()>
633

            
634
C<DBIx::Custom::Result>�ł͂���ɍŌ�ɂ���x�A�t�B���^��lj��
635
�o�^���邱�Ƃ��ł��܂��B���Ƃ���HTML�ɏo�͂������ꍇ�ɁATime::Piece
636
�I�u�W�F�N�g����ǂ݂₷���L�q�ɕϊ����邱�Ƃ��ł��܂��B
637
�Ō�̃t�B���^��o�^����ɂ́AC<end_filter()>��g�p���܂��B
638

            
639
    $result->end_filter(issue_date => sub {
640
        my $tp = shift;
641
        
642
        return '' unless $tp;
643
        return $tp->strftime('%Y/%m/%d %h:%m:%s (%a)');
644
    });
645

            
646
��t��₷���`�Ƀt�H�[�}�b�g���邱�Ƃ��ł��܂��B
647

            
648
�t�B���^�̓t�F�b�`��s���O�ɓo�^���Ă����K�v�����邱�Ƃ�
649
���ӂ��Ă��������B
650

            
651
    $result->filter(...);
652
    $result->end_filter(...);
653
    my $row = $result->fetch_hash_first;
654

            
655
=head3 ��̏���Ƀt�B���^��K�p���� C<each_column()>
656

            
657
��t�^�̗�͎蓮�Őݒ肵�Ȃ��Ă�A�����I�ɐݒ�ł���ƕ֗��ł��B
658
���̂��߂Ƀf�[�^�x�[�X�̃e�[�u���̗�̂��ׂĂ̏���
659
���Ԃɏ������邽�߂�C<each_column()>������܂��B
660

            
661
    $dbi->each_column(
662
        sub {
663
            my ($self, $table, $column, $info) = @_;
664
            
665
            my $type = $info->{TYPE_NAME};
666
            
667
            my $filter = $type eq 'DATE'     ? {out => 'tp_to_date', in => 'date_to_tp'}
668
                       : $type eq 'DATETIME' ? {out => 'tp_to_datetime', in => 'datetime_to_tp'}
669
                                             : undef;
670
            
671
            $self->apply_filter($table, $column, $filter)
672
              if $filter;
673
        }
674
    );
675

            
676
each_column�̓R�[���o�b�N��󂯎��܂��B�R�[���o�b�N�̈��
677
���Ԃ�L<DBIx::Custom>�I�u�W�F�N�g�A�e�[�u�����A�񖼁A��̏��ł��B
678
��̌^���̏����ƂɎ����I�ɁA�t�B���^��K�p���Ă��܂��B
679

            
680
�ЂƂ‚̒��ӓ_�Ƃ��ăR�[���o�b�N�̒�����A�R�[���o�b�N�̊O��
681
�̕ϐ���Q�Ƃ��Ȃ��悤�ɒ��ӂ��Ă��������Beach_column��
682
���X1�񂾂���s����邾���Ȃ̂ŁA�قƂ�ǂ̏ꍇ��肠��܂��񂪁A
683
�z�ŽQ�Ƃɂ�郁�������[�N���������Ă��܂��”\�����Ă��邩��ł��B
684

            
685
=head2 5. �^�O
686

            
687
=head3 �^�O�̋@�\
688

            
689
L<DBIx::Custom>��SQL�̒��Ƀ^�O�𖄂ߍ��ދ@�\���Ă��܂��B
690

            
691
    select * from book where {= title} and {like author};
692

            
693
{= title}��{like author}�̕������^�O�ł��B�^�O�͎��̂悤�Ȍ`��
694
����܂��B
695

            
696
    {�^�O�� ��1 ��2 ...}
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
697
    
update pod
Yuki Kimoto authored on 2011-01-28
698
�^�O��C<{>�Ŏn�܂�AC<}>�ŏI���܂��B�ŏ���C<{>�ƃ^�O���̊�
699
�ɂ͋󔒂�}��Ȃ��悤���ӂ��Ă��������B
700

            
701
�^�O�̋@�\�̂��߂�C<{>��C<}>�͗\���ɂȂ�Ă��܂��B
702
�����p�������ꍇ�͒��O��\����ăG�X�P�[�v��s���K�v������܂��B
703

            
704
    select from book \\{ ... \\}
705

            
706
C<\>���̂�Perl�̃G�X�P�[�v�����ł��̂ŁA
707
�G�X�P�[�v����ꍇ��C<\>����•K�v�ɂȂ�Ƃ����_�ɒ��ӂ��Ă��������B
708

            
709
��L�̃^�O��SQL����s�����O�Ɏ���SQL�ɓW�J����܂��B
710

            
711
    select * from book where title = ? and author like ?;
712

            
713
�^�O��܂�SQL���s����ɂ�C<execute()>��g�p���܂��B
714

            
715
    my $sql = "select * from book where {= author} and {like title};"
716
    $dbi->execute($sql, param => {title => 'Perl', author => '%Ken%'});
717

            
718
C<param>�I�v�V������g��āA�v���[�X�z���_�ɖ��ߍ��݂����l��
719
�n�b�V�����t�@�����X�Ŏw�肷�邱�Ƃ��ł��܂��B
720

            
721
���̃��\�b�h�Ɠ��l��C<execute()>�ɂ����Ă�C<filter>��w�肷�邱�Ƃ��ł��܂��B
722

            
723
    $dbi->execute($sql, param => {title => 'Perl', author => '%Ken%'}
724
                  filter => {title => 'to_something');
725

            
726
C<execute>�̂ЂƂ‚̒��ӓ_�Ƃ��Ă�C<apply_filter()>�œK�p���ꂽ�t�B���^
727
�̓f�t�H���g�ł͗L��ł͂Ȃ��Ƃ������Ƃɒ��ӂ��Ă��������B
728
C<apply_filter()>�œK�p���ꂽ�t�B���^��L��ɂ���ɂ́A
729
C<table>��w�肷��K�v������܂��B
730

            
731
    $dbi->execute($sql, param => {title => 'Perl', author => '%Ken%'}
732
                  table => ['book']);
733

            
update pod
Yuki Kimoto authored on 2011-01-31
734
=head3 �^�O�ꗗ
update pod
Yuki Kimoto authored on 2011-01-28
735

            
736
L<DBIx::Custom>�ł͎��̃^�O���g�p�”\�ł��B
737

            
738
���̂悤�Ƀ^�O��g���SQL����\������̂�L<DBIx::Custom>��
739
����ł��B�ȉ��̃^�O�����p�”\�ł��B
740

            
update pod
Yuki Kimoto authored on 2011-01-31
741
=head4 C<?>
update pod
Yuki Kimoto authored on 2011-01-28
742

            
743
C<?>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
744

            
745
    {? NAME}    ->   ?
746

            
update pod
Yuki Kimoto authored on 2011-01-31
747
=head4 C<=>
update pod
Yuki Kimoto authored on 2011-01-28
748

            
749
C<=>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
750

            
751
    {= NAME}    ->   NAME = ?
752

            
update pod
Yuki Kimoto authored on 2011-01-31
753
=head4 C<E<lt>E<gt>>
update pod
Yuki Kimoto authored on 2011-01-28
754

            
755
C<E<lt>E<gt>>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
756

            
757
    {<> NAME}   ->   NAME <> ?
758

            
update pod
Yuki Kimoto authored on 2011-01-31
759
=head4 C<E<lt>>
update pod
Yuki Kimoto authored on 2011-01-28
760

            
761
C<E<lt>>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
762

            
763
    {< NAME}    ->   NAME < ?
764

            
update pod
Yuki Kimoto authored on 2011-01-31
765
=head4 C<E<gt>>
update pod
Yuki Kimoto authored on 2011-01-28
766

            
767
C<E<gt>>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
768

            
769
    {> NAME}    ->   NAME > ?
770

            
update pod
Yuki Kimoto authored on 2011-01-31
771
=head4 C<E<gt>=>
update pod
Yuki Kimoto authored on 2011-01-28
772

            
773
C<E<gt>=>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
774

            
775
    {>= NAME}   ->   NAME >= ?
776

            
update pod
Yuki Kimoto authored on 2011-01-31
777
=head4 C<E<lt>=>
update pod
Yuki Kimoto authored on 2011-01-28
778

            
779
C<E<lt>=>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
780

            
781
    {<= NAME}   ->   NAME <= ?
782

            
update pod
Yuki Kimoto authored on 2011-01-31
783
=head4 C<like>
update pod
Yuki Kimoto authored on 2011-01-28
784

            
785
C<like>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
786

            
787
    {like NAME}   ->   NAME like ?
788

            
update pod
Yuki Kimoto authored on 2011-01-31
789
=head4 C<in>
update pod
Yuki Kimoto authored on 2011-01-28
790

            
791
C<in>�^�O�͈ȉ��̂悤�ɓW�J����܂��B�v���[�X�z���_��
792
�����Ŏw�肷��K�v�����邱�Ƃɒ��ӂ��Ă��������B
793

            
794
    {in NAME COUNT}   ->   NAME in [?, ?, ..]
795

            
update pod
Yuki Kimoto authored on 2011-01-31
796
=head4 C<insert_param>
update pod
Yuki Kimoto authored on 2011-01-28
797

            
798
C<insert_param>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
799

            
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
800
    {insert_param NAME1 NAME2}   ->   (NAME1, NAME2) values (?, ?)
update pod
Yuki Kimoto authored on 2011-01-28
801

            
update pod
Yuki Kimoto authored on 2011-01-31
802
=head4 C<update_param>
update pod
Yuki Kimoto authored on 2011-01-28
803

            
804
C<update_param>�^�O�͈ȉ��̂悤�ɓW�J����܂��B
805

            
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
806
    {update_param NAME1 NAME2}   ->   set NAME1 = ?, NAME2 = ?
807

            
update pod
Yuki Kimoto authored on 2011-01-31
808
=head3 �����̗�̈���
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
809

            
update pod
Yuki Kimoto authored on 2011-01-28
810
�����̗��܂ރ^�O������ꍇ�ɂ�ASQL���s���邱�Ƃ��ł��܂��B
811
���Ƃ��΁A��‚̓�t�Ŕ�r���Ȃ���΂Ȃ�Ȃ��ꍇ��
812
�l���Č��܂��傤�B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
813

            
update pod
Yuki Kimoto authored on 2011-01-28
814
    my $sql = "select * from table where {> date} and {< date};";
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
815

            
update pod
Yuki Kimoto authored on 2011-01-28
816
���̂悤�ȏꍇ�͑Ή�����p�����[�^�̒l��z��̃��t�@�����X�ɂ��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
817

            
update pod
Yuki Kimoto authored on 2011-01-28
818
    my $dbi->execute($sql, param => {date => ['2010-10-01', '2012-02-10']});
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
819

            
update pod
Yuki Kimoto authored on 2011-01-31
820
=head3 �^�O�̒lj� C<register_tag()>
update pod
Yuki Kimoto authored on 2011-01-28
821

            
822
L<DBIx::Custom>�ł̓^�O��Ǝ��ɒlj���邱�Ƃ��ł��܂��B
823
�^�O��lj����ɂ�C<register_tag()>��g�p���܂��B
824

            
825
    $dbi->register_tag(
826
        '=' => sub {
827
            my $column = shift;
828
            
829
            return ["$column = ?", [$column]];
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
830
        }
831
    );
832

            
update pod
Yuki Kimoto authored on 2011-01-28
833
�����ł̓f�t�H���g��C<=>�^�O���ǂ̂悤�Ɏ������Ă��邩����Ă��܂��B
834
�^�O��o�^����֐��̈�̓^�O�̒��ɏ����ꂽ��ɂȂ�܂��B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
835

            
update pod
Yuki Kimoto authored on 2011-01-28
836
    {�^�O�� ��1 ��2}
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
837

            
update pod
Yuki Kimoto authored on 2011-01-28
838
C<=>�^�O�̏ꍇ��
cleanup
Yuki Kimoto authored on 2011-01-12
839

            
update pod
Yuki Kimoto authored on 2011-01-28
840
    {= title}
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
841

            
update pod
Yuki Kimoto authored on 2011-01-28
842
�Ƃ����`���ł�����A�T�u���[�`���ɂ�title�Ƃ����ЂƂ‚̗񖼂��킽��Ă��܂��B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
843

            
update pod
Yuki Kimoto authored on 2011-01-28
844
�T�u���[�`���̖߂�l�ɂ͎��̌`���̔z��̃��t�@�����X��Ԃ��K�v������܂��B
845

            
846
    [
847
        �W�J��̕�����,
848
        [�v���[�X�z���_�ɖ��ߍ��݂ɗ��p�����1, ��2, ...]
849
    ]
850

            
851
��–ڂ̗v�f�͓W�J��̕�����ł��B���̗�ł�
852

            
853
    'title = ?'
854

            
855
��Ԃ��K�v������܂��B
856

            
857
��–ڂ̗v�f�̓v���[�X�z���_�ɖ��ߍ��݂ɗ��p����񖼂�܂ޔz���
858
���t�@�����X�ł��B����̗�ł�
859

            
860
    ['title']
861

            
862
��Ԃ��K�v������܂��B�����̃v���[�X�z���_��܂ޏꍇ�́A���̕�����
863
�����ɂȂ�܂��BC<insert_param>�^�O��C<update_param>�^�O��
864
���̕�������ە����ɂȂ�Ă��܂��B
865

            
866
��L��킹���
867

            
868
    ['title = ?', ['title']]
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
869
    
update pod
Yuki Kimoto authored on 2011-01-28
870
��Ԃ��K�v������Ƃ������Ƃł��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
871

            
update pod
Yuki Kimoto authored on 2011-01-28
872
�^�O�̎���̑��̃T���v����L<DBIx::Custom::Tag>�̃\�[�X�R�[�h
873
����ɂȂ�Ă݂Ă��������B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
874

            
update pod
Yuki Kimoto authored on 2011-01-28
875
=head2 6. Where��̓��I�Ȑ���
876

            
877
=head3 Where��̓��I�Ȑ��� where()
878

            
879
�����̌�����w�肵�āA�����s�������ꍇ������܂��B
880
����3�‚̃P�[�X��where���l���Ă݂܂��傤�B
881
���L�̂悤��where�傪�K�v�ɂȂ�܂��B
882

            
883
title�̒l�����Ō�������ꍇ
884

            
885
    where {= title}
886

            
887
author�̒l�����Ō�������ꍇ
888

            
889
    where {= author}
890

            
891
title��author�̗���̒l�Ō�������ꍇ
892

            
893
    where {= title} and {=author}
894

            
895
L<DBIx::Custom>�ł͓��I��Where��̐�����T�|�[�g���Ă��܂��B
896
�܂�C<where()>��L<DBIx::Custom::Where>�I�u�W�F�N�g�𐶐����܂��B
897

            
898
    my $where = $dbi->where;
899

            
900
����C<clause()>��g�p����where���L�q���܂��B
901

            
902
    $where->clause(
903
        ['and', '{= title'}, '{= author}']
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
904
    );
905

            
update pod
Yuki Kimoto authored on 2011-01-28
906
clause�̎w���@�͎��̂悤�ɂȂ�܂��B
907

            
908
    ['or' ���邢�� 'and', �^�O1, �^�O2, �^�O3]
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
909

            
update pod
Yuki Kimoto authored on 2011-01-28
910
����ɂ�or���邢��and��w�肵�܂��B����ȍ~�ɂ�
911
������^�O��g��ċL�q���܂��B
912

            
913
C<clause>�̎w��͓��q�ɂ��邱�Ƃ�ł��A����ɕ��G�ȏ�
914
��L�q���邱�Ƃ�ł��܂��B
915

            
916
    ['and', 
917
      '{= title}', 
918
      ['or', '{= author}', '{like date}']
919
    ]
920

            
921
���̂悤��C<clause>��ݒ肵�����C<param>�Ƀp�����[�^��w�肵�܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
922
    
update pod
Yuki Kimoto authored on 2011-01-28
923
    my $param => {title => 'Perl'};
924
    $where->param($param);
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
925

            
update pod
Yuki Kimoto authored on 2011-01-28
926
���̗�ł�title�������p�����[�^�Ɋ܂܂�Ă��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
927

            
update pod
Yuki Kimoto authored on 2011-01-28
928
���̌�C<to_string()>���s�����$param�Ɋ܂܂��p�����[�^�𖞂���
929
where��𐶐����邱�Ƃ��ł��܂��B
930

            
931
    my $where_clause = $where->to_string;
932

            
933
�p�����[�^��title�����ł��̂ŁA���̂悤��where�傪��������܂��B
934

            
935
    where {= title}
936

            
937
�܂�L<DBIx::Custom>�͕�����̕]����I�[�o�[���[�h���āAC<to_string()>
938
��Ăяo���悤�ɂ��Ă��܂��̂ŁA���̂悤�ɂ���where��𐶐����邱�Ƃ�
939
�ł��܂��B
940

            
941
    my $where_clause = "$where";
942

            
943
�����SQL�̒���where��𖄂ߍ��ނƂ��ɂƂĂ�𗧂‹@�\�ł��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
944

            
update pod
Yuki Kimoto authored on 2011-01-28
945
=head3 ����̗񖼂�܂ޏꍇ
check arguments of connect m...
Yuki Kimoto authored on 2010-12-20
946

            
update pod
Yuki Kimoto authored on 2011-01-28
947
�^�O�̒��ɓ���̖��O��‚�̂����݂����ꍇ�ł��I��
948
where���쐬���邱�Ƃ��ł��܂��B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
949

            
update pod
Yuki Kimoto authored on 2011-01-28
950
���Ƃ��΁A�p�����[�^�Ƃ��ĊJ�n��t�ƏI����t��󂯎������Ƃ�
951
�l���Ă݂Ă��������B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
952

            
update pod
Yuki Kimoto authored on 2011-01-28
953
    my $param = {start_date => '2010-11-15', end_date => '2011-11-21'};
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
954

            
update pod
Yuki Kimoto authored on 2011-01-28
955
�܂��J�n��t�ƏI����t�̕Е���A�ǂ����󂯎��Ȃ��ꍇ���邩����܂���B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
956

            
update pod
Yuki Kimoto authored on 2011-01-28
957
���̏ꍇ�͎��̂悤�ȃp�����[�^�ɕϊ����邱�ƂőΉ����邱�Ƃ��ł��܂��B
958

            
959
    my $p = {date => ['2010-11-15', '2011-11-21']};
960

            
961
�l���z��̃��t�@�����X�ɂȂ�Ă��邱�Ƃɒ��ڂ��Ă��������B���̂悤�ɂ����
962
�����̗��܂ރ^�O�ɏ��Ԃɖ��ߍ��ނ��Ƃ��ł��܂��B
963

            
964
    $where->clause(
965
        ['and', '{> date}', '{< date}']
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
966
    );
update pod
Yuki Kimoto authored on 2011-01-28
967
    $where->param($p);
968

            
969
�܂��J�n��t�����݂��Ȃ��ꍇ�͎��̂悤�ȃf�[�^��쐬���܂��B
970

            
971
    my $p = {date => [$dbi->not_exists, '2011-11-21']};
972

            
973
L<DBIx::Custom>��C<not_exists>��DBIx::Custom::NotExists�I�u�W�F�N�g��
974
�擾�ł��܂��B����͑Ή�����l�����݂��Ȃ����Ƃ�����߂̂�̂ł��B
975

            
976
�܂��I����t�����݂��Ȃ��ꍇ�͎��̂悤�ȃf�[�^��쐬���܂��B
977

            
978
    my $p = {date => ['2010-11-15']};
979

            
980
�ǂ�����݂��Ȃ��ꍇ�͎��̂悤�ȃf�[�^��쐬���܂��B
981

            
982
    my $p = {date => []};
983

            
984
��������̂ň�ԊȒP�ɍ쐬�ł��郍�W�b�N����Ă����܂��B
985

            
986
    my @date;
987
    push @date, exists $param->{start_date} ? $param->{start_date}
988
                                            : $dbi->not_exists;
989
    push @date, $param->{end_date} if exists $param->{end_date};
990
    my $p = {date => \@date};
991

            
992
=head3 C<select()>�Ƃ̘A�g
993

            
994
L<DBIx::Custom::Where>�I�u�W�F�N�g��
995
C<select()>��C<where>�ɒ��ړn�����Ƃ�
996
�ł��܂��B
997
    
998
    my $where = $dbi->where;
999
    $where->clause(...);
1000
    $where->param($param);
1001
    my $result = $dbi->select(table => 'book', where => $where);
1002

            
1003
���邢��C<update()>�AC<delete()>��where�Ɏw�肷�邱�Ƃ�”\�ł��B
1004

            
1005
=head3 C<execute()>�Ƃ̘A�g
1006

            
1007
C<execute()>�Ƃ̘A�g�ł��BSQL��쐬����Ƃ��ɖ��ߍ��ނ��Ƃ��ł��܂��B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1008

            
1009

            
update pod
Yuki Kimoto authored on 2011-01-28
1010
    my $where = $dbi->where;
1011
    $where->clause(...);
1012
    $where->param($param);
1013

            
1014
    my $sql = <<"EOS"
1015
    select * from book;
1016
    $where
1017
    EOS
1018

            
1019
    $dbi->execute($sql, param => $param);
1020

            
1021
=head2 7. �e�[�u�����f��
1022

            
1023
=head3 �e�[�u���I�u�W�F�N�g�̍쐬 C<table()>
1024

            
1025
L<DBIx::Custom>�̓��W�b�N�Ƃ��ăe�[�u���𒆐S�ɂ�����
1026
���f���̍쐬��x�����܂��B
1027

            
1028
�A�v���P�[�V�����̃��W�b�N��L�q����Ƃ��ɁA���̃��W�b�N��
1029
�f�[�^�x�[�X�̃e�[�u���ɂ����邱�Ƃ́ARDBMS�𗘗p����
1030
���f���ł���΁A�R�[�h�̏d�����Ȃ�
1031
�킩��₷����̂ɂȂ�܂��B
1032

            
1033
�e�[�u���I�u�W�F�N�g�𐶐�����ɂ�C<table()>��g�p���܂��B
1034

            
1035
    my $table = $dbi->table('book');
1036

            
1037
��ۂɃf�[�^�x�[�X�Ƀe�[�u���͑��݂��Ă���K�v�͂���܂���B
1038
����͉��z�I�ȃe�[�u���I�u�W�F�N�g�ł��B�����
1039
L<DBIx::Customm::Table>�I�u�W�F�N�g�ɂȂ�܂��B
1040

            
1041
�e�[�u���I�u�W�F�N�g�����C<insert()>�AC<update()>�AC<update_all()>�A
1042
C<delete()>�AC<delete_all()>�AC<select()>�Ȃǂ̃��\�b�h�Ăяo�����Ƃ��ł��܂��B
1043
L<DBIx::Custom>�ƈقȂ�Ƃ���́AC<table>��K������w�肷��K�v��
1044
�Ȃ��Ƃ������Ƃł��B
1045

            
1046
    $table->insert(param => $param);
1047

            
1048
C<table���̒l�͎����I��book�ɐݒ肳��܂��B
1049

            
1050
�܂��e�[�u���I�u�W�F�N�g�ɂ͓Ǝ��̃��\�b�h��lj���邱�Ƃ��ł��܂��B
1051

            
1052
    $table->method(
1053
        register => sub {
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1054
            my $self = shift;
update pod
Yuki Kimoto authored on 2011-01-28
1055
            my $table_name = $self->name;
1056
            # something
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1057
        },
update pod
Yuki Kimoto authored on 2011-01-28
1058
        list => sub {
1059
            my $self = shift;
1060
            my $table_name = $self->name;
1061
            # something
1062
        }
1063
    );
1064

            
1065
���\�b�h�ɓn���������L<DBIx::Custom::Table>�I�u�W�F�N�g�ł��B
1066
C<name()>��g�p���āA�e�[�u������擾���邱�Ƃ��ł��܂��B
1067

            
1068
���̂悤�ɂ��ēo�^�������\�b�h�͒��ڌĂяo�����Ƃ��ł��܂��B
1069

            
1070
    $table->register(...);
1071
    $table->list(...);
1072

            
1073
�܂��e�[�u����p�̃��\�b�h��I�[�o�[���C�h���č쐬���邱�Ƃ�ł��܂��B
1074

            
1075
    $table->method(
1076
        insert => sub {
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1077
            my $self = shift;
1078
            
update pod
Yuki Kimoto authored on 2011-01-28
1079
            $self->base_insert(...);
1080
            
1081
            # something
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1082
        }
1083
    );
1084

            
update pod
Yuki Kimoto authored on 2011-01-28
1085
��Ƃ�Ƒ��݂��Ă���C<insert()>��ĂԂɂ�C<base_$method>�Ƃ��܂��BL<DBIx::Custom::Table>
1086
�̃I�[�o�[���C�h�̋@�\�͊ȈՓI�Ȃ�̂ł����A�ƂĂ�֗��ł��B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1087

            
update pod
Yuki Kimoto authored on 2011-01-28
1088
=head2 �e�[�u���ŋ��L�̃��\�b�h�̓o�^
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1089

            
update pod
Yuki Kimoto authored on 2011-01-28
1090
���ׂẴe�[�u���Ń��\�b�h��L����ɂ�C<table>���\�b�h�Ńe�[�u����쐬����O�ɁA
1091
C<base_table>�Ƀ��\�b�h��o�^���Ă����܂��B
added experimental DBIx::Cus...
Yuki Kimoto authored on 2011-01-17
1092

            
update pod
Yuki Kimoto authored on 2011-01-28
1093
    $dbi->base_table->method(
1094
        count => sub {
1095
            my $self = shift;
1096
            return $self->select(column => ['count(*)']);
1097
        }
1098
    );
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1099

            
update pod
Yuki Kimoto authored on 2011-01-28
1100
�܂��e�[�u�������L<DBIx::Custom>��L<DBI>�̂��ׂẴ��\�b�h��Ăяo�����Ƃ��ł��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1101

            
update pod
Yuki Kimoto authored on 2011-01-28
1102
    # DBIx::Custom method
1103
    $table->execute($sql);
1104
    
1105
    # DBI method
1106
    $table->begin_work;
1107
    $table->commit;
1108

            
1109
=head2 ��ʓI�ȃ��f���̍\��
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1110

            
update pod
Yuki Kimoto authored on 2011-01-28
1111
��ʓI�ɂ́AL<DBIx::Custom>��p�����ăR���X�g���N�^�̒��ɁA���f����쐬
1112
����̂��悢�ł��傤�B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1113

            
update pod
Yuki Kimoto authored on 2011-01-28
1114
    package MyDBI;
1115
    
1116
    use base 'DBIx::Custom';
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1117
    
update pod
Yuki Kimoto authored on 2011-01-28
1118
    sub connect {
1119
        my $self = shift->SUPER::connect(@_);
1120
        
1121
        $self->base_table->method(
1122
            ... => sub { ... }
1123
        );
1124
        
1125
        $self->table('book')->method(
1126
            insert_multi => sub { ... },
1127
            ... => sub { ... }
1128
        );
1129
        
1130
        $self->table('company')->method(
1131
            ... => sub { ... },
1132
        );
1133
    }
1134

            
1135
���̂悤�ɂ��Ē�`���Ă����΁A���̂悤�ɗ��p���邱�Ƃ��ł��܂��B
1136

            
1137
    my $dbi = MyDBI->connect(...);
1138
    $dbi->table('book')->insert_multi(...);
1139

            
1140
=head2 8. �p�t�H�[�}���X�̉�P
1141

            
1142
=head3 �N�G���̍쐬
1143

            
1144
��C<insert()>���\�b�h��g�p���ăC���T�[�g���s�����ꍇ�A
1145
�K�v�ȃp�t�H�[�}���X�𓾂��Ȃ��ꍇ�����邩����܂���B
1146
C<insert()>���\�b�h�́ASQL���ƃX�e�[�g�����g�n���h����
1147
����쐬���邽�߂ł��B
1148

            
1149
���̂悤�ȏꍇ�́AC<query>�I�v�V������w�肷�邱�ƂŁA
1150
�N�G����擾���邱�Ƃ��ł��܂��B
1151

            
1152
    my $query = $dbi->insert(table => 'book', param => $param, query => 1);
1153

            
1154
�܂�C<create_query()>���\�b�h��g��ĔC�ӂ�SQL�̃N�G����쐬
1155
���邱�Ƃ�ł��܂��B
1156

            
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1157
    my $query = $dbi->create_query(
update pod
Yuki Kimoto authored on 2011-01-28
1158
        "insert into book {insert_param title author};";
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1159
    );
1160

            
update pod
Yuki Kimoto authored on 2011-01-28
1161
�߂�l��L<DBIx::Custom::Query>�I�u�W�F�N�g�ł��B
1162
���̃I�u�W�F�N�g��SQL���ƃp�����[�^�o�C���h���̗񖼂�
1163
�ێ����Ă��܂��B�܂��X�e�[�g�����g�n���h����ێ����Ă��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1164

            
1165
    {
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
1166
        sql     => 'insert into book (title, author) values (?, ?);',
update pod
Yuki Kimoto authored on 2011-01-28
1167
        columns => ['title', 'author'],
1168
        sth     => $sth
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1169
    }
1170

            
update pod
Yuki Kimoto authored on 2011-01-28
1171
�N�G���I�u�W�F�N�g��g��ČJ��Ԃ���s����ɂ�C<execute()>��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1172
    
remove DBIx::Custom::Model
Yuki Kimoto authored on 2011-01-12
1173
    my $params = [
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1174
        {title => 'Perl',      author => 'Ken'},
1175
        {title => 'Good days', author => 'Mike'}
1176
    ];
1177
    
update pod
Yuki Kimoto authored on 2011-01-28
1178
    foreach my $param (@$paramss) {
1179
        $dbi->execute($query, table => 'book', param => $input);
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1180
    }
1181

            
update pod
Yuki Kimoto authored on 2011-01-28
1182
C<execute>���\�b�h�̑���ɃN�G���I�u�W�F�g��n�����Ƃ��ł��܂��B
1183
C<insert()>���\�b�h�������ł��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1184

            
update pod
Yuki Kimoto authored on 2011-01-28
1185
���ӓ_�������‚�����܂��B����̓p�����[�^�̐��͕K�������łȂ��Ă͂Ȃ�Ȃ�
1186
�Ƃ������Ƃł��B�ŏ���3�‚̃p�����[�^������n�����̂ɁA���̎�s�ł�
1187
��‚̃p�����[�^��n���Ɨ\��Ȃ����ʂɂȂ�܂��B�����
1188
���I�ɐ������ꂽSQL�Ɋ܂܂��v���[�X�z���_�̐����قȂ邩��ł��B
1189
�܂�C<execute()>�ɂ��Ă͎����I�ɂ̓t�B���^���L��ɂȂ�Ȃ��̂ŁA
1190
C<table>��w�肷��K�v�̂��邱�Ƃɒ��ӂ��Ă��������B
1191
�{���ɕK�v�ȏꍇ�������p���Ă��������B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1192

            
update pod
Yuki Kimoto authored on 2011-01-28
1193
=head2 9. ���̑��̋@�\
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1194

            
update pod
Yuki Kimoto authored on 2011-01-28
1195
=head3 ���\�b�h�̓o�^
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1196

            
update pod
Yuki Kimoto authored on 2011-01-28
1197
���\�b�h��o�^����ɂ�C<method()>��g�p���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1198

            
update pod
Yuki Kimoto authored on 2011-01-28
1199
    $dbi->method(
1200
        update_or_insert => sub {
1201
            my $self = shift;
1202
            # something
1203
        },
1204
        find_or_create   => sub {
1205
            my $self = shift;
1206
            # something
1207
        }
1208
    );
1209

            
1210
<method()>�œo�^�������\�b�h��
1211
L<DBIx::Custom>�I�u�W�F�N�g���璼�ڌĂяo�����Ƃ��ł��܂��B
1212

            
1213
    $dbi->update_or_insert;
1214
    $dbi->find_or_create;
1215

            
1216
=head3 ���ʃN���X�̕ύX
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1217

            
update pod
Yuki Kimoto authored on 2011-01-28
1218
�K�v�Ȃ�Ό��ʃN���X��ύX���邱�Ƃ��ł��܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1219

            
update pod
Yuki Kimoto authored on 2011-01-28
1220
    package MyResult;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1221
    use base 'DBIx::Custom::Result';
1222
    
1223
    sub some_method { ... }
1224

            
1225
    1;
1226
    
1227
    package main;
1228
    
update pod
Yuki Kimoto authored on 2011-01-28
1229
    use MyResult;
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1230
    
1231
    my $dbi = DBIx::Custom->connect(...);
update pod
Yuki Kimoto authored on 2011-01-28
1232
    $dbi->result_class('MyResult');
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1233

            
update pod
Yuki Kimoto authored on 2011-01-28
1234
=head3 �L���b�V���O
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1235

            
update pod
Yuki Kimoto authored on 2011-01-28
1236
�^�O�̓W�J���SQL�̓p�t�H�[�}���X�̗��R�̂��߂ɃL���b�V������܂��B
1237
�����C<chace>�Őݒ�ł��A�f�t�H���g�ł̓L���b�V����s���ݒ�ł��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1238

            
update pod
Yuki Kimoto authored on 2011-01-28
1239
    $dbi->cache(1);
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1240

            
update pod
Yuki Kimoto authored on 2011-01-28
1241
�L���b�V����@��C<cache_method>�Ƀ��\�b�h��w�肷�邱�Ƃ�
1242
�ύX���邱�Ƃ��ł��܂��B
1243
�f�[�^�̕ۑ��Ǝ擾�̂��߂̃��\�b�h���`���܂��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1244

            
update pod
Yuki Kimoto authored on 2011-01-28
1245
�f�t�H���g�ł͎��̂悤�Ƀ�������ɃL���b�V����s����̂ɂȂ�Ă��܂��B
1246

            
1247
    $dbi->cache_method(sub {
1248
        sub {
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1249
            my $self = shift;
update pod
Yuki Kimoto authored on 2011-01-28
1250
            
1251
            $self->{_cached} ||= {};
1252
            
1253
            if (@_ > 1) {
1254
                # Set
1255
                $self->{_cached}{$_[0]} = $_[1] 
1256
            }
1257
            else {
1258
                # Get
1259
                return $self->{_cached}{$_[0]}
1260
            }
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1261
        }
update pod
Yuki Kimoto authored on 2011-01-28
1262
    });
1263
    
1264
����L<DBIx::Custom>�I�u�W�F�N�g�ł��B
1265
����̓^�O�̓W�J�����O��SQL�ł��B
1266
��O��̓^�O�̓W�J���SQL�ł��B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1267

            
update pod
Yuki Kimoto authored on 2011-01-28
1268
�����ō쐬����ꍇ�͑�O�����݂����ꍇ�̓L���b�V����ݒ肵�A
1269
���݂��Ȃ�����ꍇ�̓L���b�V����擾��������
1270
�����������B
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1271

            
update pod
Yuki Kimoto authored on 2011-01-28
1272
=cut
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1273

            
pod fix
Yuki Kimoto authored on 2011-01-21
1274
=head1 EXAMPLES
1275

            
1276
L<DBIx::Custom Wiki|https://github.com/yuki-kimoto/DBIx-Custom/wiki> - Many useful examples
add examples
Yuki Kimoto authored on 2011-01-07
1277

            
added DBIx::Custom::Guides
yuki-kimoto authored on 2010-10-17
1278
=cut