sqlview 0.4.0 copy "sqlview: ^0.4.0" to clipboard
sqlview: ^0.4.0 copied to clipboard

Sql view widgets for Sqlcool. Auto admin view and infinite list view.

Sqlview #

pub package

A collection of sql views for Sqlite and Flutter using Sqlcool. Available views:

  • Admin view: full admin interface for add/edit/delete rows in a table
  • Infinite list view from a table

Crud admin view #

List of rows Edit row
Crud admin 1 Crud admin 1

To get the above use an Sqlcool database with a defined schema:

import 'package:sqlcool/sqlcool.dart';

var table = DbTable("item")
   ..boolean("boolean", defaultValue: false)
   ..varchar("varchar")
   ..integer('integer_number', defaultValue: 1)
   ..real("double_number", defaultValue: 0)
   ..text("text", defaultValue: "");

var db = Db();
db.init("db.sqlite", schema = [table]);

Then use it in a widget:

import 'package:flutter/material.dart';
import 'package:sqlcool/sqlcool.dart';
import 'package:sqlview/sqlview.dart';

class _CrudPageState extends State<CrudPage> {
   SelectBloc bloc;

@override
void initState() {
   bloc = SelectBloc(database: db, table: "item");
   super.initState();
}

@override
Widget build(BuildContext context) {
   return Scaffold(
      body: CrudView(bloc: bloc, nameField: "varchar"),
      floatingActionButton:
         CrudAddActionButton(db: db, schema: db.schema.table("item")),
      );
   }
}

class CrudPage extends StatefulWidget {
   @override
   _CrudPageState createState() => _CrudPageState();
}

Infinite list view #

InfiniteListView(
   db: db,
   table: "product",
   orderBy: "name",
   itemsBuilder: (context, item) {
      return ListTile(
         title: Text(item['name']), trailing: Text(item["price"]));
   });

Todo #

  • Check table constraints and add validators for forms in CrudView
1
likes
40
pub points
2%
popularity

Publisher

unverified uploader

Sql view widgets for Sqlcool. Auto admin view and infinite list view.

Repository (GitHub)
View/report issues

License

MIT (LICENSE)

Dependencies

card_settings, cupertino_icons, extra_pedantic, flutter, flutter_slidable, pedantic, sqlcool

More

Packages that depend on sqlview