Jifty::Plugin::SQLQueries(3pm) User Contributed Perl Documentation Jifty::Plugin::SQLQueries(3pm)NAME
Jifty::Plugin::SQLQueries - Inspect your application's SQL queries
DESCRIPTION
This plugin will log each SQL query, its duration, its bind parameters, and its stack trace. Such reports are available at:
http://your.app/__jifty/admin/requests
USAGE
Add the following to your site_config.yml
framework:
Plugins:
- SQLQueries: {}
You can turn on and off the stacktrace, as well as an "EXPLAIN" of each query, using options to the plugin:
framework:
Plugins:
- SQLQueries:
stacktrace: 0
explain: 1
The plugin defaults to logging the stack trace, but not the explain.
METHODS
init
Sets up a "post_init" hook.
inspect_before_request
Clears the query log so we don't log any unrelated previous queries.
inspect_after_request
Stash the query log.
inspect_render_summary
Display how many queries and their total time.
inspect_render_analysis
Render a template with all the detailed information.
post_init
Tells Jifty::DBI to log queries in a way that records stack traces.
prereq_plugins
This plugin depends on Jifty::Plugin::RequestInspector.
COPYRIGHT AND LICENSE
Copyright 2007-2010 Best Practical Solutions
This is free software and may be modified and distributed under the same terms as Perl itself.
perl v5.14.2 2010-12-10 Jifty::Plugin::SQLQueries(3pm)
Check Out this Related Man Page
Jifty::Plugin::Authentication::Facebook(3pm) User Contributed Perl Documentation Jifty::Plugin::Authentication::Facebook(3pm)NAME
Jifty::Plugin::Authentication::Facebook - Facebook authentication plugin for Jifty
DESCRIPTION
Provides standalone Facebook authentication for your Jifty application. It adds the columns "facebook_name", "facebook_uid",
"facebook_session", and "facebook_session_expires" to your User model.
SYNOPSIS
In your jifty config.yml under the "framework" section:
Plugins:
- Authentication::Facebook:
api_key: xxx
secret: xxx
You may set any options which the "new" method of WWW::Facebook::API understands.
In your User model, you'll need to include the line
use Jifty::Plugin::Authentication::Facebook::Mixin::Model::User;
after your schema definition (which may be empty). You may also wish to include
sub _brief_description { 'facebook_name' }
To use the user's Facebook name as their description.
See Jifty::Plugin::Authentication::Facebook::View for the provided templates and Jifty::Plugin::Authentication::Facebook::Dispatcher for
the URLs handled.
init
api
Generates a new WWW::Facebook::API for the current user
get_login_url
Gets the login URL, preserving continuations
get_link_url
Gets the login URL used for linking, preserving continuations
AUTHOR
Alex Vandiver
LICENSE
Copyright 2005-2009 Best Practical Solutions, LLC.
This program is free software and may be modified and distributed under the same terms as Perl itself.
perl v5.10.0 2009-06-09 Jifty::Plugin::Authentication::Facebook(3pm)
I have a variable in a shell script which is more than 80 characters.
1) I log into SQL plus and populate a variable using 3 queries appended by ,' comma'.
ORAINFO=`sqlplus -s << !
/ as sysdba
set feedback off
set heading off
select LOG_MODE... (2 Replies)
I have 2 pattern of lines (SQL query and Time taken)in a log i need to capture all SQL queries with time taken >20 sec and need to display as one line.
2 lines from log:
2007-10-23 11:39:17,061 DEBUG - SQL Query : SELECT A.GROUP_CD , C.FN_CD FROM UP_GROUP A , PRD_GROUP_TO_FN B , PRD_FN... (7 Replies)
Hi,
I am extracting SQL queries into a file and the file is as follows
*********************************************************
select BatchKey ,restartStatus ,batchContextBuffer ,batchPgmId ,StartKey ,
EndKey ,Mcbatchcontrol_ver
from
qsecminload.Mcbatchcontrol_t where RefId = :1 ... (5 Replies)
Hi all
chdev -l sys0 -a fullcore=flase
In the above command please explain why this command is use.and what is the default value of sys0
Also it would be good if someone can elaborate on the 'sys0' thing.
Thanks (3 Replies)
Hi,
I am starting to do a log4j framework but with unix shell script. So, this framework, will create the log file, will put all info in there, and will close the log file.
He will only work whenever he is called by the father script.
Now, I want him to be able to work with different father... (6 Replies)
Hi,
Can anyone tell me how in BIND 9.x (running 9.7.3) do you configure it to put the answer to each query in the log. I see the query, the IP who asked the query but not what the answer to the query is.
thanks for your help,
Phil (3 Replies)
Dear friends,
We are learning UNIX system programming as part of our course. I came across this simple program, which the teacher didn't explain well enough. could you please explain this program fully
#include <sys/types.h>
#include <stdio.h>
#include <unistd.h>
int main()
{
int pid;... (2 Replies)
Good afternoon,
I have been searching the web, and these forums for help. I will try my best to explain the issue, and what my desired results are.
I am doing queries in MYSQL, and need the output to be sent to a file. That file needs to have things with the same ID on the same line. To... (14 Replies)
Hi,
I'm new to this and very much interested to learn unix.
Can any one explain me the symbols y we use this is scripting(~ and $).
It would be great if some one explain with the eg.
Thanks
Naveen A (2 Replies)
Hello
I am asked to run around 5-6 SQL queries in a shell script and take a note of the time taken to execute each query to a file. How do I get the time taken to run the individual SQL queries (2 Replies)
Dear community,
could someone help me to join 2 queries into one?
Basically it's the same query with different clauses (please notice the FIELD3 filters and related counters into the subquery):
SELECT A.FIELD1,A.FIELD2,A.FIELD3
FROM
TABLE A
INNER JOIN
(
SELECT FIELD1,... (3 Replies)
Dear all,
I would like to use SQL's log file to extract information from it.
This file can include four different types of instruction with the number of lines involved for each of them:
-> (1) "INSERT" instruction with the number of lines inserted
-> (2) "UPDATE" instruction with the... (4 Replies)