mysqlfetch

README

MySQL Fetch

This activity provides your flogo application the ability to fire a select query to mySQL database and fetch the required data returning it as a JSON string.

Installation

Flogo Web

Use the below link for to install this activity in Flogo Web

https://github.com/Ganitagya/flogo-contrib/activity/mysqlfetch

Flogo CLI

flogo add activity github.com/Ganitagya/flogo-contrib/activity/mysqlfetch

Schema

Inputs and Outputs:

"input":[
   {
      "name": "host",
      "type": "string",
      "required": true
    },
    {
      "name": "username",
      "type": "string",
      "required": true
    },
    {
      "name": "password",
      "type": "string",
      "required": true
    },
    {
      "name": "database",
      "type": "string",
      "required": true
    },
    {
      "name": "query",
      "type": "string",
      "required": true
    }
  ],
  "output": [
    {
      "name": "result",
      "type": "any"
    }
  ]

Settings

Setting	Required	Description
host	True	The hostname of the MySQL server, including the portnumber of the server (like localhost:3306)
username	True	The username to connect to MySQL
password	True	The password to connect to MySQL
database	True	The name of the MySQL database
query	True	The SELECT query you want to execute

Documentation

Index

• func NewActivity(metadata *activity.Metadata) activity.Activity
• type MyActivity
  • func (a *MyActivity) Eval(context activity.Context) (done bool, err error)
  • func (a *MyActivity) Metadata() *activity.Metadata

Functions

func NewActivity

func NewActivity(metadata *activity.Metadata) activity.Activity

NewActivity creates a new AppActivity

Types

type MyActivity

type MyActivity struct {
	// contains filtered or unexported fields
}

MyActivity is a stub for your Activity implementation

func (*MyActivity) Eval

func (a *MyActivity) Eval(context activity.Context) (done bool, err error)

Eval implements activity.Activity.Eval

func (*MyActivity) Metadata

func (a *MyActivity) Metadata() *activity.Metadata

Metadata implements activity.Activity.Metadata