just create migration scripts named
migrations/<nnn>-up-<some-text>.sql and myplc will apply them at start time
I am unsure whether wildcards are supported in setup.py, checking that..
--- /dev/null
+-- this is mostly sample code
+-- since subversion is also created by the migration code in plc.d/db
+
+ALTER TABLE plc_db_version ADD subversion integer DEFAULT 0;
--- /dev/null
+Store here migration scripts, named
+<nnn>-up-any-text.sql
+with contiguous indices starting with 001
--
-- Copyright (C) 2006 The Trustees of Princeton University
--
--
-- Copyright (C) 2006 The Trustees of Princeton University
--
--- $Id: planetlab4.sql,v 1.66 2007/01/29 20:13:12 mlhuang Exp $
+-- $Id: planetlab4.sql,v 1.67 2007/01/29 20:48:27 mlhuang Exp $
--
--------------------------------------------------------------------------------
--
--------------------------------------------------------------------------------
-- Database version
CREATE TABLE plc_db_version (
version integer NOT NULL
-- Database version
CREATE TABLE plc_db_version (
version integer NOT NULL
+-- subversion created on demand by plc.d/db
) WITH OIDS;
INSERT INTO plc_db_version (version) VALUES (4);
) WITH OIDS;
INSERT INTO plc_db_version (version) VALUES (4);
# Mark Huang <mlhuang@cs.princeton.edu>
# Copyright (C) 2006 The Trustees of Princeton University
#
# Mark Huang <mlhuang@cs.princeton.edu>
# Copyright (C) 2006 The Trustees of Princeton University
#
-# $Id: setup.py,v 1.4 2006/10/27 20:08:46 mlhuang Exp $
+# $Id: setup.py,v 1.5 2007/01/09 16:33:16 mlhuang Exp $
#
from distutils.core import setup
#
from distutils.core import setup
packages = ['PLC', 'PLC/Methods', 'PLC/Methods/system'],
scripts = ['plcsh', 'Server.py', 'Test.py'],
data_files = [('', ['planetlab4.sql']),
packages = ['PLC', 'PLC/Methods', 'PLC/Methods/system'],
scripts = ['plcsh', 'Server.py', 'Test.py'],
data_files = [('', ['planetlab4.sql']),
- ('php', ['php/plc_api.php'])])
+ ('php', ['php/plc_api.php']),
+ ('migrations', ['migrations/*.sql','migrations/README.txt'])])