Method GetAccountByNumber

database/account.go:298–325

GetAccountByNumber retrieves an account based on its number. It queries the database for an account with the given number and returns the account details if found. Parameters: - number: The account number to search for. Returns: - A pointer to the Account object if found, or an error if the account

(number string)

// Returns:
// - A pointer to the Account object if found, or an error if the account is not found or a query error occurs.
func (d Datasource) GetAccountByNumber(number string) (*model.Account, error) {
	// Query the database for the account with the given number
	row := d.Conn.QueryRowContext(context.Background(), `
		SELECT account_id, name, number, bank_name, created_at, meta_data 
		FROM ledgerforge.accounts WHERE number = $1
	`, number)

	account := &model.Account{}
	var metaDataJSON []byte

	// Scan the result into the Account object
	err := row.Scan(&account.AccountID, &account.Name, &account.Number, &account.BankName, &account.CreatedAt, &metaDataJSON)
	if err != nil {
		if err == sql.ErrNoRows {
			return nil, fmt.Errorf("account with number '%s' not found", number)
		}
		return nil, err
	}

	// Unmarshal the metadata JSON into the MetaData field
	err = json.Unmarshal(metaDataJSON, &account.MetaData)
	if err != nil {
		return nil, err
	}

	// Return the account object
	return account, nil
}

// UpdateAccount updates a specific account in the database.
// It updates the account's name, number, bank name, and metadata based on the account ID.