OpenAI's Codex Security CLI and TypeScript SDK for finding, validating, and fixing security vulnerabilities. npm: https://www.npmjs.com/package/@openai/codex-security
TypeScript ai-securityapplication-securityclicode-scanningcodexcodex-securitycybersecuritydevsecopsnodejsnpmopenaisdksecuritytypescriptvulnerability-scanning
"""Process-local order data for the sample API."""
import sqlite3
TOKENS = {
"demo-acme": "acme",
"demo-beacon": "beacon",
"demo-cedar": "cedar",
}
ORDERS = [
("A-101", "acme", "west", "Acme-only notebook", 1200),
("A-102", "acme", "east", "Acme-only pen", 300),
("B-201", "beacon", "west", "Beacon-only lamp", 4200),
("B-202", "beacon", "east", "Beacon-only chair", 7800),
("C-301", "cedar", "west", "Cedar-only mug", 900),
("C-302", "cedar", "east", "Cedar-only desk", 11900),
]
def create_database():
database = sqlite3.connect(":memory:", check_same_thread=False)
database.row_factory = sqlite3.Row
database.execute(
"""
CREATE TABLE orders (
id TEXT PRIMARY KEY,
tenant_id TEXT NOT NULL,
region TEXT NOT NULL,
description TEXT NOT NULL,
amount_cents INTEGER NOT NULL
)
"""
)
database.executemany(
"INSERT INTO orders VALUES (?, ?, ?, ?, ?)",
ORDERS,
)
database.commit()
return database
def list_orders(database, tenant_id):
return database.execute(
"""
SELECT id, tenant_id, region, description, amount_cents
FROM orders WHERE tenant_id = ? ORDER BY id
""",
(tenant_id,),
).fetchall()
def lookup_order(database, order_id):
return database.execute(
"""
SELECT id, tenant_id, region, description, amount_cents
FROM orders WHERE id = ?
""",
(order_id,),
).fetchone()