ARGen automates the generation of ActiveRecord classes and template code for a database driven app. ARGen connects to an existing database, scans the schema, and creates a Xojo project to get development started quickly.
More than just class definitions, ARGen also creates user interface elements that perform simple browse, read, edit, add, and delete functionality.
Develop faster by leveraging the power of one of the most well known ORM libraries for Xojo. ActiveRecord offers the features professionals need without sacrificing the simplicity every citizen is hoping to find.
Give both a whirl, and simplify your database code.
First, connect to any one of the supported database types to scan the schema and get a project started. ARGen supports CubeSQL, Microsoft SQL Server, MySQL, ODBC, PostgreSQL, and SQLite connections.
ARGen will determine as much as possible from the database schema and pre-set some options. Developers can also manually select the tables and views to generate as well as refine the property type definitions.
With class configuration squared away, the next step is interface configuration. Select tables and fields to process and ARGen will generate UI elements to browse, read, edit, add, and delete rows. Flexible options allow developers to define editor types and labels at the individual field level.
ActiveRecord abstracts database operations to Xojo code. Using the library, tables are classes and field columns are properties. This makes table and column names appear as auto complete suggestions. Developers access records with Xojo code - not SQL - which helps prevent runtime exceptions.More about ActiveRecordSample ARGen Project
ActiveRecord and ARGen have both been updated to support Xojo API 2.0
The ActiveRecord library now supports multiple database connections in one project
Verify that class properties still exist in the database at runtime
nilare now inserted as
It is not feasible to work on user interface generation features until the Xojo Web 2.0 product has officially released. The ActiveRecord API 2.0 library is designed to support any API 2 only Xojo frameworks. When the new Xojo Web product is released the library will be re-tested and evaluation for UI generation will begin.
This is the general plan ahead for ActiveRecord and ARGen. Please be aware this is a living document.