SimplySql
0.2.1
Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities.
SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done. The basic pattern is to connect to a database, execute one or more sql
SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done. The basic pattern is to connect to a database, execute one or more sql
Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities.
SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done. The basic pattern is to connect to a database, execute one or more sql statements and then close your database connection. This module provides cmdlets that map to this basic pattern.
Information on Providers in the module is supplied by Get-SqlProviderHelp
Open/Close/Show/Test/Set -SqlConnection >> Control as many active connections as you want.
Invoke- SqlScalar/SqlQuery/SqlUpdate >> Interact with those connections.
Get/Clear -SqlMessage >> Get Informational messages, if provider supports it.
Invoke-SqlBulkCopy >> Bulk Dataload from one connection to another.
Start/Complete/Undo -SqlTransaction >> Utilize transactions!
Show more
SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done. The basic pattern is to connect to a database, execute one or more sql statements and then close your database connection. This module provides cmdlets that map to this basic pattern.
Information on Providers in the module is supplied by Get-SqlProviderHelp
Open/Close/Show/Test/Set -SqlConnection >> Control as many active connections as you want.
Invoke- SqlScalar/SqlQuery/SqlUpdate >> Interact with those connections.
Get/Clear -SqlMessage >> Get Informational messages, if provider supports it.
Invoke-SqlBulkCopy >> Bulk Dataload from one connection to another.
Start/Complete/Undo -SqlTransaction >> Utilize transactions!
Minimum PowerShell version
5.0
The owner has unlisted this package.
This could mean that the module is deprecated or shouldn't be used anymore.
Installation Options
Owners
Copyright
(c) 2017 Mithrandyr. All rights reserved.
Package Details
Author(s)
- Mithrandyr
Tags
Functions
Clear-SqlMessage Close-SqlConnection Complete-SqlTransaction Get-SqlMessage Get-SqlProviderHelp Invoke-SqlBulkCopy Invoke-SqlQuery Invoke-SqlScalar Invoke-SqlUpdate Open-SqlConnection Set-SqlConnection Show-SqlConnection Start-SqlTransaction Test-SqlConnection Undo-SqlTransaction
Dependencies
This module has no dependencies.
Release Notes
Initial Publish, Only Supporting Microsoft SQL and SQLite.
FileList
- SimplySql.nuspec
- DataReaderToPSObject.dll
- SimplySql.psd1
- SimplySql.psm1
- Classes\ProviderBase.ps1
- Classes\ProviderConfig.ps1
- Classes\SqlMessage.ps1
- Cmdlets\Clear-SqlMessage.ps1
- Cmdlets\Close-SqlConnection.ps1
- Cmdlets\Complete-SqlTransaction.ps1
- Cmdlets\Get-SqlMessage.ps1
- Cmdlets\Get-SqlProviderHelp.ps1
- Cmdlets\Invoke-SqlBulkCopy.ps1
- Cmdlets\Invoke-SqlQuery.ps1
- Cmdlets\Invoke-SqlScalar.ps1
- Cmdlets\Invoke-SqlUpdate.ps1
- Cmdlets\Open-SqlConnection.ps1
- Cmdlets\Set-SqlConnection.ps1
- Cmdlets\Show-SqlConnection.ps1
- Cmdlets\Start-SqlTransaction.ps1
- Cmdlets\Test-SqlConnection.ps1
- Cmdlets\Undo-SqlTransaction.ps1
- en-US\about_SimplySql.help.txt
- en-US\about_SimplySql_ProviderBase.help.txt
- en-US\about_SimplySql_Providers.help.txt
- Functions\AddDynamicParameterDefaults.ps1
- Functions\CreateMapFunction.ps1
- Functions\CreateParameter.ps1
- Functions\CreateParameterAttribute.ps1
- Functions\ProcessHashTable.ps1
- Functions\TestConnectionName.ps1
- Providers\SQL\sql.ps1
- Providers\SQL\SqlProvider.ps1
- Providers\SQLite\init.ps1
- Providers\SQLite\sqlite.ps1
- Providers\SQLite\SQLiteProvider.ps1
- Providers\SQLite\System.Data.SQLite.dll
- Providers\SQLite\x64\SQLite.Interop.dll
- Providers\SQLite\x86\SQLite.Interop.dll
Version History
Version | Downloads | Last updated |
---|---|---|
2.0.2.70 | 92,966 | 3/2/2024 |
2.0.1.69 | 324 | 3/1/2024 |
2.0.0.67 | 25,198 | 2/9/2024 |
1.9.1 | 660,249 | 1/29/2023 |
1.9.0 | 208,736 | 5/28/2022 |
1.8.0 | 122,584 | 4/2/2021 |
1.7.0 | 4,931 | 2/16/2021 |
1.6.2 | 63,919 | 2/26/2019 |
1.6.1 | 120 | 2/7/2019 |
1.6.0 | 57 | 2/7/2019 |
1.5.9 | 213 | 11/27/2018 |
1.5.4 | 154 | 10/5/2018 |
1.5.2 | 82 | 9/18/2018 |
1.5.1 | 56 | 9/4/2018 |
1.4.1 | 247 | 6/11/2018 |
1.4.0 | 1,249 | 5/16/2018 |
1.3.8 | 50 | 5/11/2018 |
1.3.7 | 41 | 5/9/2018 |
1.3.6 | 95 | 3/24/2018 |
1.3.5 | 41 | 3/22/2018 |
1.3.3 | 60 | 3/19/2018 |
1.3.2 | 120 | 2/12/2018 |
1.3.1 | 36 | 2/12/2018 |
1.3.0 | 37 | 2/12/2018 |
1.2.0 | 92 | 1/8/2018 |
1.1.1 | 98 | 11/30/2017 |