Editing Easy DB Help File
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
− | This is the Help "file" for the Python Application whose main page is: *'''[http://www.opencircuits.com/Python_Easy_DataBase_Project Python Easy DataBase Project - OpenCircuits ]'''. You can also get a lot of information about how the program works by looking at the GUI and its explanation: '''[[Easy DB GUI Images]]'''. | + | This is the Help "file" for the Python Application whose main page is: *'''[http://www.opencircuits.com/Python_Easy_DataBase_Project Python Easy DataBase Project - OpenCircuits ]''' |
+ | |||
+ | |||
+ | Help file for Easy DataBase application ( Documentation for Ver7 ). You can also get a lot of information about how the program works by looking at the GUI and its explanation: '''[[Easy DB GUI Images]]'''. | ||
= Application Features = | = Application Features = | ||
− | * '''[[ | + | * '''[[SmartPlug GUI Images]]'''. |
− | * Supports comma separated values ( csv ) output of data to text files. | + | * |
− | * Saves data to a sql lite database that you can use any way you wish. | + | *Supports comma separated values ( csv ) output of data to text files. |
− | * Highly configurable. | + | *Saves data to a sql lite database that you can use any way you wish. |
− | + | *Highly configurable. | |
+ | |||
= Download and Install = | = Download and Install = | ||
− | There is really no install program. Currently the application is intended for those who have at least a little familiarity with Python coding and can just insert the downloaded code into their development environment and run it. Code at '''[https:// | + | There is really no install program. Currently the application is intended for those who have at least a little familiarity with Python coding and can just insert the downloaded code into their development environment and run it. Code at '''[https://github.com/russ-hensel/smart_plug/tree/master russ-hensel/Smart_plug Application ]''' For most of you it will not run due to dependency problems. You will need to add them. Pretty much read the error messages and install the missing code. I use Anaconda Spyder so my preferred tool is conda ( conda install pyHS100 ). If conda does not work or you do not use it use pip. pyHS100, a library for smart plugs is pretty likely to be missing ( pip install pyHS100) . Depending on your installation there may be more. |
+ | |||
+ | Much of the application is configurable through the parameter.py file, but the default should give you an application that runs, including a default database. You probably will not be able to talk to your smartplugs, because the parameters do need to be told what and where ( tcpip address ) they are. | ||
− | + | ||
+ | |||
= How To:... = | = How To:... = | ||
Line 67: | Line 74: | ||
= How to Use the Parameter File = | = How to Use the Parameter File = | ||
− | + | See: [[Configuration Files For Python]] | |
− | |||
− | |||
− | |||
You need a text editor suitable for .py files to manage the parameter file ( parameters.py ) | You need a text editor suitable for .py files to manage the parameter file ( parameters.py ) | ||
− | This includes | + | This includes most text editors. I particularity like: |
*notepad++ | *notepad++ | ||
Line 99: | Line 103: | ||
= A Scenario/Use Case = | = A Scenario/Use Case = | ||
− | |||
− | |||
Lets start a new database of dogs names, their breed, and typical weight, then run a report of all the names | Lets start a new database of dogs names, their breed, and typical weight, then run a report of all the names | ||
Line 106: | Line 108: | ||
delete all the records where the dogs name is Spike. | delete all the records where the dogs name is Spike. | ||
− | + | Start the system, then press the button <Make Generic Input> | |
− | + | this will make a generic input form, a template for | |
− | + | defining a database table and its data. The system will | |
− | + | use your systems text editor to open the file. | |
− | + | ||
− | + | Save the file with a new name so it will not get overwritten the next time <Make Generic Input> | |
− | + | is run. | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | the | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
Now we will edit the file for your new set of data. | Now we will edit the file for your new set of data. | ||
− | Note that the file is full of comments ( lines starting with # ) | + | Note that the file is full of comments ( lines starting with # ) |
− | + | The purpose of the file is still insert, so do not change that | |
− | + | The name of the table should be changed to something like dogs ( generic_table_name => dogs ) | |
− | + | Now we come to the column or field names, change them for the dogs, something like: | |
− | |||
( name_first: => dog_name: | ( name_first: => dog_name: | ||
name_middle: => breed: | name_middle: => breed: | ||
name_last: => typical_weight: ) | name_last: => typical_weight: ) | ||
− | + | There are repeated records ( rows ) for this, get rid of the excess and make a bunch of | |
+ | sections so you have one section for each of the dogs you plan to enter. ( or make the sections as you go ) | ||
− | + | Enter your data, only one line per item of data. | |
− | + | When you are done your file should look like the generic file, but now specialized for dogs. | |
− | + | File it away ( remember its name ) | |
+ | Now you need a database to keep this data ( the table named something like dogs ). | ||
+ | You can use any database that is hanging around and does not already have a table called | ||
+ | dogs ( use the <Browse...> button to choose one or make a new one. | ||
+ | Lets do it the hard way and make a new one. You could type in the name you want for the file | ||
+ | but that can be tricky especially getting the path right, so lets pick one using the Database file <Browse...> | ||
+ | button, then edit the name. | ||
+ | example: I browse to: D:/Russ/0000/python00/python3/_projects/easy_db/people/people_database.db | ||
+ | which must exist and edit to | ||
+ | D:/Russ/0000/python00/python3/_projects/easy_db/people/dog_database.db | ||
+ | |||
+ | no the old file will be erased, lets warn the user and get approval ?? not sure we make it yet, we should | ||
+ | the file must not already exist ( remember we are making a new db ) but the path to it must | ||
+ | you may use your file manager to make new folders ( directories ) if you wish. | ||
+ | |||
Now for the input file <Browse...> to the file you just made. | Now for the input file <Browse...> to the file you just made. | ||
you can use the <Edit File> button to look at the file again if you wish. | you can use the <Edit File> button to look at the file again if you wish. | ||
Line 167: | Line 164: | ||
Select the table from the drop down ( dogs ) Then press <Select All> | Select the table from the drop down ( dogs ) Then press <Select All> | ||
Your text editor should open with the output. | Your text editor should open with the output. | ||
+ | |||
+ | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | = Working With Database Files = | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | * Create a directory for your data and database -- application comes with defaults | |
− | |||
− | * | ||
− | |||
− | |||
− | |||
− | + | * Run database definition routine button wf1 | |
− | + | You need to name a database, application will default | |
− | + | You also need your sample file input, start with the one from | |
− | + | the step above. | |
− | + | look at output....... | |
− | |||
− | |||
− | * | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
= The GUI = | = The GUI = | ||
Line 336: | Line 193: | ||
* Watch the GUI | * Watch the GUI | ||
* Check the Python console. | * Check the Python console. | ||
− | * Look at the python log file ( use the GUI button <Edit Log> ( specify your editor in parameters.py first ) or use your editor on the default name of the log file ...\ | + | * Look at the python log file ( use the GUI button <Edit Log> ( specify your editor in parameters.py first ) or use your editor on the default name of the log file ...\smart_plug\smart_plug.py_log. |
− | |||
− | |||
− | + | Most issues will probably be missing libraries, parameters.py issues, or just bugs in my code (email me ). | |
<!----------- | <!----------- |