GrimaDB Class Reference

Shared access to the database for GrimaUser and GrimaInstitution. More...

Inheritance diagram for GrimaDB:

Public Member Functions
	offsetExists ($offset)
	offsetGet ($offset)
	offsetSet ($offset, $value)
	offsetUnset ($offset)
	getIterator ()

Static Public Member Functions
static	init ()
static	isEmpty ()
static	isStateless ()
static	getInstitutions ()

Protected Member Functions
	getPasswordAlgorithm ()

Static Protected Member Functions
static	getDb ()

Private Attributes
	$info

Static Private Attributes
static	$db = FALSE

Detailed Description

Shared access to the database for GrimaUser and GrimaInstitution.

Definition at line 3896 of file grima-lib.php.

Member Function Documentation

getDb()

static GrimaDB::getDb ( )

staticprotected

Definition at line 3919 of file grima-lib.php.

References getenvWithFileFallbackAndDefault(), and tableExists().

                                       {

         if (!self::$db) {

             try {

                 $db_url = getenvWithFileFallbackAndDefault('DATABASE_URL','');

                 $db_user = getenvWithFileFallbackAndDefault('DATABASE_USER','');

                 $db_pass = getenvWithFileFallbackAndDefault('DATABASE_PASS','');

                 if ($db_user && $db_pass) {

                     self::$db = new PDO($db_url, $db_user, $db_pass);

                 } else {

                     self::$db = new PDO($db_url);

                 }

                 if (!tableExists(self::$db,"institutions")) {

                     self::$db->exec("CREATE TABLE institutions ( institution VARCHAR(100) PRIMARY KEY, apikey VARCHAR(100), server VARCHAR(100) )");

                 }

                 if (!tableExists(self::$db,"users")) {

                     self::$db->exec("CREATE TABLE users ( institution VARCHAR(100), username VARCHAR(100), password VARCHAR(255), isAdmin INTEGER )");

                 }

             } catch (Exception $e) {

                 self::$db = 'stateless';

             }

         }

         return self::$db;

     }

getInstitutions()

static GrimaDB::getInstitutions ( )

static

Definition at line 3947 of file grima-lib.php.

Referenced by GrimaFormField\__construct().

                                       {

         $ret = array();

         try {

             $db = self::getDb();

             $result = $db->query( 'SELECT institution FROM institutions' );

             foreach( $result as $row ) {

                 $ret[] = $row['institution'];

             }

         } catch (Exception $e) {

         }

         return $ret;

     }

getIterator()

GrimaDB::getIterator

(

)

Definition at line 3976 of file grima-lib.php.

                            {

         return new ArrayIterator($this->info);

     }

getPasswordAlgorithm()

GrimaDB::getPasswordAlgorithm ( )

protected

Definition at line 3943 of file grima-lib.php.

                                               {

         return defined("PASSWORD_ARGON2I") ? constant("PASSWORD_ARGON2I") : PASSWORD_DEFAULT;

     }

init()

static GrimaDB::init ( )

static

Definition at line 3901 of file grima-lib.php.

                            {

         return self::getDb();

     }

isEmpty()

static GrimaDB::isEmpty ( )

static

Definition at line 3905 of file grima-lib.php.

                               {

         $db = self::getDb();

         $result = $db->query( 'SELECT COUNT(*) as c FROM institutions' );

         foreach( $result as $row ) {

             if ($row['c']>0) return false;

         }

         return true;

     }

isStateless()

static GrimaDB::isStateless ( )

static

Definition at line 3914 of file grima-lib.php.

                                   {

         $db = self::getDb();

         return $db === 'stateless';

     }

offsetExists()

GrimaDB::offsetExists

(

$offset

)

Definition at line 3960 of file grima-lib.php.

                                    {

         return isset($this->info[$offset]);

     }

offsetGet()

GrimaDB::offsetGet

(

$offset

)

Definition at line 3964 of file grima-lib.php.

                                 {

         return isset($this->info[$offset]) ? $this->info[$offset] : '';

     }

offsetSet()

GrimaDB::offsetSet	(		$offset,
			$value
	)

Definition at line 3968 of file grima-lib.php.

                                        {

         $this->info[$offset] = $value;

     }

offsetUnset()

GrimaDB::offsetUnset

(

$offset

)

Definition at line 3972 of file grima-lib.php.

                                   {

         unset($this->info[$offset]);

     }

Member Data Documentation

$db

GrimaDB::$db = FALSE

staticprivate

Definition at line 3898 of file grima-lib.php.

$info

GrimaDB::$info

private

Definition at line 3899 of file grima-lib.php.

---

The documentation for this class was generated from the following file:

• grimas/grima-lib.php