# Logfile created on 2012-08-08 09:54:04 +0300 by logger.rb/31641
[2012-08-08 09:54:04]  INFO: Passed queries:
[2012-08-08 09:54:04]  INFO: ----------------------------------------------------------------------
[2012-08-08 09:54:04]  INFO: INSERT INTO sources (source) VALUES (?);
[2012-08-08 09:54:04]  INFO: ----------------------------------------------------------------------
08_sources.log lines 1-5/5 (END)

# Logfile created on 2012-08-06 00:28:57 +0300 by logger.rb/31641
[2012-08-06 00:28:57]  INFO: Passed queries:
[2012-08-06 00:28:57]  INFO: ----------------------------------------------------------------------
[2012-08-06 00:28:57]  INFO: INSERT INTO sources (source) VALUES (?);
[2012-08-06 00:28:57]  INFO: ----------------------------------------------------------------------
[2012-08-06 00:28:59]  INFO: =================================== SUMMARY ===================================
[2012-08-06 00:28:59]  INFO: Time elapsed: 2.009950587 seconds
[2012-08-06 00:28:59]  INFO: Total amount of jobs for processing: 29
[2012-08-06 00:28:59]  INFO: Successful inserts: 29
[2012-08-06 00:28:59]  INFO: Faileddddd inserts: 0

vv@crusader ~/work/own/python/portage3/bin/db_population $ rm /dev/shm/test-20120724-221542/35_ebuild_descriptions_p3.log && ./35_ebuild_descriptions_p3.rb && cat /dev/shm/test-20120724-221542/35_ebuild_descriptions_p3.log
15837
25013
5832
# Logfile created on 2012-07-25 13:01:31 +0300 by logger.rb/31641
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3133, 14891]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3134, 17036]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3134, 17037]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3135, 10195]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3135, 10198]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3135, 10203]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3136, 3514]
[2012-07-25 13:01:36 +0300] ERROR: Message: cannot use a closed statement
[2012-07-25 13:01:36 +0300] ERROR: Values: [3137, 14993]
[2012-07-25 13:01:36 +0300] ERROR: Some ebuilds(25013 items) miss its description
vv@crusader ~/work/own/python/portage3/bin/db_population $

/home/vv/work/own/python/portage3/lib/common/script.rb:110:in `join': deadlock detected (fatal)
	from /home/vv/work/own/python/portage3/lib/common/script.rb:110:in `block in run_workers'
	from /home/vv/work/own/python/portage3/lib/common/script.rb:110:in `each'
	from /home/vv/work/own/python/portage3/lib/common/script.rb:110:in `run_workers'
	from /home/vv/work/own/python/portage3/lib/common/script.rb:52:in `fill_table_X'
	from /home/vv/work/own/python/portage3/lib/common/script.rb:39:in `initialize'
	from ././db_population/14_packages.rb:21:in `new'
	from ././db_population/14_packages.rb:21:in `<main>'

sqlite> create table flags (
   ...>     id INTEGER,
   ...>     name VARCHAR NOT NULL,
   ...>     descr VARCHAR DEFAULT NULL,
   ...>     type_id INTEGER NOT NULL,
   ...>     live INTEGER NOT NULL DEFAULT 1,
   ...>     package_id INTEGER DEFAULT NULL,
   ...>     FOREIGN KEY (type_id) REFERENCES flag_types(id),
   ...>     FOREIGN KEY (package_id) REFERENCES packages(id),
   ...>     CONSTRAINT idx1_unq UNIQUE (name, descr, package_id),
   ...>     PRIMARY KEY (id)
   ...> );
sqlite> 
sqlite> select * from flags where name='x86' limit 2;
7647|x86||1|0|
7648|x86||1|0|
sqlite> select package_id from flags where name='x86' limit 2;


sqlite> select count(id) from flags where descr is NULL and name='x86' and package_id is NUll;
598
sqlite> 

crusader pkg # ls -1 */*/* | sed 's:.*/::' | grep -v ebuild | sort -u
BINPKGMD5        -     [got answer] http://bit.ly/OWQSbJ
BUILD_TIME       -     время окончания сборки
CATEGORY         -     CATEGORY
CBUILD           -     CBUILD
CC               -     c compiler
CFLAGS           -     CFLAGS
CHOST            -     CHOST
CONTENTS         -     содержимое установленного приложения
COUNTER          -     [got answer] http://bit.ly/PyKoue
CTARGET          -     CTARGET
CXX              -     CXX
CXXFLAGS         -     CXXFLAGS
DEBUGBUILD       - ???
DEFINED_PHASES   -     все фазы сборки для установленного приложения
DEPEND           - ??? все зависимости
DESCRIPTION      -     descr
EAPI             -     eapi
environment.bz2  -     архив всех переменных на момент сборки
FEATURES         - ??? все features
HOMEPAGE         -     список homepages
INHERITED        -     все eclasses установленного приложения
IUSE             - ??? какой то набор флагов
KEYWORDS         -     все кейворды установленного приложения
LDFLAGS          -     LDFLAGS сборки
LICENSE          -     все лицензии установленного приложения
NEEDED           - ??? какой то список so файлов
NEEDED.ELF.2     - ??? какой то список so файлов
PDEPEND          -     Post-Merge Dependencies
PF               -     Full package name
PKGUSE           - ??? какой то набор флагов
RDEPEND          -     runtime depends
repository       -     репозиторий к которому пренадлежит установленное приложение
REQUIRED_USE     - ??? какой то набор флагов
RESTRICT         -     запрещенные features
SIZE             -     размер собранного приложения
SLOT             -     слот установленного приложения
USE              - ??? какой то набор флагов

crusader portage # pwd
/usr/lib/portage/pym/portage
crusader portage # eix -c ^portage$
[I] sys-apps/portage (2.2.0_alpha118@07/27/2012): Portage is the package management and distribution system for Gentoo
crusader portage # grep 'been called' versions.py
	print '`vercmp` has been called'
crusader portage # emerge -1 sys-apps/portage | grep -c 'been called'
689
crusader portage # 

require 'thread'
class Pool
    def initialize(size)
        @size = size
        @jobs = Queue.new

        @pool = Array.new(@size) do |i|
            print "in array loop\n"
            Thread.new do
                print "in thread block\n"
                Thread.current[:id] = i

                catch(:exit) do
                    loop do
                        job, args = @jobs.pop
                        job.call(*args)
                    end
                end
            end
        end
    end

    def schedule(*args, &block)
        @jobs << [block, args]
    end

    def shutdown
        @size.times do
            schedule { throw :exit }
        end

        @pool.map(&:join)
    end
end

p = Pool.new(2)

20.times do |i|
    p.schedule do
        sleep rand(4) + 2
        puts "Job #{i} finished by thread #{Thread.current[:id]}"
    end
end

at_exit { p.shutdown }

#!/usr/bin/env ruby
require 'thread'
2.times do |i|
    print "in array loop\n"
    Thread.new do
        print "in thread block\n"
        #Thread.abort_on_exception = true
        #Thread.current['id'] = i
        #Thread.current['count'] = 0

        while true do
            print 'thread:'+i.to_s
        end
    end
end

def wait(mutex)
  begin
    mutex.exclusive_unlock do
      @waiters.push(Thread.current)
      Thread.stop
    end
  ensure
    mutex.lock
  end
end

def wait(mutex, timeout=nil)
  begin
    # TODO: mutex should not be used
    @waiters_mutex.synchronize do
      @waiters.push(Thread.current)
    end
    mutex.sleep timeout
  ensure
    @waiters_mutex.synchronize do
      @waiters.delete(Thread.current)
    end
  end
  self
end

#!/usr/bin/env ruby
# encoding: UTF-8
#
# Here should go some comment
#
require 'rubygems'
require 'sqlite3'

database = SQLite3::Database.new('/dev/shm/test-20120625-124831.sqlite')
database.transaction()

a = ['some', 'some', 'extra']
query = 'insert into architectures (architecture) values (?)'

a.each { |arch|
    begin
        statement = database.prepare(query)
        statement.bind_params(arch)
        statement.execute() 
    rescue SQLite3::Exception => exception
        puts "Database error happened"
        puts "Message: #{exception.message()}"
        puts "Sql query: #{query}"
        puts "Value: #{arch}"
    end
    #p statement.methods.sort
    #statement.close
}

database.commit()
database.close()

vv@vv-Latitude-E5520 /tmp $ ruby statement_test.rb 
Database error happened
Message: column architecture is not unique
Sql query: insert into architectures (architecture) values (?)
Value: some
statement_test.rb:34:in `close': unable to close due to unfinalised statements (SQLite3::BusyException)
	from statement_test.rb:34
vv@vv-Latitude-E5520 /tmp $ 

select
	* 
from
	tmp_app_guids2modules bt
group by 
	bt.app_guid,
	bt.app_platform,
	bt.app_version,
	bt.module_guid;

+------------------+-----------+------+-----+---------+-------+
| Field            | Type      | Null | Key | Default | Extra |
+------------------+-----------+------+-----+---------+-------+
| app_guid         | char(36)  | YES  | MUL | NULL    |       |
| app_platform     | char(16)  | YES  |     | NULL    |       |
| app_version      | char(16)  | YES  |     | NULL    |       |
| app_name         | char(128) | YES  |     | NULL    |       |
| app_id_string    | char(128) | YES  |     | NULL    |       |
| module_guid      | char(36)  | YES  |     | NULL    |       |
| module_name      | char(128) | YES  |     | NULL    |       |
| module_id_string | char(128) | YES  |     | NULL    |       |
+------------------+-----------+------+-----+---------+-------+

class A
  def initialize()
    p 'in A#init:' + self.class.name
  end
end
class B < A
  def initialize()
    p 'in B#init:' + self.class.name
    super
  end
end