TruckerWeather

Reproducing a Quarto project environment on another machine

First, have R and Python installed globally on your system.

In Rstudio:

Go to: File

Click New Project

Select Version Control

Paste this repo's code link

in R console:

install.packages("renv")

renv::restore()

renv::snapshot()

Follow prompts to install R and Python packages during these steps where necessary. If doing this without an R console, you might be able to run that R code in R-code chunk(s) within the index.qmd file of the project.

For Creating a MSSQL Server in Docker

sudo docker pull mcr.microsoft.com/mssql/server:2022-latest

sudo docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=MyStr@ngPassw0rd11" -p 1433:1433 --name sql1 --hostname sql1 -d mcr.microsoft.com/mssql/server:2022-latest

Creating a Database within Docker MSSQL Server

From system's bash terminal:

sudo docker exec -it sql1 "bash"

/opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "MyStr@ngPassw0rd11" -C

Now that you are in SQL cmd prompt:

CREATE DATABASE TestDB;

SELECT Name
FROM sys.databases;

GO

Optional and Other Info:

For adding version control to a new quarto project in general

In bash terminal:

git init -b main 

git add . 

git commit -m "initial commit" 

gh auth login 

gh repo create

Follow instructions on browser popup, or possibly (as an example):

echo "# your_project_repo" >> README.md 

git init 

git add README.md 

git commit -m "first commit" 

Replace username/your_project_repo with your info. Remember to add the .git at the end of the address.

git branch -M main git remote add origin https://github.com/username/your_project_ repo.git 

git push -u origin main