-
Notifications
You must be signed in to change notification settings - Fork 0
Out SQLiteTable
Marco van Gaal edited this page May 8, 2015
·
11 revisions
Out-SQLiteTable
Creates a from an object
-Connection
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
Required? false Position? named Default value Accept pipeline input? false Accept wildcard characters? false-Update
Required? false Position? named Default value Accept pipeline input? false Accept wildcard characters? false-Replace []
Required? false Position? named Default value False Accept pipeline input? false Accept wildcard characters? false-Whatif []
Required? false Position? named Default value False Accept pipeline input? false Accept wildcard characters? false
<Object[]> or
Success and Error count
-------------------------- EXAMPLE 1 -------------------------- C:\PS><Object> | Out-SQLiteTable [-Connection] <SQLiteConnection> [[-Name] <String>] Inserts Object to table from Pipeline -------------------------- EXAMPLE 2 -------------------------- C:\PS>Out-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [[-Update] <Column>] Inserts or ignores records then updates row where -Update <Column> = Row.Value -------------------------- EXAMPLE 3 -------------------------- C:\PS>Out-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-Replace] Inserts records or replaces row. -------------------------- EXAMPLE 4 -------------------------- C:\PS>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)