# README
Mongo
Mongo is a library to wrap Mongo Driver with these purposes:
Simplified Database Operations
- Simplify common database operations, such as CRUD (Create, Read, Update, Delete) operations, transactions, and batch processing
Reduced Boilerplate Code
- Reduce boilerplate code associated with database interactions, allowing developers to focus more on application logic rather than low-level database handling
- In this go-mongo-sample, you can see we can reduce a lot of source code at data access layer, or you use generic repository to replace all repository source code.
Some advantage features
Generic CRUD Repository
Repository is like CrudRepository of Spring, it provides these advantages:
- Simplicity: provides a set of standard CRUD (Create, Read, Update, Delete) operations out of the box, reducing the amount of boilerplate code developers need to write.
- Especially, it provides "Save" method, to build an insert or update statement, specified for Oracle, MySQL, MS SQL, Postgres, SQLite.
- Consistency: By using Repository, the code follows a consistent pattern for data access across the application, making it easier to understand and maintain.
- Rapid Development: reducing boilerplate code and ensuring transactional integrity.
- Flexibility: offers flexibility and control over complex queries, because it uses "database/sql" at GO SDK level.
- Type Safety: being a generic interface, it provides type-safe access to the entity objects, reducing the chances of runtime errors.
- Learning Curve: it supports utilities at GO SDK level. So, a developer who works with Mongo Driver can quickly understand and use it.
- Conclusion: The Repository offers a straightforward way to implement basic CRUD operations, promoting rapid development and consistency across applications. While it provides many advantages, such as reducing boilerplate code, it also it also offers flexibility and control over complex queries, because it uses Mongo Driver level.
- Samples: The sample is at go-mongo-generic-sample.
Filtering, Pagination and Sorting
- Filtering is the process of narrowing down a dataset based on specific criteria or conditions. This allows users to refine the results to match their needs, making it easier to find relevant data.
- Pagination is the process of dividing a large dataset into smaller pages. Key Concepts of Pagination:
- Page Size: The number of items displayed on each page.
- Example: If you have 100 items and a page size of 10, there will be 10 pages in total.
- Page Number: The current page being viewed.
- Example: If you are on page 3 with a page size of 10, items 21 to 30 will be displayed.
- Offset and Limit:
- Offset: The number of items to skip before starting to collect the result set.
- Limit: The maximum number of items to return.
- Example: For page 3 with a page size of 10, the offset would be 20, and the limit would be 10 (SELECT * FROM items LIMIT 10 OFFSET 20).
- Page Size: The number of items displayed on each page.
- Sorting: build a dynamic SQL with sorting:
- Build multi-column sorting based on dynamic parameters:
- Input: sort=phone,-id,username,-dateOfBirth
- Output: order by phone, id desc, username, date_of_birth desc
- You can define your own format, and inject your own function to map
- Safe and Secure Input Handling
- See the above output, you can see we map JSON field name to database column name: username with username, dateOfBirth with date_of_birth
- If you pass the columns which does not exist, the library ignore these columns.
- Build multi-column sorting based on dynamic parameters:
Search Repository
Provide built-in support for pagination and filtering, making it easy to handle large datasets without writing additional code. The flow for search/paging:
- Build the dynamic filter
- Query data and map to array of struct
- Count the total of records for paging
Dynamic query builder
For batch job
- Inserter
- Updater
- Writer
- StreamInserter
- StreamUpdater
- StreamWriter
- BatchInserter
- BatchUpdater
- BatchWriter
Geo Point Mapper
- Map latitude and longitude to mongo geo point
Export Service to export data
- Sample is at go-mongo-export
Mongo Health Check
- Sample is at go-mongo-sample
Passcode Adapter
Activity Log
- Save Activity Log with dynamic database design
Field Loader
Installation
Please make sure to initialize a Go module before installing core-go/mongo:
go get -u github.com/core-go/mongo
Import:
import "github.com/core-go/mongo"
# Packages
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
# Functions
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
For Patch.
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
No description provided by the author
# Structs
No description provided by the author