Created a provisioning example

[ga4php.git] / example / provisioning / dbfunctions.php

diff --git a/example/provisioning/dbfunctions.php b/example/provisioning/dbfunctions.php
new file mode 100644 (file)
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