Tyler Band

"id" is a jsonapi reserved field - tables that use "id" as primary key do not return this attribute in the results

2

The solution is to fix the CLI to change the name to "Id" Id = Column("id", Integer, primary_key=True)

elif isinstance(each_column.type, sqlalchemy.sql.sqltypes.DECIMAL): default = Decimal(default) elif isinstance(each_column.type, sqlalchemy.sql.sqltypes.NUMERIC): default = Decimal(default)

"interval" interval ,"interval(0)" interval(0) ,"interval(1)" interval(1) ,"interval(2)" interval(2) ,"interval(3)" interval(3) ,"interval(4)" interval(4) ,"interval(5)" interval(5) ,"interval(6)" interval(6)); see stress_postgrsql.sql

The GET returns various values but these do not display in Admin UI See ApiLogicServer/ApiLogicServer-dev/org_git/ApiLogicServer-src/tests/test_databases/postgres_databases/stress_postgresql.sql Many other types do not display as well -

from sqlalchemy.dialects.postgresql import ARRAY bigint__ = Column('bigint[]', ARRAY(BigInteger(),as_tuple=True, dimensions=1)) This fixes the error but the Admin UI does not display the array (need to add as_tuple, dimensions) curl http://localhost:5656/api/STRESSBIGINTARR {...

Several MySQL Field Types fail to display in Admin UI

1

Using the MySQL "stress" tables (now in the Docker mysql container) - These do not display any data in Admin UI - the GET shows that the values are returned....

1. Use 9.4.9 2. ApiLogicServer create --project_name=foo --db_url=BudgetApp 3. start app 4. Post curl -X 'POST' \ 'http://localhost:5656/api/Budget/' \ -H 'accept: application/vnd.api+json' \ -H 'Content-Type: application/json' \ -d '{ "data":...

Working with Docker/K8 we need the password to be encrypted (applies to authentication as well). If the URI is not passed - look for the parts and assemble URI after...

I have a very large database with lots of data and lots of parent and child relationships. What I notice when running the admin UI is that it will open...

Stress Postgresql Yaml uses database name and not model column name

5

STRESSBIT: attributes: - label: ' description*' name: description search: true sort: true - name: bit - name: bit(1) - name: bit(2) - name: bit(3) - name: bit(4) class STRESSBIT(SAFRSBase, Base):...