load sql file into database

xuanbao · · 667 次点击    
这是一个分享于 的资源,其中的信息可能已经有所发展或是发生改变。
<p>hi, </p> <p>Im playing around with MySQL and testing .</p> <p>i wounder if thire is a way to load the entire sql file ?</p> <p>The closest that i got is to use (LoadData)[<a href="https://github.com/go-sql-driver/mysql/blob/master/infile.go" rel="nofollow">https://github.com/go-sql-driver/mysql/blob/master/infile.go</a>] In order to insert into the datbase.</p> <hr/>**评论:**<br/><br/>mvpmvh: <pre><p>Like this? <a href="https://github.com/smotes/purse" rel="nofollow">https://github.com/smotes/purse</a></p></pre>nathj07: <pre><p>Do you mean for creating a test db or for inserting test data? In that case what we do is use a SQL file to define the schema and os.Exec to run the db command line tools. Them each test can insert the golden data it needs.</p> <p>In between tests we can them either drop the db or truncate it. </p> <p>The purse library looks clever but I fear keeping queries elsewhere will lead to cognitive overhead during dev, review and maintenance.</p></pre>

入群交流(和以上内容无关):加入Go大咖交流群,或添加微信:liuxiaoyan-s 备注:入群;或加QQ群:692541889

667 次点击  
加入收藏 微博
暂无回复
添加一条新回复 (您需要 登录 后才能回复 没有账号 ?)
  • 请尽量让自己的回复能够对别人有帮助
  • 支持 Markdown 格式, **粗体**、~~删除线~~、`单行代码`
  • 支持 @ 本站用户;支持表情(输入 : 提示),见 Emoji cheat sheet
  • 图片支持拖拽、截图粘贴等方式上传