Example

Install requests as an example.

$ pip install requests

1. define data layer accessor, and writen access structure ```python from marguerite import AbstractStructure, AbstractAccessor, Order from marguerite.accessors import bind

class Accessor(AbstractAccessor): def prepare(self, name, value): order = self.structure.get_order(name) return bind(order, value)

def create(self, name, value):
    order = self.prepare(name, value)
    return requests.post(order).json()

def get(self, name, value={}):
    order = self.prepare(name, value)
    return requests.get(order).json()

class UserStructure(AbstractStructure): accessor = Accessor

orders = Order(
    user = "https://example.com/users/:id",
    create = "https://example.com/users/:id?=username=:username"
)

```

2. get data layer accessor object ```python from marguerite import Marguerite

marguerite = Marguerite() accessor = marguerite.get_accessor(“path.to.UserStructure”) ```

3. fetch data ```python # execute get logic result = accessor.get(“user”, { “id”: 1 }) print(result) # {“id”: 1, “username”: “john”…}

SQLAlchemy

$ pip install SQLAlchemy MySQL-python

1. create database

   mysql> create database marguerite;
   Query OK, 1 row affected (0.00 sec)

2. define database structure ```python from marguerite import Order from marguerite.accessors.sql import SQLAlchemyAccessor from marguerite.structures.sql import SQLAlchemyStructure

class User(SQLAlchemyStructure): struct = { “id”: int(), “name”: str(), “email”: str(), }

orders = Order(
    create_table = """
        CREATE TABLE IF NOT EXISTS __table__(
          id int(11) unsigned NOT NULL AUTO_INCREMENT,
          name varchar(255) NOT NULL DEFAULT '',
          PRIMARY KEY (id)
        ) ENGINE=InnoDB CHARSET=utf8;
    """,

    drop_table = """
        DROP TABLE IF EXISTS __table__
    """,

    insert = """
        INSERT INTO
            __table__(name)
        VALUES
            (:name)
    """,

    select = """
        SELECT
            *
        FROM
            __table__
        WHERE
            id = :id
    """,

    find = """
        SELECT
            *
        FROM
            __table__
        WHERE
            id in (:id1, :id2)
    """
)

```

3. get database accessor object ```python from marguerite import Marguerite

engine = create_engine(“mysql+mysqldb://root:@localhost:3309/marguerite”)

marguerite = Marguerite(engine) accessor = marguerite.get_accessor(“path.to.User”) ```

4. create table

   accessor.execute("create_table")

5. check also

   mysql> use marguerite
   Database changed
   mysql> show tables;
   +----------------------+
   | Tables_in_marguerite |
   +----------------------+
   | user                 |
   +----------------------+

6. fetch data ```python # insert record at user table accessor.execute(“insert”, {“name”: “john”})