Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Skinny::ProfilerUser Contributed Perl DocumentaDBIx::Skinny::Profiler(3)

NAME
       DBIx::Skinny::Profiler -	support	query profile.

SYNOPSIS
       in your script:

	   use Your::Model;
	   use Data::Dumper;

	   my $row = Your::Model->insert('user',
	       {
		   id	=> 1,
	       }
	   );
	   $row->update({name => 'nekokak'});

	   $row	= Your::Model->search_by_sql(q{SELECT id, name FROM user WHERE id = ?},	[ 1 ]);
	   $row->delete('user')

	   # get queries
	   warn	Dumper Your::Model->profiler->query_log;
	   # The following are displayed.
	   #
	   #  INSERT INTO user (id) VALUES (?) :binds 1
	   #  UPDATE user set name = ? WHERE = id = ? :binds nekokak 1
	   #  SELECT id, name FROM user	WHERE id = ? :binds 1
	   #  DELETE user WHERE	id = ? :binds 1

       execute script:

	   $ SKINNY_PROFILE=1 perl ./sample.pl

METHODS
       $profiler->query_log()
	   get all execute SQLs.

       $profile->reset()
	   Recorded query information is reset.

POD ERRORS
       Hey! The	above document had some	coding errors, which are explained
       below:

       Around line 81:
	   =over without closing =back

perl v5.32.0			  2010-12-21	     DBIx::Skinny::Profiler(3)

NAME | SYNOPSIS | METHODS | POD ERRORS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Skinny::Profiler&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help