Module sqlite_pycalcar :: Class SqlitePycalcar
[hide private]
[frames] | no frames]

Class SqlitePycalcar

source code

Class which allow to access to the SQLite DataBase of PYCALCAR

Class Hierarchy for SqlitePycalcar
Class Hierarchy for SqlitePycalcar

TABLE

ABOUT

Contains the different information for about windows Columns: Action, Message

CONFIG

Contains the parameters for the software Columns: Lang, Screen, Action, Message

MONEY

Contains the data of every money Columns: Name, Year, Nation, Nb_unit, Unit0, Unit1, Unit2, Unit3, Unit4, Unit5, Unit6, Unit7, unit8, Unit9, Unit1_to_0, Unit2_to_1, unit3_to_2, unit4_to_3, Unit5_to_4, Unit6_to_5, unit7_to_6, Unit8_to_7, Unit9_to_8

RATE

Contains the rate to convert form money1 to money2 Columns: Name1, Year1, Nation1, Name2, Year2, Nation2, Rate1_to_2

Instance Methods [hide private]
 
__init__(self, path) source code
 
p_ins_money(self, name, year, nation, nb_unit, u0, u1, u2, u3, u4, u5, u6, u7, u8, u9, tx0, tx1, tx2, tx3, tx4, tx5, tx6, tx7, tx8)
Creation of a new money
source code
 
p_ins_rate(self, name1, year1, nation1, name2, year2, nation2, rate)
Creation of a new rate between devise
source code
 
p_upd_money(self, old_name, old_year, old_nation, name, year, nation, nb_unit, u0, u1, u2, u3, u4, u5, u6, u7, u8, u9, tx0, tx1, tx2, tx3, tx4, tx5, tx6, tx7, tx8)
Update of a money's DATA
source code
 
p_upd_rate(self, name1, year1, nation1, name2, year2, nation2, rate)
Update of money's rate
source code
 
p_del_money(self, name, year, nation)
Delete a Money
source code
 
p_del_rate(self, name1, year1, nation1, name2='', year2='', nation2='')
Delete all rate attach to a devise which has been delete
source code
 
f_read_money_name(self)
Allow to read a money's DATA
source code
 
f_read_money_rate(self, name, year, nation)
Allow to read a money's DATA internal rate conversion
source code
 
f_read_lang(self)
Allow to read the different language available for Pycalcar
source code
 
f_config_get_language(self)
Allow to read the selected language for Pycalcar
source code
 
p_config_set_language(self, language)
Allow to set the selected language for Pycalcar
source code
 
f_read_rate(self, name1, year1, nation1, name2, year2, nation2)
Allow to read money's rate conversion
source code
 
f_read_conv_combox(self, name, year, nation)
Allow to know the available money for convertion end the rate to apply
source code
 
f_read_message(self, language)
Allow to get the different messages in the selected language
source code
 
f_read_menu_text(self, language='Francais')
Allow to extract text of IHM
source code
Method Details [hide private]

p_ins_money(self, name, year, nation, nb_unit, u0, u1, u2, u3, u4, u5, u6, u7, u8, u9, tx0, tx1, tx2, tx3, tx4, tx5, tx6, tx7, tx8)

source code 

Creation of a new money

PARAMETERS

name

Money's name

year

Money's year creation

nation

Nation of the money

nb_unit

Number of unit in the money

u0 => u9

Name of the different units of the money

tx0 => tx8

Rate between the different units of the money

RETURNS

None

p_ins_rate(self, name1, year1, nation1, name2, year2, nation2, rate)

source code 

Creation of a new rate between devise

PARAMETERS

name1

Name of the first money

year1

Year of creation of the first money

nation1

Nation of the first money

name2

Name of the second money

year2

Year of creation of the second money

nation2

Nation of the second money

rate

Rate to convert money 1 into money 2

RETURNS

None

p_upd_money(self, old_name, old_year, old_nation, name, year, nation, nb_unit, u0, u1, u2, u3, u4, u5, u6, u7, u8, u9, tx0, tx1, tx2, tx3, tx4, tx5, tx6, tx7, tx8)

source code 

Update of a money's DATA

PARAMETERS

old_name

Old name of the money

old_year

Old year of creation of the money

old_nation

Old nation of the money

name

New name for the money

year

New year of creation for the money

nation

New nation for the money

nb_unit

Number of units in the money

u0 => u9

Name of the different units of the money

tx0 => tx8

Rate between the different units of the money

RETURNS

None

p_upd_rate(self, name1, year1, nation1, name2, year2, nation2, rate)

source code 

Update of money's rate

PARAMETERS

name1

Name of the first money

year1

Year of creation of the first money

nation1

Nation of the first money

name2

Name of the second money

year2

Year of creation of the second money

nation2

Nation of the second money

rate

Rate to convert money 1 into money 2

RETURNS

None

p_del_money(self, name, year, nation)

source code 

Delete a Money

PARAMETERS

name

New name for the money

year

New year of creation for the money

nation

New nation for the money

RETURNS

None

p_del_rate(self, name1, year1, nation1, name2='', year2='', nation2='')

source code 

Delete all rate attach to a devise which has been delete

PARAMETERS

name1

Name of the first money

year1

Year of creation of the first money

nation1

Nation of the first money

name2

Name of the second money

year2

Year of creation of the second money

nation2

Nation of the second money

rate

Rate to convert money 1 into money 2

RETURNS

None

f_read_money_name(self)

source code 

Allow to read a money's DATA

PARAMETERS

None

RETURNS

A list that contains the moneys's data

name, year, nation, number of unit, unit0, unit1, unit2, unit3, unit4, unit5, unit6, unit7, unit8, unit9

f_read_money_rate(self, name, year, nation)

source code 

Allow to read a money's DATA internal rate conversion

PARAMETERS

name

New name for the money

year

New year of creation for the money

nation

New nation for the money

RETURNS

A list that contains the rate between unit of a money

unit1_to_0,unit2_to_1,unit3_to_2,unit4_to_3, unit5_to_4,unit6_to_5,unit7_to_6,unit8_to_7, unit9_to_8

f_read_lang(self)

source code 

Allow to read the different language available for Pycalcar

PARAMETERS

None

RETURNS

A list that contains the different language available

f_config_get_language(self)

source code 

Allow to read the selected language for Pycalcar

PARAMETERS

None

RETURNS

The selected language for software

p_config_set_language(self, language)

source code 

Allow to set the selected language for Pycalcar

PARAMETERS

language

The selected language by user

RETURNS

None

f_read_rate(self, name1, year1, nation1, name2, year2, nation2)

source code 

Allow to read money's rate conversion

PARAMETERS

name1

Name of the first money

year1

Year of creation of the first money

nation1

Nation of the first money

name2

Name of the second money

year2

Year of creation of the second money

nation2

Nation of the second money

rate

Rate to convert money 1 into money 2

RETURNS

A list that contains the rate for conversion between the selected moneys

f_read_conv_combox(self, name, year, nation)

source code 

Allow to know the available money for convertion end the rate to apply

PARAMETERS

name

The name of source money

year

The year of creation of the source money

nation

The nation of the source money

RETURNS

A list that contains the name, the year, the nation and the rate of available money

f_read_message(self, language)

source code 

Allow to get the different messages in the selected language

PARAMETERS

language

The language selected by user

RETURNS

A list that contains the different messages by tuples

f_read_menu_text(self, language='Francais')

source code 

Allow to extract text of IHM

PARAMETERS

language

The language selected by user

RETURNS

Different lists that contains the interface's text