How can I change the default separator of group_concat() using SQLAlchemy?

Asked Oct 04 '19 at 02:49

Active Oct 04 '19 at 12:39

Viewed 214 times

I am trying to group_concat using SQLAlchemy. The problem is I want to change the separator from , to :

### code #####
.......
db.session.query(c1.ID,c1.cap ,func.group_concat(c1.Name.distinct(), ':' )).join(c2,(chart1.ID == c2.ID)).filter(c1.cap ==82).group_by(c1.ID).all()

It gives the below output:

[('ECE358', 82, 'CNT:,DB:')]

But I want the below:

[('ECE358', 82, 'CNT:DB')]

edited Oct 04 '19 at 12:39

Ilja Everilä

50,538
7
126
127

asked Oct 04 '19 at 02:49

Sam

1

You could try `group_concat(c1.Name.distinct() separator ':')`, to see if that would work. – Tim Biegeleisen Oct 04 '19 at 02:56
it shows invalid syntax. Can I import separator? if yes then how? – Sam Oct 04 '19 at 03:59
The quick'n'dirty solution using `op('SEPARATOR')` can be found at the bottom of the linked Q/A. – Ilja Everilä Oct 04 '19 at 12:41

How can I change the default separator of group_concat() using SQLAlchemy?

0 Answers0