You cannot post messages because only members can post, and you are not currently a member.
Description:
This is a discussion list for Sequel, the easy database access library for Ruby.
|
|
|
Check if table exist,
|
| |
Hello there,
Can you tell me how I can check if a table already exist, in the
database. My aim is to create a script that check if the particular
table is there, else create it.
regards,
Hari
|
|
|
Sequel ORM connecting Oracle thru JDBC
|
| |
Hello Sequel team,
Currently I am working on a solution to migrate an existing Java web
app which is more dependent on Oracle Pl/SQL stored procs for most of
its business logics, onto a Jruby platform,
Looking thru all existing frameworks on Jruby, I thought it would be
better option to use Sinatra & sequel ORM stack which has good support... more »
|
|
|
Why Sequel::Model.initialize from_db is being deprecated
|
| |
Hi,
I'm currently using Sequel, but very minimally and try to avoid any
sort of magic
when I can. That means basically:
- for insert / update / deletion of models
- basic associations
For anything more complex (i.e. joins), I prefer to write the SQL by
hand, as
it's easier to analyze and to debug code later on.... more »
|
|
|
Sharing same postgresql parser with ActiveRecord
|
| |
Hi, There's been lots of activity in the postgresql world in the past couple years. Arrays, hstores, ranges, json, etc. AR's postgresql adapter in 4.0 will have support for mapping ruby types to custom postgresql types ([link]). I've noticed that sequel, AR's postgresql adapter, and... more »
|
|
|
Sequel 3.36.0 Released
|
| |
Sequel 3.36.0 has been released and should be available on the gem mirrors. = New Features * An eager_each plugin has been added, which automatically makes eagerly loaded datasets do eager loading if you call #each (or another Enumerable method) instead of #all. By default, if you call #each on an eager dataset, it will not do eager loading,... more »
|
|
|
disconnect from database
|
| |
I'm running sequel on sinatra, and I have a method to get the content from database: def getContent(sql) require 'sequel' dsn={ :adapter=>"oracle", :database=>"mydb", :user=>"myuser", :password=>"mypassword" } connection = Sequel.connect(dsn) res=connection.fetch(sql)... more »
|
|
|
disconnect from db
|
| |
I'm using Sequel with Sinatra and I created a method to get the content from database, something like: def getContent(sql) require 'sequel' dsn={ :adapter=>"oracle", :database=>"mydatabase", :user=>"myuser", :password=>"mypassword" } connection = Sequel.connect(dsn)... more »
|
|
|
MSSQL 2003 wildcard
|
| |
My goal is to retrieve a dataset based from a combination of a LIKE operator (since MSSQL doesn't support regex): To illustrate my point, here is a definition prototype: def_dataset_method(:commercial _members) do filter(:mem_lob.like('1%'), (:mem_lob.like('2%')).sql_or) end "return a filtered dataset with mem_lob are like 1* or 2* "... more »
|
|
|
advanced many_to_many association help
|
| |
Hi all, I'm new to Sequel and am trying to solve the case in a many-to-many relationship where the join table has a third column that is used to define relationship 'type'. A common example might be to define the role of an account related to some "thing". Here's an example to get started: class Account < Sequel::Model... more »
|
|
|
