The newLISP on Rockets blog


Post #: 20
Post type: Blog post
Date: 2012-09-21 00:01:21.000
Author: Rocket Man

There's no millisecond thingy to say how fast this or how many resources were used in its making.

Comments (1)

Views: 4068


Post #: 19
Post type: Blog post
Date: 2012-09-18 00:17:03.000
Author: Rocket Man

you see, that's why I can't be left alone with a programming language, I don't know shit.

Since we all live as RocketMan - numbies will be my sig

Views: 3916

Spell check

Post #: 18
Post type: Blog post
Date: 2012-09-18 00:14:30.000
Author: Rocket Man

That service would be provided by your web browser... :)

Views: 3849


Post #: 17
Post type: Blog post
Date: 2012-09-18 00:12:14.000
Author: Rocket Man

Well, tried to just enter something in the top box and got sent away but now I am back about to make a non historical supporting post. There's spell check in here too?

How cool is that?

Views: 3966

Where's the Code?? WHERE'S THE CODE???

Post #: 15
Post type: Blog post
Date: 2012-09-17 23:28:59.000
Author: Rocket Man

This, apparently, being the first thing that gets asked.

Well, it's not much, but it's here:

Comments (1)

Views: 4396


Post #: 14
Post type: Blog post
Date: 2012-09-17 21:53:14.000
Author: Rocket Man

Encoding fun...

What happens if someone puts in a URL? The framework should translate the special characters, but it is the blog software itself that should translate it into a clickable link.

Of course, that doesn't mean I can't make a function to turn URLs into links automatically (and do other post-entry formatting of blog post text) and include it in Rockets...

Views: 4986

Utilizing the power of LISP macros

Post #: 13
Post type: Blog post
Date: 2012-11-02 17:24:39.000
Author: Rocket Man

Today's function turned out to be well suited for a macro. (create-record) takes a couple of arguments. The first is a string which holds the name of the table you are updating. The rest is kind of cool. You put in a bunch of variable names--any number is fine--and what you do is make the variable name the same as the FIELD name in your table. Then the macro takes the names and values of these variables and constructs a valid SQL statement (after filtering each value for SQL injection issues)

So, for example, to add a post in this blog, I just have to write:

(create-record "Posts" Id PosterId PostDate PostSubject PostContent)

and it generates a valid SQLite query to insert the values into the field names that are the variables Id, PosterId, etc.

The magic comes from newLISPs (sym) function, which converts a string into a valid symbol, and the (args) feature of newLISP macros, which allow a dynamic number of arguments to be passed to the macro.

Here's the code that converts the variable names into symbols:

(dolist (s (rest (args)))
(set 'temp-index-num (string 'idx)) ; we need to number the symbols to keep them in the correct order
(if (= (length temp-index-num) 1) (set 'temp-index-num (string "0" temp-index-num))) ; leading 0 keeps the max at 100.
(sym (string temp-index-num s) 'DB))

I have to prepend a numeric value to the symbols to ensure they get posted into the list (symbols 'DB) in the correct order-- right now the limit is 100 fields but I could easily bump this to 1000 if I need to, or even higher... I want to keep this limit in here for now as a kind of sanity check though.

So, the C part of CRUD is done.. just three more parts to go!

Comments (1)

Views: 4051

The very first post on the newLISP on Rockets Blog!

Post #: 0
Post type: Blog post
Date: 2012-09-13 23:01:09.000
Author: Rocket Man

Wow, this is kind of historic! This is the very first post on the newLISP on Rockets blog. Right now Rockets is barely functional (version 0.04!) but it's just enough to host itself and handle input to forms and connect to a SQLite 3 database.

It's nothing earth-shattering so far, but I want to start "eating my own dogfood" as it were, so this blog will be running on Rockets from the very beginning. As I add features, I'll post about them in the blog.

Views: 3853