database.nim 762 B

123456789101112131415161718192021222324252627282930
  1. import std/os
  2. import std/strutils
  3. import db_connector/db_postgres
  4. import allographer/connection
  5. when defined(release):
  6. import std/cpuinfo
  7. let maxConnections =
  8. when defined(release):
  9. (getEnv("DB_MAX_CONNECTION").parseInt div countProcessors()) - 2
  10. else:
  11. 95
  12. echo "maxConnections: ",maxConnections
  13. let rdb* = dbopen(
  14. PostgreSQL, # SQLite3 or MySQL or MariaDB or PostgreSQL
  15. getEnv("DB_DATABASE"),
  16. getEnv("DB_USER"),
  17. getEnv("DB_PASSWORD"),
  18. getEnv("DB_HOST"),
  19. getEnv("DB_PORT").parseInt,
  20. maxConnections,
  21. getEnv("DB_TIMEOUT").parseInt,
  22. getEnv("LOG_IS_DISPLAY").parseBool,
  23. getEnv("LOG_IS_FILE").parseBool,
  24. getEnv("LOG_DIR"),
  25. )
  26. let stdRdb* = open(getEnv("DB_HOST"), getEnv("DB_USER"), getEnv("DB_PASSWORD"), getEnv("DB_DATABASE"))