Skip to content

cosXsinX/DBTemplateHanlder-NetCore3

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DB Template Handler

This application aims to generate Data Access Layers agnosticly to the target language environment. To perform this purpose it will perform a jointure between three models

  • Database model -> A lightweight implementation of the database model which aggregate all the mandatory properties of the accessed database in order to implement a Data Access Layer
  • Templates -> Templates which are used to implement the data access layer and any other script related generation (as example : create table sql generation script templates)
  • Type mapping -> This is to define the mapping to perform between both environment accessing/accessed in order to implement the DAL

Pre beta binary distribution : windows-x64
Image

Template specific keywords

{:TDB:TABLE:COLUMN:AUTO:FOREACH:CURRENT:INDEX::}
Is replaced by the current auto generated value column index in the current table auto generated value column collection iterated
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:INDEX::}
Is replaced by the current column index in the current table column collection iterated
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:NAME::}
Is replaced by the current column name from the iteration
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:CONVERT:TYPE(...)::}
Is replaced by the specified language current column value type conversion (ex: Java, CSharp, ...)
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:TYPE::}
Is replaced by the current column database model type
{:TDB:TABLE:COLUMN:AUTO:FOREACH:CURRENT:IS:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is the first column from the iterated auto generated value column collection
{:TDB:TABLE:COLUMN:AUTO:FOREACH:CURRENT:IS:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is the last column from the iterated auto generated value column collection
{:TDB:TABLE:COLUMN:AUTO:FOREACH:CURRENT:IS:NOT:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the first column from the iterated auto generated value column collection
{:TDB:TABLE:COLUMN:AUTO:FOREACH:CURRENT:IS:NOT:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the last column from the iterated auto generated value column collection
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:FIRST:COLUMN(...):::}
Is replaced by empty value or by the inner context when the current column is the first column from the current table column collection
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:LAST:COLUMN(...):::}
Is replaced by empty value or by the inner context when the current column is the last column from the current table column collection
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:KEY:AUTO(...)KEY:AUTO:::}
Is replaced by the inner context when the current iteration column is an auto generated value column
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:NOT:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the first column from the iterated column collection
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:NOT:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the last column from the iterated column collection
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:KEY:NOT:AUTO(...)KEY:NOT:AUTO:::}
Is replaced by the inner context when the current iteration column is not an auto generated value column
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:NOT:NULL(...):::}
Is replaced by the inner context when the current iteration column is not a nullable value column
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:KEY:NOT:PRIMARY(...)KEY:NOT:PRIMARY:::}
Is replaced by the inner context when the current iteration column is not a primary key column
{:TDB:TABLE:COLUMN:FOREACH:CURRENT:IS:KEY:PRIMARY(...)KEY:PRIMARY:::}
Is replaced by the inner context when the current iteration column is a primary key column
{:TDB:TABLE:COLUMN:NOT:AUTO:FOREACH:CURRENT:IS:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the first column from the iterated auto generated value column collection
{:TDB:TABLE:COLUMN:NOT:AUTO:FOREACH:CURRENT:IS:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the last column from the iterated auto generated value column collection
{:TDB:TABLE:COLUMN:NOT:AUTO:FOREACH:CURRENT:IS:NOT:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the first column from the iterated not auto generated value column collection
{:TDB:TABLE:COLUMN:NOT:AUTO:FOREACH:CURRENT:IS:NOT:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the last column from the iterated not auto generated value column collection
{:TDB:TABLE:COLUMN:NOT:NULL:CURRENT:IS:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is the first column from the iterated not nullable value column collection
{:TDB:TABLE:COLUMN:NOT:NULL:FOREACH:CURRENT:IS:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is the last column from the iterated not nullable value column collection
{:TDB:TABLE:COLUMN:NOT:PRIMARY:FOREACH:CURRENT:IS:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is the first column from the iterated not primary key column collection
{:TDB:TABLE:COLUMN:NOT:PRIMARY:FOREACH:CURRENT:IS:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is the last column from the iterated not primary key column collection
{:TDB:TABLE:COLUMN:NOT:PRIMARY:FOREACH:CURRENT:IS:NOT:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the first column from the iterated not primary key column collection
{:TDB:TABLE:COLUMN:NOT:PRIMARY:FOREACH:CURRENT:IS:NOT:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the last column from the iterated not primary key column collection
{:TDB:TABLE:COLUMN:PRIMARY:FOREACH:CURRENT:IS:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is the first column from the iterated primary key column collection
{:TDB:TABLE:COLUMN:PRIMARY:FOREACH:CURRENT:IS:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is the last column from the iterated primary key column collection
{:TDB:TABLE:COLUMN:PRIMARY:FOREACH:CURRENT:IS:NOT:FIRST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the first column from the iterated primary key column collection
{:TDB:TABLE:COLUMN:PRIMARY:FOREACH:CURRENT:IS:NOT:LAST:COLUMN(...):::}
Is replaced by the inner context when the current column is not the last column from the iterated primary key column collection
{:TDB:TABLE:COLUMN:NOT:AUTO:FOREACH:CURRENT:INDEX::}
Is replaced by the current not auto generated value column index in the current table not auto generated value column collection iterated
{:TDB:TABLE:COLUMN:PRIMARY:NOT:NULL:CURRENT:INDEX::}
Is replaced by the current not nullable value column index in the current table not nullable value column collection iterated
{:TDB:TABLE:COLUMN:PRIMARY:FOREACH:CURRENT:INDEX::}
Is replaced by the current not primary key column index in the current table not primary key column collection iterated
{:TDB:TABLE:COLUMN:NOT:PRIMARY:FOREACH:CURRENT:INDEX::}
Is replaced by the current primary key column index in the current table primary key column collection iterated
{:TDB:TABLE:COLUMN:AUTO:FOREACH[...]::}
Is replaced by the intern context as many time as there is auto generated value column in the table
{:TDB:TABLE:COLUMN:FOREACH[...]::}
Is replaced by the intern context as many time as there is column in the table
{:TDB:TABLE:COLUMN:NOT:AUTO:FOREACH[...]::}
Is replaced by the intern context as many time as there is not auto generated value column in the table
{:TDB:TABLE:COLUMN:NOT:NULL:FOREACH[...]::}
Is replaced by the intern context as many time as there is not nullable value column in the table
{:TDB:TABLE:COLUMN:NOT:PRIMARY:FOREACH[...]::}
Is replaced by the intern context as many time as there is not primary key column in the table
{:TDB:TABLE:COLUMN:PRIMARY:FOREACH[...]::}
Is replaced by the intern context as many time as there is primary key column in the table
{:TDB:TABLE:CURRENT:NAME::}
Is replaced by the current table name
{:TDB:CURRENT:NAME::}
Is replaced by the current database name
{:TDB:TABLE:FOREACH[...]::}
Is replaced by the intern context as many time as there is table in the database
{:TDB:FUNCTION:FIRST:CHARACTER:TO:UPPER:CASE(...)::}
Is replaced by the intern context with the first letter of intern context Uppercased

About

DBTemplateHandler to NetCore3 portage

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages