zynfly/sqliteviz
1
0
Fork 0
mirror of https://github.com/lana-k/sqliteviz.git synced 2025-12-07 02:28:54 +08:00
Code Issues Projects Releases Wiki Activity
329 Commits 5 Branches 44 Tags
0.15.1
Commit Graph

100 Commits

Author SHA1 Message Date
lana-k
5017b55944 Pivot implementation and redesign (#69) 
- Pivot support implementation 
- Rename queries into inquiries
- Rename editor into workspace
- Change result set format
- New JSON format for inquiries
- Redesign panels
 2021-08-04 22:20:51 +02:00
lana-k
0f2dc9f11e fix ISO time columns when no column names #66 2021-07-15 22:36:07 +02:00
saaj
3a6628cab9 Pre-built custom sql.js for sqliteviz (#62) 
* Proof-of-concept pre-built custom sql.js

* Rewrite Makefile as a couple of comprehensible Python scripts

* Add link to a blog post about transitive closure in SQLite

* Remove eval extension -- no much point as it only returns a string

* Consistently use existing Path objects

* Add basic tests scalar functions from extension-functions.c

* Test presence of functions from the rest of built extensions

* Use the same sqlite.com domain

* Add a couple SQLite compile flags that may make it a bit faster

* Add regexpi function test

* Add node about regexpi and REGEXP operator

* Workaround first build failure, rebuild lock file and minor fixes
 2021-07-03 16:43:43 +02:00
lana-k
f9edeafd40 fix csv import with ISO dates #64 2021-07-01 19:07:59 +02:00
lana-k
cf4b83f7d4 fix csv result when column names have spaces #59 2021-06-17 12:23:44 +02:00
lana-k
99a10225a3 CSV import as a table and db connection rework 
- Add csv to existing db #32
- [RFE] Simplify working with temporary tables #53
 2021-05-24 19:40:47 +02:00
lana-k
414a116f94 Lost focus in SQL query editor #54 2021-05-19 22:50:56 +02:00
lana-k
3e503f85a9 Stub app-diagnostic-info in tests 2021-05-19 21:52:42 +02:00
lana-k
aa52048d51 Fix file type detection #48 
file.type is empty on some Windows machines (Registry settings affects)
 2021-05-17 21:32:09 +02:00
lana-k
33913f8f5c fix lint 2021-05-14 16:47:01 +02:00
lana-k
a3fb38b23c SQL query execution state in UI #3 
- use LoadingIndicator
- use Logs
 2021-05-14 16:42:58 +02:00
lana-k
bcaebd4840 Create an empty database #44 2021-05-05 21:44:44 +02:00
lana-k
4619461af8 change period format 2021-05-05 15:08:54 +02:00
lana-k
cc483f4720 change code structure 2021-05-04 14:13:58 +02:00
lana-k
b9844b8696 refine pwa app icons 2021-05-02 20:46:27 +02:00
lana-k
00e434e142 fix loading db after csv: 
new tab is not opened now
 2021-05-02 14:09:02 +02:00
lana-k
5d6280abec add default table in hint options 2021-05-02 14:04:46 +02:00
lana-k
7a39e905b9 trim csv column names 2021-04-30 20:49:37 +02:00
lana-k
9b6aa3d6c7 add manifest and offline support #12 2021-04-29 16:19:25 +02:00
lana-k
92022f9083 resolve exportToFile in a test 2021-04-28 11:41:25 +02:00
lana-k
15636fed5f increase timeout for tests; 
fix warnings in tests
 2021-04-28 10:46:40 +02:00
lana-k
9ed53e0d25 Export db #34 2021-04-27 22:51:36 +02:00
lana-k
35baaf2722 Update schema view after script running #38 2021-04-27 15:54:51 +02:00
lana-k
453098b410 Support all CSV media types #37 2021-04-27 13:42:58 +02:00
lana-k
a469de3674 dasharray with units (fix for Firefox) #27 2021-04-24 16:54:16 +02:00
lana-k
97c0c6191b run tests in Firefox 2021-04-24 16:00:31 +02:00
lana-k
9a91dd19bf Fix delimiter highlighting in Firefox #27 
input:first-line doesn't work in Firefox.
So, we use input background instead
 2021-04-23 16:36:52 +02:00
lana-k
d0c624a3cc Show result of the last query in a script #36 2021-04-22 17:01:46 +02:00
lana-k
9e29a12ebb add ctrl+enter for running queries #35 2021-04-22 14:53:14 +02:00
lana-k
628e9cee62 add tests for DbUploader #27 2021-04-22 14:04:52 +02:00
lana-k
803622f18f move tests to tests folder 
rename util modules
rename DbUpload to DbUploader
add tests for DbUploader component #27
 2021-04-21 11:05:56 +02:00
lana-k
edd45b317a add new sql.js module and tests #27 2021-04-19 15:01:40 +02:00
lana-k
6ce5d2b201 add tests for DelimiterSelector #27 2021-04-16 15:14:41 +02:00
lana-k
5c9a5560b7 add test for disabled state for checkBox #27 2021-04-13 21:31:35 +02:00
lana-k
13a8b33815 add tests for database module #27 2021-04-13 11:20:15 +02:00
lana-k
5ba371e339 fix lint errors 2021-04-12 18:25:21 +02:00
lana-k
5db8376f95 add tests for readAsArrayBuffer method #27 2021-04-12 18:23:48 +02:00
lana-k
be56079e4e add tests for LoadingIndicator component #27 2021-04-12 16:06:41 +02:00
lana-k
a7c8c29624 add tests for Logs component #27 2021-04-12 14:28:16 +02:00
lana-k
9ce1c27cf5 fix lint errors 2021-04-11 22:19:14 +02:00
lana-k
b2d21cc859 add test for setDb store mutation #27 2021-04-11 22:11:44 +02:00
lana-k
1945467dc7 restore sinon in afterEach hook 2021-04-11 21:52:09 +02:00
lana-k
73c0936927 add tests for csv module #27 2021-04-11 21:51:44 +02:00
lana-k
8867092601 add tests for dbUtils module #27 2021-04-10 21:19:00 +02:00
lana-k
c7039e144a add test for time,js module #27 2021-04-10 20:50:42 +02:00
lana-k
b30eeb6788 add CSV support #27 2021-04-10 18:24:53 +02:00
lana-k
a8e12d64a0 tests for MyQueries 2021-03-13 17:09:41 +01:00
lana-k
8decda51a4 add tests for splitter and touch events 2021-03-13 16:58:45 +01:00
lana-k
d52f822c15 fix main menu test 2021-03-13 16:58:18 +01:00
lana-k
a457f967c0 add tests for MainMenu component 2021-03-03 22:42:55 +01:00