How to Add Filtering to Apigility

How to Add Filtering to Apigility

Setting Up Apigility This guide will be using the same project setup during my Apigility Entity & Mapper Tips article. The related github repo has been updated with the new source in this article. Create a Filters Class I found the best way to stay organized was to create a type of Helper Class called <ServiceName>Filters.…

Apigility Entity & Mapper Tips

Apigility Entity & Mapper Tips

Create a Simple Schema and Table To get us started, we’ll need a source of data for our service. I’m going to use IBM i DB2 for this example, since that is primarily what I work on. Below is SQL to define a simple table and populate it with some data. CREATE SCHEMA APIGILITY ;…

CentOS 7 + i3wm Quickstart Guide

CentOS 7 + i3wm Quickstart Guide

Most commands will need to be ran with super user permissions. Just prepend withsudo if any permissions errors occur. Download CentOS 7 Download the preferred version of CentOS. I suggest the “Everything” version for this tutorial. Install CentOS 7 Begin the installation process like any other Linux installation. Either through USB or Virtual Machine. Installation…

Pretty BASH Configuration with IBM i Helpers

Pretty BASH Configuration with IBM i Helpers

Making BASH Your Default Shell There are (at least) a couple of different ways to achieve having BASH on login. sshd_config – Globally (not recommended) This will make it so anyone that SSHs in will have BASH at login. More information can be found here Editsshd_config (usually found at/QOpenSys/QIBM/UserData/SC1/OpenSSH/etc/sshd_config) to have the following: # $OpenBSD: sshd_config,v…

Simple Git Practices on IBM i Without IBM Db2 Connect

Simple Git Practices on IBM i Without IBM DB2 Connect

The Problem Ideally, application development is separated into three environments: local (development), staging, and production. Staging and production would reside on the IBM i, while local is specific to each developer and would reside on the developer’s local development machine. In a perfect world, the developer would have a mock of the database on their…

Apigility with OAuth2 on IBM i

Apigility with OAuth2 on IBM i

Create the OAuth tables in DB2 These tables are created according to specifications from Zend Framework OAuth2. /** * Replace LIBRARY with the preferred library name. * Build OAuth tables for Apigility. * OAUTH_CLIENTS * OATUH_USERS * OAUTH_ACCESS_TOKENS * OAUTH_REFRESH_TOKENS * OAUTH_CODES * OAUTH_SCOPES * OAUTH_JWT * More details at https://github.com/zfcampus/zf-oauth2 */ /* BEGIN OAUTH_CLIENTS…