Choose your plan

Pick the best option for your needs and get to work now or scroll down for a more detailed comparison.

Version

for

for is a loop to iterate tables, views, procedures, vtables, columns etc. You can generate your code for each entity in the database by using this loop.

Syntax

for((([variable]:[predefined_collection]))) {{{

}}}

Example 1
Assume that we use a database with tables : TableA, TableB, TableC, …, TableZ

Table Names :
for(((item:tables))) {{{
[[[item.name]]]
}}}
Output 1

Table Names :
TableA
TableB
TableC

TableZ

Example 2
Assume that we use a database with views : ViewA, ViewB, ViewC, …, ViewZ

for(((myView:views))) {{{
public class [[[myView.name]]] {}
}}}
Output 2

public class ViewA {}
public class ViewB {}
public class ViewC {}

public class ViewZ {}

table

“table” is one kind of reference objects for tables generated by Zontroy using a zref file. The properties of this object type which are predefined in Zontroy are accessible and as follows:

name: name of a table
targetName: target name of a table set by the developer
alternativeName: alternative name of a table set by the developer
label: label of a table
primaryKey: short version of primaryKey.name
primaryKey.dataType: data type of primary key column
displayColumn: short version of displayColumn.name
displayColumn.dataType: data type of display column
extra1: extra field for custom data
extra2: extra field for custom data
extra3: extra field for custom data

Java

Sample implementation

// I[[[table.name]]]Service.java.zref

import java.util.List;
public interface I[[[table.name]]]Service
{
public partial interface I[[[table.name]]]Service
{
List<[[[table.name]]]> GetAll();

[[[table.name]]] Get([[[table.primaryKey.DataType]]] [[[table.primaryKey]]]);

void Add([[[table.name]]] [[[table.name]]]);

void Update([[[table.name]]] [[[table.name]]]);

void Delete([[[table.name]]] [[[table.name]]]);
}
}

Generated Code Files

// IProductsService.java
import java.util.List;
public interface IProductsService
{
List<Products> GetAll();

Products Get(int ProductID);

void Add(Products Products);

void Update(Products Products);

void Delete(Products Products);
}

// ICategoriesService.java
import java.util.List;
public interface ICategoriesService
{
List<Categories> GetAll();

Categories Get(int CategoryID);

void Add(Categories Categories);

void Update(Categories Categories);

void Delete(Categories Categories);
}

// IOrdersService.java
import java.util.List;
public interface IOrdersService
{
List<Orders> GetAll();

Orders Get(int OrderID);

void Add(Orders Orders);

void Update(Orders Orders);

void Delete(Orders Orders);
}

 

C#

Sample Implementation

// I[[[table.name]]]Service.cs.zref
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface I[[[table.name]]]Service
{
[OperationContract]
List<[[[table.name]]]> GetAll();
[OperationContract]
[[[table.name]]] Get([[[table.primaryKey.DataType]]] [[[table.primaryKey]]]);
[OperationContract]
void Add([[[table.name]]] [[[table.name]]]);
[OperationContract]
void Update([[[table.name]]] [[[table.name]]]);
[OperationContract]
void Delete([[[table.name]]] [[[table.name]]]);
}
}

Generated Code Files

// IProductsService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IProductsService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);
[OperationContract]
void Add(Products Products);
[OperationContract]
void Update(Products Products);
[OperationContract]
void Delete(Products Products);
}
}

// ICategoriesService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICategoriesService
{
[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);
[OperationContract]
void Add(Categories Categories);
[OperationContract]
void Update(Categories Categories);
[OperationContract]
void Delete(Categories Categories);
}
}

// IOrdersService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IOrdersService
{
[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
[OperationContract]
void Add(Orders Orders);
[OperationContract]
void Update(Orders Orders);
[OperationContract]
void Delete(Orders Orders);
}
}

tables

“tables” is a predefined collection of reference objects for tables generated by Zontroy using a zref file. It is possible to iterate tables inside a for loop to generate code using table references.

 

Java

Sample Implementation

// ICommonService.java.zsif

import java.util.List;
public interface ICommonService
{
public partial interface ICommonService
{
for(((item:tables))){{{
// [[[item.name]]]
List<[[[item.name]]]> GetAll();

[[[item.name]]] Get([[[item.primaryKey.dataType]]] [[[item.primaryKey]]]);

void Add([[[item.name]]] [[[item.name]]]);

void Update([[[item.name]]] [[[item.name]]]);

void Delete([[[item.name]]] [[[item.name]]]);

}}}
}
}

Generated Code Files

// ICommonService.java
import java.util.List;
public interface ICommonService
{
List<Products> GetAll();

Products Get(int ProductID);

void Add(Products Products);

void Update(Products Products);

void Delete(Products Products);

List<Categories> GetAll();

Categories Get(int CategoryID);

void Add(Categories Categories);

void Update(Categories Categories);

void Delete(Categories Categories);

List<Orders> GetAll();

Orders Get(int OrderID);

void Add(Orders Orders);

void Update(Orders Orders);

void Delete(Orders Orders);
}

 

C#

Sample Implementation

// ICommonService.cs.zsif
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
for(((item:tables))){{{
// [[[item.name]]]
[OperationContract]
List<[[[item.name]]]> GetAll();
[OperationContract]
[[[item.name]]] Get([[[item.primaryKey.dataType]]] [[[item.primaryKey]]]);
[OperationContract]
void Add([[[item.name]]] [[[item.name]]]);
[OperationContract]
void Update([[[item.name]]] [[[item.name]]]);
[OperationContract]
void Delete([[[item.name]]] [[[item.name]]]);

}}}
}
}

Generated Code Files

// ICommonService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);
[OperationContract]
void Add(Products Products);
[OperationContract]
void Update(Products Products);
[OperationContract]
void Delete(Products Products);

[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);
[OperationContract]
void Add(Categories Categories);
[OperationContract]
void Update(Categories Categories);
[OperationContract]
void Delete(Categories Categories);

[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
[OperationContract]
void Add(Orders Orders);
[OperationContract]
void Update(Orders Orders);
[OperationContract]
void Delete(Orders Orders);
}
}

view -pro version only

“view” is one kind of reference objects for views generated by Zontroy using a zref file. The properties of this object type which are predefined in Zontroy are accessible and as follows:

name: name of a view
targetName: target name of a view set by the developer
alternativeName: alternative name of a view set by the developer
label: label of a view
primaryKey: short version of primaryKey.name
primaryKey.dataType: data type of primary key column
displayColumn: short version of displayColumn.name
displayColumn.dataType: data type of display column
extra1: extra field for custom data
extra2: extra field for custom data
extra3: extra field for custom data

 

Java

Sample Implementatiaon

// I[[[view.name]]]Service.java.zref

import java.util.List;
public interface I[[[view.name]]]Service
{
public partial interface I[[[view.name]]]Service
{
List<[[[view.name]]]> GetAll();

[[[view.name]]] Get([[[view.primaryKeyDataType]]] [[[view.primaryKey]]]);
}
}

Generated Code Files

// IProductsService.java
import java.util.List;
public interface IProductsService
{
List<Products> GetAll();

Products Get(int ProductID);
}

// ICategoriesService.java
import java.util.List;
public interface ICategoriesService
{
List<Categories> GetAll();

Categories Get(int CategoryID);
}

// IOrdersService.java
import java.util.List;
public interface IOrdersService
{
List<Orders> GetAll();

Orders Get(int OrderID);
}

 

C#

Sample Implementatiaon

 

// I[[[view.name]]]Service.cs.zref
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface I[[[view.name]]]Service
{
[OperationContract]
List<[[[view.name]]]> GetAll();
[OperationContract]
[[[view.name]]] Get([[[view.primaryKeyDataType]]] [[[view.primaryKey]]]);
}
}

Generated Code Files

// IProductsService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IProductsService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);
}
}

// ICategoriesService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICategoriesService
{
[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);
}
}

// IOrdersService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IOrdersService
{
[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
}
}

views -pro version only

“views” is a predefined collection of reference objects for views generated by Zontroy using a zref file. It is possible to iterate tables inside a for loop to generate code using table references.

 

Java

Sample Implementation

// ICommonService.java.zsif

import java.util.List;
public interface ICommonService
{
public partial interface ICommonService
{
for(((item:views))){{{
List<[[[item.name]]]> GetAll();

[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
}}}
}
}

Generated Code Files

// ICommonService.java
import java.util.List;
public interface ICommonService
{
List<Products> GetAll();

Products Get(int ProductID);

List<Categories> GetAll();

Categories Get(int CategoryID);

List<Orders> GetAll();

Orders Get(int OrderID);
}

 

C#

Sample Implementation

// ICommonService.cs.zsif
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
for(((item:views))){{{
[OperationContract]
List<[[[item.name]]]> GetAll();
[OperationContract]
[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
}}}
}
}

Generated Code Files

// ICommonService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);

[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);

[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
}
}

vtable -pro version only

“vtable” stands for “virtual table” and is one kind of reference objects for virtual tables generated by Zontroy using a zref file. Virtual tables are a kind of table created in Zontroy. The properties of this object type which are predefined in Zontroy are accessible and as follows:

name: name of a virtual table
label: label of a virtual table
primaryKey: short version of primaryKey.name
primaryKey.dataType: data type of primary key column
displayColumn: short version of displayColumn.name
displayColumn.dataType: data type of display column

Java

Sample Implementation

// I[[[vtable.name]]]Service.java.zref

import java.util.List;
public interface I[[[vtable.name]]]Service
{
public partial interface I[[[vtable.name]]]Service
{
List<[[[vtable.name]]]> GetAll();

[[[vtable.name]]] Get([[[vtable.primaryKeyDataType]]] [[[vtable.primaryKey]]]);

void Add([[[vtable.name]]] [[[vtable.name]]]);

void Update([[[vtable.name]]] [[[vtable.name]]]);

void Delete([[[vtable.name]]] [[[vtable.name]]]);
}
}

Generated Code Files

// IProductsService.java
import java.util.List;
public interface IProductsService
{
List<Products> GetAll();

Products Get(int ProductID);

void Add(Products Products);

void Update(Products Products);

void Delete(Products Products);
}

// ICategoriesService.java
import java.util.List;
public interface ICategoriesService
{
List<Categories> GetAll();

Categories Get(int CategoryID);

void Add(Categories Categories);

void Update(Categories Categories);

void Delete(Categories Categories);
}

// IOrdersService.java
import java.util.List;
public interface IOrdersService
{
List<Orders> GetAll();

Orders Get(int OrderID);

void Add(Orders Orders);

void Update(Orders Orders);

void Delete(Orders Orders);
}

 

C#

Sample Implementation

// I[[[vtable.name]]]Service.cs.zref
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface I[[[vtable.name]]]Service
{
[OperationContract]
List<[[[vtable.name]]]> GetAll();
[OperationContract]
[[[vtable.name]]] Get([[[vtable.primaryKeyDataType]]] [[[vtable.primaryKey]]]);
[OperationContract]
void Add([[[vtable.name]]] [[[vtable.name]]]);
[OperationContract]
void Update([[[vtable.name]]] [[[vtable.name]]]);
[OperationContract]
void Delete([[[vtable.name]]] [[[vtable.name]]]);
}
}

Generated Code Files

// IProductsService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IProductsService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);
[OperationContract]
void Add(Products Products);
[OperationContract]
void Update(Products Products);
[OperationContract]
void Delete(Products Products);
}
}

// ICategoriesService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICategoriesService
{
[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);
[OperationContract]
void Add(Categories Categories);
[OperationContract]
void Update(Categories Categories);
[OperationContract]
void Delete(Categories Categories);
}
}

// IOrdersService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IOrdersService
{
[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
[OperationContract]
void Add(Orders Orders);
[OperationContract]
void Update(Orders Orders);
[OperationContract]
void Delete(Orders Orders);
}
}

vtables -pro version only

“vtables” stands for “virtual tables” and is a predefined collection of reference objects for virtual tables generated by Zontroy using a zref file. It is possible to iterate vtables inside a for loop to generate code using virtual table references.

 

Java

Sample Implementation

// ICommonService.java.zsif

import java.util.List;
public interface ICommonService
{
public partial interface ICommonService
{
for(((item:vtables))){{{
List<[[[item.name]]]> GetAll();

[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);

void Add([[[item.name]]] [[[item.name]]]);

void Update([[[item.name]]] [[[item.name]]]);

void Delete([[[item.name]]] [[[item.name]]]);
}}}
}
}

Generated Code Files

// ICommonService.java
import java.util.List;
public interface ICommonService
{
List<Products> GetAll();

Products Get(int ProductID);

void Add(Products Products);

void Update(Products Products);

void Delete(Products Products);

List<Categories> GetAll();

Categories Get(int CategoryID);

void Add(Categories Categories);

void Update(Categories Categories);

void Delete(Categories Categories);

List<Orders> GetAll();

Orders Get(int OrderID);

void Add(Orders Orders);

void Update(Orders Orders);

void Delete(Orders Orders);
}

 

C#

Sample Implementation

// ICommonService.cs.zsif
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
for(((item:vtables))){{{
[OperationContract]
List<[[[item.name]]]> GetAll();
[OperationContract]
[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
[OperationContract]
void Add([[[item.name]]] [[[item.name]]]);
[OperationContract]
void Update([[[item.name]]] [[[item.name]]]);
[OperationContract]
void Delete([[[item.name]]] [[[item.name]]]);
}}}
}
}

Generated Code Files

// ICommonService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);
[OperationContract]
void Add(Products Products);
[OperationContract]
void Update(Products Products);
[OperationContract]
void Delete(Products Products);

[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);
[OperationContract]
void Add(Categories Categories);
[OperationContract]
void Update(Categories Categories);
[OperationContract]
void Delete(Categories Categories);

[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
[OperationContract]
void Add(Orders Orders);
[OperationContract]
void Update(Orders Orders);
[OperationContract]
void Delete(Orders Orders);
}
}

procedure -pro version only

“procedure” is a reference for the procedure generated by Zontroy using zref template file. You can access properties of this reference which are predefined in Zontroy. The procedure properties are as follows:

– name
– label
– primaryKey
– primaryKeyDataType
– displayColumn
– displayColumnDataType

 

Java

Sample “procedure” Usage in Java using Zontroy Language

// I[[[procedure.name]]]Service.java.zref

import java.util.List;
public interface I[[[procedure.name]]]Service
{
public partial interface I[[[procedure.name]]]Service
{
List<[[[procedure.name]]]> GetAll();

[[[procedure.name]]] Get([[[procedure.primaryKeyDataType]]] [[[procedure.primaryKey]]]);
}
}

Generated Code Files :

// IProductsService.java
import java.util.List;
public interface IProductsService
{
List<Products> GetAll();

Products Get(int ProductID);
}

// ICategoriesService.java
import java.util.List;
public interface ICategoriesService
{
List<Categories> GetAll();

Categories Get(int CategoryID);
}

// IOrdersService.java
import java.util.List;
public interface IOrdersService
{
List<Orders> GetAll();

Orders Get(int OrderID);
}

 

C#

Sample “procedure” Usage in C# using Zontroy Language

// I[[[procedure.name]]]Service.cs.zref
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface I[[[procedure.name]]]Service
{
[OperationContract]
List<[[[procedure.name]]]> GetAll();
[OperationContract]
[[[procedure.name]]] Get([[[procedure.primaryKeyDataType]]] [[[procedure.primaryKey]]]);
}
}

Generated Code Files :

// IProductsService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IProductsService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);
}
}

// ICategoriesService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICategoriesService
{
[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);
}
}

// IOrdersService.cs
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface IOrdersService
{
[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
}
}

procedures -pro version only

“procedures” is a predefined collection of references to the procedures in the database with additional properties. You can iterate tables inside a for loop to generate code using table references.

 

Java

Sample “procedures” Usage in Java using Zontroy Language

// ICommonService.java.zsif

import java.util.List;
public interface ICommonService
{
public partial interface ICommonService
{
for(((item:procedures))){{{
List<[[[item.name]]]> GetAll();

[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
}}}
}
}

Generated Code Files :

// ICommonService.java
import java.util.List;
public interface ICommonService
{
List<Products> GetAll();

Products Get(int ProductID);

List<Categories> GetAll();

Categories Get(int CategoryID);

List<Orders> GetAll();

Orders Get(int OrderID);
}

 

C#

Sample “tables” Usage in C# using Zontroy Language

// ICommonService.cs.zsif
using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
for(((item:procedures))){{{
[OperationContract]
List<[[[item.name]]]> GetAll();
[OperationContract]
[[[item.name]]] Get([[[item.primaryKeyDataType]]] [[[item.primaryKey]]]);
}}}
}
}

Generated Code Files :

// ICommonService.cs

using System;
using System.ServiceModel;
using System.Collections.Generic;
using MyProject.Entities.Concrete;
namespace MyProject.Business.Abstract
{
[ServiceContract]
public partial interface ICommonService
{
[OperationContract]
List<Products> GetAll();
[OperationContract]
Products Get(int ProductID);

[OperationContract]
List<Categories> GetAll();
[OperationContract]
Categories Get(int CategoryID);

[OperationContract]
List<Orders> GetAll();
[OperationContract]
Orders Get(int OrderID);
}
}

Zontroy Single File (zsif)

Zontroy Single File (zsif) is one of the three file types specific to Zontroy. Zontroy Single File is used to generate code in a single code file. Our code files use the same extension which is zsif for different languages, but before zsif extension we should also use the original file extension as below:

Syntax

[file_name].[file_extension].zsif

Example 1
Just an empty class example.

Java

Zontroy Single File :

// MyClass.java.zsif
public class MyClass {

}

Generated Code File :

// MyClass.java
public class MyClass {

}

 

 

Python

 

Zontroy Single File :

# MyClass.py.zsif
class MyClass:

Generated Code File :

# MyClass.py
class MyClass:

 

 

C#

 

Zontroy Single File :

// MyClass.cs.zsif
public class MyClass {

}

Generated Code File :

// MyClass.cs
public class MyClass {

}

 

Example 2
Assume that we use a database with tables : Table1, Table2, Table3, …, Table100

Java

Zontroy Single File :

// MyClass.java.zsif
public class MyClass {
for(((item:tables))){{{
class Nested[[[item.name]]] {

}

}}}
}

Generated Code File :

// MyClass.java
public class MyClass {
class NestedTable1 {

}

class NestedTable2 {

}

class NestedTable3 {

}

class NestedTable100 {

}
}

 

 

Python

 

Zontroy Single File :

# MyClass.py.zsif
class MyClass:
for(((item:tables))){{{
class Nested[[[item.name]]]:

}}}

Generated Code File :

# MyClass.py
class MyClass:
class NestedTable1:

class NestedTable2:

class NestedTable3:

class NestedTable100:

 

C#

 

Zontroy Single File :

// MyClass.cs.zsif
public class MyClass {
for(((item:tables))){{{
class Nested[[[item.name]]] {

}

}}}
}

Generated Code File :

// MyClass.cs
public class MyClass {
class NestedTable1 {

}

class NestedTable2 {

}

class NestedTable3 {

}

class NestedTable100 {

}
}

Zontroy Repeating File (zref)

Zontroy Repeating File (zref) is one of the three file types specific to Zontroy. Zontroy Repeating File is used to generate lines of code together with the file containing the code. Our code files use the same extension which is zref for different languages, but before zref extension we should also use the original file extension as below:

Syntax

[file_name].[file_extension].zref

Example 1
Assume that we use a database with tables : TableA, TableB, TableC, …, TableZ

Java

Zontroy Repeating File :

// My[[[table.name]]].java.zref
public class My[[[table.name]]] {

}

Generated Code Files :

// MyTableA.java
public class MyTableA {

}

// MyTableB.java
public class MyTableB {

}

// MyTableC.java
public class MyTableC {

}

// MyTableZ.java
public class MyTableZ {

}

 

Python

 

Zontroy Repeating File :

# My[[[table.name]]].py.zref
class My[[[table.name]]]:

Generated Code Files :

# MyTableA.py
class MyTableA:

 

# MyTableB.py
class MyTableB:

 

# MyTableC.py
class MyTableC:

 

# MyTableZ.py
class MyTableZ:

 

C#

 

Zontroy Repeating File :

// My[[[table.name]]].cs.zref
public class My[[[table.name]]] {

}

Generated Code Files :

// MyTableA.cs
public class MyTableA {

}

// MyTableB.cs
public class MyTableB {

}

// MyTableC.cs
public class MyTableC {

}

// MyTableZ.cs
public class MyTableZ {

}

 

Example 2
Assume that we use a database with tables : Table1, Table2, Table3, …, Table100 and each table has an id column and name column that has a name ending with its number.

Java

Zontroy Repeating File :

// Your[[[table.name]]]Class.java.zref
public class Your[[[table.name]]]Class {
// Columns :
for(((item:table.columns))){{{
// [[[item.name]]]
}}}
}

Generated Code Files :

// YourTable1Class.java
public class YourTable1Class {
// Columns :
// Id
// Name1
}

// YourTable2Class.java
public class YourTable2Class {
// Columns :
// Id
// Name2
}

// YourTable3Class.java
public class YourTable3Class {
// Columns :
// Id
// Name3
}

// YourTable100Class.java
public class YourTable100Class {
// Columns :
// Id
// Name100
}

 

Python

 

Zontroy Repeating File :

# Your[[[table.name]]]Class.py.zref
class Your[[[table.name]]]Class:
# Columns :
for(((item:table.columns))){{{
# [[[item.name]]]
}}}

Generated Code Files :

# YourTable1Class.py
class YourTable1Class:
# Columns :
# Id
# Name1

 

# YourTable2Class.py
class YourTable2Class:
# Columns :
# Id
# Name2

 

# YourTable3Class.py
class YourTable3Class:
# Columns :
# Id
# Name3

 

# YourTable100Class.py
class YourTable100Class:
# Columns :
# Id
# Name100

 

C#

 

Zontroy Repeating File :

// Your[[[table.name]]]Class.cs.zref
public class Your[[[table.name]]]Class {
// Columns :
for(((item:table.columns))){{{
// [[[item.name]]]
}}}
}

Generated Code Files :

// YourTable1Class.cs
public class YourTable1Class {
// Columns :
// Id
// Name1
}

// YourTable2Class.cs
public class YourTable2Class {
// Columns :
// Id
// Name2
}

// YourTable3Class.cs
public class YourTable3Class {
// Columns :
// Id
// Name3
}

// YourTable100Class.cs
public class YourTable100Class {
// Columns :
// Id
// Name100
}

Zontroy Inner Repeating File (ziref)

Zontroy Inner Repeating File (ziref) is one of the three file types specific to Zontroy. Zontroy Inner Repeating File is used to generate lines of code, the file containing the code, and the folder containing the files all together. Our code files use the same extension which is ziref for different languages, but before ziref extension we should also use the original file extension as below:

Syntax

[folder_name].ziref
[file_name1].[file_extension1].ziref
[file_name2].[file_extension2].ziref

Example 1
Assume that we use a database with tables : TableA, TableB, TableC, …, TableZ

Java

Zontroy Inner Repeating File :

// Folder : My[[[table.name]]].ziref
// File inside the folder : MyClass.java.ziref
public class MyClass {

}

Generated Folders and Code Files :

// Created folder : MyTableA
// Created file inside the folder : MyClass.java
public class MyClass{

}

// Created folder : MyTableB
// Created file inside the folder : MyClass.java
public class MyClass{

}

// Created folder : MyTableC
// Created file inside the folder : MyClass.java
public class MyClass{

}

// Created folder : MyTableZ
// Created file inside the folder : MyClass.java
public class MyClass{

}

 

Python

 

Zontroy Inner Repeating File :

# Folder : My[[[table.name]]].ziref
# File inside the folder : MyClass.py.ziref
class MyClass:

Generated Folders and Code Files :

# Created folder : MyTableA
# Created file inside the folder : MyClass.py
class MyClass:

 

# Created folder : MyTableB
# Created file inside the folder : MyClass.py
class MyClass:

 

# Created folder : MyTableC
# Created file inside the folder : MyClass.py
class MyClass:

 

# Created folder : MyTableZ
# Created file inside the folder : MyClass.py
class MyClass:

 

C#

 

Zontroy Inner Repeating File :

// Folder : My[[[table.name]]].ziref
// File inside the folder : MyClass.cs.ziref
public class MyClass {

}

Generated Folders and Code Files :

// Created folder : MyTableA
// Created file inside the folder : MyClass.cs
public class MyClass{

}

// Created folder : MyTableB
// Created file inside the folder : MyClass.cs
public class MyClass{

}

// Created folder : MyTableC
// Created file inside the folder : MyClass.cs
public class MyClass{

}

// Created folder : MyTableZ
// Created file inside the folder : MyClass.cs
public class MyClass{

}

 

 

Example 2
Assume that we use a database with tables : Table1, Table2, Table3, …, Table100 and each table has an id column and name column that has a name ending with its number.

Java

Zontroy Inner Repeating File :

// Folder : Your[[[table.name]]]Folder.ziref
// File inside the folder : Your[[[table.name]]]Class.java.ziref
public class Your[[[table.name]]]Class {
// Columns :
for(((item:table.columns))){{{
// [[[item.name]]]
}}}
}

Generated Folders and Code Files :

// Created folder : YourTable1Folder
// Created file inside the folder : YourTable1Class.java
public class YourTable1Class {
// Columns :
// Id
// Name1
}

// Created folder : YourTable2Folder
// Created file inside the folder : YourTable2Class.java
public class YourTable2Class {
// Columns :
// Id
// Name2
}

// Created folder : YourTable3Folder
// Created file inside the folder : YourTable3Class.java
public class YourTable3Class {
// Columns :
// Id
// Name3
}

// Created folder : YourTable100Folder
// Created file inside the folder : YourTable100Class.java
public class YourTable100Class {
// Columns :
// Id
// Name100
}

 

Python

 

Zontroy Inner Repeating File :

# Folder : Your[[[table.name]]]Folder.ziref
# File inside the folder : Your[[[table.name]]]Class.py.ziref
class Your[[[table.name]]]Class:
# Columns :
for(((item:table.columns))){{{
# [[[item.name]]]
}}}

Generated Folders and Code Files :

# Created folder : YourTable1Folder
# Created file inside the folder : YourTable1Class.py
class YourTable1Class:
# Columns :
# Id
# Name1

 

# Created folder : YourTable2Folder
# Created file inside the folder : YourTable2Class.py
class YourTable2Class:
# Columns :
# Id
# Name2

 

# Created folder : YourTable3Folder
# Created file inside the folder : YourTable3Class.py
class YourTable3Class:
# Columns :
# Id
# Name3

 

# Created folder : YourTable100Folder
# Created file inside the folder : YourTable100Class.py
class YourTable100Class:
# Columns :
# Id
# Name100

C#

 

Zontroy Inner Repeating File :

// Folder : Your[[[table.name]]]Folder.ziref
// File inside the folder : Your[[[table.name]]]Class.cs.ziref
public class Your[[[table.name]]]Class {
// Columns :
for(((item:table.columns))){{{
// [[[item.name]]]
}}}
}

Generated Folders and Code Files :

// Created folder : YourTable1Folder
// Created file inside the folder : YourTable1Class.cs
public class YourTable1Class {
// Columns :
// Id
// Name1
}

// Created folder : YourTable2Folder
// Created file inside the folder : YourTable2Class.cs
public class YourTable2Class {
// Columns :
// Id
// Name2
}

// Created folder : YourTable3Folder
// Created file inside the folder : YourTable3Class.cs
public class YourTable3Class {
// Columns :
// Id
// Name3
}

// Created folder : YourTable100Folder
// Created file inside the folder : YourTable100Class.cs
public class YourTable100Class {
// Columns :
// Id
// Name100
}