Shine Software shinesoftware

## _Magento2_DeleteTestData.md

      
              6 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                shinesoftware
                / _Magento2_DeleteTestData.md
            
            
              Created
              September 8, 2021 14:13
                — forked from leek/_Magento2_DeleteTestData.md
            
              
                Magento 2 - Delete All Test Data
              
          
    These set of scripts are for Magento 2. For Magento 1, see this Gist.

  
## fix-duplicates-product-entity-varchar.php
<?php

$conn = mysqli_connect("HOST", "USER", "PASS", "DATABASE");

if (!$conn) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

## fix-serializer.php
<?php

$conn = mysqli_connect("HOST", "USER", "PASS", "DBNAME");
var_dump($conn->get_charset());

if (!$conn) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;

## CheckPayments.php
<?php

namespace Shinesoftware\Bnl\Cron;

use Shinesoftware\Bnl\Model\Utils;

class CheckPayments
{

    /**

## varnish.vcl
vcl 4.0;

import std;
# The minimal Varnish version is 4.0
# For SSL offloading, pass the following header in your proxy server or load balancer: 'X-Forwarded-Proto: https'

backend default {
    .host = "127.0.0.1";
    .port = "8080";
}

## it_IT.csv

          
            My Support Tickets
            Le Mie Segnalazioni

            
              Create New Ticket
              Nuova Segnalazione

            
              You have not created any support ticket.
              Non hai ancora creato alcuna segnalazione.

            
              Department
              Categoria

            
              Please Select Department
              Seleziona la Categoria

            
              Please Select Priority
              Seleziona la Priorità

            
              Please Select Order Id
              Seleziona il tuo Codice Ordine

            
              Order Id
              Codice Ordine

            
              Add Attachment
              Aggiungi Allegato

            
              Submit Ticket
              Crea Segnalazione

## banca-sella-1.3.0.txt
.
├── app
│   ├── code
│   │   └── local
│   │       └── ShineSoftware
│   │           └── Bancasella
│   │               ├── Block
│   │               │   ├── Adminhtml
│   │               │   │   ├── Bancasella
│   │               │   │   │   ├── Edit

## consorzio-triveneto-2.0.0.2.txt
.
├── app
│   ├── code
│   │   └── community
│   │       └── ShineSoftware
│   │           └── Constriv
│   │               ├── Block
│   │               │   ├── Adminhtml
│   │               │   │   └── System
│   │               │   │       └── Config

## magento2-setup.sh
#!/bin/bash

#title           :magento2-setup.sh
#description     :This script will install Magento from github
#author		 :Shine Software Italy
#date            :20170202
#version         :0.1
#usage		 :Set the execution permission for this file and then call it ./magento2-setup.sh
#notes           :Install Composer and cURL to use this script.

## tax_rules.csv

          
            Code
            Country
            State
            Zip/Post Code
            Rate
            Zip/Post is Range
            Range From
            Range To
            default

            
              10
              IT
              *
              *
              10.0000

            
              10sp
              IT
              *
              *
              10.0000

            
              20
              IT
              *
              *
              20.0000

            
              20d
              IT
              *
              *
              20.0000

            
              20i
              IT
              *
              *
              20.0000

            
              20inUe
              IT
              *
              *
              20.0000

            
              21
              IT
              *
              *
              21.0000

            
              21d
              IT
              *
              *
              21.0000

            
              21exUe
              IT
              *
              *
              21.0000
	<?php

	$conn = mysqli_connect("HOST", "USER", "PASS", "DATABASE");

	if (!$conn) {
	echo "Error: Unable to connect to MySQL." . PHP_EOL;
	echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
	echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
	exit;
	}
	<?php

	$conn = mysqli_connect("HOST", "USER", "PASS", "DBNAME");
	var_dump($conn->get_charset());

	if (!$conn) {
	echo "Error: Unable to connect to MySQL." . PHP_EOL;
	echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
	echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
	exit;
	<?php

	namespace Shinesoftware\Bnl\Cron;

	use Shinesoftware\Bnl\Model\Utils;

	class CheckPayments
	{

	/**
	vcl 4.0;

	import std;
	# The minimal Varnish version is 4.0
	# For SSL offloading, pass the following header in your proxy server or load balancer: 'X-Forwarded-Proto: https'

	backend default {
	.host = "127.0.0.1";
	.port = "8080";
	}
	My Support Tickets	Le Mie Segnalazioni
	Create New Ticket	Nuova Segnalazione
	You have not created any support ticket.	Non hai ancora creato alcuna segnalazione.
	Department	Categoria
	Please Select Department	Seleziona la Categoria
	Please Select Priority	Seleziona la Priorità
	Please Select Order Id	Seleziona il tuo Codice Ordine
	Order Id	Codice Ordine
	Add Attachment	Aggiungi Allegato
	Submit Ticket	Crea Segnalazione
	.
	├── app
	│ ├── code
	│ │ └── local
	│ │ └── ShineSoftware
	│ │ └── Bancasella
	│ │ ├── Block
	│ │ │ ├── Adminhtml
	│ │ │ │ ├── Bancasella
	│ │ │ │ │ ├── Edit
	.
	├── app
	│ ├── code
	│ │ └── community
	│ │ └── ShineSoftware
	│ │ └── Constriv
	│ │ ├── Block
	│ │ │ ├── Adminhtml
	│ │ │ │ └── System
	│ │ │ │ └── Config
	#!/bin/bash

	#title :magento2-setup.sh
	#description :This script will install Magento from github
	#author :Shine Software Italy
	#date :20170202
	#version :0.1
	#usage :Set the execution permission for this file and then call it ./magento2-setup.sh
	#notes :Install Composer and cURL to use this script.
Code	Country	State	Zip/Post Code	Rate	Zip/Post is Range	Range From	Range To	default
10	IT	*	*	10.0000
10sp	IT	*	*	10.0000
20	IT	*	*	20.0000
20d	IT	*	*	20.0000
20i	IT	*	*	20.0000
20inUe	IT	*	*	20.0000
21	IT	*	*	21.0000
21d	IT	*	*	21.0000
21exUe	IT	*	*	21.0000