Function TestCreateAccount_Success

database/account_test.go:15–45

(t *testing.T)

)

func TestCreateAccount_Success(t *testing.T) {
	db, mock, err := sqlmock.New()
	assert.NoError(t, err)
	defer func() { _ = db.Close() }()

	ds := Datasource{Conn: db}

	account := model.Account{
		Name:       "Test Account",
		Number:     "1234567890",
		BankName:   "Test Bank",
		Currency:   "USD",
		LedgerID:   "ldg1",
		IdentityID: "idt1",
		BalanceID:  "bal1",
		MetaData: map[string]interface{}{
			"key": "value",
		},
	}

	metaDataJSON, err := json.Marshal(account.MetaData)
	assert.NoError(t, err)

	mock.ExpectExec("INSERT INTO ledgerforge.accounts").
		WithArgs(sqlmock.AnyArg(), account.Name, account.Number, account.BankName, account.Currency, account.LedgerID, account.IdentityID, account.BalanceID, sqlmock.AnyArg(), metaDataJSON).
		WillReturnResult(sqlmock.NewResult(1, 1))

	createdAccount, err := ds.CreateAccount(account)
	assert.NoError(t, err)
	assert.NotEmpty(t, createdAccount.AccountID)
}

func TestGetAccountByID_Success(t *testing.T) {
	db, mock, err := sqlmock.New()