Python:操作嵌入式資料庫SQLite

  去年寫過一篇通過C語言操作SQLite資料庫的文章《SQLITE學習筆記一(開啟、操作及關閉資料庫，C程式實現)》，最近在學習python,所以使用ptyhon實現了一下，實現不多描述了，代碼中的注釋已經非常詳細了。直接貼上來。

1. 實現：

#!/usr/bin/env python# -*- coding: utf-8 -*-#匯入日誌及SQLite3模組import loggingimport logging.configimport sqlite3#日誌設定檔名LOG_FILENAME = 'logging.conf'#日誌語句提示資訊LOG_CONTENT_NAME = 'sqlite_log'#SQLite資料庫名稱DB_SQLITE_PATH = ".\\db\\sqlite_pytest.db"def log_init(log_config_filename, logname):    '''    Function:日誌模組初始化函數    Input：log_config_filename:日誌設定檔名           lognmae:每條日誌前的提示句    Output: logger    author: socrates    date:2012-02-11    '''    logging.config.fileConfig(log_config_filename)    logger = logging.getLogger(logname)    return loggerdef operate_sqlite3_tbl_product():    '''    Function:操作SQLITE3資料庫函數    Input：NONE    Output: NONE    author: socrates    date:2012-02-11    '''      sqlite_logger.debug("operate_sqlite3_tbl_product enter...")         #串連資料庫      try:        sqlite_conn = sqlite3.connect(DB_SQLITE_PATH)    except sqlite3.Error, e:         print 'conntect sqlite database failed.'         sqlite_logger.error("conntect sqlite database failed, ret = %s" % e.args[0])             return             sqlite_logger.info("conntect sqlite database(%s) succ." % DB_SQLITE_PATH)          #擷取遊標     sqlite_cursor = sqlite_conn.cursor()        #刪除表    sql_desc2 = "DROP TABLE IF EXISTS tbl_product3;"    try:        sqlite_cursor.execute(sql_desc2)    except sqlite3.Error, e:         print 'drop table failed'         sqlite_logger.error("drop table failed, ret = %s" % e.args[0])         sqlite_cursor.close()         sqlite_conn.close()               return    sqlite_conn.commit()            sqlite_logger.info("drop table(tbl_product3) succ.")         #建表    sql_desc = '''CREATE TABLE tbl_product3(    i_index INTEGER PRIMARY KEY,    sv_productname VARCHAR(32)    );'''    try:        sqlite_cursor.execute(sql_desc)    except sqlite3.Error, e:         print 'drop table failed.'         sqlite_logger.error("drop table failed, ret = %s" % e.args[0])         sqlite_cursor.close()         sqlite_conn.close()             return        sqlite_conn.commit()        sqlite_logger.info("create table(tbl_product3) succ.")         #插入記錄    sql_desc = "INSERT INTO tbl_product3(sv_productname) values('apple')"    try:        sqlite_cursor.execute(sql_desc)    except sqlite3.Error, e:        print 'insert record failed.'        sqlite_logger.error("insert record failed, ret = %s" % e.args[0])          sqlite_cursor.close()        sqlite_conn.close()            return        sqlite_conn.commit()        sqlite_logger.info("insert record into table(tbl_product3) succ.")         #查詢記錄    sql_desc = "SELECT * FROM tbl_product3;"        sqlite_cursor.execute(sql_desc)    for row in sqlite_cursor:        print row        sqlite_logger.info("%s", row)         #關閉遊標和資料庫控制代碼        sqlite_cursor.close()    sqlite_conn.close()        sqlite_logger.debug("operate_sqlite3_tbl_product leaving...") if __name__ == '__main__':         #初始化日誌系統    sqlite_logger = log_init(LOG_FILENAME, LOG_CONTENT_NAME)           #操作資料庫    operate_sqlite3_tbl_product()    

2. 運行後的日誌資訊：

[2012-02-12 12:13:52,131  sqlite_log]DEBUG:  operate_sqlite3_tbl_product enter... (test_log.py:39)[2012-02-12 12:13:52,147  sqlite_log]INFO:  conntect sqlite database(.\db\sqlite_pytest.db) succ. (test_log.py:49)[2012-02-12 12:13:52,147  sqlite_log]INFO:  drop table(tbl_product3) succ. (test_log.py:66)[2012-02-12 12:13:52,240  sqlite_log]INFO:  create table(tbl_product3) succ. (test_log.py:83)[2012-02-12 12:13:52,365  sqlite_log]INFO:  insert record into table(tbl_product3) succ. (test_log.py:97)[2012-02-12 12:13:52,365  sqlite_log]INFO:  (1, u'apple') (test_log.py:104)[2012-02-12 12:13:52,365  sqlite_log]DEBUG:  operate_sqlite3_tbl_product leaving... (test_log.py:110)

3.通過命令列查看：

Microsoft Windows XP [版本 5.1.2600](C) 著作權 1985-2001 Microsoft Corp.C:\Documents and Settings\socrates.WINXP-DUANYX>cd /d E:\Study\學習\工作程式\py_test\src\dbE:\Study\學習\工作程式\py_test\src\db>sqlite3.exe sqlite_pytest.dbSQLite version 3.7.9 2011-11-01 00:52:41Enter ".help" for instructionsEnter SQL statements terminated with a ";"sqlite> .tablestbl_product3sqlite> select * from tbl_product3;1|applesqlite> .quitE:\Study\學習\工作程式\py_test\src\db>