Features

Install

$go get github.com/noborus/tbln

Example

Write example

package mainimport ("os""github.com/noborus/tbln")funcmain() {tb:=tbln.NewTBLN()tb.SetTableName("sample")tb.SetNames([]string{"id","name"})tb.SetTypes([]string{"int","text"})tb.AddRows([]string{"1","Bob"})tb.AddRows([]string{"2","Alice"})tbln.WriteAll(os.Stdout,tb)}

; TableName: sample; created_at: 2019-04-06T01:05:17+09:00; name: | id | name |; type: | int | text || 1 | Bob || 1 | Alice |

Read example

package mainimport ("log""os""github.com/noborus/tbln")funcmain() {iflen(os.Args)<=1 {log.Fatal("Requires tbln file")}file,err:=os.Open(os.Args[1])iferr!=nil {log.Fatal(err)}at,err:=tbln.ReadAll(file)iferr!=nil {log.Fatal(err)}at.SetTableName("newtable")err=tbln.WriteAll(os.Stdout,at)iferr!=nil {log.Fatal(err)}}

TBLN files can be imported and exported into the database.

# \d sample               Table "public.sample" Column |  Type   | Collation | Nullable | Default--------+---------+-----------+----------+--------- id     | integer |           |          | name   | text    |           |          |

; TableName: sample; character_octet_length: |  | 1073741824 |; created_at: 2019-04-06T02:03:43+09:00; is_nullable: | YES | YES |; numeric_precision: | 32 |  |; numeric_precision_radix: | 2 |  |; numeric_scale: | 0 |  |; postgres_type: | integer | text |; Signature: | test | ED25519 | 6271909d82000c4f686785cf0f9080971470ad3247b091ca50f6ea12ccc96efde0e1ca77e16723ef0f9d781941dfb92bed094dbf2e4079dd25f5aa9f9f1aab01 |; Hash: | sha256 | 65f7ce4e15ddc006153fe769b8f328c466cbd1dea4b15aa195ed63daf093668d |; name: | id | name |; type: | int | text || 1 | Bob || 1 | Alice |