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

Support multi-line output of queries #30

Open
jamietanna opened this issue Jun 28, 2024 · 0 comments
Open

Support multi-line output of queries #30

jamietanna opened this issue Jun 28, 2024 · 0 comments

Comments

@jamietanna
Copy link
Contributor

I.e. via this query I'm looking at using group_concat with SQLite to produce a newline-delimited output like:

select
  json_each.key as configuration_key,
  group_concat(
    platform || '/' || organisation || '/' || repo,
    char(13)
  ) as repos,
  count(*) as num_repos_with_config,
  total_repos.c as total_repos
from
  renovate_configs,
  json_each(renovate_configs.config),
  (
    select
      count(*) as c
    from
      renovate_configs
  ) as total_repos
group by
  json_each.key

Which renders like so with sqlite3:

2024-06-28-090148_873x382_scrot

However, when using sql-studio, we see:

2024-06-28-090229_1774x182_scrot

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant