LinuxMCE Forums

General => Developers => Topic started by: lon22 on January 12, 2008, 11:46:49 pm

Title: Database (Pluto_media) ERD
Post by: lon22 on January 12, 2008, 11:46:49 pm
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
Title: Re: Database (Pluto_media) ERD
Post by: posde on January 13, 2008, 09:01:32 am
Did you look in the wiki? It contains a page about just that. Search for media pictures and you shall find.

rgds
Oliver
Title: Re: Database (Pluto_media) ERD
Post by: lon22 on January 13, 2008, 10:49:56 pm
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
Title: Re: Database (Pluto_media) ERD
Post by: 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
Title: Re: Database (Pluto_media) ERD
Post by: lon22 on January 15, 2008, 04:53:03 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
Title: Re: Database (Pluto_media) ERD
Post by: 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.
Title: Re: Database (Pluto_media) ERD
Post by: lon22 on January 20, 2008, 07:42:26 pm
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
Title: Re: Database (Pluto_media) ERD
Post by: Matthew on January 25, 2008, 04:12:15 pm
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?
Title: Re: Database (Pluto_media) ERD
Post by: 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.

lon22
Title: Re: Database (Pluto_media) ERD
Post by: Matthew on January 25, 2008, 09:08:34 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.
Title: Re: Database (Pluto_media) ERD
Post by: Matthew on January 28, 2008, 03:21:39 am
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.