mirror of
https://github.com/featurebasedb/featurebase.git
synced 2026-08-28 10:54:59 +00:00
37ee6ea482
* stub out a test framework for fbsql * Introduce fbsql integration test framework. This also adds support for `pset location` to set the geo location (i.e. time zone) in which timestamps should be displayed. And it adds support for comments (lines starting with `--`) in the line reader/splitter. * Replace Stdin and Stderr with setters and un-export them
45 lines
2.4 KiB
Text
45 lines
2.4 KiB
Text
// Show databases now that we have set org.
|
|
SEND:SHOW DATABASES;
|
|
EXPECT:+-----+------+-------+------------+------------+------------+-------+-------------+
|
|
EXPECT:| _id | name | owner | updated_by | created_at | updated_at | units | description |
|
|
EXPECT:+-----+------+-------+------------+------------+------------+-------+-------------+
|
|
EXPECT:+-----+------+-------+------------+------------+------------+-------+-------------+
|
|
EXPECT:
|
|
|
|
// Create db1.
|
|
SEND:CREATE DATABASE db1 WITH UNITS 1;
|
|
EXPECT:
|
|
|
|
// List databases via SHOW DATABASES.
|
|
SEND:SHOW DATABASES;
|
|
EXPECT:+--------------------------------------+------+-------+------------+----------------------+----------------------+-------+-------------+
|
|
EXPECT:| _id | name | owner | updated_by | created_at | updated_at | units | description |
|
|
EXPECT:+--------------------------------------+------+-------+------------+----------------------+----------------------+-------+-------------+
|
|
EXPECTCOMP:WithFormat:| {uuid} | db1 | | | {timestamp} | {timestamp} | 1 | |
|
|
EXPECT:+--------------------------------------+------+-------+------------+----------------------+----------------------+-------+-------------+
|
|
EXPECT:
|
|
|
|
// List databases via SHOW DATABASES.
|
|
SEND:\l
|
|
EXPECT:+--------------------------------------+------+-------+------------+----------------------+----------------------+-------+-------------+
|
|
EXPECT:| _id | name | owner | updated_by | created_at | updated_at | units | description |
|
|
EXPECT:+--------------------------------------+------+-------+------------+----------------------+----------------------+-------+-------------+
|
|
EXPECTCOMP:WithFormat:| {uuid} | db1 | | | {timestamp} | {timestamp} | 1 | |
|
|
EXPECT:+--------------------------------------+------+-------+------------+----------------------+----------------------+-------+-------------+
|
|
EXPECT:
|
|
|
|
// Check database connection.
|
|
SEND:\c
|
|
EXPECT:You are not connected to a database.
|
|
|
|
// Try connecting to an invalid database.
|
|
SEND:\c invalid
|
|
EXPECT:executing meta command: invalid database: invalid
|
|
|
|
// Try connecting with too many arguments.
|
|
SEND:\c db1 extra
|
|
EXPECT:executing meta command: meta command 'connect' takes zero or one argument
|
|
|
|
// Connect to a database.
|
|
SEND:\c db1
|
|
EXPECTCOMP:WithFormat:You are now connected to database "db1" ({uuid}).
|