libpq_dart

Description:

libpq dart

libpq dart bindings
example
import 'dart:ffi';
import 'dart:io';
import 'package:freetype_dart/src/extensions/extensions.dart';
import 'package:freetype_dart/src/generated_bindings.dart';


void main(List<String> args) {
var dl = DynamicLibrary.open(r'libpq\\bin\\libpq.dll');
var pq = LibpqBindings(dl);
var conninfo = 'user=postgres password=dart host=127.0.0.1 dbname=postgres';
var conn = pq.PQconnectdb(conninfo.toNativeUtf8().cast());
if (pq.PQstatus(conn) != ConnStatusType.CONNECTION_OK)
print(pq.PQerrorMessage(conn));

var res = pq.PQexec(
conn, "SELECT * from pg_catalog.pg_user limit 1".toNativeUtf8().cast());

if (pq.PQresultStatus(res) != ExecStatusType.PGRES_TUPLES_OK) {
print("SET failed: " + pq.PQerrorMessage(conn).toDartString());
pq.PQclear(res);
pq.PQfinish(conn);
}

var nFields = pq.PQnfields(res);
for (var i = 0; i < nFields; i++) {
stdout.write(" " + pq.PQfname(res, i).toDartString() + ' | ');
}

for (var i = 0; i < pq.PQntuples(res); i++) {
print(' ');
for (var j = 0; j < nFields; j++) {
stdout.write(pq.PQgetvalue(res, i, j).toDartString() + ' | ');
}
print(' ');
}

pq.PQclear(res);
}

copied to clipboard
example hi level
import 'package:libpq_dart/libpq_dart.dart';

void main(List<String> args) {
final conninfo =
'user=dart password=dart host=127.0.0.1 dbname=banco_teste port=5435';
final pq = LibPq(conninfo);

final res =
pq.execParams(r'INSERT INTO public.knowledge (id, name, arquivo) values($1,$2);', ['1', 'Isaque']);

print('affectedRows: ${res.affectedRows}');

res.dispose();

// print(pq.execMapList('SELECT * from pg_catalog.pg_user limit 1'));
print('libpqVersion ${pq.libpqVersion}');

pq.dispose();
}

copied to clipboard