fennec_pg

Description:

fennec pg

fennec_pg is dart plugin for connecting to postgresql with orm. it belongs to fennec framework pub.dev but it can be used
separately.
Installation #
install the plugin from pub.dev
supported Feautures #

connect to postgres
SelectBuilder for select operation with where clause etc.
FilterBuilder for filtering searched Data.
SelectBuilderWithNestedJsonOutPut for joins especially if you want related objects as nested json
Serializable for seriable your model dynamically.
Repository an Interface that can be used for create your own repository
relations one to one, one to many , belongs to.

create models #
@Table('users')
class User extends Serializable {
@PrimaryKey(autoIncrement: true, columnType: ColumnType.bigInt)
int? id;
@Column(isNullable: false, indexType: IndexType.unique)
late String name;
@Column(isNullable: false, indexType: IndexType.unique)
late String email;
@HasOne(
localKey: 'user_id',
foreignKey: 'id',
fetchType: FetchType.include,
cascadeType: CascadeType.delete)
Account? account;
User();
User.fromJson(Map<String, dynamic> map) {
id = map['id'];
name = map['name'];
email = map['email'];
if (map['account'] != null) {
account = Account.fromJson(map['account']);
}
}
}

@Table('accounts')
class Account extends Serializable {
Account();
@PrimaryKey(autoIncrement: true, columnType: ColumnType.bigInt)
int? id;
@BelongsTo(
localKey: 'id', foreignKey: 'user_id', fetchType: FetchType.include)
User? user;

Account.fromJson(Map<String, dynamic> map) {
id = map['id'];
if (map['user'] != null) {
user = User.fromJson(map['user']);
}
}
}

copied to clipboard
create repository #
class UserRepository extends Repository<User, int> {}
class AccountRepository extends Repository<Account, int> {}

copied to clipboard
user repository example #
AccountRepository accountRepository = AccountRepository();
UserRepository userRepository = UserRepository();
User user = User();
user.email = '[email protected]';
user.name = 'ak1';
user.account = Account();
User? userResult = await userRepository.insert(user);
if (userResult != null) {
print(userResult.toJson());
}
final result = await accountRepository.findAll();
for (var row in result) {
print(row.toJson());
}


copied to clipboard
use SelectBuilder with FilterBuilder #

SelectBuilder selectBuilder = SelectBuilder(['*'],table:'users');
FilterBuilder filterBuilder = FilterBuilder(Field.tableColumn('id'), '=', Field.int(2));
filterBuilder.or(FilterBuilder(Field.tableColumn('id'), '=', Field.int(4)));
selectBuilder.where(filterBuilder);
final result = await PGConnectionAdapter.connection
.query(selectBuilder.makeQuery())
.toList();

for (var row in result) {
print(row.toMap());
}

copied to clipboard
custom own query #

final result = await PGConnectionAdapter.connection
.query('select * from users')
.toList();

for (var row in result) {
print(row.toMap());
}

copied to clipboard
start the connection with postgres #

var uri = 'postgres://user:password@localhost:5432/db-name';
await PGConnectionAdapter.init(uri);

copied to clipboard
LICENSE #
MIT