Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » SqlId aliasing
SqlId aliasing [message #41909] Wed, 05 February 2014 13:26 Go to next message
wqcmaster is currently offline  wqcmaster
Messages: 37
Registered: March 2013
Member
Similar to this post, we added some kind of SqlId aliasing.

It works as follows:
database.sch:
TABLE__(MyTableName, T1) // Fuer DBDomaenen
   INT_     (MPK) PRIMARY_KEY
   BOOL__   (BooleanVariable, CB1)
   INT__    (NameId, CI1)
   INT__    (VendorId, CI2)
   INT__    (TaskId, CI3)
   STRING__ (Title, CS1, 255)
   STRING__ (Description, CS2, 50)
   TIME__   (Timestamp, CT1)
END_TABLE

will now generate the following SqlIds:
SqlId MyTableName("T1");
SqlId MPK("MPK");
SqlId BooleanVariable("CB1");
SqlId NameId("CI1");
SqlId VendorId("CI2);
SqlId TaskId("CI3");
SqlId Title("CS1");
SqlId Description("CS2");
SqlId Timestamp("CT1");


Well, as you see, aliasing is not the correct terminology, maybe some kind of simple database column name obfuscation.

Patch attached to this post; done against r6693 but also works against r6870.

Something to be included in TRUNK?

[Updated on: Wed, 05 February 2014 13:27]

Report message to a moderator

Re: SqlId aliasing [message #42008 is a reply to message #41909] Mon, 10 February 2014 20:05 Go to previous message
mirek is currently offline  mirek
Messages: 13996
Registered: November 2005
Ultimate Member
This is interesting idea, but has disadvantage that it needs a fix to all "driver" schema definition headers. I will have to think about it a bit before commiting to trunk.
Previous Topic: firebird with sqlarray ctrl (possible?)
Next Topic: Oci8 64bit support for BLOB/CLOB
Goto Forum:
  


Current Time: Tue Jul 23 20:43:36 CEST 2024

Total time taken to generate the page: 0.01947 seconds