What works now

Still to do

Requirements

Example code

Create a new DBHub.io API object

db, err := dbhub.New("YOUR_API_KEY_HERE")if err != nil {    log.Fatal(err)}

Retrieve the list of tables in a remote database

// Run the `Tables()` function on the new API objecttables, err := db.Tables("justinclift", "Join Testing.sqlite", dbhub.Identifier{Branch: "master"})if err != nil {    log.Fatal(err)}// Display the retrieved list of tablesfmt.Println("Tables:")for _, j := range tables {    fmt.Printf("  * %s\n", j)}

Output

Tables:  * table1  * table2

Run a SQL query on a remote database

// Do we want to display BLOBs as base64?showBlobs := false// Run the queryresult, err := db.Query("justinclift", "Join Testing.sqlite",    dbhub.Identifier{ Branch: "master" }, showBlobs,    `SELECT table1.Name, table2.value    FROM table1 JOIN table2    USING (id)    ORDER BY table1.id`)if err != nil {    log.Fatal(err)}fmt.Printf("Query results (JSON):\n\t%v\n", result)fmt.Println()

Output

Query results (JSON):        {[{[Foo 5]} {[Bar 10]} {[Baz 15]} {[Blumph 12.5000]} {[Blargo 8]} {[Batty 3]}]}

Generate and display the difference between two commits of a remote database

// The databases we want to see differences fordb1Owner := "justinclift"db1Name := "Join Testing.sqlite"db1Commit := dbhub.Identifier{    CommitID: "c82ba65add364427e9af3f540be8bf98e8cd6bdb825b07c334858e816c983db0" }db2Owner := ""db2Name := ""db2Commit := dbhub.Identifier{    CommitID: "adf78104254ece17ff40dab80ae800574fa5d429a4869792a64dcf2027cd9cd9" }// Create the diffdiffs, err := db.Diff(db1Owner, db1Name, db1Commit, db2Owner, db2Name, db2Commit,    dbhub.PreservePkMerge)if err != nil {    log.Fatal(err)}// Display the difffmt.Printf("SQL statements for turning the first commit into the second:\n")for _, i := range diffs.Diff {    if i.Schema != nil {        fmt.Printf("%s\n", i.Schema.Sql)    }    for _, j := range i.Data {        fmt.Printf("%s\n", j.Sql)    }}

Output

SQL statements for turning the first commit into the second:CREATE VIEW joinedView ASSELECT table1.Name, table2.valueFROM table1 JOIN table2USING (id)ORDER BY table1.id;

Further examples