Coverage for config/database.py: 89%
9 statements
« prev ^ index » next coverage.py v7.6.1, created at 2024-11-30 23:17 +0000
« prev ^ index » next coverage.py v7.6.1, created at 2024-11-30 23:17 +0000
1import pyodbc
3class Database:
4 @staticmethod
5 def get_connection():
6 connection_string = (
7 "DRIVER={ODBC Driver 17 for SQL Server};"
8 "SERVER=.;"
9 "DATABASE=CasaDeCambioDBTest;"
10 "UID=sa;"
11 "PWD=sa"
12 )
13 return pyodbc.connect(connection_string)
15 @staticmethod
16 def conversion_rates():
17 return {
18 'USD': {
19 'EUR': 0.92,
20 'PEN': 3.70
21 },
22 'EUR': {
23 'USD': 1.09,
24 'PEN': 4.02
25 },
26 'PEN': {
27 'USD': 0.27,
28 'EUR': 0.25
29 }
30 }