The World's Simplest Code Generator

Are you a programmer? Meet your new best friend.

Update! New version out now: the World's 2nd Simplest Code Generator

'locus' on Thu, 28 Apr 2005 21:30:58 GMT, sez:

In the first box, put details of a table,
e.g.
UserId, Long
UserName, String
Password, String
etc...

Then use patterns like this:

Dim _$1 as $2

and

_$1 = .Item("$1")

or

isNull($1,0) as '$1',

'secretGeek' on Thu, 28 Apr 2005 21:34:36 GMT, sez:

Create property Getters and Setters with this pattern:

Public Property $1() As $2
Get
Return _$1
End Get
Set(ByVal Value As $2)
_$1 = Value
End Set
End Property

(Where the first box has, for example:
UserId, Long
UserName, String
)

'secretGeek' on Thu, 28 Apr 2005 22:17:11 GMT, sez:

Pattern for generating Insert statements from data:

Insert into tblMasterCombo (TypeID, Binary, Description) values('$1',$2,'$3')

'Strikes' on Fri, 29 Apr 2005 07:28:23 GMT, sez:

Very handy. Thanks for that.

Also, have you seen QuickCode?: http://www.dvxp.com/en/QuickCode.aspx.
To use your default $1 loves $2 pattern, "I,Quickcode"... Man does it save me some time...

'blameMike' on Fri, 29 Apr 2005 09:38:11 GMT, sez:

Awesome!

'aa' on Tue, 03 May 2005 01:36:56 GMT, sez:

I'm,you're,ok


$1 $3 $2 $3
$2 $3 $1 not $3
$1 not $3 $2 not $3
$1 $3 $2 not $3

'Overlook Hotel Ballroom Waiter' on Wed, 04 May 2005 08:25:46 GMT, sez:

properties in C#:

private $2 _$1;
public $2 $1
{
get { return _$1; }
set { _$1 = value; }
}

Input:
Number,int
Name,string

'comparing similar records' on Wed, 11 May 2005 02:53:50 GMT, sez:

Select
:foreach
h1.$1 as '1:$1', h2.$1 as '2:$1',
:end
from $Table h1
inner join $Table h2
on h1.$matchcol = h2.$matchcol
where h1.$keycol <> h2.$keycol
and
h1.$timecol > h2.$timecol

'Paul Stovell' on Fri, 13 May 2005 02:23:43 GMT, sez:

I needed to add columns to 90+ tables in a database but ignore others. I ran sp_tables, copied the list of table names as the input, and used

alter table $1
add [columnName] datetime not null

As the pattern. Woohoo!

'Harry' on Fri, 17 Jun 2005 17:50:42 GMT, sez:

--------------------------

string,Username
string,Password
long,ID

--------------------------

private $1 m_$2;

public $1 $2
{
get {return m_$2;}
set {m_$2 = value;}
}

--------------------------

private string m_Username;

public string Username
{
get {return m_Username;}
set {m_Username = value;}
}
private string m_Password;

public string Password
{
get {return m_Password;}
set {m_Password = value;}
}
private long m_ID;

public long ID
{
get {return m_ID;}
set {m_ID = value;}
}

'Harry' on Fri, 17 Jun 2005 17:52:47 GMT, sez:

This is really brilliant.

name


website (optional)


enter the word:
 

comment (HTML not allowed)

All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Who reads this legal bit anyhow?

TimeSnapper_{Know thyself!}

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

TimeSnapper won last year's Developer Competition at Larkware.com, and is used by over 10,000 people.