JeF's Extra Queries (for interface and/or plugin)

How to make Movienizer support new sites. Customize Movienizer.
User avatar
xbox80
Superstar
Posts: 501
Joined: Tue Sep 15, 2009 8:50 am
Location: Italy-Russian

Re: JeF's Extra Queries (for interface and/or plugin)

Post by xbox80 » Thu Apr 12, 2012 2:48 pm

;) Jef can enter the query "Tv Serials"

example:
find all the TV serials "Once upon a time" 2011.

User avatar
JeF
Black Belt Squirrel
Posts: 1175
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: JeF's Extra Queries (for interface and/or plugin)

Post by JeF » Thu Apr 12, 2012 5:03 pm

xbox80 wrote:;) Jef can enter the query "Tv Serials"
example:
find all the TV serials "Once upon a time" 2011.
Could you please give more details ?
This should consist in only one movie (containing all seasons and all episodes), so using, for instance, search tab you'll easily find the movie and so all the episodes.
JeF

charles5
Passerby
Posts: 4
Joined: Sat May 05, 2012 8:38 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by charles5 » Sat May 05, 2012 8:48 am

Hi JeF.
Thanks for this wonderful plughin. :-)

I've got a question: is there a command (for example "select * from table_name" or something like "descr table_name") that can show me the structure or the fields of a table? It'd be easier build queries with the names of the fields... I'm trying to guess some of them but sometimes it's difficult.
For example I'm trying to extract all the information of a movie file (file size, bitrate, codecs, audio stream ...) in order to build a report.

Thank you very much for your reply.
Charles5

User avatar
Vlad
Developer
Posts: 2967
Joined: Wed Jan 23, 2008 11:37 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by Vlad » Sat May 05, 2012 9:27 am

charles5 wrote: I've got a question: is there a command (for example "select * from table_name" or something like "descr table_name") that can show me the structure or the fields of a table? It'd be easier build queries with the names of the fields... I'm trying to guess some of them but sometimes it's difficult.
You can easily see the structure of the database using a tool like sqlitebrowser :)
ImageImage

charles5
Passerby
Posts: 4
Joined: Sat May 05, 2012 8:38 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by charles5 » Sat May 05, 2012 12:37 pm

G R E A T !!!

Thank you very much, Vlad.

:-)
Charles

charles5
Passerby
Posts: 4
Joined: Sat May 05, 2012 8:38 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by charles5 » Sun May 20, 2012 10:35 am

Dear Jef

I hope this is the right place to write about a possible bug of your plugin.
The selection of the columns "season" of both the tables "episodes" and "editions" doesn't work.
(for example simply "select season from editions").
The name of the column is always "n" vith no values.

I'm doing something wrong or is this a bug?

Thanks.
Charles5

User avatar
JeF
Black Belt Squirrel
Posts: 1175
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: JeF's Extra Queries (for interface and/or plugin)

Post by JeF » Sun May 20, 2012 8:07 pm

Hi,
charles5 wrote:The selection of the columns "season" of both the tables "episodes" and "editions" doesn't work.
(for example simply "select season from editions").
The name of the column is always "n" vith no values.
I'm doing something wrong or is this a bug?
Yep, this is a bug. Thanks for reporting.
Here's a fixed v2.2 of the plugin waiting v2.3 to be out (i don't know when at the moment)
Should do it. Please let me know.
;)
JeF
Attachments
ExtraQueries.zip
Fixed v2.2 ExtraQueries dll
(295.08 KiB) Downloaded 694 times

charles5
Passerby
Posts: 4
Joined: Sat May 05, 2012 8:38 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by charles5 » Mon May 21, 2012 7:56 am

Hi JeF.

Thank you very much.
It works perfectly.

Bye.
Charles5

yobogi92
Passerby
Posts: 5
Joined: Wed Aug 15, 2012 7:28 pm

Re: JeF's Extra Queries (for interface and/or plugin)

Post by yobogi92 » Wed Aug 15, 2012 7:34 pm

hey guys,

can anyone help me with listing the first 5-6 actors from a movie? i tried to work it out with no luck.

User avatar
JeF
Black Belt Squirrel
Posts: 1175
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: JeF's Extra Queries (for interface and/or plugin)

Post by JeF » Thu Aug 16, 2012 8:14 am

yobogi92 wrote:can anyone help me with listing the first 5-6 actors from a movie? i tried to work it out with no luck.
Something like this should help :

Code: Select all

Z0139=SELECT m.code, m.title, p.name , d.sort_order FROM movies m , data d, persons p WHERE d.movie = m.code and d.mode = 3 and p.code = d.person and d.sort_order < 6 and m.in_collection = 1
Z0139D=Movies in collection with first (up to) 6 actors
;)
JeF

Post Reply