Changeset 68049 in spip-zone for _plugins_/sqlip_export/trunk/sqlite-mysql.html
- Timestamp:
- Dec 1, 2012, 12:18:26 PM (8 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
_plugins_/sqlip_export/trunk/sqlite-mysql.html
r68014 r68049 1 [(#AUTORISER{webmestre}|sinon_interdire_acces)]#CACHE{0} #HTTP_HEADER{Content-Type:text/plain; charset=#CHARSET} #HTTP_HEADER{Content-Disposition: attachment; filename="mysql-dump.sql"} 1 [(#AUTORISER{webmestre}|sinon_interdire_acces)] 2 #CACHE{0} #HTTP_HEADER{Content-Type:text/plain; charset=#CHARSET} 3 #HTTP_HEADER{Content-Disposition: attachment; filename="mysql-dump.sql"} 2 4 [(#REM) lister les tables et description sqlite] 3 5 [(#REM) array type=>table name=>nom table tbl_name=>nom_table rootpage=>2 sql=>CREATE TABLE name (...,PRIMARY KEY(key))] … … 8 10 [(#REM) liste des champs - RECUPERER AUTO INCREMENT !!! - on stocke aussi pour les insert] #SET{champs,#ARRAY} 9 11 <B_table_desc><BOUCLE_table_desc(DATA){source sql,#GET{req_table}}{", "}> 10 `#VALEUR{name}` [ (#VALEUR{type}|=={"TIMESTAMP"}|?{"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP",#VALEUR{type}|strtolower}) ] [ (#VALEUR{notnull}|=={1}|?{"NOT NULL",""}) ] [ default (#VALEUR{dflt_value}|=={"''"}|?{"",#VALEUR{dflt_value}})]12 `#VALEUR{name}` [ (#VALEUR{type}|=={"TIMESTAMP"}|?{"timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP",#VALEUR{type}|strtolower}) ] [ (#VALEUR{notnull}|=={1}|?{"NOT NULL",""}) ][(#VALEUR{type}|=={"INTEGER"}|et{#VALEUR{name}|=={#GET{cle_primaire}}}|oui) AUTO_INCREMENT ] [ default (#VALEUR{dflt_value}|=={"''"}|?{"",#VALEUR{dflt_value}})] 11 13 [(#REM) et on stocke la liste des champs pour plus tard] #SET{champs,#GET{champs}|push{#VALEUR{name}}} 12 14 </BOUCLE_table_desc> 13 [(#REM) ensuite la clé primaire ][, (#GET{cle_primaire})]15 [(#REM) ensuite la clé primaire ][,PRIMARY KEY ((#GET{cle_primaire}))] 14 16 [(#REM) on cherche la liste des autres clés]#SET{req_keys,PRAGMA index_list( #GET{table} )} 15 17 <B_keys_liste>, … … 21 23 [(#REM) insérons-maintenant les valeurs]#SET{req_donnees,SELECT * FROM #GET{table}} 22 24 <B_lignes>INSERT INTO `#GET{table}` (<BOUCLE_champs(DATA){source tableau,#GET{champs}}{", "}>`#VALEUR`</BOUCLE_champs>) VALUES <BOUCLE_lignes(DATA){source sql,#GET{req_donnees}}{", "}><B_donnees>(<BOUCLE_donnees(DATA){source table,#VALEUR}{", "}>[(#VALEUR|?{['(#VALEUR|mysql_prep)'],"''"})]</BOUCLE_donnees>)</B_donnees></BOUCLE_lignes>;</B_lignes></BOUCLE_tables> 25 INSERT INTO `spip_meta` (`nom`, `valeur`, `impt`, `maj`) VALUES ('charset_collation_sql_base', 'utf8_general_ci', 'non', ''),('charset_sql_base', 'utf8', 'non', ''),('charset_sql_connexion', 'utf8', 'non', ''); 26
Note: See TracChangeset
for help on using the changeset viewer.