About

SQL DAL Maker generates the data access layer — DTO, Model, and DAO classes — for PHP, Java, C++, Python, and Go.

It works in three steps:

1. Reverse-engineer. The generator connects to your database over JDBC and reads live metadata: tables, views, and the result sets of your own SQL. The database must be up and reachable while you generate.
2. Fine-tune. What it found is written out as an XML manifest. You override the types your driver got wrong, add fields it could not see, and pick which CRUD methods you actually need.
3. Translate. The manifest is translated into complete source code — free of any direct call to PDO, JDBC, or QtSql. Those stay behind a DataStore interface that you own.

The manifest persists, so regeneration is repeatable: when the schema changes, you re-run the generator and your corrections are still there.

Implemented in Java as plug-ins for Eclipse IDE and IntelliJ Platform.

Hello-App

<sdm>
    <dto-class name="Message" ref="messages"/>
    <dao-class name="MessagesDao">
        <crud dto="Message"/>
        <query-list method="get_messages_like(key)" ref="get_messages_like.sql"/>
    </dao-class>
</sdm>

def generated_code_in_action():
    ds = scoped_ds()
    dao = MessagesDao(ds)
    m = Message()
    m.text = "Hello, World!"
    dao.create_message(m)
    print(m.id) # new "id" is available now
    m.text = "Hello, SDM World!"
    dao.update_message(m)
    for msg in dao.get_messages_like("hello%"):
        print(msg)
    dao.delete_message(m.id)

Install and Update

Links