Author Topic: Database Consistency Checker  (Read 1418 times)

Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6460
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Database Consistency Checker
« on: April 13, 2020, 12:15:44 PM »
A program for DVD Profiler that helps you to check if all profiles are in accordance to your own quality standards.

For this you generate a list of rules which are checked and low-quality profiles get listed in the result:





http://doena-journal.net/en/dvd-profiler-tools#DatabaseConsistencyChecker
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline Achim

  • Mega Heavy Poster
  • *******
  • Posts: 7176
  • Country: 00
    • View Profile
Re: Database Consistency Checker
« Reply #1 on: April 16, 2020, 03:08:27 PM »
That is something I have been planning to do. With your tool this is now in my grasp  :thundergod:

Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6460
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: Database Consistency Checker
« Reply #2 on: April 16, 2020, 07:59:44 PM »
If you have any questions, feel free to ask.  :)
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6460
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: Database Consistency Checker
« Reply #3 on: April 19, 2020, 10:01:27 AM »
The following checks and filters are now available:

Audio Track: Must contain audio tracks
Audio Track: Must contain given value
Box set: Must have child profiles
Case Type: Must be equal to given value
Case Type: Must be set
Cast: Birth Year must be larger / smaller than given value
Cast: Must contain cast members
Collection Number: Must be set
Collection Type: Must be part of given collection type value
Collection Type: Must be part of Owned collection
Count As: Must be equal to given value
Country of Origin: Must contain countries of origin
Crew: Birth Year must be larger / smaller than given value
Crew: Must contain crew members
Disc: Must contain discs
Easter Eggs: Must be set
Event: Date is older than the purchase date
Event: Must contain event of the given event type and user
Event: Must contain event with date larger / smaller than given value
Exclusion: Must be excluded from DVD Profiler for iPhone / Android
Exclusion: Must be excluded from DVD Profiler Mobile (PDA)
Exclusion: Must be excluded from online private listing
Exclusion: Must be excluded from online public listing
Features: Must contain features
Genre: Must contain genres
Genre: Must contain given value
Logic: Combine filters/checks with AND
Logic: Combine filters/checks with OR
Logic: Exclude profiles
Media Company: Must contain media companies
Media Type: Custom Type must be equal to given value
Media Type: Custom Type must be set
Media Type: Must be Blu-ray
Media Type: Must be DVD
Media Type: Must be HD-DVD
Media Type: Must be Ultra-HD
Overview: Must be set
Production Year: Must be set
Purchase: Currency must be equal to given value
Purchase: Currency must be set
Purchase: Date must be larger / smaller than given value
Purchase: Date must be set
Purchase: Place must be equal to given value
Purchase: Place must be set
Purchase: Price must be set
Rating: Must be equal to given value
Rating: Must be set
Rating: Rating System must be equal to given value
Release Date: Must be set
Review: Audio must be set
Review: DVD / Video must be set
Review: Extras must be set
Review: Movie must be set
Running Time: Must be set
SRP: Currency must be equal to given value
SRP: Currency must be set
SRP: Price must be set
Studio: Must contain studios
Subtitle: Must contain given value
Subtitle: Must contain subtitles
Tag: Must contain given value
Video Format: Any Color Format must be checked
Video Format: Any Dimension must be checked
Video Format: Any Video Format must be checked
Video Format: Aspect Ratio must be set
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6460
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: Database Consistency Checker
« Reply #4 on: April 19, 2020, 10:02:44 AM »
That is something I have been planning to do. With your tool this is now in my grasp  :thundergod:

If you have any more ideas for checks and filters, let me know.  :friends:
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline Achim

  • Mega Heavy Poster
  • *******
  • Posts: 7176
  • Country: 00
    • View Profile
Re: Database Consistency Checker
« Reply #5 on: April 24, 2020, 09:54:39 AM »
Once I get to use it, I would want to check profiles that have a certain tag set whether a set of fields is empty.

I usually like to keep certain fields empty for the parents (Box Sets; audio, video, genre, runtime; anything directly related to the actual content really) or the child (TV series; audio, video, genre). As you called one of your Watchable Profile I feel you are using it quite similarly to my intent.

Offline DJ Doena

  • Administrator
  • Mega Heavy Poster
  • *****
  • Posts: 6460
  • Country: de
  • Battle Troll
    • View Profile
    • My Blog
Re: Database Consistency Checker
« Reply #6 on: April 24, 2020, 05:05:48 PM »
Once I get to use it, I would want to check profiles that have a certain tag set whether a set of fields is empty.

That's basically what I'm doing and the program can do that.
Karsten

Abraham Lincoln once said The trouble with quotes from the internet is that you never know if they're genuine.

my Blog | my DVD Profiler Tools


Offline Antares

  • Super Heavy Poster
  • ******
  • Posts: 4148
    • View Profile
Re: Database Consistency Checker
« Reply #7 on: July 15, 2020, 09:12:19 PM »
Can't wait to try both this and your Six Degrees program. You are the best Karsten!