{"id":44031,"library":"testx-postgres-keywords","title":"testx-postgres-keywords","description":"testx-postgres-keywords v2.1.2 extends the testx testing framework with Postgres database keywords. It allows executing SQL statements, comparing results, and saving results to test context. Requires testx ^2.5.0. Designed for end-to-end testing with Protractor. Differentiators: simple keyword-driven interface, connection string configuration, and support for expected results. Stable release with low update frequency.","status":"active","version":"2.1.2","language":"javascript","source_language":"en","source_url":"ssh://git@github.com/testxio/testx-postgres-keywords","tags":["javascript","testx","keywords","postgres","sql","database","db"],"install":[{"cmd":"npm install testx-postgres-keywords","lang":"bash","label":"npm"},{"cmd":"yarn add testx-postgres-keywords","lang":"bash","label":"yarn"},{"cmd":"pnpm add testx-postgres-keywords","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"peer dependency required to integrate keywords into testx framework","package":"testx","optional":false}],"imports":[{"note":"Library uses CommonJS require; ESM import not supported.","wrong":"import ... from 'testx-postgres-keywords'","symbol":"testx-postgres-keywords","correct":"require('testx-postgres-keywords')"},{"note":"No default export; use require() to load the module directly.","wrong":"","symbol":"keywords","correct":"testx.keywords.add(require('testx-postgres-keywords'))"}],"quickstart":{"code":"// Install: npm install testx-postgres-keywords --save\n// In Protractor config file:\nconst testx = require('testx');\ntestx.keywords.add(require('testx-postgres-keywords'));\n\n// Then in test scripts:\n// | execute sql | connection string | postgres://user:pass@localhost:5432/mydb |\n// |             | sql               | SELECT * FROM users WHERE id = 1          |\n// |             | expected result   | 1;John;john@example.com                    |","lang":"javascript","description":"Shows installation, keyword registration, and usage of execute sql keyword with connection string and expected result."},"warnings":[{"fix":"Consider migrating to modern testing frameworks like Playwright or Cypress.","message":"Deprecated: testx-postgres-keywords relies on testx framework which may not be actively maintained.","severity":"deprecated","affected_versions":">=2.0.0"},{"fix":"Use multiple execute sql calls if different databases are needed.","message":"Connection string parameter supports repeating arguments: false. Only one connection string per keyword call.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Trim whitespace in expected result strings.","message":"Expected result rows use newline delimiter, values separated by semicolon. Leading/trailing whitespace may cause mismatches.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'2.5.0':34 'allow':20 'compar':24 'configur':52 'connect':50 'context':31 'databas':17,69 'db':70 'design':35 'differenti':44 'driven':48 'end':38,40 'end-to-end':37 'execut':21 'expect':56 'extend':10 'framework':14 'frequenc':63 'interfac':49 'javascript':64 'keyword':4,8,18,47,66 'keyword-driven':46 'low':61 'postgr':3,7,16,67 'protractor':43 'releas':59 'requir':32 'result':25,28,57 'save':27 'simpl':45 'sql':22,68 'stabl':58 'statement':23 'string':51 'support':54 'test':13,30,41 'testx':2,6,12,33,65 'testx-postgres-keyword':1,5 'updat':62 'v2.1.2':9","created_at":"2026-06-05T17:02:38.746265+00:00","updated_at":"2026-06-05T17:02:38.746265+00:00","problems":[{"fix":"Run `npm install testx-postgres-keywords --save` from the project root.","cause":"Package not installed or not in node_modules.","error":"Cannot find module 'testx-postgres-keywords'"},{"fix":"Set postgresConnectionString in config file or as command-line argument, or provide connection string in keyword step.","cause":"No connection string provided and default parameter missing.","error":"Error: postgresConnectionString is not defined"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/testxio/testx-postgres-keywords#readme","github":"ssh://git@github.com/testxio/testx-postgres-keywords","docs":null,"changelog":null,"pypi":null,"npm":"testx-postgres-keywords","openapi_spec":null,"status_page":null,"smithery":null,"categories":["testing"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}