dox_query_builder 1.1.11

PostgresSQL query builder, Support Model, Where, orWhere, Find, Join, softDeletes, Debugging and many mores.

Dox Query Builder

Full documentation here

Initialize Query Builder

PgPool dbPool = PgPool(
    PgEndpoint(
    host: 'localhost',
    port: 5432,
    database: 'postgres',
    username: 'postgres',
    password: 'postgres',
    ),
    settings: PgPoolSettings()
    ..maxConnectionAge = Duration(hours: 1)
    ..concurrency = 4,
);

/// Initialize Sql QueryBuilder
SqlQueryBuilder.initialize(
    database: dbPool,
    debug: config.enableQueryLog,
);

Usage

var result = await QueryBuilder.table('blog')
    .insert({
        'title': 'dox',
    });

Usage with Model

make sure you have included dox_builder and build_runner in dev dependencies

dev_dependencies:
  dox_builder: ^0.0.5
  build_runner: ^2.3.3

Setup model

you can also use dox-cli to generate model.

import 'package:dox_query_builder/dox_query_builder.dart';
part 'blog.model.g.dart';

@DoxModel()
class Blog extends BlogGenerator {
  @Column()
  String? title;
  
  @Column(name: 'title', beforeSave: makeSlug)
  String? slug;

  @Column()
  String? status;

  @Column(name: 'body')
  String? description;

  @Column(name: 'created_at')
  DateTime? createdAt;

  @Column(name: 'updated_at')
  DateTime? updatedAt;

  static makeSlug(Map<String, dynamic> map) {
    return Slugify().slugify(map['title']);
  }
}

Run build runner

$ dart run build_runner build

Run query

Blog blog = Blog();
blog.title = 'dox';
await blog.save();