Mysqllib

Simple mysql database

Connect

connect(
        user: str,
        password: str,
        database: str,
        host: str='127.0.0.1',
        port: int=3306
)

Fetch one

fetchone(query, args=None) -> Optional[dict]

Fetch all

fetchall(query, args=None) -> Optional[list]:

Execute

execute(query, args=None) -> bool:

find

def find(
        table: str,
        conditions: Dict[str, Union[str, List]] = None,
        columns='*',
        joins: Optional[List[Tuple[str, str, str]]] = None,
        order_by=None
) -> dict

findall

def findall(
        table: str,
        conditions: Dict[str, Union[str, List]] = None,
        columns='*',
        joins: Optional[List[Tuple[str, str, str]]] = None,
        group_by=None,
        order_by=None,
        limit=None
) -> list

update

def update(
        table: str,
        data: Dict[str, any],
        conditions: Optional[Dict[str, any]] = None
) -> bool

delete

def delete(
        table: str,
        conditions: Optional[Dict[str, any]] = None
)

insert

def create(
        table: str,
        data: Dict[str, any]
) -> bool

Mirations

Run

import mysqllib.migration

mysqllib.migration.run_migration('./path/to/migration/directory/')