example_test.go

package xbase_test

import (
	"fmt"
	"github.com/tsingsun/xbase"
	"time"
)

// ExampleXBase_Create demonstrates how to create a new DBF file using the xbase package.
func ExampleXBase_Create() {
	// Create a new XBase instance
	db, _ := xbase.New()

	// Add fields to the DBF file
	db.AddField("NAME", "C", 30)
	db.AddField("SALARY", "N", 9, 2)
	db.AddField("BDATE", "D")

	// Set the code page
	db.SetCodePage(1251)

	// Create the DBF file
	db.CreateFile("persons.dbf")

	// Always check for errors
	if db.Error() != nil {
		fmt.Println(db.Error())
		return
	}

	// Close the file when done
	defer db.Close()

	// Add a record
	db.Add()
	db.SetFieldValue(1, "John Smith")
	db.SetFieldValue(2, 1234.56)
	db.SetFieldValue(3, time.Date(1998, 2, 20, 0, 0, 0, 0, time.UTC))
	db.Save()

	// Always check for errors
	if db.Error() != nil {
		fmt.Println(db.Error())
	}
}

// ExampleXBase_Read demonstrates how to read a DBF file using the xbase package.
func ExampleXBase_Read() {
	// Open the DBF file
	db, err := xbase.Open("persons.dbf", true)
	if err != nil {
		fmt.Println(err)
		return
	}
	// Always check for errors
	if db.Error() != nil {
		fmt.Println(db.Error())
		return
	}

	// Close the file when done
	defer db.Close()

	// Read the records
	db.First()
	for !db.EOF() {
		name := db.FieldValueAsString(1)
		salary := db.FieldValueAsFloat(2)
		bDate := db.FieldValueAsDate(3)
		fmt.Println(name, salary, bDate)
		db.Next()
	}
}

// ExampleXBase_Append demonstrates how to append a record to a DBF file using the xbase package.
func ExampleXBase_Append() {
	// Open the DBF file
	db, err := xbase.Open("persons.dbf", false)
	if err != nil {
		fmt.Println(err)
		return
	}
	// Always check for errors
	if db.Error() != nil {
		fmt.Println(db.Error())
		return
	}

	// Close the file when done
	defer db.Close()

	// Append a record
	db.Add()
	db.SetFieldValue(1, "John Smith")
	db.SetFieldValue(2, 1234.56)
	db.SetFieldValue(3, time.Date(1998, 2, 20, 0, 0, 0, 0, time.UTC))
	db.Save()

	// Always check for errors
	if db.Error() != nil {
		fmt.Println(db.Error())
	}
}