ip75

package psql

import (
	"database/sql"
	"encoding/csv"
	"fmt"
	"io"
	"os"
	"regexp"
	"sync"

ip75

SELECT (regexp_match(m.file_url, '^.+/(.+)$'))[1] FROM media m WHERE m.file_url LIKE 'http%';  


UPDATE media
SET file_url = (regexp_match(file_url, '^.+/(.+)$'))[1]
WHERE file_url LIKE 'http%';

ip75

#!/bin/sh

zone_base_path='/usr/local/etc/nsd/'

update_serial() {

  acme_fqdn=$1
  zone_full_path=$2

  # get serial number

ip75

#!/bin/sh -
#
# $FreeBSD$
#

if [ -r /etc/defaults/periodic.conf ]; then
	. /etc/defaults/periodic.conf
	source_periodic_confs
fi

ip75

format PE64 GUI 5.0

include 'WIN64WX.INC'

section '.data' data readable writeable
  _start        TCHAR 'lets start the game...',0
  _ring0        TCHAR 'We are in ring 0',0
  _system_lstar dq    0

section '.code' code readable executable

ip75

public abstract class BranchNode
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Path { get; set; }
    [NotMapped]
    public string ParentPath
    {
        get
        {

ip75

--- in database of ФИАС get address records recursively until root record

WITH RECURSIVE parent AS
 ( SELECT a.*
   FROM addrobj a
   WHERE a.aoguid = @locality
     AND a.actstatus = 1
   UNION ALL
   SELECT ao.*
   FROM parent p

ip75

-------------------  HIERARCHYID => MERCID ---------------------------
select lpad('  ', 6 * level) || h.displayname as Tree,
       hd.value mercid,
       h.hierarchyid,
       h.authid,
       h.searchkey,
       ad.dataid
  from AUTHHIERARCHY h 
    left join hierarchydata hd
    on hd.hierarchyid = h.hierarchyid

ip75

void Main()
{

  string sDomain = "ad.microsoft.com";
  string sServiceUser = "username";
  string sServicePassword = "account_old_password";
  string sNewServicePassword = "account_new_password";


  var pc = new PrincipalContext(ContextType.Domain, sDomain, sServiceUser, sServicePassword);

ip75

public class Program
{
    static private Queue<long> lifo = new Queue<long>();

    static void walk(object[] root)
    {
        if (root == null) throw new ArgumentNullException(nameof(root));

        foreach (var o in root)
        {