postgresql

Documentation

Index

• type PostgresqlDatabases
  • func NewPostgresql(s *configurations.Settings) *PostgresqlDatabases
  • func (pg *PostgresqlDatabases) Connect() error
  • func (pg *PostgresqlDatabases) DSN() string
  • func (pg *PostgresqlDatabases) GetColumnsOfTable(table *object_model2.Table) (err error)
  • func (pg *PostgresqlDatabases) GetDriverImportLibrary() string
  • func (pg *PostgresqlDatabases) GetFloatDatatypes() []string
  • func (pg *PostgresqlDatabases) GetIntegerDatatypes() []string
  • func (pg *PostgresqlDatabases) GetStringDatatypes() []string
  • func (pg *PostgresqlDatabases) GetTables() (tables []*object_model2.Table, err error)
  • func (pg *PostgresqlDatabases) GetTemporalDatatypes() []string
  • func (pg *PostgresqlDatabases) GetTemporalDriverDataType() string
  • func (pg *PostgresqlDatabases) GetTextDatatypes() []string
  • func (pg *PostgresqlDatabases) IsAutoIncrement(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) IsFloat(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) IsInteger(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) IsPrimaryKey(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) IsString(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) IsTemporal(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) IsText(column object_model2.Column) bool
  • func (pg *PostgresqlDatabases) PrepareGetColumnsOfTableStmt() (err error)

Types

type PostgresqlDatabases

type PostgresqlDatabases struct {
	*contract.GeneralDatabases

	Host         string
	Port         int
	User         string
	Password     string
	DatabaseName string
	DriverName   string
	// contains filtered or unexported fields
}

func NewPostgresql

func NewPostgresql(s *configurations.Settings) *PostgresqlDatabases

func (*PostgresqlDatabases) Connect

func (pg *PostgresqlDatabases) Connect() error

Connect connects to the database_i_o_service by the given data source name (dsn) of the concrete database_i_o_service

func (*PostgresqlDatabases) DSN

func (pg *PostgresqlDatabases) DSN() string

DSN creates the DSN String to connect to this database_i_o_service

func (*PostgresqlDatabases) GetColumnsOfTable

func (pg *PostgresqlDatabases) GetColumnsOfTable(table *object_model2.Table) (err error)

GetColumnsOfTable executes the statement for retrieving the columns of a specific table in a given schema

func (*PostgresqlDatabases) GetDriverImportLibrary

func (pg *PostgresqlDatabases) GetDriverImportLibrary() string

GetDriverImportLibrary returns the golang sql driver specific fot the MySQL database_i_o_service

func (*PostgresqlDatabases) GetFloatDatatypes

func (pg *PostgresqlDatabases) GetFloatDatatypes() []string

GetFloatDatatypes returns the float datatypes for the postgre database_i_o_service

func (*PostgresqlDatabases) GetIntegerDatatypes

func (pg *PostgresqlDatabases) GetIntegerDatatypes() []string

GetIntegerDatatypes returns the integer datatypes for the postgre database_i_o_service

func (*PostgresqlDatabases) GetStringDatatypes

func (pg *PostgresqlDatabases) GetStringDatatypes() []string

GetStringDatatypes returns the string datatypes for the postgre database_i_o_service

func (*PostgresqlDatabases) GetTables

func (pg *PostgresqlDatabases) GetTables() (
	tables []*object_model2.Table,
	err error)

GetTables gets all tables for a given schema by name

func (*PostgresqlDatabases) GetTemporalDatatypes

func (pg *PostgresqlDatabases) GetTemporalDatatypes() []string

GetTemporalDatatypes returns the temporal datatypes for the postgre database_i_o_service

func (*PostgresqlDatabases) GetTemporalDriverDataType

func (pg *PostgresqlDatabases) GetTemporalDriverDataType() string

GetTemporalDriverDataType returns the time data type specific for the postgre database_i_o_service

func (*PostgresqlDatabases) GetTextDatatypes

func (pg *PostgresqlDatabases) GetTextDatatypes() []string

GetTextDatatypes returns the text datatypes for the postgre database_i_o_service

func (*PostgresqlDatabases) IsAutoIncrement

func (pg *PostgresqlDatabases) IsAutoIncrement(column object_model2.Column) bool

IsAutoIncrement checks if column is a serial column

func (*PostgresqlDatabases) IsFloat

func (pg *PostgresqlDatabases) IsFloat(column object_model2.Column) bool

IsFloat returns true if colum is of type float for the postgre database_i_o_service

func (*PostgresqlDatabases) IsInteger

func (pg *PostgresqlDatabases) IsInteger(column object_model2.Column) bool

IsInteger returns true if colum is of type integer for the postgre database_i_o_service

func (*PostgresqlDatabases) IsPrimaryKey

func (pg *PostgresqlDatabases) IsPrimaryKey(column object_model2.Column) bool

IsPrimaryKey checks if column belongs to primary key

func (*PostgresqlDatabases) IsString

func (pg *PostgresqlDatabases) IsString(column object_model2.Column) bool

IsString returns true if colum is of type string for the postgre database_i_o_service

func (*PostgresqlDatabases) IsTemporal

func (pg *PostgresqlDatabases) IsTemporal(column object_model2.Column) bool

IsTemporal returns true if colum is of type temporal for the postgre database_i_o_service

func (*PostgresqlDatabases) IsText

func (pg *PostgresqlDatabases) IsText(column object_model2.Column) bool

IsText returns true if colum is of type text for the postgre database_i_o_service

func (*PostgresqlDatabases) PrepareGetColumnsOfTableStmt

func (pg *PostgresqlDatabases) PrepareGetColumnsOfTableStmt() (err error)

PrepareGetColumnsOfTableStmt prepares the statement for retrieving the columns of a specific table for a given database_i_o_service