metatoaster

use leptos::prelude::*;
use leptos_meta::{MetaTags, *};
use leptos_router::{
    components::{A, Routes, Route, Router, ParentRoute},
    hooks::use_params,
    nested_router::Outlet,
    params::Params,
    path,
    SsrMode,
    StaticSegment,

metatoaster

/*
[dependencies]
chrono = "0.4.26"
*/
use crate::demo::in_the_future;

pub fn main() {
    let dt = chrono::Utc::now();
    println!("{dt} is in the future: {}", in_the_future(dt));
}

metatoaster

# This is the complete code for the StackOverflow answer:
# https://stackoverflow.com/a/24947583
from typing import List
from typing import Literal
from typing import get_args
from sqlalchemy import Enum
from sqlalchemy import ForeignKey
from sqlalchemy import String
from sqlalchemy import and_
from sqlalchemy import create_engine

metatoaster

# Complete code for the answer at https://stackoverflow.com/a/67578848
from sqlalchemy import ForeignKey, String
from sqlalchemy import create_engine, select
from sqlalchemy.orm import DeclarativeBase, Mapped, Session
from sqlalchemy.orm import mapped_column, relationship
from sqlalchemy.orm import contains_eager

class Base(DeclarativeBase):
    pass

metatoaster

// Compare between
// https://play.rust-lang.org/?version=stable&mode=debug&edition=2021&gist=74eaa1906a58b5daad47c210241143a6
// and
// https://play.rust-lang.org/?version=beta&mode=debug&edition=2021&gist=74eaa1906a58b5daad47c210241143a6

struct Thing(String);
struct View<'a>(&'a str);

impl<'a> From<&'a Thing> for View<'a>
{

metatoaster

use std::collections::HashMap;

struct ListOfUsers(Vec<(String, String)>);  // (User, Email)
struct UserToEmail<'a>(HashMap<&'a str, &'a str>);
struct EmailToUser<'a>(HashMap<&'a str, &'a str>);

impl<'a> From<&'a ListOfUsers> for UserToEmail<'a> {
    fn from(value: &'a ListOfUsers) -> Self {
        Self(value.0.iter()
            .map(|(u, e)| (u.as_ref(), e.as_ref()))

metatoaster

#[derive(Debug)]
struct EmailAddr(String);    // e.g. [email protected]
#[derive(Debug)]
struct Domain<'a>(&'a str);  // a slice onward from the @ symbol of the above

impl<'a> From<&'a EmailAddr> for Domain<'a> {
    fn from(value: &'a EmailAddr) -> Self {
        Self(&value.0[value.0.find('@').unwrap_or(0)..])
    }
}

metatoaster

# pip install SQLAlchemy==2.0.12 psycopg2==2.9.6
import random
from sqlalchemy import Column, Integer, String
from sqlalchemy import create_engine
from sqlalchemy import select
from sqlalchemy.orm import declarative_base, sessionmaker, scoped_session

Base = declarative_base()

class Entity(Base):

metatoaster

SQLAlchemy mixin example with bulk event assignment

This is a full example that shows how mixin classes can be implemented for use with SQLALchemy in a way that also automatically apply event listeners to appropriate subclasses of a given mixin class. The use case started with this question on StackOverflow which asked about how the before_delete mapper event can be used, which lead down the path of exploration that lead to this more generic skeleton on how this might be achieved in a more generic manner.

The following is an example run of the associated Python code:

INFO:sqlalchemy.engine.Engine:SELECT entity.id AS entity_id, entity.field_a AS entity_field_a, entity.field_b AS entity_field_b, entity.created_at AS entity_created_at, entity.deleted_at AS entity_deleted_at 
FROM entity
INFO:sqlalchemy.engine.Engine:[generated in 0.00009s] ()

metatoaster

/* 
[dependencies]
rand = "0.8"
*/ 
use rand::seq::SliceRandom;
use rand::thread_rng;
use std::collections::HashMap;

fn main() {
    let w: i16 = 8;