joe-re / sql-language-server

SQL Language Server
MIT License
695 stars 64 forks source link

Difficulty setting up Sqlite completion with coc.nvim #239

Open znoble360 opened 10 months ago

znoble360 commented 10 months ago

I'm trying to set this up for coc.nvim but I'm not able to figure out why I'm not getting any completion. I want to be able to see things like INSERT and CREATE TABLE in my tab completion options but I'm just not seeing that. Here is my coc-settings.json:

{   
    "languageserver": {
        "sql": {
            "command": "sql-language-server",
            "args": ["up", "--method", "stdio"],
            "filetypes": ["sql"],
            "settings": {
                "sqlLanguageServer": {
                    "connections": [
                        {
                            "name": "sqlite3-project",
                            "adapter": "sqlite3",
                            "filename": "/home/znoble360/nawctsd/seaorm/db/root",
                            "projectPaths": ["/home/znoble360/nawctsd/seaorm/"]
                        }
                    ],
                    "lint": {
                        "rules": {
                            "align-column-to-the-first": "error",
                            "column-new-line": "error",
                            "linebreak-after-clause-keyword": "off",
                            "reserved-word-case": ["error", "upper"],
                            "space-surrounding-operators": "error",
                            "where-clause-new-line": "error",
                            "align-where-clause-to-the-first": "error"
                        }
                    }
                }
            }
        }
    }
}