head 1.14; access; symbols pkgsrc-2026Q1:1.14.0.4 pkgsrc-2026Q1-base:1.14 pkgsrc-2025Q4:1.14.0.2 pkgsrc-2025Q4-base:1.14 pkgsrc-2025Q3:1.13.0.4 pkgsrc-2025Q3-base:1.13 pkgsrc-2025Q2:1.13.0.2 pkgsrc-2025Q2-base:1.13 pkgsrc-2025Q1:1.12.0.4 pkgsrc-2025Q1-base:1.12 pkgsrc-2024Q4:1.12.0.2 pkgsrc-2024Q4-base:1.12 pkgsrc-2024Q3:1.10.0.4 pkgsrc-2024Q3-base:1.10 pkgsrc-2024Q2:1.10.0.2 pkgsrc-2024Q2-base:1.10 pkgsrc-2024Q1:1.8.0.2 pkgsrc-2024Q1-base:1.8 pkgsrc-2023Q4:1.7.0.2 pkgsrc-2023Q4-base:1.7 pkgsrc-2023Q3:1.6.0.2 pkgsrc-2023Q3-base:1.6 pkgsrc-2023Q2:1.5.0.2 pkgsrc-2023Q2-base:1.5 pkgsrc-2023Q1:1.4.0.10 pkgsrc-2023Q1-base:1.4 pkgsrc-2022Q4:1.4.0.8 pkgsrc-2022Q4-base:1.4 pkgsrc-2022Q3:1.4.0.6 pkgsrc-2022Q3-base:1.4 pkgsrc-2022Q2:1.4.0.4 pkgsrc-2022Q2-base:1.4 pkgsrc-2022Q1:1.4.0.2 pkgsrc-2022Q1-base:1.4 pkgsrc-2021Q4:1.3.0.18 pkgsrc-2021Q4-base:1.3 pkgsrc-2021Q3:1.3.0.16 pkgsrc-2021Q3-base:1.3 pkgsrc-2021Q2:1.3.0.14 pkgsrc-2021Q2-base:1.3 pkgsrc-2021Q1:1.3.0.12 pkgsrc-2021Q1-base:1.3 pkgsrc-2020Q4:1.3.0.10 pkgsrc-2020Q4-base:1.3 pkgsrc-2020Q3:1.3.0.8 pkgsrc-2020Q3-base:1.3 pkgsrc-2020Q2:1.3.0.6 pkgsrc-2020Q2-base:1.3 pkgsrc-2020Q1:1.3.0.2 pkgsrc-2020Q1-base:1.3 pkgsrc-2019Q4:1.3.0.4 pkgsrc-2019Q4-base:1.3 pkgsrc-2019Q3:1.2.0.8 pkgsrc-2019Q3-base:1.2 pkgsrc-2019Q2:1.2.0.6 pkgsrc-2019Q2-base:1.2 pkgsrc-2019Q1:1.2.0.4 pkgsrc-2019Q1-base:1.2 pkgsrc-2018Q4:1.2.0.2 pkgsrc-2018Q4-base:1.2 pkgsrc-2018Q3:1.1.0.12 pkgsrc-2018Q3-base:1.1 pkgsrc-2018Q2:1.1.0.10 pkgsrc-2018Q2-base:1.1 pkgsrc-2018Q1:1.1.0.8 pkgsrc-2018Q1-base:1.1 pkgsrc-2017Q4:1.1.0.6 pkgsrc-2017Q4-base:1.1 pkgsrc-2017Q3:1.1.0.4 pkgsrc-2017Q3-base:1.1; locks; strict; comment @# @; 1.14 date 2025.10.09.08.01.59; author wiz; state Exp; branches; next 1.13; commitid v4gBetJhBehVTRdG; 1.13 date 2025.04.15.12.53.01; author adam; state Exp; branches; next 1.12; commitid EiZPfMz3CLqqc9RF; 1.12 date 2024.11.11.07.29.20; author wiz; state Exp; branches; next 1.11; commitid 1fBDq3LwS98NncxF; 1.11 date 2024.10.14.06.46.06; author wiz; state Exp; branches; next 1.10; commitid ynDJEEQamKd33BtF; 1.10 date 2024.06.04.10.43.20; author adam; state Exp; branches; next 1.9; commitid JLp5BqUAhhWKBEcF; 1.9 date 2024.05.07.03.59.49; author adam; state Exp; branches; next 1.8; commitid 8BvZpvayZTSYg19F; 1.8 date 2024.02.08.22.52.01; author adam; state Exp; branches; next 1.7; commitid GpaktZNHvR5toGXE; 1.7 date 2023.12.07.18.10.26; author adam; state Exp; branches; next 1.6; commitid 6x5vvJ5CGR5CRyPE; 1.6 date 2023.07.13.10.03.29; author wiz; state Exp; branches; next 1.5; commitid FVBRhonHqK8MTCwE; 1.5 date 2023.04.30.18.34.07; author wiz; state Exp; branches; next 1.4; commitid IG2eLzHJl8Gt6anE; 1.4 date 2022.01.04.20.55.21; author wiz; state Exp; branches; next 1.3; commitid CYyhdK9qtoffkmnD; 1.3 date 2019.12.15.21.47.20; author adam; state Exp; branches; next 1.2; commitid O29LWoHFCSJLLQOB; 1.2 date 2018.10.03.10.47.20; author adam; state Exp; branches; next 1.1; commitid nC79w9z1jVMocvUA; 1.1 date 2017.08.21.15.49.09; author adam; state Exp; branches; next ; commitid 2JiJ6VGHnoQ9Z54A; desc @@ 1.14 log @*: remove more references to (removed) Python 3.9 @ text @# $NetBSD: Makefile,v 1.13 2025/04/15 12:53:01 adam Exp $ DISTNAME= django_sql_explorer-5.3 PKGNAME= ${PYPKGPREFIX}-${DISTNAME:S/_/-/g} CATEGORIES= www python MASTER_SITES= ${MASTER_SITE_PYPI:=d/django-sql-explorer/} MAINTAINER= pkgsrc-users@@NetBSD.org HOMEPAGE= https://github.com/epantry/django-sql-explorer COMMENT= Pluggable app that allows to execute SQL, view, and export the results LICENSE= mit TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools>=78:../../devel/py-setuptools DEPENDS+= ${PYPKGPREFIX}-cryptography>=42.0:../../security/py-cryptography DEPENDS+= ${PYPKGPREFIX}-django>=3.2:../../www/py-django DEPENDS+= ${PYPKGPREFIX}-django-cryptography-django5>=2.2:../../security/py-django-cryptography-django5 DEPENDS+= ${PYPKGPREFIX}-requests>=2.2:../../devel/py-requests DEPENDS+= ${PYPKGPREFIX}-sqlparse>=0.4.0:../../databases/py-sqlparse USE_LANGUAGES= # none .include "../../lang/python/wheel.mk" .include "../../mk/bsd.pkg.mk" @ 1.13 log @py-django-sql-explorer: updated to 5.3 5.3 Improvements to the AI SQL Assistant: Table Annotations: Write persistent table annotations with descriptive information that will get injected into the prompt for the assistant. For example, if a table is commonly joined to another table through a non-obvious foreign key, you can tell the assistant about it in plain english, as an annotation to that table. Every time that table is deemed 'relevant' to an assistant request, that annotation will be included alongside the schema and sample data. Few-Shot Examples: Using the small checkbox on the bottom-right of any saved queries, you can designate certain queries as 'few shot examples". When making an assistant request, any designated few-shot examples that reference the same tables as your assistant request will get included as 'reference sql' in the prompt for the LLM. Autocomplete / multiselect when selecting tables info to send to the SQL Assistant. Much easier and more keyboard focused. Relevant tables are added client-side visually, in real time, based on what's in the SQL editor and/or any tables mentioned in the assistant request. The dependency on sql_metadata is therefore removed, as server-side SQL parsing is no longer necessary. Ability to view Assistant request/response history. Improved system prompt that emphasizes the particular SQL dialect being used. Userspace connection migration. This should be an invisible change, but represents a significant refactor of how connections function. Instead of a weird blend of DatabaseConnection models and underlying Django models (which were the original Explorer connections), this migrates all connections to DatabaseConnection models and implements proper foreign keys to them on the Query and QueryLog models. A data migration creates new DatabaseConnection models based on the configured settings.EXPLORER_CONNECTIONS. Going forward, admins can create new Django-backed DatabaseConnection models by registering the connection in EXPLORER_CONNECTIONS, and then creating a DatabaseConnection model using the Django admin or the user-facing /connections/new/ form, and entering the Django DB alias and setting the connection type to "Django Connection". The Query.connection and QueryLog.connection fields are deprecated and will be removed in a future release. They are kept around in this release in case there is an unforeseen issue with the migration. Preserving the fields for now ensures there is no data loss in the event that a rollback to an earlier version is required. Fixed a bug when validating connections to uploaded files. Also added basic locking when downloading files from S3. On-boarding UI; if no connections or queries are created, the UI walks the user through it a bit. Keyboard shortcut for formatting the SQL in the editor. Cmd+Shift+F (Windows: Ctrl+Shift+F) The format button has been moved tobe a small icon towards the bottom-right of the SQL editor. - fail gracefully when building the schema if a particular table cant be accessed by the connection @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.12 2024/11/11 07:29:20 wiz Exp $ a21 2 PYTHON_VERSIONS_INCOMPATIBLE= 39 @ 1.12 log @py-*: remove unused tool dependency py-setuptools includes the py-wheel functionality nowadays @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.11 2024/10/14 06:46:06 wiz Exp $ d3 1 a3 1 DISTNAME= django_sql_explorer-4.3 d13 2 a14 1 TOOL_DEPENDS+= ${PYPKGPREFIX}-setuptools-[0-9]*:../../devel/py-setuptools d16 1 @ 1.11 log @*: clean-up after python38 removal @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.10 2024/06/04 10:43:20 adam Exp $ a13 1 TOOL_DEPENDS+= ${PYPKGPREFIX}-wheel-[0-9]*:../../devel/py-wheel @ 1.10 log @py-django-sql-explorer: updated to 4.3 4.3.0 Keyboard shortcut to show schema hints (cmd+S / ctrl+S -- note that is a capital "S" so the full kbd commands is cmd+shift+s) DB-managed LLM prompts (editable in django admin) Versioned .js bundles (for cache busting) Automatically populate assistant responses that contain code into the editor Update schema/assistant tables/autocomplete on connection drop-down change Import models so that migrations are properly understood by Django Get CSRF from DOM (instead of cookie) if CSRF_USE_SESSIONS is set @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.9 2024/05/07 03:59:49 adam Exp $ d21 1 a21 1 PYTHON_VERSIONS_INCOMPATIBLE= 27 38 39 @ 1.9 log @py-django-sql-explorer: updated to 4.2 4.2 Tracking should be opt-in and not use the SECRET_KEY Import error (sql_metadata) with 4.1 version Accessing the database during app initialization Regex-injection vulnerability Improved assistant UI @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.8 2024/02/08 22:52:01 adam Exp $ d3 1 a3 1 DISTNAME= django_sql_explorer-4.2 @ 1.8 log @py-django-sql-explorer: updated to 4.0.2 4.0.2 Minor bugfixes 4.0.1 Add support for Django 5.0. Drop support for Python < 3.10. Basic code completion in the editor! Front-end must be built with Vite if installing from source. * Front-end modernization. CodeMirror 6. Bootstrap5. Vite-based build * Django 5 support & tests * S3 signature version support * Record and show whether the last run of each query was successful * Replace isort and flake8 with Ruff (linting) Note: There is no 4.0.0 release as 4.0.1 was needed to resolve a conflict on PyPi @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.7 2023/12/07 18:10:26 adam Exp $ d3 2 a4 2 DISTNAME= django-sql-explorer-4.0.2 PKGNAME= ${PYPKGPREFIX}-${DISTNAME} d16 1 @ 1.7 log @py-django-sql-explorer: updated to 3.2.1 3.2.1 (2023-07-13) * Test for SET PASSWORD * Fix User primary key reference 3.2.0 (2023-05-17) * CSRF token httponly support + s3 destination for async results 3.1.1 (2023-02-27) * Added makemigrations --check pre-commit hook * Add missing migration 3.1.0 (2023-02-25) * Favorite queries * Add labels to params like $$paramName|label:defaultValue$$ * Pivot export * ci: pre-commit autoupdate * ci: ran pre-commit on all files for ci bot integration * ci: coverage update * ci: Adding django 4.2 to the test suite 3.0.1 (2022-12-16) * Fix for running without optional packages 3.0 (2022-12-15) Add support for Django >3.2 and drop support for <3.2 Add support for Python 3.9, 3.10 and 3.11 and drop support for <3.8 * Document breakage of "Format" button due to CSRF_COOKIE_HTTPONLY * Avoid execution of parameterised queries when viewing query * Change sql blacklist functionality from regex to sqlparse * Form display in popup now requires sanitize: false flag * Updated celery support * Added pre-commit hooks * Feature/more s3 providers * Check sql blacklist on execution as well as save * Conditionally import optional packages @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.6 2023/07/13 10:03:29 wiz Exp $ d3 1 a3 1 DISTNAME= django-sql-explorer-3.2.1 d15 1 a15 1 DEPENDS+= ${PYPKGPREFIX}-django>=3.2.12:../../www/py-django d20 1 a20 1 PYTHON_VERSIONS_INCOMPATIBLE= 27 @ 1.6 log @*: switch django users to py-django3 @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.5 2023/04/30 18:34:07 wiz Exp $ d3 1 a3 1 DISTNAME= django-sql-explorer-1.1.3 a4 1 PKGREVISION= 2 d13 4 a16 4 DEPENDS+= ${PYPKGPREFIX}-django>=3:../../www/py-django3 DEPENDS+= ${PYPKGPREFIX}-sqlparse>=0.1.18:../../databases/py-sqlparse DEPENDS+= ${PYPKGPREFIX}-six>=1.10.0:../../lang/py-six DEPENDS+= ${PYPKGPREFIX}-unicodecsv>=0.14.1:../../databases/py-unicodecsv d22 1 a22 5 # remove cache files from the distribution post-extract: ${FIND} ${WRKSRC} -type f -name '*.pyc' -print -delete .include "../../lang/python/egg.mk" @ 1.5 log @py-django-sql-explorer: not for python 2 @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.4 2022/01/04 20:55:21 wiz Exp $ d5 1 a5 1 PKGREVISION= 1 d14 1 a14 1 DEPENDS+= ${PYPKGPREFIX}-django>=1.7.0:../../www/py-django @ 1.4 log @*: bump PKGREVISION for egg.mk users They now have a tool dependency on py-setuptools instead of a DEPENDS @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.3 2019/12/15 21:47:20 adam Exp $ d21 2 @ 1.3 log @py-django-sql-explorer: updated to 1.1.3 1.1.3: - URL-friendly parameter encoding - Updating dependency reference for Python 3 compatibility - Include database views in list of tables - Fix unicode issue when generating migration with py2 or py3 - Do not use "message" attribute on exception - Update EXPLORER_SCHEMA_EXCLUDE_TABLE_PREFIXES - Minor Changes - release checklist included in repo - readme updated with new screenshots - python dependencies/optional-dependencies updated to latest - six, xlsxwriter, factory-boy, sqlparse @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.2 2018/10/03 10:47:20 adam Exp $ d5 1 @ 1.2 log @py-django-sql-explorer: updated to 1.1.2 1.1.2: Invalid characters present in Excel worksheet name - Major Changes - Django 2.0 compatibility - Improved interface to database connection management - Minor Changes - Documentation updates - Load images over same protocol as originating page @ text @d1 1 a1 1 # $NetBSD: Makefile,v 1.1 2017/08/21 15:49:09 adam Exp $ d3 1 a3 1 DISTNAME= django-sql-explorer-1.1.2 d18 1 a18 1 USE_LANGUAGES= # empty d22 1 a22 1 find ${WRKSRC} -type f \( -name '*.pyc' -or -name .DS_Store \) -print -delete @ 1.1 log @SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. Quickly write and share SQL queries for any Django app in a simple, usable SQL editor, preview the results in the browser, share links to download CSV files, and keep the information flowing! Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. Django SQL Explorer is inspired by any number of great query and reporting tools out there. @ text @d1 1 a1 1 # $NetBSD$ d3 1 a3 1 DISTNAME= django-sql-explorer-1.1.1 d22 1 a22 1 find ${WRKSRC} -type f -name '*.pyc' -delete @