Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

jifty::plugin::sqlqueries(3pm) [debian man page]

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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Setting Col size

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)
Discussion started by: yerra
2 Replies

2. UNIX for Advanced & Expert Users

${SCRIPTS_DIR}user_info >${log_dir}${BASE_JOB_NAME}.log 2>&1 --- what will this do

Please explain me the following code how it will work ${SCRIPTS_DIR}user_info >${log_dir}${BASE_JOB_NAME}.log 2>&1 (3 Replies)
Discussion started by: satgur
3 Replies

3. UNIX for Dummies Questions & Answers

What does ls * do

Hi Can anyone please explain what this commands does? Thanks. (2 Replies)
Discussion started by: trivektor
2 Replies

4. Shell Programming and Scripting

concatenate and display 2 lines as 1 with a condition for 2 line ?

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)
Discussion started by: vithala
7 Replies

5. Shell Programming and Scripting

Perl Programming for Splitting

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)
Discussion started by: sagarbsa
5 Replies

6. AIX

AIX chdev sys0 query

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)
Discussion started by: panther20091
3 Replies

7. UNIX for Dummies Questions & Answers

log4j - my unix version

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)
Discussion started by: pipoca
6 Replies

8. Shell Programming and Scripting

Can someone please explain what tr#A-Za-z0-9+/# -_#; means in perl?

Can someone please explain what tr#A-Za-z0-9+/# -_#; means in perl? (4 Replies)
Discussion started by: 3junior
4 Replies

9. Red Hat

BIND 9.x log answers to queries

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)
Discussion started by: pcblack23
3 Replies

10. Programming

fork(), could you explain!!

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)
Discussion started by: gabam
2 Replies

11. Shell Programming and Scripting

Need help putting output on one line

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)
Discussion started by: brianjb
14 Replies

12. Shell Programming and Scripting

Basic doubt in UNIX

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)
Discussion started by: Pranaveen
2 Replies

13. Shell Programming and Scripting

Time taken to run a SQL script

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)
Discussion started by: vat1kor
2 Replies

14. Programming

Join 2 SQL queries into one

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)
Discussion started by: Lord Spectre
3 Replies

15. Shell Programming and Scripting

Parsing a log file to cut off some parts

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)
Discussion started by: dae
4 Replies