Growing stuff and doing things

[dstroy0]

Yeah, it's a little over the top for what you need. I just deal with PHP that looks like what you have all day long, and it makes the hair on my neck raise up.

No judgement towards you at all -- for context, the codebase I work with was written by "PHP professionals" and more so resembles what a freshman in CS would write. How's that saying go? Make it work, make it fast, make it pretty or something like that... If it's doing what you need, then it's not a big deal.

On that note, Python has a library called BeautifulSoup4 that is fantastic for generating HTML, and has the added benefit of not catching the hate that PHP does. Not sure if you've worked with python at all, but I could throw you some code samples to get an idea of how easy it'd be to switch over (wrote a small app specifically to separate PHP, HTML, CSS, and JS into separate files, and reconstruct the HTML accordingly).

Did you look at the table generator? The php table code should be very readable after I implement that. What would I be scraping with beautifulsoup? Side note, I've already started separating everything into its own file.

 

[coste]

Did you look at the table generator? The php table code should be very readable after I implement that. What would I be scraping with beautifulsoup? Side note, I've already started separating everything into its own file.

You don't necessarily have to scrape with BS, you can generate HTML with it too. It's just an overall DOM library. That being said, I've only explored minimal functionality of it, it's really robust. Also, I haven't looked at the PHP table generator yet, but certainly will!

 

[dstroy0]

You don't necessarily have to scrape with BS, you can generate HTML with it too. It's just an overall DOM library. That being said, I've only explored minimal functionality of it, it's really robust. Also, I haven't looked at the PHP table generator yet, but certainly will!

Cool! I didn't even know what DOM was, I had to google it hahahahaha I'm new.

 

[dstroy0]

Figuring out how to recolor cells on the fly

function cell_color(id, red_low, yellow_low, yellow_high, red_high){
    var cell_value = document.getElementById(id).textContent;
    cell_value = parseFloat(cell_value * 1);
    console.warn(cell_value);
    if (cell_value < yellow_high && cell_value > yellow_low) {
        //return;
        console.warn("nom");
    }
    if (cell_value < red_low || cell_value > red_high) {
        document.getElementById("RES_pH").setAttribute('style', 'color: white !important; background: red; opacity: 0.75;');
        //return;
        console.warn("red");
    }
    if ((cell_value < yellow_low && cell_value > red_low) || (cell_value > yellow_high  && cell_value < red_high)) {
        document.getElementById(id).setAttribute('style', 'color: black !important; background: yellow; opacity: 0.75;');
        console.warn(id, " yellow");
    }
    
    return document.getElementById(id).value;
}

function recolor_cells() {
document.getElementById("RES_pH").onchange= cell_color("RES_pH", 5.6, 5.85, 5.95, 6.1);
}

 

[dstroy0]

making visualizations was pretty easy once I figured out how to use it

 

[dstroy0]

pretty cool!

 

[dstroy0]

I used this guide to make a service that autorestarts (respawns?) my insert script

GitHub - torfsen/python-systemd-tutorial: A tutorial for writing a systemd service in Python

A tutorial for writing a systemd service in Python - GitHub - torfsen/python-systemd-tutorial: A tutorial for writing a systemd service in Python

github.com

 

[GCG]

Can you mix in a weed picture every once in a while for us dumbasses. At least I understand that. ?

 

[dstroy0]

Can you mix in a weed picture every once in a while for us dumbasses. At least I understand that. ?

lol yeah man I've just been really focused on this part of it I guess hahahaha

 

[dstroy0]

I fixed a connector

 

[Deebs]

@dstroy0 thats what im freakin' talking about! Grafana is an awesome tool man, using it for cannabis metrics? fuckin' frosty bro~ It does really help visualize things. Are you calculating baselines, and triggering alerts for out of baseline conditions?

 

[dstroy0]

Grape ape

 

[dstroy0]

Working on my python email alert script, I'll just pass it something and it'll send me a canned alert if I need to check something.

Got the water level sensor code finished and pulled them out to the ui

 

[dstroy0]

I think it's probably time to switch to a relational schema, but I think I need to figure out how to write CTEs in SQL to join tables before I try that. My database is at 168 columns now, probably half of those are config columns that only get populated once, so they're just there doing nothing. I think that I figured out a good way to attach/detach columns from my log daemon script:

#open file for reading 'r'
column_file = open('columns.csv', 'r')
#read contents of file
content = column_file.read()
#remove all newline
content = content.replace('\n', '')
#remove all spaces
content = content.replace(' ', '')
#split list item on comma
content_list = content.split(',')
#close file after done using
column_file.close()
#print(content_list, len(content_list))
#use sql query to get existing columns, compare against list create if not exists
#reject all other columns, log to error_columns.csv
#allow user to create columns for tables on the fly by adding columns to the tables' columns.csv

 

[dstroy0]

playing with grafana is fun

 

[Buck5050]

Looks Killer!

 

[dstroy0]

It's starting to look like a dashboard!

 

[dstroy0]

systemd

Python systemd wrapper

pypi.org

This was pissing me off, my systemd unit would just stay on activating because I didn't know I had to add this. I switched from a simple unit to notify. It would just say activating, even though the script was running and inserting fine.

 

[dstroy0]

Got the doser on the wall, I need another channel now that I’m using a 2 part fert.

 

[Buck5050]

How can this shit go wrong with Rick and the gnomes keeping an eye on things and passing doobers around...