pika

ORM-like SQL builder inspired by kayak/pypika

---

Notice of Deprecation

This repository contains the original code for pika, which was developed by CIQ as a proof of concept (POC). It is intended solely as an illustrative example and is provided as-is for reference purposes only.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

By using this software, you acknowledge and agree to these terms.

---

Features

• Any feature supported by sqlx
• Support for AIP-160 filtering
• Utilities to help with AIP-132 for List calls
• Support for determining filters based on Protobuf messages
• Automatically selecting columns in struct
• Count, Get, All, Create, Update, Delete and more.
• Support for simple joins

Example

Simple connect and Get

package main

import (
 "go.ciq.dev/pika"
 "log"
)

type User struct {
 PikaTableName string `pika:"users"`
 ID            int64  `db:"id" pika:"omitempty"`
 Name          string `db:"name"`
}

func main() {
 psql, _ := pika.NewPostgreSQL("postgres://postgres:postgres@localhost:5432/test")
 args := pika.NewArgs()
 args.Set("id", 1)
 qs := pika.Q[User](psql).Filter("id=:id").Args(args)
 user, _ := qs.Get()
 
 log.Println(user)
}

AIP-160

package main

import (
 "go.ciq.dev/pika"
 "log"
)

type Article struct {
 PikaTableName string    `pika:"users"`
 ID            int64     `db:"id" pika:"omitempty"`
 CreatedAt     time.Time `db:"created_at" pika:"omitempty"`
 Title         string    `db:"title"`
 Body          string    `db:"body"`
}

func main() {
 psql, _ := pika.NewPostgreSQL("postgres://postgres:postgres@localhost:5432/test")

 qs := pika.Q[Article](s.db)
 // Get the following articles
 //   * The title MUST contain Hello and the body MUST contain World
 //   * If the above is not match, the article MUST be created before 2023-07-30
 qs, err := qs.AIP160(`(title:"Hello" AND body:"World") OR (created_at < 2023-07-30T00:00:00Z)`, pika.AIPFilterOptions{})
 if err != nil {
  return nil, err
 }

 rows, err := qs.All()
 if err != nil {
  return nil, err
 }

 log.Println(rows)
}