* Disable fontification when exporting tables
@ 2017-09-27 8:29 Amos Bird
2017-09-28 18:51 ` Nicolas Goaziou
0 siblings, 1 reply; 9+ messages in thread
From: Amos Bird @ 2017-09-27 8:29 UTC (permalink / raw)
To: emacs-orgmode@gnu.org
[-- Attachment #1: Type: text/plain, Size: 867 bytes --]
#+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
amosbird@gmail.com
[-- Attachment #2.1: Type: text/html, Size: 1141 bytes --]
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-27 8:29 Disable fontification when exporting tables Amos Bird
@ 2017-09-28 18:51 ` Nicolas Goaziou
2017-09-29 2:08 ` Amos Bird
0 siblings, 1 reply; 9+ messages in thread
From: Nicolas Goaziou @ 2017-09-28 18:51 UTC (permalink / raw)
To: Amos Bird; +Cc: emacs-orgmode@gnu.org
Hello,
Amos Bird <amosbird@gmail.com> 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
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-28 18:51 ` Nicolas Goaziou
@ 2017-09-29 2:08 ` Amos Bird
2017-09-29 19:38 ` Nicolas Goaziou
0 siblings, 1 reply; 9+ messages in thread
From: Amos Bird @ 2017-09-29 2:08 UTC (permalink / raw)
To: Nicolas Goaziou; +Cc: emacs-orgmode@gnu.org
[-- Attachment #1: Type: text/plain, Size: 1106 bytes --]
#+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 <mail@nicolasgoaziou.fr> writes:
> Hello,
>
> Amos Bird <amosbird@gmail.com> 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
amosbird@gmail.com
[-- Attachment #2.1: Type: text/html, Size: 1531 bytes --]
[-- Attachment #2.2: img-2017-09-29-100634.png --]
[-- Type: image/png, Size: 42349 bytes --]
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-29 2:08 ` Amos Bird
@ 2017-09-29 19:38 ` Nicolas Goaziou
2017-09-30 1:13 ` Amos Bird
0 siblings, 1 reply; 9+ messages in thread
From: Nicolas Goaziou @ 2017-09-29 19:38 UTC (permalink / raw)
To: Amos Bird; +Cc: emacs-orgmode@gnu.org
Hello,
Amos Bird <amosbird@gmail.com> 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
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-29 19:38 ` Nicolas Goaziou
@ 2017-09-30 1:13 ` Amos Bird
2017-09-30 7:36 ` Nicolas Goaziou
0 siblings, 1 reply; 9+ messages in thread
From: Amos Bird @ 2017-09-30 1:13 UTC (permalink / raw)
To: Nicolas Goaziou; +Cc: emacs-orgmode@gnu.org
[-- Attachment #1: Type: text/plain, Size: 2781 bytes --]
#+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 <mail@nicolasgoaziou.fr> writes:
> Hello,
>
> Amos Bird <amosbird@gmail.com> 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
amosbird@gmail.com
[-- Attachment #2.1: Type: text/html, Size: 3161 bytes --]
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-30 1:13 ` Amos Bird
@ 2017-09-30 7:36 ` Nicolas Goaziou
2017-09-30 7:43 ` Amos Bird
0 siblings, 1 reply; 9+ messages in thread
From: Nicolas Goaziou @ 2017-09-30 7:36 UTC (permalink / raw)
To: Amos Bird; +Cc: emacs-orgmode@gnu.org
Hello,
Amos Bird <amosbird@gmail.com> 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
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-30 7:36 ` Nicolas Goaziou
@ 2017-09-30 7:43 ` Amos Bird
2017-09-30 7:49 ` Nicolas Goaziou
0 siblings, 1 reply; 9+ messages in thread
From: Amos Bird @ 2017-09-30 7:43 UTC (permalink / raw)
To: Nicolas Goaziou; +Cc: emacs-orgmode@gnu.org
[-- Attachment #1: Type: text/plain, Size: 5358 bytes --]
#+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 <mail@nicolasgoaziou.fr> writes:
> Hello,
>
> Amos Bird <amosbird@gmail.com> 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,
--
Amos Bird
amosbird@gmail.com
[-- Attachment #2.1: Type: text/html, Size: 6393 bytes --]
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-30 7:43 ` Amos Bird
@ 2017-09-30 7:49 ` Nicolas Goaziou
2017-09-30 7:56 ` Amos Bird
0 siblings, 1 reply; 9+ messages in thread
From: Nicolas Goaziou @ 2017-09-30 7:49 UTC (permalink / raw)
To: Amos Bird; +Cc: emacs-orgmode@gnu.org
Amos Bird <amosbird@gmail.com> 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,
^ permalink raw reply [flat|nested] 9+ messages in thread
* Re: Disable fontification when exporting tables
2017-09-30 7:49 ` Nicolas Goaziou
@ 2017-09-30 7:56 ` Amos Bird
0 siblings, 0 replies; 9+ messages in thread
From: Amos Bird @ 2017-09-30 7:56 UTC (permalink / raw)
To: Nicolas Goaziou; +Cc: emacs-orgmode@gnu.org
[-- Attachment #1: Type: text/plain, Size: 2509 bytes --]
#+OPTIONS: latex:t toc:nil H:3
Thanks!
Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:
> Amos Bird <amosbird@gmail.com> 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
amosbird@gmail.com
[-- Attachment #2.1: Type: text/html, Size: 2954 bytes --]
^ permalink raw reply [flat|nested] 9+ messages in thread
end of thread, other threads:[~2017-09-30 7:56 UTC | newest]
Thread overview: 9+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2017-09-27 8:29 Disable fontification when exporting tables Amos Bird
2017-09-28 18:51 ` Nicolas Goaziou
2017-09-29 2:08 ` Amos Bird
2017-09-29 19:38 ` Nicolas Goaziou
2017-09-30 1:13 ` Amos Bird
2017-09-30 7:36 ` Nicolas Goaziou
2017-09-30 7:43 ` Amos Bird
2017-09-30 7:49 ` Nicolas Goaziou
2017-09-30 7:56 ` Amos Bird
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).