function Get-RandomName {
    -join ((65..90) + (97..122) |
        Get-Random -Count (Get-Random -Minimum 4 -Maximum 30) |
        ForEach-Object {
            [char] $_
        })
}



# Query generetor for question 1
$query= [System.Collections.ArrayList]@()

$users = @(5,6,7,8)
$deviceIds=@("aa","bb","cc")
$beforeuser=0
$beforedevice= 0
for($i=0;$i -lt 16;$i++)
{
    for($j=0;$j -lt $users.Length;$j++)
    {
        for($d=0;$d -lt $deviceIds.Length;$d++)
        {
            if((Get-Random -Maximum 3 -Minimum 0) -ne 2)
            {
                $obj = "" | select user,device,Time,content
                $obj.user = $users[$j]
                $obj.device =  $deviceIds[$d]
                $obj.Time = (Get-Date).AddYears(-2).ToString("yyyy-MM-dd hh:mm:ss")
                $obj.content = Get-RandomName

                $query.Add($obj) >> $null

            }
            sleep -Milliseconds 84
        }
    }
    $i
}



# Query generetor for question 3
$users = @(9,10,11,12)
$deviceIds=@("aa","bb","cc")
$beforeuser=0
$beforedevice= 0
for($i=0;$i -lt 60;$i++)
{
    for($j=0;$j -lt $users.Length;$j++)
    {
        for($d=0;$d -lt $deviceIds.Length;$d++)
        {
            #if((Get-Random -Maximum 3 -Minimum 0) -ne 2)
            #{
                $obj = "" | select user,device,Time,content
                $obj.user = $users[$j]
                $obj.device =  $deviceIds[$d]
                $obj.Time = (Get-Date).AddYears(-2).ToString("yyyy-MM-dd hh:mm:ss")
                $obj.content = Get-RandomName

                $query.Add($obj) >> $null

           # }
            sleep -Milliseconds 84
        }
    }
    $i
}



[System.Collections.ArrayList]$query = $query | Sort-Object user,device
$done=$query | %{"($($_.user),'$($_.device)','$($_.Time)','$($_.content)'),"}
$done | Set-Clipboard
Read-Host "העתקתי למקלדת את התוצאות תדביק ואחרי זה תלחץ enter"

#Appearance  generator

$CommercialIDs=@(1,2,3,4,5,6,7)
$websize=@(1,2,3,4)
$applist= [System.Collections.ArrayList]@()


for($i=0;$i -lt $query.Count;$i++)
{
     if((Get-Random -Maximum 2 -Minimum 0) -ne 1)
     {
        $obj = "" | select CommercialID,Size,IP_Address,DeviceID,SubmitTime,WebsiteID
        $obj.CommercialID = $CommercialIDs[(Get-Random -Minimum 0 -Maximum $CommercialIDs.length)]
        $obj.Size = (Get-Random -Minimum 0 -Maximum 500)
        $obj.IP_Address = $query[$i].user
        $obj.DeviceID = $query[$i].device
        $obj.SubmitTime = $query[$i].Time
        $obj.WebsiteID = $websize[(Get-Random -Minimum 0 -Maximum $websize.length)]
        $applist.Add($obj) >> $null
     }
}
$done=$applist | %{"($($_.CommercialID),$($_.Size),$($_.IP_Address),'$($_.DeviceID)','$($_.SubmitTime)',$($_.WebsiteID)),"}
$done | Set-Clipboard
Read-Host "העתקתי למקלדת את התוצאות תדביק ואחרי זה תלחץ enter"