DBIx-Custom / DBIx-Custom-0.0501 / blib / libdoc / DBIx::Custom::SQLite.3pm /
Newer Older
229 lines | 6.387kb
packaging one directory
yuki-kimoto authored on 2009-11-16
1
.\" Automatically generated by Pod::Man v1.37, Pod::Parser v1.32
2
.\"
3
.\" Standard preamble:
4
.\" ========================================================================
5
.de Sh \" Subsection heading
6
.br
7
.if t .Sp
8
.ne 5
9
.PP
10
\fB\\$1\fR
11
.PP
12
..
13
.de Sp \" Vertical space (when we can't use .PP)
14
.if t .sp .5v
15
.if n .sp
16
..
17
.de Vb \" Begin verbatim text
18
.ft CW
19
.nf
20
.ne \\$1
21
..
22
.de Ve \" End verbatim text
23
.ft R
24
.fi
25
..
26
.\" Set up some character translations and predefined strings.  \*(-- will
27
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
28
.\" double quote, and \*(R" will give a right double quote.  | will give a
29
.\" real vertical bar.  \*(C+ will give a nicer C++.  Capital omega is used to
30
.\" do unbreakable dashes and therefore won't be available.  \*(C` and \*(C'
31
.\" expand to `' in nroff, nothing in troff, for use with C<>.
32
.tr \(*W-|\(bv\*(Tr
33
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
34
.ie n \{\
35
.    ds -- \(*W-
36
.    ds PI pi
37
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
38
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
39
.    ds L" ""
40
.    ds R" ""
41
.    ds C` ""
42
.    ds C' ""
43
'br\}
44
.el\{\
45
.    ds -- \|\(em\|
46
.    ds PI \(*p
47
.    ds L" ``
48
.    ds R" ''
49
'br\}
50
.\"
51
.\" If the F register is turned on, we'll generate index entries on stderr for
52
.\" titles (.TH), headers (.SH), subsections (.Sh), items (.Ip), and index
53
.\" entries marked with X<> in POD.  Of course, you'll have to process the
54
.\" output yourself in some meaningful fashion.
55
.if \nF \{\
56
.    de IX
57
.    tm Index:\\$1\t\\n%\t"\\$2"
58
..
59
.    nr % 0
60
.    rr F
61
.\}
62
.\"
63
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
64
.\" way too many mistakes in technical documents.
65
.hy 0
66
.if n .na
67
.\"
68
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
69
.\" Fear.  Run.  Save yourself.  No user-serviceable parts.
70
.    \" fudge factors for nroff and troff
71
.if n \{\
72
.    ds #H 0
73
.    ds #V .8m
74
.    ds #F .3m
75
.    ds #[ \f1
76
.    ds #] \fP
77
.\}
78
.if t \{\
79
.    ds #H ((1u-(\\\\n(.fu%2u))*.13m)
80
.    ds #V .6m
81
.    ds #F 0
82
.    ds #[ \&
83
.    ds #] \&
84
.\}
85
.    \" simple accents for nroff and troff
86
.if n \{\
87
.    ds ' \&
88
.    ds ` \&
89
.    ds ^ \&
90
.    ds , \&
91
.    ds ~ ~
92
.    ds /
93
.\}
94
.if t \{\
95
.    ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
96
.    ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
97
.    ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
98
.    ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
99
.    ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
100
.    ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
101
.\}
102
.    \" troff and (daisy-wheel) nroff accents
103
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
104
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
105
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
106
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
107
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
108
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
109
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
110
.ds ae a\h'-(\w'a'u*4/10)'e
111
.ds Ae A\h'-(\w'A'u*4/10)'E
112
.    \" corrections for vroff
113
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
114
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
115
.    \" for low resolution devices (crt and lpr)
116
.if \n(.H>23 .if \n(.V>19 \
117
\{\
118
.    ds : e
119
.    ds 8 ss
120
.    ds o a
121
.    ds d- d\h'-1'\(ga
122
.    ds D- D\h'-1'\(hy
123
.    ds th \o'bp'
124
.    ds Th \o'LP'
125
.    ds ae ae
126
.    ds Ae AE
127
.\}
128
.rm #[ #] #H #V #F C
129
.\" ========================================================================
130
.\"
131
.IX Title "DBIx::Custom::SQLite 3"
132
.TH DBIx::Custom::SQLite 3 "2009-11-16" "perl v5.8.8" "User Contributed Perl Documentation"
133
.SH "NAME"
134
DBIx::Custom::SQLite \- DBIx::Custom SQLite implementation
135
.SH "Version"
136
.IX Header "Version"
137
Version 0.0201
138
.SH "Synopsys"
139
.IX Header "Synopsys"
140
.Vb 1
141
\&    use DBIx::Custom::SQLite;
142
.Ve
143
.PP
144
.Vb 3
145
\&    # New
146
\&    my $dbi = DBIx::Custom::SQLite->new(user => 'taro', $password => 'kliej&@K',
147
\&                                       database => 'sample.db');
148
.Ve
149
.PP
150
.Vb 2
151
\&    # Insert 
152
\&    $dbi->insert('books', {title => 'perl', author => 'taro'});
153
.Ve
154
.PP
155
.Vb 3
156
\&    # Update 
157
\&    # same as 'update books set (title = 'aaa', author = 'ken') where id = 5;
158
\&    $dbi->update('books', {title => 'aaa', author => 'ken'}, {id => 5});
159
.Ve
160
.PP
161
.Vb 2
162
\&    # Delete
163
\&    $dbi->delete('books', {author => 'taro'});
164
.Ve
165
.PP
166
.Vb 2
167
\&    # select * from books;
168
\&    $dbi->select('books');
169
.Ve
170
.PP
171
.Vb 2
172
\&    # select * from books where ahthor = 'taro'; 
173
\&    $dbi->select('books', {author => 'taro'});
174
.Ve
175
.PP
176
.Vb 2
177
\&    # select author, title from books where author = 'taro'
178
\&    $dbi->select('books', [qw/author title/], {author => 'taro'});
179
.Ve
180
.PP
181
.Vb 3
182
\&    # select author, title from books where author = 'taro' order by id limit 1;
183
\&    $dbi->select('books', [qw/author title/], {author => 'taro'},
184
\&                 'order by id limit 1');
185
.Ve
186
.SH "See DBIx::Custom and DBI::Custom::Basic documentation"
187
.IX Header "See DBIx::Custom and DBI::Custom::Basic documentation"
188
This class is DBIx::Custom::Basic subclass.
189
and DBIx::Custom::Basic is DBIx::Custom subclass
190
.PP
191
You can use all methods of DBIx::Custom::Basic and <DBIx::Custom>
192
Please see DBIx::Custom::Basic and <DBIx::Custom> documentation
193
.SH "Object methods"
194
.IX Header "Object methods"
195
.Sh "connect"
196
.IX Subsection "connect"
197
This override DBIx::Custom connect.
198
.PP
199
.Vb 2
200
\&    # Connect to database
201
\&    $dbi->connect;
202
.Ve
203
.PP
204
If database attribute is set, automatically data source is created and connect
205
.Sh "connect_memory"
206
.IX Subsection "connect_memory"
207
.Vb 2
208
\&    # Connect memory database
209
\&    $self = $dbi->connect_memory;
210
.Ve
211
.Sh "reconnect_memory"
212
.IX Subsection "reconnect_memory"
213
.Vb 2
214
\&    # Reconnect memory database
215
\&    $self = $dbi->reconnect_memory;
216
.Ve
217
.SH "Author"
218
.IX Header "Author"
219
Yuki Kimoto, \f(CW\*(C`<kimoto.yuki at gmail.com>\*(C'\fR
220
.PP
221
Github <http://github.com/yuki\-kimoto>
222
.PP
223
I develope this module <http://github.com/yuki\-kimoto/DBIx\-Custom>
224
.SH "Copyright & lisence"
225
.IX Header "Copyright & lisence"
226
Copyright 2009 Yuki Kimoto, all rights reserved.
227
.PP
228
This program is free software; you can redistribute it and/or modify it
229
under the same terms as Perl itself.