# ******************************************************
# *
# * Name:         save-fairy-tales-2-blob-storage.ps1
# *     
# * Design Phase:
# *     Author:   John Miner
# *     Date:     08-26-2017
# *     Purpose:  Create one container and load sample
# *               stock data.
# * 
# ******************************************************

# Root name for objects in this script
$root = "tips17"

#
# Azure Subscriptions 
#

# Prompts you for azure credentials
Add-AzureRmAccount

# Clear the screen
Clear-Host

# List my subscriptions
Get-AzureRmSubscription 

# Pick my internal subscription
$SubscriptionId = '26efaaba-5054-4f31-b922-84ab9eff218e'
Set-AzureRmContext -SubscriptionId $SubscriptionId


#
# Create a resource group
#

# New resource group
# New-AzureRmResourceGroup -Name "rg4$root" -Location "East US 2"

# Clear the screen
# Clear-Host

# List resource groups
# Get-AzureRmResourceGroup

# Delete resource group
# Remove-AzureRmResourceGroup -Name "rg4$root" -Force



#
# Create a storage account
#

# Create new storage account (lowercase)
# New-AzureRmStorageAccount –StorageAccountName "sa4$root" -ResourceGroupName "rg4$root" -Location "East US 2" -Type "Standard_GRS"

# Clear the screen
# Clear-Host

# Show the account
# $A = Get-AzureRmStorageAccount 
# $A.Sku
# $A.Type

# Delete storage account
#Remove-AzureRmStorageAccount -ResourceGroupName "rg4$root" -Name "sa4$root"



#
# Create a storage container
#

# Grab storage context - work around for RM
# $StorageContext = Get-AzureRmStorageAccount -Name "sa4$root" -ResourceGroupName "rg4$root" 

# Create new container
# $StorageContext | New-AzureStorageContainer -Name "sc4$root" -Permission Off

# Clear the screen
# Clear-Host

# Show the container
# $StorageContext | Get-AzureStorageContainer 
 
# Remove the container
# $StorageContext | Remove-AzureStorageContainer -Name "sc4$root" -Force



#
# Upload files to azure (fairy tales)
#

# Grab storage context - work around for RM
$StorageContext = Get-AzureRmStorageAccount -Name "sa4$root" -ResourceGroupName "rg4$root" 

# Set source path
$srcpath = "C:\MSSQLTIPS\MINER2017\ARTICLE-2017-08-AZURE-FULL-TEXT-INDEXING\RAW\"

# Set counter
$cnt = 0

# Local file path
$list = Get-ChildItem $srcpath -Filter *.TXT

# For each stock
foreach ($file in $list)
{
    # Source file
    $srcfull = $srcpath + $file.Name

    # Destination blob
    $dstblob = "TALES/" + $file.Name

    # Upload file to azure
    $StorageContext | Set-AzureStorageBlobContent -Container "sc4$root" -Blob $dstblob -File $srcfull -Force

    # Increment count
    $cnt = $cnt + 1

    # Show message
    Write-Host $srcfull
    Write-Host $cnt
}



#
# List all blobs in the container
#

$blob = "TALES/*.TXT"

# List all blobs in a container.
$StorageContext | Get-AzureStorageBlob -Container "sc4$root" -Blob $blob


#
# Download file from azure
#

$StorageContext | Get-AzureStorageBlob -Container "sc4$root" -Blob "TALES/GRIMM-01.TXT" | Get-AzureStorageBlobContent -Destination "c:\temp\"