SQL Executer Plugin - Revision history

Atlioddsson at 08:46, 24 February 2016

2016-02-24T08:46:37Z

Atlioddsson at 08:45, 24 February 2016

2016-02-24T08:45:43Z

Atlioddsson at 21:28, 17 September 2009

2009-09-17T21:28:09Z

Atlioddsson at 20:53, 16 September 2009

2009-09-16T20:53:46Z

Atlioddsson: /* Sample Queries */

2009-06-18T21:39:57Z

Sample Queries

Atlioddsson: New page: (NB: this plugin has not been released and is mostly intended for developers and very technically inclined people) The SQL Executer is a sample plugin that allows anyone to run SQL querie...

2009-06-18T21:30:27Z

New page: (NB: this plugin has not been released and is mostly intended for developers and very technically inclined people) The SQL Executer is a sample plugin that allows anyone to run SQL querie...

New page

(NB: this plugin has not been released and is mostly intended for developers and very technically inclined people)

The SQL Executer is a sample plugin that allows anyone to run SQL queries against TimeSnapper database.

[[Image:sql-executer-plugin.png]]

The results can be copied from the results grid to e.g. Microsoft Excel for further processing.

For a definition of TimeSnapper's database model - see [[Database Model]]

== Sample Queries ==

List available TimeSnapper tables:
select rdb$relation_name
from rdb$relations
where rdb$view_blr is null
and (rdb$system_flag is null or rdb$system_flag = 0)
order by 1

Count the number of screenshots that have been taken since TimeSnapper was first installed:
select count(*) from activity

Count the number of screenshots that are still existing:
select count(*) from activity where filename is not null

@@ Line 5: / Line 5: @@
 [[Image:sql-executer-plugin.png]]
-The results can be copied (using Ctrl-C) from the results grid to e.g. Microsoft Excel for further processing.
+== How to use ==
-For a definition of TimeSnapper's database model - see [[Database Model]]
+Try these:
 == Sample Queries ==
@@ Line 17: / Line 28: @@
   and (rdb$system_flag is null or rdb$system_flag = 0)
   order by 1
 If you develop some interesting queries, be sure to send us a copy and we'll include them here for others to enjoy!
 [[Category:Plugins]]

← Older revision		Revision as of 21:39, 18 June 2009
Line 24:		Line 24:
	Count the number of screenshots that are still existing:		Count the number of screenshots that are still existing:
	select count(*) from activity where filename is not null		select count(*) from activity where filename is not null
		+
		+
		+	[[Category:Plugins]]

@@ Line 14: / Line 14: @@
    select count(*) from activity
-Count the number of screenshots that are still existing:
+Count the number of screenshots that still exist:
    select count(*) from activity where filename is not null

@@ Line 1: / Line 1: @@
-(NB: this plugin has not been released and is mostly intended for developers and very technically inclined people)
+(NB: This plugin is mostly intended for developers and very technically inclined people)
 The SQL Executer is a sample plugin that allows anyone to run SQL queries against TimeSnapper database.
 [[Image:sql-executer-plugin.png]]
 The results can be copied from the results grid to e.g. Microsoft Excel for further processing.
@@ Line 25: / Line 24: @@
    select count(*) from activity where filename is not null
 [[Category:Plugins]]