Out SQLiteTable

.NAME

Out-SQLiteTable

.SYNOPSIS

Creates a <SQLiteTable> from an object

.PARAMETERS

 -Connection <SQLiteConnection>
     
     Required?                    true
     Position?                    named
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -InputObject <PSObject[]>
     
     Required?                    true
     Position?                    1
     Default value                
     Accept pipeline input?       true (ByValue)
     Accept wildcard characters?  false
     
 
 -Name <String>
     
     Required?                    false
     Position?                    named
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Update <String>
     
     Required?                    false
     Position?                    named
     Default value                
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Replace [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Whatif [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Force [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false

.INPUTS

<Object[]> or <DataTable>

.OUTPUTS

Success and Error count

.NOTES

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

.EXAMPLES

 -------------------------- EXAMPLE 1 --------------------------
 
 PS C:\><Object> | Out-SQLiteTable [-Connection] <SQLiteConnection> [[-Name] <String>]
 
 
 
 Inserts Object to table from Pipeline
 
 
 
 
 
 -------------------------- EXAMPLE 2 --------------------------
 
 PS C:\>Out-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [[-Update] <Column>]
 
 
 
 Inserts or ignores records then updates row where -Update <Column> = Row.Value
 
 
 
 
 
 -------------------------- EXAMPLE 3 --------------------------
 
 PS C:\>Out-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-Replace]
 
 
 
 Inserts records or replaces row.
 
 
 
 
 
 -------------------------- EXAMPLE 4 --------------------------
 
 PS C:\>Import-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-WhatIf]
 
 
 
 Shows import query, runs the import but rollsback the changes so no changes are made to database. (debug)

.RELATED LINKS

http://www.proxx.nl/Wiki/Out-SQLiteTable