Changes between Version 17 and Version 18 of jazz/10-05-11

Timestamp:

May 11, 2010, 7:27:06 PM (14 years ago)

Author:

jazz

Comment:

--

jazz/10-05-11

@@ -149 +149 @@
 == Python + SQLite3 ==
 
+ * [參考] [http://mailliststock.wordpress.com/2007/03/01/sqlite-examples-with-bash-perl-and-python/ SQLite examples with Bash, Perl and Python] (2007-03-01)
+ * 環境: Debian 5.0.4 , amd64 核心
+{{{
+jazz@drbl:~$ lsb_release -a
+No LSB modules are available.
+Distributor ID: Debian
+Description:    Debian GNU/Linux 5.0.4 (lenny)
+Release:        5.0.4
+Codename:       lenny
+jazz@drbl:~$ uname -a
+Linux drbl 2.6.26-lustre-amd64 #1 SMP Sun Jun 28 18:28:02 CST 2009 x86_64 GNU/Linux
+}}}
+ * 相關套件: [http://packages.debian.org/sqlite3 sqlite3],[http://packages.debian.org/python-pysqlite2 python-pysqlite2]
+{{{
+jazz@drbl:~$ sudo apt-get install python-pysqlite2 sqlite3
+jazz@drbl:~$ dpkg -l | grep sqlite
+ii  python-pysqlite2                 2.4.1-1                        Python interface to SQLite 3
+ii  sqlite3                          3.5.9-6                        A command line interface for SQLite 3
+}}} 
+ * 使用範例程式建立 test.db
+{{{
+jazz@drbl:~$ vi pythonsqlite.py
+jazz@drbl:~$ chmod a+x pythonsqlite.py
+jazz@drbl:~$ ./pythonsqlite.py
+jazz@drbl:~$ file test.db
+test.db: SQLite 3.x database
+jazz@drbl:~$ sqlite3 test.db "select * from n"
+1|john|smith
+}}}
+{{{
+#!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()
+}}}
 
 == Open Hardware ==