The Soft9000/PyDAO ("PyDAO 9000") Project allows us to quickly create a Python Class from either a GUI, API, textual (CSV, TDF, Enpiped, etc.) data file, or using a Python Dictionary.
Best of all the code generated by PyDAO 9000 is 100% Core Python 3 - no other files are required!
Workflows include:
(1) Creating stand-alone PyDAO 9000 DAO script(s.)
(2) Extracting PyDAO 9000 projects from textual (CSV, etc.) data files,
(3) Creating database code from PyDAO 9000 projects, and
(4) Directly creating code from the PyDAO 9000 API. Result output-locations can also be specified.
The generated code can be used to create / drop database schema (DDL,) as well as to import & work with (C.R.U.D & query) your designed / detected / updated projects.
All four (4) workflows are supported - feel free to give each a try!
Years latter the project is working well enough to declare what we have as an Official PyPi Package.
Once installed most will probably want to use the GUI:
>>> from SqltDAO import main as PyDAO
>>> PyDAO.Main.mainloop()
As of this release, the GUI will also now start when importing SqltDAO:
>>> import SqltDAO.MainGUI
If you want to support the effort feel free to purchase one of our books on amazon or training opportunuties.
PyDAO UI: https://github.com/soft9000/PyDAO/blob/master/SqltDAO/main.py
For those who would rather create the DAO directly without needing a file full of data:
Fast-Schema Example - https://github.com/soft9000/PyDAO/blob/master/SqltDAO/Demo123.py
Includes a classic "address book" example as a test case:
Data Example: https://github.com/soft9000/PyDAO/blob/master/SqltDAO/DaoTest01/tc001_data.txt
Generated Code: https://github.com/soft9000/PyDAO/blob/master/SqltDAO/DaoTest01/foo.py
Python 1000, Python 2000, and Python 3000 students who are participating in our Stock Market resume-builder will want to look at the NASDAQ database generator.
While that stock exchange's official pipe-delimited ("enpiped" ;) data file is incuded for demonstrative purposes, note that the most recent set of enpiped data tokens can be downloaded from the stock exchange.
If you need to learn Python 3, then consider:
https://www.udemy.com/python-1000
https://www.udemy.com/python-2000-beyond-the-basics
https://www.udemy.com/python-2100-objects-factories-frameworks
As well as our "Python 3000 SQL Quick Start:" https://www.udemy.com/python-3000-tactical-sql-quick-start
Need some practice? Then try to ...
[WIP] GenTUI: Rapidly create a textual / console data CRUD application.
[WIP] GenGUI: Rapidly create a graphical / GUI CRUD application.
If you want to support the effort, I seek no donations. Instead, simply feel free to purchase one of my educational or printed productions?