{"id":28,"date":"2006-06-06T18:01:38","date_gmt":"2006-06-07T00:01:38","guid":{"rendered":"http:\/\/www.p14nd4.com\/blog\/projects\/moviedb\/"},"modified":"2014-07-11T17:12:53","modified_gmt":"2014-07-11T22:12:53","slug":"moviedb","status":"publish","type":"page","link":"http:\/\/www.p14nd4.com\/blog\/projects\/moviedb\/","title":{"rendered":"MovieDB"},"content":{"rendered":"<p>Like the <a href=\"..\/webmail-client\/\" title=\"Webmail Client\" rel=\"internal\">webmail client<\/a>, this movie database front-end was for csci4131 &#8211; Internet Programming, and is written in python\/cgi. The most notable difference between this and the webmail client, though, is that this program utilizes a database (as the name implies). Specifically, a MySQL database with a few different tables and various keys are used to store various aspects of the information about the movie. The schema was actually provided for us already, as defined here:<\/p>\n<details class=\"wp-block-inline-spoilers-block\"><summary>Spoiler<\/summary>\n<pre>CREATE TABLE Movie (\r\n    MovieID int(11) NOT NULL auto_increment,\r\n    Title char(30),\r\n    Rating int(11),\r\n    DirectorID int(11),\r\n    PRIMARY KEY (MovieID)\r\n);\r\n\r\nCREATE TABLE ActorSet (\r\n    ActorSetID int(11) NOT NULL auto_increment,\r\n    MovieID int(11),\r\n    ActorID int(11),\r\n    PRIMARY KEY (ActorSetID)\r\n);\r\n\r\nCREATE TABLE Actor (\r\n    ActorID int(11) NOT NULL auto_increment,\r\n    FName char(30),\r\n    LName char(30),\r\n    PRIMARY KEY (ActorID)\r\n);\r\n\r\nCREATE TABLE Director (\r\n    DirectorID int(11) NOT NULL auto_increment,\r\n    FName char(30),\r\n    LName char(30),\r\n    PRIMARY KEY (DirectorID)\r\n);<\/pre>\n<p><\/p><\/details>\n<p>Anyway, here&#8217;s the code I wrote. Enjoy.<\/p>\n<p>[syntax,moviedb.cgi,Python]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Like the webmail client, this movie database front-end was for csci4131 &#8211; Internet Programming, and is written in python\/cgi. The most notable difference between this and the webmail client, though, is that this program utilizes a database (as the name implies). Specifically, a MySQL database with a few different tables and various keys are used [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":25,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-28","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/pages\/28","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/comments?post=28"}],"version-history":[{"count":3,"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/pages\/28\/revisions"}],"predecessor-version":[{"id":237,"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/pages\/28\/revisions\/237"}],"up":[{"embeddable":true,"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/pages\/25"}],"wp:attachment":[{"href":"http:\/\/www.p14nd4.com\/blog\/wp-json\/wp\/v2\/media?parent=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}