datasette-pytables.git
4 years agoSome refactoring for treating tables and arrays in the same way
Javier Sancho [Wed, 30 May 2018 10:06:40 +0000 (12:06 +0200)]
Some refactoring for treating tables and arrays in the same way

4 years agoShow multidimensional arrays as string arrays
Javier Sancho [Wed, 30 May 2018 08:17:43 +0000 (10:17 +0200)]
Show multidimensional arrays as string arrays

4 years agoSome html basic tests
Javier Sancho [Tue, 29 May 2018 11:21:21 +0000 (13:21 +0200)]
Some html basic tests

4 years agoFix number of rows returned when limit is present or pagination is needed
Javier Sancho [Tue, 29 May 2018 11:03:09 +0000 (13:03 +0200)]
Fix number of rows returned when limit is present or pagination is needed

4 years agoTests for custom queries
Javier Sancho [Tue, 29 May 2018 10:36:26 +0000 (12:36 +0200)]
Tests for custom queries

4 years agoUncompleted tests for sql queries
Javier Sancho [Tue, 29 May 2018 07:39:29 +0000 (09:39 +0200)]
Uncompleted tests for sql queries

4 years agoExecute return always rows, truncated, description tuple
Javier Sancho [Mon, 28 May 2018 10:38:36 +0000 (12:38 +0200)]
Execute return always rows, truncated, description tuple

4 years agoRemove unnecessary import
Javier Sancho [Mon, 28 May 2018 08:50:13 +0000 (10:50 +0200)]
Remove unnecessary import

4 years agoTests for paginating tables and arrays
Javier Sancho [Fri, 25 May 2018 11:25:50 +0000 (13:25 +0200)]
Tests for paginating tables and arrays

4 years agoFix problems with arrays
Javier Sancho [Fri, 25 May 2018 11:25:16 +0000 (13:25 +0200)]
Fix problems with arrays

4 years agoUse max_returned_rows in conjuction with page_size for truncating
Javier Sancho [Fri, 25 May 2018 10:23:02 +0000 (12:23 +0200)]
Use max_returned_rows in conjuction with page_size for truncating

4 years agoShape testing
Javier Sancho [Thu, 24 May 2018 15:22:58 +0000 (17:22 +0200)]
Shape testing

4 years agoTest for arrays shape
Javier Sancho [Thu, 24 May 2018 14:57:14 +0000 (16:57 +0200)]
Test for arrays shape

4 years agoPyTables Row class based in list class for allow json serialization
Javier Sancho [Thu, 24 May 2018 14:56:09 +0000 (16:56 +0200)]
PyTables Row class based in list class for allow json serialization

4 years agoTest for non-existent tables
Javier Sancho [Thu, 24 May 2018 10:26:02 +0000 (12:26 +0200)]
Test for non-existent tables

4 years agoProcess some sqlite standard queries for obtaining tables info
Javier Sancho [Thu, 24 May 2018 10:24:52 +0000 (12:24 +0200)]
Process some sqlite standard queries for obtaining tables info

4 years agoTests for invalid custom queries and table page
Javier Sancho [Wed, 23 May 2018 14:43:27 +0000 (16:43 +0200)]
Tests for invalid custom queries and table page

4 years agoTruncate query results according to page_size limit
Javier Sancho [Wed, 23 May 2018 11:03:56 +0000 (13:03 +0200)]
Truncate query results according to page_size limit

4 years agoTest for custom query
Javier Sancho [Wed, 23 May 2018 10:22:21 +0000 (12:22 +0200)]
Test for custom query

4 years agoParse PyTables expressions without group/order/limit keywords in the query
Javier Sancho [Wed, 23 May 2018 10:08:51 +0000 (12:08 +0200)]
Parse PyTables expressions without group/order/limit keywords in the query

4 years agoTests for api homepage and api database page
Javier Sancho [Wed, 23 May 2018 09:50:01 +0000 (11:50 +0200)]
Tests for api homepage and api database page

4 years agoLittle support for arrays
Javier Sancho [Tue, 22 May 2018 11:19:28 +0000 (13:19 +0200)]
Little support for arrays

4 years agoSupport for 'distinct' and 'null' queries
Javier Sancho [Mon, 21 May 2018 15:20:42 +0000 (17:20 +0200)]
Support for 'distinct' and 'null' queries

4 years agoSupport PyTables expressions using the new parser
Javier Sancho [Fri, 18 May 2018 10:33:23 +0000 (12:33 +0200)]
Support PyTables expressions using the new parser

4 years agoReplace sqlparse with Mozilla SQL Parser
Javier Sancho [Fri, 18 May 2018 08:40:01 +0000 (10:40 +0200)]
Replace sqlparse with Mozilla SQL Parser

4 years agoCheck limit to return the appropiate number of rows
Javier Sancho [Wed, 16 May 2018 10:14:45 +0000 (12:14 +0200)]
Check limit to return the appropiate number of rows

4 years agoSupport queries in PyTables style
Javier Sancho [Tue, 15 May 2018 10:56:57 +0000 (12:56 +0200)]
Support queries in PyTables style

4 years agoProvide int types instead numpy types for allowing JSON encoding
Javier Sancho [Tue, 15 May 2018 10:27:51 +0000 (12:27 +0200)]
Provide int types instead numpy types for allowing JSON encoding

4 years agoFilter fields with conditions from datasette forms
Javier Sancho [Tue, 15 May 2018 08:30:25 +0000 (10:30 +0200)]
Filter fields with conditions from datasette forms

4 years agoResolve queries by rowid (nrow)
Javier Sancho [Mon, 14 May 2018 10:18:39 +0000 (12:18 +0200)]
Resolve queries by rowid (nrow)

4 years agoReturn default __getitem__ when label is a string
Javier Sancho [Fri, 11 May 2018 10:36:12 +0000 (12:36 +0200)]
Return default __getitem__ when label is a string

4 years agoConvert from bytes to strings
Javier Sancho [Fri, 11 May 2018 10:22:37 +0000 (12:22 +0200)]
Convert from bytes to strings

4 years agoReturn columns and rows ready to be shown on datasette
Javier Sancho [Fri, 11 May 2018 10:15:38 +0000 (12:15 +0200)]
Return columns and rows ready to be shown on datasette

4 years agoBasic execute method for queries
Javier Sancho [Fri, 11 May 2018 08:35:34 +0000 (10:35 +0200)]
Basic execute method for queries

4 years agoPyTables Connection class
Javier Sancho [Tue, 8 May 2018 10:58:12 +0000 (12:58 +0200)]
PyTables Connection class

4 years agoAdd connector type to inspect info
Javier Sancho [Tue, 8 May 2018 10:19:11 +0000 (12:19 +0200)]
Add connector type to inspect info

4 years agoInspect pytables files for getting tables info
Javier Sancho [Mon, 7 May 2018 10:53:47 +0000 (12:53 +0200)]
Inspect pytables files for getting tables info

4 years agoRemove useless decorator
Javier Sancho [Fri, 4 May 2018 11:02:15 +0000 (13:02 +0200)]
Remove useless decorator

4 years agoInitial commit
Javier Sancho [Fri, 4 May 2018 10:51:12 +0000 (12:51 +0200)]
Initial commit