1POE::Component::SimpleDUBsIe(r3pCmo)ntributed Perl DocumPeOnEt:a:tCioomnponent::SimpleDBI(3pm)
2
6 POE::Component::SimpleDBI - Asynchronous non-blocking DBI calls in POE
7 made simple
8
10 This document describes v1.31 of POE::Component::SimpleDBI - released November 05, 2014 as part of POE-Component-SimpleDBI.
11
13 use POE;
14 use POE::Component::SimpleDBI;
15 # Create a new session with the alias we want
17 POE::Component::SimpleDBI->new( 'SimpleDBI' ) or die 'Unable to create the DBI session';
18 # Create our own session to communicate with SimpleDBI
20 POE::Session->create(
21 inline_states => {
22 _start => sub {
23 # Tell SimpleDBI to connect
24 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT',
25 'DSN' => 'DBI:mysql:database=foobaz;host=192.168.1.100;port=3306',
26 'USERNAME' => 'FooBar',
27 'PASSWORD' => 'SecretPassword',
28 'EVENT' => 'conn_handler',
29 );
30 # Execute a query and return number of rows affected
32 $_[KERNEL]->post( 'SimpleDBI', 'DO',
33 'SQL' => 'DELETE FROM FooTable WHERE ID = ?',
34 'PLACEHOLDERS' => [ qw( 38 ) ],
35 'EVENT' => 'deleted_handler',
36 'INSERT_ID' => 0,
37 );
38 # Retrieve one row of information
40 $_[KERNEL]->post( 'SimpleDBI', 'SINGLE',
41 'SQL' => 'Select * from FooTable LIMIT 1',
42 'EVENT' => 'success_handler',
43 'BAGGAGE' => 'Some Stuff I want to keep!',
44 );
45 # We want many rows of information + get the query ID so we can delete it later
47 # Furthermore, disable prepare_cached on this query
48 my $id = $_[KERNEL]->call( 'SimpleDBI', 'MULTIPLE',
49 'SQL' => 'SELECT foo, baz FROM FooTable2 WHERE id = ?',
50 'PLACEHOLDERS' => [ qw( 53 ) ],
51 'EVENT' => 'multiple_handler',
52 'PREPARE_CACHED'=> 0,
53 );
54 # Quote something and send it to another session
56 $_[KERNEL]->post( 'SimpleDBI', 'QUOTE',
57 'SQL' => 'foo$*@%%sdkf"""',
58 'SESSION' => 'OtherSession',
59 'EVENT' => 'quote_handler',
60 );
61 # Changed our mind!
63 $_[KERNEL]->post( 'SimpleDBI', 'Delete_Query', $id );
64 # 3 ways to shutdown
66 # This will let the existing queries finish, then shutdown
68 $_[KERNEL]->post( 'SimpleDBI', 'shutdown' );
69 # This will terminate when the event traverses
71 # POE's queue and arrives at SimpleDBI
72 $_[KERNEL]->post( 'SimpleDBI', 'shutdown', 'NOW' );
73 # Even QUICKER shutdown :)
75 $_[KERNEL]->call( 'SimpleDBI', 'shutdown', 'NOW' );
76 },
77 # Define your request handlers here
79 'quote_handler' => \&FooHandler,
80 # And so on
81 },
82 );
83
85 This module simplifies DBI usage in POE's multitasking world.
86 This module is a breeze to use, you'll have DBI calls in your POE
88 program up and running in only a few seconds of setup.
89 This module does what XML::Simple does for the XML world.
91 This module works its magic by creating a new session with POE, then
93 spawning off a child process to do the "heavy" lifting. That way, your
94 main POE process can continue servicing other clients. Queries are put
95 into a queue, and processed one at a time.
96 The standard way to use this module is to do this:
98 use POE;
100 use POE::Component::SimpleDBI;
101 POE::Component::SimpleDBI->new( ... );
103 POE::Session->create( ... );
105 POE::Kernel->run();
107 Starting SimpleDBI
109 To start SimpleDBI, just call it's new method:
110 POE::Component::SimpleDBI->new( 'ALIAS' );
112 This method will die on error or return success.
114 NOTE: The act of starting/stopping SimpleDBI fires off _child events,
116 read the POE documentation on what to do with them :)
117 This constructor accepts only 3 arguments.
119 Alias
121 This sets the session alias in POE.
123 The default is "SimpleDBI".
125 PREPARE_CACHED
127 This sets the global PREPARE_CACHED setting. This is a boolean value.
129 POE::Component::SimpleDBI->new( 'ALIAS', 0 );
131 The default is enabled.
133 SYNCHRONOUS_MODE
135 This disables the fork() that the subprocess does. Use this only if you
137 are having issues with the backend and want to debug the database
138 without dealing with multiprocess issues.
139 POE::Component::SimpleDBI->new( 'ALIAS', 1, 1 );
141 The default is disabled.
143 Commands
145 There are a few commands you can trigger in SimpleDBI. They are
146 triggered via $_[KERNEL]->post( ... );
147 ID
149 All of the commands except for Delete_Query and shutdown return an id.
151 To get them, do this: my $id = $_[KERNEL]->call( 'SimpleDBI', ...
152 );
153 Afterwards, the id can be used to delete queries, look at Delete_Query
155 for more information.
156 Argument errors
158 All of the commands validate their arguments, and if an error happens (
160 missing argument, etc ), they will do either: - return undef and
161 forget that your request even existed - post to the SESSION/EVENT
162 with ERROR present in the data NOTE: The data will not have
163 an ID key present
164 Explanation of DO/SINGLE/MULTIPLE/QUOTE arguments
166 They are passed in via the $_[KERNEL]->post( ... );
168 NOTE: Capitalization is very important!
170 "SQL"
172 This is the actual SQL line you want SimpleDBI to execute. You can
173 put in placeholders, this module supports them.
174 "PLACEHOLDERS"
176 This is an array of placeholders.
177 You can skip this if your query does not utilize it.
179 "SESSION"
181 This is the session that will get the result
182 You can skip this, it defaults to the sending session
184 "EVENT"
186 This is the event, triggered whenever a query finished.
187 It will get a hash in ARG0, consult the specific queries on what
189 you will get.
190 NOTE: If the key 'ERROR' exists in the hash, then it will contain
192 the error string.
193 "BAGGAGE"
195 This is a special argument, you can "attach" any kind of baggage to
196 a query. The baggage will be kept by SimpleDBI and returned to the
197 Event handler intact.
198 This is good for storing data associated with a query like a client
200 object, etc.
201 You can skip this if your query does not utilize it.
203 "PREPARE_CACHED"
205 This was added recently, to override SimpleDBI's default behavior
206 of using the $dbh->prepare_cached() function. Setting this to false
207 will use $dbh->prepare() instead.
208 Some users reported problems with PostgreSQL. After investigation,
210 this turned out to be some bizarre OID caching issues when the
211 table was updated while the connection is alive. The quick work-
212 around is to reconnect to the database, but this was not a "sane"
213 solution.
214 This is a simple boolean value, and if this argument does not
216 exist, SimpleDBI will use the global setting when calling new().
217 "INSERT_ID"
219 This was added recently, to override SimpleDBI's default behavior
220 of using the $dbh->last_insert_id() function. Setting this to false
221 will disable retrieval of this value.
222 This is a simple boolean value, and if this argument does not
224 exist, SimpleDBI will default to true.
225 "CONNECT"
227 This tells SimpleDBI to connect to the database. NOTE: if we are
229 already connected, it will be a success ( SimpleDBI will not disconnect
230 then connect automatically ). Accepted arguments:
231 DSN -> The DBI DSN string, consult the DBI docs on what this is
233 USERNAME -> The username for the connection
234 PASSWORD -> The password for the connection
235 SESSION -> The session to send the results
236 EVENT -> The event to send the results
237 NOW -> Tells SimpleDBI to bypass the queue and connect NOW!
238 CLEAR -> Tells SimpleDBI to clear the queue and connect NOW!
239 AUTO_COMMIT -> The boolean value we will pass to DBI->connect ( defaults to true )
240 CACHEDKIDS -> Controls the method to cache prepare_cached queries, an arrayref ( defaults to undef )
241 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
242 NOTE: if the DSN/USERNAME/PASSWORD/SESSION/EVENT does not exist,
244 SimpleDBI assumes you wanted to use the old connection and will use the
245 cached values ( if you told it to DISCONNECT ). Here's an example on
246 how to trigger this event:
247 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT',
249 'DSN' => 'DBI:mysql:database=foobaz;host=192.168.1.100;port=3306',
250 'USERNAME' => 'MyUser',
251 'PASSWORD' => 'MyPassword',
252 'EVENT' => 'conn_handler',
253 'NOW' => 1,
254 );
255 The NOW/CLEAR arguments are special, they will tell SimpleDBI to bypass
257 the request queue and connect NOW... The CLEAR argument will also
258 delete all the requests waiting in the queue, they will get an ERROR
259 result. They both default to false, supply a boolean value to turn
260 them on. The Event handler will get a hash in ARG0:
261 {
263 'ERROR' => exists only if an error occured
264 'GONE' => exists only if the server was disconnected and the reconnect failed
265 'ACTION' => 'CONNECT'
266 'ID' => ID of the Query
267 'EVENT' => The event the query will respond to
268 'SESSION' => The session the query will respond to
269 }
270 # NOTE: You can do nifty things like this. They all will be executed in the right order!
272 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT', 'DSN' => 'DBI:mysql:...', ... );
273 $_[KERNEL]->post( 'SimpleDBI', 'DO', ... );
274 $_[KERNEL]->post( 'SimpleDBI', 'SINGLE', ... );
275 $_[KERNEL]->post( 'SimpleDBI', 'DISCONNECT' );
276 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT', 'DSN' => 'DBI:oracle:...', ... );
277 $_[KERNEL]->post( 'SimpleDBI', 'MULTIPLE', ... );
278 $_[KERNEL]->post( 'SimpleDBI', 'shutdown' );
279 As of 1.11 SimpleDBI now detects whether the backend lost the
281 connection to the database server. The backend will automatically
282 reconnect if it happens, but if that fails, an error will be sent to
283 the session/event specified here with an extra key: 'GONE'. In this
284 state SimpleDBI is deadlocked, any new queries will not be processed
285 until a CONNECT NOW event is issued! Keep in mind the SINGLE/etc
286 queries WILL NOT receive an error if this happens, the error goes
287 straight to the CONNECT handler to keep it simple!
288 As of 1.29 SimpleDBI added better control of the prepare_cached cache.
290 Some users reported that the subprocess' memory usage was leaking, and
291 in extreme cases reached several gigs! Upon investigation, it was not
292 SimpleDBI's fault but the way DBI works. What DBI does is cache the
293 statement handle from $dbh->prepare_cached in the $dbh handle. The
294 problem is that it stays around forever in the default implementation!
295 Perusing the DBI docs revealed that it was possible to tie this cache
296 to a custom cache module. So I've added the CACHEDKIDS argument, and
297 setting it to an arrayref will enable the behavior. Look at
298 <http://search.cpan.org/dist/DBI/DBI.pm#prepare_cached> for more
299 information. Here's an example:
300 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT', ..., 'CACHEDKIDS' => [ 'Tie::Cache::LRU' ] );
302 The first element in the array is the module to use when tying the
304 cache. Any additional elements are passed to the module's constructor.
305 Please look at the docs for your favorite cache module! If users report
306 success with this, in a future version of SimpleDBI it might become the
307 default behavior. Keep in mind that this will be redundant if
308 PREPARE_CACHED == 0.
309 "DISCONNECT"
311 This tells SimpleDBI to disconnect from the database. NOTE: In the case
313 that a DISCONNECT is issued when we are not connected, it will still
314 succeed! Accepted arguments:
315 SESSION -> The session to send the results
317 EVENT -> The event to send the results
318 NOW -> Tells SimpleDBI to bypass the queue and disconnect NOW!
319 CLEAR -> Tells SimpleDBI to clear the queue and disconnect NOW!
320 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
321 Here's an example on how to trigger this event:
323 $_[KERNEL]->post( 'SimpleDBI', 'DISCONNECT',
325 'EVENT' => 'disconn_handler',
326 'NOW' => 1,
327 );
328 The NOW/CLEAR arguments are special, they will tell SimpleDBI to bypass
330 the request queue and connect NOW. The CLEAR argument will also delete
331 all the requests waiting in the queue, they will get an ERROR result.
332 They both default to false, supply a boolean value to turn them on. The
333 Event handler will get a hash in ARG0:
334 {
336 'ERROR' => exists only if an error occured
337 'ACTION' => 'DISCONNECT'
338 'ID' => ID of the Query
339 'EVENT' => The event the query will respond to
340 'SESSION' => The session the query will respond to
341 }
342 # BEWARE: There is the possibility of a deadlock! In this case, the DO/SINGLE queries will
344 # NEVER run until you issue a CONNECT with NOW enabled at the end!
345 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT', ... );
346 $_[KERNEL]->post( 'SimpleDBI', 'MULTIPLE', ... );
347 $_[KERNEL]->post( 'SimpleDBI', 'DISCONNECT' );
348 $_[KERNEL]->post( 'SimpleDBI', 'DO', ... );
349 $_[KERNEL]->post( 'SimpleDBI', 'SINGLE', ... );
350 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT' );
351 "QUOTE"
353 This simply sends off a string to be quoted, and gets it back. Accepted
355 arguments:
356 SESSION -> The session to send the results
358 EVENT -> The event to send the results
359 SQL -> The string to be quoted
360 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
361 Internally, it does something like this:
363 return $dbh->quote( $SQL );
365 Here's an example on how to trigger this event:
367 $_[KERNEL]->post( 'SimpleDBI', 'QUOTE',
369 SQL => 'foo$*@%%sdkf"""',
370 EVENT => 'quote_handler',
371 );
372 The Event handler will get a hash in ARG0:
374 {
376 'ERROR' => exists only if an error occured
377 'ACTION' => 'QUOTE'
378 'ID' => ID of the Query
379 'EVENT' => The event the query will respond to
380 'SESSION' => The session the query will respond to
381 'SQL' => Original SQL inputted
382 'RESULT' => The quoted SQL
383 'PLACEHOLDERS' => Original placeholders ( may not exist if it was not provided )
384 'BAGGAGE' => whatever you set it to ( may not exist if it was not provided )
385 }
386 "DO"
388 This query is specialized for those queries where you
390 UPDATE/DELETE/INSERT/etc. THIS IS NOT FOR SELECT QUERIES! Accepted
391 arguments:
392 SESSION -> The session to send the results
394 EVENT -> The event to send the results
395 SQL -> The string to be quoted
396 PLACEHOLDERS -> Any placeholders ( if needed )
397 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
398 PREPARE_CACHED -> Boolean value ( if needed )
399 INSERT_ID -> Boolean value ( if needed )
400 Internally, it does something like this:
402 $sth = $dbh->prepare_cached( $SQL );
404 $rows_affected = $sth->execute( $PLACEHOLDERS );
405 return $rows_affected;
406 Here's an example on how to trigger this event:
408 $_[KERNEL]->post( 'SimpleDBI', 'DO',
410 SQL => 'DELETE FROM FooTable WHERE ID = ?',
411 PLACEHOLDERS => [ 38 ],
412 EVENT => 'deleted_handler',
413 );
414 The Event handler will get a hash in ARG0:
416 {
418 'ERROR' => exists only if an error occured
419 'ACTION' => 'DO'
420 'ID' => ID of the Query
421 'EVENT' => The event the query will respond to
422 'SESSION' => The session the query will respond to
423 'SQL' => Original SQL inputted
424 'RESULT' => Scalar value of rows affected
425 'PLACEHOLDERS' => Original placeholders ( may not exist if it was not provided )
426 'BAGGAGE' => whatever you set it to ( may not exist if it was not provided )
427 'INSERTID' => The insert ID - using $dbh->last_insert_id( undef, undef, undef, undef ) [ defaults to undef ]
428 }
429 "SINGLE"
431 This query is specialized for those queries where you will get exactly
433 1 result back. Accepted arguments:
434 SESSION -> The session to send the results
436 EVENT -> The event to send the results
437 SQL -> The string to be quoted
438 PLACEHOLDERS -> Any placeholders ( if needed )
439 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
440 PREPARE_CACHED -> Boolean value ( if needed )
441 Internally, it does something like this:
443 $sth = $dbh->prepare_cached( $SQL );
445 $sth->execute( $PLACEHOLDERS );
446 $result = $sth->fetchrow_hashref;
447 return $result;
448 Here's an example on how to trigger this event:
450 $_[KERNEL]->post( 'SimpleDBI', 'SINGLE',
452 SQL => 'Select * from FooTable',
453 EVENT => 'success_handler',
454 SESSION => 'MySession',
455 );
456 The Event handler will get a hash in ARG0:
458 {
460 'ERROR' => exists only if an error occured
461 'ACTION' => 'SINGLE'
462 'ID' => ID of the Query
463 'EVENT' => The event the query will respond to
464 'SESSION' => The session the query will respond to
465 'SQL' => Original SQL inputted
466 'RESULT' => Hash of columns - similar to fetchrow_hashref ( undef if no rows returned )
467 'PLACEHOLDERS' => Original placeholders ( may not exist if it was not provided )
468 'BAGGAGE' => whatever you set it to ( may not exist if it was not provided )
469 }
470 "MULTIPLE"
472 This query is specialized for those queries where you will get more
474 than 1 result back.
475 WARNING! The column names are all lowercased automatically! WARNING!
477 Accepted arguments:
479 SESSION -> The session to send the results
481 EVENT -> The event to send the results
482 SQL -> The string to be quoted
483 PLACEHOLDERS -> Any placeholders ( if needed )
484 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
485 PREPARE_CACHED -> Boolean value ( if needed )
486 Internally, it does something like this:
488 $sth = $dbh->prepare_cached( $SQL );
490 $sth->execute( $PLACEHOLDERS );
491 $sth->bind_columns( \( @$newdata{ @{ $sth->{'NAME_lc'} } } ) );
492 while ( $sth->fetch() ) {
493 push( @results, { @$newdata } );
494 }
495 return \@results;
496 Here's an example on how to trigger this event:
498 $_[KERNEL]->post( 'SimpleDBI', 'MULTIPLE',
500 SQL => 'SELECT foo, baz FROM FooTable2 WHERE id = ?',
501 EVENT => 'multiple_handler',
502 PLACEHOLDERS => [ 53 ],
503 PREPARE_CACHED => 0,
504 );
505 The Event handler will get a hash in ARG0:
507 {
509 'ERROR' => exists only if an error occured
510 'ACTION' => 'MULTIPLE'
511 'ID' => ID of the Query
512 'EVENT' => The event the query will respond to
513 'SESSION' => The session the query will respond to
514 'SQL' => Original SQL inputted
515 'RESULT' => Array of hash of columns - similar to array of fetchrow_hashref's ( undef if no rows returned )
516 'PLACEHOLDERS' => Original placeholders ( may not exist if it was not provided )
517 'BAGGAGE' => whatever you set it to ( may not exist if it was not provided )
518 }
519 "ATOMIC"
521 This query is specialized for those queries that you need to execute in
523 a transaction. You supply an array of SQL queries, and SimpleDBI will
524 execute them all in a transaction block. No need to worry about
525 AutoCommit, BEGIN, and END TRANSACTION!
526 You are supposed to pass an array of queries that normally would be
528 executed in a DO-style query. Again, you cannot execute SELECT queries
529 in this type of command! Currently there is no control over
530 prepare_cached for individual queries. It may be added in a future
531 release.
532 WARNING: It tripped me up on my testing when I realized this worked on
534 Postgres but not MySQL. I forgot that I was testing against MyISAM
535 tables, which doesn't support transactions! ( it works nicely on InnoDB
536 tables hah ) So, if this doesn't "behave" properly for you please check
537 your database tables! Accepted arguments:
538 SESSION -> The session to send the results
540 EVENT -> The event to send the results
541 SQL -> The array of SQL queries
542 PLACEHOLDERS -> The array of placeholders ( if needed ) [ this is an AoA - array of arrays! ]
543 BAGGAGE -> Any extra data to keep associated with this query ( SimpleDBI will not touch it )
544 PREPARE_CACHED -> Boolean value ( if needed ) [ for all of the queries! ]
545 Internally, it does something like this:
547 eval {
549 $dbh->begin_work;
550 for my $idx ( 0 .. $#array ) {
551 if ( $prepare_cached ) {
552 $sth = $dbh->prepare_cached( $array[ $idx ] );
553 } else {
554 $sth = $dbh->prepare( $array[ $idx ] );
555 }
556 if ( defined $PLACEHOLDERS[ $idx ] ) {
557 $sth->execute( $PLACEHOLDERS[ $idx ] );
558 } else {
559 $sth->execute;
560 }
561 $sth->finish;
562 }
563 $dbh->commit;
564 };
565 if ( $@ ) {
566 eval { $dbh->rollback };
567 if ( $@ ) {
568 return ROLLBACK_FAILURE;
569 } else {
570 return COMMIT_FAILURE;
571 }
572 } else {
573 return SUCCESS;
574 }
575 Here's an example on how to trigger this event:
577 $_[KERNEL]->post( 'SimpleDBI', 'ATOMIC',
579 SQL => [
580 'DELETE FROM FooTable WHERE ID = ?',
581 'UPDATE FooTable SET baz = ? WHERE bar = ?',
582 ],
583 EVENT => 'atomic_handler',
584 PLACEHOLDERS => [ [ 53 ],
585 [ 5, 86 ]
586 ],
587 );
588 The Event handler will get a hash in ARG0:
590 {
592 'ERROR' => exists only if an error occured ( ROLLBACK_FAILURE or COMMIT_FAILURE with explanation )
593 'ACTION' => 'ATOMIC'
594 'ID' => ID of the Query
595 'EVENT' => The event the query will respond to
596 'SESSION' => The session the query will respond to
597 'SQL' => Original SQL array inputted
598 'RESULT' => Either SUCCESS or in case of error, not exists
599 'PLACEHOLDERS' => Original placeholders ( may not exist if it was not provided )
600 'BAGGAGE' => whatever you set it to ( may not exist if it was not provided )
601 }
602 "Delete_Query"
604 Call this event if you want to delete a query via the ID. Returns:
606 undef if it wasn't able to find the ID
608 0 if the query is currently being processed
609 1 if the query was successfully deleted
610 Here's an example on how to trigger this event:
612 $_[KERNEL]->post( 'SimpleDBI', 'Delete_Query', $queryID );
614 IF you really want to know the status, execute a call on the event and
616 check the returned value.
617 "Clear_Queue"
619 This event will clear the entire queue except the running query, if
621 there is one.
622 You can also pass in one argument -> the error string to be used
624 instead of the default, 'Cleared the queue'
625 All the queries in the queue will return ERROR to their respective
627 sessions/events
628 "shutdown"
630 This will signal SimpleDBI to start the shutdown procedure. Without
632 arguments, SimpleDBI will wait for outstanding queries to complete
633 before killing it's session. You can also specify an argument to ignore
634 those queries and immediately halt:
635 $_[KERNEL]->post( 'SimpleDBI', 'shutdown', 'NOW' );
637 Due to the way POE's queue works, this shutdown event will take some
639 time to propagate POE's queue. If you REALLY want to shut down
640 immediately, do this:
641 $_[KERNEL]->call( 'SimpleDBI', 'shutdown', 'NOW' );
643 SimpleDBI Notes
645 This module is very picky about capitalization!
646 All of the options are uppercase, to avoid confusion.
648 You can enable debugging mode by doing this:
650 sub POE::Component::SimpleDBI::DEBUG () { 1 }
652 use POE::Component::SimpleDBI;
653 Also, this module will try to keep the SubProcess alive. if it dies,
655 it will open it again for a max of 5 retries.
656 You can override this behavior by doing this:
658 sub POE::Component::SimpleDBI::MAX_RETRIES () { 10 }
660 use POE::Component::SimpleDBI;
661 DBI attributes
663 Since SimpleDBI doesn't expose the DBI handle it might be an issue if
665 you need to set custom attributes. Fear not for DBI already has a
666 standard mechanism for this: "connection attribute values" in
667 "#connect" in DBI. Here is an example to enable utf8 for a Postgres
668 database:
669 $_[KERNEL]->post( 'SimpleDBI', 'CONNECT',
671 'DSN' => 'DBI:Pg(pg_enable_utf8=>1):host=foo;dbname=bar',
672 ...
673 );
674
676 Please see those modules/websites for more information related to this
677 module.
678 · DBI
680 · POE::Component::DBIAgent
682 · POE::Component::LaDBI
684 · POE::Component::EasyDBI
686
688 Perldoc
689 You can find documentation for this module with the perldoc command.
690 perldoc POE::Component::SimpleDBI
692 Websites
694 The following websites have more information about this module, and may
695 be of help to you. As always, in addition to those websites please use
696 your favorite search engine to discover more resources.
697 · MetaCPAN
699 A modern, open-source CPAN search engine, useful to view POD in
701 HTML format.
702 <http://metacpan.org/release/POE-Component-SimpleDBI>
704 · Search CPAN
706 The default CPAN search engine, useful to view POD in HTML format.
708 <http://search.cpan.org/dist/POE-Component-SimpleDBI>
710 · RT: CPAN's Bug Tracker
712 The RT ( Request Tracker ) website is the default bug/issue
714 tracking system for CPAN.
715 <http://rt.cpan.org/NoAuth/Bugs.html?Dist=POE-Component-SimpleDBI>
717 · AnnoCPAN
719 The AnnoCPAN is a website that allows community annotations of Perl
721 module documentation.
722 <http://annocpan.org/dist/POE-Component-SimpleDBI>
724 · CPAN Ratings
726 The CPAN Ratings is a website that allows community ratings and
728 reviews of Perl modules.
729 <http://cpanratings.perl.org/d/POE-Component-SimpleDBI>
731 · CPAN Forum
733 The CPAN Forum is a web forum for discussing Perl modules.
735 <http://cpanforum.com/dist/POE-Component-SimpleDBI>
737 · CPANTS
739 The CPANTS is a website that analyzes the Kwalitee ( code metrics )
741 of a distribution.
742 <http://cpants.cpanauthors.org/dist/overview/POE-Component-SimpleDBI>
744 · CPAN Testers
746 The CPAN Testers is a network of smokers who run automated tests on
748 uploaded CPAN distributions.
749 <http://www.cpantesters.org/distro/P/POE-Component-SimpleDBI>
751 · CPAN Testers Matrix
753 The CPAN Testers Matrix is a website that provides a visual
755 overview of the test results for a distribution on various
756 Perls/platforms.
757 <http://matrix.cpantesters.org/?dist=POE-Component-SimpleDBI>
759 · CPAN Testers Dependencies
761 The CPAN Testers Dependencies is a website that shows a chart of
763 the test results of all dependencies for a distribution.
764 <http://deps.cpantesters.org/?module=POE::Component::SimpleDBI>
766 Email
768 You can email the author of this module at "APOCAL at cpan.org" asking
769 for help with any problems you have.
770 Internet Relay Chat
772 You can get live help by using IRC ( Internet Relay Chat ). If you
773 don't know what IRC is, please read this excellent guide:
774 <http://en.wikipedia.org/wiki/Internet_Relay_Chat>. Please be courteous
775 and patient when talking to us, as we might be busy or sleeping! You
776 can join those networks/channels and get help:
777 · irc.perl.org
779 You can connect to the server at 'irc.perl.org' and join this
781 channel: #perl-help then talk to this person for help: Apocalypse.
782 · irc.freenode.net
784 You can connect to the server at 'irc.freenode.net' and join this
786 channel: #perl then talk to this person for help: Apocal.
787 · irc.efnet.org
789 You can connect to the server at 'irc.efnet.org' and join this
791 channel: #perl then talk to this person for help: Ap0cal.
792 Bugs / Feature Requests
794 Please report any bugs or feature requests by email to
795 "bug-poe-component-simpledbi at rt.cpan.org", or through the web
796 interface at
797 <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=POE-Component-SimpleDBI>.
798 You will be automatically notified of any progress on the request by
799 the system.
800 Source Code
802 The code is open to the world, and available for you to hack on. Please
803 feel free to browse it and play with it, or whatever. If you want to
804 contribute patches, please send me a diff or prod me to pull from your
805 repository :)
806 <https://github.com/apocalypse/perl-poe-simpledbi>
808 git clone https://github.com/apocalypse/perl-poe-simpledbi.git
810
812 Apocalypse <APOCAL@cpan.org>
813 CONTRIBUTORS
815 · Apocalypse <apoc@blackhole.(none)>
816 · Apocalypse <apoc@satellite.(none)>
818 · Rocco Caputo <rcaputo@cpan.org>
820
822 This software is copyright (c) 2014 by Apocalypse.
823 This is free software; you can redistribute it and/or modify it under
825 the same terms as the Perl 5 programming language system itself.
826 The full text of the license can be found in the LICENSE file included
828 with this distribution.
829
831 THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY
832 APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT
833 HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT
834 WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT
835 LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
836 PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE
837 OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU
838 ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
839 IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
841 WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR
842 CONVEYS THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
843 INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES
844 ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT
845 NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES
846 SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO
847 OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY
848 HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
849perl v5.30.0 2019-07-26 POE::Component::SimpleDBI(3pm)