efsqlite Package For Easy DB With Provider AutoMap No Generator

  • efsqlite You Can Management The Database Easy
  • It's Auto ToMap FromMap
  • No Generator
  • Auto PK Generate
  • Provider
  • Your Own Query
  • Remove DB
  • Work With Enum
  • View For Any Model Add Delete Edit Get
  • Full App Design With EFMatrialApp
  • You Can Call Actions From Model
  • Default Items For Tables
  • Auto Indexing

https://dev-wsmwebsite.pantheonsite.io/ https://dev-wsmwebsite.pantheonsite.io/efsqlite

https://www.youtube.com/watch?v=JDz-EsoCzkA

Import efsqlite.dart

 import '../../efsqlite.dart';

Create Class (database.dart)

 class Todo extends IModel {
     Todo({this.id, this.name, this.isDone});
     int? id;
     String? name;
     bool? isDone;
 }

Create Table (database.dart)

 EFTable<Todo> tb_todos = EFTable(
    tableName: "todos",
    primrayKeyType: PrimaryKeyEnum.AutoIncrement,
    properties: [
        EFProperty(
            name: "name",
            type: TypeEnum.STRING,
            propertyGet: (e) => e.name,
            propertySet: (e, v) => e.name = v,
            isIndexed: true,
        ),
        EFProperty(
            name: "isDone",
            type: TypeEnum.BOOL,
            propertySet: (e, v) => e.isDone = v,
            propertyGet: (e) => e.isDone,
        ),
    ],
    primaryKeyGet: (e) => e.id,
    primaryKeySet: (e, v) => e.id = v,
    newEmptyObject: () => Todo(),
 );

Create Sqlite Data (database.dart)

 SqliteData data = SqliteData(
     tables: [tb_todos], 
     databaseName: "AppDb"
 );

Create Sqlite Query (database.dart)

 SqliteQuery<Todo> TodosManager = SqliteQuery(
     data: data, 
     table: tb_todos
 );

Create View (main.dart)

 void main() {
    runApp(EfMaterialApp(
        theme: ThemeData(primarySwatch: Colors.blue),
        data: data,
        pages: [
            ModelPage<Todo>(
                page: (scaffold, heightDialog) => 
                    ManagePage<Todo>(
                        scaffold: scaffold,
                        query: TodosManager,
                        heightDialog: heightDialog,
                    ),
                table: tb_todos,
                appBarName: "Todos",
                icon: Icons.today_outlined,
            ),
        ],
        isDrawer: false,
    ));
 }

Preview You Can Edit The Theme

database.dart

import '../../efsqlite.dart';

class Todo extends IModel {
    Todo({this.id, this.name, this.isDone});
    int? id;
    String? name;
    bool? isDone;
}

class TodoVaction extends IModel {
    TodoVaction({this.id, this.name, this.isDone});
    int? id;
    String? name;
    bool? isDone;
}

EFTable<Todo> tb_todos = EFTable(
    tableName: "todos",
    primrayKeyType: PrimaryKeyEnum.AutoIncrement,
    properties: [
        EFProperty(
            name: "name",
            type: TypeEnum.STRING,
            propertyGet: (e) => e.name,
            propertySet: (e, v) => e.name = v,
            isIndexed: true,
        ),
        EFProperty(
            name: "isDone",
            type: TypeEnum.BOOL,
            propertySet: (e, v) => e.isDone = v,
            propertyGet: (e) => e.isDone,
        ),
    ],
    primaryKeyGet: (e) => e.id,
    primaryKeySet: (e, v) => e.id = v,
    newEmptyObject: () => Todo(),
);
EFTable<TodoVaction> tb_todoVactions = EFTable(
    tableName: "todoVactions",
    primrayKeyType: PrimaryKeyEnum.AutoIncrement,
    properties: [
        EFProperty(
            name: "name",
            type: TypeEnum.STRING,
            propertyGet: (e) => e.name,
            propertySet: (e, v) => e.name = v,
            isIndexed: true,
        ),
        EFProperty(
            name: "isDone",
            type: TypeEnum.BOOL,
            propertySet: (e, v) => e.isDone = v,
            propertyGet: (e) => e.isDone,
        ),
    ],
    primaryKeyGet: (e) => e.id,
    primaryKeySet: (e, v) => e.id = v,
    newEmptyObject: () => TodoVaction(),
);
SqliteData data =
    SqliteData(tables: [tb_todos, tb_todoVactions], databaseName: "AppDb");
SqliteQuery<Todo> TodosManager = SqliteQuery(data: data, table: tb_todos);
SqliteQuery<TodoVaction> TodoVactionsManager =
    SqliteQuery(data: data, table: tb_todoVactions);

main.dart

import './database.dart';
import 'package:flutter/material.dart';
import '../../efsqlite.dart';

void main() {
    runApp(EfMaterialApp(
        theme: ThemeData(primarySwatch: Colors.blue),
        data: data,
        pages: [
            ModelPage<Todo>(
                page: (scaffold, heightDialog) => ManagePage(
                    scaffold: scaffold,
                    query: TodosManager,
                    heightDialog: heightDialog,
                ),
                table: tb_todos,
                appBarName: "Todos",
                icon: Icons.today_outlined,
            ),
            ModelPage<TodoVaction>(
                page: (scaffold, heightDialog) => ManagePage(
                    scaffold: scaffold,
                    query: TodoVactionsManager,
                    heightDialog: heightDialog,
                ),
                table: tb_todoVactions,
                appBarName: "TodosVaction",
                icon: Icons.card_travel_rounded,
            ),
        ],
    ));
}

Preview Result You Can Edit The Theme

If We Edit isDrawer

runApp(EfMaterialApp(
    ...,
    isDrawer: false,
));

Libraries

package/design/ef_home_page
efsqlite
package/design/manage_page
package/extensions/model
package/interfaces/model
package/enums/number_undo
package/enums/primary_key_enum
package/extensions/printing
package/models/property
package/interfaces/property
package/provider/provider
package/provider/provider_base
package/database/sqflite_batch
package/database/sqlite_commands
package/database/sqlite_data
package/database/sqlite_query
package/interfaces/sqlite_query
package/database/sqlite_query_storage
package/database/sqlite_storage
package/models/table
package/enums/type_enum