第深入了解Golang包的獲取方法目錄1.獲取遠(yuǎn)程包2.應(yīng)用

1.獲取遠(yuǎn)程包

go語言有一個(gè)獲取遠(yuǎn)程包的工具就是goget，目前goget支持多數(shù)開源社區(qū)(例如：github、googlecode、bitbucket、Launchpad)

例如：

goget/astaxie/beedb

在pkg目錄下tree/f可查看到安裝的包如下所示：

2.應(yīng)用

如下代碼所示，可以應(yīng)用遠(yuǎn)程下載的go第三方庫文件，連接sqllite。

鏈接地址

packagemain

import(

"fmt"

"/astaxie/beedb"

_"/mattn/go-sqlite3"

"time"

"database/sql"

CREATETABLE`userinfo`(

`uid`INTEGERPRIMARYKEYAUTOINCREMENT,

`username`VARCHAR(64)NULL,

`departname`VARCHAR(64)NULL,

`created`DATENULL

CREATETABLE`userdeatail`(

`uid`INT(10)NULL,

`intro`TEXTNULL,

`profile`TEXTNULL,

PRIMARYKEY(`uid`)

varormbeedb.Model

typeUserinfostruct{

Uidint`beedb:"PK"`

Usernamestring

Departnamestring

Createdstring

funcmain(){

db,err:=sql.Open("sqlite3","./asta.db")

iferr!=nil{

panic(err)

orm=beedb.New(db)

//insert()

//insertsql()

//a:=selectone()

//fmt.Println(a)

//b:=selectall()

//fmt.Println(b)

//update()

//updatesql()

//findmap()

//groupby()

//jointable()

//delete()

//deletesql()

//deleteall()

funcinsert(){

//savedata

varsaveoneUserinfo

saveone.Username="TestAddUser"

saveone.Departname="TestAddDepartname"

saveone.Created=time.Now().Format("2006-01-0215:04:05")

orm.Save(saveone)

fmt.Println(saveone)

funcinsertsql(){

//addone

add:=make(map[string]interface{})

add["username"]="astaxie"

add["departname"]="clouddevelop"

add["created"]="2012-12-02"

orm.SetTable("userinfo").Insert(add)

funcselectone()Userinfo{

//getoneinfo

varoneUserinfo

orm.Where("uid=",1).Find(one)

returnone

funcselectall()[]Userinfo{

//getalldata

varalluser[]Userinfo

orm.Limit(10).Where("uid",1).FindAll(alluser)

returnalluser

funcupdate(){

////updatedata

varsaveoneUserinfo

saveone.Uid=1

saveone.Username="UpdateUsername"

saveone.Departname="UpdateDepartname"

saveone.Created=time.Now().Format("2006-01-0215:04:05")

orm.Save(saveone)

fmt.Println(saveone)

funcupdatesql(){

//originalSQLupdate

t:=make(map[string]interface{})

t["username"]="updateastaxie"

//updateone

orm.SetTable("userinfo").SetPK("uid").Where(2).Update(t)

//updatebatch

orm.SetTable("userinfo").Where("uid",3).Update(t)

funcfindmap(){

//OriginalSQLBackinforesultsSlice[]map[string][]byte

//defaultPrimaryKeyid

c,_:=orm.SetTable("userinfo").SetPK("uid").Where(2).Select("uid,username").FindMap()

fmt.Println(c)

funcgroupby(){

//OriginalSQLGroupBy

b,_:=orm.SetTable("userinfo").GroupBy("username").Having("username='updateastaxie'").FindMap()

fmt.Println(b)

funcjointable(){

//OriginalSQLJoinTable

a,_:=orm.SetTable("userinfo").Join("LEFT","userdeatail","userinfo.uid=userdeatail.uid").Where("userinfo.uid=",1).Select("userinfo.uid,userinfo.username,file").FindMap()

fmt.Println(a)

funcdelete(){

//////deleteonedata

saveone:=selectone()

orm.Delete(saveone)

funcdeletesql(){

//originalSQ