Styjun

What is the difference between Major and Minor Bug?

Showing that the limit of non-eigenvector goes to infinity

What is the difference between "Grippe" and "Männergrippe"?

Is there any way to keep a player from killing an NPC?

Tex Quotes(UVa 272)

Round towards zero

Lost property on Portuguese trains

Why is 7 Bd3 in the Cambridge Springs QGD more often met with 7...Ne4 than 7...dxc4?

Is there any way white can win?

Architectural feasibility of a tiered circular stone keep

Did anyone try to find the little box that held Professor Moriarty and his wife after the crash?

Compelling story with the world as a villain

Transposing from C to Cm?

How do we calculate energy of food?

Is the position of vector in space immaterial?

Do they have Supervillain(s)?

'Us students' - Does this apposition need a comma?

How to find volume from Washer method?

Why do banks “park” their money at the European Central Bank?

"Sorry to bother you" in an email?

What is this symbol: semicircles facing each other?

How do I, an introvert, communicate to my friend and only colleague, an extrovert, that I want to spend my scheduled breaks without them?

Is “I am getting married with my sister” ambiguous?

If all stars rotate, why was there a theory developed that requires non-rotating stars?

Change a VARCHAR field via migration in Vapor Fluent-MySQL

Setting up Vapor and Vapor-MySQLDeleting a Vapor Fluent Pivotstring primary key with vapor + fluentVapor 2, Fluent model subclassQuery child in Fluent+VaporMySQL & Vapor 3: unrecognized basic packet, full auth not supportedUsing vapor-fluent to upsert modelsVapor 3 Fluent MySQL: save on model adds 10 to auto_incrementvapor 3 fluent-mysql join query

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I'm using Vapor 3 and FluentMySQL for my new project and want to change maximum length of a field (varchar(N)) via migration. How can I do this?

I have a Model named Word in my project and one of its fields is sourceIdentifier that is String and have maximum length of 12. The model is something like this:

final class Word: MySQLModel 
 ...other properties

 var sourceIdentifier: String

 ...other properties

At the beginning, I thought 5 is enough for the field and used this code to create Table for this model:

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.create(Word.self, on: conn) builder in
 ...other fields...

 builder.field(for: .sourceIdentifier, type: .varchar(5, characterSet: nil, collate: nil))

 ...other fields...
 

As you see above, the table created with field sourceIdentifier and its type is .varchar(5, characterSet: nil, collate: nil).

Now I want to increase maximum length of the field via migration.

I also tried MySQLDatabase.update like this:

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.update(Word.self, on: conn) builder in
 builder.field(for: .sourceIdentifier, type: .varchar(12, characterSet: nil, collate: nil))
 

and it didn't work; Nothing happened.

How can I change structure of the table via Vapor, FluentMySQL and migrations?

swift vapor vapor-fluent fluent-mysql

share|improve this question

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

add a comment | 

1

I'm using Vapor 3 and FluentMySQL for my new project and want to change maximum length of a field (varchar(N)) via migration. How can I do this?

I have a Model named Word in my project and one of its fields is sourceIdentifier that is String and have maximum length of 12. The model is something like this:

final class Word: MySQLModel 
 ...other properties

 var sourceIdentifier: String

 ...other properties

At the beginning, I thought 5 is enough for the field and used this code to create Table for this model:

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.create(Word.self, on: conn) builder in
 ...other fields...

 builder.field(for: .sourceIdentifier, type: .varchar(5, characterSet: nil, collate: nil))

 ...other fields...
 

As you see above, the table created with field sourceIdentifier and its type is .varchar(5, characterSet: nil, collate: nil).

Now I want to increase maximum length of the field via migration.

I also tried MySQLDatabase.update like this:

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.update(Word.self, on: conn) builder in
 builder.field(for: .sourceIdentifier, type: .varchar(12, characterSet: nil, collate: nil))
 

and it didn't work; Nothing happened.

How can I change structure of the table via Vapor, FluentMySQL and migrations?

swift vapor vapor-fluent fluent-mysql

share|improve this question

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

add a comment | 

I'm using Vapor 3 and FluentMySQL for my new project and want to change maximum length of a field (varchar(N)) via migration. How can I do this?

I have a Model named Word in my project and one of its fields is sourceIdentifier that is String and have maximum length of 12. The model is something like this:

final class Word: MySQLModel 
 ...other properties

 var sourceIdentifier: String

 ...other properties

At the beginning, I thought 5 is enough for the field and used this code to create Table for this model:

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.create(Word.self, on: conn) builder in
 ...other fields...

 builder.field(for: .sourceIdentifier, type: .varchar(5, characterSet: nil, collate: nil))

 ...other fields...
 

As you see above, the table created with field sourceIdentifier and its type is .varchar(5, characterSet: nil, collate: nil).

Now I want to increase maximum length of the field via migration.

I also tried MySQLDatabase.update like this:

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.update(Word.self, on: conn) builder in
 builder.field(for: .sourceIdentifier, type: .varchar(12, characterSet: nil, collate: nil))
 

and it didn't work; Nothing happened.

How can I change structure of the table via Vapor, FluentMySQL and migrations?

swift vapor vapor-fluent fluent-mysql

share|improve this question

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

final class Word: MySQLModel 
 ...other properties

 var sourceIdentifier: String

 ...other properties

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.create(Word.self, on: conn) builder in
 ...other fields...

 builder.field(for: .sourceIdentifier, type: .varchar(5, characterSet: nil, collate: nil))

 ...other fields...
 

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return MySQLDatabase.update(Word.self, on: conn) builder in
 builder.field(for: .sourceIdentifier, type: .varchar(12, characterSet: nil, collate: nil))
 

share|improve this question

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

share|improve this question

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

asked Mar 27 at 17:53

Omid GolparvarOmid Golparvar

9133 silver badges66 bronze badges

1 Answer
1

active

oldest

votes

1

You could do anything with raw query like this

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return conn.raw("ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);").run()

share|improve this answer

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55383680%2fchange-a-varchar-field-via-migration-in-vapor-fluent-mysql%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

You could do anything with raw query like this

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return conn.raw("ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);").run()

share|improve this answer

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges

add a comment | 

1

You could do anything with raw query like this

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return conn.raw("ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);").run()

share|improve this answer

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges

add a comment | 

You could do anything with raw query like this

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return conn.raw("ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);").run()

share|improve this answer

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges

static func prepare(on conn: MySQLConnection) -> Future<Void> 
 return conn.raw("ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);").run()

share|improve this answer

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges

answered Mar 27 at 18:14

imikeimike

2,58711 gold badge2323 silver badges2929 bronze badges