Skip to content

astianmuchui/PixelSequel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

69 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PixelSequel ORM

wakatime

Introduction

This is my portfolio project for ALX Software Engineering program. The project is a simple ORM that allows you to interact with the database using PHP. The project is still in its early stages and is not recommended for use in production environments. The project is open source and contributions are welcome.

Author

Sebastian Muchui

License

MIT

Version

0.1.0

Installation

You need to have PHP installed in your machine to use this package. If you do not have PHP installed, you can download it from the official PHP website.

Secondly, ensure you have composer installed in your machine. If not, you can install it by following the instructions provided in the official composer website. Once this is done, you need to create a composer.json file in your project root directory and add the following code:

    {
        "minimum-stability" : "dev"
    }

After that, you can install the package by running the following command in your terminal:

    composer require astianmuchui/pixelsequel

Usage

The ORM comes with 2 major parts, Built seperately to allow for flexibility and ease of use. The two parts are:

  • The Model
  • The Schema

The Model

The model is the part of the ORM that allows you to interact with the database tables. It allows you to perform operations such as insertion, updating, querying, and deletion. To use the model, you need to create a new instance of the model class.

    use PixelSequel\Model\Model;

    new Model (
        dbname: 'pixel_sequel',
        username: 'root',
        password: '',
        dbhost: 'localhost'
    );

By Default, the following values are set:

  • username: 'root'
  • password: ''
  • dbhost: 'localhost'

In a development environment, you can just pass the dbname as the only parameter to the model class.

    use PixelSequel\Model\Model;

    new Model (
        dbname: 'pixel_sequel'
    );

Inserting Data

To insert data, you just need to call the Insert static method. Note that the Model instance does not need to be assigned to a variable as the methods will infer the connection from the instantiated object.

    use PixelSequel\Model\Model;

    new Model (
        dbname: 'pixel_sequel'
    );

    Model::Insert(

        table: 'users',

        data: [
            'name' => 'John Doe',
            'email' => '[email protected]'
        ]
    );

The keys of the data arrays must be valid column names in the table. The corresponding values are the values to be inserted into the table. In upcoming versions, the ORM will be able to automatically infer the column names from the table and validate the data before insertion.

Reading Data

Here you basically need to just call the All method. The method can take a variety of parameters to filter the data you want to retrieve.

    use PixelSequel\Model\Model;

    new Model (
        dbname: 'pixel_sequel'
    );

    $users = Model::All(

        table: 'users',

        where: [
            'name' => 'John Doe'
        ]

        where_like: [
            'email' => 'gmail'
        ]

        order_by: 'id',
        order: 'DESC',

        limit: 10
    );
  • All the parameters are:
    table: The table to read from
    where: An associative array of the column names and their values to filter the data using the where clause
    where_like: An associative array of the column names and their values to perform searches
    order_by: The column to order the data by
    order: The order to use. Either 'ASC' or 'DESC'
    limit: The number of records to retrieve
    json: A boolean value to determine if the data should be returned as a json string or an array

The method returns an object of the data retrieved. You can then loop through the object to get the data. If you set the limit to 1, you would need to select the zeroth index of the object to get the data. Typically one of the key goals while developing this was to make it that a single function does all the select functionality. There are other select methods but ignore them as they are not well written and will be removed in future versions.

Updating Data

The update method is basically a replica of the Insert method, However the parameter type to identify the row and its value must be passed in

    use PixelSequel\Model\Model;

    new Model (
        dbname: 'pixel_sequel'
    );

    Model::Update(

        table: 'users',
        param_t: 'id'
        param_n: 1,
        data: [
            'name' => 'John Doe',
            'email' => '[email protected]'
        ]
    );

param_t is the parameter type, typically a column name. param_n is the value of the parameter type.

Deleting Data

The Delete method is used to delete data from the database. It takes in the table name and the parameter type and value to identify the row to delete.

    use PixelSequel\Model\Model;

    new Model (
        dbname: 'pixel_sequel'
    );

    Model::Delete(

        table: 'users',
        param_t: 'id'
        param_n: 1
    );

The Schema

The schema is the part of the ORM that allows you to interact with the database tables. It allows you to perform operations such as creating, updating, and deleting tables. To use the schema, you need to create an instance of the model class and pass the database connection to the schema class. Note that the Model instance does not need to be assigned to a variable and the schema as well

    use PixelSequel\Model\Model;
    use PixelSequel\Schema\Schema;

    new Model (
        dbname: 'pixel_sequel'
    );

    new Schema (
        Model::Connection()
    );

The connection can be checked by calling the Connected method on the model class. The method returns a boolean value.

    use PixelSequel\Model\Model;
    use PixelSequel\Schema\Schema;

    new Model (
        dbname: 'pixel_sequel'
    );



    if (Model::Connected())
    {
        new Schema (
          Model::Connection()
        );

        echo 'Connected';
    }
    else
    {
        echo 'Not Connected';
    }

Creating Tables

Once the connection is established, you can create tables by calling the Create method on the schema class. The method takes in the table name and an associative array of the column names and their data types.

    use PixelSequel\Model\Model;
    use PixelSequel\Schema\Schema;

    new Model (
        dbname: 'pixel_sequel'
    );

    new Schema (
        Model::Connection()
    );

    Schema::Create (
        table: 'pxtest',
        structure: [
            "id" => [
                "type" => "int",
                "length" => 11,
                "primary_key" => true
            ],

            "username" => [
                "type" => "varchar",
                "length" => 11,
                "null" => false
            ]

        ]
    );

The keys of the structure array must be valid column names in the table. The corresponding values are associative arrays of the column data types and their properties. The properties are:

    type: The data type of the column
    length: The length of the column
    primary_key: A boolean value to determine if the column is a primary key
    null: A boolean value to determine if the column can be null
    auto_increment: A boolean value to determine if the column is auto increment

Altering Tables

The Alter method is used to alter tables. It takes in three parameters: the table name, the column name, and what to set

    use PixelSequel\Model\Model;
    use PixelSequel\Schema\Schema;

    new Model (
        dbname: 'pixel_sequel'
    );

    new Schema (
        Model::Connection()
    );

    Schema::Alter (
        table: 'pxtest',
        column: 'username'
        set: "int(255) NOT NULL"
    );

Dropping Tables

The Drop method is used to drop tables. It takes in the table name as a parameter.

    use PixelSequel\Model\Model;
    use PixelSequel\Schema\Schema;

    new Model (
        dbname: 'pixel_sequel'
    );

    new Schema (
        Model::Connection()
    );

    Schema::Drop (
        table: 'pxtest'
    );

To disconnect from the database, you can call the Disconnect method on the model class.

    use PixelSequel\Model\Model;
    use PixelSequel\Schema\Schema;

    new Model (
        dbname: 'pixel_sequel'
    );

    new Schema (
        Model::Connection()
    );

    Model::Disconnect();

Upcoming Features

  • Validation of data before insertion
  • Automatic inference of column names from the table
  • More robust select methods
  • More robust update methods
  • More robust delete methods
  • More robust create methods
  • Elimination of the key value syntax

Contributions

Contributions are welcome. You can contribute by forking the repository and making a pull request. You can also open an issue if you find any bugs or have any feature requests.

About

A Lightweight, easy to use PHP ORM for mysql databases. Installable via composer

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published