# godbmanager

MySql Manager to handle DB transaction for go project

Start/Stop Service

1. Start Sql manager by calling StartMySqlService(/* pass MySqlConfig Struct Object that holds sql connection details*/)
2. Use defer StopMySqlService()

Handling Database Query Service

 

1. Call GetSqlHandler()
2. The above function will help you perform following
   • Insert - Documentation pending
   • Update - Documentation pending
   • QueryRow
     • sqlHandler := godbmanager.GetSqlHandler()
     • sqlHandler.QueryRow("SELECT name FROM user WHERE id = ?", 1).Scan(&id)
   • AddTransaction - This is when you want to perform bulk transactions
     • sqlHandler := godbmanager.GetSqlHandler()
     • transactionIdOne := sqlHandler.AddTransaction("INSERT INTO user(name) VALUES (?);", "Gonerd")
     • transactionIdTwo := sqlHandler.AddTransaction("INSERT INTO user_detail(id, name) VALUES (?,?);", transactionIdOne, "Gonerd")
     • Above, second transaction is dependent on first transaction id hence we pass transaction id of first transaction
   • PerformTansactions
     • Once we have added transactions by above AddTransactions, We need to call PerformTransactions() to commit
3. Thats it