sqlite连接:
type Database struct {
db sqlbuilder.Database
}
func NewDatabase(cfg *config.Config) (*Database, error) {
// 连接数据库;
db, err := sqlbuilder.Open(sqlite.Adapter, &sqlite.ConnectionURL{
Database: filepath.Join(cfg.DataDir, "dbName.db"),
Options: map[string]string{
"cache": "shared",
// "mode":"memory",
},
})
if err != nil {
return nil, err
}
// db.SetLogging(true)
DB := &Database{db: db}
// 初始化数据库;
if err := DB.init(); err != nil {
return nil, err
}
return DB, nil
}
func (d *Database) DB() sqlbuilder.Database {
return d.db
}