dFrame

dFrame is an open source PaaS (Platform as a Service) solution. You can evaluate the prototype now. You can build up a business application without any code (No Code) or with small amount of SQL statements (Low Code).
It should be strongly mentioned that the source code (or system information) of your application is build on MySQL database as "data", that is, the ultimate target of dFrame is "auto porgraming" thru AI generator. For details visit web site PaaS dFrame
YouTube dframe:Create an app with nocode(5min)

Reqirments

Windows , Linux
flask/Python3
MySQL

Source Code

Please download from the branch "master"

Create dFrame Platform

1.make the file folder for your PaaS Platform on your system(ex."dFrameSystem")
2.deploy download file of 'dframe'package to the above folder

Create database on MySQL

1.create the following schema
dframe: dframe control information
testbed: sample app for training tool for biginners as well as testbed for pytest
dframe_testbed: control information for "testbed" app
2.down load mysql dump
mysql -uroot -pmypass dframe < ../sql/dframe.dump
mysql -uroot -pmypass dframe_testbed < ../sql/dframe_socket.dump

Instration:Layout

dFrameSystem
　|---dframe/
　|　　　|---init.py
　|　　　|---auth.py
　|　　　|---commonTool.py
　|　　　|---constant.py
　|　　　|---db.py
　|　　　|---formInfoGetting.py
　|　　　|---genPDF.py
　|　　　|---index.py
　|　　　|---navi.py
　|　　　|---trailKeeper.py
　|　　　|---viewEdit.py
　|　　　|---static/
　|　　　|---templates/
　|　　　|　　　|---auth/
　|　　　|　　　|　　　|---login.html
　|　　　|　　　|---base.html
　|　　　|　　　|---bForm.html
　|　　　|　　　|---.....html
　|　　　|---out_files/
　|
　|---sql
　|　　　|---dframe_inv2_20250701.dump
　|　　　|---dframe.dump
　|　　　|---dframe_inv2_20250701.dump
　|　　　|---dframe_socket.dump
　|　　　|---nschool_20250701.dump
　|　　　|---nschool_20250701.dump
　|
　|---logfile/
　|　　　|---logger.log
　|
　|---tests/
　|　　　|---init.py
　|　　　|---.....py
　|　　　|---testRun.bat
　|　　　|---testRun.sh
　|
　|---venv/
　|---flaskRun.bat
　|---flaskrun.sh
　|---createApp.bat
　|---createapp.sh

Run testbed app on Setting mode

1.cd dFrameSystem(your PaaS Platform)
2.sh flaskrun.sh(linux) or flaskRun.bat(widows)
3.reply to log form as "admin" as user name and "password" as password as well as choice "testbed" as app name selection menu.

Create tables(objects) on the testbed app

1.set runnning mode thrugh hitting "Setting" link on the top menu bar on the form
(defalut running mode is "applicationt"
2.Hit "Add" button to create new table(object)
3.define table name on the table definition form then hit "Save" button
4.You will find your new table(object) name on the object list form
5.Hit "setting" link on your new table(object) on the object list form
6.define data fields for your new table(object)
for more detail, please vist YouTube (search "dframe")

Run testbed app on Application mode

1.Hit "Application" link on the top menu bar on the form
2.You can see your object(s) list on the form
3.Hit "Open" link on the object(s) list
4.There is no data, "empty", on that object.
5.Hit "Add" button to create data of the object
6.Empty form of the object is set for your new data entry

Create your new application

to create new applicaton,
1.create new schema on MySQL whose name is of mame of your new application (ex."newapp")
2.sh createapp.sh newapp NewAPP (or createAPP.bat newapp,NewApp)
　newapp:your object name(sample) NewAPP:title of your new application
3.reply to log form as "admin" as user name and "password" as password as well as choice "NewAPP" as app name selection menu.
4.define objects and their fields for NewAPP like as mentioned for testbed app

Sample applications:

1.Nursly School Document Support System: dframe_nschool_20250701.dump, nschool_20250701.dump(Japanese version)
2.Inventory Information System: dframe_invt2_20250701.dump, invt2_20250701.dump(English version)
Those source code are available to download from the branch "master"

If you have any questions or comments, please mail to dframe@u01.itscom.net .