Hi all,

After spending the last 12 months working intensively on a PHP based project, I moved back to FPC once again for another project. One of the more interesting concepts working in PHP was migrations. These are simple scripts that define the columns in a database table including indexes and foreign key constraints. Next to that also seeding and factories are integrated in this design. A trivial example is shown below;

        Schema::create('flights', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('airline');
            $table->timestamps();
        });

I already did some tests in pascal and it seems quite doable to create a system like this. But before I proceed I would like to check here if something like this already exists and if other developers are interested in this. If so I would publish the sources on github.

Rgds, Darius

But before I proceed I would like to check here if something like this

already exists

None that I know of for native Pascal. As I no longer use ORM, Sqitch does the job for me these days. Basically it's like a git for database schema (surely you can do CRUD as well there, but it's mainly for schema). I have an experience of building such a tool myself, not a good days. I'd rather use what others have already made and proven to be working well.

FPC contains this as well since many years, you can drop the components on a form, but they are exposed in the lazarus database desktop as well.

Michael.

Le 21/06/2020 à 00:30, Michael Van Canneyt a écrit :

FPC contains this as well since many years, you can drop the components on a form, but they are exposed in the lazarus database desktop as well.

Very interesting, I didn't know this existed. I will have fact I developed my code around 2004 for Delphi 7 and migrated it to fpc/lazarus around 2013 to be able to run it on linux server.

Unfortunately my code is progressively abandoned now.

I use the functionality in the database desktop actively. The generated code even runs in Delphi.

If you look at it and find ways to improve it, I'm all ears :-)

Michael.

I've seen other code generators that use a similar approach as yours: use templates. I considered but discarded that approach early on because there is too much logic involved; I would end up with too many templates.

Michael.