Quick question, and some background info.
I finally have a project that I think will fit in with ISIS perfectly. An
application project was created about a year or so ago using Rails and
PostgreSQL as the DB. The developer who built the app, left no documentation
and the web-admins actually had to scan the network to find the rails source
code that he used. I know nothing about Rails, but I've taken on the task to
port it into Java, and I think it will work great with ISIS
I want to get some feedback from the isis users to get some initial questions
answered, and in the future, I in turn, can provide some community feedback as
the migration from rails to ISIS proceeds.
The existing app only has about 35 users. So its fairly small.
Short term ToDOs:
1. Use the existing rails table schema as a start point for the domain objects
(subject to change of course, as the project progresses)
2. Use the domain objects to create the PostgresSQL tables for the new ISIS
port.
3. Create some rough functionality for the app, just to get a feel of ISIS and
how it works with the DB and the HTML Viewer.
Longer Term ToDos:
1. Work with users for defined use cases (they currently have none)
2. Import the existing data into the new ISIS port Database Tables.
3. Use the Use Cases to develop the actions and interactions for the domain
objects.
=========== Current status and questions I have ========
I just ran the new 2.0 archtype and created my project, and I have imported it
into Eclipse 3.7
The "projects" I imported are these.
Assignments
Assignments-dom
Assignments-fixture
Assignments-objstore-dflt
Assignments-tests-bdd
Assignments-tests-junit
Assignments-webapp
I am using PostgreSQL 9.1 for the database.
In which project pom do I put in the PostgreSQL driver dependencies (does
anyone have an example for Postgresql 9.1?
Which isis.properties file do I setup my Postgresql Datasource in? I assume
it's the Assignments-webapp
==================================
==================================
Here is the Rails Schema, but its just a baseline that I'm to use as the
starting point for my ISIS Domain Objects.
Again, I'll use ISIS itself to actually create the tables.
======== Rails Scheme Begin =========
create_table "airports", :force => true do |t|
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "assignments", :force => true do |t|
t.integer "worker_id"
t.integer "job_id"
t.datetime "_start"
t.datetime "_end"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "categories", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "histories", :force => true do |t|
t.integer "summary_id"
t.integer "job_id"
t.integer "number", :default => 0
t.float "hours", :default => 0.0
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "jobs", :force => true do |t|
t.string "name"
t.integer "category_id"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "lids", :force => true do |t|
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "logs", :force => true do |t|
t.integer "shift_id"
t.integer "user_id"
t.text "log_text"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "positions", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "shifts", :force => true do |t|
t.date "date"
t.string "name"
t.datetime "_start"
t.datetime "_end"
t.boolean "assigned", :default => false, :null => false
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "summaries", :force => true do |t|
t.integer "user_id"
t.string "stype"
t.integer "number", :default => 0
t.float "hours", :default => 0.0
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "templates", :force => true do |t|
t.string "stype"
t.boolean "weekend", :default => false, :null => false
t.datetime "_start"
t.datetime "_end"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "tjobs", :force => true do |t|
t.integer "template_id"
t.integer "position"
t.integer "job_id"
t.integer "parent_id"
t.datetime "_start"
t.datetime "_end"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "users", :force => true do |t|
t.string "last"
t.string "first"
t.string "initials"
t.string "email"
t.integer "hours"
t.time "day_start"
t.time "eve_start"
t.time "mid_start"
t.datetime "created_at"
t.datetime "updated_at"
t.string "encrypted_password"
t.string "salt"
t.boolean "admin"
t.boolean "active"
t.integer "position_id"
end
create_table "workers", :force => true do |t|
t.integer "shift_id"
t.integer "user_id"
t.integer "position_id"
t.datetime "_start"
t.datetime "_end"
t.datetime "created_at"
t.datetime "updated_at"
end
======== Rails Scheme END =========
Jason Richardson
This electronic message contains information generated by the USDA solely for
the intended recipients. Any unauthorized interception of this message or the
use or disclosure of the information it contains may violate the law and
subject the violator to civil or criminal penalties. If you believe you have
received this message in error, please notify the sender and delete the email
immediately.
