{"t":18,"e":4100000,"r":["Table `examples.games` already exists."],"b":[],"p":[{"duration(ms)":0.343791}]}
if that is the case, that might be something that could be exported all the way to the error itself... it's more comfortable to trust the value of the "e" rather that the message that has higher chance of being updated in the future
The driver spec is missing that field so I completely ignored it haha
If you could create an issue on Github I will make sure it gets added in the next version
@dancannon trying to load http://apps.sfgov.org/datafiles/view.php?file=sfgis/citylots.zip data into rethinkdb using gorethink
package main
import "fmt"
import r "github.com/dancannon/gorethink"
import "encoding/json"
import "io/ioutil"
import "reflect"
func main() {
conn, connErr := r.Connect(r.ConnectOpts{Address: "localhost:21015"})
if connErr != nil {
fmt.Println(connErr)
return
}
data, dataErr := ioutil.ReadFile("/Users/home/Downloads/dataset/citylots.json")
if dataErr != nil {
fmt.Println(dataErr)
return
}
var jsonData map[string]interface{}
unmarshalErr := json.Unmarshal(data, &jsonData)
if unmarshalErr != nil {
fmt.Println(unmarshalErr)
return
}
val := reflect.ValueOf(jsonData["features"])
for i := 0; i < val.Len(); i++ {
_, insertErr := r.DB("tootle").Table("citylots").Insert(val.Index(i).Interface()).Run(conn)
if insertErr != nil {
fmt.Println(insertErr)
return
}
}
}
it ends with following Error
dial tcp: lookup localhost: no such host
Because if I have conflict set to "error" then the err wont be nil.... And I cant determine the failure cause
consider this code:
result, err := r.Table(Table).Insert(org).RunWrite(h.session)
if err != nil {
return httperr.New("could not insert org: "+err.Error(), http.StatusInternalServerError)
}
if result.Inserted == 0 {
return httperr.New("organization already exists", http.StatusConflict)
}
whoops that didnt look pretty
in this code, the Conflict portion will never be reached b/c the error is non-nil... but if i put reverse the checking... I might return a 409-Conflict when I should have returned a 500- internal-server-error
But I am pondering!
Sorry, it's been a heck of a day. Central VA, so tornados and blah. Anyways, if there's an error and a response, can use the counts to see if anything was changed iirc. Or, on failure, do another query to see what's there. Should tell you if there's an error between app and db or the error was due to it existing already
On a side note, freaking tornadoes in Virginia. Eesh
So it seems to me like there should be an explicit way of determining if a conflict has caused the insert to fail...
The only way I see how to check for a conflict is to parse the error message:
Duplicate primary key
id:
Please use #gorethink on the RethinkDB slack from now on. I will be removing the link from the repo shortly
My reasoning behind this change is that notifications in gitter are not great and the slack has got a pretty good community there now. Sorry for any trouble this causes
Anybody who can help with this? GoRethink/gorethink#447
when I return the
It gives me following error
resultIt gives me following error
cannot use result (type *rethinkdb.Cursor) as type int in return argument
My question is how do I get an integer count from above query
I'm sorry if it's a very simple thing