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

Class SqlitePycalcar

source code

:

Class Hierarchy for SqlitePycalcar
Class Hierarchy for SqlitePycalcar

DESCRIPTION

Allow to access to the DataBase of PYCALCAR

FUNCTIONS

p_ins_money

Creation of a new money

p_ins_rate

Creation of a new rate between devise

p_upd_money

Update of a money's DATA

p_upd_rate

Update of money's rate

p_del_money

Delete a Money

p_del_rate

Delete all rate attach to a devise which has been delete

f_read_money_name

Allow to read a money's DATA

f_read_money_rate

Allow to read a money's DATA internal rate conversion

f_read_lang

Allow to read the different language available for Pycalcar

f_config_get_language

Allow to know the active language

p_config_set_language

Allow to set the selected language for Pycalcar

f_read_rate

Allow to read money's rate conversion

f_read_conv_combox

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

f_read_message

Allow to get the different messages in the selected language

f_read_menu_text

Allow to extract text of IHM

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) 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)
:
source code
 
p_ins_rate(self, name1, year1, nation1, name2, year2, nation2, rate)
:
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)
:
source code
 
p_upd_rate(self, name1, year1, nation1, name2, year2, nation2, rate)
:
source code
 
p_del_money(self, name, year, nation)
:
source code
 
p_del_rate(self, name1, year1, nation1, name2='', year2='', nation2='')
:
source code
 
f_read_money_name(self)
:
source code
 
f_read_money_rate(self, name, year, nation)
:
source code
 
f_read_lang(self)
:
source code
 
f_config_get_language(self)
:
source code
 
p_config_set_language(self, language)
:
source code
 
f_read_rate(self, name1, year1, nation1, name2, year2, nation2)
:
source code
 
f_read_conv_combox(self, name, year, nation)
:
source code
 
f_read_message(self, language)
:
source code
 
f_read_menu_text(self, language='Francais')
:
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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

Allow to read the selected language for Pycalcar

PARAMETERS

None

RETURNS

The selected language for software

p_config_set_language(self, language)

source code 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

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 

:

DESCRIPTION

Allow to extract text of IHM

PARAMETERS

language

The language selected by user

RETURNS

Different lists that contains the interface's text