Potato.SQLite

The Potato.SQLite library is a helper class designed to simplify interactions with SQLite databases in .NET applications. It supports database initialization, data manipulation (CRUD operations), and utility functions for SQLite.

Features

• Database Initialization: Automatically creates the SQLite database file if it does not exist.
• CRUD Operations: Provides asynchronous methods to insert, update, delete, and query data.
• Parameterized Queries: Protects against SQL injection.
• Flexible Initialization: Allows for optional configuration of base image URIs.

---

Installation

1. Add the Potato.SQLite class to your project.
2. Ensure you have the System.Data.SQLite NuGet package installed.

dotnet add package System.Data.SQLite

---

Usage

1. Initialize the Helper Class

using Potato.SQLite; // With base image URI var helper = new Helper("C:\\databases", "example.db", new Uri("http://example.com/images")); // Without base image URI var helperWithoutImage = new Helper("C:\\databases", "example.db");

2. Insert Data

Insert a Collection of Rows

var data = new List<Dictionary<string, object>> { new Dictionary<string, object> { { "Name", "Potato" }, { "Type", "Vegetable" } }, new Dictionary<string, object> { { "Name", "Tomato" }, { "Type", "Fruit" } }, }; await helper.InsertDataAsync("Products", data);

Insert Data and Get the Last Inserted ID

int lastId = await helper.InsertReturnDataAsync("Products", data); Console.WriteLine($"Last inserted ID: {lastId}");

---

3. Query Data

Read All Rows from a Table

var rows = await helper.ReadAllDataAsync("Products"); foreach (var row in rows) { Console.WriteLine(string.Join(", ", row.Select(kvp => $"{kvp.Key}: {kvp.Value}"))); }

Read Data with Conditions

var conditions = new Dictionary<string, object> { { "Type", "Vegetable" } }; var rowsWithConditions = await helper.ReadDataAsync("Products", conditions);

---

4. Update Data

Update Rows with Specific Conditions

var updatedValues = new Dictionary<string, object> { { "Name", "Sweet Potato" } }; var conditions = new Dictionary<string, object> { { "Name", "Potato" } }; await helper.UpdateDataAsync("Products", updatedValues, conditions);

---

5. Delete Data

var conditions = new Dictionary<string, object> { { "Name", "Potato" } }; await helper.DeleteDataAsync("Products", conditions);

---

Notes

• Connection Management: The library manages database connections internally. You do not need to explicitly open or close connections.
• Thread Safety: Ensure proper thread synchronization if using the library in multi-threaded applications.
• SQL Injection Prevention: Always use parameterized queries for safe interactions.

---

Contributing

Contributions are welcome! If you encounter a bug or want to add new features, feel free to submit a pull request or file an issue.

---

License

This project is licensed under the MIT License.