Re: [O] Disable fontification when exporting tables

[Amos Bird]

#+OPTIONS: latex:t toc:nil H:3

Thanks!

Nicolas Goaziou  writes:

> Amos Bird  writes:
>
>> | QueryID | SQL Text 
>>  
>>   | Query Time (Seconds) | Query Time Hot (Seconds) |
>> |-+-+--+--|
>> | Q0  | SELECT avg(c1) from (select Year, Month, count(*) as c1 from 
>> ontime group by Year, Month);
>>   | 1.27 | 0.13 |
>> | Q1  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 
>> AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; 
>> | 1.23 | 0.21 |
>> | Q2  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE DepDelay>10 
>> AND Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;
>>  |  1.4 | 0.25 |
>> | Q3  | SELECT Origin, count(*) AS c FROM ontime WHERE DepDelay>10 AND 
>> Year >= 2000 AND Year <= 2008 GROUP BY Origin ORDER BY c DESC LIMIT 10;  
>> |  5.2 | 0.29 |
>> | Q4  | SELECT Carrier, count(*) FROM ontime WHERE DepDelay>10  AND Year 
>> = 2007 GROUP BY Carrier ORDER BY count(*) DESC;  
>>   |  1.0 | 0.09 |
>> | Q5  | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime 
>> WHERE Year = 2007 GROUP BY Carrier ORDER BY Carrier; 
>>| 0.12 | 0.04 |
>> | Q6  | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime 
>> WHERE Year >= 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;   
>>| 0.42 | 0.26 |
>>
>> that is, it contains = characters which breaks the verbatim markup.
>
> Then use `code' markup:
>
>   ~SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE Year >= 
> 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;~
>
> which is more appropriate than `verbatim' for SQL code anyway.
>
>> Is there a way to specify the whole column to be verbatim?
>
> No, there isn't.
>
> Regards,


--
Amos Bird
amosb...@gmail.com

Re: [O] Disable fontification when exporting tables

[Nicolas Goaziou]

Amos Bird  writes:

> | QueryID | SQL Text  
>   
> | Query Time (Seconds) | Query Time Hot (Seconds) |
> |-+-+--+--|
> | Q0  | SELECT avg(c1) from (select Year, Month, count(*) as c1 from 
> ontime group by Year, Month); 
>  | 1.27 | 0.13 |
> | Q1  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 
> AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;  
>| 1.23 | 0.21 |
> | Q2  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE DepDelay>10 AND 
> Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; 
> |  1.4 | 0.25 |
> | Q3  | SELECT Origin, count(*) AS c FROM ontime WHERE DepDelay>10 AND 
> Year >= 2000 AND Year <= 2008 GROUP BY Origin ORDER BY c DESC LIMIT 10;   
>|  5.2 | 0.29 |
> | Q4  | SELECT Carrier, count(*) FROM ontime WHERE DepDelay>10  AND Year 
> = 2007 GROUP BY Carrier ORDER BY count(*) DESC;   
>  |  1.0 | 0.09 |
> | Q5  | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE 
> Year = 2007 GROUP BY Carrier ORDER BY Carrier;
> | 0.12 | 0.04 |
> | Q6  | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE 
> Year >= 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;  
> | 0.42 | 0.26 |
>
> that is, it contains = characters which breaks the verbatim markup.

Then use `code' markup:

  ~SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE Year >= 
2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;~

which is more appropriate than `verbatim' for SQL code anyway.

> Is there a way to specify the whole column to be verbatim?

No, there isn't.

Regards,

Re: [O] Disable fontification when exporting tables

[Amos Bird]

#+OPTIONS: latex:t toc:nil H:3

Hi,

> However, you could add verbatim markup
>
> =SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;=
>
> but, again, since I don't know exactly what the issue is, I may be wide
> of the mark.

Well, this solves my issue :).

But I also have a table like this :
#+BEGIN_EXAMPLE
   | QueryID | SQL Text 

   | Query Time (Seconds) | Query Time Hot (Seconds) |
   
|-+-+--+--|
   | Q0  | SELECT avg(c1) from (select Year, Month, count(*) as c1 from 
ontime group by Year, Month);   
   | 1.27 | 0.13 |
   | Q1  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 
AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;
 | 1.23 | 0.21 |
   | Q2  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE DepDelay>10 
AND Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;   
  |  1.4 | 0.25 |
   | Q3  | SELECT Origin, count(*) AS c FROM ontime WHERE DepDelay>10 AND 
Year >= 2000 AND Year <= 2008 GROUP BY Origin ORDER BY c DESC LIMIT 10; 
 |  5.2 | 0.29 |
   | Q4  | SELECT Carrier, count(*) FROM ontime WHERE DepDelay>10  AND Year 
= 2007 GROUP BY Carrier ORDER BY count(*) DESC; 
   |  1.0 | 0.09 |
   | Q5  | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime 
WHERE Year = 2007 GROUP BY Carrier ORDER BY Carrier;
| 0.12 | 0.04 |
   | Q6  | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime 
WHERE Year >= 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;  
| 0.42 | 0.26 |
#+END_EXAMPLE

that is, it contains = characters which breaks the verbatim markup.

Is there a way to specify the whole column to be verbatim?

regards,

Nicolas Goaziou  writes:

> Hello,
>
> Amos Bird  writes:
>
>>> - what are you trying to export?
>>
>> an Org table like this:
>>
>>
>> | QueryID | SQL Text 
>>  
>> | Query Time (Seconds) | Query 
>> Time Hot (Seconds) |
>> |-+---+--+--|
>> | Q0  | SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;  
>>  
>> |10.14 | 
>>11.57 |
>> | Q1  | SELECT passenger_count, avg(total_amount) FROM trips_log GROUP 
>> BY passenger_count;  
>>   |12.00 |   
>>   6.27 |
>> | Q2  | SELECT passenger_count, toYear(pickup_datetime) AS year, 
>> count(*) FROM trips_log GROUP BY passenger_count, year;  
>> |10.45 | 
>> 7.23 |
>> | Q3  | SELECT passenger_count, toYear(pickup_datetime) AS year, 
>> round(trip_distance) AS distance, count(*) FROM trips_log GROUP BY 
>> passenger_count, year, distance ORDER BY year, count(*) DESC; |  
>>   13.03 |10.80 |
>
> OK.
>
>>> - to what back-end?
>>
>> ODT and HTML
>
> OK.
>
>>> - what is the exact problem?
>>
>> I'd like to export this table with *:nil ^:nil options while exporting other 
>> subtrees with *:t ^:t.
>
> This is not my question. You are explaining me how you are trying to
> proceed. I want to know what it the problem you are trying to solve.
>
> Anyway, it seems you are conflating fontification in the Org buffer and
> export. I guess there is no issue related to export in this thread.
>
>> I tried surrounding the table with example block and src block but
>> both look bad after exportation.
>
> Of course. I didn't know you were exporting an Org table.
>
> However, you could add verbatim markup
>
>   =SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;=
>
> but, again, since I don't know 

Re: [O] Disable fontification when exporting tables

[Nicolas Goaziou]

Hello,

Amos Bird  writes:

>> - what are you trying to export?
>
> an Org table like this:
>
>
> | QueryID | SQL Text  
>   
>   | Query Time (Seconds) | Query Time 
> Hot (Seconds) |
> |-+---+--+--|
> | Q0  | SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;   
>   
>   |10.14 |
> 11.57 |
> | Q1  | SELECT passenger_count, avg(total_amount) FROM trips_log GROUP BY 
> passenger_count;  
>   |12.00 |
>  6.27 |
> | Q2  | SELECT passenger_count, toYear(pickup_datetime) AS year, count(*) 
> FROM trips_log GROUP BY passenger_count, year;
>   |10.45 |
>  7.23 |
> | Q3  | SELECT passenger_count, toYear(pickup_datetime) AS year, 
> round(trip_distance) AS distance, count(*) FROM trips_log GROUP BY 
> passenger_count, year, distance ORDER BY year, count(*) DESC; |   
>  13.03 |10.80 |

OK.

>> - to what back-end?
>
> ODT and HTML

OK.

>> - what is the exact problem?
>
> I'd like to export this table with *:nil ^:nil options while exporting other 
> subtrees with *:t ^:t.

This is not my question. You are explaining me how you are trying to
proceed. I want to know what it the problem you are trying to solve.

Anyway, it seems you are conflating fontification in the Org buffer and
export. I guess there is no issue related to export in this thread.

> I tried surrounding the table with example block and src block but
> both look bad after exportation.

Of course. I didn't know you were exporting an Org table.

However, you could add verbatim markup

  =SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type;=

but, again, since I don't know exactly what the issue is, I may be wide
of the mark.

> characters when exporting.

I never suggested that.

> I also tried changing _ to \under{} and * to \asc{} but it doesn't look well 
> in the Org buffer.
>
> I did turn on org-toggle-pretty-entities but it changes the appearance
> of other subtrees which I don't want to.

Maybe Org mode is not the appropriate mode for the task?

Regards,

-- 
Nicolas Goaziou

Re: [O] Disable fontification when exporting tables

[Amos Bird]

#+OPTIONS: latex:t toc:nil H:3

Hi,

> - what are you trying to export?

an Org table like this:

#+BEGIN_EXAMPLE
| QueryID | SQL Text

  | Query Time (Seconds) | Query Time Hot 
(Seconds) |
|-+---+--+--|
| Q0  | SELECT cab_type, count(*) FROM trips_log GROUP BY cab_type; 

  |10.14 |  
  11.57 |
| Q1  | SELECT passenger_count, avg(total_amount) FROM trips_log GROUP BY 
passenger_count;
|12.00 |
 6.27 |
| Q2  | SELECT passenger_count, toYear(pickup_datetime) AS year, count(*) 
FROM trips_log GROUP BY passenger_count, year;  
|10.45 |
 7.23 |
| Q3  | SELECT passenger_count, toYear(pickup_datetime) AS year, 
round(trip_distance) AS distance, count(*) FROM trips_log GROUP BY 
passenger_count, year, distance ORDER BY year, count(*) DESC; |
13.03 |10.80 |
#+END_EXAMPLE

> - to what back-end?

ODT and HTML

> - what is the exact problem?

I'd like to export this table with *:nil ^:nil options while exporting other 
subtrees with *:t ^:t.

I tried surrounding the table with example block and src block but both look 
bad after exportation.

I added <10> to the SQL column but it doesn't help quoting the * and _ 
characters when exporting.

#+BEGIN_EXAMPLE
I also tried changing _ to \under{} and * to \asc{} but it doesn't look well in 
the Org buffer.

I did turn on org-toggle-pretty-entities but it changes the appearance of other 
subtrees which I don't want to.
#+END_EXAMPLE

regards,


Nicolas Goaziou  writes:

> Hello,
>
> Amos Bird  writes:
>
>> I've tried the example block but it doesn't export well.
>>
>> img-2017-09-29-100634.png
>
> You didn't specify you were trying to export an Org table in the first
> place. You need to give as much information as possible if you want to
> have useful answers.
>
> So, let's start again:
>
> - what are you trying to export?
> - to what back-end?
> - what is the exact problem?
>
> Regards,


--
Amos Bird
amosb...@gmail.com

Re: [O] Disable fontification when exporting tables

[Nicolas Goaziou]

Hello,

Amos Bird  writes:

> I've tried the example block but it doesn't export well.
>
> img-2017-09-29-100634.png

You didn't specify you were trying to export an Org table in the first
place. You need to give as much information as possible if you want to
have useful answers.

So, let's start again:

- what are you trying to export?
- to what back-end?
- what is the exact problem?

Regards,

-- 
Nicolas Goaziou

Re: [O] Disable fontification when exporting tables

[Amos Bird]

#+OPTIONS: latex:t toc:nil H:3

Hi Nicolas,

I've tried the example block but it doesn't export well.

[[file:/home/amos/Pictures/Screenshots/img-2017-09-29-100634.png]]


> - include this in a fixed-width area,

Um, do you mean putting a <10> at the top of the second column? I tried that 
but it still doesn't
export cleanly.

> - use \star instead of *

Yeah, this is a valid option but it's a bit unconvenient

regards,

Nicolas Goaziou  writes:

> Hello,
>
> Amos Bird  writes:
>
>> How can I disable fontifications when exporting this:
>>
>>   QueryID  SQL Text  Query Time (Seconds)  Query Time Hot (Seconds)
>>   Q0  SELECT avg(c1) from (select Year, Month, count(*) as c1 from ontime 
>> group by Year, Month);  1.27  0.13
>>   Q1  SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 AND 
>> Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;  1.23  0.21
>
> There are multiple solutions:
> - include this in an example block,
> - include this in a fixed-width area,
> - use \star instead of *
> - ...
>
> Regards,


--
Amos Bird
amosb...@gmail.com

Re: [O] Disable fontification when exporting tables

[Nicolas Goaziou]

Hello,

Amos Bird  writes:

> How can I disable fontifications when exporting this:
>
>   QueryID  SQL Text  Query Time (Seconds)  Query Time Hot (Seconds)
>   Q0  SELECT avg(c1) from (select Year, Month, count(*) as c1 from ontime 
> group by Year, Month);  1.27  0.13
>   Q1  SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 AND Year 
> <= 2008 GROUP BY DayOfWeek ORDER BY c DESC;  1.23  0.21

There are multiple solutions:
- include this in an example block,
- include this in a fixed-width area,
- use \star instead of *
- ...

Regards,

-- 
Nicolas Goaziou

[O] Disable fontification when exporting tables

[Amos Bird]

#+OPTIONS: latex:t toc:nil H:3

Hi,

How can I disable fontifications when exporting this:

   | QueryID | SQL Text 
   | Query Time (Seconds) | 
Query Time Hot (Seconds) |
   
|-+-+--+--|
   | Q0  | SELECT avg(c1) from (select Year, Month, count(*) as c1 from 
ontime group by Year, Month);  | 1.27 | 
0.13 |
   | Q1  | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 
AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; | 1.23 |   
  0.21 |

regards,

--
Amos Bird
amosb...@gmail.com