Re: configure nginx

2020-06-22 Thread Jonathan Spicer
>From the error message it appears something is already listening on port 80. Do you apache installed? Or do you have python running as a web server? If something is already using the same port number the service can't start. Kind regards Johnny On Sun, 21 Jun 2020 at 05:21, Giovanni Silva

Re: Recreating SQL query in ORM

2019-08-01 Thread Jonathan Spicer
).values( > seq=Concat('loading_code', ...), > ids=Concat('loading_id', ), > ).annotate( > total=Count('*'), > ).order_by('-total') > > Using .values() before an annotation of an aggregate function uses the > provided columns > from grouping. > > Cheers, &

Re: Recreating SQL query in ORM

2019-07-30 Thread Jonathan Spicer
Bagiliko wrote: > > Do you want to make this exact query in Django? > Then use Your_model.objects.raw("the query here except the last semi > colon") > > On Tue, Jul 30, 2019, 4:56 PM Jonathan Spicer < > joh...@spicersolutions.co.uk > wrote: > >> Hell

Recreating SQL query in ORM

2019-07-30 Thread Jonathan Spicer
Hello, I have an sql query that I would like to recreate using the ORM. Would it be possible for someone to give me some pointers. select count(*) as total, concat(loading_code,code1_code,code2_code,code3_code,code4_code) as seq,