-
Notifications
You must be signed in to change notification settings - Fork 0
Out SQLiteTable
Out-SQLiteTable
Creates a <SQLiteTable> 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 <DataTable>
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)