_IMv2.key

Size: px

Start display at page:

Download "_IMv2.key"

しげじろうじゅふく
6 years ago
Views:

1 飯島基文

88 $ ssh $ cd /Library/Server/Web/Data/Sites/Default/ $ git clone

96 $ sudo mkdir /var/db/im $ cd /Library/Server/Web/Data/Sites/Default/INTER-Mediator/dist-docs/ $ sudo sqlite3 /var/db/im/sample.sq3 < sample_schema_sqlite.txt $ sudo chown _www /var/db/im $ sudo chown _www /var/db/im/sample.sq3

100

101

102

103

104

105

106

107

108 CREATE TABLE fruit ( id INTEGER PRIMARY KEY AUTOINCREMENT, item TEXT, price INTEGER ); INSERT INTO fruit (id, item, price) VALUES (1, ' ',100); INSERT INTO fruit (id, item, price) VALUES (2, ' ', 150); INSERT INTO fruit (id, item, price) VALUES (3, ' ', 450); INSERT INTO fruit (id, item, price) VALUES (4, ' ', 200); INSERT INTO fruit (id, item, price) VALUES (5, ' ', 850); INSERT INTO fruit (id, item, price) VALUES (6, ' ', 2500); INSERT INTO fruit (id, item, price) VALUES (7, ' ', 126); INSERT INTO fruit (id, item, price) VALUES (8, ' ', 390); INSERT INTO fruit (id, item, price) VALUES (9, ' ', 420); INSERT INTO fruit (id, item, price) VALUES (10, ' ', 320); INSERT INTO fruit (id, item, price) VALUES (11, ' ', 3200);

109 $ sqlite3 mysample.sq3 < mysample.txt $ sqlite3 mysample.sq3 sqlite>.header ON sqlite> select * from fruit; id item price

110 $ ssh $ sudo chown _www:admin /var/db/im //_www:wheel"_www:admin $ sudo chmod 775 /var/db/im //755"775 $ exit $ scp mysample.sq3 ladmin@im.example.com:/var/db/im/ $ ssh ladmin@im.example.com $ sudo chown _www /var/db/im/mysample.sq3

111

112 <?php // INTER-Mediator.php require_once(dirname( FILE ). /../INTER-Mediator.php'); // IM_Entry() IM_Entry( // array(), // array(), // DB array(), );?> // 2

113 <?php require_once(dirname( FILE ). /../INTER-Mediator.php'); IM_Entry( // array( arrary( 'name' => 'fruit', 'records' => 5, 'paging' => true, 'key' => 'id', 'sort' => array(array('field' => 'id', 'direction' => 'ASC')), ) ), null, // DB );?> array( 'db-class' => 'PDO', 'dsn' => 'sqlite:/var/db/im/mysample.sq3' ), // 2

114

115

116 <html> <body> <table border="1"> <thead> <tr><td> </td><td> </td><td> </td></tr> </tbody> </table> </body> <html> </thead> <tbody> <tr><td>1</td><td> </td><td>100</td></tr> <tr><td>2</td><td> </td><td>150</td></tr> <tr><td>3</td><td> </td><td>450</td></tr> <tr><td>4</td><td> </td><td>200</td></tr> <tr><td>5</td><td> </td><td>850</td></tr> <tr><td>6</td><td> </td><td>2500</td></tr> <tr><td>7</td><td> </td><td>126</td></tr> <tr><td>8</td><td> </td><td>390</td></tr> <tr><td>9</td><td> </td><td>420</td></tr> <tr><td>10</td><td> </td><td>320</td></tr> <tr><td>11</td><td> </td><td>3200</td></tr>

117 <html> <body> <table border="1"> <thead> <tr><td> </td><td> </td><td> </td></tr> </tbody> </table> </body> <html> </thead> <tbody> <tr><td>1</td><td> </td><td>100</td></tr> <tr><td>2</td><td> </td><td>150</td></tr> <tr><td>3</td><td> </td><td>450</td></tr> <tr><td>4</td><td> </td><td>200</td></tr> <tr><td>5</td><td> </td><td>850</td></tr> <tr><td>6</td><td> </td><td>2500</td></tr> <tr><td>7</td><td> </td><td>126</td></tr> <tr><td>8</td><td> </td><td>390</td></tr> <tr><td>9</td><td> </td><td>420</td></tr> <tr><td>10</td><td> </td><td>320</td></tr> <tr><td>11</td><td> </td><td>3200</td></tr>

118 <tbody> <tr> <td><div data-im= <td><div data-im= <td><div data-im= ></div></td> </tr> </tbody>

119 <html> <head> <script src= contexts_sqlite.php"></script> </head> <body> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> </body> </html>

120 <html lang="ja"> <head> <meta charset="utf-8"> <title>inter-mediator - MySample - SQLite</title> <script src="contexts_sqlite.php"></script> </head> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> <table border="1" id=""> <thead> <tr> <th> </th> <th> </th> <th> </th> </tr> </thead> <tbody> <tr> <td><div data-im="fruit@id"></div></td> <td><div data-im="fruit@item"></div></td> <td><div data-im="fruit@price"></div></td> </tr> </tbody> </table> </body> </html>

121 <html> <head> <meta charset="utf-8"> <title>inter-mediator - MySample - SQLite</title> <script src="contexts_sqlite.php"></script> </head> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> <table border="1" id=""> <thead> <tr> <th> </th> <th> </th> <th> </th> </tr> </thead> <tbody> <tr> <td><div data-im="fruit@id"></div></td> <td><div data-im="fruit@item"></div></td> <td><div data-im="fruit@price"></div></td> </tr> <tr data-im-control="noresult"> <td colspan="4"> </td> </tr> </tbody> </table> </body> </html>

122 <html> <head> <meta charset="utf-8"> <title>inter-mediator - MySample - SQLite</title> <script src="contexts_sqlite.php"></script> </head> <body onload="intermediator.construct(true)"> <div id="im_navigator">navigation Controls by INTER-Mediator</div> <table border="1" id=""> <thead> <tr> <th> </th> <th> </th> <th> </th> </tr> </thead> <tbody> <tr> <td><div data-im="fruit@id"></div></td> <td><div data-im="fruit@item"></div></td> <td><div data-im="fruit@price"></div></td> </tr> <tr data-im-control="noresult"> <td colspan="4"> </td> </tr> </tbody> </table> </body> </html>

123

124

125

126

127

128

129 <html> <head> <link rel="stylesheet" type="text/css" href="../sample.css" /> </head> </html>

130

131

132

133

134

135 IM_Entry( // array( 'repeat-control' => 'insert delete, ), // array(), // DB array(), );?> // 2

136

137

138 <thead> <tr> <th></th> </tr> </thead> <tbody> <tr> <td></td> </tr> </tbody>

139

140

141 <tbody> <tr> <td><div data-im= <td><input type="text" /></td> <td><input type="text" /></td> <td></td> </tr> </tbody>

142

143

144

145

146

147 <thead> <tr> <th> <span style="cursor: pointer" data-im= > </span> <span style="cursor: pointer" data-im= > </span> </th> <th> <span style="cursor: pointer" data-im= </span> <span style="cursor: pointer" data-im= </span> </th> <th> <span style="cursor: pointer" data-im= </span> <span style="cursor: pointer" data-im= </span> </th> </tr> </thead>

148

149

150

151

152

153 <div> :<input type="text" : <select type="text" <option value="5">5</option> <option value="10">10</option> <option value="20" selected>20</option> </select> <button </div>

154

155

156

157

158

159

160

161

162

163

164 CREATE TABLE receipt ( id INTEGER PRIMARY KEY AUTOINCREMENT, timestamp TEXT, person INTEGER, category INTEGER, company TEXT, details TEXT, amount REAL, payment INTEGER, settlement INTEGER, filepath TEXT, remarks TEXT );

165

166

167 <?php require_once(dirname( FILE ). '/../../INTER-Mediator.php'); IM_Entry( array( array( 'name' => 'receipt', 'records' => 10, 'paging' => true, 'key' => 'id', 'sort' => array(array('field' => 'timestamp', 'direction' => 'ASC')), 'repeat-control' => 'insert delete' ), array( 'name' => 'receiptdetail', 'view' => 'receipt', 'table' => 'receipt', 'records' => 1, 'key' => 'id', 'repeat-control' => 'delete' ), array( 'name' => 'person', 'key' => 'id', ), array( 'name' => 'category', 'key' => 'id', ), array( 'name' => 'payment', 'key' => 'id', ), array( 'name' => 'settlement', 'key' => 'id', ), ), array( 'formatter' => array( array( 'field' => 'converter-class' => 'Number', 'parameter' => '0' ), ), ), array( 'db-class' => 'PDO', 'dsn' => 'sqlite:/var/db/im/myapp.sq3' ), 2 );?>

168

169

170

171

172

173

174

175

176

Vol. 31 No. 1 Feb [3] INTER-Mediator HTML HTML ( HTML ) Web 2 INTER-Mediator 3 Web INTER-Mediator INTER-Mediator Web Web 2010 MIT Lic

Vol. 31 No. 1 Feb [3] INTER-Mediator HTML HTML ( HTML ) Web 2 INTER-Mediator 3 Web INTER-Mediator INTER-Mediator Web Web 2010 MIT Lic 60 Web INTER-Mediator Web HTML INTER-Mediator is a framework for developing web applications. Mainly it can be applied to the business system for small and medium organizations, especially limited budget