andela-cganga / potato-orm

index.php

<?php

For compatibility and reusability of your code, PSR1 recommends that a file should introduce either new symbols (like classes, functions, etc.) or have side-effects (like outputting something, or including other files), but not both at the same time. The first symbol is defined on line 18 and the first side effect is on line 2.

require 'vendor/autoload.php';

use Ganga\Potato\Potato;
use Ganga\Potato\Connection;

/**
 * NOTE:: Create a test.db database fil
 * and run the users.sql dump file in the root of the project
 * to create the users table and some records
 */

/**
 * It is advisable that classes are created on their own file
 * This class definition will connect to the users table
 */

class User extends Potato

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{

}

// SQLite config example
// Make sure a users table exists
// A sample users.sql dump is provided in the root of the project
$sqliteConfig = [
    "type" => "sqlite",
    "database" => "test.db"
];

// Load environment variables
$dotenv = new Dotenv\Dotenv(__DIR__);
$dotenv->load();

// MySQL config example
// Make sure you have a mysql database connection available
// And that the connected database has a users table with id, name, address, company and age
// As culumns
// Fill in the fields below with the relevant ones
$mysqlConfig = [
    "type" => getenv('DB_TYPE'),
    "database" => getenv('DB_NAME'),
    "user" => getenv('DB_USER'),
    "password" => getenv('DB_PASS'),
    "host" => getenv('DB_HOST')
];

// Make sure you choose the correct config type
$conn = new Connection($mysqlConfig);

// Get all users from the users table
$users = User::getAll();
echo '<h3>All Users</h3>';
prettyPrint($users);

// Get one user from the users table
$user = User::getOne(3);//
echo '<h3>One User</h3>';
prettyPrint($user);

// Create a new user
$user = new User;
$user->name = "Jin Kazama";

The property name does not exist on object<User>. Since you implemented __set, maybe consider adding a @property annotation.

$user->age = 21;

The property age does not exist on object<User>. Since you implemented __set, maybe consider adding a @property annotation.

$user->address = "525 Kindaruma";

The property address does not exist on object<User>. Since you implemented __set, maybe consider adding a @property annotation.

$user->company = "466 Video Productions";

The property company does not exist on object<User>. Since you implemented __set, maybe consider adding a @property annotation.

$user->save();
$users = User::getAll();
echo '<h3>All Users</h3>';
prettyPrint($users);

// Edit an existing user
$user = User::find(1000);
$user->name = "Anthony Steven";

The property name does not exist on object<User>. Since you implemented __set, maybe consider adding a @property annotation.

$user->save();
$users = User::getAll();
echo '<h3>All Users (3rd edited)</h3>';
prettyPrint($users);

// Delete a user
User::destroy(2);

2 is of type integer, but the function expects a object<Ganga\Potato\id>.

$user_del = User::getAll();
echo '<h3>All Users (id 2 deleted)</h3>';
prettyPrint($user_del);


function prettyPrint($data)
{
    echo '<pre>'.print_r($data, true);
}