f207818afa
Implemented a server-side cursor to enhance performance when retrieving large datasets. #5797
2025-07-02 12:47:01 +05:30
31b1af2f84
Fixed an issue where filtering on a view caused an error. #8630
2025-04-09 19:00:32 +05:30
133a59c71b
Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost. #6044
2025-01-22 10:06:56 +05:30
964d211260
Copyright updated for 2025
2025-01-01 11:26:42 +05:30
0e0cbc40b8
Fixed SonarQube code smell Replace the unused local variable with '_'.
2024-01-24 18:33:43 +05:30
740ce15bd7
Update copyright notices for 2024
2024-01-01 14:13:48 +05:30
9aa116bf3f
1) Added new/missing parameters to pg_dumpall (Backup Server). #6416
...
2) Added new/missing parameters to pg_dump (Backup Objects). #6417
2023-07-10 10:34:30 +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
4746fbd346
Fixed an issue where View/Edit data is throwing an error if the user deleted and re-create the same table for which View/Edit data was opened. #6431
2023-06-19 19:37:10 +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
0b6b2e733a
1) Remove Python's 'Six' package completely. #5357
...
2) Replace deprecated @abstractproperty with @property, @abstractmethod.
2022-09-26 12:47:31 +05:30
2786f7ac5a
Update copyright notices for 2022
2022-01-04 13:54:25 +05:30
d644b4f94e
1) Replace Flask-BabelEx with Flask-Babel. Fixes #6088
...
2) Upgrade Flask to version 2. Fixes #7010
2021-11-24 17:22:57 +05:30
b372f08a59
Update copyright notices for 2021
2021-01-04 15:34:45 +05:30
1c70a43b91
Fixed code smells 'Define a constant instead of duplicating this literal' reported by SonarQube.
2020-09-29 15:08:14 +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
3984544bdb
Fixed code smell 'String literals should not be duplicated'.
2020-08-28 18:17:27 +05:30
d6400bbcae
Replace the generic exception class with a more specific one.
2020-08-07 12:37:00 +05:30
aa679e06b2
Replace the generic exception class with a more specific one to fix SonarQube issues.
2020-08-05 12:41:28 +05:30
56cf64ad22
Fixed following SonarQube issues:
...
- Refactor functions to not always return the same value.
- Rename "cls" to "self" or add the missing "self" parameter.
- Remove useless assignment to variables.
2020-07-30 14:04:22 +05:30
357a9179b1
Fixed convention related issues reported by SonarQube.
2020-07-09 18:55:33 +05:30
641f7bbe9d
Some clumsy coding related fixes reported by SonarQube.
2020-06-15 16:50:07 +05:30
726ecd79e6
Fixed import statements.
...
refs #3669
2020-06-03 12:49:05 +05:30
d22e276586
Ensure that proper error should be displayed for the deleted node. Fixes #3669
2020-06-03 11:26:26 +05:30
d68e6bd892
Remove Python2 modules.
...
refs #5443
2020-05-08 12:28:21 +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
01c7636c75
Update copyright notices for 2020.
2020-01-02 14:43:50 +00:00
f8f7d5ac6f
Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header. Fixes #4667
2019-08-26 14:17:40 +05:30
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
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
da8cf14047
Prevent an error that may occur when editing data with an integer primary key. Fixes #4404
2019-06-27 10:43:25 -04:00
6e8ebbd375
Allow editing of data where a primary key column includes a % sign in the value. Fixes #4036
...
Fix an XSS issue seen in View/Edit data mode if a column name includes HTML. Fixes #4367
2019-06-20 12:21:37 +01:00
6d52f2b911
Initial support for PostgreSQL 12. Fixes #4283 . Fixes #4288 . Fixes #4290 .
2019-06-10 14:24:45 +01:00
944cc55df7
Prevent an error when closing the Sort/Filter dialogue with an empty filter string. Fixes #3970
2019-02-13 16:44:57 +00:00
e23d307c56
Update copyright notices for 2019
2019-01-02 15:54:12 +05:30
0ec3224212
Fix logic around validation and highlighting of Sort/Filter in the Query Tool. Fixes #3607
2018-09-14 14:18:43 +01:00
25679fd542
Ensure sort/filter dialog should display proper message after losing database connection. Fixes #3561
2018-08-22 16:38:31 +05:30
57660d131f
1) Fix sort/filter dialog editing issue. Fixes #3558 .
...
2) Fix sort/filter dialog issue where it incorrectly requires ASC/DESC. Fixes #3325 .
2018-08-21 13:05:40 +05:30
fa1854bd85
Allow sorting when viewing/editing data. Fixes #1894
2018-04-05 16:25:17 +01:00
be055ce57d
Update Python and JS modules. Fixes #3154
2018-04-04 10:47:01 +01:00
96165044ae
Ensure we can properly update rows with upper-case primary key columns. Fixes #3105
2018-02-19 11:37:31 +00:00
e0da9c5a0c
Significantly improve connection loss detection and handling in the query tool. Fixes #2815
2018-02-01 14:29:18 +01:00
393ce53d2d
Fix PEP8 issues in the Tools module. Fixes #3063
2018-01-26 16:54:21 +00:00
89821c0d19
Update copyright notices for 2018.
2018-01-05 10:42:50 +00:00
0c5a5ba9c2
Add support for editing data in tables with OIDs but no primary keys. Fixes #2849 .
...
This patch also updates the editor to retrieve all row values on save, thus immediately showing default values and allowing subsequent editing without a refresh.
2017-12-13 10:28:31 +00:00
23d431fb54
Remove more exclamation marks from error messages.
2017-11-01 15:18:07 +00:00
bdc08d94c4
Fix View Data option and column config for Foreign Tables. Fixes #2691
2017-09-18 14:32:17 +01:00
30e7016077
Changed array representation and formatting for the data types in Query Tool and View Data. Fixes #2671
2017-09-18 12:07:15 +05:30
Khushboo Vashi
Akshay Joshi
Anil Sahoo
Nikhil Mohite
Mark Mayo
Cyril Jouve
Yogesh Mahajan
Aditya Toshniwal
Satish V
navnath gadakh
Dave Page
Yosry Muhammad
Murtuza Zabuawala
Harshal Dhumal
Alexander Lakhin