| Re: [stellation-res] Yet another DB abstraction idea... |
On Wed, Aug 14, 2002 at 08:55:58AM +0000, Mark C. Chu-Carroll wrote:
> The template version would be:
>
> String command =
> db.expandCommand("CREATE TABLE Properties " +
> "($INT aid, $INT vid, $INT inheritable, $SHORTSTRING name" +
> "$LONGSTRING value, " +
> "CONSTRAINT fk4 FOREIGN KEY (aid, vid) REFERENCES Versions(aid,vid), " +
> "PRIMARY KEY(aid, vid, name))$CREATE_TRAILER");
>
> DB implementations would provide a set of mappings of keywords to
> the appropriate value for the database.
>
> It looks like SQL, it's easy to write, and it'll be easy to implement. Seems
> like an obvious answer, much less stupid than the earlier idea. What do
> you all think?
+1
florin
/me is cursing the java "designers" who didn't add multiline string
constants to the language.
--
"If it's not broken, let's fix it till it is."
41A9 2BDE 8E11 F1C5 87A6 03EE 34B3 E075 3B90 DFE4
Attachment:
pgpotC31AhiuV.pgp
Description: PGP signature