rivsh77

# Variables
SAW_PROTO='http'
SAW_SERVER='myobieeserver.foo.com'
SAW_PORT=7780
BI_USER='Prodney'
BI_PW='Admin123'
# Libraries
import requests, re

try:

rivsh77

#!/usr/bin/env python
# coding: utf-8

# In[301]:


import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
import re

rivsh77

1)
select tr.txn_amount * rt.ccy_rate
  from transactions tr, rates rt
 where     rt.ccy_code = 840
       and rt.report_date = (select max (rts.report_date)
                               from rates rts
                              where rts.report_date <= tr.report_date)

2)
select ll.*, kk.vsp_number last_vsp

rivsh77

#!/bin/bash
deb_pkg_name=$1 #получить имя пакета
apt-cache rdepends $deb_pkg_name > /tmp/list_dep.txt
while read LINE; 
do 
  if [[ $LINE != $deb_pkg_name && $LINE != "Reverse Depends:" ]]; then
  echo "sudo apt-get install $LINE" ; 
  fi
done <  /tmp/list_dep.txt

rivsh77

http {
    upstream example {
        server localhost:8222;
    }

    server {
        listen 80;
        server_name subdomain.example.com/path;
        rewrite ^ http://example.com/subdomain/path$request_uri? permanent;
        location / {

rivsh77

^((8|\+\d{1,5})[\- ]?)?(\(?\d{3}\)?[\- ]?)?[\d\- ]{7,12}$