Write SQLite

.NAME

Write-SQLite

.SYNOPSIS

Excutes query on the database

.PARAMETERS

 -Connection <SQLiteConnection>
     
     Required?                    true
     Position?                    1
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Query <String>
     
     Required?                    true
     Position?                    2
     Default value                
     Accept pipeline input?       true (ByValue)
     Accept wildcard characters?  false
     
 
 -Whatif [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false

.INPUTS

<String>

.OUTPUTS

<Boolean>

.NOTES

 Author: Proxx
 Web:    www.Proxx.nl 
 Date:    10-06-2015

.EXAMPLES

 -------------------------- EXAMPLE 1 --------------------------
 
 PS C:\>Write-SQLite [-Connection] <SQLiteConnection> [-Query] <String>
 
 
 
 Runs the query on database and return $true or $false
 
 
 
 
 
 -------------------------- EXAMPLE 2 --------------------------
 
 PS C:\>Write-SQLite [-Connection] <SQLiteConnection> [-Query] <String> -Whatif
 
 
 
 Runs the query on database then rollsback the transaction.
 WARNING: Whatif only works with "INSERT, UPDATE, and DELETE"!!!!!!
 
 
 
 
 
 -------------------------- EXAMPLE 3 --------------------------
 
 PS C:\>"INSERT INTO TABLE_NAME (column1, column2, column3,...columnN) VALUES (value1, value2, value3,...valueN);" | Wri
 te-SQLite [-Connection] <SQLiteConnection>

.RELATED LINKS

http://www.proxx.nl/Wiki/Write-SQLite