[asterisk-users] sql schema without alembic

[Ryan, Travis]

From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of George Joseph
Sent: Monday, February 08, 2016 10:11 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] sql schema without alembic



On Mon, Feb 8, 2016 at 2:54 AM, Marek Červenka <cervajs at fpf.slu.cz<mailto:cervajs at fpf.slu.cz>> wrote:
Dne 4.2.2016 v 12:17 A J Stiles napsal(a):
On Thursday 04 Feb 2016, Marek Červenka wrote:
hi,

is there way to get SQL schema for Asterisk 13.7.0 without alembic?
thanks
Assuming you already have Asterisk up and running, you can just use

$ mysqldump -d -uroot DATABASE TABLE1 TABLE2 TABLE3 ...

will print  (on STDOUT, so you can just use > to write it to a new file, >> to
join onot an existing file or | to pass it through a program)  the SQL
statements required to recreate the given tables in the given database.  (If
you don't specify any tables, it will assume you mean all of them.)

The -d means "don't dump any data", so it will dump just the CREATE statements
and not the INSERT statements that would actually populate the database.

i have asterisk 13.3.0 running on box where i cannot install alembic
i need upgrade to latest asterisk.
for me is the best way apply only "alter table ..." commands for upgrade 13.3.0->13.7.2

​If you can run alembic on a different box, you can run it in offline mode with the --sql option to generate an upgrade script.

https://alembic.readthedocs.org/en/latest/offline.html


[Ryan, Travis] I’m also very interested. I have tables that are already named the same as alembic uses, so it causes me issues on upgrades.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160208/f424b0bc/attachment.html>