Stop Web Crawlers update API
Switch branches/tags
Nothing to show
Clone or download
Failed to load latest commit information.
src previous commit error Feb 16, 2018
.gitignore removed .vscode Apr 7, 2017
LICENSE Initial commit Apr 7, 2017 added bacic insert referrer functionality Feb 3, 2018

Stop Web Crawlers Web Update API

A web API to enable updates the Stop Web Crawlers WordPress Plugin referer spam list


We'll make use of MS SQL in a Docker container for the Database server

Run the SQL Server Docker image on Linux, Mac, or Windows

Download the docker image

       sudo docker pull microsoft/mssql-server-linux

run docker image - we've set up a standard SA password

       docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=P@ssw0rd12' -p 1433:1433 -d microsoft/mssql-server-linux

Upgrade docker

      sudo docker pull microsoft/mssql-server-linux:latest

Connect and Query

     sqlcmd -S localhost -U SA -P P@ssw0rd12 

Check Database exists

SELECT Name from sys.Databases;

Stop Docker Container

      docker container [container id]

Development DB Connection String

For development purposes set the appsettings.Development.json to

"ConnectionStrings": {
    "PortalDB": "Data Source=localhost;Initial Catalog=portal;User Id=sa;Password=P@ssw0rd12;Integrated Security=false;MultipleActiveResultSets=True;"

This is will make use of the Docker DB

threenine logo