Welcome, Guest
Python Scripts for ComicRack

TOPIC: New Smartlist scripts

New Smartlist scripts 8 years 5 months ago #3455

  • cYo
  • cYo's Avatar
  • Offline
  • Moderator
  • Posts: 3476
  • Thank you received: 675
  • Karma: 181
I wonder if someone comes up with some clever ideas for this feature.

Maybe a script that finds gaps in series and displays start/end issue of the gap. Or a better duplicate finder.
The administrator has disabled public write access.

Re:New Smartlist scripts 8 years 4 months ago #3662

  • oraclexview
  • oraclexview's Avatar
  • Offline
  • Moderator
  • aka SoundWave
  • Posts: 906
  • Thank you received: 182
  • Karma: 37
I'm up to take a crack at it. I have a question for you though. Is it possible for you to create a page to add to your wiki section or create document file that covers all automation objects and database structures like MediaMonkey does so that it's easier to develop scripts for ComicRack?
example MediaMonkey Automation objects:
www.mediamonkey.com/wiki/index.php/Media...y_Automation_objects

example MediaMonkey Database structure:
www.mediamonkey.com/wiki/index.php/Media...y_Database_structure

Thanks cYo!

Onyx X aka SoundWave
The administrator has disabled public write access.

Re:New Smartlist scripts 8 years 3 months ago #3774

  • perezmu
  • perezmu's Avatar
  • Offline
  • Platinum Boarder
  • Posts: 1114
  • Thank you received: 64
  • Karma: 51
Hi, cYo, are the new objects exposed described somewhere?

thanks
The administrator has disabled public write access.

Re:New Smartlist scripts 8 years 1 month ago #4217

Hi, cYo.

I don't program in Python, but in SQL Transaction the idea is that:

CREATE TABLE #MyComicBook (num INT PRIMARY KEY)
INSERT INTO #MyComicBook VALUES (1)
INSERT INTO #MyComicBook VALUES (3)
INSERT INTO #MyComicBook VALUES (8)
INSERT INTO #MyComicBook VALUES (11)

DECLARE @numMax INT
DECLARE cursorMax CURSOR
FOR (SELECT MAX(num) FROM #MyComicBook) OPEN cursorMax
FETCH NEXT FROM cursorMax
INTO @numMax

CREATE TABLE #MyGapComicBook (num INT PRIMARY KEY)
DECLARE @i INT
SET @i = 1
WHILE @i<@numMax
BEGIN
INSERT INTO #MyGapComicBook VALUES (@i)
SET @i = @i + 1
END

SELECT * FROM #MyGapComicBook WHERE num NOT IN(SELECT * FROM #MyComicBook)

DROP TABLE #MyComicBook
DROP TABLE #MyGapComicBook
DEALLOCATE cursorMax
The administrator has disabled public write access.

Re:New Smartlist scripts 7 years 9 months ago #4865

  • CyRog
  • CyRog's Avatar
  • Offline
  • Junior Boarder
  • Posts: 25
  • Karma: 0
cYo wrote:
Maybe a script that finds gaps in series and displays start/end issue of the gap.

This would be great! My scan collections have many missing issue gaps in them, and it's a chore to go through each folder and note what I'm missing. Sadly, I have no knowledge of programming Python.
The administrator has disabled public write access.

Re:New Smartlist scripts 7 years 9 months ago #4889

I want to also chime in and say that this would be a great script to have. My collection is large enough that it would take me weeks to find all the gaps in it. If there was a script or list that would do it it would be great.
The administrator has disabled public write access.
Time to create page: 0.193 seconds

Who's Online

We have 171 guests and 11 members online