1d68074a59
Fixed macros test cases when run on more than one server.
2025-07-09 16:01:51 +05:30
f207818afa
Implemented a server-side cursor to enhance performance when retrieving large datasets. #5797
2025-07-02 12:47:01 +05:30
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
22cdb86aab
Fix issue with missing new added records in download file. #5345
2024-07-02 11:48:13 +05:30
4e3ec91d23
Added support for the 'Add to macros' feature and fixed various usability issues. #4735
2024-05-24 15:30:31 +05:30
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
9eb7c1cbea
1) Ensure that eventlet's subprocess is used for Python versions up to 3.11 and await the issue resolution for Python versions 3.12.
...
2) Fixed unescape sequence for Python 3.12
2023-11-02 16:03:50 +05:30
0b707be615
Fixed restoration of query tool database connection after dropping and re-creating the database with the same name. #6487
2023-11-01 15:27:18 +05:30
b55164c454
Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live. #6420
2023-08-07 17:19:08 +05:30
1a7a23de3f
Added WAL option to EXPLAIN ANALYZE command. #6382
2023-08-03 15:57:12 +05:30
326dc2bbcc
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317 ( #6491 )
...
Fix an issue where queries longer than 1 minute get stuck - Container 7.1. #6317
Fix an issue where queries get stuck with auto-completion enabled. #6356
Fix an issue where queries can't complete execution. #6163
2023-07-04 10:44:46 +05:30
366dd3a973
Remove psycopg2 completely.
2023-03-20 16:57:30 +05:30
5e0daccf76
Added support for psycopg3 along with psycopg2. #5011
2023-02-15 11:31:29 +05:30
98184e5835
Update copyright notices for 2023
2023-01-02 11:53:55 +05:30
41508f7f67
python 3 updates
...
- Fix super() calls for python 3
- No need to inherit objects.
- No need for u at the start of strings
- Tidied up some brackets and f-strings too
2022-11-19 10:13:41 +05:30
d13ee8db29
1) Remove folders that are no longer used for older database versions.
...
2) Fixed RESQL tests for View/MView.
2022-09-29 16:45:51 +05:30
084203debc
Fixed Securtiy Hotspot reported by SonarQube.
2022-08-12 17:10:26 +05:30
b5b9ee46a1
1) Port query tool to React. Fixes #6131
...
2) Added status bar to the Query Tool. Fixes #3253
3) Ensure that row numbers should be visible in view when scrolling horizontally. Fixes #3989
4) Allow removing a single query history. Refs #4113
5) Partially fixed Macros usability issues. Ref #6969
6) Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly. Fixes #6725
7) Relocate GIS Viewer Button to the Left Side of the Results Table. Fixes #6830
8) Fixed an issue where the connection bar is not visible. Fixes #7188
9) Fixed an issue where an Empty message popup after running a query. Fixes #7260
10) Ensure that Autocomplete should work after changing the connection. Fixes #7262
11) Fixed an issue where the copy and paste row does not work if the first column contains no data. Fixes #7294
2022-04-07 17:36:56 +05:30
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
eeff75ba20
Remove GPDB support completely. Fixes #6692
2021-09-09 13:09:53 +05:30
9d8360641f
Use schema qualification while accessing the catalog objects.
...
refs #3976
2021-03-12 11:17:25 +05:30
87b9549ff4
Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character. Fixes #6018
2021-02-26 13:23:07 +05:30
b372f08a59
Update copyright notices for 2021
2021-01-04 15:34:45 +05:30
98b7603ebd
Close query tool connection for API test cases.
2020-12-25 18:32:01 +05:30
6475a70514
Ensure that the macro query result should be download properly. Fixes #5965
2020-12-14 11:58:53 +05:30
c28509ac28
Fixed an issue where the user is unable to change the macro name. Fixes #5885
2020-10-05 14:40:21 +05:30
be7bb81a19
Allow user to change the database connection from an open query tool tab. Fixes #3794
2020-10-01 13:29:46 +05:30
4616a74029
Added Macro support. Fixes #1402
2020-09-28 15:26:45 +05:30
5a253f9053
Change the following to replace Python 2 code with Python 3:
...
1) Replace the deprecated unit test method.
2) Wraps filter usage in a list call.
3) Converts the old metaclass syntax to new.
4) Use range instead of xrange method.
5) Change Unicode to str.
6) Several other transformations.
7) Fixed change password test cases.
8) Use simplejson instead of plain JSON.
2020-08-31 16:45:31 +05:30
e3dfe03a2a
Fixed an issue where the user is not able to insert the data if the table and columns name contains special characters. Fixes #4387
2020-08-06 12:30:10 +05:30
b1cbcc7ef6
Fixed data truncation issue when updating the data of type character with length. Fixes #5481
2020-05-25 17:05:47 +05:30
d68e6bd892
Remove Python2 modules.
...
refs #5443
2020-05-08 12:28:21 +05:30
86afec860f
Remove Python 2 support from the Python tests.
...
refs #5443
2020-04-30 12:56:45 +05:30
c76732e3e7
Ensure that default sort order should be using the primary key in View/Edit data. Fixes #5157
2020-04-22 18:47:13 +05:30
8bdfa18efb
Ensure that if the delimiter is set other than comma then download the file as '.txt' file. Fixes #4573
2020-04-17 17:37:02 +05:30
01c7636c75
Update copyright notices for 2020.
2020-01-02 14:43:50 +00:00
234efc3be7
Don't wait for the database connection before rendering the Query Tool UI, for improved UX. Fixes #4453
...
In addition, unescape HTML entities in database names in the Query Tool title bar. Fixes #4584
2019-08-23 12:14:20 +01:00
ed76787b76
Fix the Transaction Status failed test cases.
2019-08-20 10:22:11 +05:30
624f229ce7
Comment out the failed Transaction Status API test cases for successful Jenkins build
2019-08-20 09:33:42 +05:30
663e8382f3
1) Added new python test that checks the transaction status after executing queries and saving data when auto-commit is on/off.
...
2) Some refactoring of previously written python tests.
2019-08-19 11:45:36 +05:30
76e658ee12
Ensure command tags are shown in the messages tab of the Query Tool. Fixes #4520
2019-08-01 14:29:38 +01:00
7b65507533
Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updateable resultsets. Fixes #4520
2019-08-01 13:59:53 +01:00
82d209946f
Added support for editing of result sets from tables with OIDs in query tool.
2019-07-29 12:26:53 +05:30
c019778a47
1) Fix an error while retrieving json data from the table. Fixes #4427
...
2) Fix an issue where Explain and Explain Analyze are not working, it's regression of #1760 . Fixes #4484
3) Fix an issue where Filter toolbar button is not working in view/edit data, it's regression of keyboard navigation. Fixes #4485
2019-07-22 18:42:48 +05:30
f5b927b925
Randomise table names for tests.
2019-07-17 16:50:59 +01:00
710d520631
Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable. Fixes #1760
...
When a query is run in the Query Tool, check if the source of the columns
can be identified as being from a single table, and that we have all
columns that make up the primary key. If so, consider the resultset to
be editable and allow the user to edit data and add/remove rows in the
grid. Changes to data are saved using SAVEPOINTs as part of any
transaction that's in progress, and rolled back if there are integrity
violations, without otherwise affecting the ongoing transaction.
Implemented by Yosry Muhammad as a Google Summer of Code project.
2019-07-17 11:45:20 +01:00
bd0e4a5a8f
Remove some files committed in error.
2019-07-08 12:07:50 +01:00
11a3aa56be
Use different folders for pg vs. ppas RE-SQL tests. Fall back to the tests folder without a subdirectory if neither exist.
2019-07-05 14:40:51 +01:00
0340b8fb28
Add EXPLAIN options for SETTINGS and SUMMARY. Fixes #4335
...
Prevent flickering of large tooltips on the Graphical EXPLAIN canvas. Fixes #4224
EXPLAIN options should be Query Tool instance-specific. Fixes #4395
2019-07-03 13:57:56 +01:00
78d55c7cc0
Fix regression tests.
2019-06-20 13:26:06 +01:00
Akshay Joshi
Khushboo Vashi
Rohit Bhati
Anil Sahoo
Mark Mayo
Aditya Toshniwal
Rahul Shirsat
Nikhil Mohite
Cyril Jouve
Yogesh Mahajan
Dave Page
navnath gadakh
Nagesh Dhope
Yosry Muhammad