Commit Graph

37 Commits

Author SHA1 Message Date
shortcutme 62a2ec7254
Make sure to commit before vacuum 2020-01-22 16:36:33 +01:00
shortcutme 71d32d7414
Less slow query loggin 2019-12-31 12:45:36 +01:00
shortcutme c161140a90
Add locking for db cursor 2019-12-18 16:43:46 +01:00
shortcutme dca1dcdd2d
Use always active connection in DbCursor 2019-12-17 14:28:52 +01:00
shortcutme 23f851343f
Fix exception when params is an iterator 2019-12-04 17:15:08 +01:00
shortcutme 12bfad8fe6
Don't execute query while commiting 2019-11-30 02:11:11 +01:00
shortcutme 594edc6e9a
Commit after executemany 2019-11-30 02:10:40 +01:00
shortcutme 99304a09ca
Log long db queries 2019-11-30 02:10:11 +01:00
shortcutme fca9db7972
Try fix Recursive use of cursors ProgrammingError by creating new cursor for every execute and move Lock to db 2019-11-27 03:07:08 +01:00
d9xr92 89e8fd3d3a potential fix for #2323 (#2324)
* potential fix for #2323

* Update DbCursor.py

* replaced RLock with Lock
2019-11-23 13:22:36 +01:00
shortcutme 608a411d97
Db table rebuild as debug message 2019-10-16 15:43:28 +02:00
shortcutme f4f0e2afa8
Allow like parameters in database queries 2019-07-10 03:14:09 +02:00
shortcutme 7bef78e10f
Fix newsfeed sql query with many parameters 2019-04-29 16:44:13 +02:00
shortcutme 446641c31c
Always commit before Db VACUUM 2019-04-15 22:11:44 +02:00
shortcutme 61c72ac3ea
Fix SQLite concurrency errors 2019-03-18 03:36:12 +01:00
shortcutme a1b5dad1c8
New Db connection type to avoid corruption 2019-03-16 02:40:32 +01:00
shortcutme 13c453d610
Embed query values if more than 100 specified 2019-01-26 20:40:34 +01:00
shortcutme 47316741c1
Allow only CREATE in indexes 2018-12-15 17:48:19 +01:00
shortcutme 1fc364fa07
Remove unused lines from dbCursor 2018-10-15 13:01:44 +02:00
shortcutme 089bb92f70
Record last query time on every command 2018-01-19 02:18:19 +01:00
shortcutme a3a7af73bd
Fix named db query list parameters when query ends with parameter 2018-01-05 20:22:25 +01:00
Ivanq 8986d8037a Typos 2017-12-30 12:16:16 +03:00
Ivanq d97631fb8c str() 2017-12-30 12:06:07 +03:00
Ivanq be1eb14fd0 Handle dict value being a list 2017-12-30 10:06:05 +03:00
shortcutme 6e55c8b7c7
Allow ranged SQL queries 2017-10-04 13:10:41 +02:00
shortcutme 38c663ee95
Use WHERE 1 for queries without argument 2017-10-04 13:10:26 +02:00
shortcutme 551aa3ef67
Raise exception on unsupported dbschema version 2017-07-18 20:53:52 +02:00
shortcutme 0d9e3baebc Formatting 2016-11-07 23:09:06 +01:00
shortcutme 8955998d25 Support insertOrUpdate in database cursor 2016-11-07 23:08:57 +01:00
ZeroNet 721bed76a9 Type 3 dbschema version for merger sites 2016-08-10 12:46:27 +02:00
HelloZeroNet 687a848292 Version 0.3.6, Rev879, Fix sidebar error on description missing, New trayicon, New favicon, Disable some functions on MultiUser proxies, New homepage, Replace only the last ? in SQL queries, Alwaays grant ADMIN permission to homepage site, Announce before publish if no peers, configSet, serverShutdown, ADMIN WebsocketAPI command, Stop Tor client before updating, Ignore peer ip packing error, Ignore db files from git, Fix safari ajax error when UiPassword enabled 2016-02-02 11:40:45 +01:00
HelloZeroNet e9d2cdfd37 Version 0.3.5, Rev830, Full Tor mode support with hidden services, Onion stats in Sidebar, GeoDB download fix using Tor, Gray out disabled sites in Stats page, Tor hidden service status in stat page, Benchmark sha256, Skyts tracker out expodie in, 2 new tracker using ZeroNet protocol, Keep SSL cert option between restarts, SSL Certificate pinning support for connections, Site lock support for connections, Certificate pinned connections using implicit SSL, Flood protection whitelist support, Foreign keys support for DB layer, Not support for SQL query helper, 0 length file get bugfix, Pex onion address support, Faster port testing, Faster uPnP port opening, Need connections more often on owned sites, Delay ZeroHello startup message if port check or Tor manager not ready yet, Use lockfiles to avoid double start, Save original socket on proxy monkey patching to get ability to connect localhost directly, Handle atomic write errors, Broken gevent https workaround helper, Rsa crypt functions, Plugin to Bootstrap using ZeroNet protocol 2016-01-05 00:20:52 +01:00
HelloZeroNet ee70e2f022 Version 0.3.4, Rev656, CryptMessage plugin for AES and ECIES encryption, Added pyelliptic lib for OpenSSSL based encryption methods, Test CryptMessage plugin, Force reload content.json before signing and after write, Escaped Sql IN queries support, Test Sql parameter escaping, ui_websocket Test fixture, Plugin testing support, Always return websocket errors as dict, Wait for file on weboscket fileGet command if its already in bad_files queue, PushState and ReplaceState url manipulation support in wrapper API, Per auth-address localstorage, Longer timeout for udp tracker query 2015-12-10 21:36:20 +01:00
HelloZeroNet b5ecb62bc6 rev280, The whole project reformatted to PEP8, UiRequest getPosted to query posted variables 2015-07-12 20:36:46 +02:00
HelloZeroNet b2e2453e58 rev242, Implicit SSL support for the future, Exist typo fix 2015-06-17 00:49:46 +02:00
HelloZeroNet 7e4f6bd38e version 0.3.0, rev187, Trusted authorization sites support, --publish option on signing, cryptSign command line option, OpenSSL enabled on OSX, Crypto verify allows list of valid addresses, Option for version 2 json DB tables, DbCursor SELECT parameters bugfix, Add peer to site on ListModified, Download blind includes when new site added, Publish command better messages, Multi-threaded announce, New http Torrent trackers, Wait for dbschema.json on query, Handle json import errors, More compact writeJson storage command, Testcase for signing and verifying, Workaround to make non target=_top links work, More clean UiWebsocket command route, Send cert_user_id on siteinfo, Notify other local clients on local file modify, Option to wait for file download before sql query, File rules websocket API command, Cert add and select, set websocket API command, Put focus on innerframe, innerloaded wrapper api command to add hashtag, Allow more file error on big sites, Keep worker running after stuked on done task, New more stable openSSL layer that works on OSX, Noparallel parameter bugfix, RateLimit allowed again interval bugfix, Updater skips non-writeable files, Try to close openssl dll before update 2015-05-25 01:26:33 +02:00
HelloZeroNet 3b8d49207e version 0.2.6, database support, dbrebuild and dbquery startup commands, connection firstchar error bugfix, log python gevent msgpack lib versions, sitestorage class for site file operations, dbquery websocket api command 2015-03-19 21:19:14 +01:00