snail 1.1.0

A library inspired by Spring Boot's JPA that facilitates SQLite database management in Flutter/Dart applications.

🐌 Snail: A Simple ORM-like Library for Flutter/Dart 🐦

Snail is a library inspired by Spring Boot's JPA, designed to simplify SQLite database management in Flutter/Dart applications. Easy to use like a snail 🐌 (but as functional as a rocket 🚀)!

✨ Features

• ✅ Create, Read, Update, Delete (CRUD) operations.
• 🔍 Dynamic query methods based on method naming conventions.
• 🛠️ Table creation based on field definitions.
• 🔄 Automatic mapping of entities to database rows and vice versa.
• 🔗 Support for snake_case and camelCase conversions.

📥 Installation

Add the following dependency to your pubspec.yaml:

dependencies:
  snail: ^1.1.0

🚀 Getting Started

🏗️ Creating a Repository

To create a repository for your model, extend the SnailRepository class:

import 'package:snail/snail.dart';

class UserRepository extends SnailRepository<User, int> {
  UserRepository() : super(
    tableName: 'users',
    primaryKeyColumn: 'id',
    defineFields: {
      'id': int,
      'name': String,
      'email': String,
      'isActive': bool,
    },
  );

  @override
  Map<String, dynamic> toMap(User entity) => {
        'id': entity.id,
        'name': entity.name,
        'email': entity.email,
        'isActive': entity.isActive,
      };

  @override
  User fromMap(Map<String, dynamic> map) => User(
        id: map['id'],
        name: map['name'],
        email: map['email'],
        isActive: map['isActive'],
      );
}

class User {
  final int id;
  final String name;
  final String email;
  final bool isActive;

  User({required this.id, required this.name, required this.email, required this.isActive});
}

⚡ Using the Repository

void main() async {
  final userRepository = UserRepository();

  // Save a user
  await userRepository.save(User(id: 1, name: 'John Doe', email: '[e-mail]', isActive: true));

  // Find a user by ID
  final user = await userRepository.findById(1);

  // Find all users
  final users = await userRepository.findAll();

  // Delete a user
  await userRepository.deleteById(1);
}

🛠️ Dynamic Methods

The dynamicMethod allows constructing SQL queries based on the method naming. The naming structure should follow standard conventions:

🧱 Naming Structure

• Prefixes: find or findAll
• Connectors: And, Or
• Operators: Between, LessThan, GreaterThan, Like, StartingWith, EndingWith, Containing, In, NotIn, OrderBy, True, False, IsNull, NotNull

📋 Example Naming Conventions

findByTitle(String title);
findById(int id);
findByTitleAndDescription(String title, String description);
findByTitleOrDescription(String title, String description);
findByTitleStartingWith(String title);
findByTitleEndingWith(String title);
findByTitleContaining(String title);
findByIdLessThan(int id);
findByIdGreaterThan(int id);
findByDateBetween(DateTime startDate, DateTime endDate);
findByTitleStartingWithAndIdLessThan(String title, int id);
findByTitleContainingOrDescriptionLike(String title, String description);
findByIdIn(List<int> ids);
findByIdNotIn(List<int> ids);
findByTitleOrderByDate(String title);
findByTitleOrderByDateDesc(String title);
findByTitleAndDescriptionOrderByDate(String title, String description);
findByIsActiveTrue();
findByIsActiveFalse();
findByTitleIsNull();
findByTitleNotNull();

🛠️ Usage Example

Future<List<User>> findByTitleStartingWith(String title) {
  return dynamicMethod('findByTitleStartingWith', [title]);
}

🔄 CRUD Operations

💾 Save or Update an Entity

Future<int> save(T entity);

💾 Save or Update Multiple Entities

Future<List<int>> saveAll(List<T> entities);

🔍 Find an Entity by ID

Future<T?> findById(ID id);

🔍 Find All Entities

Future<List<T>> findAll();

❌ Delete an Entity by ID

Future<int> deleteById(ID id);

❌ Delete All Entities

Future<int> deleteAll(List<T>? entities);

📊 Count Entities

Future<int> count();

🤝 Contributing

Feel free to fork this repository and contribute by submitting a pull request. 🛠️

📜 License

This project is licensed under the MIT License. 📄

---

Made with ❤️ for Flutter developers! 🎯