Spica - Simple Primary Interface and Core Application

• top > toybox
• Japanese [日本語]

• spica.js
• Making a skeleton
• About Spica

spica - Skeleton generator

Spica contains spica as the skeleton generator which provides simple interaction interface to create the template of a CGI application.

• enter perl spica on command line(terminal) to run spica.
• type help in spica to show help.

The following sample shows an example flow to create the project "sample".

• Using SQLite as database engine and setting "./data/sample.db" as a database file.
• Defining "Spica::Data::Bookmark" and creating the table for "Spica::Data::Bookmark" which is defined as:
  • id
  • name => varchar 256
  • url => varchar 256
  • stat => interger (assumed to indicate as a status flag)
  • description => text

$ perl spica

==/ Spica - Simple Primary Interface and Core Application /==
----- Copyright (C) 2005 SimpleBoxes/SerendipityNZ Ltd. -----
----- Copyright (C) 2005 Spica Project Kei/Fuco/Takkyun -----
======================================= Spica Version : 1.00

spica> create sample
creating project ... sample
* select driver [0]MySQL [1]Text [2]SQLite ?
    :> 2
* input name [default => ./sqlite/data.db] ?
    :> ./data/sample.db
* input sqlite2 [default => ] ?
    :> 
project "sample" is created!
spica> define bookmark
creating table ... Bookmark
    :> name str(256)
    :> url str(256)
    :> stat int
    :> description text
    :> ;
creating [Bookmark] ...  done
creating table in database ... done
"Spica::Data::Bookmark" is created!
spica>exit
$