mongoExport

Documentation

Overview

Package mongoExport 导出mongo里的数据到 xlsx, csv, 或者json文件

Index

• type Client
  • func NewClient(uri, dbName, cltName, userName, password string) (*Client, error)
  • func (c *Client) ToCsv(queryBsonM bson.M, limit int64, fileName string, ...) error
  • func (c *Client) ToExcel(queryBsonM bson.M, limit int64, fileName string, ...) error
  • func (c *Client) ToJson(queryBsonM bson.M, limit int64, fileName string, ...) error

Types

type Client

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

func NewClient

func NewClient(uri, dbName, cltName, userName, password string) (*Client, error)

NewClient uri default 127.0.0.1:27017

func (*Client) ToCsv

func (c *Client) ToCsv(queryBsonM bson.M, limit int64, fileName string, headerS, fieldExclude []string) error

ToCsv To export data from a collection for a CSV file.

headerS 指定 Excel 的字段以及顺序, queryBsonM 过滤条件,可以为nil,代表全部

fieldExclude 排除掉的字段. 当headerS不为空的时候, 该参数失效.

func (*Client) ToExcel

func (c *Client) ToExcel(queryBsonM bson.M, limit int64, fileName string, headerS, fieldExclude []string) error

ToExcel To export data from a collection for a Excel file.

headerS 指定 Excel 的字段以及顺序, queryBsonM 过滤条件,可以为nil,代表全部

fieldExclude 排除掉的字段. 当headerS不为空的时候, 该参数失效.

func (*Client) ToJson

func (c *Client) ToJson(queryBsonM bson.M, limit int64, fileName string, headerS, fieldExclude []string) error

ToJson To export data from a collection for a JSON file.

headerS 指定 Excel 的字段以及顺序, queryBsonM 过滤条件,可以为nil,代表全部

fieldExclude 排除掉的字段. 当headerS不为空的时候, 该参数失效.