edXOps Productivity Tools and Apps :: Production-like Projects

Tools outcomes is neccessary for any works, all it takes is the specific tools!

Most essential everyday design and development tasks can be tackled with productivity tools or apps, such as tasks in designing a database, creating a collection of SQL scripts, or generating a set of data files that you’ve collected, all of these tasks and more are easy to do thanks to productivity tools and software.

In the Software development life cycle, if you don’t have productivity tools or software, it’s hard to imagine the steps and the time you would need to go through create these tasks on your responsibility.

edXOps Foundation has developed many best productivity tools that you can start using in Production-like Projects right now.

Explore Skills Chain »

Data Productivity Tools

Table Schema Generator | SQL-Based Scripts Executor | SQL-Based CRUD Scripts Creator | SQL-Based Code Scanner | Table Schema Scanner

Table Schema Generator

Table Schema Generator Tool uses to create SQL-Based DDL (Data Definition Language) scripts from Physical Data Modelling Diagrams which are implemented under the Schema Excel Template files.

Schema files are named and saved under Excel format as .xls or .xlsx
Structure of tables is designed and described by the Japanese or English language.
Scripts are generated as SQL-Based such as T-SQL or PL/SQL or MySQL-SQL.

Schema Generator »Template »

SQL-Based Scripts Executor

SQL-Based Scripts Executor Tool uses to execute SQL-Based scripts (.sql) from the physical path in a specific database server.

SQL-Based Script files are named and saved under SQL format as .sql or .txt
SQL Syntax is defined by SQL-Based language (T-SQL, PL/SQL, MySQL-SQL).
Provide Connection String for connecting to a specific database platform.

SQL-Based Scripts Executor »

SQL-Based CRUD Scripts Creator

SQL-Based CRUD Scripts Creator Tool uses to create CRUD stored procedures (INSERT/SELECT/UPDATE/DELETE) of tables in a specific database server to SQL-Based script files (.sql).

SQL-Based Script files are named and saved under SQL format as .sql or .txt
Stored Procedure name is defined as the same name as the table with or w/o prefix and suffix.
Stored Procedure with or w/o implementation of the TRY CATCH block.
Stored Procedure with or w/o implementation of the TRANSACTION.
CRUD Stored Procedure contains three types:
- SQL-based Single CRUD Stored Procedures.
- SQL-based Bulk XML CRUD Stored Procedures.
- SQL-based Bulk JSON CRUD Stored Procedures.

CRUD Scripts Creator »

SQL-Based Code Scanner and Validator (Test Coverage)

SQL-Based Code Scanner and Validator Tool use to scan and validate (TEST) procedures (stored procedures and user-defined functions) of a specific database server. The software will be used as an essential tool to test coverage SQL-Based Code then notify the wrong logic and mismatched expectation of stored procedures and user-defined functions.

Scan SQL-Based procedures in a specific relational database.
Validate the business logic of SQL-Based procedures.
Excecute and Get the number of ResultSet and Rows.
Enable to load the test data file of procedures.

SQL Code Validator »

Table Schema Scanner

Table Schema Scanner Tool uses to scan table structure and find dependency procedures (stored procedures and user-defined functions) of a specific table in the database server. The software will be used as an essential tool to show the columns, indexes, primary keys, foreign keys, computed columns, not null columns, and find dependency procedures or user-defined functions.