![]() We'll be installing flask-restx, a community driven fork of Flask-RESTPlus. The Pipfile requires Python 3.6, but you should be able to manually change this if you have a different Python version. We'll now install pipenv, create a virtual environment, install the project packages to it, and activate it. The app directory contains the Flask app and the src directory contains the frontend Vue app. Project-structure.txt flask-vuejs-template-master It will guide you through the process of setting up an Azure SQL database with a sample AdventureWorks dataset, and find the connection string. The video below starts from the Azure portal. You can register for an Azure account which has some services free for 12 months. To facilitate an end to end tutorial, I’m setting up an Azure SQL database for testing. ![]() This first step is optional as you might already have your own database you want to connect to. Optional: Setting up an Azure SQL database for testing You'll also need Python 3.6.x along with Node and Yarn installed. I’ll be setting up and connecting to an Azure SQL database however it should be adaptable to other databases. You’ll need either your own database set up to follow along, or you can set one up in the optional first step. You can use this as a starting point to further develop a more complex and tailored solution. Bonus: Displaying the SQL code nicely formatted.Building a simple form to accept user input.Getting a Vue - Flask app set up from a template.Optional: Setting up an Azure SQL database for testing.This article will cover building a simplified version of this app where we’ll go over the following: ![]() Finally, the data was more accessible via a web app to users without knowledge of SQL. The queries no longer needed to be ran manually, saving time. There were a multitude of benefits from this. The data could then be viewed or downloaded straight from the browser. The result was a Vue - Flask app which accepted some user input, and based upon that input, sent the relevant SQL query to a data warehouse. I was recently working on a project building a web app to automate viewing and downloading data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |