Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
import '../../tooling/just/database.just'
mod sqlx '../../tooling/just/sqlx.just'
force_drop_db:
echo "y" | just sqlx::drop_db {{ DATABASE_URL }}
test:
cargo test
check:
SQLX_OFFLINE=true cargo check
create_db:
just sqlx::create_db {{ DATABASE_URL }}
# Prepare DB for offline cache for docker image
prepare_db:
just sqlx::prepare_db {{ DATABASE_URL }}
# Prepare DB for offline cache against dev database
prepare_db_dev:
just sqlx::prepare_db $(../../tooling/scripts/rds_database_url.sh macro-db-dev macrodb-password-dev macrodb)
migrate_db:
just sqlx::migrate_db {{ DATABASE_URL }}
drop_db *FLAGS:
just sqlx::drop_db {{ DATABASE_URL }} {{ FLAGS }}
setup:
just sqlx::setup {{ DATABASE_URL }}
setup_prepare:
just sqlx::setup_prepare {{ DATABASE_URL }}
reset_db:
just sqlx::reset_db {{ DATABASE_URL }}
check_db_dev:
just sqlx::check_db $(../../tooling/scripts/rds_database_url.sh macro-db-dev macrodb-password-dev macrodb)
check_db_prod:
#!/usr/bin/env bash
echo -e "\033[33mChecking pending migrations on PRODUCTION database...\033[0m"
just sqlx::check_db $(../../tooling/scripts/rds_database_url.sh macro-db-prod macrodb-password-prod macrodb)
migrate_db_dev:
DATABASE_URL=$(../../tooling/scripts/rds_database_url.sh macro-db-dev macrodb-password-dev macrodb) sqlx migrate run
migrate_db_prod:
#!/usr/bin/env bash
echo -e "\033[31mWARNING: You are about to run migrations on the PRODUCTION database!\033[0m"
echo -n "Are you sure you want to continue? [y/N] "
read -r response
if [[ "$response" =~ ^[Yy]$ ]]; then
echo "Running production migrations..."
DATABASE_URL=$(../../tooling/scripts/rds_database_url.sh macro-db-prod macrodb-password-prod macrodb) sqlx migrate run
else
echo "Migration cancelled."
fi