-
Notifications
You must be signed in to change notification settings - Fork 0
Invoke SQLiteTable
Marco van Gaal edited this page May 8, 2015
·
11 revisions
Invoke-SQLiteTable
Bulk insert to SQLite Database
-Connection
Required? true Position? 1 Default value Accept pipeline input? false Accept wildcard characters? false-InputObject
Required? true Position? 2 Default value Accept pipeline input? false Accept wildcard characters? false-Name
Required? false Position? 3 Default value $InputObject.TableName Accept pipeline input? false Accept wildcard characters? false-Update
Required? false Position? 4 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-Progress []
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
None. You cannot pipe objects to Invoke-SQLiteTable.
Work in progress (maybe count of updates/inserts)
-------------------------- EXAMPLE 1 -------------------------- C:\PS>Invoke-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] Inserts or ignores records to database table. -------------------------- EXAMPLE 2 -------------------------- C:\PS>Invoke-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>Invoke-SQLiteTable [-conn] <SQLiteConnection> [-InputObject] <DataTable> [[-Name] <String>] [-Replace] Inserts records or replaces row. -------------------------- EXAMPLE 4 -------------------------- C:\PS>Invoke-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)