MySQL Powershell Library 0.0.3

Rating: No reviews yet
Downloads: 122
Released: Jun 16, 2014
Updated: Jun 16, 2014 by Avalon77
Dev status: Alpha Help Icon

Recommended Download

Application MySQL Powershell Library Installer
application, 457K, uploaded Jun 16, 2014 - 61 downloads

Other Available Downloads

Source Code MySQL Powershell Library Source
source code, 40K, uploaded Jun 16, 2014 - 61 downloads

Release Notes

This PowerShell Module attempt to provide a convenient method for working with MySQL. It make use of the Oracle MySQL .Net connector version 6.8.3. All the cmdlet are still in a "raw state" this means that you still need some SQL knowledge to use these correctly. The ultimate goal of my Library is to provide cmdlet that doesn't require any SQL syntax knowledge. To achieve this I must implement a lot of checks and also friendly error messages. This is not the case for the moment because at first, I would like to bring as many functionnalities as possible before implementing parameters and parameters association validation.

What was Fixed / Added / Removed ?

-Added 3 ENUM type to ease cmdlet parameter autocompletion
* EnumCharacterSets (Contains the Character Sets like UTF8, CP850, etc...)
* EnumCollationTypes (Contains the Collation types like utf8generalci, cp850generalci, etc...)
* EnumDatatype (Contains all the datatype available in MySQL version xxxx)

- A "Add-MySQLColumn" cmdlet has been created and commented
- A "Add-MySQLColumnForeignKey" cmdlet has been created and commented
- A "Add-MySQLColumnIndex" cmdlet has been created and commented
- A "Clear-MySQLTable" cmdlet has been created and commented
- A "Get-DataTypeCategory" cmdlet has been created and commented
- A "Get-MySQLDeprecatedCommand" cmdlet has been created and commented
- A "Get-MySQLTableIndex" cmdlet has been created and commented
- A "New-MySQLDatabase" cmdlet has been created and commented
- A "New-MySQLTable" cmdlet has been created and commented
- A "Remove-MySQLColumn" cmdlet has been created and commented
- A "Remove-MySQLDatabase" cmdlet has been created and commented
- A "Remove-MySQLRow" cmdlet has been created and commented
- A "Remove-MySQLTable" cmdlet has been created and commented
- A "Use-MySQLDatabase" cmdlet has been created and commented

New-MysqlUpdate has been renamed to Update-MySQLRow and an alias is available for backward compatibility via Get-MySQLDeprecatedCommand
New-MysqlInsert has been renamed to Add-MySQLRow and an alias is available for backward compatibility via Get-MySQLDeprecatedCommand
New-MySQLSelect has been renamed to Get-MySQLRow and an alias is available for backward compatibility via Get-MySQLDeprecatedCommand

- Some small bugs fixes and improvements

REM : Same issue as previous version with Windows x64 systems. The installer pretend to install the module in the System32 folder but in fact the module is installed in the SysWOW64 folder... Sorry about this ! I'll try to fix it as soon as possible !

Reviews for this release

No reviews yet for this release.