[TxMt] Looking for a Bundle

[Brad Miller]

Here's a slightly improved create table:
create table ${1:tableName} (
	${2:column}	${3:type}	${4:null}	${5:default ${6:null}},
	$0
	primary key ($2)
) ;

The $0 puts the cursor on the blank line for the next column after  
you have tabbed through the default value.

I also forgot to mention that you can take the  line for the column  
and make a snippet out of that line to make new columns easily.  Be  
sure to renumber the placeholders starting at 1.

Brad


On Mar 19, 2006, at 4:51 PM, Brad Miller wrote:

> David,
>
> Here's an example of a snippet for creating a table:  You can try  
> this out by going to the bundle editor and adding a snippet to the  
> SQL bundle.  Replace all the explanation with the following:
>
> create table ${1:tableName} (
> 	${2:column}	${3:type}		${4:null}		${5:default ${6:null}},
> 	primary key ($2),
> ) ;
>
> Notice that the primary key defaults to the first column you create  
> and is automatically filled in as soon as you make fill in the name  
> for the column.
>
> Give the snippet a tab trigger like create and scope of source.sql
>
> You could add a foreign key snippet using something like this:
>
> ${1:column} references ${2:otherTable} ($1)
>
> I don't know anything about peopleSync so I'm not sure if this is  
> what you were thinking of...
>
> Brad
>
> On Mar 19, 2006, at 3:57 PM, David Newberger wrote:
>
>> I would like to be able to do the following
>>
>> 1. Create Tables
>> 2. Create Columns
>> 3. Create drop table statements
>> 4. Create foregin keys
>>
>> a example of this would be:
>>
>> drop table if exists <table name>;
>>
>> create table <table> (
>>   <column>	<type>	<null>	<default>,
>> ) ;
>>
>> I like the syncPeople implementation for RoR migration and this is  
>> something I would like to do just for MySQL syntax. I know it  
>> seems like something that would be borderline for productivity  
>> increases but when you write as many DDL files as I do it would be  
>> a life saver and since I am just starting with textmate and mac in  
>> general I am trying to figure out the best way to do it.
>>
>>
>> On Mar 19, 2006, at 3:43 PM, Brad Miller wrote:
>>
>>> David,
>>>
>>> What kind of help?  What would you like the bundle to do for you?
>>>
>>> It would be pretty easy to create a Snippet that would expand  
>>> into a create table statement template...
>>>
>>>
>>> Brad
>>>
>>> On Mar 19, 2006, at 3:16 PM, David Newberger wrote:
>>>
>>>> Hi All,
>>>>
>>>> 	I have been using textmate for a little over a week now and I  
>>>> love the program. I have been using it for mostly RoR and HTML  
>>>> Development but I am looking for a bundle that will help me  
>>>> create MySQL DDL files. Any Ideas?
>>>>
>>>> David Newberger
>>>>
>>>> ___________________________________________________________________ 
>>>> ___
>>>> For new threads USE THIS: textmate at lists.macromates.com
>>>> (threading gets destroyed and the universe will collapse if you  
>>>> don't)
>>>> http://lists.macromates.com/mailman/listinfo/textmate
>>>
>>>
>>> ____________________________________________________________________ 
>>> __
>>> For new threads USE THIS: textmate at lists.macromates.com
>>> (threading gets destroyed and the universe will collapse if you  
>>> don't)
>>> http://lists.macromates.com/mailman/listinfo/textmate
>>
>>
>> _____________________________________________________________________ 
>> _
>> For new threads USE THIS: textmate at lists.macromates.com
>> (threading gets destroyed and the universe will collapse if you  
>> don't)
>> http://lists.macromates.com/mailman/listinfo/textmate
>
>
> ______________________________________________________________________
> For new threads USE THIS: textmate at lists.macromates.com
> (threading gets destroyed and the universe will collapse if you don't)
> http://lists.macromates.com/mailman/listinfo/textmate