Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLite icon is not showing up in the new outputs preview #4431

Closed
anna-geller opened this issue Jul 25, 2024 · 0 comments · Fixed by #4440
Closed

SQLite icon is not showing up in the new outputs preview #4431

anna-geller opened this issue Jul 25, 2024 · 0 comments · Fixed by #4440
Assignees
Labels
area/frontend Needs frontend code changes bug Something isn't working

Comments

@anna-geller
Copy link
Member

Describe the issue

image

reproducer:

id: business_automation
namespace: tutorial
description: Business Automation

tasks:
  - id: working_directory
    type: io.kestra.plugin.core.flow.WorkingDirectory
    tasks:
      - id: create_table
        type: io.kestra.plugin.jdbc.sqlite.Query
        url: jdbc:sqlite:kestra.db
        sql: |
          CREATE TABLE IF NOT EXISTS features (
              id INTEGER PRIMARY KEY,
              name TEXT NOT NULL,
              description TEXT NOT NULL,
              release_version TEXT NOT NULL,
              edition TEXT NOT NULL
          );

      - id: empty_table
        type: io.kestra.plugin.jdbc.sqlite.Query
        url: jdbc:sqlite:kestra.db
        sql: DELETE FROM features;

      - id: insert_data
        type: io.kestra.plugin.jdbc.sqlite.Query
        url: jdbc:sqlite:kestra.db
        sql: |
          INSERT INTO features (name, description, release_version, edition)
          VALUES 
              ('Worker Groups', 'Allows targeting specific tasks or triggers to run on specific remote workers for better scalability and resource management.', '0.10', 'Enterprise'),
              ('Realtime Triggers', 'Supports triggering of event-driven workflows in real-time.', '0.17', 'Open-Source'),
              ('Task Runners', 'Provides on-demand remote execution environments for running tasks.', '0.16', 'Open-Source'),
              ('KV Store', 'Adds key-value storage for persisting data across workflow executions.', '0.18', 'Open-Source'),
              ('SCIM Directory Sync', 'Allows synchronization of users and groups from Identity Providers.', '0.18', 'Enterprise');  

      - id: query
        type: io.kestra.plugin.jdbc.sqlite.Query
        url: jdbc:sqlite:kestra.db
        store: true
        sql: |
          SELECT * FROM features
          ORDER BY release_version;

      - id: to_csv
        type: io.kestra.plugin.serdes.csv.IonToCsv
        from: "{{ outputs.query.uri }}"

      - id: to_excel
        type: io.kestra.plugin.serdes.excel.IonToExcel
        from: "{{ outputs.query.uri }}"

Environment

  • Kestra Version:
  • Operating System (OS/Docker/Kubernetes):
  • Java Version (if you don't run kestra in Docker):
@anna-geller anna-geller added the bug Something isn't working label Jul 25, 2024
@github-project-automation github-project-automation bot moved this to Backlog in Issues Jul 25, 2024
@anna-geller anna-geller added the area/frontend Needs frontend code changes label Jul 25, 2024
@github-project-automation github-project-automation bot moved this from Backlog to Done in Issues Jul 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/frontend Needs frontend code changes bug Something isn't working
Projects
Archived in project
Development

Successfully merging a pull request may close this issue.

2 participants