query-builder

Setup

Setup a project with sqlite using the following up.sql:

create table example (
    id integer not null primary key,
    calculated integer generated always as (id*2)
);

Versions

• Rust: 1.56.0 nightly
• Diesel: 1.4.7
• Database: Sqlite
• Operating System Linux

Feature Flags

• diesel: sqlite

Problem Description

Sqlite does

Describe the bug
I created a component in QueryBuilder.tsx by taking the example from the README with some little cleanup. It all worked except the CSS import causes an issue. Is there a solution that is supported in tsx or a hosted css file that can be used?

./node_modules/react-awesome-query-builder/lib/css/styles.css:1
.qb-drag-handler, .qb-draggable, .query-builder {
^

Synt

We have a basic test for piccolo asgi new:

https://github.com/piccolo-orm/piccolo/blob/master/tests/apps/asgi/commands/test_new.py

It can definitely be improved though. As a minimum, we should read the generated file contents, and use ast.parse(file_contents) to make sure the file is valid Python code. We use a similar approach here:

https://github.com/piccolo-orm/piccolo/blob/e0f04a4

The .returning() function currently only supports strings (which should be the target table's column names). In reality they can accept any expression and (returning) query.

This should be supported:

insert into bar (val) values (123) returning (select count(*) from bar), id, val || 'test'

which would equate to something like:

db.insertInto(bar).values({ val: 123 })