perldiver: A false-color multi-spectrum image of Sol. (Default)
This is a note for my professional memory. If you aren't a Catalyst programmer, feel free to skip it, but it's public so that Google can make it available to anyone who needs it.

My preferred webapp construction sequence starts as follows:
  1. Design ERDs in SQLEditor
  2. Export to .sql file for reference and so it's easy to have a "postflight.sql" script to add data, triggers, etc
  3. Import the .sql files into a SQLite DB
  4. Use helper scripts to generate a Catalyst app
  5. Use helper scripts to generate a DBIx::Class model against the SQLite DB
There are a few important things to know about step #5. First, the magic incantation can be found in this doc.(I always have to fumble around through the whole sequence to remember which it is.)

The second thing to know is that the Catalyst / DBIC helper scripts cannot handle any of the following constructs, all of which are legal for SQLite:
  1. IF NOT EXISTS in a create statement [e.g., do: CREATE TABLE foo... , not: CREATE TABEL foo IF NOT EXISTS...]
  2. Quotes around identifiers [e.g. do: CREATE TABLE foo , not: CREATE TABLE 'foo' ; same for column names, etc
I thought for a moment that putting the table name on the index would also break it, but actually the jury is still out on that; I didn't have any indexes in my create scripts.

Reply

From:
Anonymous( )Anonymous This account has disabled anonymous posting.
OpenID( )OpenID You can comment on this post while signed in with an account from many other sites, once you have confirmed your email address. Sign in using OpenID.
User
Account name:
Password:
If you don't have an account you can create one now.
Subject:
HTML doesn't work in the subject.

Message:

 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

December

SunMonTueWedThuFriSat
      1
 
2
 
3
 
4
 
5 6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
 
16
 
17
 
18
 
19
 
20
 
21
 
22 23
 
24
 
25
 
26
 
27
 
28
 
29
 
30
 
31