Contents

Basics:
-------

Underneath everything is the Ruby Sequel library; there are a number
of ways to access it.



fixie:0 > o.groups.by_name(cl.id).inner.count
1
fixie:0 > o.groups.by_name(cl.id).inner.delete
1
fixie:0 > o.groups.by_name(cl.id).inner.count     


* Changing email for user in fixie

USERS.by_username('anujbiyani').inner.update(:email=>"[e-mail]")



* Adding a record
```ruby
u=USERS['a_username']
o=ORGS['an_org']

pivotal = USERS['pivotal']

ASSOCS.inner.insert(:org_id=>o.id, :user_id=>u.id, :last_updated_by=>pivotal.authz_id,
	:created_at=>:NOW.sql_function, :updated_at=>:NOW.sql_function) )
```

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
chef_fixie-0.3.0	doc/AccessingSQL.md~
chef_fixie-0.2.1	doc/AccessingSQL.md~
chef_fixie-0.2.0	doc/AccessingSQL.md~
chef_fixie-0.1.0	doc/AccessingSQL.md~