[fpc-pascal] Re: tiOPF: automapping for m-n relationships

Graeme Geldenhuys graemeg.lists at gmail.com
Tue Apr 3 00:26:32 CEST 2012

On 2 April 2012 15:37, leledumbo <leledumbo_cool@***> wrote:
> Ouch, that's a bit bad to hear, I thought I could get something simpler. I'll
> try to implement that relationship manager pattern because I want to avoid
> direct sql.

Yeah, Auto-Mapping hasn't received a lot of love in recent years. I
have plans to totally revamp it, but I just never seem to get the time
to do the actual work.

As for hard-coded visitors. Yes they are driven by SQL, but that
doesn't mean you need to write the SQL yourself, or implement the
visitors manually. Use the tools! :-)  Lazarus's Data Desktop (I think
that's the name) can generate complete units of code with SQL for you.
I also ported and updated a old tiOPF tool called tiSQLEditor. With
tiSQLEditor, it can generate vast amounts of tiOPF code for you, based
on simple SQL statements. For the remainder, I use the power of Code
Templates in my IDE. I've produced some 30-40 fully working hard coded
visitors in 15 minutes - that's a lot of mostly auto generated code.
So "hard-coded visitors" doesn't always equal "hard work"! ;-)

  - Graeme -

fpGUI - a cross-platform Free Pascal GUI toolkit

More information about the fpc-pascal mailing list