-
-
Save parzibyte/c6778c68ee83ffd4f861e4e114e9f51e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import 'dart:io'; | |
import 'package:flutter/material.dart'; | |
import 'package:path/path.dart'; | |
import 'package:sqflite_common_ffi/sqflite_ffi.dart'; | |
import 'package:sqflite/sqflite.dart'; | |
void main() { | |
runApp(const MyApp()); | |
} | |
class MyApp extends StatelessWidget { | |
const MyApp({super.key}); | |
// This widget is the root of your application. | |
@override | |
Widget build(BuildContext context) { | |
return MaterialApp( | |
title: 'Flutter Demo', | |
theme: ThemeData( | |
// This is the theme of your application. | |
// | |
// Try running your application with "flutter run". You'll see the | |
// application has a blue toolbar. Then, without quitting the app, try | |
// changing the primarySwatch below to Colors.green and then invoke | |
// "hot reload" (press "r" in the console where you ran "flutter run", | |
// or simply save your changes to "hot reload" in a Flutter IDE). | |
// Notice that the counter didn't reset back to zero; the application | |
// is not restarted. | |
primarySwatch: Colors.blue, | |
), | |
home: const MyHomePage(title: 'Flutter Demo Home Page'), | |
); | |
} | |
} | |
class MyHomePage extends StatefulWidget { | |
const MyHomePage({super.key, required this.title}); | |
// This widget is the home page of your application. It is stateful, meaning | |
// that it has a State object (defined below) that contains fields that affect | |
// how it looks. | |
// This class is the configuration for the state. It holds the values (in this | |
// case the title) provided by the parent (in this case the App widget) and | |
// used by the build method of the State. Fields in a Widget subclass are | |
// always marked "final". | |
final String title; | |
@override | |
State<MyHomePage> createState() => _MyHomePageState(); | |
} | |
class _MyHomePageState extends State<MyHomePage> { | |
int _counter = 0; | |
void testSqlite() async { | |
Database db; | |
if (Platform.isWindows || Platform.isLinux) { | |
// Initialize FFI | |
sqfliteFfiInit(); | |
var databaseFactory = databaseFactoryFfi; | |
db = await databaseFactory.openDatabase(join(".", "ejemplo.db")); | |
} else { | |
db = await openDatabase( | |
// Set the path to the database. Note: Using the `join` function from the | |
// `path` package is best practice to ensure the path is correctly | |
// constructed for each platform. | |
join(await getDatabasesPath(), 'ejemplo.db'), | |
// When the database is first created, create a table to store dogs. | |
onCreate: (db, version) { | |
// Run the CREATE TABLE statement on the database. | |
}, | |
// Set the version. This executes the onCreate function and provides a | |
// path to perform database upgrades and downgrades. | |
version: 1, | |
); | |
} | |
await db.execute(''' | |
CREATE TABLE IF NOT EXISTS Product ( | |
id INTEGER PRIMARY KEY, | |
title TEXT | |
) | |
'''); | |
await db.insert('Product', <String, Object?>{'title': 'Product 1'}); | |
await db.insert('Product', <String, Object?>{'title': 'Product 1'}); | |
var result = await db.query('Product'); | |
print(result); | |
// prints [{id: 1, title: Product 1}, {id: 2, title: Product 1}] | |
await db.close(); | |
} | |
void _incrementCounter() { | |
setState(() { | |
// This call to setState tells the Flutter framework that something has | |
// changed in this State, which causes it to rerun the build method below | |
// so that the display can reflect the updated values. If we changed | |
// _counter without calling setState(), then the build method would not be | |
// called again, and so nothing would appear to happen. | |
_counter++; | |
}); | |
} | |
@override | |
Widget build(BuildContext context) { | |
// This method is rerun every time setState is called, for instance as done | |
// by the _incrementCounter method above. | |
// | |
// The Flutter framework has been optimized to make rerunning build methods | |
// fast, so that you can just rebuild anything that needs updating rather | |
// than having to individually change instances of widgets. | |
return Scaffold( | |
appBar: AppBar( | |
// Here we take the value from the MyHomePage object that was created by | |
// the App.build method, and use it to set our appbar title. | |
title: Text(widget.title), | |
), | |
body: Center( | |
// Center is a layout widget. It takes a single child and positions it | |
// in the middle of the parent. | |
child: Column( | |
// Column is also a layout widget. It takes a list of children and | |
// arranges them vertically. By default, it sizes itself to fit its | |
// children horizontally, and tries to be as tall as its parent. | |
// | |
// Invoke "debug painting" (press "p" in the console, choose the | |
// "Toggle Debug Paint" action from the Flutter Inspector in Android | |
// Studio, or the "Toggle Debug Paint" command in Visual Studio Code) | |
// to see the wireframe for each widget. | |
// | |
// Column has various properties to control how it sizes itself and | |
// how it positions its children. Here we use mainAxisAlignment to | |
// center the children vertically; the main axis here is the vertical | |
// axis because Columns are vertical (the cross axis would be | |
// horizontal). | |
mainAxisAlignment: MainAxisAlignment.center, | |
children: <Widget>[ | |
const Text( | |
'You have pushed the button this many times:', | |
), | |
Text( | |
'$_counter', | |
style: Theme.of(context).textTheme.headline4, | |
), | |
], | |
), | |
), | |
floatingActionButton: FloatingActionButton( | |
onPressed: () async { | |
Database db; | |
if (Platform.isWindows || Platform.isLinux) { | |
// Initialize FFI | |
sqfliteFfiInit(); | |
var databaseFactory = databaseFactoryFfi; | |
db = await databaseFactory.openDatabase(join(".", "ejemplo.db")); | |
} else { | |
db = await openDatabase( | |
// Set the path to the database. Note: Using the `join` function from the | |
// `path` package is best practice to ensure the path is correctly | |
// constructed for each platform. | |
join(await getDatabasesPath(), 'ejemplo.db'), | |
// When the database is first created, create a table to store dogs. | |
onCreate: (db, version) { | |
// Run the CREATE TABLE statement on the database. | |
}, | |
// Set the version. This executes the onCreate function and provides a | |
// path to perform database upgrades and downgrades. | |
version: 1, | |
); | |
} | |
await db.execute(''' | |
CREATE TABLE IF NOT EXISTS Product ( | |
id INTEGER PRIMARY KEY, | |
title TEXT | |
) | |
'''); | |
await db.insert('Product', <String, Object?>{'title': 'Product 1'}); | |
await db.insert('Product', <String, Object?>{'title': 'Product 1'}); | |
var result = await db.query('Product'); | |
ScaffoldMessenger.of(context) | |
.showSnackBar(SnackBar(content: Text(result.toString()))); | |
print(result); | |
// prints [{id: 1, title: Product 1}, {id: 2, title: Product 1}] | |
await db.close(); | |
}, | |
tooltip: 'Increment', | |
child: const Icon(Icons.add), | |
), // This trailing comma makes auto-formatting nicer for build methods. | |
); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment