sequel.rubyforge.org Archives - 25 April 2014, Friday

  • Sequel::MySQL::DatasetMethods

    sequel.rubyforge.org 23 Oct '13, 8am

    Sets up the insert methods to use ON DUPLICATE KEY UPDATE If you pass no arguments, ALL fields will be updated with the new values. If you pass the fields you want then ONLY those field will be updated.

  • Symbol

    sequel.rubyforge.org 10 Oct '13, 10am

    class Symbol lib/sequel/extensions/core_extensions.rb Parent: core_extensions.rb Sequel extends Symbol to add methods to implement the SQL DSL. Methods Public Instance identifier sql_function Included modules Sequel::SQL::AliasMethods Sequel::SQL::CastMethods Sequel::SQL::OrderMethods...

  • code_order.rdoc

    sequel.rubyforge.org 07 Oct '13, 4pm

    code_order.rdoc doc/code_order.rdoc Last Update: 2013-06-06 17:24:35 -0700 Code Order In Sequel , the order in which code is executed is important. This guide provides the recommended way to order your Sequel code. Some of these guidelines are not strictly necessary, but others are, a...

  • querying.rdoc

    sequel.rubyforge.org 28 Sep '13, 2pm

    Note that the retrieval methods discussed above just return the row(s) included in the existing dataset. In most cases, you aren't interested in every row in a table, but in a subset of the rows, based on some criteria. In Sequel , filtering the dataset is generally done separately th...

  • Sequel::Plugins::PgRow

    sequel.rubyforge.org 12 May '13, 8pm

    The pg_row plugin allows you to use Sequel::Model classes as composite type classes, via the pg_row extension. So if you have an address table: DB.create_table(:address) do String :street String :city String :zip end and a company table with an address: DB.create_table(:company) do St...

  • Sequel::Model::ClassMethods

    sequel.rubyforge.org 16 Apr '13, 3pm

    Whether to raise an error when unable to typecast data for a column (default: true). This should be set to false if you want to use validations to display nice error messages to the user (e.g. most web applications). You can use the validates_not_string validations (from either the va...

  • active_record.rdoc

    sequel.rubyforge.org 16 Apr '13, 7am

    and ActiveRecord use the active record pattern of database access, where model instances are objects that wrap a row in a database table or view, encapsulating the database access, and adding domain logic on that data. Just like ActiveRecord, Sequel supports both associations and inhe...

  • Sequel: The Database Toolkit for Ruby - Documentation

    sequel.rubyforge.org 04 Apr '13, 3am

    Jeremy Evans's "The Development of Sequel" Presentation in May 2012 at Heroku Jeremy Evans's "Sequel: The Database Toolkit for Ruby" Presentation at PostgreSQL Conference West 2011 Jeremy Evans's "Sequel: SQL in Ruby" Presentation at Lone Star Ruby Conference 2009 Jeremy Evans's "Sequ...

    Related:
    1. ANN: Sequel 3.46.0 Released ruby-forum.com 02 Apr '13, 5pm
  • Sequel::Dataset

    sequel.rubyforge.org 28 Mar '13, 7pm

    Should be a hash with keys being symbols of column aliases, and values being either symbols or arrays with one to three elements. If the value is a symbol, it is assumed to be the same as a one element array containing that symbol. The first element of the array should be the table al...

  • dataset_filtering.rdoc

    sequel.rubyforge.org 23 Mar '13, 6pm

    dataset_filtering.rdoc doc/dataset_filtering.rdoc Last Update: 2012-07-13 09:26:05 -0700 Dataset Filtering Sequel is very flexibile when it comes to filtering records. You can specify your conditions as a custom string, as a string with parameters, as a hash of values to compare again...

  • sql.rdoc

    sequel.rubyforge.org 26 Jul '12, 7am

    actually does internally is two separate things. It first creates a dataset representing the query, and then it executes the dataset's SQL code to retrieve the objects. Often, you want to define a dataset at some point, but not execute it till later. You can do this by leaving off the...

  • 3.37.0.txt

    sequel.rubyforge.org 03 Jul '12, 1pm

    A pg_range extension has been added, making it easy to deal with PostgreSQL 9.2+'s range types. As ruby's Range class does not support all PostgreSQL range type values (such as empty ranges, unbounded ranges, or ranges with an exlusive beginning), range types are returned as instances...

    Related:
    1. ANN: Sequel 3.37.0 Released ruby-forum.com 03 Jul '12, 2pm
  • pg_json.rb

    sequel.rubyforge.org 29 Jun '12, 11pm

    The pg_json extension adds support for Sequel to handle PostgreSQL's json type. It is slightly more strict than the PostgreSQL json type in that the object returned must be an array or object (PostgreSQL's json type considers plain numbers and strings as valid). This is because Sequel...

  • dataset_basics.rdoc

    sequel.rubyforge.org 15 May '12, 7am

    Datasets are probably the thing that separate Sequel from other database libraries. While most database libraries have specific support for updating all records or only a single record, Sequel's ability to represent SQL queries themselves as objects is what gives Sequel most of its po...

  • migration.rdoc

    sequel.rubyforge.org 06 May '12, 11pm

    Migrations are optional, you don't have to use them. You can always just create the necessary database structure manually using Sequel's schema modification methods or another database tool. However, if you are dealing with other developers, you'll have to send them all of the changes...

  • opening_databases.rdoc

    sequel.rubyforge.org 24 Apr '12, 11am

    Note that using an adapter method forces the use of the specified adapter, not a database type, even though some adapters have the same name as the database type. So if you want to connect to SQLite, for example, you can do so using the sqlite, do, dbi, jdbc, odbc, and swift adapters....

  • cheat_sheet.rdoc

    sequel.rubyforge.org 18 Apr '12, 2am

    cheat_sheet.rdoc doc/cheat_sheet.rdoc Last Update: 2011-07-16 11:31:03 -0700 Cheat Sheet Open a database require 'rubygems' require 'sequel' DB = Sequel.sqlite('my_blog.db') DB = Sequel.connect('postgres://user:password@localhost/my_db') DB = Sequel.postgres('my_db', :user => 'user', ...

  • Sequel: The Database Toolkit for Ruby

    sequel.rubyforge.org 06 Apr '12, 6am

    Sequel provides thread safety, connection pooling and a concise DSL for constructing SQL queries and table schemas. Sequel includes a comprehensive ORM layer for mapping records to Ruby objects and handling associated records. Sequel supports advanced database features such as prepare...

  • virtual_rows.rdoc

    sequel.rubyforge.org 25 Mar '12, 5pm

    There are two related differences here. First is the usage of "o.c" vs "c", and second is the difference between the the use of "a". In the regular proc, you couldn't call c without an explicit receiver in the proc, unless the self of the surrounding scope responded to it. For a, note...

  • Sequel: The Database Toolkit for Ruby

    sequel.rubyforge.org 03 Mar '12, 11am

    Sequel provides thread safety, connection pooling and a concise DSL for constructing SQL queries and table schemas. Sequel includes a comprehensive ORM layer for mapping records to Ruby objects and handling associated records. Sequel supports advanced database features such as prepare...

  • README.rdoc

    sequel.rubyforge.org 03 Mar '12, 12am

    Sequel provides thread safety, connection pooling and a concise DSL for constructing SQL queries and table schemas. Sequel includes a comprehensive ORM layer for mapping records to Ruby objects and handling associated records. Sequel supports advanced database features such as prepare...