#29 Missing sqlite pragmas full_column_names and short_column_names.

[Blady]

Hello,
By default, SQLite column names are short that is:
sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs, proprietaires;
nom|nom
P1|A1
P21|A1
P3|A1

There is 2 pragmas but they are written deprecated (I don't find why).
http://www.sqlite.org/pragma.html#pragma_full_column_names
http://www.sqlite.org/pragma.html#pragma_short_column_names

They do almost the job:
sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs, proprietaires;
proprietaires.nom|auteurs.nom
P1|A1
P21|A1
P3|A1

I propose to add their support in Gnoga.
Thanks, Pascal.

[David Botton]

I would add a procedure to apply the pragmas in
gnoga-server-database-sqlite.ads but not do so by default.

David Botton

[Blady]

Hello David, I agree.
Proposal:
procedure Full_Column_Names (C : Connection; Active : Boolean := True);
function Full_Column_Names (C : Connection) return Boolean;
procedure Short_Column_Names (C : Connection; Active : Boolean := True);
function Short_Column_Names (C : Connection) return Boolean;
Is it correct ? Pascal.

[David Botton]

Hmm, would it be possible to just make one property since they are the
reverse of each other?

On Sun, Nov 29, 2015 at 11:43 AM Blady blady-com@users.sf.net wrote:

Hello David, I agree.
Proposal:
procedure Full_Column_Names (C : Connection; Active : Boolean := True);
function Full_Column_Names (C : Connection) return Boolean;
procedure Short_Column_Names (C : Connection; Active : Boolean := True);
function Short_Column_Names (C : Connection) return Boolean;
Is it correct ? Pascal.

---

• [tickets:#29] http://sourceforge.net/p/gnoga/tickets/29/ Missing
  sqlite pragmas full_column_names and short_column_names.*

Status: open
Milestone: 1.2
Created: Sat Nov 28, 2015 08:48 AM UTC by Blady
Last Updated: Sat Nov 28, 2015 08:48 AM UTC
Owner: Blady

Hello,
By default, SQLite column names are short that is:
sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs,
proprietaires;
nom|nom
P1|A1
P21|A1
P3|A1

There is 2 pragmas but they are written deprecated (I don't find why).
http://www.sqlite.org/pragma.html#pragma_full_column_names
http://www.sqlite.org/pragma.html#pragma_short_column_names

They do almost the job:
sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs,
proprietaires;
proprietaires.nom|auteurs.nom
P1|A1
P21|A1
P3|A1

I propose to add their support in Gnoga.
Thanks, Pascal.

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/gnoga/tickets/29/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Blady]

Hello David, stay well on your chair, they are not reverse from each other, it would be so simple.
I tested the all 4 possbilities combinated with requested from one or several tables -> all have a different behaviour. See http://www.sqlite.org/pragma.html#pragma_full_column_names.
I propose to add this comment in Gnoga code ;-)
Regards, Pascal.

[David Botton]

Wow, ok, so go ahead and add. Thanks for the great work!

On Sun, Nov 29, 2015 at 12:40 PM Blady blady-com@users.sf.net wrote:

Hello David, stay well on your chair, they are not reverse from each
other, it would be so simple.
I tested the all 4 possbilities combinated with requested from one or
several tables -> all have a different behaviour. See
http://www.sqlite.org/pragma.html#pragma_full_column_names.
I propose to add this comment in Gnoga code ;-)
Regards, Pascal.

---

• [tickets:#29] http://sourceforge.net/p/gnoga/tickets/29/ Missing
  sqlite pragmas full_column_names and short_column_names.*

Status: open
Milestone: 1.2
Created: Sat Nov 28, 2015 08:48 AM UTC by Blady

Last Updated: Sun Nov 29, 2015 04:43 PM UTC
Owner: Blady

Hello,
By default, SQLite column names are short that is:
sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs,
proprietaires;
nom|nom
P1|A1
P21|A1
P3|A1

There is 2 pragmas but they are written deprecated (I don't find why).
http://www.sqlite.org/pragma.html#pragma_full_column_names
http://www.sqlite.org/pragma.html#pragma_short_column_names

They do almost the job:
sqlite> select distinct proprietaires.nom, auteurs.nom from auteurs,
proprietaires;
proprietaires.nom|auteurs.nom
P1|A1
P21|A1
P3|A1

I propose to add their support in Gnoga.
Thanks, Pascal.

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/gnoga/tickets/29/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Blady]

Support for pragmas full_column_names and short_column_names added with commit 1206516.