Connect SQLite

.NAME

Connect-SQLite

.SYNOPSIS

Connect to SQLite Database file

.PARAMETERS

 -Database <String>
     
     Required?                    false
     Position?                    1
     Default value                $(Join-path -Path $MyInvocation.PSScriptRoot -ChildPath "database.db")
     Accept pipeline input?       false
     Accept wildcard characters?  false
     
 
 -Open [<SwitchParameter>]
     
     Required?                    false
     Position?                    named
     Default value                False
     Accept pipeline input?       false
     Accept wildcard characters?  false

.INPUTS

None. You cannot pipe objects to Connect-SQLite

.OUTPUTS

<SQLiteConnection>

.NOTES

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

.EXAMPLES

 -------------------------- EXAMPLE 1 --------------------------

 

 PS C:\>$conn = Connect-SQLite -Database <FilePath>

 

 

 

 

 

 

 

 -------------------------- EXAMPLE 2 --------------------------

 

 PS C:\>$conn = Connect-SQLite -Database <FilePath> -Open

 

 

 PS C:\> $conn

 

 PoolCount         : 0

 ConnectionString  : Data Source = D:\database.db

 DataSource        : database

 Database          : main

 DefaultTimeout    : 30

 ParseViaFramework : False

 Flags             : Default

 DefaultDbType     : 

 DefaultTypeName   : 

 OwnHandle         : True

 ServerVersion     : 3.8.6

 LastInsertRowId   : 0

 Changes           : 0

 AutoCommit        : True

 MemoryUsed        : 69631

 MemoryHighwater   : 69673

 State             : Open

 ConnectionTimeout : 15

 Site              : 

 Container         :

 

 

 

 

 -------------------------- EXAMPLE 3 --------------------------

 

 PS C:\>$conn = Connect-SQLite -Open

 

 

 When run in Script the database file is located in $PSscriptRoot with the name: database.db

 But if you run this from Console the database file is located in $pwd location

 

 

 

 

 -------------------------- EXAMPLE 4 --------------------------

 

 PS C:\>$conn = Connect-SQLite -Database :MEMORY:

 

 

 (creates a SQLite database in memory)

.RELATED LINKS

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