[Web]INTER-Mediatorについて（その1）

INTER-Mediatorは、データベースとの連動が簡単に行える、Webのフレームワークだ。

MySQLにデモ用のデータベースを用意する。

$ mysqladmin -u root -p create DEMOCompactDisc
Enter password: 
$ mysql -u root -p mysql
Enter password: 
	
mysql> GRANT ALL PRIVILEGES ON DEMOCompactDisc.* TO demo
    -> IDENTIFIED BY 'test';
 
mysql> GRANT ALL PRIVILEGES ON DEMOCompactDisc.* TO demo@localhost
    -> IDENTIFIED BY 'test';
 
mysql> FLUSH PRIVILEGES;
 
mysql> quit
 
$ mysql -u demo -p DEMOCompactDisc
Enter password: 
	
mysql> CREATE TABLE CD (CD_ID INT NOT NULL,
    -> RECORD_LABEL_ID INT,
    -> CD_TITLE TEXT,
    -> PRIMARY KEY (CD_ID));
 
mysql> CREATE TABLE Artist (ARTIST_ID INT NOT NULL,
    -> ARTIST_NAME TEXT,
    -> PRIMARY KEY (ARTIST_ID));
 
mysql> CREATE TABLE Song (SONG_ID INT NOT NULL,
    -> CD_ID INT,
    -> ARTIST_ID INT,
    -> SONG_NAME TEXT,
    -> PRIMARY KEY (SONG_ID));
 
mysql> CREATE TABLE RecordLabel (RECORD_LABEL_ID INT NOT NULL,
    -> RECORD_LABEL_NAME TEXT,
    -> PRIMARY KEY (RECORD_LABEL_ID));
 
mysql> INSERT INTO Artist (ARTIST_ID, ARTIST_NAME) VALUES (1, "Robert Leroy Johnson");
 
mysql> select * from Artist;
+-----------+----------------------+
| ARTIST_ID | ARTIST_NAME          |
+-----------+----------------------+
|         1 | Robert Leroy Johnson |
+-----------+----------------------+
 
mysql> quit
$