# Easy way to create fixtures that use betternestedset?

**URL:** <https://www.ruby-forum.com/t/easy-way-to-create-fixtures-that-use-betternestedset/135375>\
**Category:** Rails\
**Created:** [April 21, 2008, 5:34pm UTC](https://www.ruby-forum.com/t/easy-way-to-create-fixtures-that-use-betternestedset/135375 "2008-04-21T17:34:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![apswartz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/71e660/32.png) [@apswartz](https://www.ruby-forum.com/u/apswartz)\
**Post date:** [April 21, 2008, 5:34pm UTC](https://www.ruby-forum.com/t/easy-way-to-create-fixtures-that-use-betternestedset/135375/1 "2008-04-21T17:34:35Z")

</div>

Other than calculating by hand the :lft and :rgt for my fixtures for  
classes that use betternestedset, is there an easier (automagic) way?

Thanks in advance,

Alan

---

<div class="post-metadata">

**Author:** ![apswartz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/71e660/32.png) [@apswartz](https://www.ruby-forum.com/u/apswartz)\
**Post date:** [April 21, 2008, 6:36pm UTC](https://www.ruby-forum.com/t/easy-way-to-create-fixtures-that-use-betternestedset/135375/2 "2008-04-21T18:36:27Z")

</div>

[http://nubyonrails.com/articles/2005/12/27/dump-or-slurp-yaml-reference-data](http://nubyonrails.com/articles/2005/12/27/dump-or-slurp-yaml-reference-data)  
[http://snippets.dzone.com/tag/fixtures](http://snippets.dzone.com/tag/fixtures)

Create your DB records in irb or some other ruby script file outside  
of rails in a temporary DB (or just use your existing DB), then use  
that to export the YAML from the live data.

---

<div class="post-metadata">

**Author:** ![apswartz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/71e660/32.png) [@apswartz](https://www.ruby-forum.com/u/apswartz)\
**Post date:** [April 21, 2008, 8:56pm UTC](https://www.ruby-forum.com/t/easy-way-to-create-fixtures-that-use-betternestedset/135375/3 "2008-04-21T20:56:16Z")

</div>

Thanks!!