from:"BeeRich33"

This just tested, which works fine:

a = DR[:company_t].where(Sequel.ilike(:company_name, 
'%Tru%')).where(status: 'active')


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/2d8db812-f8b0-409d-8355-e097b769f799%40googlegroups.com.

Query Error

I get an error on the following query:

a = DR[:company_t].where(Sequel.ilike(:company_name, '%Tru%') & (status: 
'active'))


The error:

syntax error, unexpected tLABEL
...mpany_name, '%Tru%') & (*status*: 'active'))

status is a field name.  

According to the Queries documentation page, this is apparently good.  

Artist.where(Sequel.like(:name, 'Y%') & (Sequel[{b: 1}] | Sequel.~(c: 3)))


Any insight as to why this is tripping?  It doesn't like my fieldname.  

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/9345d12c-7b76-40f0-956e-bf2fd1413e53%40googlegroups.com.

Re: Filtering & Subqueries

I'm facing items like this:

SELECT DISTINCT ON (listing_t.product_name) listing_t.product_name, 
company_t.company_name, company_t.company_address, 
  company_t.company_city, company_t.company_province, company_t.
company_url, company_t.company_phone,
FROM listing_t inner join s_ad_contracts_t on 
s_ad_contracts_t.contract_company_id 
= listing_t.product_company_id
  inner join company_t on company_t.scid = s_ad_contracts_t.
contract_company_id
WHERE company_t.status = 'active'
  AND listing_t.status = 'active'
  AND s_ad_contracts_t.contract_status = 'active'
  AND listing_t.product_name ILIKE '#{ submitted }'
ORDER BY listing_t.product_name, company_t.company_name
LIMIT 100

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/a738bd6a-8424-4b76-bfdb-6d64673f780d%40googlegroups.com.

Re: Filtering & Subqueries

Well, I've moved to a .left_join which has me satisfied so far.  There 
isn't anything specific I'm trying to translate.  Just trying to get my 
head around this approach.  But two questions:

Given that every table that I include might have a *creation_date* field, 
how can I decipher between which table I need to select it from?  For 
clarity:

tableone.creation_at
tabletwo.creation_at

Ultimately, I'd like to use the Sequel subset capabilities in order to get 
to qualified fields in those various tables.  I've been looking for a way 
to decipher between table names, however a dataset starts with a single 
table.  At this point it's sounding like getting an array of qualified 
keyfield values for an IN statement.  The documentation for subqueries 
comes in multiple statements.  I have a three-table join that I am facing 
and it would be ideal to do this by avoiding joins.

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/2136a8f2-8015-4f1f-a0cc-a7dcce86ee7d%40googlegroups.com.

Re: Sequel.extract Day from Duration

Solved:  Turns out there's no extraction needed.  

Sequel.cast(Time.now, Date) - Sequel.cast(:creation_at, Date)

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/401c4f3d-98e9-4eff-a85b-d3f02945caa9%40googlegroups.com.

Sequel.extract Day from Duration

2020-02-17 Thread BeeRich33

Hi there.  I'm trying to get Sequel.extract working to measure the duration 
between a queried field value and Time.now.

This is what I've been trying: (:creation_date is the date field)
# start = Date.today - 421
puts Sequel.extract(:day, Sequel.cast(Time.now, Date) - Sequel.cast(:
creation_at, Date)).as(:age)  # reference: alpha

puts Sequel[Time.now - Sequel.cast(:creation_at, Date)].extract(:day) # 
reference: bravo

Corresponding sql for PostgreSQL:

EXTRACT(day FROM (SELECT now()-creation_at)) AS age

Alpha comes up with a numeric expression but I can't seem to get anything 
out of it.  Bravo gives me errors.  I thought this would have resulted in a 
hash such as:

{:age => 421}

I'm assuming this type of extraction can be pulled out of a duration, 
seeing that this is a PostgreSQL aspect rather than Sequel.

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/55c02b19-eeaf-4ef7-98ec-4b8376201ed3%40googlegroups.com.

Filtering & Subqueries

2020-02-17 Thread BeeRich33

I'm using Dataset Filtering to narrow down a final Dataset.  

I need to grab field values from those various tables.  How can I reference 
different fields, given that this is a roundabout way of performing a 
join?  

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/a661dab4-83b8-4495-bb4a-12b3e3d3a785%40googlegroups.com.

Re: Dysfunctional Relationship?

2020-02-12 Thread BeeRich33

Excellent.  Thank you.  

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/4eab564f-2f8f-4f4d-9c41-00532e97e53d%40googlegroups.com.

Re: Dysfunctional Relationship?

2020-02-12 Thread BeeRich33

OK, just found something here.

I have two connections going on.  My projects have different connections 
belonging to different constants such as DR and DBL.  DBL was ahead of this 
DR I have here.  I moved DR above DBL (which has no :user table), and it 
worked.

Can I not have multiple connections open?  

I can see a possible conflict where two databases can have the same table 
name.  In that class declaration, Can I provide a database and table name 
as parameters instead of the sole table name?

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/f0b5a512-579c-4ef7-97af-080659eed7be%40googlegroups.com.

Dysfunctional Relationship?

2020-02-12 Thread BeeRich33

Hi there.  

I've declared a connection, which I have tested:

puts DR.inspect
DR[:user].each do |i|
  ap i
  puts
end

Works fine.  

I go to declare a class and that relationship is missing:

class User < Sequel::Model(:user)
end

PG is indicating the relation is missing:

ERROR:  relation "user" does not exist (PG::UndefinedTable)
LINE 1: SELECT * FROM "user" LIMIT 1

How does it disappear?  How can I fix this?

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/02b89bbe-fdb3-43f2-9cf9-09e652e38f5f%40googlegroups.com.

Re: PostgreSQL Error Returned?

2020-02-10 Thread BeeRich33

Ya I think there is.  That err_message I think is coming from pg, or is 
that transparent right from PostgreSQL?  Again, I haven't chased where it's 
used, so maybe it was just for development feedback.  I thought that there 
would be something like a "returning id" type of feedback, which I know 
is PostgreSQL.  In fact, I think I will be needing that soon, for inserts.  


On Monday, February 10, 2020 at 5:54:30 PM UTC-5, Jeremy Evans wrote:
>
> On Monday, February 10, 2020 at 1:04:14 PM UTC-8, BeeRich33 wrote:
>>
>> Ah ok.  
>>
>> I'm redoing some stuff, so it's not imperative I stick to anything.  
>> Essentially, leaving INSERT or DELETE commands without any capture of 
>> errors makes me lose sleep at night.  With pg, it would have 
>> res.error_message which was returned so some kind of $SDOUT or some kind of 
>> feedback.  
>>
>
> Maybe there is a misunderstanding.  With Sequel, if a database query 
> causes a database error, that is raised as a Ruby exception.  So unless you 
> are rescuing the exception and purposely choosing to ignore it, you must 
> handle it or the program stops running and outputs a backtrace.
>
> Thanks,
> Jeremy
>

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/0113f959-86c0-436a-a544-15f1cdd2bc44%40googlegroups.com.

Re: PostgreSQL Error Returned?

2020-02-10 Thread BeeRich33

Ah ok.  

I'm redoing some stuff, so it's not imperative I stick to anything.  
Essentially, leaving INSERT or DELETE commands without any capture of 
errors makes me lose sleep at night.  With pg, it would have 
res.error_message which was returned so some kind of $SDOUT or some kind of 
feedback.  

On Monday, February 10, 2020 at 3:46:53 PM UTC-5, Jeremy Evans wrote:
>
> On Monday, February 10, 2020 at 12:27:26 PM UTC-8, BeeRich33 wrote:
>>
>> Is there any way I can replicate a *PG* gem error message?
>>
>> return res.error_message
>>
>
> In general, Sequel wraps driver errors and uses the same message preceded 
> by the exception class name. The underlying exception is available in 
> #wrapped_exception, and maybe #cause in modern versions of Ruby.
>
> If that isn't enough information to go on, you'll have to provide an 
> example of what you want.  
>
> Thanks,
> Jeremy
>

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/b473859b-1510-434b-bd1b-e6c11462e874%40googlegroups.com.

PostgreSQL Error Returned?

2020-02-10 Thread BeeRich33

Is there any way I can replicate a *PG* gem error message?

return res.error_message




-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/47a18324-0f62-45bd-a3ca-8ccc29bd7904%40googlegroups.com.

Re: Mapping Tablename with Object

2020-02-03 Thread BeeRich33

A million thanks.  Saved my arse.  

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/3bce5e5a-a966-484c-89dd-e5aab29b13a3%40googlegroups.com.

Re: Mapping Tablename with Object

2020-02-03 Thread BeeRich33

I'm trying to inherit Sequel::Model but it won't see the table name, as the 
Sequel table recognition algos don't expect what they're currently named.

I tend to choose a little obscure table names as it adds a layer of 
security.  I guess it's caught me in the ass now.  Unless I'm overlooking 
something, can I keep those unexpected table names?

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/b061a16f-2fac-4948-aaae-34c8815c6cae%40googlegroups.com.

Re: .inspect Showing Empty Object

2020-01-23 Thread BeeRich33

Oh I see.  So all the functionality of that still works through Sequel 
magic I'm guessing?


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/e04d6ac3-89bb-4a65-84da-6630a63cc378%40googlegroups.com.

Re: .inspect Showing Empty Object

2020-01-22 Thread BeeRich33

Taking out Sequel, I get expected feedback:

#
#
#
#


Cobb
4°C
nry
2020-01-23 02:49:47 -0500
On Hold


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/c5b52cff-5ca3-4ee0-80ce-1e0d1713cd6d%40googlegroups.com.

.inspect Showing Empty Object

2020-01-22 Thread BeeRich33

Hi Sequel people.  I've read the documents from more than one source and 
it's still not working.

Code: 
DBL.create_table? :salads do  # works
  primary_key :id
  String :name, size: 200
  Integer :temp
  String :review
  DateTime :cdate
  DateTime :mdate
  String :status
end

class Salad < Sequel::Model
attr_accessor :id, :name, :temp, :review, :cdate, :mdate, :status
def initialize(args = nil)
  @name = nil
  @temp = 'cold'
  @review = 'nry'
  @cdate = Time.now
  @status = 'new' 
end
set_primary_key [:id]

#   self.strict_param_setting = false
end

a = Salad.new
puts a.inspect # empty

a.name = 'Cobb'
puts a.inspect # empty

a.temp = '4°C'
puts a.inspect # empty

a.status = 'On Hold'
puts a.inspect # empty

puts "values: #{ a.values }" # empty

puts
puts a.name # works
puts a.temp # works
puts a.review # works
puts a.cdate # works
puts a.status # works

Table created, class definition works.  Instantiation works.  Changing 
properties works.  

The issue is that the Sequel methods aren't working.

a.inspect brings up empty objects as seen below.
a.values also is empty.

Results:
#
#
#
#
values:



Cobb
4°C
nry
2020-01-23 02:30:56 -0500
On Hold

I'm sure it's something obvious, but what am I missing?  

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/2a0711dc-6bc8-4f0c-ab75-a8c001501e6b%40googlegroups.com.

Re: Variable into Sequel.cast

2020-01-20 Thread BeeRich33

OK, it was apparently working for me somehow.  Anyway, in Sequel, is this 
the proper sequence for a var placeholder?  It works but I'm confused about 
the *:interval* casting type, and its position within that Sequel.cast:

where(Sequel.cast(:login_date, Date) > Sequel.cast(Sequel::CURRENT_DATE - 
Sequel.cast((? 'days', 30) :interval), Date))

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/22c08ffe-9a03-42cd-b56b-b719fb752240%40googlegroups.com.

Re: Variable into Sequel.cast

2020-01-19 Thread BeeRich33

This is how I've been using it, now currently replaced with "30 days" 
manually.  I'd like to shove a variable in there.  

tm = PG::TypeMapByColumn.new([
  PG::TextEncoder::String.new
  ])
d = d.to_s

res = $conn.exec_params( %Q{ SELECT search_phrase, count(search_phrase) 
  FROM searches 
  WHERE creation_date::timestamp::date > (CURRENT_DATE - interval '$1 
days')::date 
AND search_phrase != 'about'
  GROUP BY search_phrase 
  ORDER BY count(search_phrase) DESC }, [ d ], 0, tm ).to_a



-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/37db9845-c5bc-4771-af53-83cef8ee29da%40googlegroups.com.

Re: Select Fields Not Empty (nil)

2020-01-19 Thread BeeRich33

Hi.  Sorry for the delay.  Fighting a now 4-week cold, been out of 
commission.

Been reading and testing some more, translating my current projects.  I try 
to post generalized examples as this isn't about anything specific.  



-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/1da11bff-dca0-45ef-916b-4c3c896f680b%40googlegroups.com.

Re: Select Fields Not Empty (nil)


>
>
> My apologies for correcting you yet again, hence the questions here in the 
group meant for such questions:

DBS[:searches_t].
where{(exclude(search_phrase: nil))}.
select(:search_phrase, :result_count)


ERROR.  *HINT:  No function matches the given name and argument types. You 
might need to add explicit type casts. *Points to "exclude"

The "Where TRUE" is what the .sql is explaining.  From here:

where{(exclude(:search_phrase = nil) & (:client_ip != '192.168.1.4')}.

Question still not answered.  I've simplified the query to the following, 
which still has no answer:

DBS[:searches_t].
where{(exclude(search_phrase: nil))}.
select(:search_phrase, :result_count)

I've also tried:
DBS[:searches_t].
where{(:search_phrase != nil)}.
select(:search_phrase, :result_count)

=> provides nils.  So that doesn't work.

I've also tried:

DBS[:searches_t].
where{(:search_phrase !~ nil)}.
select(:search_phrase, :result_count)

=> provides nils.  Doesn't work.  

I'm reading as much as I can, and wish to avoid coming in here.  Believe 
me.  


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/37e2cf0c-5960-4ed9-83f2-5749d04f9f27%40googlegroups.com.

Re: Select Fields Not Empty (nil)

Just reviewed it yet again.
>
>
.invert: Nothing to invert.  What is an invert of 'field with something'?

.exclude 'any field value'?  The field values I want to avoid are *nil*, 
not ''.

'not in' doesn't apply as there's no qualifier set.

'not like' doesn't apply.  

Sequel.~ throws an error, "WHERE NOT 'search_phrase'..."

~Sequel. is not applicable.

Negated expressions, !~:  
where{(:search_phrase !~ nil)}.

...returns nil search phrases, so this doesn't work nor apply.

And that's it.  The complete section you just "hinted" about.  

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/d26f699a-6332-44b9-8186-889bb629dcb4%40googlegroups.com.

Re: Select Fields Not Empty (nil)

You need to ask questions before accusing people. That is plain outright
rude.

See, there are obviously multiple websites. Did you know that? I spend
lots of time reviewing here:

http://sequel.jeremyevans.net/rdoc/files/doc/dataset_filtering_rdoc.html

So have some respect. I'd love to not wait for anybody to get back to me.

Nowhere on those pages, does it say anything about not returning empty
fields.

DBS[:searches_t].
where{(:search_phrase != nil) & (:client_ip != '192.168.1.4')}.
select(:search_phrase, Sequel.cast(:creation_date,
DateTime).as(:creation_date), :search_type, :result_count).
reverse(:creation_date).
limit(d).sql

Doesn't resolve properly. Nowhere in the documents does it say anything
about this:

SELECT "search_phrase", CAST("creation_date" AS timestamp) AS
"creation_date", "search_type", "result_count" FROM "searches_t" WHERE true
ORDER BY "creation_date" DESC LIMIT 30

"WHERE true"?

Show me where it's explained. If you can't, then please understand this is
a forum for people looking for answers. If you don't like it, then you
don't have to be here. Maybe you should read the docs. The question is
valid. Maybe you should be respectful and read the question.

--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/fa442373-1a81-4267-9dbe-361a16829e6d%40googlegroups.com.

Select Fields Not Empty (nil)

I can't seem to get a select to work on non-empty fields:

where{(:search_phrase != nil) & (:client_ip != '192.168.1.50')}.

Tried this as well:

where{(:search_phrase != '') & (:client_ip != '192.168.1.4')}.

PostgreSQL registers the field as *null*, but searches come back with *nil* 
as field values.  

How can I eliminate rows with empty fields?  Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/3d150a88-6584-4d08-b24f-90683dc156ae%40googlegroups.com.

Variable into Sequel.cast

My PG syntax has a variable into an interval:

WHERE creation_date::timestamp::date > (CURRENT_DATE - interval '$1 days')::
date

Can I use a variable in Sequel as a parameter passed to this method, for 
use inside this interval integer?

Sequel.cast('? days', 30, :interval)


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/5df736c2-1ac7-4314-a030-7b07ee27b40c%40googlegroups.com.

Re: Select Specific Fields from Dataset

So why didn't that take a *Sequel.function* approach?

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/a9528c9a-f057-449f-9c21-82c736c58b95%40googlegroups.com.

Re: Select Specific Fields from Dataset

Solved:

select(:search_phrase, Sequel.cast(:creation_date, DateTime).as(:
creation_date), :search_type, :result_count).

Formatting done in the view. 


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/9aae2ccc-936f-4183-9d12-cc84f73570b2%40googlegroups.com.

Re: Select Specific Fields from Dataset

Sorry, here's my original PG syntax:

res = $c.exec_params( %Q{ SELECT search_phrase, date_trunc('minute', 
creation_date), search_type, result_count...


-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/1477f911-d1d8-49ec-a027-f35e3e951832%40googlegroups.com.

Re: Select Specific Fields from Dataset

OK, let's start fresh:

date_trunc is two pages down:  
https://www.postgresql.org/docs/9.1/functions-datetime.html


Also:  
https://www.postgresql.org/docs/9.1/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

Truncate on timestamp:

date_trunc('hour', timestamp '2001-02-16 20:38:40')

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/366aed3b-b8d9-4341-8d01-672203d948a7%40googlegroups.com.

Re: Select Specific Fields from Dataset

2020-01-07 Thread BeeRich33

In a related application: date_trunc (this rounds up)

select{[:search_phrase, Sequel.function(:date_trunc(:minute, :creation_date
)).as(:creation_date), :search_type, :result_count]}.

That field is a timestamp, which I want to round up to the minute.  I'm 
thinking it's a PostgreSQL function, so I tried to apply it as above for 
this SQL:

date_trunc('minute', creation_date)

It's not a cast...is it?  

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/5cd5e31f-4208-48a2-9463-dc262efd7f05%40googlegroups.com.

Complex Select

2020-01-07 Thread BeeRich33

Trying to avoid *fetch* (which isn't working either), I have the following 
attempt for sequel:

SELECT hashtag, (tagcount/1000) AS tagcount
FROM myhashtags 
WHERE status = 'new' 
  AND NOT hashtag = ANY (?)
ORDER BY tagcount DESC 
LIMIT ? }, 'active', avoids, 29 ]

This is what I have:

DBL[:myhashtags].
  where(:status => 'active').
  select{ :hashtag, (Sequel.function(:tagcount/1000)) }. # => trouble 
here
  reverse(:tagcount).
  limit(29)



My *avoids* is a list of tags to not include (avoid).  I can't seem to get 
the *:tagcount/1000* to work either.  I can't seem to find anything in the 
docs that shows me how to get that done.  

Any insight appreciated as to how I can get this to work.  Even .fetch 
isn't working.  

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/7efa9f85-9b37-4756-b3e1-c904c4b400ec%40googlegroups.com.

WHERE creation_date::date > (CURRENT_DATE) - interval '30 days'::date

Any chance I can get some leadership on that statement?  It's one *WHERE* 
clause I need to use.  

WHERE creation_date::date > (CURRENT_DATE) - interval '30 days'::date

*:creation_date* is a timestamp field.  It's tripping up on the *'30 days'* 
part.  I'm assuming I do not need any coercing to timestamp or datetime 
types.  

.where(:creation_date > (CURRENT_DATE - interval '30 days')

Cheers

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/a28c242d-d4d3-42a9-8d3c-a9d69719952e%40googlegroups.com.

Re: Select Specific Fields from Dataset

So that is always based on *:id*?

Both look great, but the first I need to remember the select syntax with 
curly braces and inner array.

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/970a96a7-3921-4892-84d8-c6f347545979%40googlegroups.com.

Re: Select Specific Fields from Dataset


Got it.  

puts DBS[:thistable].group_and_count(:country).where(:status => 'active').
order(Sequel.desc(:country)).sql




-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sequel-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/9cb0f5da-c287-4963-9537-e3ba3cb9390d%40googlegroups.com.

Select Specific Fields from Dataset