iCodegenerator is a database centric template based code generator for any programming language like C, PHP, C#, Visual Basic, Java, Perl, Python... Supported databases are SQL Server, MySQL and PostgreSQL.
git clone https://github.com/VientoDigital/codegenerator.git
Initial view of the iCodegenerator.
SQL Server, MySQL, Postgres & Oracle.
Special defined tags.
Snippets of the tags available to use on a template.
<!DOCTYPE html>
<html>
<head>
<title>iCodegenerator- {DATABASE.NAME}</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<h1>{TABLE.NAME}</h1>
<form role="form">
{TABLE.COLUMNS}
<div class="form-group">
<label for="{COLUMN.NAME}">{COLUMN.NAME HUMAN}</label>
<input type="text" class="form-control" id="{COLUMN.NAME}" placeholder="{COLUMN.NAME HUMAN}">
</div>{/TABLE.COLUMNS}
<button type="submit" class="btn btn-default">Submit</button>
</form>
<script src="https://code.jquery.com/jquery.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<title>iCodegenerator- yrasesoras3_pruebas</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- Bootstrap -->
<link href="css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<h1>Users</h1>
<form role="form">
<div class="form-group">
<label for="Id">Id</label>
<input type="text" class="form-control" id="Id" placeholder="Id">
</div>
<div class="form-group">
<label for="Fullname">Fullname</label>
<input type="text" class="form-control" id="Fullname" placeholder="Fullname">
</div>
<div class="form-group">
<label for="Email">Email</label>
<input type="text" class="form-control" id="Email" placeholder="Email">
</div>
<div class="form-group">
<label for="Username">Username</label>
<input type="text" class="form-control" id="Username" placeholder="Username">
</div>
<div class="form-group">
<label for="Password">Password</label>
<input type="text" class="form-control" id="Password" placeholder="Password">
</div>
<div class="form-group">
<label for="Active">Active</label>
<input type="text" class="form-control" id="Active" placeholder="Active">
</div>
<div class="form-group">
<label for="DateCreated">Date Created</label>
<input type="text" class="form-control" id="DateCreated" placeholder="Date Created">
</div>
<div class="form-group">
<label for="DateModified">Date Modified</label>
<input type="text" class="form-control" id="DateModified" placeholder="Date Modified">
</div>
<div class="form-group">
<label for="Impersonate">Impersonate</label>
<input type="text" class="form-control" id="Impersonate" placeholder="Impersonate">
</div>
<button type="submit" class="btn btn-default">Submit</button>
</form>
<script src="https://code.jquery.com/jquery.js"></script>
<script src="js/bootstrap.min.js"></script>
</body>
</html>
CREATE PROCEDURE [{TABLE.SCHEMA}].[{CLASS}_Update]
(
{TABLE.COLUMNS} @{COLUMN.NAME} {COLUMN.TYPE}{IF COLUMN.TYPE EQ 'varchar|nvarchar'}({COLUMN.LENGTH}){/IF}{IF COLUMN.NULLABLE} = NULL{/IF}{IF NOT LAST},{/IF}
{/TABLE.COLUMNS})
AS
UPDATE [{TABLE.SCHEMA}].[{TABLE.NAME}] SET
{TABLE.COLUMNS NOPRIMARY} {COLUMN.NAME} = @{COLUMN.NAME}{IF NOT LAST},{/IF}
{/TABLE.COLUMNS}
WHERE {TABLE.COLUMNS PRIMARY}{COLUMN.NAME}= @{COLUMN.NAME}{/TABLE.COLUMNS}
GO
CREATE PROCEDURE [Viento].[Log_Update]
(
@Id bigint,
@Clasification varchar(50),
@Keyname varchar(50),
@Description text,
@LogType varchar(50),
@DateCreated datetime,
@Username varchar(50))
AS
UPDATE [Viento].[Logs] SET
Clasification = @Clasification,
Keyname = @Keyname,
Description = @Description,
LogType = @LogType,
DateCreated = @DateCreated,
Username = @Username
WHERE Id= @Id
GO
Language: English
Programming Language: C#
Framework: Microsoft.NET 4.0
Operating System: Microsoft Windows
Intented Audience: Developers, Educational, Information Technology
License: GNU General Public License, version 2
For educational purposes, the following were the design patterns used and where you can find its use.