package main

import (
	"log"
	"math/rand"

	"upper.io/db.v1"
	"upper.io/db.v1/mysql"
)

type Charbase struct {
	PlatformID     int64  `db:"platformid"`
	ZoneID         int64  `db:"zoneid"`
	AccID          int64  `db:"accid"`
	CharID         int64  `db:"charid"`
	Name           string `db:"name"`
	MapID          int64  `db:"mapid"`
	Gender         int64  `db:"gender"`
	Profession     int64  `db:"profession"`
	DestProfession int64  `db:"destprofession"`
	RoleLv         int64  `db:"rolelv"`
	RoleExp        int64  `db:"roleexp"`
	Charge         int64  `db:"charge"`
	Diamond        int64  `db:"diamond"`
	Silver         int64  `db:"silver"`
	Gold           int64  `db:"gold"`
	CreateTime     int64  `db:"createtime"`
	OnlineTime     int64  `db:"onlinetime"`
	OfflineTime    int64  `db:"offlinetime"`
	Addict         int64  `db:"addict"`
	BattleTime     int64  `db:"battletime"`
	Body           int64  `db:"body"`
	AddictTipsTime int64  `db:"addicttipstime"`
	UserData       []byte `db:"userdata"`
	Package        []byte `db:"package"`
	Quest          []byte `db:"quest"`
	Pet            []byte `db:"pet"`
	Var            []byte `db:"var"`
	Fighter        []byte `db:"fighter"`
	ChatMsg        []byte `db:"chatmsg"`
	UserTower      []byte `db:"usertower"`
	Seal           []byte `db:"seal"`
	Manual         []byte `db:"manual"`
}

var settings = mysql.ConnectionURL{
	Address:  db.HostPort("localhost", 4000),
	Database: "test",
	User:     "root",
	Password: "",
}

const letterBytes = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"

func randBytes(n int) []byte {
	b := make([]byte, n)
	for i := range b {
		b[i] = letterBytes[rand.Intn(len(letterBytes))]
	}
	return b
}

func prepareUser(idFrom int, idTo int) {
	// TODO
}

func randomUpdate(accountID int64, userDataSize int) string {
	// TODO
	return ""
}

func main() {
	sess, err := db.Open(mysql.Adapter, settings)

	if err != nil {
		log.Fatalf("db.Open(): %q\n", err)
	}

	defer sess.Close()

	charbaseCollection, err := sess.Collection("charbase")

	err = charbaseCollection.Truncate()

	if err != nil {
		log.Fatalf("Truncate(): %q\n", err)
	}

	charbaseCollection.Append(&Charbase{
		AccID:    1,
		UserData: []byte("test"),
	})

}