Skip to content
Snippets Groups Projects
akaver's avatar
Andres Käver authored
7295e687

Meeting Planner

Scaffolding

Database

dotnet ef migrations add --project DAL.App.EF --startup-project WebApp --context AppDbContext Initial

dotnet ef migrations remove --project DAL.App.EF --startup-project WebApp --context AppDbContext 

dotnet ef database update --project DAL.App.EF --startup-project WebApp

dotnet ef database drop --project DAL.App.EF --startup-project WebApp

Controllers

NB! Change the slash ("/") in "-outDir Areas/Admin/Controllers" according to your operations system - its "" on windows and "/" on *nix.

cd WebApp
dotnet aspnet-codegenerator controller -name MeetingsController       -actions -m  App.Domain.Meeting    -dc AppDbContext -outDir Areas/Admin/Controllers --useDefaultLayout --useAsyncActions --referenceScriptLibraries -f
dotnet aspnet-codegenerator controller -name MeetingOptionsController       -actions -m  App.Domain.MeetingOption    -dc AppDbContext -outDir Areas/Admin/Controllers --useDefaultLayout --useAsyncActions --referenceScriptLibraries -f
dotnet aspnet-codegenerator controller -name FoosController       -actions -m  App.Domain.Foo    -dc AppDbContext -outDir Areas/Admin/Controllers --useDefaultLayout --useAsyncActions --referenceScriptLibraries -f

DOCKER

MS SQL, works on ARM also.

services:
  mssql-eventor2:
    container_name: "mssql-eventor2"
    image: mcr.microsoft.com/azure-sql-edge:latest
    volumes:
      - mssql-eventor2-volume:/var/opt/mssql
    restart: on-failure
    environment:
      TZ: "Europe/Tallinn"
      ACCEPT_EULA: "Y"
      # regular sql server
      SA_PASSWORD: "Bad.Pass.1"
      # sql edge
      MSSQL_SA_PASSWORD: "Bad.Pass.1"
      MSSQL_PID: Developer
    ports:
      # this maps external:internal, but the docker created network between images is connected directly - using the original ports
      # so use external for connecting with admin tools - docker will forward connection to internal port
      - "1502:1433"

Maria-DB

services:
  mariadb:
    image: mariadb:latest
    ports:
      - 3306:3306
    volumes:
      - "/Users/akaver/Dev/docker-webdev/sql-data:/var/lib/mysql"
    environment:
      TZ: "Europe/Tallinn"
      MYSQL_ALLOW_EMPTY_PASSWORD: "no"
      MYSQL_ROOT_PASSWORD: "Bad.Pass.1"

Git helper - lgit "comment"

> cat .zshrc

export NVM_DIR="$HOME/.nvm"
[ -s "$NVM_DIR/nvm.sh" ] && \. "$NVM_DIR/nvm.sh"  # This loads nvm
[ -s "$NVM_DIR/bash_completion" ] && \. "$NVM_DIR/bash_completion"  # This loads nvm bash_completion


function lgit(){
    git add .
    git commit -a -m "$1"
    git push
}