AndyDaSilva52

namespace SeleniumTest
{
    [TestFixture(typeof(FirefoxDriver))]
    [TestFixture(typeof(InternetExplorerDriver))]
    public class BlogTest<TWebDriver> where TWebDriver : IWebDriver, new()
    {
        private IWebDriver _driver;

        [Test]
        public void SearchResults_ShouldHaveCorrectPageTitle()

AndyDaSilva52

#!/usr/bin/env python

# Lastfm loved tracks/playlist to Google Music playlist, either with songs from your library or from all access
# Order of songs in lastfm is preserved.
# First export the lastfm data in a json file, and then import it into Google Music
# You can edit the intermediate json file if you wish.
#
# Based on this script.
# https://gist.github.com/Timmmm/6572592
#

AndyDaSilva52

Sub CreateFolders()
    Dim olNS As NameSpace
    Dim olFolder As Folder
    Dim OlNewFolder As Folder
    Dim olNewFolders As Folders
    Dim olItems As Items
    Dim olItem As MailItem
    Dim strName As String
    Dim i As Long
    

AndyDaSilva52

# Usage:  powershell MSSQLExportSchema.ps1 "SERVERNAME" "DATABASE" "C:\<YourOutputPath>"


# Start Script
#Set-ExecutionPolicy RemoteSigned

# Set-ExecutionPolicy -ExecutionPolicy:Unrestricted -Scope:LocalMachine
function GenerateDBScript([string]$serverName, [string]$dbname, [string]$scriptpath)
{
  [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null

AndyDaSilva52

create or replace TRIGGER T_CLI_EST_MOVTOLOTES_SPACE 
BEFORE INSERT OR UPDATE OF MVL_ST_LOTEFORNE ON MGADM.EST_LOTESMOVIMENTO 
REFERENCING OLD AS OLD NEW AS NEW 
FOR EACH ROW
BEGIN
    BEGIN
    /**
    Quem: AGS (anderson@sanavita.com.br)
    Quando: 27/05/2019
    Motivo: Evitar de permitir inserir Lote com espaço em branco no inicio ou fim do Lote

AndyDaSilva52

create or replace TRIGGER MGCLI.T_CLI_EST_PRODUTOS 
FOR INSERT OR UPDATE ON MGADM.EST_PRODUTOS 
COMPOUND TRIGGER
    
    TYPE TYP_CLI_RC_PRODUTOS IS RECORD(
        PRO_TAB_IN_CODIGO   MGADM.EST_PRODUTOS.PRO_TAB_IN_CODIGO%TYPE,
        PRO_PAD_IN_CODIGO   MGADM.EST_PRODUTOS.PRO_PAD_IN_CODIGO%TYPE,
        PRO_IN_CODIGO       MGADM.EST_PRODUTOS.PRO_IN_CODIGO%TYPE,
        PRO_ST_DESCRICAO    MGADM.EST_PRODUTOS.PRO_ST_DESCRICAO%TYPE
    );

AndyDaSilva52

create or replace TRIGGER MGCLI."T_CLI_EST_RECEBNFE_MANIF" 
BEFORE UPDATE OF RCNF_ST_STATUSMANIFESTACAO, RCNF_ST_STATUSIMPORTA 
    ON MGADM.EST_RECEBIMENTONFE 
REFERENCING OLD AS OLD NEW AS NEW 
FOR EACH ROW
BEGIN
  
  /**
  Status Arquivo NF-e
    Indica o status da importação do arquivo NF-e

AndyDaSilva52

select
    case
        when p.mie_re_qtdebaixatotal <> p.mer_re_quantidade   then
            'SOMA_BX_ITENS_VS_BX_TOTAL_ITEM'
        when nvl(p.mvs_re_quantidade,0)<> p.mie_re_quantdisp then
            'SALDO_CTRL_VS_SALDO_GERAL'
        when p.mie_re_qtdebaixatotal <> p.mer_re_quantidade
             or(p.mvs_re_quantidade)<> p.mie_re_quantdisp then
            'AMBOS'
        else

AndyDaSilva52

Verifying my Blockstack ID is secured with the address 1K66tYTj9PmuNPXaEb2xaKvwfaBuKTTTsn https://explorer.blockstack.org/address/1K66tYTj9PmuNPXaEb2xaKvwfaBuKTTTsn

AndyDaSilva52

create or replace FUNCTION F_VALIDA_CHAVE
(
  pRCB_ST_CHAVEACESSO   IN MGADM.EST_RECEBIMENTO.RCB_ST_CHAVEACESSOCTE%TYPE,
  pUF_ST_SIGLA             IN MGGLO.GLO_AGENTES.UF_ST_SIGLA%TYPE,
  pRCB_DT_DOCUMENTO        IN MGADM.EST_RECEBIMENTO.RCB_DT_DOCUMENTO%TYPE,
  pAGN_ST_CGC              IN MGGLO.GLO_AGENTES.AGN_ST_CGC%TYPE,
  pTDF_IN_CODIGO           IN MGADM.EST_RECEBIMENTO.TDF_IN_CODIGO%TYPE,
  pSER_ST_CODIGO           IN MGADM.EST_RECEBIMENTO.SER_ST_CODIGO%TYPE,
  pRCB_ST_NOTA             IN MGADM.EST_RECEBIMENTO.RCB_ST_NOTA%TYPE 
) RETURN VARCHAR2 AS  -- Retorna 'S' caso seja válido