Python sqlite3.Connection.text_factory用法及代碼示例

用法: text_factory

使用此屬性，您可以控製為 TEXT 數據類型返回的對象。默認情況下，此屬性設置為 str 並且 sqlite3 模塊將為 TEXT 返回 str 對象。如果您想返回 bytes ，可以將其設置為 bytes 。

您還可以將其設置為任何其他接受單個字節字符串參數並返回結果對象的可調用對象。

請參閱以下示例代碼進行說明：

import sqlite3

con = sqlite3.connect(":memory:")
cur = con.cursor()

AUSTRIA = "Österreich"

# by default, rows are returned as str
cur.execute("select ?", (AUSTRIA,))
row = cur.fetchone()
assert row[0] == AUSTRIA

# but we can make sqlite3 always return bytestrings ...
con.text_factory = bytes
cur.execute("select ?", (AUSTRIA,))
row = cur.fetchone()
assert type(row[0]) is bytes
# the bytestrings will be encoded in UTF-8, unless you stored garbage in the
# database ...
assert row[0] == AUSTRIA.encode("utf-8")

# we can also implement a custom text_factory ...
# here we implement one that appends "foo" to all strings
con.text_factory = lambda x: x.decode("utf-8") + "foo"
cur.execute("select ?", ("bar",))
row = cur.fetchone()
assert row[0] == "barfoo"

con.close()

相關用法

注：本文由純淨天空篩選整理自python.org大神的英文原創作品 sqlite3.Connection.text_factory。非經特殊聲明，原始代碼版權歸原作者所有，本譯文未經允許或授權，請勿轉載或複製。