Python Easy DataBase Project - Revision history

Russ hensel: /* Introduction/Status */

2019-12-01T19:29:29Z

Introduction/Status

Russ hensel: /* The Internet */

2019-12-01T19:28:53Z

The Internet

Russ hensel: /* Youtube Not Involving Python */

2019-12-01T19:27:59Z

Youtube Not Involving Python

Russ hensel: /* In this Wiki */

2019-12-01T19:27:31Z

In this Wiki

Russ hensel: /* Introduction/Status */

2019-12-01T19:26:39Z

Introduction/Status

Russ hensel: /* Python Code */

2019-12-01T19:22:40Z

Python Code

Russ hensel: /* Program Design */

2019-12-01T19:22:04Z

Program Design

Russ hensel: /* Graphical User Interface */

2019-12-01T19:21:47Z

Graphical User Interface

Russ hensel: Created page with "This is an article started by Russ Hensel, see "http://www.opencircuits.com/index.php?title=Russ_hensel#About My Articles" About My Articles for a bit of info. Still polishing..."

2019-12-01T19:21:23Z

Created page with "This is an article started by Russ Hensel, see "http://www.opencircuits.com/index.php?title=Russ_hensel#About My Articles" About My Articles for a bit of info. Still polishing..."

New page

This is an article started by Russ Hensel, see "http://www.opencircuits.com/index.php?title=Russ_hensel#About My Articles" About My Articles for a bit of info. Still polishing up this page.
= Introduction/Status=

'''Purpose:''' This is a Graphical User Interface Application (actually two applications ) is to control TP-LINK HS110 Smart Plug w/Energy Monitoring (*'''[https://www.amazon.com/gp/product/B0178IC5ZY/ref=ppx_yo_dt_b_asin_title_o06_s00?ie=UTF8&psc=1 TP-LINK HS110 Smart Plug w/Energy Monitoring - - Amazon.com ]''' ) graph and otherwise process the data. The application uses the pyHS100 library code. It should work on Windows, Mac, Linux, and the Raspberry Pi. It does require at least Python 3.6 as it uses f-strings ( print( f"evaluate this{1+1}" )

'''Program Status:''' ( Program now Ver7 ) More or less beta, seems to work fairly well if not stressed. Intended for those with some Python experience who can add the files to their
Python development environment ( no install features for this code ). Some dependencies will need to be installed, probably prompted by error messages.
Editing of the parameter file should be easier for those with Python experience. Users should find some useful documentation in the code, this is still
a work in progress. Much code has been lifted from other projects of mine, some artifacts remain.

'''This Page Status:''' This page is the "master" page for the project, all other pages link back here, either directly or indirectly. Pages are drafts, but worth reading if you are trying to use the program.

'''Help File:''' Including install and configuration. [[SmartPlug Help File]]. Screen shots and more at: '''[[SmartPlug GUI Images]]'''.

'''More Documentation:''' See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )

= Graphical User Interface =
Like to see what the interface, the gui, looks like see: *[[SmartPlug GUI Images]]

= Help "file" for the Program =

Not a file but a page on this Wiki, this includes information on Download and Install, see: '''[[SmartPlug Help File]]'''
Note that the wiki pages as pdf files may be found in .\wiki_etc, but these sometimes lag the online versions.

= Python Code =
Available at:

*'''[https://github.com/russ-hensel/smart_plug/tree/master russ-hensel/smart_plug: Program Source ]'''

*Directory Structure
**.\ all executable python code
**.\wiki_etc supplementary documentation, in particular this wiki's pages as pdf's.

= Program Design =
See: [[SmartPlug Technical]]

= Links =

== In this Wiki ==
*[[SmartPlug Help File]]
*[[SmartPlug Technical]]
*[[SmartPlug GUI Images]]
*Click on Python SmartPlug Category below

== The Internet ==
=== General ===

*'''[https://pypi.org/project/pyHS100/ pyHS100 · PyPI ]'''
*'''[https://github.com/GadgetReactor/pyHS100 GadgetReactor/pyHS100: Python Library to control TPLink Switch (HS100 / HS110) ]'''
*'''[https://pceasies.com/blog/tag/pyhs100/ pyhs100 – PCEasies ]'''
*'''[https://news.ycombinator.com/item?id=18576009 There's now a pyhs100 library/utility that works pretty nicely out of the box. ... | Hacker News ]'''

=== Matthias Random Stuff and Related ===
Matthias's youtube videos originally informed me about the SmartPlugs.
*'''[https://www.youtube.com/watch?v=0LVKUxtK4Wg Refrigerator heat pump efficiency test - YouTube ]'''
*'''[https://www.youtube.com/watch?v=0LVKUxtK4Wg (54) Refrigerator heat pump efficiency test - YouTube ]'''
*'''[https://woodgears.ca/heating/fridge.html Refrigerator heat pump efficiency ]'''
*'''[https://woodgears.ca/physics/humidity.html Of dehumidifiers, moisture and vapour barriers - experiments ]'''

=== Amazon ===
Of course there are other sources.
*'''[https://www.amazon.com/gp/product/B0178IC5ZY/ref=ppx_yo_dt_b_asin_title_o06_s00?ie=UTF8&psc=1 TP-LINK HS110 Smart Plug w/Energy Monitoring - - Amazon.com ]'''
*'''[https://www.amazon.com/dp/B07KYVS85J/ref=dp_cerb_1 TP-Link Mini WiFi Smart Plug, Wi-Fi, Compatible with Alexa, Only Occupies one Socket (HS105), Wall-Light, Electronic-Component-switches, 1-Pack (Renewed) - - Amazon.com ]'''

=== Youtube Not Involving Python ===
Or maybe some Python ??
*'''[https://www.youtube.com/watch?v=9gTDlD1whdw (54) ESP8266 Smart Power Plug: Control and Monitor device from Internet - YouTube ]'''

[[Category:Python Projects]] [[Category:Python SmartPlug]] [[category:Python]]

@@ Line 11: / Line 11: @@
 '''This Page Status:''' This page is the "master" page for the project, all other pages link back here, either directly or indirectly. Pages are drafts, but worth reading if you are trying to use the program.
-'''Help File:'''  Including install and configuration. [[Easy DB Help File]].  Screen shots and more at: '''[[Easy DB GUI Images]]'''.
+'''Help File:'''  Including install and configuration. '''[[Easy DB Help File]]'''.  Screen shots and more at: '''[[Easy DB GUI Images]]'''.
 '''More Documentation:'''  Not ready yet, this is false as of now See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )

@@ Line 44: / Line 44: @@
 == The Internet ==
-=== General ===
+None yet, ever?
 [[Category:Python Projects]] [[Category:Python Easy DB]] [[category:Python]]

@@ Line 63: / Line 63: @@
 *'''[https://www.amazon.com/dp/B07KYVS85J/ref=dp_cerb_1 TP-Link Mini WiFi Smart Plug, Wi-Fi, Compatible with Alexa, Only Occupies one Socket (HS105), Wall-Light, Electronic-Component-switches, 1-Pack (Renewed) - - Amazon.com ]'''
-=== Youtube Not Involving Python ===
-[[Category:Python Projects]] [[Category:Python SmartPlug]] [[category:Python]]
+[[Category:Python Projects]] [[Category:Python Easy DB]] [[category:Python]]

@@ Line 38: / Line 38: @@
 == In this Wiki ==
-*[[SmartPlug Help File]]
+*[[Easy DB Help File]]
-*[[SmartPlug Technical]]
+*[[Easy DBTechnical]]
-*[[SmartPlug GUI Images]]
+*[[Easy DBGUI Images]]
-*Click on Python SmartPlug Category below
+*Click on Python Easy DB Category below
 == The Internet ==

@@ Line 2: / Line 2: @@
 = Introduction/Status=
-'''Purpose:''' This is a Graphical User Interface Application (actually two applications ) is to control TP-LINK HS110 Smart Plug w/Energy Monitoring (*'''[https://www.amazon.com/gp/product/B0178IC5ZY/ref=ppx_yo_dt_b_asin_title_o06_s00?ie=UTF8&psc=1 TP-LINK HS110 Smart Plug w/Energy Monitoring - - Amazon.com ]''' ) graph and otherwise process the data.  The application uses the pyHS100 library code.  It should work on Windows, Mac, Linux, and the Raspberry Pi.  It does require at least Python 3.6 as it uses f-strings ( print( f"evaluate this{1+1}" )
+'''Purpose:''' This is a Graphical User Interface Application to easily create databases using simple text files to control input, output, and record maintance.  The application uses an sqllite database.  It should work on Windows, Mac, Linux, and the Raspberry Pi.  It does require at least Python 3.6 as it uses f-strings ( print( f"evaluate this{1+1}" )
-'''Program Status:''' ( Program now Ver7 ) More or less beta, seems to work fairly well if not stressed.  Intended for those with some Python experience who can add the files to their
+'''Program Status:''' ( Program now Ver9 ) Very Alpha, many parts work. Not ready to post the code.  Intended for those with some Python experience who can add the files to their
 Python development environment ( no install features for this code ).  Some dependencies will need to be installed, probably prompted by error messages.
 Editing of the parameter file should be easier for those with Python experience.  Users should find some useful documentation in the code, this is still
@@ Line 11: / Line 11: @@
 '''This Page Status:''' This page is the "master" page for the project, all other pages link back here, either directly or indirectly. Pages are drafts, but worth reading if you are trying to use the program.
-'''Help File:'''  Including install and configuration. [[SmartPlug Help File]].  Screen shots and more at: '''[[SmartPlug GUI Images]]'''.
+'''Help File:'''  Including install and configuration. [[Easy DB Help File]].  Screen shots and more at: '''[[Easy DB GUI Images]]'''.
-'''More Documentation:'''  See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )
+'''More Documentation:'''  Not ready yet, this is false as of now See links below, and code ( '''[https://github.com/russ-hensel/smart_plug russ-hensel/Smart Plug Repository]''' )
 = Graphical User Interface =

@@ Line 24: / Line 24: @@
 = Python Code =
-Available at:
+Available at: Not yet, this links to a different project
 *'''[https://github.com/russ-hensel/smart_plug/tree/master russ-hensel/smart_plug: Program Source ]'''

@@ Line 33: / Line 33: @@
 = Program Design =
-See: [[SmartPlug Technical]]
+See: [[Easy DB Technical]]
 = Links =

@@ Line 16: / Line 16: @@
 = Graphical User Interface =
-Like to see what the interface, the gui, looks like see: *[[SmartPlug GUI Images]]
+Like to see what the interface, the gui, looks like see: *[[Easy DB GUI Images]]
 = Help "file" for the Program =