galaxyproject / galaxyproject/gxadmin

query training-members* broken

Open
#171 0 comments 0 reactions 0 assignees View on GitHub
feature request
Dominant language
Shell
Stars
24
Forks
30
Avg merge
3d 10h
Merged PRs (30d)
5

Description

Both `gxadmin query training-members` and `training-members-remove --yesdoit` do not work for me:
~~~
root@sn06:~$ gxadmin query training-members-remove pxe-test mira-miracoli --yesdoit
ERROR: syntax error at or near ")"
LINE 1: COPY () to STDOUT with CSV DELIMITER E'\t'
^
delete from user_group_association where id =
~~~
~~~
root@sn06:/tmp$ gxadmin query training-members pxe-test
ERROR: syntax error at or near "as"
LINE 1: ...ALESCE(galaxy_user.username::text, '__UNKNOWN__') as usernam...
~~~

while this works:
~~~
root@sn06:~$ gxadmin query training-members-remove pxe-test mira-miracoli
id | username | name
-------+---------------+-------------------
36476 | mira-miracoli | training-pxe-test

~~~
VERSION:
~~~
root@sn06:~$ gxadmin version
22
~~~

Contributor guide

Open the contributing guide

Research direction

Start with the gxadmin query training-members and training-members-remove entry points and reproduce both failures on version 22. Compare their generated SQL with the working training-members-remove output; done means both reported commands execute without syntax errors and the removal command retains its demonstrated behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
shell, sql
Domain
cli, database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.