# Copyright (c) reifydb.com 2025
# This file is licensed under the MIT
# Test command execution (schema creation and data insertion)
admin 'create namespace test'
admin 'create table test::simple{id: int4, name: text}'
command 'INSERT test::simple [{ id: 1, name: "Alice" }]'
query 'from test::simple'
---
> +---------+-------------+-----------+
> | id | namespace | created |
> +---------+-------------+-----------+
> | 16385 | test | true |
> +---------+-------------+-----------+
>
> +---------+-------------+----------+-----------+
> | id | namespace | table | created |
> +---------+-------------+----------+-----------+
> | 16385 | test | simple | true |
> +---------+-------------+----------+-----------+
>
> +-------------+----------+------------+
> | namespace | table | inserted |
> +-------------+----------+------------+
> | test | simple | 1 |
> +-------------+----------+------------+
>
> +-----------+----------------------------------+----------------------------------+------+---------+
> | #rownum | #created_at | #updated_at | id | name |
> +-----------+----------------------------------+----------------------------------+------+---------+
> | 1 | 1970-01-01T00:00:00.000000000Z | 1970-01-01T00:00:00.000000000Z | 1 | Alice |
> +-----------+----------------------------------+----------------------------------+------+---------+
>