sqlib

Documentation

Index

• func AddValue(database string, table string, key string, value string)
• func CreateNewDatabase(filename string) error
• func CreateTable(database string, table string, rowlist TableRows) error
• func GetAllFromTable(database string, table string) ([]map[string]interface{}, error)
• func GetFromKey(database string, table string, key string) ([]map[string]interface{}, error)
• func Search(database string, table string, column string, searchstring string) ([]map[string]interface{}, error)
• type TableRows
  • func NewRowsList() TableRows
  • func (r *TableRows) AddRow(name string, datatype string)
  • func (r *TableRows) ToString() string

Functions

func AddValue

func AddValue(database string, table string, key string, value string)

Fügt die Daten in die Rows ein

sqlib.AddValue("TEST", "Person", "name", "Mustermann2")

sqlib.AddValue("TEST", "Person", "vorname", "Paul2")

sqlib.AddValue("TEST", "Person", "age", "582")

func CreateNewDatabase

func CreateNewDatabase(filename string) error

erstellt eine neue Datenbank

Beispiel :

err := sqlib.CreateNewDatabase("TEST")

if err != nil {
	fmt.Println(err.Error())
}

func CreateTable

func CreateTable(database string, table string, rowlist TableRows) error

if err != nil {
	fmt.Println(err.Error())
}

func GetAllFromTable

func GetAllFromTable(database string, table string) ([]map[string]interface{}, error)

holt von allen Rows die Daten

myMap, err := sqlib.GetAllFromTable("TEST", "Person")

if err != nil {
	fmt.Println(err.Error())
}

func GetFromKey

func GetFromKey(database string, table string, key string) ([]map[string]interface{}, error)

holt von einem bestimmten Key die Daten

data, err := sqlib.GetFromKey("TEST", "Person", "name")

if err != nil {
	fmt.Println(err.Error())
}

fmt.Println(data)

func Search

func Search(database string, table string, column string, searchstring string) ([]map[string]interface{}, error)

sucht in einer bestimmten Spalte der Datenbank nach einem Suchbegriff

myMap, err := sqlib.Search("TEST", "Person", "name", "Mustermann")

if err != nil {
	fmt.Println(err.Error())
}

fmt.Println(myMap)

Types

type TableRows

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

func NewRowsList

func NewRowsList() TableRows

func (*TableRows) AddRow

func (r *TableRows) AddRow(name string, datatype string)

func (*TableRows) ToString

func (r *TableRows) ToString() string