数据库操作工具。
Project description
使用教程
快速开始
import jdbcer
db = jdbcer.SQLite("test.db")
create_table_sql = """
CREATE TABLE IF NOT EXISTS t_test (
data_key varchar(255) PRIMARY KEY,
data_value text,
data_int integer
);
"""
# 创建数据表
db.execute(create_table_sql)
# 插入数据
db.replace("replace into t_test values (?,?,?)", "test_key", "test_data", 1)
# 查询数据
print(db.select("select * from t_test where data_key = ?", "test_key"))
print(db.selectOne("select * from t_test where data_key = ?", "test_key"))
print(db.selectTable("t_test", data_key="test_key"))
# 查询字段
print(db.getColumnIntValue("select data_int from t_test where data_key = ?", "test_key"))
print(db.getColumnFloatValue("select data_int from t_test where data_key = ?", "test_key"))
print(db.getColumnBoolValue("select data_value,data_int from t_test where data_key = ?", "test_key", column="data_int"))
# 批量插入数据
rows = []
for i in range(0, 100):
row = (f"k{i}", f"v{i}", i)
rows.append(row)
db.replaceBatch("replace into t_test values (?,?,?)", rows)
print(db.count("t_test"))
print(db.count("t_test", where="data_int > 90"))
# 更新数据
db.update("update t_test set data_int=? where data_key = ?", 100, 'test_key')
# 删除数据
db.delete("delete from t_test")
# 清空表
db.clear("t_test")
# 删除表
db.drop("t_test")
# 关闭
db.close()
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
jdbcer-0.0.2.tar.gz
(3.8 kB
view hashes)
Built Distributions
jdbcer-0.0.2-py3.9.egg
(2.5 kB
view hashes)
Close
Hashes for jdbcer-0.0.2-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36a69364173dd2706dd947917ca54d1d343db25d846ec7b24331be442c681885 |
|
MD5 | 4293e912fdba947744cf489379d621e0 |
|
BLAKE2b-256 | 971b4ce24b4bd0b2fe04d7d9449ad8d79d7e85c7720dd35d80fecd7b0e195992 |