import 'package:dchisel/dchisel.dart';

Future<void> main(List<String> arguments) async {
  DChisel().serve();
}

 DChisel().serve(serverHost: '0.0.0.0', serverPort: 5555);

DChisel().routeGet('/hello', (Request request) {
    return 'Hello, World';
});

DChisel().routeGet('/getparam/<name>', (Request request, String name) {
    return 'Hello, $name';
});

DChisel().routePost('/hello', (Request request) async {
    return 'Hello, World';
});

var body = await request.body.asJson;

var headers = await request.headers;

DChisel().routePut('/hello/<name>', (Request request, String name) async {
  return 'Hello, $name';
});

var headers = await request.headers;
var body = await request.body.asJson;

DChisel().routeDelete('/hello/<name>', (Request request, String name) async {
  return 'Hello, $name';
});

DChiselDB().configDB('dialect', // DIALECT DATABASE, IF YOU USE POSTGRESQL CHANGE 'dialect' to 'postgre', IF YOU USE MYSQL CHANGE 'dialect' to 'mysql'
    host: 'your_host',
    db: 'your_db_name',
    port: your_port, //integer
    username: 'your_db_username',
    password: 'your_db_password');

DChiselDB().getAll('your_table_name');

DChiselDB().getOption('your_table_name', 
    column: 'your_column1,your_column2', 
    where: ['your_column_name', 'your_filter_value']);

'%your_filter_value%'

DChiselDB().create('users', data: {
    'your_column_name': 'your_value'
});

DChiselDB().update('users', data: {
    'your_column_name': 'your_value'
}, where: ['your_filter_column_name', 'your_filter_value']);

DChiselDB().deleteAll('your_table_name');

DChiselDB().deleteOption('your_table_name', where: ['your_filter_column_name', 'your_filter_value']);