import importlib.util
import json
from pathlib import Path
import tempfile
import unittest
from unittest.mock import patch
import zipfile

HERE=Path(__file__).resolve().parents[1]
spec=importlib.util.spec_from_file_location('engine',HERE/'private/engine.py')
e=importlib.util.module_from_spec(spec)
spec.loader.exec_module(e)

class EngineTests(unittest.TestCase):
    def test_01_php_commentaires_et_deux_bases(self):
        with tempfile.TemporaryDirectory() as p:
            root=Path(p);(root/'application/config').mkdir(parents=True)
            (root/'application/config/database.php').write_text('''<?php
            // $db['default'] = ['database'=>'bd_commentaire'];
            /* $db['default'] = ['database'=>'bd_docblock']; */
            # $db['default'] = ['database'=>'bd_hash'];
            $db['default'] = ['hostname'=>'localhost','username'=>'app','password'=>'secret','database'=>'bd_active'];
            $db['ancien'] = ['hostname'=>'localhost','username'=>'app','password'=>'old','database'=>'bd_relique'];
            ''')
            dbs,dynamic,source=e.scan_db(root)
            self.assertEqual([x['name'] for x in dbs],['bd_active','bd_relique'])
            self.assertFalse(dynamic)
            self.assertEqual(source,['application/config/database.php'])
            self.assertNotIn('password',e.export_candidates(dbs)[0])

    def test_02_configuration_storage_indirecte(self):
        with tempfile.TemporaryDirectory() as p:
            root=Path(p);(root/'application/config').mkdir(parents=True)
            (root/'storage/private/config').mkdir(parents=True)
            (root/'application/config/database.php').write_text('''<?php
            $kv_db = Private_config::get('database');
            $db['default'] = ['database'=>(string)($kv_db['database'] ?? '')];
            ''')
            (root/'storage/private/config/database.php').write_text('''<?php return [
            'hostname'=>'localhost','username'=>'u','password'=>'p','database'=>'bd_production'];''')
            dbs,dyn,_=e.scan_db(root)
            self.assertEqual([x['name'] for x in dbs],['bd_production'])
            self.assertTrue(dyn)

    def test_03_archive_filtre_cache_logs_et_sql(self):
        with tempfile.TemporaryDirectory() as p:
            root=Path(p)/'test.prodisplay.ma'
            (root/'application/logs').mkdir(parents=True)
            (root/'storage/private/cache').mkdir(parents=True)
            (root/'application/logs'/'ancien.log').write_text('secret')
            (root/'application/logs'/'index.html').write_text('')
            (root/'application/logs'/'.htaccess').write_text('Require all denied')
            (root/'storage/private/cache'/'session-1').write_text('session')
            (root/'index.php').write_text('<?php')
            sql=Path(p)/'sql.sql';sql.write_text('CREATE TABLE a (x int);')
            archive=Path(p)/'save.zip'
            e.make_zip(root,archive,sql,{'database':'bd','domain':'test.prodisplay.ma'})
            with zipfile.ZipFile(archive) as z:
                names=z.namelist()
                self.assertIn('test.prodisplay.ma/index.php',names)
                self.assertIn('__backup/database/bd.sql',names)
                self.assertIn('test.prodisplay.ma/application/logs/index.html',names)
                self.assertIn('test.prodisplay.ma/application/logs/.htaccess',names)
                self.assertNotIn('test.prodisplay.ma/application/logs/ancien.log',names)
                self.assertNotIn('test.prodisplay.ma/storage/private/cache/session-1',names)
            # L'étape ZIP ne modifie pas les logs sur disque.
            self.assertTrue((root/'application/logs/ancien.log').exists())

    def test_04_protection_du_site_actif(self):
        with tempfile.TemporaryDirectory() as p:
            row={'domain':'kiosk.prodisplay.ma','root':p,'type':'sub_domains'}
            with patch.object(e,'HOME',Path(p).parent),patch.object(e,'run',return_value=None),patch.object(e.shutil,'which',return_value=None):
                blockers=e.blockers_for(row,[row],[])
            self.assertTrue(any('Site actif protégé' in x for x in blockers))

    def test_05_plan_resume_et_selection_sql(self):
        with tempfile.TemporaryDirectory() as p:
            root=Path(p)/'public_html/test';root.mkdir(parents=True)
            (root/'application/config').mkdir(parents=True)
            (root/'application/config/database.php').write_text('''<?php
              $db['default']=['username'=>'u','password'=>'p','database'=>'bd_reelle'];
              $db['legacy']=['username'=>'u','password'=>'p','database'=>'bd_ancienne'];''')
            first=e.scan_db(root)[0][0]['id']
            iv={'domain':'test.prodisplay.ma','root':str(root),'type':'sub_domains',
                'size':1000,'db_candidates':e.export_candidates(e.scan_db(root)[0]),
                'dynamic_config':False,'blockers':[],'warnings':['Deux BD trouvées'],
                'recommended_archive':'test.prodisplay.ma-2026-11-16.zip'}
            for c in iv['db_candidates']:c.update(owned=True,shared_with=[])
            with patch.object(e,'HOME',Path(p)),patch.object(e,'PLANS',Path(p)/'plans'), patch.object(e,'inspect',return_value=iv),\
                 patch.object(e,'mega_accounts',return_value=[{'name':'mega1','free':100000,'quota_ok':True}]),\
                 patch.object(e,'sql_connection_ok',return_value=True),patch.object(e,'annotate') as annotate:
                pl=e.newplan({'domain':'test.prodisplay.ma','remote':'mega1','db_id':first,'action':'backup_delete'})
            self.assertEqual(pl['db_name'],'bd_reelle')
            self.assertEqual(pl['archive'],'test.prodisplay.ma-2026-11-16.zip')
            self.assertEqual(pl['action'],'backup_delete')
            annotate.assert_called_once()

    def test_06_suppression_refusee_si_base_secondaire(self):
        with tempfile.TemporaryDirectory() as p:
            root=Path(p)/'test';root.mkdir()
            (root/'application/config').mkdir(parents=True)
            (root/'application/config/database.php').write_text('''<?php
              $db['default']=['username'=>'u','password'=>'p','database'=>'bd_reelle'];
              $db['legacy']=['username'=>'u','password'=>'p','database'=>'bd_ancienne'];''')
            candidates=e.scan_db(root)[0]
            iv={'domain':'test.prodisplay.ma','root':str(root),'type':'sub_domains',
                'size':1000,'db_candidates':e.export_candidates(candidates),'dynamic_config':False,
                'blockers':[],'warnings':[],'recommended_archive':'test.prodisplay.ma-2026-11-16.zip'}
            for c in iv['db_candidates']:c.update(owned=True,shared_with=[])
            with patch.object(e,'HOME',Path(p)),patch.object(e,'inspect',return_value=iv),patch.object(e,'mega_accounts',return_value=[{'name':'mega1','free':100000,'quota_ok':True}]),patch.object(e,'annotate'):
                with self.assertRaisesRegex(RuntimeError,'Suppression bloquée'):
                    e.newplan({'domain':'test.prodisplay.ma','remote':'mega1','db_id':candidates[1]['id'],'action':'backup_delete'})

    def test_08_suppression_uniquement_apres_sha_distant_valide(self):
        with tempfile.TemporaryDirectory() as p0:
            p=Path(p0);store=p/'store';(store/'jobs'/'abc').mkdir(parents=True)
            (store/'work').mkdir();(store/'plans').mkdir()
            root=p/'public_html'/'other';root.mkdir(parents=True)
            (root/'index.html').write_text('Version à archiver')
            main=p/'public_html'/'main';main.mkdir()
            plan={'domain':'other.prodisplay.ma','root':str(root),'db_id':'',
                  'remote':'mega1','action':'backup_delete','archive':'other.prodisplay.ma-2026-11-16.zip',
                  'fingerprint':e.file_fingerprint(root)}
            e.save_json(store/'jobs'/'abc'/'plan.json',plan)
            row={'domain':plan['domain'],'root':plan['root'],'type':'sub_domains'}
            primary={'domain':'prodisplay.ma','root':str(main),'type':'main_domain'}
            state={'deleted':False,'remote_digest':None,'copied':False}
            def fake_discover():
                return [primary] if state['deleted'] else [row,primary]
            def fake_uapi(mod,fn,**kw):
                self.assertTrue(state['copied'])
                self.assertEqual((mod,fn),('SubDomain','delsubdomain'))
                self.assertEqual(kw,{'domain':'other','rootdomain':'prodisplay.ma'})
                state['deleted']=True
            def fake_run(args,**kw):
                if args[:2]==['rclone','copyto']:
                    state['remote_digest']=e.sha(Path(args[2]));state['copied']=True
                return type('P',(),{'returncode':0,'stdout':b''})()
            overview={'blockers':[],'db_candidates':[]}
            with patch.object(e,'STORE',store),patch.object(e,'WORK',store/'work'),patch.object(e,'JOBS',store/'jobs'),                patch.object(e,'HOME',p),patch.object(e,'discover',side_effect=fake_discover),                patch.object(e,'inspect',return_value=overview),                patch.object(e,'mega_accounts',return_value=[{'name':'mega1','free':1000000,'quota_ok':True}]),                patch.object(e,'run',side_effect=fake_run),                patch.object(e,'remote_digest',side_effect=lambda d:state['remote_digest']),                patch.object(e,'uapi',side_effect=fake_uapi):
                e.worker('abc')
            self.assertTrue(state['deleted'])
            self.assertFalse(root.exists())
            st=e.read_json(store/'jobs'/'abc'/'state.json')
            self.assertEqual(st['status'],'done')
            self.assertTrue((store/'jobs'/'abc'/'receipt.json').is_file())

    def test_07_aucune_suppression_si_verification_mega_echoue(self):
        with tempfile.TemporaryDirectory() as p:
            p=Path(p);store=p/'store';(store/'jobs'/'abc').mkdir(parents=True)
            (store/'work').mkdir();(store/'plans').mkdir()
            root=p/'public_html'/'other';root.mkdir(parents=True)
            (root/'index.html').write_text('Hello')
            plan={'domain':'other.prodisplay.ma','root':str(root),'db_id':'',
                  'remote':'mega1','action':'backup_delete','archive':'other.prodisplay.ma-2026-11-16.zip',
                  'fingerprint':e.file_fingerprint(root)}
            e.save_json(store/'jobs'/'abc'/'plan.json',plan)
            row={'domain':plan['domain'],'root':plan['root'],'type':'sub_domains'}
            overview={'blockers':[],'db_candidates':[]}
            with patch.object(e,'STORE',store),patch.object(e,'WORK',store/'work'),patch.object(e,'JOBS',store/'jobs'),\
                patch.object(e,'HOME',p),patch.object(e,'discover',return_value=[row]),\
                patch.object(e,'inspect',return_value=overview),\
                patch.object(e,'mega_accounts',return_value=[{'name':'mega1','free':1000000,'quota_ok':True}]),\
                patch.object(e,'run',return_value=type('P',(),{'returncode':0,'stdout':b''})()),\
                patch.object(e,'remote_digest',return_value='wrong'),patch.object(e,'uapi') as deleteapi:
                with self.assertRaisesRegex(RuntimeError,'SHA-256'):
                    e.worker('abc')
            deleteapi.assert_not_called()
            self.assertTrue(root.is_dir())
            st=e.read_json(store/'jobs'/'abc'/'state.json')
            self.assertEqual(st['status'],'error')

if __name__=='__main__':unittest.main(verbosity=2)
