Changes between Version 7 and Version 8 of jazz/09-09-11

Timestamp:

Sep 12, 2009, 12:56:02 AM (16 years ago)

Author:

jazz

Comment:

--

jazz/09-09-11

@@ -53 +53 @@
 Any source-code tarball that includes the 'debian/*' files should be able to be built directly with it. 
 }}}
+ * 中文叢書
+  * [http://tlsj.tenlong.com.tw/WebModule/BookSearch/bookSearchViewAction.do?isbn=9789866840302&sid=48113&aid=69e42ffb   Python 學習手冊 (Learning Python, 3/e)]
+  * [http://www.books.com.tw/exep/prod/booksfile.php?item=0010434463& Python 3 技術手冊]
  
 == Message Queue ==
@@ -74 +77 @@
 }}}
 
+== SQLite ==
+
+ * [http://mailliststock.wordpress.com/2007/03/01/sqlite-examples-with-bash-perl-and-python/ SQLite examples with Bash, Perl and Python]
+{{{
+#!perl
+#!/usr/bin/perl -w
+use DBI;
+use strict;
+my $db = DBI->connect("dbi:SQLite:test.db", "", "",
+{RaiseError => 1, AutoCommit => 1});
+
+$db->do("CREATE TABLE n (id INTEGER PRIMARY KEY, f TEXT, l TEXT)");
+$db->do("INSERT INTO n VALUES (NULL, 'john', 'smith')");
+my $all = $db->selectall_arrayref("SELECT * FROM n");
+
+foreach my $row (@$all) {
+my ($id, $first, $last) = @$row;
+print "$id|$first|$lastn";
+}
+}}}
+{{{
+#!python
+#!/usr/bin/python
+from pysqlite2 import dbapi2 as sqlite
+
+db = sqlite.connect('test.db')
+cur = db.cursor()
+cur.execute('CREATE TABLE n (id INTEGER PRIMARY KEY, f TEXT, l TEXT)')
+db.commit()
+cur.execute('INSERT INTO n (id, f, l) VALUES(NULL, "john", "smith")')
+db.commit()
+cur.execute('SELECT * FROM n')
+print cur.fetchall()
+}}}
+{{{
+#!sh
+#!/bin/bash
+sqlite3 test.db  "create table n (id INTEGER PRIMARY KEY,f TEXT,l TEXT);"
+sqlite3 test.db  "insert into n (f,l) values ('john','smith');"
+sqlite3 test.db  "select * from n";
+}}}
+
 == Torque ==