Function init

cli/cmd/sqlcmd.go:62–95

()

}

func init() {
	sqlCli = &cobra.Command{
		Use:   "sqlcmd",
		Short: "exec sql or cmd",
		Long:  sqlcmdmodule.SqlcmdHelpTable(),
		Run:   runSqlcmd,
		Example: `cube sqlcmd -x mysql -l root -p root -e "whoami"
cube sqlcmd -x mysql -l root -p root -e "clear"
cube sqlcmd -x mssql -l sa -p sa -e "whoami" --port 4134
		`,
	}

	sqlCli.Flags().StringP("service", "s", "", "service ip")
	sqlCli.Flags().StringP("login", "l", "", "login user")
	sqlCli.Flags().StringP("password", "p", "", "login password")
	sqlCli.Flags().StringP("query", "e", "", "string to query or exec")
	sqlCli.Flags().StringP("plugin", "x", "", fmt.Sprintf("avaliable plugin: %s", 111))
	sqlCli.Flags().StringP("port", "", "", "if the service is on a different default port, define it here")

	if err := sqlCli.MarkFlagRequired("plugin"); err != nil {
		gologger.Errorf("error on marking flag as required: %v", err)
	}
	if err := sqlCli.MarkFlagRequired("service"); err != nil {
		gologger.Errorf("error on marking flag as required: %v", err)
	}
	if err := sqlCli.MarkFlagRequired("login"); err != nil {
		gologger.Errorf("error on marking flag as required: %v", err)
	}
	if err := sqlCli.MarkFlagRequired("password"); err != nil {
		gologger.Errorf("error on marking flag as required: %v", err)
	}

	rootCmd.AddCommand(sqlCli)
}