Method parse

src/connectors/sqlite/index.ts:41–82

(dsn: string, config?: ConnectorConfig)

 */
class SQLiteDSNParser implements DSNParser {
  async parse(dsn: string, config?: ConnectorConfig): Promise<{ dbPath: string }> {
    // Basic validation
    if (!this.isValidDSN(dsn)) {
      const obfuscatedDSN = obfuscateDSNPassword(dsn);
      const expectedFormat = this.getSampleDSN();
      throw new Error(
        `Invalid SQLite DSN format.\nProvided: ${obfuscatedDSN}\nExpected: ${expectedFormat}`
      );
    }

    try {
      // Use SafeURL helper to handle special characters properly
      const url = new SafeURL(dsn);
      let dbPath: string;

      // Handle in-memory database
      if (url.hostname === "" && url.pathname === "/:memory:") {
        dbPath = ":memory:";
      }
      // Handle file paths
      else {
        // Get the path part, handling both relative and absolute paths
        if (url.pathname.startsWith("//")) {
          // Unix absolute path: sqlite:///path/to/db.sqlite
          dbPath = url.pathname.substring(2); // Remove leading //
        } else if (url.pathname.match(/^\/[A-Za-z]:\//)) {
          // Windows absolute path: sqlite:///C:/path/to/db.sqlite
          // URL parser adds leading slash to drive letter paths, so strip it
          dbPath = url.pathname.substring(1);
        } else {
          // Relative path: sqlite://./path/to/db.sqlite
          dbPath = url.pathname;
        }
      }

      return { dbPath };
    } catch (error) {
      throw new Error(
        `Failed to parse SQLite DSN: ${error instanceof Error ? error.message : String(error)}`
      );
    }
  }

  getSampleDSN(): string {
    return "sqlite:///path/to/database.db";