Write-ObjectToSQL

1.13

Write-ObjectToSQL.psd1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
                                #

# Module manifest for module 'Write-ObjectToSQL'

#

# Generated by: John Roos

#

# Generated on: 2017-02-11

#

@{

# Script module or binary module file associated with this manifest.

RootModule = 'Write-ObjectToSQL'

# Version number of this module.

ModuleVersion = '1.13'

# ID used to uniquely identify this module

GUID = '4079b2c3-6522-44b7-bfa9-b0ee9a8b21d5'

# Author of this module

Author = 'John Roos'

# Company or vendor of this module

# CompanyName = 'Unknown'

# Copyright statement for this module

Copyright = '(c) 2017 John Roos. All rights reserved.'

# Description of the functionality provided by this module

Description = 'Writes the properties of an object into a database table. The table will be created if it doesnt exist.'

# Minimum version of the Windows PowerShell engine required by this module

PowerShellVersion = '4.0'

# Name of the Windows PowerShell host required by this module

# PowerShellHostName = ''

# Minimum version of the Windows PowerShell host required by this module

# PowerShellHostVersion = ''

# Minimum version of Microsoft .NET Framework required by this module

# DotNetFrameworkVersion = ''

# Minimum version of the common language runtime (CLR) required by this module

# CLRVersion = ''

# Processor architecture (None, X86, Amd64) required by this module

# ProcessorArchitecture = ''

# Modules that must be imported into the global environment prior to importing this module

# RequiredModules = @()

# Assemblies that must be loaded prior to importing this module

# RequiredAssemblies = @()

# Script files (.ps1) that are run in the caller's environment prior to importing this module.

# ScriptsToProcess = @()

# Type files (.ps1xml) to be loaded when importing this module

# TypesToProcess = @()

# Format files (.ps1xml) to be loaded when importing this module

# FormatsToProcess = @()

# Modules to import as nested modules of the module specified in RootModule/ModuleToProcess

# NestedModules = @()

# Functions to export from this module

FunctionsToExport = 'Write-ObjectToSQL'

# Cmdlets to export from this module

CmdletsToExport = 'Write-ObjectToSQL'

# Variables to export from this module

# VariablesToExport = '*'

# Aliases to export from this module

# AliasesToExport = '*'

# DSC resources to export from this module

# DscResourcesToExport = @()

# List of all modules packaged with this module

# ModuleList = @()

# List of all files packaged with this module

FileList = 'Write-ObjectToSQL.psm1'

# Private data to pass to the module specified in RootModule/ModuleToProcess. This may also contain a PSData hashtable with additional module metadata used by PowerShell.

PrivateData = @{

    PSData = @{

        # Tags applied to this module. These help with module discovery in online galleries.

        Tags =  @('Database', 'SQLServer', 'Object')

        # A URL to the license for this module.

        # LicenseUri = ''

        # A URL to the main website for this project.

        ProjectUri = 'https://github.com/JohnRoos/PowerShell/tree/master/Modules/Write-ObjectToSQL'

        # A URL to an icon representing this module.

        # IconUri = ''

        # ReleaseNotes of this module

        ReleaseNotes = 'Added logic to handle System.Nullable data types (thanks to beanska on GitHub for adding this)

Improved the GUID support to use uniqueidentifier when creating the table

Added the optional parameter PrimaryKey (thanks to lw-schick on GitHub for this idea)

When PrimaryKey is used, that column will be set to NOT NULL when creating the table

Added the SchemaName parameter to select which schema the table should have (thanks to lw-schick on GitHub for adding this)

Fixed a bug where zeroes were sometimes treated as null values (thanks to acheung456 in GitHub for reporting this)'

    } # End of PSData hashtable

} # End of PrivateData hashtable

# HelpInfo URI of this module

# HelpInfoURI = ''

# Default prefix for commands exported from this module. Override the default prefix using Import-Module -Prefix.

# DefaultCommandPrefix = ''

}