Every table in the database must be created. This is done before the Flask server is started otherwise it causes errors. I’ll be using the F5 Info page. Creating the Table Models.py The models.py file is what contains all the Python classes for the database tables. Setting up the Database This must be run before […]
Flask Creating SQLite3 Table and Database Read More »
There are a number of places inside the F5 Dashboard project where the database needs to be modified. A good example of this is from the F5 info gathering page. The F5 info page is displaying some columns from a database table.There are a few things going on here so I will start at the
Python Modifying SQLite3 Database Read More »
This is a basic file upload through Flask. I have used this in my F5 Dashboard project to upload a CSV file that contains the database that is used as the source for what domains require SSL profile updates. The Process There are two views for the CSV upload. The file uploader The database refresh
This is a very basic way to set the default path to always be the same as where the script is running from.So if the script has multiple files referenced then when moving the script instead of updating the paths for something such as opening a csv file, as long as the file is in
Python Default Setting Path Read More »
As I didn’t explain the functionality of the feedback form and login on the main project page I thought I would put it as a post and add in the details behind the downloading of the feedback table as a CSV format. The Process I have not made the option to download the csv available
jQuery Download DB Table as CSV Read More »
This is a quick note of how to create buttons that can toggle forms using jQuery. I used this in the F5 Dashboard to display different forms. The user can click on the top or bottom to reveal that. Then clicking the other button will hide the first to only reveal the second. Example JSFiddle
jQuery Toggle Form Buttons Read More »
This is a how I have used jQuery to build a table from a list that is returned. The table is a list of lists, each element in the list is a row. Returned List in Python This is a list of lists, here I am printing each element of the overall list. More on
jQuery Display Table Read More »
This is a nice and quick note of how to create a button on a web page that will be used to run something. In this example I am going to be shuffling a deck of cards from the Deck of Cards API.https://www.deckofcardsapi.com Very basic, a button on a web page. When clicked the API
jQuery Button Call API Read More »
This is a very quick and dirty way to backup network devices rom my GNS3 lab. I will likely expand on this in the future. This is a simple Paramiko script that will SSH into each device perform “show run” and sve that output with in a text file with the IP, year, month and
GNS3 Lab Paramiko Backup Read More »
This is where we start to integrate Scrapli with Flask. Here I have created a very quick website that is mostly reused from my F5 Dashboard project. This is a very simple web app with the single purpose of adding data to a database and then displaying that to a user. How it Works The
Scrapli and Flask – Part 3: Scrapli Integrated into Flask Read More »