anjakammer / data2table Goto Github PK

The user should be able to load all items by ajax request, without page is refreshing

The user should be able, to import a new set of data by providing a csv file.
Think of using ajax requests to prevent page reload.

Functionalities:

• choose file
• ajax based loading
• upload file
• preview first 5 rows after upload
• fire import separatly
• delimiter default is comma, but can be provided
• dateformat (pattern) can be provided

Conditions:

• file should be a csv, txt or excel
  (http://php.net/manual/en/function.fgetcsv.php, https://gist.github.com/anjakammer/dbea481e5f77b219a52de57ecc960531)
• First row should contain property-names
• All values should get converted to datatype (if empty || None -> Default)

The user should be able to do see the following features at the dashboard:

• show meta infos of database (storage quota, number of tables, size)
• show all tables as tile with meta info
• go to a specific tables detail page #4
• create a new table #1 and #2

empty data are getting imported as a empty string, they do not trigger the default value

The user should be able to create new tables in the database which wordpress is currently running on.
The user should be able to give the following parameters:

• table name
• column name
• column data type
• default value of column
• if column can be null
• if column values must be unique

The user should be able to export the data as .csv
(http://php.net/manual/en/function.fputcsv.php)

Parse the create table statement to avoid sql injection.
https://github.com/greenlion/PHP-SQL-Parser

The User should be able to modify all rows in the table with CRUD Operations.
Think of using ajax requests to prevend page reload.

The user should be able to create new tables in the database which wordpress is currently running on.
The user should be able to give a sql create statement to do so.
Think of using ajax requests to prevend page reload.

The user should be able to view the table structure.

To get better UX, the functionalities and UI should be well designed.

use wordpress prefix plus plugin prefix.

The user should be able to make a content page with created tables. The querying is formed by using a widget which offeres filtering options.
With this feature, the user don't need to be a developer who could easily make WP Query on their own, pasting it into the template.

The user should be able to see the following features

• complete set of data as data table
• View database table structure