Open source AI coding agent. Designed for large projects and real world tasks.
Go aiai-agentsai-developer-toolsai-toolsclicommand-linedeveloper-toolsgitgolanggpt-4llmopenaipolyglot-programmingterminalterminal-basedterminal-ui
package db
import (
"fmt"
"github.com/jmoiron/sqlx"
)
func ProjectExists(orgId, projectId string) (bool, error) {
var count int
err := Conn.QueryRow("SELECT COUNT(*) FROM projects WHERE org_id = $1 AND id = $2", orgId, projectId).Scan(&count)
if err != nil {
return false, fmt.Errorf("error checking if project exists: %v", err)
}
return count > 0, nil
}
func CreateProject(orgId, name string, tx *sqlx.Tx) (string, error) {
var projectId string
err := tx.QueryRow("INSERT INTO projects (org_id, name) VALUES ($1, $2) RETURNING id", orgId, name).Scan(&projectId)
if err != nil {
return "", fmt.Errorf("error creating project: %v", err)
}
return projectId, nil
}