sql_data_helper 1.1.3

A dart package to organize our sql data and make tables, querys more efficiently

sql_data_helper

A Dart package to organize our database data.

Getting Started

Installing

In your Flutter project, add the package to your dependencies

flutter pub add sql_data_helper

or

dependencies:
  ...
  sql_data_helper: #last_version
  ...

Usage Example

Create a field

SqlColumnModel idField = SqlColumnModel("field_name",
    type: SqlDataType.integer, primaryKey: true, autoIncrement: true);

Create a foreign key

SqlForeignKeyModel fkField = SqlForeignKeyModel(
    "field",
    table: "table_name",
    columnPrimaryKey: "pk_of_table",
    onUpdateRule: SqlForeignKeyRules.cascade,
    onDeleteRule: SqlForeignKeyRules.cascade);

Example of how to organize a table

abstract class SqlTableRestaurant {
  static const String tableName = "restaurants";

  static final SqlColumnModel id = SqlColumnModel("id",
      type: SqlDataType.integer, primaryKey: true, autoIncrement: true);

  static final SqlColumnModel name = SqlColumnModel("name", type: SqlDataType.text, notNull: true);

  String get toCreate => "CREATE TABLE IF NOT EXISTS $tableName (${[
    id.toCreate,
    name.toCreate
  ].join(" ")})";
}

With foreign key

abstract class SqlTableFood {
  static const String tableName = "foods";

  static final SqlColumnModel id = SqlColumnModel("id",
      type: SqlDataType.integer, primaryKey: true, autoIncrement: true);

  static final SqlColumnModel restaurantId = SqlColumnModel("restaurant_id",
      type: SqlDataType.integer, notNull: true);

  static final SqlColumnModel name =
  SqlColumnModel("name", type: SqlDataType.text);

  static final SqlForeignKeyModel _restaurantFk = SqlForeignKeyModel(
      restaurantId.name,
      table: SqlTableRestaurant.tableName,
      columnPrimaryKey: SqlTableRestaurant.id.name,
      onUpdateRule: SqlForeignKeyRules.cascade,
      onDeleteRule: SqlForeignKeyRules.cascade);

  String get toCreate => "CREATE TABLE IF NOT EXISTS $tableName (${[
    id.toCreate,
    restaurantId.toCreate,
    name.toCreate,
    _restaurantFk.toCreate
  ].join(" ")})";
}