Skip to content

Latest commit

 

History

History
83 lines (62 loc) · 1.79 KB

README.md

File metadata and controls

83 lines (62 loc) · 1.79 KB

CSV Database Library

A simple CSV database library for Dart, providing basic query operations.

Features

  • Supports CSV file storage and retrieval
  • Provides query operations for searching by string and integer values
  • Supports various query operators: EQ, NE, GT, GTE, LT, LTE
  • Supports creating, dropping, inserting, and selecting data

Usage

To use this library, create a CsvDb object with the path to your CSV file:

var db = CsvDb(filePath: 'databases/library_db.csv');

You can then use the various methods to perform operations on the database:

Create Create a new CSV database file:

await db.create(dataModel: [...]); 

Drop Delete the CSV database file:

await db.drop();

Insert Insert new data into the CSV database:

await db.insert(data: DbModel(...));

Select All Retrieve all data from the CSV database:

var data = await db.selectAll();

Select Where Retrieve data from the CSV database based on a query:

var data = await db.selectWhere(
  columnName: 'fatherName',
  targetValue: 'fn1',
  operation: QueryOps.eq,
);

Query Operations The library supports the following query operations:

EQ: Equal to NE: Not equal to GT: Greater than GTE: Greater than or equal to LT: Less than LTE: Less than or equal to Data Model The library uses a DbModel class to represent the data to be inserted into the database. You can create a new DbModel object and pass it to the insert method:

var data = DbModel(...);
await db.insert(data: data);

Testing The library includes a comprehensive test suite to ensure its functionality.

Contributing Contributions are welcome! If you'd like to contribute to this library, please fork the repository and submit a pull request.

License This library is licensed under the MIT License.