sqlitec 0.0.2+2 
sqlitec: ^0.0.2+2 copied to clipboard
Automatically generate code for converting sqlite to dart.
A Dart plugin to generate boilerplate code for your local database,
featuring low coupling and type safety, completely inspired by the sqlc Go library.
IT IS NOT AN ORM. This package has no intention of being an ORM. Instead, it simply writes the tedious parts of database handling for you, leaving you in control and fully aware of what is happening. There is no magic code, no surprises, just simple, and idiomatic dart code.
This plugin works on any operating system and can be used with sqflite and sqflite_common_ffi.
Features #
Use this plugin in your dart application to:
- Create classes from you tables.
- Call your queries as a simple dart method ensuring type safety.
- Consume data from your database without need to worry about type casting and all the boilerplate.
Getting started #
To use this plugin you will need sqflite or sqflite_common_ffi implementation.
Usage #
Create a .sql file anywhere in your lib folder and write your custom SQL commands.
create table customers (
id integer primary key autoincrement,
name varchar not null default null,
status varchar not null default ''
);
--name getCustomerByName :one
select * from customers where name = ? and status = :status;
--name: insertCustomer :exec
insert into customers(name, status) values (?, ?);
Generated code:
// sqlitec/schemas.dart
class Customers {
static const String $tableInfo = 'customers';
static const String $createTableStatement = 'CREATE TABLE customers(id integer PRIMARY KEY AUTOINCREMENT, name varchar NOT NULL DEFAULT NULL, status varchar NOT NULL DEFAULT \'\')';
int id;
String name;
String status;
Customers({
required this.id,
required this.name,
required this.status,
});
factory Customers.fromJson(Map<String, dynamic> jsonMap) {
return Customers(
id: (jsonMap['id'] as num).toInt(),
name: jsonMap['name'] as String,
status: jsonMap['status'] as String,
);
}
Map<String, dynamic> toJson() {
return {
'id': id,
'name': name,
'status': status,
};
}
String toString() {
return '''Customers(
id: $id,
name: $name,
status: $status,
)'''; }
...
// methods inside Queries class on sqlitec/queries.sqlitec.dart
Future<Customers?> getCustumerByNameAndStatus(String $arg1, {
required String status,
}) async {
final result = await db.rawQuery(
'SELECT * FROM customers WHERE name = ? AND status = ?',
[$arg1, status],
);
if (result.isEmpty) return null;
final resultFirst = result.first;
return Customers.fromJson(resultFirst);
}
Future<int> insertCustomer({
required String name,
required String status,
}) async {
final result = await db.rawInsert(
'INSERT INTO customers (name, status) VALUES (?, ?)',
[
name,
status,
],
);
return result;
}
Using the generated code #
final queries = Queries(db: /*your db instance*/);
await queries.insertCustomer(name: 'Bob', status: 'registered');
final user = await queries.getCustomerByNameAndStatus('Bob', status: 'registered');
print(user); // Customers(id: 1, name: Bob, status: registered,)
Metadata
Publisher
unverified uploader
Weekly Downloads
Metadata
Automatically generate code for converting sqlite to dart.
Repository (GitHub)
View/report issues
Topics
#sqlite #build-runner #sqlc #codegen
Documentation
License
BSD-3-Clause (license)
Dependencies
build, change_case, collection, dart_style, flutter_lints, glob, markdown, path, source_gen, sqlparser
