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

FreeBSD Manual Pages

  
 
  

home | help 
DBIx::Skinny::ProfilerUseraContributed Perl DoDBIx::Skinny::Profiler::Trace(3)

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

SYNOPSIS
       in your script:

	   use Your::Model;

	   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')

       execute script: It is output to STDERR in default.

	   $ SKINNY_TRACE=1 perl ./sample.pl
	   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

       or

       The file	can be specified.

	   $ SKINNY_TRACE=1=./query.log	perl ./sample.pl
	   $ cat ./query.log
	   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

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

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

       Around line 91:
	   =over without closing =back

perl v5.32.1			  2010-12-21  DBIx::Skinny::Profiler::Trace(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::Trace&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help