sqleto 0.0.3

A ORM-ish for use with PostgreSQL

example/example.dart

import 'package:sqleto/sqleto.dart';

import 'entities/post_entity.dart';
import 'entities/user_entity.dart';

void main() async {
  try {
    final config = SQLetoConfig(
      host: 'host.docker.internal',
      port: 5432,
      database: 'postgres',
      username: 'postgres',
      password: 'postgres',
      schemas: [UserEntitySchema, PostEntitySchema],
    );

    await SQLeto.initialize(config);

    final user = await createUser(
      () => UserEntitySchema.create(
        name: 'John Doe',
        username: 'john',
        email: '[e-mail]',
        password: '123456',
        image: '',
      ),
    );

    final post = await createPost(
      () => PostEntitySchema.create(
        title: 'My first post',
        body: 'LOL',
        ownerId: user.uid,
      ),
    );

    print(post.toMap());
  } on SQLetoException catch (e) {
    print(e.error);
  } on Exception catch (e) {
    print(e);
  }
}

// Insert post
Future<PostEntitySchema> createPost(PostEntitySchema Function() post) async {
  return await SQLeto.instance.insert<PostEntitySchema>(post);
}

// Update post
Future<PostEntitySchema> updatePost(PostEntitySchema Function() post) async {
  return await SQLeto.instance.update<PostEntitySchema>(post);
}

// Delete post
Future<PostEntitySchema> deletePost(PostEntitySchema Function() post) async {
  return await SQLeto.instance.delete<PostEntitySchema>(post);
}

// Insert user
Future<UserEntitySchema> createUser(UserEntitySchema Function() user) async {
  return await SQLeto.instance.insert<UserEntitySchema>(user);
}

// Update User
Future<UserEntitySchema> updateUser(UserEntitySchema Function() user) async {
  return await SQLeto.instance.update<UserEntitySchema>(user);
}

// Delete User
Future<UserEntitySchema> deleteUser(UserEntitySchema Function() user) async {
  return await SQLeto.instance.delete<UserEntitySchema>(user);
}