Abarorm

**Release Date:** 2024-11-12

What's New

This release introduces compatibility enhancements across SQLite, PostgreSQL, and MySQL databases, focusing on data type adjustments, constraint handling, and primary key definitions. These improvements ensure consistent behavior across all supported databases.

Key Updates

1. **Primary Key Adjustments**
- Replaced PostgreSQL-specific `SERIAL` with cross-compatible primary key configurations:
- **SQLite**: `INTEGER PRIMARY KEY AUTOINCREMENT`
- **MySQL & PostgreSQL**: Adapted for native auto-increment behaviors.

2. **DecimalField Data Type Changes**
- Standardized `DecimalField` across databases:
- **SQLite**: Uses `REAL` due to precision limitations.
- **PostgreSQL & MySQL**: Maintains precision handling with appropriate constraints.

3. **Improved Constraint Handling**
- Enhanced `NOT NULL` constraint management during table creation to prevent issues, especially in SQLite where constraints can't be altered post-creation.
- Default values added for consistency.

4. **Cross-Database Testing**
- Verified functionality for table creation, data insertion, querying, and filtering across SQLite, PostgreSQL, and MySQL.

Impact

This update enhances stability and performance for projects requiring multi-database support, allowing easy switching between databases without changing model definitions.

For feedback or issues, please refer to Issue 18.

abarorm Version 3.2.0 Release Notes

We are excited to announce the release of abarorm version 3.2.0! This version introduces new features and improvements that enhance the functionality and usability of our Object-Relational Mapping (ORM) library for SQLite, MySQL, and PostgreSQL databases.

New Features

- **Advanced Filtering Options**:
- Introduced new lookup expressions `__gte` (greater than or equal) and `__lte` (less than or equal) for the `filter()` method. This allows for more precise and flexible queries when retrieving records from the database.

Bug Fixes

- Resolved minor issues related to database connections and query execution that enhance overall performance and stability.

Improvements

- Improved documentation with detailed explanations of the filtering functionality, including usage examples for advanced filtering options.
- Enhanced code readability and organization to make it easier for contributors and users to understand the library's structure and functionality.

Upgrade Instructions

To upgrade to version 3.2.0, simply run:

bash
pip install --upgrade abarorm


Make sure to check the [documentation](https://prodbygodfather.github.io/abarorm/) for additional guidance on using the new features and any other changes in this release.

Release Notes: ORM Update Functionality Enhancement

Overview
In this release, we have implemented significant enhancements to the update functionality of the ORM. This update introduces two new methods for updating records, providing users with more flexibility and ease of use.

Key Features

1. **Specific Category Update Method:**
- Users can now update the title of a category by its ID through a dedicated method. This simplifies the process and allows for quick updates without requiring additional parameters.

2. **Flexible Post Update Route:**
- A new API route has been added that enables users to update multiple attributes of a post in a single request. This method accepts optional parameters, allowing for comprehensive updates based on user input.

Benefits
- The new update functionality improves user experience by offering a straightforward method for category updates and a versatile approach for post updates.
- Users can make multiple changes at once, reducing the number of requests needed to update records.

Testing and Validation
All new features have undergone thorough testing to ensure functionality and reliability. We encourage users to explore the new features and provide feedback for further improvements.

Conclusion
This release marks a significant step forward in enhancing the ORM's capabilities, making it easier for users to manage and update their records efficiently. We look forward to your continued support and feedback as we work to improve the ORM further.

Thank you for your contributions and engagement with our project!

What's New
We are excited to announce the release of `abarorm` version 3.0.2! This update brings significant improvements and new features to our lightweight and easy-to-use Object-Relational Mapping (ORM) library for SQLite, MySQL, and PostgreSQL databases.

Key Features
1. **Multi-Database Support**:
- **SQLite**, **MySQL**, and **PostgreSQL** support has been fully implemented.
- The ORM can now seamlessly switch between databases without code changes, making it suitable for various applications.

2. **Enhanced DateField and DateTimeField Handling**:
- Added support for `auto_now` and `auto_now_add` options in `DateField` and `DateTimeField`.
- Automatically set current date and time for fields with these options during record creation and updates.

3. **Robust ForeignKey Management**:
- Improved handling for foreign key relationships.
- Support for both integer IDs and instances of related models when creating records.

4. **Error Handling**:
- Enhanced error messages for better clarity when foreign key relationships are invalid or when related instances are not found.

Bug Fixes
- Addressed several issues related to table naming and query generation to ensure compatibility across all supported databases.

Installation
You can install or upgrade `abarorm` using pip:

bash
pip install abarorm --upgrade


Documentation
For more detailed information on how to use `abarorm`, please refer to our documentation [here](https://prodbygodfather.github.io/abarorm/).

Contributing
We welcome contributions! If you have suggestions or improvements, please open an issue or submit a pull request.

Thank you for using `abarorm`! We appreciate your support and feedback.

Overview
We are excited to announce the release of version 3.0.1 of the abarorm library. This version brings significant enhancements and new features aimed at improving the usability and functionality of the ORM.

New Features
1. **DateField and DateTimeField Support**:
- Added new field types to handle date and time more effectively.
- Introduced options `auto_now` and `auto_now_add` for automatic date and time management.

2. **Improved `create` Method**:
- Updated the method to automatically manage date and time fields during record creation and updates, reducing manual input errors.

3. **Database Schema Update**:
- Updated the database schema to ensure proper storage of timestamps.

Conclusion
This release improves the overall experience for users of the abarorm library, making it easier to manage date and time fields in your models. We encourage you to update to the latest version to take advantage of these new features.

Release Overview
Version 3.0.0 of abarorm brings significant enhancements, crucial bug fixes, and new features aimed at improving the user experience and overall functionality of the ORM library. This release emphasizes better model management and supports a wider range of database operations.

Changes

1. Bug Fixes
- **Table Naming Bug Fix:** Resolved issues with inconsistent table naming conventions, ensuring that table names are now generated correctly based on model class names.
- **Adjusted Return Values:** Improved the return values for various methods in the library, ensuring that users can rely on consistent behavior across CRUD operations.

2. Enhancements
- **Ordering in Filter Method:** The `filter` method now supports ordering results by specified fields, enabling more flexible queries and data retrieval options.
- **Model Management Improvements:** Streamlined the automatic creation and updating of tables based on model definitions, reducing the need for manual table management.

3. New Features
- **Enhanced Foreign Key Support:** Improved handling of foreign key relationships, making it easier for users to interact with related models without running into common pitfalls.
- **Expanded Custom Field Types:** Added new capabilities for defining custom field types, including additional validation and constraints to ensure data integrity.

4. Documentation Updates
- Comprehensive updates to the documentation have been made to reflect the latest changes, providing clear examples and guidelines for effective usage of the abarorm library.

Compatibility
- This version supports Python 3.8 and above and is compatible with SQLite, MySQL, and PostgreSQL databases.

Contribution
- Contributions are highly encouraged! If you encounter any issues or have suggestions for improvements, please feel free to open an issue or submit a pull request on GitHub.

License
- This project is licensed under the Apache-2.0 License.

Thank you for using abarorm, and we look forward to your feedback and contributions!