Javier Goizueta
e247fda694
Fix superuser template functions
...
Superuser functions were overriding their user/org parameters with the
values from the database/role, so the user was incorrect.
2017-03-30 13:18:38 +02:00
Javier Goizueta
2ec38e93f0
Fix migration script permissions for superuser functions
2017-03-29 17:46:31 +02:00
Javier Goizueta
aac89e0236
New versions 0.16.0 (client), 0.23.0 (server), 0.15.0 (python)
2017-03-28 17:53:40 +02:00
Javier Goizueta
4b18e1f601
Rename variable
2017-03-28 10:42:03 +02:00
Javier Goizueta
970d828768
Remove unneeded ERB options
2017-03-28 10:39:23 +02:00
Javier Goizueta
39878ef542
Rename some template functions internal terms
...
* credentials => user_org
* private => superuser
2017-03-28 10:37:21 +02:00
Javier Goizueta
7101c8d8e8
Expose client-side rate limit configuration interface
...
The client functions to make configuration changes are not publicly available
(require a super user) and they have username, orgname parameters like the
server-sixe functions
2017-03-22 16:31:45 +01:00
Mario de Frutos
d7bb31be9a
Client 0.15.0 version release artifacts
2017-02-01 10:52:56 +01:00
Mario de Frutos
f0d96541b6
Fixed client tests
2017-01-26 17:00:56 +01:00
John Krauss
8094e79d0b
fix some bugs in client test
2017-01-26 12:27:30 +01:00
John Krauss
bfd7df8c8a
tmp commit
2017-01-26 12:27:29 +01:00
John Krauss
e81f005ce9
adding server tests, interface to generate client sql code
2017-01-26 12:27:29 +01:00
Rafa de la Torre
9791a5bada
Add cartodb to the search path
...
See
https://github.com/CartoDB/dataservices-api/issues/324#issuecomment-269614566
2016-12-29 12:11:00 +01:00
Javier Goizueta
629555e193
Generate release 0.14.1
...
This release cantains no actual code changes, only the
use of search_path at the top of the install/migrate scripts
2016-12-21 11:40:55 +01:00
Javier Goizueta
18df3368ef
Set search path before installing/update the extension
...
See #324
2016-12-20 12:57:40 +01:00
Rafa de la Torre
15438db59b
Client 0.14.0 control and upgrade/downgrade files
2016-12-14 16:52:40 +01:00
Rafa de la Torre
3c60f3e93b
Minor improvement for test #314
...
Make sure we return an empty record and that the mentioned code is never
reached.
2016-12-14 13:30:30 +01:00
Rafa de la Torre
8692fb12ca
Add test case for multi_field #314
2016-12-14 12:57:51 +01:00
Rafa de la Torre
4523b2e04d
Add test for multi_row case #314
2016-12-14 12:53:51 +01:00
Rafa de la Torre
5c8dbe91eb
Add test for simple interface case #314
2016-12-14 12:39:56 +01:00
Rafa de la Torre
99b76afc33
Some versioning facilities for make release #314
2016-12-14 12:08:26 +01:00
Rafa de la Torre
c97f03b2e3
Add generated file to .gitignore #314
2016-12-14 12:06:51 +01:00
Rafa de la Torre
cd653bc496
Add diagnostics info to rest of cases #314
2016-12-14 10:35:44 +01:00
Rafa de la Torre
610cfaab57
Move exception info vars to the top #314
2016-12-14 10:33:50 +01:00
Rafa de la Torre
58b1713a0d
Make the functions private #314
2016-12-14 10:27:43 +01:00
Rafa de la Torre
842be0ba85
Add diagnostics info to warning #314
2016-12-13 19:19:03 +01:00
Rafa de la Torre
dbd5911a2a
Implement the multi_field case #314
2016-12-13 17:00:55 +01:00
Rafa de la Torre
e53a39875e
Implement the multi_row case #314
2016-12-13 16:51:11 +01:00
Rafa de la Torre
4cd72616ca
Fix the no multi_row, no multi_field case #314
...
Fix for the `ERROR: control reached end of function without RETURN` but
now need to implement for the two other cases.
2016-12-13 16:46:58 +01:00
Rafa de la Torre
fae7889fe3
First take at producing exception-safe functions #314
2016-12-13 16:27:38 +01:00
Rafa de la Torre
59ed8b88a3
New client version 0.13.0 #302
2016-11-25 11:28:10 +01:00
Rafa de la Torre
9c6eabc59e
Do not enforce types for params #302
...
As types are tied to a schema, they don't get along very well with
pl/proxy. Do not use them for the service_type.
2016-11-24 18:38:33 +01:00
Rafa de la Torre
0d92eb4ba8
Fix issue with multi-field values #302
...
The difference between
```
=> select * from cdb_service_quota_info();
service | monthly_quota | used_quota | soft_limit | provider
----------------+---------------+------------+------------+------------------
isolines | 1000 | 0 | f | heremaps
hires_geocoder | 5 | 2 | f | mapzen
routing | 1500000 | 0 | f | mapzen
observatory | 1000 | 0 | f | data observatory
(4 rows)
```
and
```
=> select cdb_service_quota_info();
cdb_service_quota_info
-------------------------------------------
(isolines,1000,0,f,heremaps)
(hires_geocoder,5,2,f,mapzen)
(routing,1500000,0,f,mapzen)
(observatory,1000,0,f,"data observatory")
(4 rows)
```
is important to pl/proxy. In the later case, rows only have one field
(a tuple) and it complains with "Got too few fields from remote end".
2016-11-24 18:24:17 +01:00
Rafa de la Torre
769b740ba4
Rename service_params to service_quota_info #302
2016-11-24 17:46:07 +01:00
Rafa de la Torre
c2ede37d75
Revert internal geocoder related stuff #302
2016-11-24 17:45:19 +01:00
Rafa de la Torre
f07d2f9302
Remove the no_params from client generator #302
2016-11-24 13:27:32 +01:00
Rafa de la Torre
37a3214f67
Add quota functions to client #302
2016-11-24 13:05:31 +01:00
Mario de Frutos
f0474852f2
Client 0.12.1 and server 0.18.1 artifacts
2016-11-11 18:27:37 +01:00
Mario de Frutos
7f963d2f7a
Client update to type obs_meta_geometry with new types
2016-11-11 18:13:35 +01:00
Mario de Frutos
25cd40164a
Client init new version 0.12.1
2016-11-11 17:55:35 +01:00
Mario de Frutos
dac5e76e98
Changed JSONB in legacybuildermetadata function to JSON
2016-11-10 18:07:06 +01:00
Mario de Frutos
e6963198dc
Client version 0.12.0 artifact
2016-11-10 16:02:58 +01:00
Mario de Frutos
38f2592b22
Client addition of observatory meta functions
2016-11-10 11:29:18 +01:00
Mario de Frutos
94099540d7
New version 0.12.0 sql files
2016-11-09 11:21:29 +01:00
Mario de Frutos
b403e1d69a
Move old 0.11.1 version to a proper folder
2016-11-09 11:21:29 +01:00
Mario de Frutos
623faf1a22
Added make release option for client
2016-11-09 11:21:28 +01:00
Carla Iriberri
f8caf4314d
Release client 0.11.1
2016-09-07 17:52:53 +02:00
Carla
cc8f93c535
Use real function name for compatibility
2016-09-07 15:40:20 +02:00
Carla Iriberri
46a934b178
Client 0.11.0
2016-09-01 18:07:44 +02:00
Carla Iriberri
a6d546f2ee
Bump version client 0.11.0
2016-09-01 17:42:57 +02:00
Carla
fc99f7aba9
Merge pull request #267 from CartoDB/augment_revamp_analysis
...
Table-level OBS_GetMeasue revamp
2016-09-01 17:21:56 +02:00
Carla Iriberri
e959873b32
Check server return
2016-09-01 16:37:54 +02:00
Carla Iriberri
78add220cd
New tests for restructuration - client
2016-09-01 15:46:23 +02:00
Carla Iriberri
cf2f86136b
Update signatures in functions
2016-09-01 15:37:08 +02:00
Carla Iriberri
fb183b07ee
Update grants for new signatures
2016-09-01 15:34:57 +02:00
Carla Iriberri
5ab727bcb6
Remove warnign and fix server_conn_str path
2016-09-01 14:36:12 +02:00
Carla Iriberri
1e9b551160
Add populate table function and several fixes
2016-08-30 16:38:44 +02:00
Carla Iriberri
fc291a7c63
First steps
2016-08-29 18:07:58 +02:00
Mario de Frutos
71d5ce951a
Use mapzen as first option for the namedplace geocoding
2016-08-26 16:39:25 +02:00
Mario de Frutos
a5696f84b1
Release 0.10.2 client artifacts
2016-08-10 18:22:03 +02:00
Carla Iriberri
1107371f6f
Edit tests accordingly to default values removal
2016-08-10 16:25:26 +02:00
Carla Iriberri
fd80f3b99f
Remove all default values, including intersects and geomids
2016-08-10 16:25:26 +02:00
John Krauss
d63f2ba4d5
Replace all 'area' defaults for with NULL. Fixes #235
2016-08-10 16:25:26 +02:00
Carla
0e556ee9ac
Update README.md
2016-07-29 17:52:18 +02:00
Carla
70f290cdcf
Add user conf in cdb conf
2016-07-29 17:51:38 +02:00
Carla Iriberri
a68ab22c89
Release client 0.10.1
2016-07-26 17:53:51 +02:00
Carla
a5bf57a197
fix alias
2016-07-19 17:59:29 +02:00
Carla
5f32f7e2cd
add indexes in temp table not in user table
2016-07-19 17:57:34 +02:00
Carla
91b1648f12
test add index
2016-07-19 12:55:40 +02:00
Carla
261fff7873
Merge pull request #220 from CartoDB/bump_version_dev
...
Bump client to 0.10.0 and server to 0.13.0
2016-07-12 11:12:40 +02:00
Carla Iriberri
3b524ee3bc
Add dumpversion
2016-07-11 18:55:31 +02:00
Carla Iriberri
5bc2d974ac
Adding OBS_DumpVersion function
2016-07-11 18:25:39 +02:00
Carla
9fffd24133
drop functions before types
2016-07-11 17:13:23 +02:00
Carla Iriberri
7d24ba4efb
Add grants to public functions
2016-07-11 14:55:06 +02:00
Carla Iriberri
65d8ab3c74
Bump client to 0.10.0 sevrer to 0.13.0
2016-07-11 14:52:14 +02:00
Carla Iriberri
7b1132b4d2
Fix conflicts take 4
2016-07-11 12:18:07 +02:00
Carla Iriberri
62f866fb55
Remove versioning take 2
2016-07-11 11:45:31 +02:00
Carla Iriberri
99d21f9a84
bring master to fix versioning issues
2016-07-11 11:29:06 +02:00
Carla
ca1461c020
Update README.md
2016-07-11 10:51:51 +02:00
Carla
d22bf661e1
typo in function signature in downgrade
2016-07-07 11:27:02 +02:00
Carla Iriberri
8f7e94e7d6
Add grants to client functions
2016-07-07 10:12:11 +02:00
Carla Iriberri
442a9a8433
Bump client version to 0.9.0
2016-07-07 09:51:52 +02:00
Rafa de la Torre
9c87762b8b
Fix typo in client interface
2016-07-06 20:03:17 +02:00
Rafa de la Torre
99798f2618
Integrate isodistance into SQL API
2016-07-06 19:40:40 +02:00
Rafa de la Torre
3dacb43a9a
Add cdb_mapzen_isochrone to client
...
On behalf of @iriberri.
2016-07-06 13:18:54 +02:00
Carla Iriberri
6d35cff9c7
Exposes geocoder providers in public geocoder functions
...
Add config function in postgres explicitly to get MapzenGeocoderConfig.
Bump versions for client and server APIs. New MapzenGeocoderConfig
included to be able to use current QuotaServices with non-configured
users.
2016-07-05 11:13:43 +02:00
Carla Iriberri
92b89b7408
Prepare new version for client and server
2016-07-01 12:24:04 +02:00
Carla Iriberri
b3c8c86561
Add client tests for augment table and get table
2016-07-01 12:24:04 +02:00
Carla Iriberri
ffe44ce94e
Fully qualify, several fixes and variable renaming
2016-07-01 12:23:57 +02:00
Rafa de la Torre
d517c62e6f
Make cdb_dataservices_server.OBS_GetProcessedData "public"
2016-07-01 12:18:49 +02:00
Rafa de la Torre
01edf81600
Fix plproxy func that returns dynamic records
2016-07-01 12:18:49 +02:00
Rafa de la Torre
c0ad0412bf
Return result instead of hardcoded true value
2016-07-01 12:18:49 +02:00
Rafa de la Torre
6886a8639f
Remove unnecessary casting in function call
2016-07-01 12:18:49 +02:00
Rafa de la Torre
1ed02c69bc
Qualify types with the schema name
2016-07-01 12:18:49 +02:00
Carla
6c627fb207
Add augment functions
2016-07-01 12:18:11 +02:00
Mario de Frutos
175d5e716d
Client side SQL file for version 0.7.0
2016-05-31 10:50:51 +02:00
Mario de Frutos
0fc9469430
Client side for obs_getmeasurebyid
2016-05-30 18:12:21 +02:00
Carla Iriberri
21aac960a6
Add function cdb_routing_with_waypoints
...
Add routing with waypoints functions to client and server. Includes
signature checks tests for the Postgresql functions and unit and
integration tests for the Python library.
Add client v0.6.0 and server v0.9.0
2016-05-25 11:38:37 +02:00
Mario de Frutos
22883352e1
Version file for client 0.5.0
2016-05-16 11:03:57 +02:00
Mario de Frutos
5d6c3d7b11
Maintain old snapshot functions to avoid break compatibility
2016-05-16 10:25:27 +02:00
Mario de Frutos
8680c9cbd0
We let the old qlik snapshots functions but we make new ones with the new snapshot part from observatory'
2016-05-16 10:25:27 +02:00
Carla Iriberri
64d2afb536
Client side for the new data observatory functions (v0.5.0)
2016-05-16 10:25:26 +02:00
Mario de Frutos
5de6a2430d
Fix client downgrade script problem
2016-05-09 09:42:13 +02:00
Mario de Frutos
c3b695d1e7
Client version 0.4.0
2016-04-20 16:04:32 +02:00
Mario de Frutos
dda13033b0
Client data observatory functions
2016-04-20 15:58:38 +02:00
Mario de Frutos
b4f4ac1d99
Removed the old versioning system
2016-04-20 11:18:24 +02:00
Mario de Frutos
e867394261
Move the old version files to a folder
2016-03-08 16:47:48 +01:00
Mario de Frutos
df195a9539
Client part of the mapzen integration
2016-02-26 10:49:10 +01:00
Mario de Frutos
d9ca7911e4
Options parameter in the isolines functions has an empty array by defaul
2016-02-11 18:23:23 +01:00
Mario de Frutos
8d18e50cc5
Fixed error in the return part of the isochrone function
2016-02-11 11:35:47 +01:00
Mario de Frutos
0ca20196c0
Client with isodistance and isochrone feature working
2016-02-11 11:10:12 +01:00
Carla
9029e38216
Add 0.2.0. in gitignore
2016-02-09 16:09:41 +01:00
Carla Iriberri
b8c7015994
Add files for client side routing
...
This commit adds the new function interfaces and contains the frozen 2.0
version file as well as the upgrade/downgrade files for the previous
version according to the new function additions.
2016-02-09 15:56:50 +01:00
Mario de Frutos
05cd8f5c5c
Dataservices client 0.2.0 scaffold
2016-02-09 10:51:19 +01:00
Mario de Frutos
4b31a15027
Geocoder client renamed to dataservices client extension
2016-02-05 17:57:56 +01:00
Mario de Frutos
cbfe1b600f
Moved the interface renderer logic to the client
2016-02-04 20:07:34 +01:00
Mario de Frutos
1367c46957
Added automatic generated files warning header
2016-02-04 10:38:12 +01:00
Mario de Frutos
bb629dfe4b
Change the signature name for the geocoder street point function
2016-01-26 16:22:28 +01:00
Mario de Frutos
62ade7f1a0
Extract the username and the orgname as strings
2016-01-22 19:18:34 +01:00
Mario de Frutos
54b45c8076
Add schema for the get config function
2016-01-22 16:30:38 +01:00
Mario de Frutos
c58d7229a2
Changed the regress part of the makefile to execute the tests in other location
2016-01-22 16:23:31 +01:00
Rafa de la Torre
bd4a343e93
Fix typo (missing semicolons)
2016-01-22 16:19:15 +01:00
Rafa de la Torre
97a918306f
Modify the Makefile to install everything in place
...
Install everything by using the underlying postgres extension makefiles
infrastructure.
2016-01-22 16:14:16 +01:00
Rafa de la Torre
d9c016d242
Remove uneeded target from Makefile
2016-01-22 15:51:05 +01:00
Rafa de la Torre
ba7af1ca2c
Remove uneeded vars in Makefile
2016-01-22 15:50:54 +01:00
Rafa de la Torre
56a4c60c8f
Add already released cdb_geocoder_client--0.0.1.sql to VC
2016-01-22 15:32:16 +01:00
Mario de Frutos
c0cef3dc80
Tests and interfaces versioned
2016-01-22 13:05:33 +01:00
Mario de Frutos
7cce491a13
Dont use the defaults in the grant script
2016-01-22 10:55:07 +01:00
Mario de Frutos
49941a78f3
Change client version to 0.1.0
2016-01-22 10:40:44 +01:00
Mario de Frutos
bd8ec71855
Create update extension files for client too
2016-01-22 10:37:40 +01:00
Mario de Frutos
61ad671fbd
Update README.md
2015-12-23 16:00:51 +01:00
Mario de Frutos
922c531313
Added orgname to the arguments we pass to the server
2015-12-03 11:03:10 +01:00
Mario de Frutos
57c5b3ac19
Check for empty username
2015-12-02 19:12:11 +01:00
Mario de Frutos
941e7084e6
Change functions to user username and remove JSON config passed as argument
2015-12-02 18:54:49 +01:00
Mario de Frutos
ba7b8cfa7d
Function to get the username based user type (org or non-org)
2015-12-02 18:54:27 +01:00
Mario de Frutos
06f033b72a
Added the organization public user to the api key check
2015-11-27 13:20:55 +01:00
Mario de Frutos
97cab091b6
Added cdb_* prefix to all the functions
2015-11-24 15:36:52 +01:00
Mario de Frutos
2b141452b4
Changed api key verifying to client instead of server
2015-11-24 12:44:52 +01:00
Mario de Frutos
2c7223b385
Revert "Change ipaddress geocode to match the server signature"
...
This reverts commit b57dc82f42
.
2015-11-24 10:06:55 +01:00
Mario de Frutos
b57dc82f42
Change ipaddress geocode to match the server signature
2015-11-24 09:25:21 +01:00
Mario de Frutos
963da6c5c7
Add properties for user and geocoder config keys instead of hardcode it in the template
2015-11-23 13:09:03 +01:00
Mario de Frutos
e09af1463d
Change some visual style in generated functions
2015-11-23 13:03:37 +01:00
Mario de Frutos
f37fba6392
Added readme for the client extension
2015-11-23 10:12:06 +01:00
Mario de Frutos
d53857f737
Added user and geocoder config and removed tx_id from client templates
2015-11-20 12:07:34 +01:00
Rafa de la Torre
a33dfd18ec
Use function return_type instead of hardcoded Geometry
2015-11-19 15:44:51 +01:00
Rafa de la Torre
a6f3b74fd5
Add generated files to .gitignore
2015-11-18 19:24:01 +01:00
Rafa de la Torre
247e73b1b5
Fix typo in two tests
2015-11-18 19:10:35 +01:00
Rafa de la Torre
716b8dc43e
Fix typo in template
2015-11-18 18:00:08 +00:00
Rafa de la Torre
0d85afc99a
Adapt to yaml (WIP)
2015-11-18 18:38:06 +01:00
Rafa de la Torre
c82359f7d7
Generate files in Makefile (WIP)
2015-11-18 16:17:36 +01:00
Rafa de la Torre
0163700414
Fix merge conflict
2015-11-17 11:37:50 +00:00
Carla Iriberri
6d7156e309
Fixing conflicts
2015-11-17 12:35:07 +01:00
Carla Iriberri
c7b6db3560
Fixes IP address function naming and another CBD typo in postal codes
2015-11-17 12:26:18 +01:00
Rafa de la Torre
b977277052
cartodb as dependency and use its config table #37
...
in the client.
2015-11-17 12:01:18 +01:00
Carla Iriberri
7cba8fd679
Fixes cdb typo in out
2015-11-17 11:50:16 +01:00
Carla
35ed467c69
Update 50_ipaddresses_test.out
2015-11-17 11:36:13 +01:00
Carla
74fd173e63
Update 50_ipaddresses_test.sql
2015-11-17 11:35:12 +01:00
Rafa de la Torre
7d9060d09a
Merge branch 'review_internal_api' of github.com:CartoDB/geocoder-api into review_internal_api
2015-11-17 11:30:33 +01:00
Carla Iriberri
199a7ed905
Fixing adm0 plural naming and cdb typos in NOTICE messages
2015-11-17 11:30:25 +01:00
Rafa de la Torre
531e28f11b
Merge remote-tracking branch 'origin/master' into review_internal_api
2015-11-17 11:26:45 +01:00
Rafa de la Torre
a2c2903d76
Revert "Adds cartodb dependency"
2015-11-17 11:12:31 +01:00
Carla
30c02dd053
typo cbd
2015-11-17 10:20:31 +01:00
Carla
77d5c37717
typo cbd
2015-11-17 10:20:12 +01:00
Carla
5d7cfa9053
Update 10_admin0_test.sql
2015-11-17 10:19:48 +01:00
Guido Fioravantti
dbeef1bfb4
Fixes dependency misplacement
2015-11-16 18:01:52 +01:00
Carla Iriberri
91fab99084
Uses proper postalcode functions and tests
2015-11-13 13:04:46 +01:00
Carla Iriberri
50d1f502f7
Adds permissions and their tests
2015-11-13 12:32:36 +01:00
Carla Iriberri
5226af7c86
Adds client functions for named places, pcodes and ips
2015-11-12 18:45:27 +01:00
Carla Iriberri
d5268ee4ad
Adds functions for admin1
2015-11-12 15:06:17 +01:00
Rafa de la Torre
a7748f71c3
Add code to setup permissions properly
...
Based on roles and by default closing everything. No need to tweak
things outside of the extension.
2015-11-11 19:23:01 +00:00
Rafa de la Torre
b154dadc84
Add a test that makes a bit of sense
2015-11-11 18:52:48 +01:00
Rafa de la Torre
3ea449f645
Remove TODO that no longer applies
2015-11-11 18:51:20 +01:00
Mario de Frutos
22239d2da6
Added connection function to get the connection string to the server database
2015-11-11 17:50:22 +01:00
Mario de Frutos
65ffb5d645
Added schema to client functions and fixed some errors
2015-11-11 17:38:06 +01:00
Rafa de la Torre
7f26134632
My try at creating the client extension (to be tested)
2015-11-10 15:28:12 +01:00
Mario de Frutos
a77b8f3686
Created new structure
2015-11-05 17:05:07 +01:00