postgres_builder

Description:

postgres builder

Postgres Builder #






A tool designed to make writing SQL statements easier.
Usage #
To start, create an instance of PostgresBuilder to run your queries. There is an included PgPoolPostgresBuilder that uses the postgres_pool package, but you can create your own by extending PostgresBuilder.
To create SQL strings, create Statements, one of

Select
Insert
Update
Delete
Upsert (insert unless the entity already exists, then update)

Available Methods #

execute: run a statement and return nothing back
query: run a query an get all the rows back as Map<String, dynamic>
singleQuery: run a query and get a single row back as Map<String, dynamic>
mappedQuery: run a query and get back rows parsed using your provided fromJson function
mappedSingleQuery: run a query and get a single row parsed using your provided fromJson function

Raw Queries #
For all available methods, just add raw to the name to pass in a raw SQL string instead of a Statement.

License

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

Share

• Share on Facebook
• Share on Twitter