Description:

sqllite table builder

Programmatically create SQL Lite tables.
Currently SQFLite is tested.

Warning: This package is in alpha. Use it at own risk.

Features #

Programmatically create SQL Lite tables.
User Foreign Keys to link tables.
Use nice programming interface to ensure better safety.

Getting started #
dart pub add sqllite_table_builder
copied to clipboard
Usage #
// Create a table builder with table name and default primary key.
final someDataTable = SqlTableBuilder("some_data");
// Generate SQL query to create this table.
final someDataQuery = someDataTable.buildSqlCreateQuery();
copied to clipboard
// Create a table builder with table name and specified primary key.
final userProfileTableBuilder = SqlTableBuilder(
"user_data",
primaryKey: SqlColumn(name: "uuid", type: SqlType.text),
);

// Add required columns to a table.
userProfileTableBuilder
..createColumn("name", SqlType.text)
..nullable(false)
..createColumn("age", SqlType.integer)

// Generate SQL query to create this table.
final userProfileQuery = userProfileTableBuilder.buildSqlCreateQuery();
copied to clipboard
More examples in /examples directory and /tests.
Additional information #
If you would like to contribute to the plugin, check out it's Github page.

License

For personal and professional use. You cannot resell or redistribute these repositories in their original state.

Share

• Share on Facebook
• Share on Twitter