about summary refs log tree commit diff stats
path: root/samples/home.htm
blob: b26282156fe3b768f098b876b5fc59f9f9435a32 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<!--
 $LynxId: home.htm,v 1.4 2008/01/06 20:53:04 tom Exp $
 vile:dos
 -->
<html>
  <head>
    <title>
      :: hello ::
    </title>
    <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
  </head>
  <body>
    <table width="100%" summary="Lynx home page" align="right">
      <tr>
        <td width="100%" align="right">
          <b>Lynx browser...</b>
          <p>
            &nbsp;
          </p>
          <p>
            ...for quicker &amp; saver browsing...
          </p>
          <p>
            Light-height, fast and secure text browser.
          </p>
        </td>
      </tr>
    </table>
  </body>
</html>
ss="w"> = time::Instant::now(); info!("Connecting to database"); let conn = rusqlite::Connection::open_with_flags( path, rusqlite::OpenFlags::SQLITE_OPEN_FULL_MUTEX | rusqlite::OpenFlags::SQLITE_OPEN_CREATE | rusqlite::OpenFlags::SQLITE_OPEN_READ_WRITE, ) .expect("Could not connect to DB"); conn.execute( "CREATE TABLE IF NOT EXISTS posts ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title TEXT NOT NULL, author TEXT NOT NULL, body TEXT NOT NULL )", rusqlite::NO_PARAMS, ) .expect("Could not initialize DB"); info!( "Database connection established in {}ms", start.elapsed().as_millis() ); conn } pub fn new() -> Self { Conn { conn: Conn::init(DB_PATH), } } } #[cfg(test)] mod tests { use super::*; #[test] fn test_new() { let conn = Conn::init("/tmp/clinte-test.db"); let mut stmt = conn.prepare("SELECT * FROM POSTS").unwrap(); stmt.query_map(rusqlite::NO_PARAMS, |_| Ok(())).unwrap(); } }