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

[Graeme Geldenhuys]

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"! ;-)



-- 
Regards,
  - Graeme -


_______________________________________________
fpGUI - a cross-platform Free Pascal GUI toolkit
http://fpgui.sourceforge.net