express-admin

• Change: the admin cli is no longer available
• Change: the admin is now exposed as an Express.js middleware only
• Change: config.json server key is no longer needed
• Change: config.json app was renamed to admin
• Change: config.json new required admin.settings config should be set the absolute path to your settings.json file
• New: config.json new admin.readonly flag replacing the -v cli argument
• New: config.json new admin.debug flag replacing the -l cli argument
• New: config.json new admin.favicon key to specify a path to a custom favicon.ico file to use
• New: config.json new admin.footer text and URL to use for the admin's footer
• New: config.json new admin.locale path to a custom locale file to use
• New: config.json new admin.session object to configure the underlying session middleware
• Change: users.json each user now contains just a name and pass fields as clear text

Resolves the security issues.

• Fixed Express Admin static files not being loaded correctly when the admin is embedded and NPM3 is used

See the session key in the Embedding Example.

• fix orignal select in place of chosen not showing up on mobile
• update chosen 1.2.0
• update datetimepicker to the latest master
• update to bootstrap/bootswatch 3.3.1

• fix missing join on filter by excluded mtm column in listview
• fix show only non empty mtm values in listview
• fix break cell text and fit table in viewport on many columnt in listview
• fix internationalize the dates in listview
• fix internationalize the dates in datetime picker
• fix AM/PM time bug https://github.com/simov/express-admin/pull/61
• feature add table filter in mainview https://github.com/simov/express-admin/pull/73
• feature try to use pg.js if pg is not found https://github.com/simov/express-admin/pull/65
• feature static sql views support https://github.com/simov/express-admin/issues/77
• migrate moment 2.8.3

• Feature Logical OR checkbox in listview filter
• Feature add pre list view event https://github.com/simov/express-admin/issues/58
• Features static select options as objects https://github.com/simov/express-admin/issues/60
• Feature Support multiple schemas for pg. Define schema per table to override the default one. https://github.com/simov/express-admin/issues/48
• Migrate bootstrap 3.2.0, bootswatch 3.2.0, chosen 1.1.0, datetimepicker 2.3.0
• Migrate Express4.4.4 https://github.com/simov/express-admin/pull/55
• Migrate Hogan 3.0.2
• Fix pg filter by boolean type
• Fix always use aliases when joining tables in listview https://github.com/simov/express-admin/issues/59
• Fix chosen select controls are hidden by default to improve performance
• Fix filter columns have default value set to null
• Fix sqlite string concat on null values
• Translation Korean translation https://github.com/simov/express-admin/pull/63
• Docs greatly improved events documentation

• feature
  • support for string primary keys
  • support for compound primary keys
  • support for number control type
• fix
  • dates are not stored inside the date controls of listview filter
  • mysql error when filtering by static control type
  • select input with static values - NULL is saved as string
  • pg custom schema name is not honored
• change
  • changed version of node-mysql to 2.2.0

Blob data types

Inside settings.json the control type for blob/bytea fields can be configured like this

{
    "file": true,
    "binary": true
}

This will add an input type=file control to the editview, but instead uploading the file to the upload folder, it will store it directly into the database.

Currently the support for blob fields is very basic, if you have any comments leave them in the issue tracker

Translations

• Russian https://github.com/simov/express-admin/pull/44
• Chinese https://github.com/simov/express-admin/pull/46

Bugfixes

• Reconnect mysql server on connection lost error - https://github.com/simov/express-admin/issues/43
• Session key for better embedding - https://github.com/simov/express-admin/issues/42
• Bugfix showing error/success message in listview when redirecting from editview (this was introduced in v1.1.8)

Install the SQLite bindings

Like with PostgreSQL you need to install the SQLite bindings separately

# SQLite only: run this inside the express-admin folder
$ npm install [email protected]

The module used is https://github.com/mapbox/node-sqlite3 and it's outlined inside the documentation as well http://simov.github.io/express-admin-site/#install

Creating new project

• When prompted for Database type: type sqlite
• When prompted for Database name: type the /absolute/path/to/your/database.sqlite

Auto incrementing primary keys

Since SQLite has its own build in auto incrementing id field called rowid you can configure your project to use them like this:

• add this id column definition inside your table's columns array

"columns": [
    {
        "verbose": "id",
        "name": "rowid",
        "control": {
            "text": true
        },
        "type": "int(11)",
        "allowNull": false,
        "defaultValue": null,
        "listview": {
            "show": false
        },
        "editview": {
            "show": false
        }
    },
    ...
]

• Inside the table key set the primary key to be the rowid of the table

"table": {
    "name": "...",
    "pk": "rowid",
    "verbose": "..."
}

Pull the latest examples from https://github.com/simov/express-admin-examples/ and see how it's done there

• Implemented event hooks: http://simov.github.io/express-admin-site/#events
  • preSave
  • postSave
• Fixed date formatting for timestamps inside the Listview
• Bugfix inside Mainview when only one custom app is available not configured as a view
• Improved German translation
• Added examples for pre-selecting a theme, showing images and customizing Many to Many label appearance inside the Listview: https://github.com/simov/express-admin-examples/tree/master/examples/custom/static

• Listview search filter
• Custom column ordering
• Fixed redirect to last active page in Listview after certain actions taken inside the Editview

There is a new option available for each table's listview key inside settings.json
http://simov.github.io/express-admin-site/#settingsjson

"table_name": {
    ...
    "listview": {
        "order": { ... },
        "page": 25,
        "filter": ["column_name1", "column_name2" ...]
    }
}

Add any table's column including oneToMany and manyToMany columns. Pull the latest examples from https://github.com/simov/express-admin-examples/ and take a look at the controls table to see how all currently available control types look like inside the Filter panel.

To expand the Filter panel click on the small icon next to the Listview's title.

All filtering options set inside the Filter panel are perceived through the entire user's session. Click on the Clear button at any time to clear the filtering options.

• migrated to Bootstrap/Bootswatch 3.0.3
• migrated to Bootstrap Datetimepicker - https://github.com/smalot/bootstrap-datetimepicker in place of jQuery UI Datepicker
• new controls: date, time, datetime, year, radio and static select - http://simov.github.io/express-admin-site/#example-column
• new controls example inside the examples repository
• example database for PostgreSQL inside the examples repository - https://github.com/simov/express-admin-examples/
• fixed quotes not being escaped inside string data types

• the selected value for many to many columns can be shown inside the listview like any other regular column: http://simov.github.io/express-admin-site/#many-to-many

"listview": {
    "show": true
}

• add new record button for each column inside the mainview
• bugfix for many to many with allow null when inserting

• the default location for file uploads is public/upload make sure you have rights to write there
• the upload folder location can be configured from the config.json file http://simov.github.io/express-admin-site/#configjson
• any regular text field can be configured to have a file control inside settings.json

"control": {
    "file": true
}

• fixed urls path bug in listview

• For now the https://github.com/brianc/node-postgres module is installed separately:

$ [sudo] npm install [-g] express-admin
# PostgreSQL only: run this inside the express-admin folder
$ npm install [email protected]

http://simov.github.io/express-admin-site/#install

• The PostgreSQL connection options are set through the pg key http://simov.github.io/express-admin-site/#configjson

• Updated to the latest version of express (3.4.4)
• Express Admin now can be embedded into existing expressjs application
• Breaking changes into the custom.json object structure

• Migrated to Bootstrap/Bootswatch 3
• Overall better support for mobile devices
• Updated to the latest version of chosen