import importlib.util, pathlib, sqlite3, tempfile, unittest
p=pathlib.Path(__file__).resolve().parents[1]/'deploy/sync/sync.py'
# Import test without requiring a real database server or installed PyMySQL.
import sys, types
sys.modules.setdefault('pymysql',types.ModuleType('pymysql'))
spec=importlib.util.spec_from_file_location('itna_sync',p)
m=importlib.util.module_from_spec(spec);spec.loader.exec_module(m)
class ProvisionerTests(unittest.TestCase):
 def test_only_sold_active(self):
  with tempfile.TemporaryDirectory() as td:
   path=str(pathlib.Path(td)/'app.sqlite')
   with sqlite3.connect(path) as db:
    db.executescript('CREATE TABLE packages(id INTEGER PRIMARY KEY,minutes INTEGER,speed TEXT,active INTEGER);CREATE TABLE vouchers(code TEXT,pin TEXT,package_id INTEGER,status TEXT);')
    db.executemany('INSERT INTO packages VALUES(?,?,?,?)',[(1,60,'2M/2M',1),(2,90,'4M/4M',0)])
    db.executemany('INSERT INTO vouchers VALUES(?,?,?,?)',[('ITNA-A','12345678',1,'sold'),('ITNA-B','12345679',1,'new'),('ITNA-C','12345670',2,'sold'),('ITNA-D','12345671',1,'disabled')])
   found=m.desired_vouchers(path)
   self.assertEqual(list(found),['ITNA-A'])
 def test_radius_attrs(self):
  check,reply=m.radius_attributes({'minutes':60,'speed':'2M/2M','pin':'12345678'})
  self.assertIn(('Max-All-Session',':=','3600'),check)
  self.assertIn(('Mikrotik-Rate-Limit',':=','2M/2M'),reply)
  with self.assertRaises(ValueError):m.radius_attributes({'minutes':60,'speed':'bad','pin':'123'})
if __name__=='__main__':unittest.main()
