Not really bread. Not really fruit. Just like this package. Some simple helpers on top of knex.
constconfig={client: 'postgresql',connection: 'postgres://postgres@localhost:5432/someDatabase',pool: {min: 1,max: 7}};constbread=require('breadfruit')(config);const{browse, read, edit, add, del, raw}=require('breadfruit')(config);//get an array of users, by table, columns, and a filterconstusers=awaitbrowse('users',['username','user_id'],{active: true});//get a single user by table, columns, and a filterconstuser=awaitread('users',['username','first_name'],{user_id: 1337});//edit a user by table, returned columns, updated values, and a filterconstupdatedUser=awaitedit('users',['username','first_name'],{first_name: 'Howard'},{user_id: 1337});//add a new user by table, returned columns, and user dataconstnewUser=awaitadd('users',['user_id'],{first_name: 'Howard',username: 'howitzer'});//delete a user by table and a filterconstdeleteCount=awaitdel('users',{user_id: 1337});//perform a raw queryconstrows=awaitraw('select * from users');
