example/base.py · sheen/sqlite_queue_python

Fetch the repository succeeded.

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 9

sheen/sqlite_queue_python

forked from KAAAsS/sqlite_queue_python

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Manage

master

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 0

sqlite_queue_python

example

base.py

base.py 1.95 KB

import sqlite_queue

# 配置数据库
queue = sqlite_queue.SqliteQueue('test1.db')
# 防止线程在测试时被杀
queue.setDaemon(False)
# 启动线程
queue.start()

# 创建表
queue.register_execute("""CREATE TABLE `stocks`(
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 trans TEXT,
 symbol TEXT,
 price REAL,
 qty REAL,
 date DATE
 );""")

# 插入单条数据
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES ('BUY','RHAT',35.14,100,'2017年01月01日')")

# 预编译插入数据(更加安全,防止注入)
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES (?,?,?,?,?)", ('BUY', 'BlLl', 12.450, 18000, '2017年01月01日'))

# 批量插入数据
purchases = [('BUY', 'DOUB', 500, 233, '2017年03月01日'),
 ('SELL', 'S6', 1, 4369, '2017年04月01日'),
 ('BUY', 'BlLl', 12.450, 18000, '2016年12月01日')]
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES (?,?,?,?,?)", purchases) # list会直接被识别为批量插入

# 回调返回插入的行数
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES (?,?,?,?,?)", ('SELL', 'LOL', 1, 4369, '2017年04月01日'),
 callback=lambda lst_rowid: print('S' + str(lst_rowid)))

# 测试select,回调读入数据
queue.register_execute("SELECT * FROM stocks", callback=lambda data: print(data))

# 测试预编译select,回调读入数据
queue.register_execute(
 "SELECT * FROM stocks WHERE `price` >= ? AND `trans` IN (?, ?) "
 "AND `date` BETWEEN ? AND ? ORDER BY `price`", (30, 'BUY', 'SELL', '2017年02月01日', '2017年12月31日'),
 callback=lambda data: print(data))

Copy Edit Raw Blame History

KAAAsS authored 2017年02月06日 13:47 +08:00 . 增加一些示例

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47

import sqlite_queue

# 配置数据库
queue = sqlite_queue.SqliteQueue('test1.db')
# 防止线程在测试时被杀
queue.setDaemon(False)
# 启动线程
queue.start()

# 创建表
queue.register_execute("""CREATE TABLE `stocks`(
 id INTEGER PRIMARY KEY AUTOINCREMENT,
 trans TEXT,
 symbol TEXT,
 price REAL,
 qty REAL,
 date DATE
 );""")

# 插入单条数据
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES ('BUY','RHAT',35.14,100,'2017-01-01')")

# 预编译插入数据(更加安全,防止注入)
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES (?,?,?,?,?)", ('BUY', 'BlLl', 12.450, 18000, '2017-01-01'))

# 批量插入数据
purchases = [('BUY', 'DOUB', 500, 233, '2017-03-01'),
 ('SELL', 'S6', 1, 4369, '2017-04-01'),
 ('BUY', 'BlLl', 12.450, 18000, '2016-12-01')]
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES (?,?,?,?,?)", purchases) # list会直接被识别为批量插入

# 回调返回插入的行数
queue.register_execute("INSERT INTO stocks (`trans`,`symbol`,`price`,`qty`,`date`) "
 "VALUES (?,?,?,?,?)", ('SELL', 'LOL', 1, 4369, '2017-04-01'),
 callback=lambda lst_rowid: print('S' + str(lst_rowid)))

# 测试select,回调读入数据
queue.register_execute("SELECT * FROM stocks", callback=lambda data: print(data))

# 测试预编译select,回调读入数据
queue.register_execute(
 "SELECT * FROM stocks WHERE `price` >= ? AND `trans` IN (?, ?) "
 "AND `date` BETWEEN ? AND ? ORDER BY `price`", (30, 'BUY', 'SELL', '2017-02-01', '2017-12-31'),
 callback=lambda data: print(data))