Generate a Python Class to create a Database from a CSV (or Similar!) File
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
SqltDAO
README.md
_config.yml

README.md

PyDAO

Generate a Python Class from either a textual (CSV, TDF, Enpiped, etc.) data file, or using a Python Dictionary.

The generated code can be used to import, as well as work with (C.R.U.D and query using SQL SELECTions, etc.) that data.

API Example

For those who would rather create the DAO directly, without using a data file:

Fast-Schema Example: https://github.com/soft9000/PyDAO/blob/master/SqltDAO/Demo123.py

EXAMPLE / TEST CASE

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

STOCK MARKET

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.

Selecting Data: https://github.com/soft9000/PyDAO/blob/master/SqltDAO/DaoTest01/GenNasdaqTest.py

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.

VIDEO TRAINING

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

CONTACT INFORMATION

If you have suggestions or opportunities - be they for additional projects, corrections, consulting and / or just about anything else - feel free to use the contact form at Soft9000.com to send us a message: http://soft9000.com/blog9000/contact.php