mdnmdn

version: "3.3"

services:
  portainer:
    image: portainer/portainer-ce:2.19.0
    container_name: portainer
    restart: always 
    labels:
      - "traefik.docker.network=public-web"
      - "traefik.enable=true"

mdnmdn

Mix.install([
  {:postgrex, "~> 0.15.0"}
])

{defmodule MyMod do
  def main do
    {:ok, pid} =
      Tds.start_link(
        hostname: "localhost",
        username: "sa",

mdnmdn

CREATE DOMAIN public.sid AS CHAR(8);

CREATE OR REPLACE FUNCTION cast_uuid_as_sid(uuid)
    RETURNS sid
    LANGUAGE SQL AS
$$ SELECT substr($1::text,1,8)::sid $$;

CREATE OR REPLACE FUNCTION eq_uuid_sid(id1 uuid, id2 sid)
    RETURNS BOOLEAN
    LANGUAGE SQL AS

mdnmdn

function Escape-JSONString($str){
	if ($str -eq $null) {return ""}
	$str = $str.ToString().Replace('"','\"').Replace('\','\\').Replace("`n",'\n').Replace("`r",'\r').Replace("`t",'\t')
	return $str;
}

function ConvertTo-JSON($maxDepth = 4,$forceArray = $false) {
	begin {
		$data = @()
	}

mdnmdn

.grigua-css h1 {
  font-style: italic;
}

mdnmdn

.grigua-css h1 {
  font-style: italic;
}

mdnmdn

.grigua-css h1 {
  font-style: italic;
}

mdnmdn

// npm i mongodb

const { MongoClient } = require('mongodb');

const MONGODB_URI = 'mongodb://localhost:27021/testdata';

let mongoConnection = null;

const getMongo = async () => {
  if (!mongoConnection){

mdnmdn

CREATE LOGIN myUserName WITH PASSWORD = 'pwd';

USE My_Database

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'myUserName')
BEGIN
    CREATE USER [myUserName] FOR LOGIN [myUserName]
    EXEC sp_addrolemember N'db_owner', N'myUserName'
END;

mdnmdn

1. authorize on http.sys: from cmd as admin:
netsh http add urlacl url=http://*:8080/ user=everyone listen=yes
2. open fw port/IISexpress
3. change applicationhost.config:
  ...
  <binding protocol="http" bindingInformation="*:8080:" />
  ...
4. Run IISExpress
  "c:\Program Files (x86)\IIS Express\iisexpress.exe" /config:applicationhost.config