Aion-Query

 view release on metacpan or  search on metacpan

LICENSE  view on Meta::CPAN

for you must do so exclusively on your behalf, under your direction
and control, on terms that prohibit them from making any copies of
your copyrighted material outside their relationship with you.

  Conveying under any other circumstances is permitted solely under
the conditions stated below.  Sublicensing is not allowed; section 10
makes it unnecessary.

  3. Protecting Users' Legal Rights From Anti-Circumvention Law.

  No covered work shall be deemed part of an effective technological
measure under any applicable law fulfilling obligations under article
11 of the WIPO copyright treaty adopted on 20 December 1996, or
similar laws prohibiting or restricting circumvention of such
measures.

  When you convey a covered work, you waive any legal power to forbid
circumvention of technological measures to the extent such circumvention
is effected by exercising rights under this License with respect to
the covered work, and you disclaim any intention to limit operation or
modification of the work as a means of enforcing, against the work's
users, your or third parties' legal rights to forbid circumvention of
technological measures.

  4. Conveying Verbatim Copies.

  You may convey verbatim copies of the Program's source code as you
receive it, in any medium, provided that you conspicuously and
appropriately publish on each copy an appropriate copyright notice;
keep intact all notices stating that this License and any
non-permissive terms added in accord with section 7 apply to the code;
keep intact all notices of the absence of any warranty; and give all
recipients a copy of this License along with the Program.

i18n/Aion/Query.ru-en.po  view on Meta::CPAN

msgid "Как query, плюс преобразует результат в нужную структуру данных."
msgstr "Like query, plus converts the result into the desired data structure."

msgid "Если нужен хеш вида идентификатор – значение:"
msgstr "If you need a hash of the form identifier - value:"

msgid "Если нужен хеш вида идентификатор – строка:"
msgstr "If you need a hash of the form identifier - string:"

msgid "Если одному идентификатору соответствует несколько строк, то логично собрать их в массивы:"
msgstr "If several lines correspond to one identifier, then it is logical to collect them into arrays:"

msgid "Ну и строки со всеми полями:"
msgstr "Well, the lines with all the fields:"

msgid "## query_attach ($rows, $attach, $query, %kw)"
msgstr "## query_attach ($rows, $attach, $query, %kw)"

msgid "Подсоединяет в результат запроса результат другого запроса."
msgstr "Includes the result of another query into the result of a query."

lib/Aion/Query.pm  view on Meta::CPAN

	my %author = query_slice id => {}, "SELECT id, name FROM author";
	
	my $rows = {
	    1 => {name => "Pushkin A.S.", id => 1},
	    2 => {name => "Pushkin A.",   id => 2},
	    3 => {name => "Alice",        id => 3},
	};
	
	\%author  # --> $rows

If several lines correspond to one identifier, then it is logical to collect them into arrays:

	query "CREATE TABLE book (
		id SERIAL PRIMARY KEY,
	    author_id INT NOT NULL REFERENCES author(id),
	    title TEXT NOT NULL
	)";
	
	stores book => [
	    {author_id => 1, title => "Mir"},
	    {author_id => 1, title => "Kiss in night"},



( run in 1.290 second using v1.01-cache-2.11-cpan-0371d4a6215 )