tidb-example-golang

Outline

It's an example for Golang and TiDB. Contains subproject:

• gorm example
• go-sql-driver/mysql example
• http example

We use different frameworks or libraries to implement similar processes to reflect the solution for connecting to TiDB in different environments

This is a process about the game, each player has two attributes, coins and goods, and each player has their own unique id as an identifier. Players can trade with each other, provided that the coins and goods are sufficient

The process is as follows:

1. Create a player
2. Create some players
3. Read players amount
4. Read some players attributes
5. Two player trade with insufficient coins or goods
6. Two player trade with sufficient coins or goods

Dependency

• Golang SDK
• mycli

gorm example

It's an example used gorm to connect TiDB.

Running way

1. Makefile(recommend)

   • Run make gorm-example

2. Manual

   • Into gorm
   • Run go build -o bin/gorm-example
   • Run ./bin/gorm-example

Expected output

gorm-example expected output

Code

• Demo

go-sql-driver/mysql example

It's an example used go-sql-driver/mysql to connect TiDB.

Running way

1. Makefile(recommend)

   • Run make sql-driver-example

2. Manual

   • Run create table sql in your TiDB
   • Into sqldriver
   • Run go build -o bin/sql-driver-example
   • Run ./bin/sql-driver-example

Expected output

go-sql-driver/mysql expected output

Code

• Initial SQL
• Data Access Functions
• SQL Strings
• Main Entry

http example

It's an example service used gorm to connect TiDB. Provide a group of HTTP Restful interface.

Running way

1. Makefile(recommend)

   1. First terminal
      • Run make http-example
   2. Second terminal
      • Run make request
   3. You can quit first terminal to stop service

2. Manual

   • Into http
   • Run go build -o bin/http
   • Run ./bin/http
   • Request:
     • Option 1 (recommend):
       • Input Request Collection to Postman
       • Request by Postman application
     • Option 2:
       • Using script to request. It's based on curl
     • Option 3:
       • Request HTTP Restful interface by other way

Expected output

1. request expected output
2. service expected output

Code

• Main Entry
• Logic

More Demo

• Transaction
• Batch Delete/Update
• Write Skew