Project Code Structure

[danwells]

Initial File/Methods/Data Structure

File Structure

• Project /
  • .rspec
  • Gemfile
  • Gemfile.lock
  • config.ru
  • spec/
  • spec_helper.rb
  • _misc-class__spec.rb files
  • features/
    • _misc-views__spec.rb files
  • app/
  • main.rb
  • functions.rb (if needed)
  • views/
    • layout.erb
    • bloghome.erb
    • contact.erb
    • about.erb
  • dbfiles/
    • blog_data.db (one data base replaces previously planned four databases)
    • titles table
    • toc table
    • articles table from articles.db
    • view_options table
    • results table
    • authors table
    • commenters table
    • articles table
    • sections table
    • contents table
    • media table
    • navigation.db
    • titles table
    • toc table
    • articles table from articles.db
    • view_options table
    • search.db
    • results table
    • contributers.db
    • authors table
    • commenters table
    • articles.db
    • articles table
    • sections table
    • contents table
    • media table

      Model

      Database/Tables

• blog_data.db
  • nav tables (titles, toc, view_options)
  • search table (results)
  • contributers tables (authors, commenters)
  • articles tables (articles, sections, contents, media)
• navigation.db
  • tables (titles, toc, view_options)
• search.db
  • tables (results)
• contributers.db
  • tables (authors, commenters)
• articles.db
  • tables (articles, sections, contents, media)

    Classes/Modules

• One ActiveRecord class for each table
• PersonalData module (if needed) for utility methods handling authors/commenters

  View

• layout.erb
• bloghome.erb
• contact.erb
• about.erb

  Controller

• main.rb (sinatra)
  • "/"
  • "/search"
  • "/about"
  • "/contact_info"
• ActiveRecord (table classes, query functions)

[danwells]

After discussion in today's class, it will be better to combine the four database files into one overarching database file. Plan is call the single database file blog_data.db and combine all tables into this file.

[danwells]

(OLD Version) Visual Layout for Tables used in database (initial attempt)

[danwells]

(OLD Version) Visual Layout for Tables

• Previous version had the foreign keys (belongs_to/has_many relationships) reversed. Also added a search_results table.

[danwells]

UPDATE 2 Visual Layout for Tables

• Rearranged/renamed fields. Added relationship connections.