To execute locally this project you will need to follow the steps bellow:

1. First go to the folder: client and run the command:

npm install

2. After to install all the Node.Js packages, now you can execute the command:

npm run serve

3. Now, open your browser on http://localhost:8080/. Thanks to the configuration defined in vue.config.js all requests will be automatically proxied to the local Azure Functions host. You can learn more about the integrated proxy in vue client here: VUE CLI Configuration Reference

Depending on what you prefer, you can use a local SQL Server to Azure SQL DB hosted in Azure to run your local application.

Using local SQL Server

Thanks to DevContainers, SQL Server 2019 is already running in your enviroment. All you have to do is to create an .env file in the api folder and add the connection string to connect to the aformentioned SQL Server 2019:

# Database connection string
DATABASE_URL="sqlserver://db:1433;database=EmployeeDB;user=sa;password=P@ssw0rd;encrypt=true;trustServerCertificate=true;"

# Shadow database connection string for development
SHADOW_DATABASE_URL="sqlserver://db:1433;database=EmployeeDB;user=sa;password=P@ssw0rd;encrypt=true;trustServerCertificate=true;"

Unless you have changed the database name, login and password in the Dockerfile that comes into the .devcontainer folder, the above connection string is already correct. Of course make sure you use this connection string only for testing, as it is using the sa account to log into SQL Server, which is the most powerful administrative account and should not be used to connect your application to the database.

Using Azure SQL database

If you want to test Azure SQL database, to make sure everything will work perfectly even when deployed on Azure, you need to create an Azure SQL database before.

Using the Azure Dev CLI

The following prerequisites are required to use this application. Please ensure that you have them all installed locally.

• Azure Developer CLI
  • Windows:

    powershell -ex AllSigned -c "Invoke-RestMethod 'https://aka.ms/install-azd.ps1' | Invoke-Expression"
    

  • Linux/MacOS:

    curl -fsSL https://aka.ms/install-azd.sh | bash
    

• Azure CLI (2.38.0+)

To create the necessary infrastructure on Azure:

1. Open a terminal, change directory to the root of this project.
2. Run the following command to initialize the project, provision Azure resources.

azd provision

For more details, read the Azure Dev CLI documentation.

Once the infrastructure has been created, create a .env file in the api folder and copy/paste content from .azure/azure-sql-prisma-vue/.env. We only care about the DATABASE_URL and SHADOW_DATABASE_URL variables:

# Database connection string
DATABASE_URL="sqlserver://DB_SERVER_NAME.database.windows.net:1433;database=DB_NAME;user=DB_USER@DB_SERVER_NAME;password={PASSWORD};encrypt=true"

# Shadow database connection string for development
SHADOW_DATABASE_URL="sqlserver://DB_SERVER_NAME.database.windows.net:1433;database=DB_NAME;user=DB_USER@DB_SERVER_NAME;password={PASSWORD};encrypt=true"

Using the Azure Portal

The are different ways you can create an Azure SQL Database. Using the Portal, using AZ CLI or Powershell. The easiest is using the Portal, and you can have see complete walk-through in this recording: Demo: Deploy Azure SQL Database | Azure SQL for beginners (Ep. 14). If you prefer reading instead of watching, here a complete quickstart guide available, with detailed steps for each option: Quickstart: Create an Azure SQL Database single database. If you want something more concise and direct, you can to follow the simple 6-steps guide available here: Create and connect to an Azure SQL DB.

Make sure you create two Azure SQL databases:

• azuresql-prisma-database
• azuresql-prisma-database-shadow

And you also create two users, one for each database. If you are not sure how to do it, don't worry, the links mentioned above will help you in going throught the simple process.

Once the database have beem created, include the Azure SQL Server connection string creating an .env file in the api folder:

# Database connection string
DATABASE_URL="sqlserver://DB_SERVER_NAME.database.windows.net:1433;database=DB_NAME;user=DB_USER@DB_SERVER_NAME;password={PASSWORD};encrypt=true"

# Shadow database connection string for development
SHADOW_DATABASE_URL="sqlserver://DB_SERVER_NAME.database.windows.net:1433;database=DB_NAME;user=DB_USER@DB_SERVER_NAME;password={PASSWORD};encrypt=true"

1. First go to the folder: api and run the command:

> npm install

2. Make sure you have an .env file configured as explained in the Project: db section above.

3. Now create a file called: local.settings.json (root of the project) and include this information below:

{
  "IsEncrypted": false,
  "Values": {
    "FUNCTIONS_WORKER_RUNTIME": "node",
    "AzureWebJobsStorage": ""
  },
  "Host": {
    "LocalHttpPort": 7071,
    "CORS": "*"
  }
}

4. Now we need to execute the prisma migrate command. Run the command below

> npx prisma migrate dev

5. Now you can execute the command:

> npm run dev

You will see the message saying the application is running in the port: http://localhost:7071/api/