Teng tips
•Download as KEY, PDF•
1 like•1,553 views
Teng is an O/R mapper that provides methods like bulk_insert and fast_insert for efficiently inserting multiple rows into a database table. It also has features like lookup to retrieve a row by primary key, suppress_row_objects for improved performance by not creating row objects, and sql_comment to add comments to generated SQL for debugging. Teng aims to improve performance of database operations in Perl applications.
![$teng->bulk_insert(
table => [
+{ foo => 1, bar => 2 },
+{ foo => 3, bar => 4 },
],
);](https://image.slidesharecdn.com/tengtips-121023002336-phpapp01/75/Teng-tips-8-2048.jpg)
![my $row = $teng->single(
table => +{
foo => 1,
},
+{
column => [qw/foo/],
}
);](https://image.slidesharecdn.com/tengtips-121023002336-phpapp01/75/Teng-tips-17-2048.jpg)
Teng tips
- 1. Teng tips Chiba.pm #1 id:karupanerura Mobile Factory, Inc.
- 2. Profile • twitter: @karupanerura • software developer • C/C++/JavaScript/Perl • CPAN Author
- 4. O/R Mapper
- 6. tips
- 8. $teng->bulk_insert( table => [ +{ foo => 1, bar => 2 }, +{ foo => 3, bar => 4 }, ], );
- 10. my $id = $teng->fast_insert( table => +{ foo => 1, bar => 2, }, );
- 12. my $row = $teng->lookup( table => +{ foo => 1, }, ); # SQL: SELECT foo, bar FROM table WHERE foo = 1;
- 14. Don’t row objet creation
- 17. my $row = $teng->single( table => +{ foo => 1, }, +{ column => [qw/foo/], } );
- 20. $ENV{TENG_SQL_COMMENT} Teng#sql_comment
- 21. /* hoge.pl line at 3 */ SELECT foo, bar FROM table
- 22. DevOps :)
- 23. Teng#sql_builder + Teng#do
Editor's Notes
- \n
- (さらっと流す)\n\n佐藤健太と申します。\n仕事ではソフトウェア開発をやっていて、\nCとC++とJavaScriptとPerlを使うのが得意です。\nオープンソースの開発もやっていて、CPANというPerlのモジュールを公開するプラットフォームでいくつかのライブラリをモジュール化して公開しています。\n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n
- \n