Derg: Created page with " cur = 'beginning' fi = open(cur + '.sql', 'wb') starts = b'CREATE DATABASE /!32312 IF NOT EXISTS/ `' ends = b'` /!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci /;' with open('beforereinstallalldbs.sql', 'rb') as f: for l in f: l = l.strip() if l.startswith(starts) and l.endswith(ends): cur = l[len(starts):-len(ends)].decode('utf-8') print(cur) fi.close() fi = open(cur + '.sql', 'wb')..."

2024-09-17T06:26:07Z

Created page with " <syntaxhighlight lang="python"> cur = 'beginning' fi = open(cur + '.sql', 'wb') starts = b'CREATE DATABASE !32312 IF NOT EXISTS: `' ends = b'` !40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: ;' with open('beforereinstallalldbs.sql', 'rb') as f: for l in f: l = l.strip() if l.startswith(starts) and l.endswith(ends): cur = l[len(starts):-len(ends)].decode('utf-8') print(cur) fi.close() fi = open(cur + '.sql', 'wb')..."

New page

<syntaxhighlight lang="python">
cur = 'beginning'
fi = open(cur + '.sql', 'wb')
starts = b'CREATE DATABASE /*!32312 IF NOT EXISTS*/ `'
ends = b'` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;'

with open('beforereinstallalldbs.sql', 'rb') as f:
for l in f:
l = l.strip()
if l.startswith(starts) and l.endswith(ends):
cur = l[len(starts):-len(ends)].decode('utf-8')
print(cur)
fi.close()
fi = open(cur + '.sql', 'wb')
with open('beginning.sql', 'rb') as fb:
fi.write(fb.read())
fi.write(b'\n')
fi.write(l + b'\n')
</syntaxhighlight>

splitsql.py - Revision history