About

SQL DAL Maker is a generator of DTO, Model, and DAO classes to access relational databases. Target programming languages: PHP, Java, C++, Python, and Go. To generate the class, you declare it in XML meta-program.

At the stage of code generation, the target database must exist and be available for JDBC connection. Generated code is being synchronized with the current database schema using "live" JDBC metadata.

Implemented in Java as plug-ins for Eclipse IDE and IntelliJ Platform. See also GitHub and Quick Demo Video.

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
Eclipse IDE 3.8+

Follow this: https://marketplace.eclipse.org/content/sql-dal-maker/help or use drag-and-drop feature from here: https://marketplace.eclipse.org/content/sql-dal-maker

Update site URL 1 (fast access): https://sourceforge.net/projects/sqldalmaker/files/eclipse

Update site URL 2 (redirected): https://sqldalmaker.sourceforge.net/eclipse

IntelliJ Platform 2018.1.8+

Supported products: PhpStorm, IntelliJ IDEA, Android Studio, CLion, PyCharm, GoLand.

IDE Menu "File" > Settings > Plugins > Marketplace > SQL DAL Maker > Install.

IDE Menu "File" > Settings > Plugins > Installed > SQL DAL Maker > Update.

Or use "Install..." button from the plug-in web-page: http://plugins.jetbrains.com/plugin/7092