Edit your textpattern pages/forms/css in Textmate

wosh · 2006-05-03 06:37:01

I’ve created a Textmate bundle that allows you to connect to a mysql database and edit any data stored there within Textmate. The upshot of this is that you can now edit all your template data from Textpattern within Textmate.

If anyone is interested, there is a small video here: http://vivified.net/journal/sqledit-textmate-bundle
You can also download the bundle there.

Cheers,
Bastiaan

robmcm · 2006-05-19 07:44:11

Wow thanks mate this is superb!!! Going to save a lot of time!

wosh · 2006-05-20 09:12:04

Glad someone finds this useful. If you have any feature suggestions, do let me know!

lee · 2006-05-20 11:29:59

I like the look of this, any chance of a simple guide to installing the Mysql library – the instructions that come with it leave me a bit lost.

Thank you, Lee.

sthmtc · 2006-05-20 11:33:40

lee wrote:

I like the look of this, any chance of a simple guide to installing the Mysql library – the instructions that come with it leave me a bit lost.

same here :(

wosh · 2006-05-20 11:58:49

Hi,
I agree that compiling the mysql extension can be a royal pain in the ass.

I recommend the following article:
http://hivelogic.com/articles/2005/12/01/ruby_rails_lighttpd_mysql_tiger
Scroll down to “MySQL” and follow the steps (if you already have MySQL installed you can obviously skip that step).

Good luck!

wosh · 2006-05-20 12:01:04

If you’re into rails, you could also use the script found here:
http://sg.validcode.at/articles/2006/03/31/the-best-way-to-install-rails-on-os-x

That will set you up with rails, some gems, and the mysql bindings.

domfucssion · 2006-05-20 15:13:19

great – this might finally ween me off bbedit…

I got it running but the css in txp database is encoded (b64?), is they any way to convert that back and forth ‘cos for me that would be the main reason I would use this…

wosh · 2006-05-25 11:40:06

Ah, hadn’t thought of that yet (the base64 thing).
One solution is to use this: http://base64.darwinports.com/ (or a similar script…)

Then, simply select everything in your file, go to Text -> Filter through command.
Filter it through the decode utility, and you’re done.
The downside is you’ll have to do the reverse before saving.

Hope this helps (somewhat).

domfucssion · 2006-05-25 14:11:18

no worries, it is still paradise not editing in the browser for the other files.

One thing that bothers me in textmate Vs. bbedit though that I can’t get used to is the formatting. In bbedit i used to be able to run the “format” command and get a nice hierachical view of the source and I can’t get tm to do that. Any tips on that front?

thank you again

jamiew · 2006-05-25 15:23:14

this is amazing — trying it out now. thanks wosh!

wosh · 2006-05-28 09:32:30

domfucssion wrote:

One thing that bothers me in textmate Vs. bbedit though that I can’t get used to is the formatting. In bbedit i used to be able to run the “format” command and get a nice hierachical view of the source and I can’t get tm to do that. Any tips on that front?

I’m not a BBEdit user, so I’m not sure what the format command does exactly, however, did you try the text->indent selection command? Might be what you are looking for.

domfucssion · 2006-05-28 20:27:55

hi again, thanks for your suggestion, but it didn’t do it for me,

here’s what I am trying to do in textmate.
format:
<pre>
<body>
<div>dsdsd</div><ul><li>baa</li><li>baa2</li></ul>
</body>
</pre> into:
<pre> <body> <div>dsdsd</div> <ul> <li> baa </li> <li> baa2 </li> </ul> </body>
</pre>

wosh · 2006-05-29 07:17:59

I see, yes the indent selection command only does indentation, no linebreaks.
Try the Bundles->html->tidy command (ctrl-shift-h). That seems to do what you want.

marios · 2006-10-01 02:25:38

@domfuccsion,

In the latest Textpattern Bundle, I have included a command, that will do that for you.
(It uses a perl script taken of course from elsewhere)
The only thing you need to do is, press opt cmd shift F (when you are in text.html.txp scope), and you get the human readable source format in your document, your asking for,
although it is not the same as tab indenting, but I used it a lot these days with some huge html templates, that have all sorts of divitis and white space there from cutting and pasting, and then with just one key stroke, I get back to where I was before.

Just thought , you might find this useful .

you can get latest v <a href=“http://www.consking.com/file_download/31”>here</a>

@Bastiaan, I’d like to try out your Bundle, but can’t find the download link.

regards, marios

Last edited by marios (2006-10-01 03:00:47)

Textpattern CMS

Textpattern CMS support forum

#1 2006-05-03 06:37:01

Edit your textpattern pages/forms/css in Textmate

#2 2006-05-19 07:44:11

Re: Edit your textpattern pages/forms/css in Textmate

#3 2006-05-20 09:12:04

Re: Edit your textpattern pages/forms/css in Textmate

#4 2006-05-20 11:29:59

Re: Edit your textpattern pages/forms/css in Textmate

#5 2006-05-20 11:33:40

Re: Edit your textpattern pages/forms/css in Textmate

#6 2006-05-20 11:58:49

Re: Edit your textpattern pages/forms/css in Textmate

#7 2006-05-20 12:01:04

Re: Edit your textpattern pages/forms/css in Textmate

#8 2006-05-20 15:13:19

Re: Edit your textpattern pages/forms/css in Textmate

#9 2006-05-25 11:40:06

Re: Edit your textpattern pages/forms/css in Textmate

#10 2006-05-25 14:11:18

Re: Edit your textpattern pages/forms/css in Textmate

#11 2006-05-25 15:23:14

Re: Edit your textpattern pages/forms/css in Textmate

#12 2006-05-28 09:32:30

Re: Edit your textpattern pages/forms/css in Textmate

#13 2006-05-28 20:27:55

Re: Edit your textpattern pages/forms/css in Textmate

#14 2006-05-29 07:17:59

Re: Edit your textpattern pages/forms/css in Textmate

#15 2006-10-01 02:25:38

Re: Edit your textpattern pages/forms/css in Textmate

Board footer