sqlbase 0.0.5

Dart to php to Sql database

example/lib/main.dart

import 'package:flutter/material.dart';

import 'package:sqlbase/sqlbase.dart';

void main() {
  Sqlbase.initialize(url: "http://localhost/sqlbase.php", key: '123456');
  runApp(const MyApp());
}

class MyApp extends StatelessWidget {
  const MyApp({super.key});

  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      home: Home(),
    );
  }
}

class Home extends StatelessWidget {
  Home({super.key});

  final Sqlbase myDB = Sqlbase();

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(),
      body: Center(
        child: ElevatedButton(
            onPressed: () async {
              // var data = await Sqlbase.update('user')
              //     .where('name', 'Sammed')
              //     .set({"name": "Sammed  Twumasi"}).execute();
              // print(data.toString());
              Sqlbase.createTable([
                DBTable(
                  name:"Users",
                  column: [
                    DBColumn("id",type: ColumnType.int,length:11,isPrimary:true,autoIncrement:true),
                    DBColumn("name",type: ColumnType.varChar,length:225),
                    DBColumn("email",type: ColumnType.varChar,length:225),
                    DBColumn("createddate",type: ColumnType.date),
                  ]
                ),
                DBTable(
                    name:"Business",
                    column: [
                      DBColumn("id",type: ColumnType.int,isPrimary:true,autoIncrement:true),
                      DBColumn("id",type: ColumnType.int,foreignKey:'Users.id',autoIncrement:true),
                      DBColumn("name",type: ColumnType.varChar),
                      DBColumn("address",type: ColumnType.varChar),
                      DBColumn("createddate",type: ColumnType.date),
                    ]
                ),
              ]);
            },
            child: Text('Try')),
      ),
    );
  }
}