I would like to know if there are any diagrams of how the relational Pluto_Media database is structured.
My ultimate goal is to write a script that I can use to batch assigned attributes and cover art to multiple episodes of the same show. This shouldn't be to hard once I figure out the relationships amongst the tables in Pluto_Media.
thanks
lon22
Did you look in the wiki? It contains a page about just that. Search for media pictures and you shall find.
rgds
Oliver
I didn't look in the right area of the wiki. After doing a search on media pictures, I found it. http://wiki.linuxmce.org/index.php/Media_Pictures_%28mediapics%29
thanks
lon22
That's the one.
It is of interest for me as well, 'cause I have a couple of media files I like to associate with cover art.
rgds
Oliver
Quote from: posde on January 14, 2008, 09:21:54 AM
That's the one.
It is of interest for me as well, 'cause I have a couple of media files I like to associate with cover art.
rgds
Oliver
Ok, after I create a working script , I will post it.
lon22
We're discussing generating ERDs for each of the v0704 and v0710 in "Graphical view on pluto_main (http://forum.linuxmce.org/index.php?topic=3459.0)". If you can help with the overall schema view, that would be good for everyone.
Quote from: Matthew on January 15, 2008, 06:02:23 AM
We're discussing generating ERDs for each of the v0704 and v0710 in "Graphical view on pluto_main (http://forum.linuxmce.org/index.php?topic=3459.0)". If you can help with the overall schema view, that would be good for everyone.
I'm willing to help. I have Visio and I'm familiar with ERDs.
Oliver see: http://forum.linuxmce.org/index.php?topic=3907.0
Quote from: lon22 on January 20, 2008, 07:42:26 PM
Quote from: Matthew on January 15, 2008, 06:02:23 AM
We're discussing generating ERDs for each of the v0704 and v0710 in "Graphical view on pluto_main (http://forum.linuxmce.org/index.php?topic=3459.0)". If you can help with the overall schema view, that would be good for everyone.
I'm willing to help. I have Visio and I'm familiar with ERDs.
Oliver see: http://forum.linuxmce.org/index.php?topic=3907.0
Any luck generating a schema view?
Just to clearify, when you say schema view, you are refering to a graphical schema i.e. ERD and not a data dictionary?
I haven't tried yet, but Visio uses an odbc driver and as long as I can set up a connection to the mySql database, it should be doable. Problems will arise when it comes to datatypes and relationships, for the reverse engineering might not translate everything accuratly.
lon22
Quote from: lon22 on January 25, 2008, 06:19:54 PM
Just to clearify, when you say schema view, you are refering to a graphical schema i.e. ERD and not a data dictionary?
I haven't tried yet, but Visio uses an odbc driver and as long as I can set up a connection to the mySql database, it should be doable. Problems will arise when it comes to datatypes and relationships, for the reverse engineering might not translate everything accuratly.
Well, what I want is a picture of the tables and their relations. But any progress in documenting the DB(s), like a data dictionary, would be very helpful. Even just a structured start of one that we can wiki, and people can fill out properly. Which will make an eventual ERD picture usable.
Maybe royw's mindmap point in the "Graphical view on pluto_main" thread (http://forum.linuxmce.org/index.php?topic=3459.msg22903#msg22903) and lon2's data dictionary point in this thread (http://forum.linuxmce.org/index.php?topic=3791.msg22801#msg22801), as well as chriss' ERD points in "Graphical view on pluto_main" (http://forum.linuxmce.org/index.php?topic=3459.msg23002#msg23002) suggest a team of people who can work together to wiki a solid beginning of a LMCE DB document.
FWIW, I hope the docs/diagrams include a version number, as 0704 is different from 0710bN, and the different bNs (1, 2, 3 so far, and SVN snapshots), all could be different.