X-Git-Url: http://git.pjr.cc/?p=ga4php.git;a=blobdiff_plain;f=example%2Fprovisioning%2Fdbfunctions.php;fp=example%2Fprovisioning%2Fdbfunctions.php;h=2aa2c05001d9b45c26889ca2436f79ffb6dca990;hp=0000000000000000000000000000000000000000;hb=ddd5c8118fb9ad4f6e8f4ea7371f189e1b152064;hpb=195c42d5711d000a987ed3a0a376ac09b98867fc

diff --git a/example/provisioning/dbfunctions.php b/example/provisioning/dbfunctions.php
new file mode 100644
index 0000000..2aa2c05
--- /dev/null
+++ b/example/provisioning/dbfunctions.php
@@ -0,0 +1,27 @@
+<?php
+
+function getDatabase() {
+	$dbobject = false;
+	if(file_exists("/tmp/gadata.sqlite")) {
+		try {
+			$dbobject = new PDO("sqlite:/tmp/gadata.sqlite");
+		} catch(PDOException $exep) {
+			error_log("execpt on db open");
+		}
+	} else {
+		try {
+			$dbobject = new PDO("sqlite:/tmp/gadata.sqlite");
+		} catch(PDOException $exep) {
+			error_log("execpt on db open");
+		}
+		$sql = 'CREATE TABLE "users" ("users_id" INTEGER PRIMARY KEY AUTOINCREMENT,"users_username" TEXT,"users_fullname" TEXT,"users_tokendata" TEXT);';
+		$dbobject->query($sql);
+	}
+	
+	return $dbobject;
+}
+
+function closeDatabase($db) {
+	// doesnt do anything yet
+}
+?>
\ No newline at end of file