final class \SmartModExtLib\DbOrmRedbean\ORM
extends \RedBeanPHP\Facade
{ } ::

• Language: PHP
• Located at: modules/mod-db-orm-redbean/libs/ORM.php
• Package: modules:Database:PDO:Redbean-ORM
• Namespace: \SmartModExtLib\DbOrmRedbean\
• Class Name: ORM
• Version: v.20231018
• Depends: extensions: PHP Ctype, PHP PDO ; vendor-classes: \RedbeanOrm\Db ; classes: Smart, SmartFileSysUtils, SmartEnvironment
• Usage: dynamic object: (new Class())->method() - This class provides only DYNAMIC methods
• Inheritance Chart:
  class \SmartModExtLib\DbOrmRedbean\ORM →
  •  ↳ class \RedBeanPHP\Facade

class Methods

Sample code: PHP
<?php

 R::setup( 'mysql:host=localhost;dbname=mydatabase', 'dba', 'dbapassword' );

// #end php code

Sample code: PHP
<?php

 SELECT {table}.*

SELECT *

// #end php code

Sample code: PHP
<?php

 $from = 1;
 $to = 2;
 $amount = 300;

 R::transaction(function() use($from, $to, $amount)
 {
   $accountFrom = R::load('account', $from);
   $accountTo = R::load('account', $to);
   $accountFrom->money -= $amount;
   $accountTo->money += $amount;
   R::store($accountFrom);
   R::store($accountTo);
 });

// #end php code

Sample code: PHP
<?php

 R::addDatabase( 'database-1', 'sqlite:/tmp/db1.txt' );
 R::selectDatabase( 'database-1' ); //to select database again

// #end php code

Sample code: PHP
<?php

 R::createToolbox( 'mysql:host=localhost;dbname=mydatabase', 'dba', 'dbapassword' );

// #end php code

Sample code: PHP
<?php

 $post = R::dispense('post');
 $post->title = 'my post';
 $id = R::store( $post );
 $post = R::load( 'post', $id );
 R::trash( $post );

// #end php code

Sample code: PHP
<?php

 list( $author, $bio ) = R::loadMulti( 'author, bio', $id );

// #end php code

Sample code: PHP
<?php

 $post = R::dispense('post');
 $post->title = 'my post';
 $id = R::store( $post );
 $post = R::load( 'post', $id );
 R::trash( $post );

// #end php code

Sample code: PHP
<?php

 $bean = R::loadForUpdate( 'bean', $id );
 ...update...
 R::store( $bean );

// #end php code

Sample code: PHP
<?php

 $bean = R::findForUpdate(
    'bean',
    ' title LIKE ? ',
    array('title')
 );
 ...update...
 R::store( $bean );

// #end php code

Sample code: PHP
<?php

 $post = R::dispense('post');
 $post->title = 'my post';
 $id = R::store( $post );
 $post = R::load( 'post', $id );
 R::trash( $post );

// #end php code

Sample code: PHP
<?php

 $book = R::dispense( 'book' );
 $book->title = 'My Book';
 R::store( $book );

$book = R::dispense( [
   '_type' => 'book',
   'title'  => 'Gifted Programmers',
   'author' => [ '_type' => 'author', 'name' => 'Xavier' ],
   'ownPageList' => [ ['_type'=>'page', 'text' => '...'] ]
 ] );

// #end php code

Sample code: PHP
<?php

 list( $book, $page, $text ) = R::dispenseAll( 'book,page,text' );

list($book, $pages) = R::dispenseAll('book,page*100');

// #end php code

Sample code: PHP
<?php

 $stuff = $finder->findMulti('movie,review', '
          SELECT movie.*, review.* FROM movie
          LEFT JOIN review ON review.movie_id = movie.id');

array(
 	'a'       => TYPE A
    'b'       => TYPE B
    'matcher' => MATCHING FUNCTION ACCEPTING A, B and ALL BEANS
    'do'      => OPERATION FUNCTION ACCEPTING A, B, ALL BEANS, ALL REMAPPINGS
 )

array(
 	'a'       => 'movie'     //define A as movie
    'b'       => 'review'    //define B as review
    'matcher' => function( $a, $b ) {
       return ( $b->movie_id == $a->id );  //Perform action if review.movie_id equals movie.id
    }
    'do'      => function( $a, $b ) {
       $a->noLoad()->ownReviewList[] = $b; //Add the review to the movie
       $a->clearHistory();                 //optional, act 'as if these beans have been loaded through ownReviewList'.
    }
 )

// #end php code

Sample code: PHP
<?php

 $rows = R::getAll( 'SELECT * FROM ...' )
 $beans = R::convertToBeans( $rows );

$rows = R::getAll( 'SELECT FROM... COUNT(*) AS extra_count ...' );
 $beans = R::convertToBeans( $rows, 'extra_' );
 $bean = reset( $beans );
 $data = $bean->getMeta( 'data.bundle' );
 $extra_count = $data['extra_count'];

// #end php code

Sample code: PHP
<?php

 R::hasTag( $blog, 'horror,movie', TRUE );

// #end php code

Sample code: PHP
<?php

 R::untag( $blog, 'smart,interesting' );

// #end php code

Sample code: PHP
<?php

 R::tag( $meal, "TexMex,Mexican" );
 $tags = R::tag( $meal );

// #end php code

Sample code: PHP
<?php

 R::addTags( $blog, ["halloween"] );

// #end php code

Sample code: PHP
<?php

 $watchList = R::tagged(
   'movie',
   'horror,gothic',
   ' ORDER BY movie.title DESC LIMIT ?',
   [ 10 ]
 );

// #end php code

Sample code: PHP
<?php

 $watchList = R::taggedAll(
    'movie',
    [ 'gothic', 'short' ],
    ' ORDER BY movie.id DESC LIMIT ? ',
    [ 4 ]
 );

// #end php code

Sample code: PHP
<?php

 R::begin();
 try {
  $bean1 = R::dispense( 'bean' );
  R::store( $bean1 );
  $bean2 = R::dispense( 'bean' );
  R::store( $bean2 );
  R::commit();
 } catch( \Exception $e ) {
  R::rollback();
 }

// #end php code

Sample code: PHP
<?php

 R::begin();
 try {
  $bean1 = R::dispense( 'bean' );
  R::store( $bean1 );
  $bean2 = R::dispense( 'bean' );
  R::store( $bean2 );
  R::commit();
 } catch( \Exception $e ) {
  R::rollback();
 }

// #end php code

Sample code: PHP
<?php

 R::begin();
 try {
  $bean1 = R::dispense( 'bean' );
  R::store( $bean1 );
  $bean2 = R::dispense( 'bean' );
  R::store( $bean2 );
  R::commit();
 } catch( \Exception $e ) {
  R::rollback();
 }

// #end php code

Sample code: PHP
<?php

 R::genSlots( array( 'a', 'b' ) );

R::genSlots( array('a', 'b'), ' IN( %s ) ' );

// #end php code

Sample code: PHP
<?php

 $users = R::find('user');
 $users = R::loadJoined( $users, 'country' );

$all = R::findMulti('country',
    R::genSlots( $users,
       'SELECT country.* FROM country WHERE id IN ( %s )' ),
    array_column( $users, 'country_id' ),
    [Finder::onmap('country', $gebruikers)]
 );

// #end php code

Sample code: PHP
<?php

 R::flat( array( 'a', array( 'b' ), 'c' ) );

// #end php code

Sample code: PHP
<?php

 $tea->flavour = R::enum( 'flavour:apple' );

R::enum('flavour');

R::gatherLabels( R::enum( 'flavour' ) );

// #end php code

Sample code: PHP
<?php

 R::setup( ... );
 ... do stuff ...
 R::close();

// #end php code

Sample code: PHP
<?php

 R::getDatabaseAdapter()->getDatabase()->getPDO();

// #end php code

Sample code: PHP
<?php

 Custom handler method signature: handler( array (
 	'message' => string
 	'bean' => OODBBean
 	'method' => string
 ) )

// #end php code

Sample code: PHP
<?php

 echo R::dump( $bean );

// #end php code

Sample code: PHP
<?php

 R::bindFunc( 'read', 'location.point', 'asText' );
 R::bindFunc( 'write', 'location.point', 'GeomFromText' );

// #end php code

Sample code: PHP
<?php

 R::aliases( array( 'cover' => 'page' ) );
 $book = R::dispense( 'book' );
 $page = R::dispense( 'page' );
 $book->cover = $page;
 R::store( $book );
 $book = $book->fresh();
 $cover = $book->cover;
 echo $cover->getMeta( 'type' ); //page

// #end php code

Sample code: PHP
<?php

 R::startLogging();
 R::store( R::dispense( 'book' ) );
 R::find('book', 'id > ?',[0]);
 $logs = R::getLogs();
 $count = count( $logs );
 print_r( $logs );
 R::stopLogging();

// #end php code

Sample code: PHP
<?php

 R::startLogging();
 R::store( R::dispense( 'book' ) );
 R::find('book', 'id > ?',[0]);
 $logs = R::getLogs();
 $count = count( $logs );
 print_r( $logs );
 R::stopLogging();

// #end php code

Sample code: PHP
<?php

 R::startLogging();
 R::store( R::dispense( 'book' ) );
 R::find('book', 'id > ?',[0]);
 $logs = R::getLogs();
 $count = count( $logs );
 print_r( $logs );
 R::stopLogging();

// #end php code

Sample code: PHP
<?php

 R::resetQueryCount();
 echo R::getQueryCount() . ' queries processed.';

// #end php code

Sample code: PHP
<?php

 echo R::getQueryCount() . ' queries processed.';

// #end php code

Sample code: PHP
<?php

 R::csv( 'SELECT
                 `name`,
                  population
          FROM city
          WHERE region = :region ',
          array( ':region' => 'Denmark' ),
          array( 'city', 'population' ),
          '/tmp/cities.csv'
 );

// #end php code

Sample code: PHP
<?php

 $htmlPulldown = R::look(
   'SELECT * FROM color WHERE value != ? ORDER BY value ASC',
   [ 'g' ],
   [ 'value', 'name' ],
   '<option value="%s">%s</option>',
   'strtoupper',
   "\n"
 );

// #end php code

Sample code: PHP
<?php

 AQueryWriter::useJSONColumns( $flag );
 OODBBean::convertArraysToJSON( $flag );

// #end php code

Sample code: PHP
<?php

 R::useFeatureSet( 'novice/latest' );

// #end php code

Sample code: PHP
<?php

 R::ext( 'makeTea', function() { ... }  );

R::makeTea();

// #end php code

class Properties

class Constants

Sample code: PHP